J808 LO5 Data Manipulation - Complete SoW Cambridge National Level 1/2 Information Technologies

Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach.

Database lessons use Microsoft Access.

5.1.1a Spreadsheet Functions Lesson PLUS worksheet and example files
5.1.1b VLOOKUP Lesson PLUS worksheet and example files
5.1.2 Cell Referencing and Importing Lesson PLUS example and solution files
5.1.3 Charts and Tables Lesson PLUS worksheet
5.1.4 What-If Analysis Lesson PLUS worksheet, answer and example files
5.1.5 Macros Lesson PLUS worksheet
5.2.1 Relational database Lesson
5.2.2 Import data from other sources Lesson PLUS worksheet, sample and example files
5.2.3 Data validation Lesson PLUS worksheet, sample and example files
5.2.4 Input Forms Lesson PLUS worksheet, sample and example files
5.2.5 Queries Lesson PLUS worksheet, sample and example files
5.2.6-8 Reports, Security, Exporting Data Lesson plus database file
5.2.x Bringing It All Together – recap lesson incorporating all database learning
5.2.x Mini-project – Mini project Lesson to consolidate learning. WAGOLL included.

2 x Homework sheets with marking scheme
1 x End-of-module test question paper with marking scheme
1 x Module self-assessment learning checklist for students

All lessons are tried-and-tested. Save yourself hours of work by downloading now.