Differences

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

--- powerschool:powerschool:homeroom [2015/07/22 11:13]
lokes
+++ powerschool:powerschool:homeroom [2017/07/11 08:14]
jrhea
@@ Line 1: / Line 1: @@
 ====== Homeroom Field Import ======
-Contact Jennifer Rhea or Lisa Okes as you are preparing for the upcoming school year. All of last year's homeroom teachers can be cleared out of the Homeroom field in the Modify Info Page in a single operation. Once it's cleared out, there are three options for updating the homeroom teachers' names.
+All of last year's homeroom teachers can be cleared out of the Homeroom field in the Modify Info Page in a single operation.  To have this done contact Jennifer Rhea or Lisa Okes as you are preparing for the upcoming school year. Once it's cleared out, there are three options for updating the homeroom teachers' names.
 **Option 1:** Manually enter the homeroom teacher for each student on the Modify Info page. (Probably not the best!)
@@ Line 9: / Line 9: @@
 **Option 3:**  If you have not scheduled your students and you want the homeroom field updated, please follow these instructions to prepare a MS Excel spreadsheet for Lisa or Jennifer to import. Of course, only request this for the students that have not manually been updated.
-  - On the start page, select All (beside of the grade options)
+  * On the Start page, select **All** (as a grade option)
-  - From the group functions menu, choose Quick Export
+  * From the Group Functions menu, choose **Quick Export**
-  - In the field window, include:
+  * In the Field window, include:
-  *              student_number
+           * student_number
-  *              lastfirst
+           * lastfirst
-  *              grade_level
+           * grade_level
-  *              home_room
+           * home_room
-  - Submit and either open or save in Microsoft Excel
+  * Sort by grade_level
-  - Sort by grade_level
+  * Click **Submit** and either open or save in Microsoft Excel
-  - Enter the teacher names in the home_room column for each student (see example below).  **Note:** you can copy/paste to save time.  In case you aren't aware of it, MS Excel also has a memory feature that will allow you to type the first letter or two of a word and it will recall a previous entry so all you need to do is hit enter.
+Within the MS Excel Spreadsheet, enter the teacher names in the home_room column for each student (see example below).
-  -
-  - {{:powerschool:powerschool:homeroom_spreadsheet.png}}
-  -
-  - Once you're finished, save the file as an Excel (.xls) file and email it to Jennifer or Lisa.
+**Note:** It is extremely important that the teachers' names are standardized when entering them in the Home Room field on the Modify Info page.  Some students may have "Warner, Griffith" for the Home_Room field, and some may have "Warner, Griffith A.".  That makes other programs that use PowerSchool data consider them to be different homerooms. //Copy/paste to save time. MS Excel also has a memory feature that will allow you to type the first letter or two of a word and it will recall a previous entry so all you need to do is hit enter.//
+{{:powerschool:powerschool:homeroom_spreadsheet.png}}
+Once you've finished the list, save the file as an Excel (.xls) file and email it to Jennifer or Lisa.

Knowledge Base

User Tools

Site Tools

Differences

Page Tools