🛠️ Attendance Works School Attendance Tracking Tool

The Attendance Works Student Data Grids are designed to enable district staff to quickly assemble and configure the necessary data for the School Attendance Tracking Tool template. 

Administrators can send the data to those who need it; they can easily format it for the template by following these directions. 

SENDING STUDENT DATA GRID 

1. Start by selecting "My Data Grids" from the left-hand navigation menu.

2. Click the Manage button for ‘School Attendance Tracking Tool.

3. Click the Report column, then click Select from  Student Group.

4. Click Shared Groups and School Specific.
5.  Next, click the plus button next to the group from the school needed.

6. Type in a File Name, e.g., “School Attendance Tracking Tool - MS 2016121,” and click Send Spreadsheet Report.

DOWNLOAD DATA GRID 

1. Find the email from with the subject of ‘Your Student Data is Ready!’ 
2. Click the button. You may need to authenticate per FERPA with your SDS (Homeroom) username and password. 
3. Your Student Data Grid will begin downloading. 
4. Navigate to your device's default download location and open the xlsx file. 

FORMAT THE DATA FOR ATTENDANCE WORKS 

1. Current Grade Level (Columns D & E): Highlight all data in this column >> from the warning selections, and choose “Convert to Number.”

2. Zip Code (column G): The Data grid does not contain a zip code; this can be updated manually.
3. Total Days Present (column M or L for MS-HS ): Copy all numbers in the column and paste special >> pick VALU >> ok (this will remove the function and put the ‘value’ of the function in that column). 
4. Total days absent (column N or M for MS-HS): Copy numbers in column N to column M. 

INSERT DATA INTO ATTENDANCE WORKS TEMPLATE 

Copy all data rows (starting at row 3) from Student Data Grid into ‘Attendance Works School Attendance Tracking Tool - MS.’

• Attendance Works - Elementary School - SDS Version.xlsx
• Attendance Works - Middle School - SDS Version.xlsx
• Attendance Works - High School - SDS Version.xlsx
  

ATTENDANCE WORKS RISK INDICATORS

For information on building Risk Indicators with Attendance Works and risk thresholds, read this Attendance Works Student Data Grids Reference Guide, Attendance Works Risk Indicators.

(updated 2/13/2023)

• Attendance Works Reference Guide.pdf300 KB
• Attendance Works - Middle School - SDS Version.xlsx4 MB
• Attendance Works - High School - SDS Version.xlsx8 MB
• Attendance Works - Elementary School - SDS Version.xlsx4 MB