Queries needed from Amanda Johnson’s VC Workspace:
Hapara Students Query
Download Student query data in Excel
In Class column:
-Replace : with -
-Replace spaces with -
-Replace -- with -
-Replace . with -
-Replace / with -
-Create new column next to Class column and input -2223 in every cell next to Class column
Concatenate Class column + -2223 column
-Copy concatenated information, paste special (values only) and delete Class and -2223 columns
(-2223 will change to 2324 next school year, and so on for each school year)
Copy information from Excel into a Google Sheet
Name Google Sheet - TD Students + 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 Students, 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