ICT and PSHE 11-14/KS3/Levels E&F
Sportsround is a new TV show from CBBC. It will showcase some sports you may not know much about.
This could help get kids more active by encouraging them to participate in sport. Sportsround will be on BBC1 at 11.45 on Saturdays.
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 exercise a week do you get?
How much of this do you get from sport?
Which sports do you like or dislike?
How many different sports have you tried?
Is it really possible to hate all sports, or do people who say that really mean team sports?
What unusual sports would you like to try?
Are there any of these you could do at school?
What sports would be good to try if you are uncomfortable with your appearance?
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 exercise for 30 minutes, five days a week, like experts say you should?
If you answered No to this question, 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.