SIS Data Format

To ensure Equity Analytics processes your Student Information System (SIS) data correctly, all uploaded files must meet our standard format requirements. This allows the platform to align your student, staff, and school data for accurate reporting and accountability calculations.

---

Required File Names and Formats

All SIS data files must be in CSV format (.csv) and named exactly as listed below.

---

acceleration_metrics.csv

school_id	school_name	course_code	course_name	period	teacher_id	teacher_name	student_id	first_name	last_name	grade

district_admin_users.csv

school_id	first_name	last_name	email	title

district_users.csv

school_id	first_name	last_name	email	title

enrolments.csv

school_id	teacher_id	student_id	grade	subject	course_code	period	term

fay_students.csv

school_name	state_code	ada_grade	first_name	last_name	enrollment_status	enrollment_days	total_fay_days	percent_enrolled

schedules.csv

school_id	teacher_id	student_id	term	course_code	subject	short_name	long_name	period

school_users.csv

school_id	first_name	last_name	email	title

schools.csv

sis_id	name	short_name	low_grade	high_grade	principal_first_name	principal_last_name	principal_email	address	city	state	zip

students.csv

school_id	student_id	first_name	last_name	email	ada_grade	gender	is_sped	is_scd	is_ell	is_gifted

teacher_users.csv

teacher_id	first_name	last_name	email	title

teachers.csv

teacher_id	school_id	first_name	last_name	email

Getting Your SIS Data

If you need assistance with exporting these files from your SIS (for example SAM7 or PowerSchool), please contact our support team:

• Email: support@equityanalyticsms.com

Our team can guide you or coordinate directly with your district technology staff to ensure files are prepared in the correct format.

---

Automating Your SIS Data Uploads

For districts looking to streamline this process, Equity Analytics supports nightly automated uploads via our API.

• API Documentation: View API Overview

With API integration, your SIS data can be securely transmitted each night without manual uploads. This keeps your dashboards, reports, and accountability metrics up to date.

---