Uncategorized
Find out and present
About this unit: Introduce students to researching information, presenting what they find and creating exciting interactive quizzes. National Curriculum Links – Computing KS1 The content of this plan cover the following National Curriculum strands: use technology purposefully to create, organise, store, manipulate and retrieve digital content recognise common uses of information technology beyond school use…
Read MoreSelf-marking quizzes (Microsoft)
Spreadsheet masters – Lesson 6 Objectives Create a spreadsheet to test maths facts Use Conditional formatting to mark the questions Lesson Resources Lesson slides (Microsoft Excel version) Student activity sheet (Microsoft Excel version) Demonstration Spreadsheet activities Spreadsheet masters Microsoft Excel version Lesson 1 – What is a spreadsheet? Lesson 2 – The perfect formula Lesson 3 – Sort…
Read MoreConditional formatting (Microsoft)
Spreadsheet masters – Lesson 5 Objectives Use tools in a spreadsheet to help someone understand the information more quickly Sort Conditional formatting Lesson Resources Lesson slides (Microsoft Excel version) Student activity sheet (Microsoft Excel version) Demonstration Spreadsheet activities ‘Scores’ – Student Version Spreadsheet masters Microsoft Excel version Lesson 1 – What is a spreadsheet? Lesson 2…
Read MoreCheck it with charts (Microsoft)
Spreadsheet masters – Lesson 4 Objectives Use a set of data in a spreadsheet to create an appropriate chart Use data in a spreadsheet to answer a set of questions Use information presented in a chart to answers questions Lesson Resources Lesson slides (Microsoft Excel version) Student activity sheet (Microsoft Excel version) Demonstration Spreadsheet activities…
Read MoreSort it out (Microsoft)
Spreadsheet masters – Lesson 3 Objectives Use a spreadsheet to sort data quickly Recall features of a spreadsheet Lesson Resources Lesson slides (Microsoft Excel version) Student activity sheet (Microsoft Excel version) Demonstration Spreadsheet activities Students ‘LESSON 3’ spreadsheet to download as Excel Sheet Spreadsheet masters Microsoft Excel version Lesson 1 – What is a spreadsheet? Lesson…
Read MoreThe perfect formula (Microsoft)
Spreadsheet masters – Lesson 2 Objectives Recall features of a spreadsheet Use cell references to complete formulae Use spreadsheets to complete formulae quickly and easily Lesson Resources Lesson slides (Microsoft Excel version) Student activity sheet (Microsoft Excel version) Demonstration Spreadsheet activities Tricky Times Tables video guide Excel Quick Start Guide Basic tasks in Excel Spreadsheet…
Read MoreWhat is a spreadsheet? (Microsoft)
Spreadsheet masters – Lesson 1 Objectives Explain what a spreadsheet is; Describe how a spreadsheet could be used by someone at work; Label the different areas of a spreadsheet using the correct vocabulary; Create simple formulae in a spreadsheet. Lesson Resources Lesson slides (Microsoft Excel version) Student activity sheet (Microsoft Excel version) Demonstration Spreadsheet activities…
Read MoreSwitch it up
Getting started with a Crumble – Lesson 2 Objectives To safely and accurately set up a Crumble and Sparkle LEDs To understand, explain and apply conditions in a program using ‘if then’ and ‘if then, else’ statements. Lesson Resources Lesson Slides Crumble starter kits (1 between 2 students) 3 x AA batteries (per Crumble) Other…
Read MoreGetting started with a Crumble
About this unit: Explore the fantastic microcontroller that is the Crumble. Learn about inputs, outputs, electrical circuits and controlling LEDs and motors as you embark on a range of exciting physical computing STEM projects. National Curriculum Links – Computing KS2 The content of this plan cover the following National Curriculum strands: design, write and debug…
Read MoreInputs, loops, conditionals, variables… games!
Taking micro:bits further – Lesson 5 Objectives Understand looping as a form of iteration Understand and use variables in a program Understand and use conditional statements Combine inputs, loops, conditional statements and variables to create a micro:bit game Lesson Resources Lesson Slides 3D Design Lesson 1 – Lesson 2 – Lessons 3 & 4 Lessons…
Read More