Lesson to introduce pupils to databases. Top 500 Access.txt needs changed to .accdb (TES does not accept this type of file)

Bare bones SoW for Y7 ICT. I have followed this for a couple of years and it appears to have gone ok. Any comments would be appreciated.

A selection of scenarios for pupils to solve. (There is a PP showing how to draw a graph to solve the first question)

Simple self-marking quiz to test users knowledge of spreadsheets. Uses screen shot of Excel 2010. This is an updated version of a similar resource already shared on TES by 'darlingclementine' password to allow editing is 'Impawn01'

Simple explanation of how to structure IF and Count IF statements in Excel

Step by step guide for drawing break even graph. (This is also the solution to the first question on the break even question sheet)

Guide with screen shots for Excel 2007 macros.

This example uses IF and COUNTIF statements, conditional formatting, data validation and cell protection. All aspects are explained on 1 tab. Macros are explained (sort of) but not included as TES does not allow that file type. Second file (with macro in name) includes macros but needs renamed .xlxm instead of .xlsx

Teacher PP and blank handout for pupils.

Teacher PP and pupil work sheets for Y12.