admin:spreadsheet_file_format
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
admin:spreadsheet_file_format [2019/07/25 22:58] – lillie | admin:spreadsheet_file_format [2019/08/13 13:03] – [Bulk Loading] lillie | ||
---|---|---|---|
Line 16: | Line 16: | ||
* Extended care accounts (denoted by letter " | * Extended care accounts (denoted by letter " | ||
- | ==== Syntax (Format) | + | ==== Format |
{{ : | {{ : | ||
A minimum of five columns of information is required to create facility & staff accounts. While it is constructive to fill each column with their respective value, many of these fields are optional. **The information entered should be either in Title Case or lowercase, but __not in all capital letters__.** | A minimum of five columns of information is required to create facility & staff accounts. While it is constructive to fill each column with their respective value, many of these fields are optional. **The information entered should be either in Title Case or lowercase, but __not in all capital letters__.** | ||
Line 46: | Line 46: | ||
After creating user accounts for Silent Dismissal, the next step is to create your student list. This will allow for the creation of student profiles, which can then be assigned to their respective classrooms, groups, etc. While this process is similar to user account creation, please be aware there are important differences, | After creating user accounts for Silent Dismissal, the next step is to create your student list. This will allow for the creation of student profiles, which can then be assigned to their respective classrooms, groups, etc. While this process is similar to user account creation, please be aware there are important differences, | ||
- | ==== Syntax (Format) ==== | + | ==== Format |
{{ : | {{ : | ||
A minimum of five columns of information is required to create student lists. While it is constructive to fill each column with their respective value, many of these fields are optional. **The information entered should be either in Title Case or lowercase, but __not in all capital letters__.** | A minimum of five columns of information is required to create student lists. While it is constructive to fill each column with their respective value, many of these fields are optional. **The information entered should be either in Title Case or lowercase, but __not in all capital letters__.** | ||
Line 65: | Line 65: | ||
* Recommended, | * Recommended, | ||
- | FIXME [[admin: | + | [[admin: |
==== Bulk Loading ==== | ==== Bulk Loading ==== | ||
Line 79: | Line 79: | ||
Now that the faculty & staff accounts and student lists have been created and reviewed, it is possible to create a spreadsheet with information on the school' | Now that the faculty & staff accounts and student lists have been created and reviewed, it is possible to create a spreadsheet with information on the school' | ||
- | ==== Syntax (Format) ==== | + | ==== Format |
Groups, locations, and messages require two columns of data to be bulk loaded. The information entered should be either in Title Case or lowercase, but not in all capital letters. | Groups, locations, and messages require two columns of data to be bulk loaded. The information entered should be either in Title Case or lowercase, but not in all capital letters. | ||
Line 105: | Line 105: | ||
Finally, the last spreadsheet to be prepared for bulk loading is the bus stop spreadsheet. While some schools have used this feature, it is considered to be optional. | Finally, the last spreadsheet to be prepared for bulk loading is the bus stop spreadsheet. While some schools have used this feature, it is considered to be optional. | ||
- | ==== Syntax (Format)==== | + | ==== Format |
Bus stops may be set by parents if desired by the school. To load the bus stops two pieces of information are required: | Bus stops may be set by parents if desired by the school. To load the bus stops two pieces of information are required: | ||
- BUS STOP NAME [**required**] - Name of the bus stop, usually an address | - BUS STOP NAME [**required**] - Name of the bus stop, usually an address | ||
Line 113: | Line 113: | ||
==== Bulk Loading ==== | ==== Bulk Loading ==== | ||
- | - From an administrator account, click on **GROUPS** at the top of the page. You should see a dropdown menu. Next, click on **BUS**. This will direct you to a webpage that looks like the screenshots below. | + | - From an administrator account, click on **GROUPS** at the top of the page. You should see a dropdown menu. Next, click on **BUS**. From the table of buses, click the value of the bus you would like to edit under the " |
- Using your spreadsheet containing account data, select the columns & rows for each student that must be created, including columns that were left blank during data input as they will serve as a placeholder. | - Using your spreadsheet containing account data, select the columns & rows for each student that must be created, including columns that were left blank during data input as they will serve as a placeholder. | ||
- Copy & paste your selection from the spreadsheet into the textbox on the page. Remember to review your entry to avoid errors in transfer. | - Copy & paste your selection from the spreadsheet into the textbox on the page. Remember to review your entry to avoid errors in transfer. | ||
- After verifying this data is correct, click on the “Submit” button below the textbox. | - After verifying this data is correct, click on the “Submit” button below the textbox. | ||
{{: | {{: |
admin/spreadsheet_file_format.txt · Last modified: 2024/03/05 13:13 by 127.0.0.1