Year 7 · Spring 1 · Spreadsheets

Functions: SUM, AVERAGE, MAX, MIN, COUNTIF

What this lesson covers

Topic 18 Data, spreadsheets and AI

KS3 Computing · Data is raw facts. Information is data with meaning. Spreadsheets calculate, databases store and search, and AI learns patterns from examples.

Managing DataCambridge Lower Secondary Computing 0860

You will learn to

Use SUM, AVERAGE, MAX and MIN on a range of cells.
Use COUNTIF to count how many values meet a condition, like 'more than 10'.
Work out a mean by hand and check it with AVERAGE.

Success criteria

I can find the total, the mean, the best and the worst score.
I can count how many pupils scored more than 10 with COUNTIF.
I can say which function answers which question.

Key words

Say each word, then read what it means. Every one is in the glossary too.

formula: A spreadsheet calculation. Always starts with =.
Function: A subroutine that returns a value.
Record / field: One row in a database table: everything stored about one thing.
Primary key: A field whose value is unique for every record.
SQL: Structured Query Language: asks databases questions.
Machine learning: The computer finds rules itself from labelled examples.

The explanation

Read it here, or open the study page below to go one step at a time with things to try.

Formulas and functions

★Remember

A formula always starts with =. It updates by itself when other cells change.

Formula	Does	Spanish Excel
=B2+C2	Adds two cells	same
=SUM(B2:B10)	Adds B2 to B10	SUMA
=AVERAGE(B2:B10)	Mean	PROMEDIO
=MAX(...) / =MIN(...)	Biggest / smallest	MAX / MIN
=COUNTIF(B2:B10,">=25")	How many meet a condition	CONTAR.SI
=IF(B2>=25,"Pass","Retry")	Selection, like if/else	SI

!Watch out

Spanish settings use semicolons: =SI(B2>=25;"Aprobado";"Repetir"). Spain uses the comma as its decimal point.

The data science cycle

Ask a question.
Collect data.
Clean it: duplicates, typos, impossible values.
Analyse: averages, sorting, charts.
Conclude, honestly.

!Watch out

A link between two things (correlation) doesn't prove one causes the other.

Study it

Open the study page and go one step at a time.

Topic 18 · Year 7

Data, spreadsheets and AI

Data is raw facts. Information is data with meaning. Spreadsheets calculate, databases store and search, AI learns patterns from examples.

The steps for this lesson

Topic 18, step 7: Averages (The mean (average))

Check yourself

One question at a time. The reason shows after each answer.

Saved on this device.