Computing

Y7 Computing

Key Stage 3

Year 7

Spreadsheets

In this lesson, we will introduce the concept of spreadsheets and why spreadsheets are useful. We will learn how to navigate a spreadsheet via its rows and columns, and become familiar with the cell referencing system.

Getting to know a spreadsheet

In this lesson, we 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. We will learn how to use the autofill tool to duplicate cells and continue a linear pattern.

Quick calculations

In this lesson, we will begin with a recap of the previous lessons content and some further practise of using formulas. We will discover the difference between data and information, and between primary and secondary sources of data.

Collecting data

In this lesson, we will discover how to use functions to analyse data in a spreadsheet. As well as learning how to automatically create charts from data. We will be introduced to four functions: SUM, MAX, MIN, and COUNTA.

Become a data master!

In this lesson, we will introduce three more functions "COUNTIF, AVERAGE, and IF" and to how they can sort and filter a spreadsheet. We will work on a larger data set to get a feel for analysing real-world data using spreadsheets.

Level up your data skills!

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

Key Stage 3, Computing, Spreadsheets

Getting to know a spreadsheet

Quick calculations

Collecting data

Become a data master!

Level up your data skills!

Conditional formatting