Olympic+Medals+Race





 Main Objective : To familiarize the students with the Excel program and to teach them how to use it as a tool to solve mathematical problems.


 * 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 including addition, mean, median and mode;
 * 4) To learn how to graph data making a bar graph using Excel graphing/charting capabilities;
 * 5) To analyze data and come up with conclusions based on the graphs;
 * 6) To create 5 alegraic math word problems based on the graphs.
 * 7) To incorporate creativity into your project including graphics, clipart, photos, etc.
 * 8) Extra points for turning in your work early!
 * Materials:**


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


 * Instructions:**

We will be going over this flow work chart together in class. Please view the flow chart of instructions here below. Click on the .pdf file and zoom in to read the instructions:

OR  If you have any questions, please contact me. The following is a sample excel sheet showing what your Excel Spreadsheet should look like. You need to fill in the data in the cells with the questions marks. "?"

<span style="font-family: 'Comic Sans MS',cursive; font-size: 110%;">When you have completed your Excel Spreadsheet, you need to graph your data and it is called "Chart" under the header Data. Try to make your graph colorful and interesting. It should look something like this:

Once you have completed your graph, you need to analyze the information and create 5 algebraic word problems about your graph. Please include them at the bottom of your table. Bonus points for two step word problems!

For simple example and an algebraic expression assuming (g) = gold, (s) = silver, (b) = bronze, and (t) total medals:

Which country has three times as many medals as Austria?

<span style="color: #ff0000; display: block; font-family: 'Comic Sans MS',cursive; font-size: 110%; text-align: center;">(x) = 3 * Austria (t) ?

Your answer is the USA. We have 15 medals and Austria has 3.

<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, an organized and accurate spreadsheet and chart. I would like to see an imaginative use of graphics and 5 correct and well thought out word problems.
 * <span style="font-family: 'Comic Sans MS',cursive; font-size: 110%;"> Assessment:

** (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)** ||   ||   ||   ||   ||   ||   ||   ||