Listing all results (14669)

Lesson 6 - Assessment

In this lesson, students will discover how to use conditional formatting, whereby the appearance of a cell changes automatically depending on the data it contains, according to rules the students themselves set. They then complete an end-of-unit summative assessment.

This lesson is the sixth in a six session...

Lesson 5 - Level Up Your Data Skills

This lesson will introduce students to three more functions — COUNTIF, AVERAGE, and IF — and to how they can sort and filter a spreadsheet. Students will work on a larger data set to get a feel for analysing real-world data using spreadsheets.

...

Lesson 4 - Become A Data Master

In this lesson, students will discover how to use functions to analyse data in a spreadsheet. As well as learning how to automatically create charts from data, they will be introduced to four functions: SUM, MAX, MIN, and COUNTA. Functions allow you to very quickly calculate results. The functions covered in this...

Lesson 3 - Collecting Data

This lesson begins with a recap of the previous lesson’s content and some further practise of using formulas. Then students will discover the difference between data and information, and between primary and secondary sources of data. They will then design a survey to collect some data of their own for use in the...

Lesson 2 - Quick Calculations

In this lesson, students will practise entering text into cells of a spreadsheet and then learn how to perform calculations on the data using basic formulas and cell references. They will learn how to use the autofill tool to duplicate cells and continue a linear pattern, and then combine the autofill tool with...

Lesson 1 - Getting To Know A Spreadsheet

This lesson introduces students to the concept of spreadsheets and why spreadsheets are useful. They will learn how to navigate a spreadsheet via its rows and columns, and become familiar with the cell referencing system. They will locate and select ranges of cells and change cells’ background colour and border...

Modelling Data - Spreadsheets Overview

This resource provides a unit overview for the Year 7 ‘Modelling data' unit of work. It gives a clear overview of objectives to be covered within each session and a learning graph to show the range of skills being developed through this computing...

Lesson 6 - Who Are You Talking To Online?

This lesson introduces students to the concept of people impersonating others online. This can be done in different contexts, but this lesson focuses on people pretending to be one of our ‘non-digital world’ friends. It gives students tips on how to identify our friends online and how to spot impersonations. 

...

Lesson 5 - Presenting To An Audience (Part 2)

This lesson is a continuation of the previous lesson. Students are reminded of good practice for presentations through a ‘true or false’ activity. They then continue to work on their presentations, in preparation for showing them to the class. 

This lesson is the fifth in a six session teaching unit provided...

Lesson 4 - Presenting To An Audience (Part 1)

This lesson focuses on the skills required to plan an effective presentation for an audience. It also explores the term ‘cyberbullying’ and the effects of cyberbullying. The lesson includes questioning and observation, which can help you assess students’ prior knowledge of presentation software.

This lesson...

Pages

View all publishers