Olympic+Medal+Tally



Main Objective : To further develop students knowledge of Excel while improving their graphing skills utilizing the "many-eyes" website.


 * Goal:**
 * 1) To practice internet data collection and entering or copying data into an Excel spreadsheet;
 * 2) To learn to how to organize and sort data within a spreadsheet;
 * 3) To perform mathematical calculations within Excel on a data set;
 * 4) To learn how to graph data using many-eyes website;
 * 5) To analyze data and come up with conclusions based on the graphs;
 * 6) Extra points for turning in your work early!
 * Materials:**


 * 1) Excel Software Package
 * 2) Many-Eyes Website []
 * 3) Internet website for data collection: [|http://www.vancouver2010.com]


 * Instructions:**

Now that you have experience working on in Excel and created a chart last week on the medal standings, you are ready for the next step! Instead of creating a bar graph, I would like you to practice your graphing skills by creating a world map in a different program, called "many-eyes." Your maps should highlight which countries won the most winter medals in past Olympics. I have done a sample map for you of this year's medal results from Vancouver for you. You can find it at:

[]

Now its your turn to create a similar map using historical Olympic data. You need to research historical medal tallies found at the internet website [|http://www.vancouver2010.com]

media type="custom" key="5517073"

Once you are at the website, click on "medals" and then click on "historical medals." Under historical medals you can see medal results from past winter Olympics.

Your Task:


 * Pick 5 different winter Olympics and chart the medal results;
 * <span style="font-family: 'Comic Sans MS',cursive;">Create 5 simple spreadsheets for each Olympic year results (you can use this year's if you like);
 * <span style="font-family: 'Comic Sans MS',cursive;">Go to the many-eyes website;
 * <span style="font-family: 'Comic Sans MS',cursive;">Create 5 world maps with your results (using handout or class notes);
 * <span style="font-family: 'Comic Sans MS',cursive;">Save your graphs and print them out;
 * <span style="font-family: 'Comic Sans MS',cursive;">Analyze your results and do some research:
 * <span style="font-family: 'Comic Sans MS',cursive;">At the bottom of each graph, provide explanations for the US perfomance in each year;
 * <span style="font-family: 'Comic Sans MS',cursive;">Provide explanations for the top performer in that year;
 * <span style="font-family: 'Comic Sans MS',cursive;">Provide 3 interesting facts about the medal results for that year;

Assessment: <span style="font-family: arial,helvetica,sans-serif; font-size: 13px; font-weight: normal; line-height: 19px;"> <span style="font-family: 'Comic Sans MS',cursive; font-size: 14px;">You will be graded based on the following rubrik criteria as discussed in class. I am looking for a good understanding of Excel, and an organized and accurate spreadsheets and maps. I would like to see a good analysis of the the maps and explanations for the top achieving countries, for US performances and interesting facts.

(15 pts.) || <span style="background-color: #fefcd2; font-family: 'Comic Sans MS',cursive; font-size: 14px;">Student's charts and/or maps are disorganized with missing headers and labels. Charts or maps are difficult to read. || <span style="background-color: #fefcd2; font-family: 'Comic Sans MS',cursive; font-size: 14px;">Student's charts and/or maps have missing information, labels and/or errors. But overall readability is okay. || <span style="background-color: #fefcd2; font-family: 'Comic Sans MS',cursive; font-size: 14px;">Student's charts and maps have no missing labels or errors. Overall readability is very good. || <span style="background-color: #fefcd2; font-family: 'Comic Sans MS',cursive; font-size: 14px;">Student's charts and maps are organized and clear. They are clear and easy to read. ||  || (50 pts.) || <span style="background-color: #c9fdf3; font-family: 'Comic Sans MS',cursive;">Student has difficulty with Excel and/or many-eyes. Student does not have a good understanding of creating charts or maps, incorrect charts/maps. Poor Analysis. || <span style="background-color: #c9fdf3; font-family: 'Comic Sans MS',cursive;">Student has a fair understanding of Excel and many-eyes. Understands the programs but has miscalculations. Fair Analysis. || <span style="background-color: #c9fdf3; font-family: 'Comic Sans MS',cursive;">Student shows good use of Excel and many-eyes. Complete charts and maps. Good analysis. || <span style="background-color: #c9fdf3; font-family: 'Comic Sans MS',cursive;">Student demonstrates excellent use of Excel and many-eyes. Calculations are correct. Anaylsis is detailed and correct. Bonus points for effort! ||  || ** <span style="background-color: #f4e3fc; font-family: 'Comic Sans MS',cursive;">(15 pts.) || <span style="background-color: #f4e3fc; font-family: 'Comic Sans MS',cursive;">Student did not complete the tables or maps. Work is only partially completed. Missing graphics. || <span style="background-color: #f4e3fc; font-family: 'Comic Sans MS',cursive;">Student completed basic charts and maps but could have used more effort. || <span style="background-color: #f4e3fc; font-family: 'Comic Sans MS',cursive;">Student had good complete charts and maps. Good use of colors. Good effort. || <span style="background-color: #f4e3fc; font-family: 'Comic Sans MS',cursive;">Student had great charts and maps. Enhanced work with colors and or clipart. Put forth extra effort. ||  || (10 pts.) || <span style="background-color: #c6fbd8; font-family: 'Comic Sans MS',cursive;">Student's work has four or more errors, miscalculations or missing data. || <span style="background-color: #c6fbd8; font-family: 'Comic Sans MS',cursive;">Student's work has two to three errors, miscalculations or missing data. || <span style="background-color: #c6fbd8; font-family: 'Comic Sans MS',cursive;">Student's work has no more than one error, miscalculation and missing data. || <span style="background-color: #c6fbd8; font-family: 'Comic Sans MS',cursive;">Student's work has no miscalculations, missing data or errors. ||  || (10 pts.) || <span style="background-color: #d5d3fd; font-family: 'Comic Sans MS',cursive;">Student did not complete the project within an appropriate time. || <span style="background-color: #d5d3fd; font-family: 'Comic Sans MS',cursive;">Student turned in the project a day late. || <span style="background-color: #d5d3fd; font-family: 'Comic Sans MS',cursive;">Student completed the project on time. || <span style="background-color: #d5d3fd; font-family: 'Comic Sans MS',cursive;">Student completed the project early and submitted the project early! ||  ||
 * ||  ||   ||   ||   ||   || <span style="font-family: 'Comic Sans MS',cursive;">** 100 Points ** ||
 * || <span style="font-family: 'Comic Sans MS',cursive;">** 1 (Poor) ** || <span style="font-family: 'Comic Sans MS',cursive;">** 2 (Average) ** || <span style="font-family: 'Comic Sans MS',cursive;">** 3 (Above Average) ** || <span style="font-family: 'Comic Sans MS',cursive;">** 4 (Outstanding) ** ||  ||
 * <span style="font-family: 'Comic Sans MS',cursive; font-size: 14px;">**<span style="background-color: #fefcd2; font-family: 'Comic Sans MS',cursive; font-size: 16px;">Organization ** <span style="background-color: #fefcd2; font-family: 'Comic Sans MS',cursive; font-size: 14px;">
 * <span style="font-family: 'Comic Sans MS',cursive;">**<span style="background-color: #c9fdf3; font-family: 'Comic Sans MS',cursive;">Content Knowledge ** <span style="background-color: #c9fdf3; font-family: 'Comic Sans MS',cursive;">
 * <span style="font-family: 'Comic Sans MS',cursive;">** Graphics/Maps
 * <span style="font-family: 'Comic Sans MS',cursive;">**<span style="background-color: #c6fbd8; font-family: 'Comic Sans MS',cursive;">Accuracy ** <span style="background-color: #c6fbd8; font-family: 'Comic Sans MS',cursive;">
 * <span style="background-color: #d5d3fd; font-family: 'Comic Sans MS',cursive;">**Punctuality**
 * ||  ||   ||   || <span style="font-family: 'Comic Sans MS',cursive;">**Total Points (Your Grade)** ||   ||   ||   ||   ||   ||   ||   ||

(15 pts.) || <span style="background-color: #fefcd2; font-family: 'Comic Sans MS',cursive; font-size: 14px;">Student's chart and/or graph is disorganized with missing headers and labels. Chart is difficult to read. || <span style="background-color: #fefcd2; font-family: 'Comic Sans MS',cursive; font-size: 14px;">Student's chart and/or graph has missing information, labels and/or errors. But overall readability is okay. || <span style="background-color: #fefcd2; font-family: 'Comic Sans MS',cursive; font-size: 14px;">Student's chart has no missing labels or errors. Overall readability is very good. || <span style="background-color: #fefcd2; font-family: 'Comic Sans MS',cursive; font-size: 14px;">Student's charts and graph are organized and clear. They are easy to read and have a creative use of clipart and graphics. ||  || (50 pts.) || <span style="background-color: #c9fdf3; font-family: 'Comic Sans MS',cursive;">Student has difficulty with Excel. Student does not have understanding of mean, median and mode; incorrect calculations || <span style="background-color: #c9fdf3; font-family: 'Comic Sans MS',cursive;">Student has a fair understanding of Excel. Understand mean, median, mode and range but has a miscalculation. || <span style="background-color: #c9fdf3; font-family: 'Comic Sans MS',cursive;">Student shows good use of Excel. Good graph and good word problems. || <span style="background-color: #c9fdf3; font-family: 'Comic Sans MS',cursive;">Student demonstrates excellent use of Excel. Calculations are correct. Word problems are detailed and correct. Bonus points for 2 step problems! Great graphics. ||  || (10 pts.) || <span style="background-color: #c6fbd8; font-family: 'Comic Sans MS',cursive;">Student's work has four or more errors, miscalculations or missing data. || <span style="background-color: #c6fbd8; font-family: 'Comic Sans MS',cursive;">Student's work has two to three errors, miscalculations or missing data. || <span style="background-color: #c6fbd8; font-family: 'Comic Sans MS',cursive;">Presentation has no more than one error, miscalculation and missing data. || <span style="background-color: #c6fbd8; font-family: 'Comic Sans MS',cursive;">Presentation has no miscalculations, missing data or errors. ||  || (10 pts.) || <span style="background-color: #d5d3fd; font-family: 'Comic Sans MS',cursive;">Student did not complete the project within an appropriate time. || <span style="background-color: #d5d3fd; font-family: 'Comic Sans MS',cursive;">Student turned in the project a day late. || <span style="background-color: #d5d3fd; font-family: 'Comic Sans MS',cursive;">Student completed the project on time. || <span style="background-color: #d5d3fd; font-family: 'Comic Sans MS',cursive;">Student completed the project early and submitted the project early! ||  ||
 * ||  ||   ||   ||   ||   || <span style="font-family: 'Comic Sans MS',cursive;">** 100 Points ** ||
 * || <span style="font-family: 'Comic Sans MS',cursive;">** 1 (Poor) ** || <span style="font-family: 'Comic Sans MS',cursive;">** 2 (Average) ** || <span style="font-family: 'Comic Sans MS',cursive;">** 3 (Above Average) ** || <span style="font-family: 'Comic Sans MS',cursive;">** 4 (Outstanding) ** ||  ||
 * <span style="font-family: 'Comic Sans MS',cursive; font-size: 14px;">**<span style="background-color: #fefcd2; font-family: 'Comic Sans MS',cursive; font-size: 16px;">Organization ** <span style="background-color: #fefcd2; font-family: 'Comic Sans MS',cursive; font-size: 14px;">
 * <span style="font-family: 'Comic Sans MS',cursive;">**<span style="background-color: #c9fdf3; font-family: 'Comic Sans MS',cursive;">Content Knowledge ** <span style="background-color: #c9fdf3; font-family: 'Comic Sans MS',cursive;">
 * <span style="font-family: 'Comic Sans MS',cursive;">** Graphics ** <span style="background-color: #f4e3fc; font-family: 'Comic Sans MS',cursive;">(15 pts.) || <span style="background-color: #f4e3fc; font-family: 'Comic Sans MS',cursive;">Student did not complete the table or graphs. Work is only partially completed. Missing graphics. || <span style="background-color: #f4e3fc; font-family: 'Comic Sans MS',cursive;">Student included basic and few clipart, or graphics and could have used more. || <span style="background-color: #f4e3fc; font-family: 'Comic Sans MS',cursive;">Good use of clipart, photos, and graphics. || <span style="background-color: #f4e3fc; font-family: 'Comic Sans MS',cursive;">Great use of clipart, photos, graphics and greatly enhanced work. ||  ||
 * <span style="font-family: 'Comic Sans MS',cursive;">**<span style="background-color: #c6fbd8; font-family: 'Comic Sans MS',cursive;">Accuracy ** <span style="background-color: #c6fbd8; font-family: 'Comic Sans MS',cursive;">
 * <span style="background-color: #d5d3fd; font-family: 'Comic Sans MS',cursive;">**Punctuality**
 * ||  ||   ||   || <span style="font-family: 'Comic Sans MS',cursive;">**Total Points (Your Grade)** ||   ||   ||   ||   ||   ||   ||   ||