Year 8 Science · Unit 4 · Lesson 9

Using Spreadsheets for Data

Foundation Worksheet

Name

Date

Class

Learning Goals

Define key spreadsheet terms: cell, formula, column, row, chart, and the =AVERAGE function.
Describe how to organise scientific data in a spreadsheet with appropriate headers and layout.
Identify the advantages of using a spreadsheet over manual calculation for scientific data.

Warm Up

Match each term to its definition

Draw a line connecting each spreadsheet term on the left to its correct definition on the right. Or write the matching letter next to each term.

Term	Your answer	Definition
Cell		A. A visual representation of data such as a bar graph or line graph generated automatically from selected cells.
Formula		B. A horizontal series of cells running left to right across the spreadsheet, identified by a number.
=AVERAGE		C. A single box where data or a formula is entered, identified by a column letter and row number (e.g. B3).
Column		D. A built-in spreadsheet function that calculates the mean of a selected range of cells.
Row		E. An instruction beginning with = that performs a calculation using cell references or values.
Chart		F. A vertical series of cells running top to bottom, identified by a letter.

Your Turn

Fill the gap

Choose the correct word from the word bank to complete each sentence about using a spreadsheet to organise plant growth data.

spreadsheet formula average column row chart cell header label

A is a digital tool that stores data in rows and columns and can perform calculations automatically. Each piece of data is entered into a single , which is identified by a letter and a number. In a science experiment, each usually stores one observation and each stores one variable or measurement type. The top row should be a row that names each variable and includes its unit. To find the mean of five plant height measurements in cells B2 to B6, you would type the =AVERAGE(B2:B6). Once your data is entered, you can create a that visually displays the pattern — for example, how plant growth changes over time.

Show What You Know

1. A student types the formula =AVERAGE(B2:B6) into cell B7. What will the spreadsheet calculate, and what happens to this result if the student later corrects the value in cell B4?

Recall 2 marks

2. Give two advantages of entering science experiment data into a spreadsheet rather than calculating everything by hand.

Recall 2 marks

Wrap Up

In one sentence, what was the main idea of this lesson?