Year 9 Using Data Interview lesson Da Vinci

• Computing
• Upper Secondary (Key Stage 4)
• Lower Secondary (Key Stage 3)

Year 9 Using Data Interview lesson Da Vinci

Key learning objective - To analyse and interpret data  using spreadsheet tools.

Year 9 Using Data Interview lesson Da Vinci

You are going to be shown a bar chart, it has no titles or labels. You will be asked some questions about this chart, be ready to discuss your ideas with the class.

What do you think this graph is showing?

What made you guess that, what existing knowledge did you use?

What question do you think this graph is now answering?

Computer activities

Year 9 Using Data Interview lesson Da Vinci

Title: Time Spent on Different Computer Activities by Teenagers per Week

Activity Hours Spent per Week:

Coding 4

Gaming 6

Watching Tech Videos 10

Social Media 5

Online Learning 3

Data or Information?

1. Data
2. Information

Data or Information?

1. Data
2. Information

Red, Blue, Green
Data or Information?

1. Data
2. Information

These are the top 3 colours chosen in a class survey.
Data or Information?

1. Data
2. Information

Success criteria

- I can use basic formula

- I can turn raw data into chart

- I can analyse a data set to answer questions.

What is a dataset?

Advances in technology have made it more feasible to collect, store, and analyse data on a much larger scale.​

Let’s consider how a company such as Netflix collects data.​

Watch this video

What other companies can you think of that might collect large sets of data?​

How do you think they use this data to help them make decisions?​

​

Think/pair/share.

There are large online databases that provide easy access tools to filter data like the best place to live database.

Click here

Watch the board do not take notes just listen and observe. I am going to make a prediction of a dataset then use the tools available to test my prediction.

“I think young adult visitors spend more time on roller coasters.”

Using the dataset provided, as a class we will make  anew prediction then use the tools to see if that prediction is true.

some examples:

- “Do older visitors spend more money?”

- “Do people who stay longer spend more?”

Lets make a spreadsheet together, when creating our spreadsheet think about what data should we collect? How should we organise our database? What is the purpose of our database? Which tools do we have available to help us?

Your task:

-Find the average age of park visitors

-Calculate the average time spent in the park

-Count how many people choose each ride

-Count how many visitors are in each age group

-Calculate the average visit time of under 18's

-What is the most popular under 18 ride?

-Create a graph to showcase your answers

-Make a presentation based on your findings

Scenario:

You are part of a music tour planning team. Your job is to decide which city would be the best for a concert stop based on data like:

- Ticket sales

- Average temperature

- Travel costs

- Number of venues

- Social media interest

Create a spreadsheet containing information on 5-6 cities can be real or fictious.

Column                     Description                                      Formula      

City                             Name of city 

Ticket Sales              Number of tickets sold                 =SUM(B2:B7)

Venues                      Number of venues in the city      =MAX(C2:C7)

Avg Temp (°C)         Weather during month      =AVERAGE(D2:D7)

Travel Cost £            Estimated cost to get there           =MIN(E2:E7)

Social Media            No. of followers        =SUMIF(C2:C7, \">2\", F2:F7)

Challenge Yourself: Use your spreadsheet skills to go beyond the basics.

________________________________________

Task: Add a column to label cities as:

• "High Potential" if Ticket Sales >1800 AND Venues >2

• "Low Potential" otherwise Formula Example: =IF(AND(B2>1800, C2>2),"High Potential”, “Low Potential")

________________________________________

Task: Find averages or counts based on conditions.

• "What is the average ticket sale for cities with more than 2 venues?"

• =AVERAGEIF (C2:C7,">2",B2:B7)

________________________________________

Task: Think of a new factor that matters in concert planning. Add it to the spreadsheet.

• Example: Hotel Costs, Public Transport Rating, Fan Club Size

• Recalculate your best city based on the new factor.

________________________________________

Task: Write a short paragraph or slide:

• State which city is best and why.

• Use data and formulas as evidence.

Sum	Sumif	Min
Max	If	Average

Formula bingo, I will say a statement, drag a tick to the correct box. Call 'DATA' when your card is complete.

What did you learn today?

What is one thing your still unsure about?

Would be better if...