This Tip Sheet has been designed to assist Districts in uploading the Submission Course (aka the Course Submission).

PURPOSE

To collect teacher and course data. In addition, to collect assignments for those in roles that do not have courses, such as Principals or Superintendents.

WHO TO INCLUDE

All credentialed staff within an SAU, District and School. Include ALL staff that require an educator credential, even if they do not teach a course (e.g., Superintendent, Curriculum Director). Additionally, include staff who must be licensed by another agency (e.g., School Nurses, Psychologists, etc.). A New Hampshire educator ID is required for inclusion in the Submission Course.

WHAT TO INCLUDE

An Excel template of the Submission Course can be downloaded from the NHED website: https://www.education.nh.gov/who-we-are/division-of-educator-and-analytic-resources/bureau-of-education-statistics/user-guides-and-templates

The following fields are included in the Submission Course:

HOW TO SUBMIT THE SUBMISSION COURSE

1. Fill out the Submission Course template available at the NHED website, or pull the data directly from your district's Student Information System (SIS) using a premade extract. Contact your SIS vendor if you need assistance with an extract.
2. Save the Submission Course as a CSV (comma separated value) file
   
   1. Do not use commas anywhere in your Submission Course file, as they will cause the submission to fail during the upload process
3. In your web browser, navigate to the myNHDOE Single Sign-On portal: https://my.doe.nh.gov/myNHDOE/Login/Login.aspx
   1. If you do not have a single sign-on account, create one using the "Create an Account" link
4. Login to your single sign-on account
   1. If you do not remember your password, or if your account has been disabled, use the "Forgot Username/Password Wizard" to reset your account
   2. For security purposes, passwords must be updated every few months
5. Once in myNHDOE, navigate to i4see (Initiative for School Empowerment and Excellence)
   1. If you do not have access to i4see, contact your SAU's Local Security Coordinator to request access
   2. A list of Coordinators can be found at the NHED website (https://my.doe.nh.gov/Profiles/PublicReports/PublicReports.aspx?ReportName=i4seeContacts)
6. Once in i4see, navigate to the UPLOAD FILES screen
   1. If you are a multi-district SAU, make sure you select the appropriate district from the dropdown menu, to avoid uploading the Submission Course to the wrong district's workbench
7. Select "Submission Course" from the Submission Type dropdown menu
8. Click CHOOSE FILE and browse to your saved Submission Course CSV file
9. If your CSV file still contains the column headers (e.g., SASID, DateOfBirth, SAUNbr, etc), select the "Remove Headers" checkbox
   1. Selecting the "Remove Headers" checkbox will delete the first row of the CSV file upon upload
   2. If your file does NOT include the column headers, do NOT select this checkbox, as it will cause your first record to be deleted
10. Enter a Comment if desired (e.g. "High School, First Semester")
11. Click "Pre-Check Formatting"
    1. Pre-Check Formatting reviews all the records in the file to verify the formatting for each field is correct. It does not check the validity of the data
    2. For example, Pre-Check Formatting will check that the "Primary Grade ID" field contains no more than two numeric characters, but does NOT check if the Primary Grade ID code is a valid code
12. If there are no formatting errors, a sample of the data in the submission will be displayed
    1. Only the first 99 records in the submission will be displayed as part of the sample
13. If the sample looks correct, click the "Submit Data to DOE" button
    1. Your file is NOT submitted to i4see until you have clicked the "Submit Data to DOE" button
14. Navigate to the WORKQUEUE tab.  Your Submission Course should be at the top of the workqueue
    1. If the status is UPLOADING, please refresh the screen using the "Refresh" button. An Uploading status should not last longer than a few seconds
    2. If the status is BATCH VERIFIED WITH ERRORS, select the batch by clicking the "Select" button, then click "View Detail"
       1. This will allow you to view the errors that are preventing the batch from verifying, and to correct the records that are causing the errors
       2. Once you have corrected the errors, return to the Workqueue, select the batch again, and click "Verify"
15. Once the batch reaches BATCH VERIFIED, the submission is complete

Related articles

• Page:
  Submission Course FAQ
• Page:
  Student’s Grade Level has Changed since the BOY. Please exit the student...
• Page:
  Enrollment Status MUST NOT be 7
• Page:
  If Diploma Type =4 then AGE at EXIT DATE MUST BE > 16
• Page:
  If district responsible = 930 and town responsible = 990, then enrollment status = 2 or 11 (foreign exchange)