Teaching and Learning Quantitative Reasoning

**Quantitative Reasoning
Project 1: **

In this project you will create a spreadsheet which keeps track of your grade in this Math 50 class. In addition to simply recording all of your grades for the course, it will provide you with a “**running tally**” of how you are doing in the course at any point in time during the semester.

**1. (5%)** What does “running tally” mean? To help you understand this, compute the grade of a student with an 8.2 HW average, 7.3 Quiz average, a 92 on Project 1 and a 93 on the first exam. Use the syllabus to determine the **appropriate weights** for each category and enter a formula in a spreadsheet to compute their grade. Re-compute their grade assuming they get a 95 on Project 2. Insert a textbox into the spreadsheet and record both grades in the textbox. Are you surprised by their grades? Explain what weights dominate at this point in the semester.

**2. (10%)** Create a new sheet in the spreadsheet from part **1** which will allow you to enter all of your grades for this Math 50 course. To start, **you may make up** grades **for some** but **not all** of the possible assignments (so enter the HW and quiz grades you already have, and make up 2 projects and make up 1 exam grade). There should be **nicely labeled spaces** J for all of the following work:

- Assume there will be 12
**HW**assignments for article questions and 12 HW assignments for Excel Problems and 12 HW assignments for written Exercises. HW graded 0-10 points. - Assume there will be 12
**quizzes**on the articles and 12 quizzes on the Exercises. Quizzes graded 0-10 points. - There will be 5 projects.
**Projects**graded 0-100 points. - There will be 2 exams.
**Exams**graded 0-100 points.

3. **(10%)** Create cells which will compute the **average** HW grade, average quiz grade, average project grade, and average exam grade. **Name** these cells appropriately, so if used in a formula the name will appear not the cell reference.

** 4.** **(10%)** Create cells which will **count** the number of HW grades entered so far, count the number of quiz grades, number of project grades, and number of exam grades. **Name** these cells appropriately, so if used in a formula the name will appear not the cell reference.

** 5**. **(5%)** Create cells which will compute the **max** and **min** grades for each of the 4 categories: HW, quiz, project, and exam.

** 6.** **(20%)** Create a **Histogram** of your HW grades and your Quiz grades (you may put both in one chart). You must choose appropriate bin sizes so that there is more than one column in your chart. Keep the chart next to where you enter grades, not on a separate sheet, so when you enter your grades the columns will change… WOOOHOOOO!

**7.** **(5%) Format** all of this nicely with borders and shading J Try to arrange so that it all fits onto one screen when Excel is opened to the max width of the monitor screen.

**8.** **(20%) **Create a cell which computes your total grade using the ideas of **weighted average** as discussed in class. The formula must take into account the “counts” of your grades. This formula must be linked to all of your input cells, so when you enter a grade it automatically updates.

You may use the **average** for the HW and Quizzes as counting for the full weight of that category, **but** you must **weight each** project and exam individually.

**9. (10%)** Create a cell which computes the **highest possible average** you can get in the class. You may assume your HW and Quiz averages are fixed (you can use the averages on the sheet) but you should assume that you get a 100 on all remaining projects and exams. To do this you will once again have to **count** the number of projects and exam grades entered so far.

**10. (5%) Enter ONLY **your grades for the semester so far, your total grade formula should give you your grade at this point in the semester. If you get an error try again!

%d bloggers like this:

## Discussion

## No comments yet.