• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!


Collecting Data and Using it in a Spreadsheet

Page history last edited by Harold Olejarz 12 years ago

Eisenhower Middle School

Wyckoff, New Jersey



Mr. Bonavitacola Mr. DeBlock
Mr. Olejarz



Data Analysis and Presentation


Click Here To Login To Eisenhower Google Apps


Click here to learn more about Google Apps




Collecting Data and Using it in a Spreadsheet


1. Olympic Data Project


Use the link below to create a spreadsheet based on Olympic statistics.



Use this link for data that can be pasted into a Google Spreadsheet (use Command-C to copy and Command-V to paste the data into your Google spreadsheet) http://www.databaseolympics.com/


This search engine http://www.wolframalpha.com can find the population of a country for any year just enter population, country, year, so for the population of  France in 1920 type population France 1920 into the search box. To see an example of what your spreadsheet should look like click here.


Olympic Data Checklist - Data Analysis and Presentation


Olympic Data Checklist.pdf


Formulas and Formatting (5 points each = total 50 points)

  1. Header is filled in (Title and Name)
  2. Bold Column/Row headings
  3. Column Widths adjusted or Text Wrapped
  4. Total Medals calculated
  5. Average medals calculated
  6. Maximum medals calculated
  7. Minimum medals Calculated
  8. Decimals adjusted to whole numbers
  9. A grid is applied to the entire table
  10.  The text is centered in all of the cells


Sorting  (10 points each = Total 30 points)

  1. Sort alphabetically by country name
  2. Sort by year with the most gold medals (high to low)
  3. Sort by year with the highest total medals (high to low)


Graph (5 points each = 20 Points)

  1. Title
  2. X axis Labeled
  3. Y axis labeled
  4. Scale adjusted if necessary



Comments (0)

You don't have permission to comment on this page.