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 18:06] – [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 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