Setting Up Student Programs in Reports

Follow these instructions if you need reports that show aggregated results for students participating in a special program, such as English Language Learner. For example, the following report has an option to group results by special programs:

To set up this data, you can complete the programs spreadsheet template as part of the roster import.

Prerequisite: Set Up Program Names

Your district specifies the names of programs in the preferences set up on the MAP site. Someone with the appropriate role should make sure the names stored on the MAP site exactly match the source information going into your student roster. The program names must match or the roster import will fail.

Required role: District Assessment Coordinator or System Administrator

  1. Log in to teach.mapnwea.org.
  2. From the side navigation, choose Modify Preferences > Modify District.
  3. Scroll down to the Programs section.

  4. Compare these program names to your source for student information and make any needed changes to ensure they match.
    1. To make changes, use the Edit Name or Add Program buttons.

    2. Always click Submit when making changes.
  5. Share the correct program names with the person preparing the roster, who might not have access.

    Alternatively, you could add the District Assessment Coordinator role for this person.

How to Assign Programs with the Student Roster

As part of the standard roster process, you can also include a secondary file with students and their programs. The Programs File is a spreadsheet with two columns: student ID and program name. That information will combine with the standard roster file information during import.

Like the standard roster, you would import the Programs File at least once per term. However, if you re-import the standard roster with corrections or additions, you do not need to include the Programs File unless those student changes also affect the programs.

Required role: Data Administrator

  1. Prepare the standard roster as usual or use the most recent file.

  2. Download the programs spreadsheet template from the MAP site (teach.mapnwea.org):

    Links on MAP site with Programs File Template highlighted

  3. Open the programs spreadsheet and save a copy so you can easily distinguish it from other roster files.

    Example name: ProgramsRosterFall2020

  4. Extract a list of students and their special programs from your source information.

    • If you have a Student Information System (SIS) application: Either create a custom report or export directly from the database.
    • If you have no SIS application: Copy from the next best source of official record-keeping, such as another spreadsheet.

    Note: The program names should match what is stored in the MAP preferences, as described in Prerequisite: Set Up Program Names.

  5. Move extracted information into the NWEA programs spreadsheet.

    Note: For students with multiple programs, use multiple rows with one program per row.

  6. Compare the programs and standard roster spreadsheets to ensure students and their IDs match.

    Tip: You can sort both spreadsheets by the Student ID column.

  7. Save a copy of the programs spreadsheet with the CSV file format:

    Choices for file types, with both the correct CSV type and incorrect CSV UTF-8 type

  8. Log in to the MAP site (teach.mapnwea.org) and choose Import Profiles / Rostering.
  9. On the Set Up Import page, add both the Roster File (teacher and students) spreadsheet and the Programs File.

Import Errors from Programs

If you encounter errors during roster import, see the detailed instructions:

Error Detailed instructions

Student ID does not match any student ID in the CRF file

(A student appears in the Programs File but not in the standard roster file.)

 

Student ID does not match any student ID in the CRF file

Reconcile Error—Program Errors

(A program name does not match between your roster and the settings stored in the MAP site.)

School, Ethnic Group, Grade, or Program Error Reconciliation

Alternative: Program Names Bulk Update

As an alternative to the roster import, you can assign students to programs using the bulk update feature. However, this alternative involves searching for students you want to update. Bulk update works best for students who share something in common, such as grade or class. See Updating in Bulk.