Panel | |
---|---|
|
...
Add the count of teachers to the count of students.
Code Block |
---|
[Distinct Count: Teacher ID] + [Distinct Count: Student ID]
|
...
Code Block |
---|
dim1Total = [Total: Dimension 1 Score]; dim2Total = [Total: Dimension 2 Score]; dim3Total = [Total: Dimension 3 Score]; dim4Total = [Total: Dimension 4 Score]; dim5Total = [Total: Dimension 5 Score]; overallTotal = sum(dim1Total, dim2Total, dim3Total, dim4Total, dim5Total); overallCount = [Count: Session ID]; round(overallTotal / overallCount, 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.
Code Block |
---|
[Distinct Count: Student ID] / [Distinct Count: Teacher ID]
|
Use variables to hold the average of each of the dimensional scores. Use min(...)
function to find the lowest dimensional score. Use nested if (cond, trueValue, falseValue)
blocks to return which dimension matches the lowest score. Note: If more than one dimension shares the same lowest score, this only returns the first dimension found.
Code Block |
---|
dim1Avg = [Average: Dimension 1 Score]; dim2Avg = [Average: Dimension 2 Score]; dim3Avg = [Average: Dimension 3 Score]; dim4Avg = [Average: Dimension 4 Score]; dim5Avg = [Average: Dimension 5 Score]; lowestScore = min(dim1Avg, dim2Avg, dim3Avg, dim4Avg, dim5Avg); if (dim1Avg == lowestScore, "Dimension 1", if (dim2Avg == lowestScore, "Dimension 2", if (dim3Avg == lowestScore, "Dimension 3", if (dim4Avg == lowestScore, "Dimension 4", if (dim5Avg == lowestScore, "Dimension 5", "Unknown" ) ) ) ) ) |
...
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.
Code Block |
---|
[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.
Code Block |
---|
profLevel = 4;
if ([Average: Essay 1st Submission Score] < 4,
"Below",
"Above"
);
|
...
Code Block |
---|
stRatio = [Distinct Count: Student ID] / [Distinct Count: Teacher ID]; mediumThreshold = 20; highThreshold = 40; if (stRatio < mediumThreshold, "<span style=\"color:green\">Low</span>", if (stRatio >= highThreshold, "<span style=\"color:red;font-weight:bold\">High</span>", "<span style=\"color:yellow\">Medium</span>" ) ) |
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.
Code Block |
---|
profLevel = 4; if ([Average: Essay 1st Submission Score] < 4, "Below", "Above" ); |
...