How to use the Student Import Template

Method 1 - PowerSchool:

1. From the Start Page at the High School, select desired students.
2. Open the Data and Reporting tab
3. Exports
4. Export Using Template
   1. Type of Export:  Students
   2. Export Template:  NDHSAA Fall Export 2023
   3. For Which Records? - The selected xx students
   4. Submit
5. Navigate to the student.export.txt file on your computer, often in the Downloads folder.
6. Open with Excel
   1. Right click on the file and select Open With....Excel
7. Column F:  Fill in the Year student entered 9th grade
8. Column J:  IF you have a student that transferred to your school THIS YEAR, enter the school the student transferred from
9. Save file and email to nick.walton@ndhsaa.org

If you encounter issues with the export, please submit a ticket to PS Support at http://www.edutech.nd.gov

If you are able to get the download, but are unable to open with Excel, please contact your technology director or an excel user in your school.

Method 2 - Student Import Template PowerSchool Template file:

1. Download the template file: NDHSAA_Fall_Export_2023.pst
2. In PowerSchool navigate to Data & Reporting
3. Click on Imports
4. Click on Import Existing Report Template
5. Browse to and upload the NDHSAA_Fall_Export_2023.pst file
6. Click Import
7. Save file and email to nick.walton@ndhsaa.org

Note: This PowerSchool template may have columns on it that do not match columns in your PowerSchool version and may cause errors upon export. Please review the document prior to submission to NDHSAA.

Method 3 - Manually filling in the Student Import Template:

1. Download the Student Import Template.xlsx
2. Fill in the form.
   1.  Columns:
      1. School - Required - Name of School submitting the Student Import Template
      2. First Name - Required - Should be the legal first name of the student
      3. Last Name - Required - Should be the legal last name of the student
      4. Gender (M/F) - Required - The gender of the student
      5. Birthdate - Required - Format mm/dd/yyyy or yyyy-mm-dd
      6. Year Entered 9th Grade - Required for 9th grade students - Ex: '2024' for a student beginning their 9th grade year in 2024
      7. Grade - Required - The grade of the student for this school year
      8. Student ID # - Either the state or school ID # for the student
      9. Foreign Exchange (8=yes) - Required for Foreign Exchange students
      10. Transferring From -Complete ONLY for students transferring in during/for THIS year - Required for students transferring into your school this year - Should contain the name of the school the student is transferring from.
3. Save file and email to nick.walton@ndhsaa.org

Notes

• The 'Year entered 9th grade field' should only be filled in for new 9th graders, and should be the year they began 9th grade, i.e. "2021".
• While they should be submitted on the import, Transfer and Foreign Exchange will not be imported and you should use the Transfer or Foreign Exchange forms to add these students.

Transfer Students

Foreign Exchange Students