Queries needed from Amanda Johnson’s VC Workspace:
Hapara Class Query
Hapara Students Query
Download Class query data in Excel
In Mailbox & Name columns:
-Replace : with -
-Replace spaces with -
-Replace -- with -
-Replace . with -
-Replace / with -
-Create new column next to Name column and input -2223 in every cell next to Name column
Concatenate Name column + -2223 column
-Copy concatenated information, paste special (values only) and delete Name and -2223 columns
(-2223 will change to 2324 next school year, and so on for each school year)
43 = Lilburn HS School ID, make sure 43 is next to every class in the spreadsheet
Copy information from Excel into a Google Sheet
Name Google Sheet - TD Classes + school year (2223, 2324, 2425, etc)
Share Google Sheet with School Docs Owner
Go to teacherdashboard.com, sign in with Google
Click on the settings wheel in top right corner
Click Data Loader
In the Upload Data column, select Upload CSV or Google Sheet
Click Next
In the Locate File section, type in TD Classes, find the correct spreadsheet and click Verify
Once verified, click Start Load
Spreadsheet will load and return with any errors, go back in spreadsheet to fix any errors and reload as needed