AS IT Year 12


Cambridge International AS and A Levels are international in outlook, but retain a local relevance. The syllabuses provide opportunities for contextualised learning and the content has been created to suit a wide variety of schools, avoid cultural bias and develop essential lifelong skills, including creative thinking and problem-solving.

Our aim is to balance knowledge, understanding and skills in our qualifications to enable students to become effective learners and to provide a solid foundation for their continuing educational journey. Cambridge International AS and A Levels give learners building blocks for an individualised curriculum that develops their knowledge, understanding and skills.

Parents are encouraged to support their child’s learning by taking an active interest in the subject and checking homework, test and project schedules. If possible, provide facilities to do the practical work at home to achieve maximum exposure to the software applications. Requirements are: a computer or laptop with Office 2013 version installed. A printer is also useful.

Any issues please contact: Mr. Benjamin Jones - Benjamin.jones


Term 1 Theory

Unit 1. Data, information, knowledge and processing

1.1 Data, information and knowledge

1.2 Sources of data

1.3 Quality of information

1.4 Coding, encoding and encrypting data

1.5 Checking the accuracy of data

Unit 2. Hardware and software

2.1 Hardware

2.2 System, application and user interface software

2.3 Utility software

2.4 Custom written software and off-the-shelf software

2.5 Compiler and interpreter

Unit 3. Monitoring and Control

3.1 Identify sensors

3.2 Evaluate the use of monitoring technologies in everyday life

3.3 Evaluate the use of control technologies in everyday life

Unit 4. E-safety and health and safety

4.1 Personal data and handling

·4.2 Unauthorised persons prevention

4.3 Describe malware issues

4.4 Describe a range of potential health and safety issues that could arise from using IT

Term 1 Practical

Unit 8. Spreadsheets

8.1 Create a spreadsheet

Structure, purpose, formatting,

Formulae and functions, validation and rules, data sorting, import, export,

8.2 Analysis, graphs and charts

8.3 Modelling

8.4 Simulations, description and evaluation.

Term 2 Theory

Unit 5 .The Digital Divide

5.1 What is the digital divide

5.2 What can cause a digital divide

5.3 The future

Unit 6. Using Networks

6.1 Networking computers

6.2 The internet

6.3 The World Wide Web

6.4 Communication using the internet

6.5 Mobile networks

Unit 6. Using Networks (continued)

6.6 Video and Web conferencing

Unit 7 .Expert systems

7.1 What is an expert system

7.2 How are expert systems used

7.3 Data processing system

Term 2 Practical

Unit 9. Databases

9.1 Create a database

9.2 Normalise to third normal form

9.3 Data dictionary

9.4 File and data management