Easier to read with cream paper, a tint, more contrast or larger text? Choose your colours and text, once, for every page.

Preview

Changing data: manipulate, analyse, process

This is the first page of the lesson. Read it and have a go at the activities. The rest is in the full lesson.

40 minutes

The school trip list

Your class plans a trip. Ms Okafor has a messy list: names in any order, some prices, some students who have not paid.

She needs three things. A tidy list. The total cost. How many students have paid.

She does not collect new data. She changes the data she has. That is called transforming data.

Key words

WordWhat it meansExample
TransformChange data so that it is more useful.Sort a list by price
ManipulateChange the shape or order of data: sort it, filter it, or join it.Keep only students who paid
AnalyseLook at data to find out what it says.Find the average price
ProcessTake input, do a set of steps on it, and give output.Turn a list of prices into one total
AverageThe total divided by how many items there are.60 divided by 3 is 20
PercentageA number out of every 100.75 out of every 100
FilterKeep only the rows that fit a rule.Prices under £15
SortPut items in an order.Smallest price first

The cells students fill in are left blank in this preview.

Try it: manipulate a list

Code: python
prices = [12.5, 5.0, 20.0, 8.0, 15.0]

print("Original:", prices)
prices.sort()
print("Sorted:", prices)

cheap = []
for price in prices:
    if price < 15:
        cheap.append(price)
print("Under 15:", cheap)

# Change 15 to 10 and run it again.

Manipulating: change the shape

Manipulating data means changing how it looks or where it sits. You do not find out anything new.

You can sort a list. You can filter it to keep only some rows. You can join two lists into one, or change "5" typed as text into the number 5. The facts stay the same.

Analysing: find out what it says

Analysing means looking at data to learn something new. You count, add up, and compare.

The total of the prices is one answer. The average is another. The percentage of students who paid is a third. Analysis turns many numbers into a few useful ones.

Worked example: total and average

StepWhat you doResult
1Write the prices10, 20, 30
2Add them up10 + 20 + 30 = 60
3Count them3 prices
4Divide the total by the count60 divided by 3 = 20
AnswerThe average price£20

The cells students fill in are left blank in this preview.

Quick check: which way?

Have a go

Quick check: which way?

3 questions
Have a go: your answers are marked here and then forgotten. Sign in if you would like your score kept, and to pick up where you left off.Sign in to keep your score

Your answers are marked here and are not kept. A college account keeps every student’s marks.

Worked example: a percentage

StepWhat you doResult
1Count the students who paid15
2Count all the students20
3Divide paid by all15 divided by 20 = 0.75
4Multiply by 1000.75 times 100 = 75
Another way20 goes into 100 five times, so multiply both numbers by 515 times 5 = 75 and 20 times 5 = 100
AnswerA percentage is out of every 10075 out of every 100 have paid

The cells students fill in are left blank in this preview.

The lesson goes on

7 more parts of this lesson are in the full curriculum, with the tasks, the final check and the labs. A college account gives your students all of it.