Importing Achievement Standards in Bulk

How do I bulk import achievement standards/outcomes for my school?

Uploading standards one at a time would be a pain. Luckily, we make it easy for you:

Steps:

  1. Navigate to your Admin Dashboard
  2. Click on the Achievement > Bulk Import tab
  3. Create a copy of the spreadsheet template provided
  4. Input your data into your new spreadsheet
  5. Download the data as a CSV (Comma-Separated Values) File
  6. Click“Next”
  7. Upload your CSV file for validation
  8. Review your data
  9. Click“Next” (Again)
  10. Confirm and import your data

1. Navigate to your Admin Dashboard

You can get to your dashboard in 2 ways:

a) Use the drop down menu in the top right corner and click“AdminDashboard”

image_preview-20

b) From your main dashboard, click“AdminDashboard”

image_preview-21

If you are a school administrator, but are unable to see your admin dashboard, please contact us at hello@wabisabizen.com. We’ll get you set up properly.

2. Click on the Achievement > Bulk Import tab

On your side nav, click Achievement > Bulk Import.

image_preview-22

3. Create a copy of the spreadsheet template provided

Click on the big purple icon to view a copy of the spreadsheet template you will need, in Google Sheets. If you already have a CSV of your data handy, skip to Step 6.

image_preview-23

Create a copy of the template by clicking File > Make a Copy.  If you do not make a copy, you will not be able to edit the spreadsheet!

image_preview-1-10

Workbook Sheets

Sheet 1 of the workbook you have just copied has instructions for how to enter your data into the spreadsheet.

image_preview-24

Sheet 2 of the workbook is a sample spreadsheet with example data on it.

image_preview-25

Sheet 3 is the blank template you will use to input your data

image_preview-26

4. Input your data into your new spreadsheet

Make sure you are on the last sheet in the workbook (Blank Template). Input all your achievement standard data into your sheet.

5. Download the data as a CSV (Comma-Separated.Values) File

Before we can use this data in Wabisabi, it must be saved as a CSV file. If you skip this step, the import will not work. To do this, click File > Download As > Comma-separate values(.csv,current sheet). 

image_preview-27

This will download your data as a CSV onto your computer.

Note: Make sure you are on the sheet with all your data when you do this!

6. Click“Next”

When your CSV is ready, head back to the Wabisabi app and click “Next”.

image_preview-28

7. Upload your CSV file for validation

Click on the big purple icon to upload your new CSV. You will have a chance to review your data before you import (this may take several minutes).

image_preview-29

8. Review your data

Almost there! If there are any errors in your spreadsheet, the app will ask you to fix your changes before proceeding. To fix your changes, go back to Step 4, update your sheet, download a new CSV and try again.

image_preview-30

If the app did not find any errors, you are ready to review your data for import

image_preview-1-11

Click Next, and use the arrows to review your standards.

Note: You must review all your data (scroll to the very last set of standards) before the app will let you proceed to the next step.

image_preview-31

9. Click“Next” (Again)

Once you have reviewed all your data and are ready to import, click “Next”.

image_preview-32

10. Confirm and import your data

Satisfied with your data? Good! Confirm that your data is correct by checking the box, then click Confirm & Submit. Your import will begin and could take several minutes.

image_preview-1-12

That’s it! Pat yourself on the back for a job well done.