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. When there are “missing” numbers in the sequence of lessons is when I have done exam papers as variation of what we have learnt with my students. For copyright reasons these cannot be included but can be found at the following link: https://qualifications.pearson.com/en/qualifications/btec-nationals/information-technology-2016.coursematerials.html#filterQuery=category:Pearson-UK:Category%2FExternal-assessments&filterQuery=category:Pearson-UK:Unit%2FUnit-2

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.

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

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.

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.

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.