Rerostered reports are available, as soon as we import your "external" reroster file into MMARS. You simply need to send us a file that contains the roster information -- presumably exported from your Student Information System (SIS).  We need the following information for each student, each period (multiple rows per student with multiple classes).  Notes:
  • Please use the column titles EXACTLY as they are shown below (otherwise, we have to change them).
  • We prefer Excel format, but .CSV text is acceptable.
  • Do not have ANY punctuation in your files.  In particular, the files must be void of all commas, periods, apostrophes, and quotes.
  • If you want teacher first names or initials, please put these in a separate column from the last name.

Required Columns:
  1. Firstname
  2. Lastname
  3. Birthdate
  4. StudentID (local)
  5. SSID (state)
  6. SchoolID (7-digit CDS; do not use a local number or name)
  7. TeacherLastname
  8. TeacherCode (unique SEIN or local ID)
Recommended Columns:
  1. TeacherFirstname
  2. GradeLevel

... and for middle/high schools:

  1. DepartmentName (e.g. English, Math, Science, Social Studies, Elective, Other)
  2. CourseName
  3. PeriodNumber
  4. SemesterTerm (e.g. 1,2 or F,S,Y)
See sample roster files: Elementary School File     Secondary School File

Before you upload your files to us via ShareFile, please name them in such a way that identifies whether they are:
  • as-tested 2017-18 classes  (e.g. HometownUSD_Spring2018_rosters_AsTested.xls)
  • new 2018-19 classes  (e.g. HometownUSD_Fall2018_rosters_Current.xls).
We prefer that you send us both, so we can build reports for both sets of teachers. 

If you have any questions, please email or call us at (530) 295-1262.