This course introduces foundational information and communication technology concepts, covering computer hardware, software, storage, file management, and operating systems. It explores word processing techniques, including document creation, formatting, image insertion, and proofing tools. Further topics include online safety, email etiquette, effective searching, source evaluation, spreadsheets with formulas and charts, and basic presentation and image editing skills.
Click any lesson with to preview it
This module introduces foundational computer skills, emphasising practical application via a student-chosen project. Learners explore hardware, software, storage, file management, and operating systems; master word processing techniques including formatting, tables, and proofing; and develop safe internet practices, effective searching, and professional emailing. A digital portfolio captures progress for assessment.
This module introduces essential software packages beyond basic tools, focusing on spreadsheets and presentation applications. Learners evaluate tool suitability for projects, master data entry, navigation, formatting, formulas, charts, and error checking in spreadsheets. It covers slide design, animations, and image editing in tools like PowerPoint or Canva, culminating in practical workshops for real-world portfolios.
| Spreadsheets | ||
| What's a Spreadsheet for? Suitable Uses | Quiz | |
| Entering Data: Cells, Rows, Columns, Sheets | Quiz | |
| Navigation, Editing & Undo | Quiz | |
| Saving, File Formats & Versioning | Quiz | |
| Cell Formatting: Numbers, Currency, Dates, Alignment | Quiz | |
| Borders, Shading & Readability | Quiz | |
| Simple Formulas: SUM & AVERAGE | Quiz | |
| More Formulas: MIN, MAX, COUNT | Quiz | |
| Cell References & Autofill | Quiz | |
| Logical Formulas: IF | Quiz | |
| Logical Formulas: Standard Functions | Quiz | |
| Standard Functions: ROUND, TODAY, NOW, LEN, UPPER, LOWER | Quiz | |
| Sorting & Filtering Data | Quiz | |
| Checking Your Data: Finding & Fixing Errors | Quiz | |
| Print Preview, Print Areas & Page Setup | Quiz | |
| KA1 Workshop Part 1: Building the "Best Spreadsheet" | Quiz | |
| KA1 Workshop Part 2: Formulas That Do Real Work | Quiz | |
| KA1 Workshop Part 3: Evidence Check & Unit 1 Recap | Quiz | |
| Introduction to the Graphical Presentation of Data | ||
| Your First Bar Chart | Quiz | |
| Your First Pie Chart | Quiz | |
| Chart Formatting: Titles, Labels, Legends, Colours | Quiz | |
| Chart Interpretation: What Does It Say? | Quiz | |
| KA2 Workshop: Saving & Printing in Graphic Format | Quiz | |
| Intro to Presentations: Powerpoint, Slides, or Canva | Quiz | |
| Inserting Text & Images in Slides | Quiz | |
| Slide Design: Readability at the Back of the Room | Quiz | |
| Animations, Transitions & When to Use Them | Quiz | |
| Image Editing Basics: the Tools Students Actually Reach for | Quiz | |
| KA3 Workshop Part 1: Designing the Promotional Document | Quiz | |
| KA3 Workshop Part 2: Building the Promotional Document | Quiz | |
| KA3 Workshop Part 3: Pitch Day & Full Portfolio Walkthrough | Quiz | |
This module introduces foundational computer skills, emphasising practical application via a student-chosen project. Learners explore hardware, software, storage, file management, and operating systems; master word processing techniques including formatting, tables, and proofing; and develop safe internet practices, effective searching, and professional emailing. A digital portfolio captures progress for assessment.
This module introduces essential software packages beyond basic tools, focusing on spreadsheets and presentation applications. Learners evaluate tool suitability for projects, master data entry, navigation, formatting, formulas, charts, and error checking in spreadsheets. It covers slide design, animations, and image editing in tools like PowerPoint or Canva, culminating in practical workshops for real-world portfolios.
| Spreadsheets | ||
| What's a Spreadsheet for? Suitable Uses | Quiz | |
| Entering Data: Cells, Rows, Columns, Sheets | Quiz | |
| Navigation, Editing & Undo | Quiz | |
| Saving, File Formats & Versioning | Quiz | |
| Cell Formatting: Numbers, Currency, Dates, Alignment | Quiz | |
| Borders, Shading & Readability | Quiz | |
| Simple Formulas: SUM & AVERAGE | Quiz | |
| More Formulas: MIN, MAX, COUNT | Quiz | |
| Cell References & Autofill | Quiz | |
| Logical Formulas: IF | Quiz | |
| Logical Formulas: Standard Functions | Quiz | |
| Standard Functions: ROUND, TODAY, NOW, LEN, UPPER, LOWER | Quiz | |
| Sorting & Filtering Data | Quiz | |
| Checking Your Data: Finding & Fixing Errors | Quiz | |
| Print Preview, Print Areas & Page Setup | Quiz | |
| KA1 Workshop Part 1: Building the "Best Spreadsheet" | Quiz | |
| KA1 Workshop Part 2: Formulas That Do Real Work | Quiz | |
| KA1 Workshop Part 3: Evidence Check & Unit 1 Recap | Quiz | |
| Introduction to the Graphical Presentation of Data | ||
| Your First Bar Chart | Quiz | |
| Your First Pie Chart | Quiz | |
| Chart Formatting: Titles, Labels, Legends, Colours | Quiz | |
| Chart Interpretation: What Does It Say? | Quiz | |
| KA2 Workshop: Saving & Printing in Graphic Format | Quiz | |
| Intro to Presentations: Powerpoint, Slides, or Canva | Quiz | |
| Inserting Text & Images in Slides | Quiz | |
| Slide Design: Readability at the Back of the Room | Quiz | |
| Animations, Transitions & When to Use Them | Quiz | |
| Image Editing Basics: the Tools Students Actually Reach for | Quiz | |
| KA3 Workshop Part 1: Designing the Promotional Document | Quiz | |
| KA3 Workshop Part 2: Building the Promotional Document | Quiz | |
| KA3 Workshop Part 3: Pitch Day & Full Portfolio Walkthrough | Quiz | |
See exactly how this course maps to official curriculum specifications
The curriculum does not include official reference codes for individual learning outcomes, so we have assigned a code scheme to make it easier to identify and track coverage.
Students will need one of these devices. Students can share in groups of 2-3 if necessary.
Get in touch to discuss pricing and ordering for your school.
