todays scenarios n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Todays Scenarios PowerPoint Presentation
Download Presentation
Todays Scenarios

Loading in 2 Seconds...

play fullscreen
1 / 12

Todays Scenarios - PowerPoint PPT Presentation


  • 81 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Todays Scenarios' - kieve


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
todays scenarios
Todays Scenarios
  • Fitness Exercise Data (Conditional formatting)
  • Shopping Exercise Data (Graphs)
  • Selling Old Games Data (Decisions)
slide2

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
slide4

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