Class Rosters File Requirements and Upload
Classroom reports are available, as soon as we import your "external" roster file into MMARS™.
Roster Overview
You simply need to send us a file that contains the roster information -- exported via a query from your Student Information System (SIS). • Click here for an example file • See example Aeries query on step 3
Step 1 • We prefer CSV (MS-DOS) format - comma-separated-values. If you use CSV, the delimiters must be commas.
File Format
• Excel files are acceptable, provided all the other requirements are met. • No punctuation is permitted. In particular, the files must be void of all commas, tabs, and quotes (except the comma delimiters between columns).
Step 2 Column Headings We need this information for each student, each period (multiple rows per student with multiple classes).
1. 2. 3. 4. 5. 6. 7.
Firstname Lastname Middlename Birthdate StudentID (local) SSID (state) SchoolID (CA customers: use only the rightmost 7-digits of the CDS code) Do NOT use the full 14-digit CDS code. Do NOT use the 7-digit County-District ID. Do NOT use a local number or school name.
8. TeacherLastname 9. TeacherFirstname 10. TeacherID (unique SEIN or local ID) 11. DepartmentName (optional - e.g. English, Math, Science, Social Studies, Elective, Other)
Leave blank for elementary students with only one teacher.
12. CourseName (optional ) Please name your column titles EXACTLY as they are shown below (otherwise, your file will be rejected).
Leave blank for elementary students with only one teacher.
13. PeriodNumber (optional ) Leave blank for elementary students with only one teacher.
14. GradeLevel (TK - 12)
Step 3
Example Aeries query for current year rosters: Elementary Schools
LIST STU SCH TCH STF STU.LN STU.FN STU.BD STU.ID STU.CID STU.SC SCH.TLN TCH.TF STF.SID STU.GR Secondary Schools
Aeries Queries
LIST STU SEC MST CRS TCH LOC STU.FN STU.LN STU.MN STU.BD STU.ID STU.CID LOC.SC TCH.TLN TCH.TF TCH.ID CRS. DC? CRS.CO MST.PD STU.GR
*** OR *** LIST STU SEC MST CRS TCH LOC STF STU.FN STU.LN STU.MN STU.BD STU.ID STU.CID LOC.SC STF.LN STF.FN STF.ID CRS.DC? CRS.CO MST.PD STU.GR
Step 4 Before you upload your files to us via the MMARS Upload Utility, please name them in such a way that identifies whether they are:
File Naming
• as-tested 2019-20 classes (e.g. HometownUSD_Spring2020_rosters_AsTested.xls) • new 2020-21 classes (e.g. HometownUSD_Fall2020_rosters_Current.xls).
Step 5 We prefer that you send us files, for both years, so we can build reports for all your teachers.
Uploading
To upload your file(s), follow the tutorial below: Uploading Your Rosters
Got a question? To learn more about us, visit here.
Or contact a live representative below.
Chat
Phone
tech@multiplemeasures.net
www.multiplemeasures.com
(530) 295-1262