As the Administrator, run the report Reports / Staff Reference after the accounts have been created to obtain the numeric code for each classroom.
Go to the page Students / Bulk Load to learn the format of the spreadsheet for loading student accounts.
Export the student information, including street address, from your Student Information System into a spreadsheet.
Sort the spreadsheet by street address.
Determine the column to be used for the carpool numbers
In the second row of the spreadsheet enter a formula to calculate the carpool number
Here is an example of the formula, assuming that the second student record field for the carpool ID is in column H, row 3 and the student street address is in column K:
=if(K3=K2,H2,H2+1)
This formula is interpreted as follows:
if the current street address (k3) is the same (equal to) the street address of the preceding student (K2), then use the same carpool number (H2), but if it is different, then add one the carpool number (H2+1)
In the first row of the student records (H2), enter the starting carpool number such as 1, 100, or 101
Once the carpool numbers have been calculated, select the entire column, then perform a copy followed by a paste as value operation to replace the formulas with actual numbers so that the numbers won't change when the data is moved around
Now fill in the classroom field column with the proper staff reference value from the report above. You may do this by performing a search and replace (CTRL-H) on the teacher names or by sorting the student records by staff name then entering the reference number using the keyboard and mouse to copy and paste into the appropriate fields
Enter the appropriate numeric value for the student grade as defined in the instructions: Use a numeric value for the grade with 0 for kindergarten, -1 for 4K (pre K), -2 for 3K, and -3 for Other. If not entered, all accounts will default to kindergarten.
Finally, copy all five columns of data - Last Name, First Name, Carpool ID, Grade, and Class Code from the spreadsheet for all of the students, paste into the input field in Silent Dismissal, set the drop down to Use Data Set, then press Submit