ICT and PSHE 11-14/KS3/Levels E&F
Kids will be offered at least five hours of school sport a week under government plans to get children more active.
Using spreadsheets, students devise a weekly exercise timetable for a fitness fanatic and a realistic one for themselves.
The number of calories used up doing different sports
How much exercise is good for you
How to plan a healthy exercise programme
Using spreadsheets: Adding using Autosum; inserting comments.
Read out this story to the class.
Ask students:How many hours a week of sport will be offered to students?
Will this be all in school time?
No. The sport will either take place in school time or in after school clubs.
How are the government helping?
They are spending half a billion pounds on more special sports colleges. Normal schools will be able to share the sports equipment and fields.
When are the government plans set to come in?
What reasons does the Prime Minister give for introducing more sport at school?
To cut the number of kids who are dangerously overweight. To help people learn how to win, lose and be part of a team.
What unusual school sports are named in the story?
Yoga and Tai Chi.
Which sports would you like to do at school?
Students click through the picture gallery of different forms of exercise or read the printable fact file. See below.
They work out, and write down, how many calories each sport uses in an hour. The figures quoted are for half an hour.
ICT activity: Students devise an exercise timetable for Mr or Miss Fitness Fanatic using a spreadsheet.
In the first column of a new spreadsheet, students write the days of the week. In A2 they write Monday, in A3 Tuesday etc. until Sunday in A8 and Total in A9.
In the first row, they write the hours of the day from 8am to 9pm. In B1 they write 8-9am, in C1 9-10am etc. up to 8-9pm in N1 and Total in O1.
Using the picture gallery or fact file and their own ideas, students write the names of sports played by Mr or Miss Fitness in the appropriate hour cells in the spreadsheet.
E.g. If Mr or Miss Fitness Fanatic plays football from 9am to 12 on a Saturday morning, students write Football in cells D7, D8 and D9.
Using their notes of calories used per hour, students replace the name of the sport with the number of calories used in that hour. For exercises which are not in the gallery or fact file, they make an educated guess about the number of calories used.
They add the name of the sport being played as a note (signified by a little red triangle in the top right hand corner of the cell). This is done by highlighting a cell, then right clicking on it and selecting the Insert Comment option.
Students use the Autosum tool to work out the total number of calories used each day, and the week's total.
Students create a weekly exercise timetable for themselves.
In a new spreadsheet, they type in the sports they do in PE lessons, in before and after-school clubs and in their own time.
Non-ICT activity: Students draw the timetables on paper.
The recommended daily calorie intake for the average man is around 2,500 calories and 2,000 for the average woman.
Students write a menu of the food Mr or Miss Fitness Fanatic would have to eat each day to remain a healthy weight?
Ask students:Do you do five hours of school sport a week (in PE lessons and before and after school clubs) as the government propose?
Do you exercise for 30 minutes, five days a week, like experts say you should?
If you answered No to either of these questions, what could you do increase the amount of exercise you do?
Students add their suggestions to their timetables to achieve a healthy weekly exercise plan.