Added 6/1/24 Assessments>Setup>Assessment Templates>Result Files - Added option for column marked as Grade Level to import based on SAT Grade level codes.
Assessment Module Tour
A quick overview of the Assessments Module.
Setup
Setup is where two key functions take place:
- Creation of Assessment Templates
- Uploading of Assessment "Result Files" - Scores of the taken tests.
Assessment Templates
An "Assessment Template" is a description of a type of standardized test, such as "SAT".
Once a Template is defined it can be used many times as the "map" by which an Assessment Result File is interpreted.
For example, "SAT" can be defined as a Template and then a separate "Assessment Result File" can be uploaded, using the SAT Template, for each actual SAT Scores file the district acquires.
Data Views
Data Views == Longitudinal Spreadsheets
"Data Views" are longitudinal spreadsheets with scores pulled from any collection of underlying "Result Files".
For example, a "Reading Scores" Data View might have 'reading' scores pulled from various underlying Assessments.
Student Assessment Scores
A Student Assessment Score record contains the set of scores and other data from a single assessment taken by an individual student.
An unlimited number of records can be stored per student.
The following information is stored on each individual record.
Scores Record
StudentAssessmentScore (Assessments Group)
Report Writer Property | Sample Data | Description |
objectid (pk) | 8720345 | Globally unique id for this row. |
studentid * | 00123 | Local student id |
assessmentCode * | 12C7A27F2CA | Pointer to a record in the ASSESSMENTS table that contains information about the file this record was imported from. |
testName | NJASK | Name of the test (as defined in the ASSESSMENTS table). |
examName | Name of the exam (or subtext). For example: "Economics: Microeconomics" which would be an exam from the AP test. | |
assessmentYear * | 2010 | Year the assessment was taken by the student. |
assessmentMonth * | March | Month in the year that the assessment was taken by the student. |
gradeLevel | 09 | Grade Level from the assessment |
dateTaken | 03/04/2010 | The exact date and (optionally time) the assessment was taken by the student. |
printOnTranscript * | Yes | Print on the transcript using the ASCORE_.. transcript macros. |
numericScore1 … 200 | 50 | Numeric value of score |
alphaScore1 … 200 | A+ | Alphanumeric value of a score |
*These fields are required; and will always contain data
PKThis field is the primary key in the database table.
Standard 6 Scores
Even though there are 200 scores that can be loaded into a single record;
Scores 1 through 6 are standardized as the following:
# | Name | Description |
1 | Language Arts | |
2 | Reading | |
3 | Writing | |
4 | Math | |
5 | Science | |
6 | Score | Used when none of the above is applicable |
This means that an addition 194 scores can be loaded in per record.
Alpha and Numeric
Each score can be stored as either numeric (6,2) or Alpha (50 Characters).
Additional Articles
How to Import Assessment Scores
Graduation Requirement Mapping
Uploading and Mapping the NJSLA/NJGPA Result File for Graduation Requirements
Building Assessments and Data Views for Gradebook Posting
Student Records and Assessments
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article