I have taught Maths and ICT for over 25 years in 6 different schools in both England and Wales. I have been a Cross Curricular ICT coordinator (5 years) in one school and a Head of Maths in two other schools (4 and 10 years). During that time I have developed numerous resources to teach Maths and ICT particularly using EXCEL and VBA.
The resources in the shop are all written using EXCEL. I would welcome any feedback / suggestions that would make the resources better.
I have taught Maths and ICT for over 25 years in 6 different schools in both England and Wales. I have been a Cross Curricular ICT coordinator (5 years) in one school and a Head of Maths in two other schools (4 and 10 years). During that time I have developed numerous resources to teach Maths and ICT particularly using EXCEL and VBA.
The resources in the shop are all written using EXCEL. I would welcome any feedback / suggestions that would make the resources better.
Teaching If Statements using EXCEL
This is a series of interactive resources to teach IF Statements in EXCEL. The EXCEL workbook contains the following sheets:
• A word cloud starter with spreadsheet terms
• An interactive “Build an IF statement” whiteboard sheet
• 10 x “Build an IF Statement” question sheets designed to practice creating IF statements
• 5 x Project sheets where the students need to build a complete interactive test sheet for younger students to practice their maths. These include self-assessment sheets with indicative levels
• 3 x Help sheets and example sheets to support students
• 1 x Final assessment sheet with timer where the students have to evaluate 5 if statements. (Random number generation so that all students have a different assessment answer set)
The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4.
You will need to enable the macros for the resource to work properly.
