Ann Arbor Public Schools
Ann Arbor, Michigan
Determining Whom to Report in MCIR
Current year entry date and code are in the Student table. Previous year entry data is in the Reenrollments table. To make it possible for you guys to search entirely in Student, I find the kids in the Reenrollment table and match the records to the Student table to and put an X in the immunizaton_dpt field in Student.
If you are an elementary (except AAO), you would next add on the kindergarten kids:
At Allen and Thurston, run this step last to leave off the preschoolers:
If you are a middle school, you would add on the 6th graders:
If you are Ann Arbor Open, you would use the following to pick up both Ks and 6s:
NOTE!: If you have your browser set to open all PowerSchool exports in Excel, you will have trouble with the resulting file! Use a different browser that doesn't automatically open Excel (try Safari) or call ITD for help on how to edit the file. Excel automatically places quotes around the exported entries which must be stripped out in a text editor.
On the MCIR website, go to the Build Roster screen and choose 'Load External File'. See second link below for detailed steps to upload the list.
There are helpful notes available from MCIR regarding quickly cleaning out and then uploading new students. See the following items under Resource Library in the Schools/Childcares section: