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.

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.

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.

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.

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.

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.