Year 11 DIT Learning Map

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.