Assessment Codes Table

Marks Matix

An assessment code record is created for every time of assessment presented to students.  The school should create separate assessment codes for different test vendors as no vendors will every be completely the same.  A unique code is given to each type of assessment.  When a student takes that assessment, the results are recorded and associated with the assessment code.  All student scores per code may be reported on.

Data Relationships

There are multiple tables that may be linked to an assessment code record.  Not all are required. Subject is required as the school should not be assessing students in subjects it does not teach.  If the student takes a single test with multiple subjects at one time, multiple code records will need to be creates, each with a unique subject.  Then when the students assessments results are input, multiple student assessment results will also be required.

Assessment codes may be linked to plans to determine the effectiveness of the plan.  A plan may have many assessment codes.

Assessment codes may be further linked to a curriculum in that plan if the effectiveness of the curriculum should be assessed.

Assessment codes may be linked to a grade level for example if that assessment is an important 'gate' before embarking of a course of study.

When a student takes an assessment, the results are input into the student assessment code table, one student will have multiple student assessment results records associated with one assessment code over time.  For example, a student may take the SAT multiple times, these scores may be input and linked to the same SAT assessment code record.

Fields

Assessment name - should contain the name of the vendor if third party test is uses. 

Code - an short a unique abbreviation for the assessment.

Type -how the student is being measured.

• Level Equivalent - the student score reflects where they stand against what the larger world expects from a student at that grade level.
• Percentile Rank  - the test ranked the students against other students in the same grade level.
• Competence - an yes/no determination if the student can perform the to the standard.

Normalize Scores - toggle this to yes to use the Marks Matrix table to normalize the student's raw test scores to fit one of the selected types.

Action Items JAN 2024

NV | ASSESSMENT | Implement Mark Matrix logic to normalize scores for assessments that are not already level equivalent.