IT Archives - teachictnt.org.uk

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…

Check it with charts (Google)

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 Teacher’s presentation Student activity sheet Demonstration Spreadsheet activities Google Sheets Google help sheets -…

Sort it out (Google)

Spreadsheet masters – Lesson 3 Objectives Use a spreadsheet to sort data quickly Recall features of a spreadsheet Lesson Resources Teacher’s presentation Student activity sheet Lesson 3 Student worksheet – 1 per child on paper or share via Google Classroom so they have their own digital copy Demonstration Spreadsheet activities Google Sheets Data sort video guide…