Student Grades Example

Not Reviewed
Dataset / Last modified by mike on 2015/07/30 07:02
Type
Dataset
Category
vCommons
Contents
8 columns
Rating
ID
MichaelBartmess.Student Grades Example
UUID
29f71992-c8f3-11e4-a3bb-bc764e2038f2
Use this Dataset
Columns
DatatypeRequired
AssignmentStringYes
WeightEnumYes
Susan HEnumYes
Susan H (Numeric)RealNo
Todd ZEnumYes
Todd Z (Numeric)RealNo
Trent WEnumYes
Trent W (Numeric)RealNo
Current statistics
SumAvgMinMax
Susan H (Numeric)1110.092.579.0102.0
Todd Z (Numeric)1044.087.068.098.0
Trent W (Numeric)1007.583.9583333333333367.096.0

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.

letterrangemidpt
A+97-10098.5
A94-9695
A-90-9391.5
B+87-8988
B84-8685
B-80-8381.5
C+77-7978
C74-7675
C-70-7371.5
D+67-6968
D65-6665.5
F0-64n/a

References