What-do-I-need-to-get calculator
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
DEIJKLMNOPQ
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 1608430-36
7
Lecture exam 27069.40100
8
Lecture exam 370Values of exams, practicums, and quizzesRelative value of lecture and lab exam points to a single quiz point.Total % value of quiizzes, and lecture & lab exams
9
Practicum 140Number of quizzes**:5Each quiz is worth2
percent of the course grade.
Quizzes1.010
10
Practicum 240Number of practicums:5
Each practicum is worth
7
percent of the course grade.
Lab Practicums3.535
11
Practicum 380Number of lecture exams:3Each exam is worth12
percent of the course grade.
Lecture exams6.036
12
Practicum 480 The final is worth19
percent of the course grade.
Final9.519
13
Practicum 580A = 90 - 100%; B = 80 - 89; C = 70 - 79; D = 55 - 69; F = < 55100
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 280
16
Quiz 380
17
Quiz 480
18
Quiz 580
19
Quiz 680
20
Final Exam70
Loading...
 
 
 
Sheet1