120 likes | 209 Views
Todays Scenarios. Fitness Exercise Data (Conditional formatting). Shopping Exercise Data (Graphs). Selling Old Games Data (Decisions). FITNESS EXERCISE (BRIEF 1). Your spreadsheet records the following information for ten students: Student’s Name Student’s Form Student’s Age
E N D
Todays Scenarios • Fitness Exercise Data (Conditional formatting) • Shopping Exercise Data (Graphs) • Selling Old Games Data (Decisions)
FITNESS EXERCISE (BRIEF 1) • Your spreadsheet records the following information for ten students: • Student’s Name • Student’s Form • Student’s Age • Student’s Gender • Student’s Year Group • The names of at least five exercises undertaken • The maximum number of each exercise that the student has completed • The spreadsheet will need to: • Calculate the average number of each exercise across all the students • Indicate in the spreadsheet those students that are below the average for each exercise
SHOPPING EXERCISE (BRIEF 2) I have supplied a spreadsheet with the summary data on. Could you please use it to plot the following graphs for me. • A line graph showing the total number of visitors that came to the centre on each of the 14 days of the survey • A column chart comparing the number of men to the number of women that visited the centre on each of the 14 days of the survey • A pie chart showing, as percentages, the total number of people that visited each type in the 14 days • A bar chart showing the total amount of people that travelled by different transport methods over the 14 days • A line graph showing the number of visitors per day over the 14 day period for all the different shop types
Selling Games (BRIEF 3) A group of your friends have decided that they want to sell some of their old computer games. Each of them has different games to sell and there are four different shops in the town that would buy them. The friends have visited the shops and asked them how much they would pay for each game. Your friends have now asked you if you could construct a spreadsheet to help them decide which shop they should sell the games to. Set up formulas in the spreadsheet to do the following: • Work out the average price per game paid by each shop • Work out the maximum that each person can get for selling all their games • Indicate who will get the most money