Setting Up Class and Student Spreadsheets Follow

The Hapara Data Loader offer three methods for loading Class and Student data into Hapara. The most commonly used method, particularly for smaller schools, is a manual load. This article details the process for setting up spreadsheets for manual loads.

The Manual Configuration page provides template Class and Student files for you to populate. These templates are built to exactly match the settings specifies in the Manual Configuration page, making the templates easier to populate.

The manual load method has the following steps: 

  1. Log in to the Hapara Admin Console.
  2. Browse to the Data Loader menu option.
  3. Select the Manual Configuration link.
  4. Use the Data Loader Manual Configuration page to select how you will use several Hapara features.
  5. Using the template Class and Student files (either Google Sheets or CSVs) provided on the Manual Configuration page, populate the templates with your Class and Student data.
  6. If you are using Google Sheets, share your spreadsheets with the Institutional Content Owner user (named school.apps.owner for most schools).
  7. Use the Data Loader Manual Load page to start the load of your Class file (Google Sheet or CSV) into Hapara.
  8. Loading large files can take a while to complete. Use the Data Loader Status page to monitor the progress of your load or to view the results of historic loads. You can also track any errors that may result from your data load. Also refer Data Loader Status page guide
  9. When the Class load is finished, use the Data Loader Manual Load page to start the load of your Students file (Google Sheet or CSV) into Hapara.

At the start of the school year, you will want the Class and Student files to contain all of your classes and students. During the school year, you may want to incrementally add classes, change teachers, or update class rosters.

Note: Whenever you load an existing student, you must include each of that student's classes in your spreadsheet. If you only include one class for a student, they will be removed from every other class in Hapara.

The article Making Changes to Classes and Students explains additional steps for this process.



Have more questions? Submit a request