ICT Key Stage 4 Cambridge National in ICT

In year 10 and 11, students will complete 4 units necessary to achieve the OCR Level 1/2 Cambridge National Certificate in ICT. Final outcome could range from Pass at level 1 to Distinction at level 2, based on the total marks achieved across the full 4 units.

Unit R001: Understanding computer systems

This unit will provide learners with the underpinning knowledge and understanding required to use computer systems effectively. Learners will develop their knowledge and understanding of the systems they use both at home and at school and will explore how these same technologies are used by business organisations.

This unit complements unit R002. In unit R001 learners will study the computer system on which applications software sits and consider the implications of working with data to create content, while in unit R002 they will work with ‘office’ applications software to edit and format/create content to meet specified business purposes.

From personal computers to smartphones, computing devices are an essential feature of the modern world. Technology may be changing every day, but the knowledge and understanding of how to use computers effectively is the same regardless of the technology being used. Computers are powerful devices for the storage and manipulation of data, but how can they be used effectively and the important data they use be stored securely?

On completion of this unit, learners will have gained the knowledge and understanding to use computers more effectively in a variety of different contexts including home, school and the workplace. Their regard for their own personal data security and for the security of the data of others will be increased and, overall, learners will be more informed users of computers making them more effective participators in business and social life.

Unit R002: Using ICT to create business solutions

This unit will enable learners to develop ICT skills that will equip them to operate effectively in a business environment. This unit complements unit R001. In unit R001 learners will study the computer system on which applications software sits and consider the implications of working with data to create content, while in this unit they will work with ‘office’ applications software to edit and format/create content to meet specified business purposes.

Learners will use a wide range of applications that are commonly used in the workplace, schools, and in further and higher education. They will learn how to select the most appropriate software to complete tasks to meet specified business requirements in a variety of contexts.

They will learn how to use software tools to handle data and communicate information for a range of business purposes, and how to apply formatting to enhance those documents to suit their purpose and intended audience. This type of skill is very valuable as it can be transferred from one software application to another. So if the learner is able to secure these skills through this unit they will be prepared to use a range of software applications effectively. They will learn to work with a variety of file types and to integrate/import files of different types into other documents. They will develop techniques to search for, select and store information in a variety of contexts. They will learn how to select the tools and techniques to communicate information and solve problems.

On completion of this unit learners will have extended their capability in the use of applications software.

Unit R003: Handling data using spreadsheets

This unit builds on Units R001 and R002 and learners will be able to apply the skills, knowledge and understanding developed in those units and vice versa. This unit will help the learner to process and present data into meaningful information that can be used to support the decision-making process in real life scenarios. The learning is important because spreadsheets are used extensively in businesses for a variety of purposes such as budgeting, cost modelling, reporting, trend analysis and forecasting. Spreadsheets are very effective at performing automatic calculations e.g. for displaying information to highlight relationships, for predicting outcomes by changing data, for numerical analyses and to create informative graphs and charts. In a school environment teachers use spreadsheets to monitor and analyse learners’ performance.

Learners will create a spreadsheet to provide a solution to a given scenario which will provide the facility for the user to create and manipulate data and to produce graphs and/or charts to support decision making. On completion of this unit learners will be able to interpret requirements for a spreadsheet, take unstructured data, plan how to use it in a spreadsheet, create and populate a spreadsheet, use relevant functions and tools to manipulate the data and produce outputs to present the data graphically to support decision making.

Unit R007: Creating dynamic products using sound and vision

This unit builds on Units R001 and R002 and learners will be able to apply the skills, knowledge and understanding developed in those units and vice versa.

21st century technology such as gaming technologies, mobile phone apps, media marketing technologies and web-based technologies make great use of dynamic specialist technologies to differentiate their products for the end user. This unit will enable learners to develop the knowledge, understanding and skills that would be expected in creative media industries such as advertising, music and online marketing. Learners will have the opportunity to learn about dynamic products such as music recordings and/or mixes; video/media news clips and animation for webpages before going on to create their own dynamic product.

Movies, animations and sounds bring messages and communications to life. The ability to create, edit and enhance these types of media is an essential business and personal skill that can be used for many purposes. On completion of this unit learners will be able to prepare, create, export and evaluate a timeline-based dynamic product.