Exporting Results
On KAMAR go to Setup -> Server
Then click on “Maintenance Scripts” -> “Custom” and click the “Assay Scripts” on the list in the bottom right, and then press the “Edit” button underneath the list of custom files.
If you do not see an Assay Scripts custom file, you will need to follow these instructions to setup the custom file.
This will open up the scripts screen. On this screen click on the “Assay_Previous_Years_Results” and click the run button up the top.
If you do not see this script on the left menu, you will need to follow these instructions to update you k_List file.
This may cause a popup like this to come up, if it does just press the “Continue” button.
You will then be asked where you want to save the file. Make sure you choose the “CSV” file type, and give it a name where you can find it later. Then press save.
This will then bring up a slider showing the export process.
Once it has finished make sure the file is created where you were expecting it.
Exporting Core Data
Copy the all the list in red text below:
ID Number Last Name (Preferred) First Name (Preferred) Student email - School All Subjects with Teachers (semi-colon) Ethnicity - Level 1 Group Gender Year Level NZQA - Credits Level 1 - Achieved NZQA - Credits Level 1 - Merit NZQA - Credits Level 1 - Excellence NZQA - Level 1 NCEA (Short) NZQA Results - L1 NCEA Endorsement NZQA - Credits Level 2 - Achieved NZQA - Credits Level 2 - Merit NZQA - Credits Level 2 - Excellence NZQA - Level 2 NCEA (Short) NZQA Results - L2 NCEA Endorsement NZQA - Credits Level 3 - Achieved NZQA - Credits Level 3 - Merit NZQA - Credits Level 3 - Excellence NZQA - Level 3 NCEA (Short) NZQA Results - L3 NCEA Endorsement NZQA - Numeracy NZQA - L1 Literacy NZQA - UE Literacy NZQA Results - UE Num Attendance - Percentage (Half-Days) Enrollment Status NZQA - Credits Level 1 - Not Achieved NZQA - Credits Level 2 - Not Achieved NZQA - Credits Level 3 - Not Achieved House Type Leaving Date Tutor Ethnicity - Level 2 Group Pastoral Attendance Item Count Pastoral Classroom Item Count Pastoral Demerits Total All Pastoral Demerits Total Current Pastoral Discipline Item Count Pastoral Guidance Item Count Pastoral Other Item Count Pastoral Points Total All Pastoral Points Total Current Pastoral Total Item Count Pastoral Uniform Item Count Recognitions - Item Count Periods - Absent (Year) Periods - Justified (Year) Periods - Unjustified (Year) Attendance - Total Periods (Year) Previous School 1 Name National Student Number (NSN) Timetable Class (Bottom 3) Timetable Class (Top 4) Timetable Class Attendance by Code - ? (Year) Attendance by Code - A (Year) Attendance by Code - C (Year) Attendance by Code - D (Year) Attendance by Code - E (Year) Attendance by Code - F (Year) Attendance by Code - G (Year) Attendance by Code - H (Year) Attendance by Code - I (Year) Attendance by Code - J (Year) Attendance by Code - K (Year) Attendance by Code - L (Year) Attendance by Code - M (Year) Attendance by Code - N (Year) Attendance by Code - O (Year) Attendance by Code - P (Year) Attendance by Code - Q (Year) Attendance by Code - R (Year) Attendance by Code - S (Year) Attendance by Code - T (Year) Attendance by Code - U (Year) Attendance by Code - V (Year) Attendance by Code - W (Year) Attendance by Code - X (Year) Attendance by Code - Y (Year) Attendance by Code - Z (Year) Attendance by Code - Term 1 - ? Attendance by Code - Term 1 - A Attendance by Code - Term 1 - C Attendance by Code - Term 1 - D Attendance by Code - Term 1 - E Attendance by Code - Term 1 - F Attendance by Code - Term 1 - G Attendance by Code - Term 1 - H Attendance by Code - Term 1 - I Attendance by Code - Term 1 - J Attendance by Code - Term 1 - K Attendance by Code - Term 1 - L Attendance by Code - Term 1 - M Attendance by Code - Term 1 - N Attendance by Code - Term 1 - O Attendance by Code - Term 1 - P Attendance by Code - Term 1 - Q Attendance by Code - Term 1 - R Attendance by Code - Term 1 - S Attendance by Code - Term 1 - T Attendance by Code - Term 1 - U Attendance by Code - Term 1 - V Attendance by Code - Term 1 - W Attendance by Code - Term 1 - X Attendance by Code - Term 1 - Y Attendance by Code - Term 1 - Z Attendance by Code - Term 2 - ? Attendance by Code - Term 2 - A Attendance by Code - Term 2 - C Attendance by Code - Term 2 - D Attendance by Code - Term 2 - E Attendance by Code - Term 2 - F Attendance by Code - Term 2 - G Attendance by Code - Term 2 - H Attendance by Code - Term 2 - I Attendance by Code - Term 2 - J Attendance by Code - Term 2 - K Attendance by Code - Term 2 - L Attendance by Code - Term 2 - M Attendance by Code - Term 2 - N Attendance by Code - Term 2 - O Attendance by Code - Term 2 - P Attendance by Code - Term 2 - Q Attendance by Code - Term 2 - R Attendance by Code - Term 2 - S Attendance by Code - Term 2 - T Attendance by Code - Term 2 - U Attendance by Code - Term 2 - V Attendance by Code - Term 2 - W Attendance by Code - Term 2 - X Attendance by Code - Term 2 - Y Attendance by Code - Term 2 - Z Attendance by Code - Term 3 - ? Attendance by Code - Term 3 - A Attendance by Code - Term 3 - C Attendance by Code - Term 3 - D Attendance by Code - Term 3 - E Attendance by Code - Term 3 - F Attendance by Code - Term 3 - G Attendance by Code - Term 3 - H Attendance by Code - Term 3 - I Attendance by Code - Term 3 - J Attendance by Code - Term 3 - K Attendance by Code - Term 3 - L Attendance by Code - Term 3 - M Attendance by Code - Term 3 - N Attendance by Code - Term 3 - O Attendance by Code - Term 3 - P Attendance by Code - Term 3 - Q Attendance by Code - Term 3 - R Attendance by Code - Term 3 - S Attendance by Code - Term 3 - T Attendance by Code - Term 3 - U Attendance by Code - Term 3 - V Attendance by Code - Term 3 - W Attendance by Code - Term 3 - X Attendance by Code - Term 3 - Y Attendance by Code - Term 3 - Z Attendance by Code - Term 4 - ? Attendance by Code - Term 4 - A Attendance by Code - Term 4 - C Attendance by Code - Term 4 - D Attendance by Code - Term 4 - E Attendance by Code - Term 4 - F Attendance by Code - Term 4 - G Attendance by Code - Term 4 - H Attendance by Code - Term 4 - I Attendance by Code - Term 4 - J Attendance by Code - Term 4 - K Attendance by Code - Term 4 - L Attendance by Code - Term 4 - M Attendance by Code - Term 4 - N Attendance by Code - Term 4 - O Attendance by Code - Term 4 - P Attendance by Code - Term 4 - Q Attendance by Code - Term 4 - R Attendance by Code - Term 4 - S Attendance by Code - Term 4 - T Attendance by Code - Term 4 - U Attendance by Code - Term 4 - V Attendance by Code - Term 4 - W Attendance by Code - Term 4 - X Attendance by Code - Term 4 - Y Attendance by Code - Term 4 - Z
On KAMAR in the top right change the year to the year you want to export the results for (eg: 2020)
Then go to Reporting -> Student Lists
And then click on “Student List – Custom Fields” and press the magnifying glass in the Student Search
Filter
Change the “Find” to “All” and press continue
Then press the “OK” button under the list of students
Click the “Field List” button, and paste in the list we copied earlier, and press the “Apply” button.
This will update the display. Depending on the number of students, this could take a little bit of time.
Then press Actions -> Export, making sure the settings are the same as below.
Then press “OK” This will then ask you where you want to save it. Choose your location and file name and press save.
This will bring up a slider showing the export process:
Once it has finished make sure the file is created where you were expecting it.
Uploading to Assay
On Assay go to Admin -> Upload Data. Change the year at the top to the year you want to load the data for. Press the two chosen file buttons… the first one you want to upload the Core Data, the second one the Results data. After choosing the file you need to press the “Upload” button and it will tell you if it has been successful.
Then scroll right to the bottom of that window and press the “Process” button. This will show the process on the screen and tell you when it has finished.