Still loading...

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 Blackboard gradebook. Or you can calculate your overall average by entering your exam, practicum, and quiz 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 your overall average includes your score on quizzes 1 & 2, lab practicum #1 & 2, and lecture exam 1, then 30 percent of the course has been been completed. If you enter your exam, practicum, and quiz 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 quizzes to get the overall percent score you entered in the blue cell. | ||||||

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

6 | Lecture exam 1 | 60 | 84 | 30 | -36 | ||||||

7 | Lecture exam 2 | 70 | 69.40 | 100 | |||||||

8 | Lecture exam 3 | 70 | Values of exams, practicums, and quizzes | Relative value of lecture and lab exam points to a single quiz point. | Total % value of quiizzes, and lecture & lab exams | ||||||

9 | Practicum 1 | 40 | Number of quizzes**: | 5 | Each quiz is worth | 2 | percent of the course grade. | Quizzes | 1.0 | 10 | |

10 | Practicum 2 | 40 | Number of practicums: | 5 | Each practicum is worth | 7 | percent of the course grade. | Lab Practicums | 3.5 | 35 | |

11 | Practicum 3 | 80 | Number of lecture exams: | 3 | Each exam is worth | 12 | percent of the course grade. | Lecture exams | 6.0 | 36 | |

12 | Practicum 4 | 80 | The final is worth | 19 | percent of the course grade. | Final | 9.5 | 19 | |||

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

14 | Quiz 1** | 85 | **There are 6 quizzes but the lowest quiz score is counted as extra credit. The extra credit is calculated this way: the percentage score on the lowest quiz is mutliplied by 2% and the resulting number is added to your overall average (2% because each quiz is worth a maximum of 2% of your total overall average). For example, if your lowest quiz score is a 50%, and since 2% x 50 = 1, then 1% is added to your overall average (so if for example your overall average is 78 before the extra credit, it would be 79 after the extra credit is added). All this math is done automatically if you fill in all your quiz scores in the purple cells to the left. Do not discount the importance of this extra credit! If, going in to the final, your overall average is 78 and you had no extra credit, then you'd need a score of 89 to get an 80% and thus a B in the course. If you had one point of extra credit and thus an overall average of 79, you'd need an 84% on the final to get a B. With just 1.5 points of extra credit, only an 82%! | ||||||||

15 | Quiz 2 | 80 | |||||||||

16 | Quiz 3 | 80 | |||||||||

17 | Quiz 4 | 80 | |||||||||

18 | Quiz 5 | 80 | |||||||||

19 | Quiz 6 | 80 | |||||||||

20 | Final Exam | 70 |

Loading...