A set of 30 full lessons covering all content for the unit 2 creating systems to manage information database unit for the new BTEC Nationals. Includes exam database help (signposted to the Pearson website due to copyright ) and some databases created by myself. Step by step guide throughout the whole unit which has been successful with my students and for other members of staff.

UPDATED The booklet is uodated to reflect changes made by Pearson for the 2020 series with the Part A and Part B exam. A revision booklet that goes through the whole exam which includes help guides for each part of the exam. It includes print screens and examples and covers the following skills: Entity Relationship Diagram Importing data Creating Tables Relationships Validation and Input Masks Forms Append Queries Testing Main Menus Queries Reports Evaluation And how to fill in the following documentation: Activity 1 ERD Screenshot Activity 2 Tables Activity 3 Implementation Activity 4 Testing Activity 5 Evaluation There is also an assessment checklist with exactly what to make sure that they have done in each hour of the exam.

Whole scheme of work with lessons, resources and example code for each step of the way. Students learn and practice skills and by the end of the 8 lessons will have a fully coded HTML website through notepad. It covers: tags, formatting, hyperlinks and changing colours (both standard and hexadecimal), images and page colours and table layouts.

At least 3 lessons to use with years 7 and / or 8 to introduce the ideas of hardware, software, storage and the input process output cycle. Includes lessons, resources, tasks and a link to my ready made kahoot.

One off lesson to help explain how the internet works. Includes key terms, key hardware and a working diagram of how data is transferred.

An 8 lesson scheme of work with resources, lessons and student worksheets to cover both e-safety and powerpoint in the same topic. Students learn the basics of e-safety and then apply their knowledge to an interactive quiz.