KS2 Archives - Page 2 of 25 - teachictnt.org.uk

Modify your code

Starting from Scratch – Lesson 3 Objectives Use logic to debug existing code and explain your changes. Modify existing code for a particular purpose and explain your changes. Lesson Resources Lesson Slides Debugging task download Debugging task PDF version Scratch project for Debugging task Scratch project solution for Debugging task Student worksheet – ‘Lesson 3…

Reading code

Starting from Scratch – Lesson 2 Objectives To become familiar with the Scratch programming environment (blocks, sprites, stage, canvas, controls). To understand and use coordinates in programming. To accurately read, predict and explain visual code. Suggest changes to existing code. Lesson Resources Lesson Slides Student activity – ‘Purple Mash – reading code lesson 2’ file…

Define and predict

Starting from Scratch – Lesson 1 Objectives To understand and explain key vocabulary linked to programming. To accurately read, predict and explain visual code to a partner. Lesson Resources Lesson Slides Definition match – student sheets Vocabulary bingo – student sheets Reading code – Student activity slides Starting from Scratch Lesson 1 – Define and predict…

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…