This data set serves to manage a list of students and their grades for a variety of assignments. This can be used with the Equation-in-Equation (EiE) lookup that is called Student Grades Lookup.
For this example data set we have recorded the letter grades for each student for a list of assignments. A numeric grade may also be associated with each assignment. Both numeric and letter grades are provided here simply because this data set is an example and is intended to be duplicated and modified for your own specific purposes. This data set can easily be duplicated with a button push from the pull-down menu in the vCalc taxonomy, so make a copy and modify to your heart's delight!
There is a column in which you can name the assignment (row) as a String. Name it in any way you want. This is accompanied by a mandatory field called Weight, which contains a weighting factor for the assignment. The weights can be chosen from the range 1 through 25, where 25 is the highest relative weight.
The successive pairs of columns are each a letter grade and a numeric grade for each separate student. The three data columns for each student are:
The student's grades are recorded as letter grades and numeric grades but you could choose to record with just letter or just numeric grades.
The following table lists the range and midpoint for numerical grades corresponding to a letter grade.1 This data set is structured to hold the numeric grade, the corresponding letter grade. Again, you could duplicate this table and have it hold either numeric or letter grades or even additional student information.
letter | range | midpt |
A+ | 97-100 | 98.5 |
A | 94-96 | 95 |
A- | 90-93 | 91.5 |
B+ | 87-89 | 88 |
B | 84-86 | 85 |
B- | 80-83 | 81.5 |
C+ | 77-79 | 78 |
C | 74-76 | 75 |
C- | 70-73 | 71.5 |
D+ | 67-69 | 68 |
D | 65-66 | 65.5 |
F | 0-64 | n/a |
Entered | By | Assignment | Weight | Susan H | Susan H (Numeric) | Todd Z | Todd Z (Numeric) | Trent W | Trent W (Numeric) |
---|
2015-03-12 17:23:05 | MichaelBartmess | Qtr1, First Report | 7 | A | 96 | B | 86 | B+ | 89 |
2015-03-12 17:22:25 | MichaelBartmess | Qtr 1, Quiz 1 | 9 | A | 95 | A+ | 98 | D+ | 67 |
2015-03-12 17:21:44 | MichaelBartmess | Qtr 2, Quiz 1 | 10 | A- | 90 | B+ | 87 | A- | 90 |
2015-03-12 17:21:03 | MichaelBartmess | Qtr 2, Quiz 2 | 10 | B+ | 88 | B+ | 88 | C | 76 |
2015-03-12 17:20:22 | MichaelBartmess | Qtr 3, Trend Analysis | 5 | A | 96 | B+ | 88 | A | 96 |
2015-03-12 17:19:30 | MichaelBartmess | Qtr 3 Quiz 1 | 10 | A+ | 97 | D+ | 68 | B- | 81 |
2015-03-12 17:18:45 | MichaelBartmess | Qtr 4, Quiz 1 | 10 | A- | 90 | A- | 91 | A | 94 |
2015-03-12 17:18:05 | MichaelBartmess | Qtr 4, Quiz 2 | 10 | A+ | 102 | B+ | 89 | B+ | 89 |
2015-03-12 17:17:19 | MichaelBartmess | Qtr 4, Big Report | 7 | C+ | 79 | A | 94 | B- | 81.5 |
2015-03-12 17:16:14 | MichaelBartmess | Qtr 4, Quiz 3 | 10 | A- | 90 | C- | 71 | B- | 83 |
No comments |