A revision sheet to help students remember the difference between data and information as well as features of spreadsheets software Suitable to support students using NCCE Modelling Data unit Ideal for supporting remote learning delivery – we’ve used it for this!

If you purchase either a lesson or the Modelling Data Series bundle these videos are included so no need to buy them! A set of 19 videos to demonstrate the skills needed when modelling data (with narration): 1 - Familiarisation 2 - Arithmetic Formulas 2 - Charts - Excel 3 - Charts - Google Sheets 3 - Ctrl Key 3 - Data & Information 3 - Data & Information + Excel Charts 3 - Data & Information + Google Sheets Charts 4 - SUM MIN MAX COUNTA 5 - Average 5 - COUNTIF 5 - Filtering - Excel 5 - Filtering - Google Sheets 5 - IF Statement (Cat Scenario) 5 - IF 5 - Sorting - Excel 5 - Sorting - Google Sheets 6 - Conditional Formatting - Excel 6 - Conditional Formatting - Google Sheets Suitable to support students using NCCE Modelling Data unit in a clear and concise way Ideal for supporting remote learning delivery – we’ve used it for this! Google Sheets versions of videos included for skills where we believe it is significantly different between Microsoft Excel and Google Sheets

Lesson includes skeleton presentation which includes learning objectives, videos, task direction and plenary questions Videos demonstrate (with narration): Conditional formatting Google Sheets version of video also included Exercises to complete within one spreadsheet (Microsoft Excel format) Suitable to support students using NCCE Modelling Data unit

Lesson includes skeleton presentation which includes learning objectives, videos, task direction and plenary questions Videos demonstrate (with narration): AVERAGE IF COUNTIF Sort Filter Google Sheets version of Sort & Filter videos also included Exercises to complete within one spreadsheet (Microsoft Excel format) Suitable to support students using NCCE Modelling Data unit in a clear and concise way Ideal for remote learning delivery – we’ve used it for this! Please note: not all worksheets are shown in the preview images *Updated January 2023 - fixed box in COUNTIF video and added YouTube videos so students can get help independently.

Lesson includes skeleton presentation which includes learning objectives, videos, task direction and plenary questions Video demonstrate (with narration): Cell reference; range; SUM; MIN; MAX; COUNTA Exercises to complete within one spreadsheet (Microsoft Excel format) Suitable to support students using NCCE Modelling Data unit in a clear and concise way Ideal for remote learning delivery – we’ve used it for this!

Lesson includes skeleton presentation which includes learning objectives, videos, task direction and plenary questions Video demonstrate (with narration): The difference between data and information Making the information stand out with gridlines and fill bucket Displaying information in a graph How to make a graph (Video for Microsoft Excel and Google Sheets) Exercises to complete within one spreadsheet (Microsoft Excel format) Suitable to support students using NCCE Modelling Data unit in a clear and concise way Ideal for remote learning delivery – I’ve used it for this!

Lesson includes skeleton presentation which includes learning objectives, videos, task direction and plenary questions Videos demonstrate (with narration): – / ^ Exercises to complete within one spreadsheet (Microsoft Excel format) Solution provided (Excel format) Suitable to support students using NCCE Modelling Data unit in a clear and concise way Ideal for remote learning delivery – we’ve used it for this!

A series to support the delivery of Modelling Data, particularly via remote learning Includes all our mini-lessons with videos and spreadsheet exercises Tried and tested with our students remotely

Brief explanation of how to write a question using selection or while loop Template to plan questions if needed Includes Python files Updated 15/02/22 to fix error

A visual way to remind students keywords for GCSE Computer Science The template is slightly larger than A3 so it could be enlarged for a wall poster

Exercises to complement the First Impressions Count story A way for students to reflect on what they have read (and check they have read it!)

Our Know How tasks are shorter tasks (which can go further!) Image files provided for students to use plus an example solution (PSD file) Image files include the market and snowflakes images In this exercise students use Photopea to remove some people from an image, adjust the colours and add snowflakes

11 steps to help students use lists and loops to create a Christmas list Includes Scratch solution plus the Santa and Rudolf images (full size) Please note: the sheet does not teach students how to draw sprites and a basic knowledge of how to select blocks would be helpful!

In this worksheet students learn how to create, add to, delete from and combine lists as well as use a for loop to present items row by row As the concepts are slightly trickier, the format is slightly different to the first few worksheets Part of the Python Practice Makes Perfect series where students practice by repetition Includes Python files Updated Nov. 21 to correct final task numbers (7a and 7b)

Set of tasks to help teach students Computer Science through Scratch, using PRIMM Based on Scratch 3 In this task students practice the ‘repeat until’ block Contains student sheet, and the solution to solve the MAKE section

Part of the Python Practice Makes Perfect series In this worksheet students learn how to use FOR loops As the concepts are slightly trickier, the format is slightly different to the first few worksheets Includes our solutions and a skeleton presentation with the task and solutions on

Part of the Python Practice Makes Perfect series In this worksheet students learn how to use WHILE loops Includes our solutions

Students code a Christmas quiz Resource includes: Three versions of the handout (plain, add-ons annotated, fully annotated) The source code for two questions The source code to get students started with one question (without scoring)

Students code a program that can allows them a create a Christmas list in a text file Lesson includes handout with three tasks, worksheet where they can explain the code, a supporting presentation and the code