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/11 17:40] – [Creation] lillie | admin:spreadsheet_file_format [2019/07/25 22:58] – lillie | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Spreadsheet File Formats ====== | ====== Spreadsheet File Formats ====== | ||
- | To create a viable spreadsheet file capable of transition | + | To create a viable spreadsheet file capable of transfer |
With the assistance of this guide, the task of creating spreadsheet(s) for initial data load will be most efficient. A minimum of two sets of data should be provided: the [[admin: | With the assistance of this guide, the task of creating spreadsheet(s) for initial data load will be most efficient. A minimum of two sets of data should be provided: the [[admin: | ||
Ideally, the [[admin: | Ideally, the [[admin: | ||
+ | ===== Blank Spreadsheet with Column Headers ===== | ||
+ | {{ : | ||
+ | |||
===== Faculty & Staff Accounts ===== | ===== Faculty & Staff Accounts ===== | ||
Line 31: | Line 34: | ||
* Defaults to the user's last name in lower case if omitted. May optionally be specified with the same value for all staff during initial configuration | * Defaults to the user's last name in lower case if omitted. May optionally be specified with the same value for all staff during initial configuration | ||
- | ==== Creation | + | ==== Bulk Loading |
Once this data has been collected and input into a spreadsheet, | Once this data has been collected and input into a spreadsheet, | ||
Line 39: | Line 42: | ||
- 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 " | - After verifying this data is correct, click on the " | ||
+ | {{: | ||
===== Student List ===== | ===== Student List ===== | ||
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, | ||
Line 56: | Line 59: | ||
- GRADE [// | - GRADE [// | ||
* Strongly recommended to allows students to be directly loaded into grade rosters | * Strongly recommended to allows students to be directly loaded into grade rosters | ||
- | - CLASS CODE [// | + | - [[admin: |
* This information can be located by clicking on **REPORTS** then under **DATA REVIEW** click **STAFF REFERENCE**. A reference list of staff and their classrooms should appear, and the class code will be present in the column farthest to the left. | * This information can be located by clicking on **REPORTS** then under **DATA REVIEW** click **STAFF REFERENCE**. A reference list of staff and their classrooms should appear, and the class code will be present in the column farthest to the left. | ||
- | * Strongly recommended to allows | + | * Strongly recommended to allow students to be directly loaded into classroom rosters |
- Student ID [// | - Student ID [// | ||
* Recommended, | * Recommended, | ||
Line 64: | Line 67: | ||
FIXME [[admin: | FIXME [[admin: | ||
- | ==== Creation | + | ==== Bulk Loading |
Once this data has been collected and input into a spreadsheet, | Once this data has been collected and input into a spreadsheet, | ||
Line 71: | Line 74: | ||
- 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. | ||
+ | {{: | ||
===== Groups, Locations, and Messages ===== | ===== Groups, Locations, and Messages ===== | ||
{{ : | {{ : | ||
Line 90: | Line 94: | ||
| **m** - Message | **l** - Location | **z** - Zone Location | | | **m** - Message | **l** - Location | **z** - Zone Location | | ||
- | ==== Creation | + | ==== Bulk Loading |
- From an administrator account, click on **GROUPS** at the top of the page. You should see a dropdown menu. Click on **BULK LOAD**. This will direct you to a webpage with an empty textbox. | - From an administrator account, click on **GROUPS** at the top of the page. You should see a dropdown menu. Click on **BULK LOAD**. This will direct you to a webpage with an empty textbox. | ||
Line 96: | Line 100: | ||
- 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. | ||
+ | {{: | ||
===== Bus Stops ===== | ===== Bus Stops ===== | ||
{{ : | {{ : | ||
Line 107: | Line 112: | ||
* Each bus stop list must be loaded individually for each bus and the ordering of the bus stops is predicated on the order of the list. | * Each bus stop list must be loaded individually for each bus and the ordering of the bus stops is predicated on the order of the list. | ||
- | ==== Creation | + | ==== 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**. This will direct you to a webpage that looks like the screenshots below. | ||
- 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. |
admin/spreadsheet_file_format.txt · Last modified: 2024/03/05 13:13 by 127.0.0.1