1 / 12

Todays Scenarios

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

kieve
Download Presentation

Todays Scenarios

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Todays Scenarios • Fitness Exercise Data (Conditional formatting) • Shopping Exercise Data (Graphs) • Selling Old Games Data (Decisions)

  2. 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

  3. 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

  4. LINE GRAPH

  5. COLUMN CHART

  6. PIE CHART

  7. BAR CHART

  8. LINE GRAPH #2

  9. 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

More Related