Take the average test score and apply the round(x, p)
function, setting the precision p
equal to 2.
round([Average: Test Score], 2)
The number of students divided by the number of teachers. Distinct counts must be used here if the data contains more than one row per student or teacher.
[Distinct Count: Student ID] / [Distinct Count: Teacher ID]
Compare the average score of the 1st essay submission to what the desired proficiency level (e.g. 4). Then use an if (cond, trueValue, falseValue)
block to return the text "Below" if the average score is less than 4, or to return "Above" if the score is equal to or greater than 4.
profLevel = 4; if ([Average: Essay 1st Submission Score] < 4, "Below", "Above" );
Use a variable to record the student-teacher ratio. Then set variables to mark the points at which the ratio is considered medium or high. Finally, use two if (cond, trueValue, falseValue)
blocks to return the "Low", "Medium" or "High" text based on the ratio value.
stRatio = [Distinct Count: Student ID] / [Distinct Count: Teacher ID]; mediumThreshold = 20; highThreshold = 40; if (stRatio < mediumThreshold, "Low", if (stRatio >= highThreshold, "High", "Medium" ) )
Use a variable to set the desired proficiency level (e.g. 4). Then create two variables, before
and after
which indicate the proficiency level of the 1st essay submission and most recent submission, respectively. Finally, use nested conditional blocks to return "Improved" if the proficiency went from "Below" to "Above", "Unchanged" if it remained the same, or "Got Worse" if it went from "Above" to "Below".
profLevel = 4; before = if ([Average: Essay 1st Submission Score] < profLevel, "Below", "Above" ); after = if ([Average: Essay Most Recent Score] < profLevel, "Below", "Above" ); if (before == "Below" && after == "Above", "Improved", if (before == "Above" && after == "Below", "Got Worse", "Unchanged" ) )