User Tools

Site Tools


admin:spreadsheet_file_format

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
admin:spreadsheet_file_format [2019/07/11 18:12] – [Creation] lillieadmin:spreadsheet_file_format [2019/07/18 18:52] – [Syntax (Format)] lillie
Line 1: Line 1:
 ====== Spreadsheet File Formats ====== ====== Spreadsheet File Formats ======
-To create a viable spreadsheet file capable of transition to the Silent Dismissal system, it is crucial to understand its components. As mentioned on the **[[admin:getting_started|Getting Started]]** page, the system does not have preloaded information. It is the responsibility of clientele to create their school's database, which includes all the information necessary to fully utilize our service.+To create a viable spreadsheet file capable of transfer to the Silent Dismissal system, it is crucial to understand its components. As mentioned on the **[[admin:getting_started|Getting Started]]** page, the system does not have preloaded information. It is the responsibility of clientele to create their school's database, which includes all the information necessary to fully utilize our service.
  
 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:spreadsheet_file_format#Faculty & Staff Accounts|facility & staff account list]] and the [[admin:spreadsheet_file_format#Student List|student list]]. Both of these accounts have fields (required or optional) that use their input values to determine aspects of account creation. 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:spreadsheet_file_format#Faculty & Staff Accounts|facility & staff account list]] and the [[admin:spreadsheet_file_format#Student List|student list]]. Both of these accounts have fields (required or optional) that use their input values to determine aspects of account creation.
  
 Ideally, the [[admin:spreadsheet_file_format#Groups, Locations, and Messages|Groups, Locations, and Messages]] spreadsheet will also be created; if this information is not collected in a spreadsheet, it may be entered manually at the school directly into Silent Dismissal. For most schools, the [[admin:spreadsheet_file_format#Bus Stops|Bus Stops]] spreadsheet will not be used, but this feature is available for later use if desired. Ideally, the [[admin:spreadsheet_file_format#Groups, Locations, and Messages|Groups, Locations, and Messages]] spreadsheet will also be created; if this information is not collected in a spreadsheet, it may be entered manually at the school directly into Silent Dismissal. For most schools, the [[admin:spreadsheet_file_format#Bus Stops|Bus Stops]] spreadsheet will not be used, but this feature is available for later use if desired.
 +===== Blank Spreadsheet with Column Headers =====
 +{{ :admin:sample_load_file.xlsx |}}
 +
 ===== Faculty & Staff Accounts ===== ===== Faculty & Staff Accounts =====
  
Line 58: Line 61:
   - CLASS CODE [//​optional//​] - Numeric value that corresponds to a specific classroom.   - CLASS CODE [//​optional//​] - Numeric value that corresponds to a specific classroom.
     * 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 students to be directly loaded into classroom rosters+    * Strongly recommended to allow students to be directly loaded into classroom rosters
   - Student ID [//​optional//​] - Unique ID given to student   - Student ID [//​optional//​] - Unique ID given to student
     * Recommended,​ however will be available for updates later     * Recommended,​ however will be available for updates later
Line 97: 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.
 +{{:lillie:group-loading-1.png?600|}} {{:lillie:group-loading-2.png?600|}}
 ===== Bus Stops ===== ===== Bus Stops =====
 {{ :lillie:spreadsheet-setup-4.png?600|}} {{ :lillie:spreadsheet-setup-4.png?600|}}
admin/spreadsheet_file_format.txt · Last modified: 2024/03/05 13:13 by 127.0.0.1