Preparing Roster Files and Programs Files for Import

A roster file is required for importing profiles. If you need to include student program data, such as Special Education, you must also prepare a separate programs file.

Overall steps for creating a roster file and optional programs file are:

Export data from your student information system (SIS)
Download and save templates for the roster file and, optionally, the programs file (you can download templates from the home page when you log into the Web-based MAP system)
Enter information into the roster files
Save the completed roster files in .csv format

Required Role

Roster File Format

The roster and programs files are in .csv Collapsed Comma Separated Value format and must match the NWEA templates, provided on the MAP Administrative and Reporting Center home page.

The roster file template contains a separate tab for each type of roster import:

Combined Import prepares student data so that students are ready for testing, organizes data for reporting, and provides instructors access to their students’ reports.

Note: An optional, Student Only Import template is also available in case you need to temporarily import students without class and instructor information. However, you must later complete the student information so that they appear on reports.

To use this template, you must first unhide it. In Excel, you can right-click on any worksheet tab and choose Unhide. In other software, use the View menu.
Instructors Only Import allows teachers quick access to the system, but does not associate them with students, which is required for reporting. You might use this import type to update teacher names and e-mail addresses.
Additional Users Import adds or updates profiles in bulk for users with the MAP system role of Proctor, Administrator, Data Administrator, or Assessment Coordinator.

Preparing Roster Files and Programs Files for Import

Roster File Format

Related Links