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. | Step 2: Enter your current overall average in the orange cell below. Your overall average can be found in the Cancas gradebook, or you can calculate your overall average by entering your exam and lab practicum percent scores in the purple cells to the left; your overall 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, then only the orange cell will be used in the calculation; the green cell will be ignored. | 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 entered automatically in the red cell along with your overall average in the green cell. If there are numbers in both the yellow and red cells, then only the yellow cell will be used in the calculation; the red cell will be ignored. | 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. | ||||||

5 | You can download this file ("File => Download as") if you want to open the spreadsheet in a program like Excel and save it on your computer. if you have a Google account you can save this spreadsheet online for your own private use ("File => Make a copy..."). | ||||||||||

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

7 | Midterm Exam 2 | Enter overall average in orange cell or enter scores in purple cells to calculate. | Enter % completed in yellow cell or enter scores in purple cells (left) to calculate. | ||||||||

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

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

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

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

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

13 | Practicum 5 | â€ A weighted average calculation takes into consideration that midterm 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 column P in the table above. | |||||||||

20 | Final Exam |

Loading...