D | E | I | J | K | L | M | N | O | P | Q | |
---|---|---|---|---|---|---|---|---|---|---|---|

3 | |||||||||||

4 | Don't include percent signs when entering scores. For example, enter 80% as 80. | Step 1: In the blue cell below enter the overall percent score you want at the end of the term. (90 for an A, 80 for a B, etc.) | Step 2: Enter your current overall average from the Canvas gradebook in the orange cell below. (You can also calculate your current overall average by entering your exam and lab practicum percent scores in the purple cells to the left; your average will then be automatically entered in the green cell and the percent of the course completed will be entered in the red cell. If there are numbers in both the orange and green cells, only the number in the orange cell will be used in the calculation.) Note: your overall average seen in the Canvas gradebook may be a bit different from the average calculated by this spreadsheet. The spreadsheet average is the correct one! | Step 3: Enter the percent of the course completed in the yellow cell below. (If you enter your exam and lab practicum percent scores in the purple cells to the left, the percent of the course completed will be calculated.) | Step 4: After compleing steps 1-3, the white cell below shows the minimum overall weighted average score† needed on the remaining exams and practicums to get the overall percent score you entered in the blue cell. When you are finished please delete all numbers entered. | ||||||

5 | You can download this spreadsheet ("File => Download as") and open it in a program like Excel. If you have a Google account, you can save this spreadsheet online to your Google Drive for your personal use ("File => Make a copy..."). [Choose "File" from the document menu and not the browser menu.] | ||||||||||

6 | Midterm Exam 1 | 84 | |||||||||

7 | Midterm Exam 2 | 93.55 | 91.0 | 100 | |||||||

8 | Midterm Exam 3 | 94.66 | Values of exams and practicums. | Relative value of exam points to practicum points | Total % value of lecture & lab exams | ||||||

9 | Practicum 1 | 98.87 | # of practicums: | 5 | Each practicum is worth | 8 | percent of the course grade. | Lab practicums | - | 40 | |

10 | Practicum 2 | 98.33 | # of midterm exams: | 3 | Each midterm exam is worth | 14 | percent of the course grade. | Midterm exams | 1.8 | 42 | |

11 | Practicum 3 | 100 | The final exam is worth | 18 | percent of the course grade. | Final exam | 2.3 | 18 | |||

12 | Practicum 4 | 100 | A = 90 - 100%; B = 80 - 89; C = 70 - 79; D = 55 - 69; F = < 55 | 100 | |||||||

13 | Practicum 5 | 100 | †A weighted average calculation takes into consideration that exams and lab practicums have different relative values. To calculate a weighted average, the values for the exams are considered relative to the value of a single lab practicum. For example, since each midterm exam is worth 1.8 lab pracicums, a weighted average of the scores on one midterm exam and one lab practicum would treat the midterm exam as if it were equivalent to 1.8 practicums. The relative values for the midterm & final exams and lab practicums can be seen in cells P10 and P11 in the table above. | ||||||||

14 | Final Exam | 72.73 |

Loading...

Main menu