Alternative to Lesson 4 of NCCE’s “Modelling data using spreadsheets” . Adapted to be Christmas themed but covers SUM, MIN, MAX and COUNTA functions. Includes teacher presentation to guide lesson, spreadsheet for student, support sheet to help with Task 1 copying and teacher solution.

An exercise created for the Year 7 NCCE unit “Gaining support for a cause” Students choose the best tool for the job Includes student slide to complete, answers and prompt slide All editable

Discover my incredible printable Key Stage 3 Computer Systems booklet in PDF format, designed to make learning about computers engaging and effortless. It’s a complete rework of NCCE’s Year 8 Computer Systems unit so you can rest assured you are still following the same content, just in a different way! You could use for differentiation, cover lessons, revision or homework. Delve into essential topics such as “What is a computer?”, “Computer Components,” “How Components Work Together,” “Boolean Logic,” “Computer Software,” and “Artificial Intelligence.” The booklet is supported by my 8 Computer Systems videos on YouTube (free) Equip your students with comprehensive content and the convenience of studying at their own pace, anywhere, and anytime. This TES resource contains the PDF student booklet (printable but non-editable) and PDF student answers (printable but non-editable). Also available as with an editable student booklet: https://www.tes.com/teaching-resource/resource-12848800

Discover my incredible printable Key Stage 3 Computer Systems booklet in PDF format, designed to make learning about computers engaging and effortless. It’s a complete rework of NCCE’s Year 8 Computer Systems unit, so you can rest assured you are still following the same content, just in a different way! You could use it for differentiation, cover lessons, revision or homework. Delve into essential topics such as “What is a computer?”, “Computer Components,” “How Components Work Together,” “Boolean Logic,” “Computer Software,” and “Artificial Intelligence.” The booklet is supported by my 8 Computer Systems videos on YouTube (free) Equip your students with comprehensive content and the convenience of studying at their own pace, anywhere, and anytime. This TES resource contains the PDF student booklet (printable but non-editable), a Word version which is EDITABLE and PDF student answers (PRINTABLE but NON-EDITABLE). Please note: The Word version has a large file size! Also available as a PDF version only: https://www.tes.com/teaching-resource/-12848799

A visual overview of the Key Stage 3 curriculum if you follow the NCCE resources Created as an A3 file so prints to A3 and lower easily and can be enlarged (check quality)

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!

A rework of the NCCE Year 7 unit “Networks from semaphores to the Internet” into a booklet Could be used to teach, support or revise the unit This resource contains: 30-page PDF student booklet with the theory and then activities including watching videos, answering questions, fill in the gap exercises. PDF booklet with answers for teachers/support staff

The slides to accompany my KS3 Networks & Internet booklet https://www.tes.com/teaching-resource/resource-12681094 (Word Version) https://www.tes.com/teaching-resource/resource-12680939 (Printable PDF) The slides help to deliver the booklet in lesson - so videos and embedded and youc can reveal the answers instead of relying on the answer booklet. The slides are a rework of the NCCE Year 7 unit “Networks from semaphores to the Internet” into a booklet

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!

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

A rework of the NCCE Year 7 unit “Networks from semaphores to the Internet” into a booklet Could be used to teach, support or revise the unit This resource contains: a 30-page student PDF booklet with the theory and then activities including watching videos, answering questions, fill in the gap exercises. a 30-page student Word version of the same booklet with the theory and then activities including watching videos, answering questions, fill in the gap exercises. PDF booklet with answers for teachers/support staff Font required for Word booklet: Fira Sans Black

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 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): 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!

Final lesson in our Modelling Data Series, designed to help students revise for an end of unit assessment Lesson includes: Skeleton presentation with learning objectives, task direction and plenary questions All the videos used in the Modelling Data Series: Support sheet summarising all the key concepts (in the guise of a menu) Differentiated activity in which students create a spreadsheet based on the nutrition in a meal deal Version 1 – Guides them and tells students what to write and do (includes screenshots of Microsoft Excel and Google Sheets) Version 2 – Tells them what is required but doesn’t tell students what to do Spreadsheet Solution Suitable to support students using NCCE Modelling Data unit Ideal for remote learning delivery – I’ve used for this! *Updated February 2023 - task sheets now in Word format and a few corrections made!

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

Revision tasks for students completing the NCCE KS3 Year 9 Computing unit Includes answer sheet

Mark scheme for blog in the NCCE Year 7 Using media – Gaining support for a cause unit Editable spreadsheet Highlights the mark band based on the number allocated Room for criteria Could be uploaded and converted to a Google sheet then shared with each student so they can see their progress and/or use it