If your NWEA testing period is coming up and you require an up-to-date import file from your PowerSchool data, this is the article for you!  We will walk through the step by step process of creating the Combined Import.csv file.  This walk through assumes that you are exporting information for a single school but if you wish to export multiple schools, this is easily changed by changing the school to “District Office.”

Before we start, you want to download the latest specifications of the combined import .csv file by navigating to:

https://yourschoollink-admin.mapnwea.org/admin/importprofile/StartNewImportPage.seam

Note that the “yourschoollink” portion of the link above requires your school specific link provided by NWEA and requires a profile for data administration.

Step 1:  Login and select all of your students.

Once you select all of your students, the number of students will show up next to “Current Student Selection.”  This should isolate the selection to only current students.

Step 2:  Navigate to the DDE and match selection to CC table.

Go to System (Setup) > Direct Database Export (DDE)

Use the pull down menu to select the CC (4) Table and

1) Select all XXXXX records in this table then

2) click “Match Selection”

This will isolate the selection of sections begin offered for only the active students.

Step 3:  Match to the Students table and select “Proceed to match Selection”

Step 4:  Filter results for the current school year only.

Use the filter expression TermID >= 2XXX in order to isolate the selection to the current year only.  These are the current TermID’s in PowerSchool.

• 2017-2018 = 2700
• 2018-2019 = 2800
• 2019-2020 = 2900
• 2020-2021 = 3000
• 2021-2022 = 3100
• 2022-2023 = 3200
• 2023-2024 = 3300
• ….

After you have selected the filter expression, click on “Search within the current XXXX records only.”

Step 5:  Click on “Export Records”

Step 6:  Paste the following code into the box and “Submit”

[39]Name
TeacherID
[5]Last_Name
[5]First_Name
[5]Middle_Name
[5]Email_addr
[5]Email_addr
[2]Course_Name
[1]Student_Number
[1]Last_Name
[1]First_Name
[1]Middle_Name
[1]DOB
[1]Gender
[1]Grade_Level
[1]FedEthnicity

Step 6:  Open the resulting file in Excel and insert a blank column in columns B and J (Click picture to see larger version)

Step 7:  Paste the headers for the NWEA specification into row 1.

For file specifications reference the NWEA website here.

Step 8:  In column R, Student Ethnic Group Name, replace “1” values with “Hispanic or Latino” and anything else with “Not Hispanic or Latino”

Step 9:  Save as “.csv” file and upload!

By this step, you should be complete.  Please note that this walkthrough does make certain assumptions about your data which are as follows:

• The school name in PowerSchool matches that of NWEA.
• Previous Instructor ID is not used
• Previous Student ID is not used
• User Name and Email address is based on the Teacher’s e-mail field in PowerSchool.
• Student Ethnic Group is limited to a yes/no statement to the question: “Is the Student Hispanic or Latino?”