L.O: I can collect, enter, organise into a spreadsheet. 

L.O: I can use a range of spreadsheet formulae, e.g. + - / x, sum, average, max, min.

 

Let's activate our prior knowledge... Beth wyt ti'n feddwl?

1. What is the formula for calculating the total or sum?

2. What is the formula for calculating the average?

3. How do I create a graph? 

 

“Right, Year Pry Cop, I’ve got a challenge for you...”

Gower is packed full of ancient stories, dramatic castles, hidden stones, and places people travel from all over the world to see. But something surprising has happened...

The Gower Heritage Team has lost some really important information and they need YOU.

They want to know:

• Which sites are the most popular?

• Which ones might need more protection?

• How far people travel to see them?

• And which places are secretly the most impressive?

To solve this mystery, they’ve given you access to their official data, hidden inside a spreadsheet.

Your job?

🕵️ Investigate the data using sums, averages, charts and comparisons
📊 Create evidence to help the Gower Heritage Team make decisions
💡 Become Data Detectives of the Gower

Every number tells a story. Every chart uncovers a clue. And by the end, you’ll know Gower better than most adults!