PROJECT 1: Weighted Average Gradebook

Student Guide

 

How to create the Excel Weighted Gradebook Project:

 

• Open the Excel program
• Click to place your cursor in the first cell (A1)
• In that cell type “Homework”
  • Enter the homework scores in column A, one score in each cell. (scores are found on your Project Description, p. 2)
  • You can use arrows, your mouse, or the enter key to move up and down.
• Move over to the next column (B)
  • Type “Quizzes” in that cell (B1)
  • Enter the quiz scores in column B, one quiz score in each cell.
• Move over to the next column (C)
  • Type “Papers” in that cell (C1)
  • Enter paper scores in column C, one score in each cell.
• Move over to the next column (D)
  • Type “Midterm” in that cell (D1)
  • Enter the midterm score in cell (D2)
• Move over the next column (E)
  • Type “Final” in that cell (E1)
  • Enter the final score in cell (E2)

 

Your spreadsheet should now look like this:

 

 

 

Next we are going to set up the weights for our calculations:

 

• Click on cell G3, and in that cell type “Homework”
  • In cell H3 type “10%”
• In cell G4 type ”Quizzes”
  • In cell H4 type “10%”
• In cell G5 type “Papers”
  • In cell H5 type “25%”
• In cell G6 type “Midterm”
  • In cell H6 type “25%”
• In cell G7 type “Final”
  • In cell H7 type “30%”

 

Your spreadsheet should now look like this:

 

 

 

 

Next we are going to use Excel to calculate the average for each category:

 

• Calculate the average homework score:
  • Put your cursor in I3
  • Type  (A2:A13)
  • Press Enter.  The calculated homework average will appear in I3.
• Calculate the average quiz score:
  • Put your cursor in I4
  • Type (B2:B11)
  • Press Enter.  The calculated quiz average will appear in I4.
• Calculate the average paper score:
  • Put your cursor in I5
  • Type (C2:C3)
  • Press Enter.  The calculated paper average will appear in I5.
• Include the midterm score
  • Put your cursor in I6
  • Type   (You must use a formula here!  Do not just type in the score)
  • Press Enter.  The midterm score will appear in I6.
• Include the final exam score
  • Put your cursor in I7
  • Type   (You must use a formula here!  Do not just type in the score)
  • Press Enter.  The final score will appear in I7.

 

 

Your spreadsheet should now look like this:

 

 

 

 

Now we are going to calculate the weighted average:

 

• Multiply the homework weight by the homework average.
  • Place your cursor in J3. Type  *I3  then Enter
• Multiply the quiz weight by the quiz average.
  • Place your cursor in J4.  Type  *I4  then Enter
• Multiply the paper weight by the paper average.
  • Place your cursor in J5.  Type  *I5  then Enter
• Multiply the midterm weight by the midterm score.
  • Place your cursor in J6.  Type  *I6  then Enter
• Multiply the final weight by the final score.
  • Place your cursor in J7.  Type  *I7  then Enter
• Add the products to calculate the weighted average.
  • Place your cursor in I8.  Type Final Grade.
  • Place your cursor in J8.  Type (J3:J7)

 

Your spreadsheet should now look like this:

 

 

 

 

 

 

 

You will now need to write the reflection paper.  Make sure to answer all of the questions listed on the Project Description.  You will need to use your gradebook spreadsheet to answer the several of the questions.  Your answers should be written in a report in paragraph form. 

 

Both the spreadsheet and paper will be electronically submitted in Blackboard.