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, 3, & 4; lab practicum #1, 2, & 3; and lecture exam 1 & 2, then 53 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 and save it on your computer. | ||||||||||

6 | Lecture exam 1 | 62.75 | |||||||||

7 | Lecture 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 to calculate. | ||||||||

8 | Lecture exam 3 | 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 | Number of quizzes**: | 5 | Each quiz is worth | 2 | percent of the course grade. | Quizzes | 1.0 | 10 | ||

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

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

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

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

14 | Quiz 1** | **There are actually 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 your overall average is, say, 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 | ||||||||||

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

17 | Quiz 4 | â€ A weighted average calculation takes into consideration that lecture exams, lab practicums, quizzes, and the final have different relative values. To calculate a weighted average, the values for the exams, etc., are considered relative to the value of a single quiz. For example, since each lecture exam is worth 6 quizzes, a weighted average of the scores on one lecture exam and one quiz would treat the lecture exam as if it were equivalent to 6 quizzes. The relative values for the lecture and final exams, lab practicums, and quizzes can be seen in column P in the table above. | |||||||||

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

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

20 | Final Exam |

Loading...