If attendance is tracked outside of TeacherEase/SchoolInsight, you can import that attendance data into TeacherEase to be displayed on the report card. Absences, Tardies, and Presences may be imported and displayed on the report card.
The vast majority of schools should use the Import Aggregate Totals option. This file will have a single line for each student and columns showing that students’ total number of each attendance code. A few schools may use the Import Daily Attendance option, which uses a single line for each instance of an absences or tardy.
Import Aggregate Totals
Import Daily Attendance
Import Aggregate Totals
The file needs to include a column for the School description (School Name) or school External name, student ID (Student Number, Student External ID, Student External Ref ID, or Student Internal ID) and a column for each type of attendance code that is tracked. The attendance code columns should show the total number of days that the student had that attendance code.
School Name |
Student Number |
Days Present |
Days Absent |
Days Tardy |
Elementary School |
1114 |
45 |
0 |
2 |
High School |
1780 |
42 |
5 |
0 |
To import the file:
- Go to Main > Import/Export > Import Report Card Attendance
- (District Level only) Set File Type to Aggregate Totals
- (District Level only) Select whether you are importing attendance for the entire district or just one school
- Select the Report Card and grading period
- Choose a CSV file from your desktop
- Import
- Match each column in the file to a field in SchoolInsight
- Preview the import and verify there are no errors
- Import
Import Individual Daily Attendance
Some schools will import individual days of attendance instead of a total for each student. This mode can only be used when the report card is managed by the school district. It can only show absences and tardies, not presences.
The file must be a CSV, formatted as follows, and it should only include days in which students are absent or tardy. If you don’t wish to show tardies on the report card, you can omit the final column.
School Name |
Student Number |
Date |
Absent |
Tardy |
Elementary School |
1234 |
9/07/2018 |
Yes |
No |
Elementary School |
1234 |
10/24/2018 |
No |
Yes |
The file must include every absence and tardy. Students not in the file will have any prior attendance data overwritten with 0 absences and 0 tardies.
To import the file:
- Go to District Main > Import/Export > Import Report Card Attendance
- Choose the file type Daily Attendance
- To save time and make sure that previous grading periods are not changed, check “Skip inactive grading periods”
- Choose a file from your desktop
- Click Import to preview the file. This may take several minutes.
- Review the information to make sure there are no errors and Import