Quantcast

Student Grades Example

Last modified by
on
Jul 24, 2020, 6:28:09 PM
Created by
on
Mar 12, 2015, 8:05:43 PM
Tags
UUID
29f71992-c8f3-11e4-a3bb-bc764e2038f2

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:

  • a column with the student's name, which contains letter grades for each assignment row
  • a column with the student's name followed by "(Numeric)", which contains numeric grades for each assignment row

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.

Grading Scale

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
  1. ^ https://people.sunyit.edu/~boylank/scale.html

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

This dataset, Student Grades Example, is used in 1 page
  • Comments
  • Attachments
  • Stats
No comments
This site uses cookies to give you the best, most relevant experience. By continuing to browse the site you are agreeing to our use of cookies.