Lesson video

Hi there, welcome to your lesson.

Today's lesson is on the data analysis of engagement patterns.

My name's Ms. Hackin and I'm really looking forward to being your teacher today.

By the end of today's lesson, I'm hoping that we can interpret data and graphs relating to participation in sport and physical activity.

Our keywords today, x-axis is a horizontal axis on a bar or line graph.

So it's the one that goes along the bottom.

A y-axis is a vertical axis on a bar or line graph, the one that goes from the bottom upwards.

A pie chart is a circular graph divided into sectors, each representing a proportion of a whole.

So it's often thought of as a pie.

And the segments of the pie are the sections of data that it's representing.

And a bar chart is a chart or graph that represents categorical data with rectangular bars with heights or lens proportional to the values that they represent.

And this might be the type of graph that you've seen a lot of already.

So today's lesson is split into three parts.

In the first part, we're going to be looking at how we interpret data relating to participation as data is often given to us in numerical form, and we see this in tables.

In the second part of today's lesson, we're going to be interpreting graphs relating to participation.

So often data is easier to read when it's portrayed in a graph, and trends are easier to spot as a result of being shown in a graph.

And in the third part of today's lesson, we're going to be plotting graphs relating to participation.

So being given some data and then producing a graph from that data by plotting the data on the graph.

Let's get started.

So data are facts and statistics collected together for reference or analysis.

Analysing participation trends helps identify who is physically active and what activities they engage in.

So it's really useful for funding or campaigns, for Sport England for the Youth Sport Trust to identify who is participating in physical activity and what people are engaging in.

Now it's important from that data to read who is not also being physically active so that funding campaigns and initiatives can be put towards those people to try and get them more physically active.

Data can be presented as numbers in a table or graphs.

Here are two examples of how data can be presented.

Okay, let's have a go to check, shall we? Why is it important to analyse data about participation trends? A, to identify how people are physically active.

B, to compare how much different sports cost C, to identify who is physically active or D, so that graphs can be used in a sport active survey.

I'm hoping that you ticked both A and C, so we need to identify how people are physically active and who is physically active so that we can identify participation trends and identify which type of people may need more support in being physically active.

So the data below shows a percentage of participants who use a gym according to age.

In the first column are the age groups of different participants, and in the second column are the numbers, the percentages of people that participate from that age group.

So let's have a go at some questions about this data.

Which age group has the highest participation rate at the gym? I'm hoping that you spotted it was the 18 to 25 year olds.

This is because they have 74%, the highest number of percentage of participants participating at the gym, so therefore, they have the highest participation rate.

Can you now tell me which age group has the lowest participation rate? Yeah, I'm hoping you spotted that it was anyone over the age of 55 has the lowest participation rate as that was only 4% of the gym members were over 55.

Okay, and with that information, can you now suggest a participation trend from this data? Okay, I'm hoping that you've spotted that the highest participation rate was the youngest group and the lowest participation rate was the oldest group.

So that you may have written something along these lines that the data indicates that gym participation decreases with age.

You've just analysed your first piece of data by answering those questions, you were able to analyse the data in the table.

Well done.

Let's have another go together.

The data below shows a number of year nine students that took part in different extracurricular activities.

You can see the column on the left is the types of extracurricular activities that were involved in this survey.

And you can see the column on the right is a number of participants that took part in each of the activity.

So let's have a go at some questions.

Which extracurricular activity has the highest number of participants? I'm hoping that you spotted, it was the badminton club because the badminton club had 32 participants and all the other clubs had less than 32.

Therefore, badminton club had the highest participation rate.

Okay, which extracurricular activity has the lowest number of participants? Yeah, I'm hoping you spotted that trampolining had the lowest number of participants with only 12 participants.

All the other clubs had more participants, so therefore, trampolining had the lowest participation rate.

So now you've looked at the data initially.

Can you now suggest a participation trend from this data? I'm hoping you've spotted that the data shows that badminton is the most popular extracurricular activity for year nine with trampolining being the least popular.

You may have even added a little bit more and said that netball was a second popular activity and table tennis was either the third popular or the second least popular activity, but that just shows that you are looking at the data and you are analysing what you see.

Well done.

Okay, let's have a go to check.

Which image shows that cricket has the lowest amount of participants.

Is it A, B, or C? That's right, it's B.

It's B because cricket has 75 participants.

But compared to softball, tennis, and tag rugby, that is the least amount of participants compared to the other clubs.

Whereas in the other ones, there is another sport, another activity that has less participants than cricket.

So B is the correct answer.

Okay, now it's your turn to have a practise on your own.

The table below shows a number of members in a golf club according to socioeconomic status.

In the left column is a level of socioeconomic status, and in the right column is a number of participants at the golf club.

The first thing I'd like you to do is analyse the data.

Can you spot any participation trends? The second thing I'd like you to do is suggest reasons for this data and why it might be the way it is.

And the third thing I'd like you to do is suggest ways to change this data.

You may wish to pause the video now to give yourself time to complete the task.

Okay, so the first part of the question, you are asked to analyse the data below.

I'm hoping that you've spotted something along these lines that the data indicates that participation at this golf club decreases with lower socioeconomic status.

And you might have said it the other way round.

So the data indicates that participation at this golf club increases with higher socioeconomic status.

They are both correct and well done if you spotted that trend.

The second part of the task, you were asked to suggest reasons for this.

Now you might have put something along these lines that golf memberships, green fees and equipment are expensive, making them less accessible to individuals with less disposable income.

This means they're less likely to join a club.

So playing golf can be expensive because they've got all the clubs to buy and they've got high membership costs.

So therefore, people with lower disposable income or lower socioeconomic status are less likely to participate.

Well done, if you said something along those lines.

And finally, suggest ways to change this data.

Now you may have put that the golf club could offer discounted rates or pay-as-you-play options to reduce the need for full membership commitments.

Additionally, they could provide club rentals to eliminate the need for expensive equipment purchases.

So if you've talked about how we could do pay-as-you-play or hire out equipment to help reduce costs, then well done.

That's really good way to change the outcome of what this data is suggesting.

Okay, we're now going to move on to the second part of today's lesson.

We're going to look at interpreting graphs relating to participation.

Graphs effectively present participation trends by visually highlighting patterns, comparisons and changes over time, making the data easier to interpret and understand.

Let's have a go to check.

Which is not a benefit of using graphs to show participation trend data? I'm just gonna repeat that question, which is not a benefit of using graphs to show participation trend data? Is it A, highlights patterns? Is it B, shows changes over times? Is it C, makes comparisons visually easier or is it D, provides reasons for participation trends? It's D because a graph does highlight patterns.

It does show changes over times.

It does make comparisons visually easier.

It does show participation trends, but it doesn't provide reasons for the participation trends.

Well done if you got that right.

So the graph below shows a percentage of people who took part in a marathon based on their ethnicity.

Let's have a go at some questions.

Identify the ethnicity that had the highest participation rate in the marathon.

I'm hoping that you've spotted that it was the mixed group had the highest participation rate in the marathon.

Now you know it's a mixed group because you can see from the key that the mixed is the blue colour and on the graph, the biggest section is that blue colour.

So that shows that more participations from that blue colour, which was a mixed category, participated in the marathon.

Can you now identify the ethnicity that had the lowest participation rate in this marathon? Now, it might not be a hundred percent clear for you all to see, so I'm hoping that you can all see this, but the answer would be the Asian excluding Chinese category.

They had the lowest participation in this marathon.

So you can see on the key that the Asian excluding Chinese is the lightest blue and therefore, the lightest blue has the smallest segment on the circle.

So therefore, they have the lowest participation trend.

Well done if you've got that right.

Okay, the graph below shows a percentage of people who participated in different activities according to gender.

So here we have a bar chart and we have four activities along the x-axis along the bottom.

And then we have a key.

So the blue column is a number of females that took part in that activity, and a red column is a number of males that took part in that activity.

So let's have a go at analysing this data.

Can you identify the most popular activity for females? The most popular activity for females is body pump and we can easily see that because the highest, the longest and biggest blue rectangle, which is what the females are being represented by the blue colour is in body pump.

As you can see that there are 20 participants that are female at body pump.

Identify the least popular activity for females.

So the least popular activity for females was boxercize as that's got the smallest blue bar are going just over five, so probably six participants were female.

Can you identify the most popular activity for males? The most popular activity for males was yoga.

And again, you can see that by the biggest red column because red is a colour that is representing the males.

The biggest red column is at yoga with 14 participants, which is more than any other of the red columns or any other of the activities.

Identify the least popular activity for males.

The least popular activity for males was Zumba, and we can see that by seeing the smallest red column, which is really clear to see is the Zumba column.

Well done if you got those correct.

Okay, here is an example of a line graph.

This line graph displays a participation trend over seven years comparing a number of people in a hiking group to the number of people at the gym.

The hiking group are represented by the purple line as we can see in the key.

And the gym participants are represented by the orange line that we can see.

So using the graph below, can you answer the following questions? Which group had the highest participation in 2018? So you would look along the x-axis to where it said 2018, and then you would go up to see which line was higher.

Is it the orange line or the purple line? I'm hoping that you spotted that it was the orange line and therefore, the gym participants had higher participation compared to the hiking participants in 2018.

So which group had the lowest participation in 2020? Again, go along the x-axis to 2020 and then go up.

And this time, we are looking for the lowest participation trend.

So the first line you get to as you're going up, is it the orange or the purple? Yeah, I'm hoping that you noticed it was the orange line.

So again, in 2020, the lowest participation was the gym participants.

Now I wonder if you can suggest a reason for this because the gym participants had the highest participation rate in 2018, but they went the lowest in 2020.

Perhaps some of you remembered what happened in 2020 and how this might have affected whether people went to the gym or not.

Well done if you put something along the lines of COVID-19 prevented people going to the gyms in 2020.

Therefore, gym participation definitely got lower in 2020 compared to 2018.

Okay, now it's your turn to have a go to practise task.

The graph below shows a number of participants in each activity according to gender.

Analyse the data on the graph.

You may wish to pause a video now to give yourself time to complete the task.

Okay, so the graph below shows a number of participants in each activity according to gender.

Analyse the data on the graph.

You may have put a number of things here.

You might have said that girls have highest participation rates in BMXing.

Boys have lowest participation rates in BMXing.

Boys have highest participation rates in skateboarding.

Girls have lowest participation rates in scooting.

Skateboarding has the highest overall participation and scooting has the lowest overall participation.

Well done if you put any of those participation trends down and well done on analysing the data from the graph.

We are now moving on to the final part of today's lesson.

We're going to plot graphs relating to participation.

Sometimes you might be giving data to plot your own graph, therefore, you always need to remember to use a ruler and a pencil when plotting data.

Sometimes you may be given the data to plot your own graph, and it's always useful to have a ruler and a pencil when plotting data.

You may need other maths equipment too.

Maybe a protractor if you are doing a pie chart.

Let's have a go, a quick question to check you know the minimum equipment you need for plotting a graph.

Can you tell me what is the minimum equipment required for plotting a graph? That's right, it's a ruler and pencil.

I hope you found that easy.

The data below shows the ages of participants who are members of a swimming club.

The first column shows the age groups and the second column shows a number of participants from each age group that are members at the swimming club.

Your task is to complete the graph using the data.

You may wish to pause this video now to give you time to complete that graph.

Well done if you notice that on this bar graph, the column for the 55 and over group was missing, therefore, that was what you needed to add on.

Now in order to do this, you needed to find 21 on the y-axis move along and draw your column that was up to 21, so it represented 21 participants like this.

Well done if you got that right.

Okay, this data shows a number of participants at a lacrosse club over five years.

Here's a graph that starts to represent this data.

Firstly, can you add labels to the axis based on the data table? Well done if you remember to put year along the x-axis and number of participants along the y-axis.

For the second part of this task, I'd like you to complete the graph using the data.

I'm hoping that you've done something like me where you've seen that the data missing is for 2023 and 2024.

And for both those years, the number of participants were 40.

So I'm hoping that you found 40 on the y-axis and you've gone a long to 2023 and 2024.

You've put a point at 2023 at 40 and a point at 2024 at point 40.

And then you've used a ruler to draw your lines.

And I'm hoping that your lines are joined, not like my line to show you.

I'm hoping that your line is all one line that moves over the graph.

Well done if you've got that right.

So now it's your turn to have a go at plotting a graph relating to participation.

So below is data identifying the physical activities that a group of teenagers with disabilities took part in.

So on the left is a number of participants that took part in each of the activities on the right.

The first thing I'd like you to do is to plot the data on a bar graph.

The second thing I'd like you to do is analyse a graph to suggest participation trends.

You may wish to pause a video now to give you time to complete this task.

So first part of the task, you are asked to plot the data on the bar graph, and I'm hoping your bar graph looks a little bit like mine with the x-axis labelled with activity and the y-axis labelled as number of participants.

You may have put different numbers up the y-axis and that's okay.

I went up in fives, but you might have gone up in different numbers.

That's okay.

Along the x-axis, I hope you've labelled all of the activities that were in the table.

For the second part of the task, you are asked to analyse a graph to suggest participation trends.

Maybe you've written something along these lines.

Swimming is the most popular activity for this group as it has the highest amount of participants, and that's really easy to see on the graph as it has the highest column.

The least amount of participants were involved in wheelchair rugby compared to the other activities.

And again, you'll have noticed this on the graph as this would've had the smallest column.

Well done if you mentioned any of those.

So that just leaves us enough time to summarise today's lesson.

So data are facts and statistics collected together for reference or analysis.

Data can be presented as numbers in a table or graphs.

Analysing participation trends helps identify who is physically active and what activities they engage in.

Presenting data in graphs makes the data easier to interpret and understand as it enables patterns to be highlighted, comparisons to be made and changes over time to be seen and ultimately shows us the participation trends that are occurring.

Well done today.

You've worked really hard.

Thanks for another great lesson and I look forward to seeing you soon.