IT and Digital Literacy Archives

Keep safe and create

About this unit: A combination of 3 lessons from Common Sense Education’s excellent digital citizenship curriculum and the chance for your students to apply their learning to digital making activities that would help them share the important online safety messages with others. National Curriculum Links – Computing KS1 The content of this plan cover the…

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…

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…

Self-marking quizzes (Google)

Spreadsheet masters – Lesson 6 Objectives Create a spreadsheet to test maths facts Use Conditional formatting to mark the questions Lesson Resources Teacher’s presentation Student activity sheet Demonstration Spreadsheet activities Google Sheets General spreadsheet guidance How to use Google Sheets Excel Quick Start Guide Basic tasks in Excel Spreadsheet masters Lesson 1 – What is…

Conditional formatting (Google)

Spreadsheet masters – Lesson 5 Objectives Use tools in a spreadsheet to help someone understand the information more quickly Sort Conditional formatting Lesson Resources Teacher’s presentation Student activity sheet Demonstration Spreadsheet activities Google Sheets Lower than 0 video guide ‘Students ‘Scores’ to copy’ General spreadsheet guidance How to use Google Sheets Excel Quick Start…