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:26] – [Syntax (Format)] 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 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 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 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 ===== | ||
{{ : | {{ : |
admin/spreadsheet_file_format.txt · Last modified: 2024/03/05 13:13 by 127.0.0.1