Autumn Term Sep – Dec
2A Data Analysis
- Data and Information
- How to Present Information
- Making Data Suitable for Processing
- Collecting Data
- Quality of Data
- Data Modelling
- Data Security
- 2A Internal Assessment – Data Analysis
Spring Term Jan – Apr
2B Presenting Data
- What is a Dashboard
- Importing Data
- Spreadsheet Formulae and Functions
- Lookup Functions
- Crating Tables, Charts and Graphs
- Validation
- Conditional Formatting
- Macros
- Creating a Dashboard
- 2B Internal Assessment – Creating a Dashboard
2C Interpreting Data
- Drawing Conclusions
- Making Recommendations
- 2C Internal Assessment – Dashboard Review and Conclusions
Summer Term 1 Apr – July
3A Modern Technologies
- Revisit Modern Technologies – In preparation for the external exam.
3B Threats to Data
- Revisit Threats to Data – In preparation for the external exam.
3C Responsible Use of Technology
- Revisit Legal and Ethical Use of Technology – In preparation for the external exam.