This is for a lesson for students who are new to using the Raspberry Pi. The PPT and worksheet is fully customizable.

For the new IT/ Computing Syllabus

Insight in to the Central Processing Unit

Covers the following areas: describe the three types of relationships create and interpret an entity relationship diagram evaluate difference between flat file & relational database create a relational database analyse the function of key fields (including: primary key, compound key, foreign key) validate and verify data entry use validation rules test validation applied to a database complex queries using multiple criteria using text, numeric, date, time, wildcard, Boolean operators (AND, OR, NOT), ., ,, =, .=, ,= create and evaluate an appropriate data entry form

Suitable for year KS3

An intro to Python using the Thonny IDE which is Free to download and use.

A selection of questions for the year 10 or 11 Mock exams. This is relevant for the 2017-19 Syllabus

Objectives of the Topic - Understand how Binary makes computers work - Be able to convert Binary to Denary - Understand the Denary numbers are - Be able to convert numbers to Binary - Understand the Hexidecimal system - Be able to convert Binary to Hexidecimal - Be able to convert Hexidecimal to Binary

Customizable PPT and worksheet

Covers the following areas: Use validation rules in a spreadsheet Test validation rules Test a spreadsheet model & evaluate effectiveness Search for data within a spreadsheet Sort data Import & export data Analyse & select appropriate type of chart Describe the characteristics of modelling software Analyse the need for computer models Evaluate the use of simulations

For both IT and Computing subjects.

This resource allows the teacher to incorporate Spreadsheet, Database, Research and Presentation topic areas as they wish. Project management can be used as an extra if required. There are no set instructions on how to use the resources. Therefore, the teacher has the ability to adapt the classes as they wish. It is recommended to use over a period of 5-6 lessons. -Research using the internet for Ingredients -Presenting findings on a spreadsheet or database report -Finding recipes online and breaking it down in to activities using Gantt chart -Designing product packaging -Present the work as a PPT or any other means to the class

Selection in Python (IF statements) with customizable PPT and worksheet

Customizable PPT on Python strings

Transmission Control Protocol (TCP) & IP for iGCSE and A Level Covers the basics in a way that is easy for pupils to understand

Index Formula in Excel Note: Will require teacher to make Excel questions