Skip to main content
guest
Join

Help

Sign In
Forrester High School Computing
Home
guest

Join

Help

Sign In
Wiki Home
Recent Changes
Pages and Files
Members
Courses
Computing Science Courses
S1 CfE Computing
S2 CfE Computing
S3 CfE Computing
National 4 Computing Science
National 5 Computing Science
Higher Computing Science
Advanced Higher Computing Science
Computer Games Development Courses
NPA Computer Games Development
S3 Computer Games Development
Enrichment Courses
Web Design and Development Enrichment
Code Academy
Coding
Other
Office 365
Useful Links
Online Tools
Miscellaneous
Templates
Admin
Course Pathways
Course Plans and Arrangements
Cover
Old courses
Past Courses
2012 Olympic Games Medals Table
Edit
0
3
…
0
Tags
No tags
Notify
RSS
Backlinks
Source
Print
Export (PDF)
The final medals table for the 2012 Olympic Games in London is as follows:
Task 1
Produce a spreadsheet which shows this information
Task 2
Sort the table by country name in alphabetical order
Task 3
Watch this video which shows
how to create formulas in Excel
Task 4
Add a column which uses a formula to calculate the total number of medals won by each country in the table.
Task 5
Sort the table by the total number of medals won
Task 6
Add a column which uses a formula to calculate points for each country as follows:
Gold medal = 3 points
Silver medal = 2 points
Bronze medal = 1 point
Task 7
Sort the table by the total points as calculated in Task 6 above
Javascript Required
You need to enable Javascript in your browser to edit pages.
help on how to format text
Turn off "Getting Started"
Home
...
Loading...
Task 1
Produce a spreadsheet which shows this information
Task 2
Sort the table by country name in alphabetical order
Task 3
Watch this video which shows how to create formulas in Excel
Task 4
Add a column which uses a formula to calculate the total number of medals won by each country in the table.
Task 5
Sort the table by the total number of medals won
Task 6
Add a column which uses a formula to calculate points for each country as follows:
Task 7
Sort the table by the total points as calculated in Task 6 above