Year 9 · Spring 1 · Data Science and AI

Analysing in a spreadsheet or Python

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 Data ProgrammingCambridge Lower Secondary Computing 0860

You will learn to

Calculate the mean, median, mode and range of a small data set by hand.
Use AVERAGE, MEDIAN, MODE, and MAX minus MIN in a spreadsheet to check the answers.
Work out the same answers in Python from a list, using sum, len, sorted, max and min.
Write an SQL query with WHERE that picks out only the records a question needs.

Success criteria

I can work out all four values by hand for seven numbers.
I can say which one fits a question, like the mode for the most common way to travel.
I can get the same mean in the spreadsheet and in Python.

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.