Student Grades Lookup

Not Reviewed
Equation / Last modified by mike on 2015/07/13 11:32
`"Grade" = `
MichaelBartmess.Student Grades Lookup

This equation is intended to be used as a vCalc equation-in-equation (EiE) to performs a cell look-up in the data set: Student Grades Example.  You should be able to select an example student name, associated with either letter or numeric grade, and this equation will return data from the table in several forms.


To access various information from the Student Grades Example data set, you select these inputs:

  • Choice of Student - the equation assumes you have set-up a data set for a set of students. For example, the Student Grades Example captures assignment grades for a fictitious class of three students.
  • Data Choice - a selectable choice to use either the letter grades for each assignment or the numeric grades.
  • Visualization Choice - a selectable choice to show one of the following for the chosen student.
    • Student's Grades - list of the chosen student's grades on all assignments
    • Weighted Average - a weighted average of all the grades for the chosen student
    • Highest Score - the chosen student's highest score
    • Lowest Score - the chosen student's lowest score
    • Unweighted Average - an unweighted average of all the chosen student;s scores


First you select a student to view that student's grade information.  There are three students to choose from in the Student Grades Example data set, so this is an example of a small class.

Next you select the Data Choice of whether to use letter grades or numeric grades for the chosen student.  In most real-world cases, the data set would store one or the other but we used this example equation to show how to manage both the textual letter grade (in a switch statement) and the numeric grades.

Last you choose what kind of output you want to see for the chosen student.  We use Groovy methods in this case to form some of the possible data, this proving an example of Groovy method signatures.

As in all tokens in vCalc (constants, calculators, equations and data sets), you can easily duplicate this equation or the accompanying data set if you are a registered user.  All you have to do is mouse-over the token's name in the vCalc taxonomy and select duplicate from the menu that appears.  You will then have your own copy of this equation to play with.