Eisenhower Middle School

Wyckoff, New Jersey

Computer Technology 7-1

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 links below to create a spreadsheet based on Olympic statistics.

Use this link

http://www.olympic.org/uk/games/index_uk.asp

Back-up Link

http://www.databaseolympics.com/

Olympic Data Checklist

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