/ Knowledge Base / K-12 Student Courses / K-12 Student Enrollment / Schools / SLP: Import List of Student Profiles

SLP: Import List of Student Profiles

Introduction:

A school can choose to add a single student account or upload multiple accounts through the use of a comma separated values (CSV) file. This process describes how to create the file and upload it to create multiple accounts in the Student Learning Portal.

Note: After a student account is created, the system will automatically make a guardian account. Once the student has been enrolled in a course, an email message will be sent to the guardian which will contain their account setup instructions. These accounts are generated with the intent of keeping guardians informed of student progress.

Details:

Step 1. Create the Import File

  1. First, tap the Affiliations tab in the top menu and then tap your affiliation name.
  2. Next, tap Bulk Import from the left navigation menu and open the Import Student Template.
  3. Then insert a row for each student which contains the required information are as follows:
    • firstname: This cell should contain the student’s first name.
    • lastname: This cell should contain the students last name.
    • dob: This cell should contain the student’s date of birth.
    • email: This cell should contain the student’s unique email address. (This will also be the student’s Username)
    • guardian1firstname: This cell should contain the primary guardian’s first name.
    • guardian1lastname: This cell should contain the primary guardian’s first name.
    • guardian1email: This cell should contain the primary guardian’s unique email address.
    • iep: This cell should contain a “1” if the student has an Individualized Education Program (IEP); if not, the cell should contain the number “0.”
    • section504: This cell should contain a “1” if the student has a 504 Plan; if not, the cell should contain the number “0.”
    • affiliationindex: Disregard this column, this cell should be blank.
      Note: Do not remove or alter the headers in this file or insert more than 200 students at a time.
      The data for ten students are shown as an example for completing the CSV file in Microsoft Excel.
  4. Next, select File and then select Save As and then choose the location on your computer where the file should be stored.
  5. To finish, rename the file using the File Name field and then change the Save as type field to “CSV (Comma delimited)” using the drop-down options.

Step 2. Import Student Profiles

  1. Begin by returning to the Student Learning Portal.
  2. Next, tap the Affiliations tab on the top menu.
  3. Then tap the name of your school in the “Name” column.
  4. Next, scroll to the bottom of the page and tap Bulk Import Students on the left navigation menu.
  5. At this point, you will be prompted to upload the file. Proceed by tapping the Choose File button.
    The Student Import page is showing an Upload File prompt. An arrow points to the Choose File button which is located above the Preview and Upload buttons.
  6. Then choose the file saved in step 2.
  7. Next, tap the Preview button to display the list of students to be imported.
    he Student Import page is showing an Upload File prompt. An arrow points to the Preview button just below the Choose File area.
  8. Then tap the Choose File button once again and select the file saved in step 2.
    The Student Import page is showing an Upload File prompt. An arrow points to the Choose File button which is located above the Preview and Upload buttons.
  9. Next, select the Upload button to import the students.
  10. At this time, a new column titled “Results” will appear next to each student record.
    • If “OK” is displayed, the student information was imported successfully.
    • If “Fail” is shown, the student profile was not successfully imported and must be recreated. Reference the “Messages” column for additional information.
      The Student Import page is showing an Upload File prompt. An arrow points to the Upload button just below the Choose File area.

Step 3. Verify Import

  1. First, tap the Students tab in the top menu bar.
  2. Finally, review the list of students to ensure the imported students are listed. At this point, student and guardian accounts are created and an email will be distributed to provide them with their login credentials.

Last updated on April 14, 2020

Keep up with the latest Michigan Virtual has to offer

Limited Course Capacity

We’re sorry to inform you that we have reached capacity for several of our Semester 1 and Trimester 1 courses. You’ll notice when attempting to enroll students in our Student Learning Portal that some courses are unavailable. While we are no longer accepting new enrollments for these courses at this time, many courses continue to remain open for enrollment.

With many students across the state 100% remote, demand for our online courses is greater than ever before. Because every course we offer is taught by a Michigan-certified teacher, this high volume of enrollments has created capacity issues for our teachers who provide each and every student with individual feedback.

While the Michigan Virtual team anticipated and planned for significant increases in student enrollments this Fall, the increased demand we’ve experienced has been unprecedented. As a result, we are taking steps to hire even more part-and full-time teachers to support larger numbers of student enrollments for Semester 2 as well as for Trimester 2 and 3. 

For schools that still need online learning options this year, please fill out the form at the bottom of our virtual pathways page to meet with someone to discuss other solutions. While some of our teacher-led courses are full, we may still have the capacity to help you in upcoming terms or can discuss timing to implement a whole-school or collaborative program in which local teachers from your school/district use our online course content to teach students. We also have free course content and resources available for you to use.

We know this is an incredibly stressful time for all, and we’re sorry if the courses you’re looking for are unavailable. We never want to turn away a student who wants to learn from us. Our top concern, however, is student success, and we have a policy to not take on additional enrollments if we cannot guarantee that all students will have a quality online learning experience. 

We appreciate your patience and understanding as we navigate the unusually high volume of enrollments we are receiving.