BAD-1335: Calculate Your Grade to Date: Daphne A. Morris:
Assignments: (B) Points (C) (D) Total (E) Total (F) Your
Sample numbers are entered so you
You Earned Possible Possible Points You Grade to Date
can see how the Calculator works.
Points Points Earned
Just click in a shaded cell and type
Training: Windows 7 15 15 0.00 the points you earn. Column F
In-Class Problems: Windows 7 10 25 0.00 automatically calculates your current
Training: Common Features 15 40 0.00 Grade-to-Date (called "GTD"). Your
GTD is just a snapshot in time
In-Class Problems: Common Features 10 50 0.00
through a particular assignment; it
Test# 1: Objective Questions 45 95 0.00 will change as you complete
Test #1: Application Questions 45 140 0.00 additional assignments.
Training: Word Module 1 15 155 0.00
In-Class Problems: Word Module 1.1 10 165 0.00 Daphne A. Morris:
The math behind percentages: For
In-Class Problems: Word Module 1.2 10 175 0.00 each assignment, you earn a certain
Training: Word Module 2 15 190 0.00 number of points out of a possible
In-Class Problems: Word Module 2.3 10 200 0.00 total. Divide the points you earn by
In-Class Problems: Word Module 2.4 10 210 0.00 the possible points (Column
B/Column C). If you earned 10.5
Test# 2: Objective Questions 70 280 0.00
points on the Common Features
Test #2: Application Questions 70 350 0.00 Training, 10.5/15 = 0.7000 or
Training: Excel Module 1 15 365 0.00 70.0%.
In-Class Problems: Excel Module 1.1 10 375 0.00
The math behind grade-to-date: As
In-Class Problems: Excel Module 1.2 10 385 0.00
you complete more than one
Training: Excel Module 2 15 400 0.00 assignment, the points you earn
In-Class Problems: Excel Module 2.3 10 410 0.00 add up. Divide the total points you
In-Class Problems: Excel Module 2.4 10 420 0.00 have earned so far by the total
possible points. For the sample
Test# 3: Objective Questions 70 490 0.00
numbers, the student earned 27.5
Test #3: Application Questions 70 560 0.00 points (Column E) out of a possible
Training: Access Module 1 15 575 0.00 40 points (column D). Divide 27.5
In-Class Problems: Access Module 1.1 10 585 0.00 by 40 = 0.6875 or 68.75. This is a
In-Class Problems: Access Module 1.2 10 595 0.00 "D" grade; there is no rounding up.
Training: Access Module 2.3 15 610 0.00
In-Class Problems: Access Module 2.3 10 620 0.00
Test# 4: Objective Questions 45 665 0.00
Test #4: Application Questions 45 710 0.00
Training: PowerPoint Module 1 15 725 0.00
In-Class Problems: PowerPoint Module 1 10 735 0.00
Training: PowerPoint Module 2 15 750 0.00
In-Class Problems: PowerPoint Module 2 10 760 0.00
Test# 5: Objective Questions 70 830 0.00
Test #5: Application Questions 70 900 0.00
Course Capstone 300 1200 0.00