key stage 2 Archives - Page 2 of 3

Starting from Scratch

About this unit: Lay strong foundations for coding as you introduce your class to the visual language of Scratch, while using the PRIMM approach. Teach your students to predict, run and investigate code, before they start to modify existing code and eventually plan and make their own coded animation project. National Curriculum Links – Computing…

Self-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…

Conditional 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…

Check 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…

Sort 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…

The 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…

What 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…

Crumble colour codes

Getting started with a Crumble – Lesson 3 Objectives Use logical reasoning to explain how some simple algorithms work and to detect and correct errors in algorithms and programs To create (and decode) coded messages by programming light sequences Lesson Resources Lesson Slides Colour codes worksheet Crumble starter kits (1 between 2 students) 3 x…

Making it move

Getting started with a Crumble – Projects part 2 Objectives Design and make and test objects or artefacts that successfully incorporate the Crumble controller and motors to make the object move. Use sequence, selection, and repetition in programs and various forms of input and output. use logical reasoning to explain how some simple algorithms work…

Illuminated making

Getting started with a Crumble – Projects part 1 Objectives Use sequence, selection, and repetition in programs and various forms of input and output. use logical reasoning to explain how some simple algorithms work and to detect and correct errors in algorithms and program. Design and make and test objects or artefacts that successfully incorporate…