![Page 1: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/1.jpg)
Secretary’s Tool Box 2
![Page 2: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/2.jpg)
Affton School District ~ Converted to PS Jan 2008
Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant
Principal
Samantha Kurtzeborn – District Data Coordinator
![Page 3: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/3.jpg)
Agenda
• Daily Bulletin
• Change Student Field Values
• Honor Roll
• Reporting Engine Reports: EOY Checker, Pre-Low Current Grade Report and Individual Discipline Summary Report
• Mail Merge
![Page 4: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/4.jpg)
From the main menu, click on Special Functions, then
![Page 5: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/5.jpg)
![Page 6: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/6.jpg)
![Page 7: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/7.jpg)
Things To Make Your Bulletin Stand Out
• <marquee> - will make your title scroll• <font color=purple> - change your font
colors using HTML code• <font size=20> - change the size of your
font• Type in your message: Welcome Back !• Don’t forget to end all your commands by
using the /: </marquee></font></font color>
![Page 8: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/8.jpg)
Completing the fields
• Choose the date you want to publish your bulletin
• Choose your audience: Public (everyone can view it), Teachers (those with teacher and Admin access can view it), Admin (only those with Admin access can view it)
• Type in your message
• Submit
![Page 9: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/9.jpg)
Preview and Edit
• Click on Preview your bulletin
• If you don’t like the results, click on Edit and make your changes
• Click on submit and preview again
• This is the bulletin that will be seen if the user clicks on Daily Bulletin from the main menu
![Page 10: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/10.jpg)
Change or Clear Student Field Values
![Page 11: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/11.jpg)
![Page 12: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/12.jpg)
• You can also select a group of students to change or clear field values on.
• Once you’ve selected the students using “Select Students by Hand”, click on Select a Function, then choose “Student Field Value”
![Page 13: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/13.jpg)
Honor Roll
• From the main menu, click on School
• Click on Honor Roll
![Page 14: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/14.jpg)
![Page 15: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/15.jpg)
![Page 16: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/16.jpg)
![Page 17: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/17.jpg)
![Page 18: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/18.jpg)
• Click on System
• Click on Calculate Honor Roll
• Enter the Quarter in the Store Code Field
![Page 19: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/19.jpg)
• After pressing submit, the following message will appear:
![Page 20: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/20.jpg)
• Click on Reports
• Click on Run Reports
• Click on Honor Roll
![Page 21: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/21.jpg)
![Page 22: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/22.jpg)
Reporting Engine Reports
• EOY Checker
• Pre-Low Current Grade Report
• Individual Discipline Summary Report
![Page 23: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/23.jpg)
PRE - EOY Checker Report• Click on Reports
• Click on Reporting Engine – these are reports that your school has obtained from other sources
• Click on PRE-EOY checker
![Page 24: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/24.jpg)
![Page 25: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/25.jpg)
• View your report
• Errors will appear in Yellow so you know what to correct – you can click on the student and fix it immediately
![Page 26: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/26.jpg)
Pre-Low Current Grade Report
• Obtain a group of students based on their grades i.e.: students with 2 F’s as current grades
![Page 27: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/27.jpg)
• Reports
• Reporting Engine
• PRE-Low Current Grades
![Page 28: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/28.jpg)
![Page 29: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/29.jpg)
![Page 30: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/30.jpg)
• View report after it runs
• At the bottom of the report is a “group function” feature so you can now work with these students
![Page 31: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/31.jpg)
Individual Discipline Summary
• Click on Reports
• Reporting Engine
• Individual Discipline Summary
![Page 32: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/32.jpg)
How to find the Internal Student ID Number
To use this function, you will need the Internal Student ID number. You can find it by choosing your student, then clicking on “Teacher Comments”. The number at the bottom of this screen is the number you will need.
![Page 33: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/33.jpg)
Teacher Comment Screen
![Page 34: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/34.jpg)
![Page 35: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/35.jpg)
![Page 36: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/36.jpg)
• The report will automatically open
![Page 37: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/37.jpg)
Mail Merge
• Use with excel and word to make:– Labels– Letters– Certificates– Any other function where you are unable to
use PowerSchool easily!
![Page 38: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/38.jpg)
To begin…
• Choose a group of students by:
Selecting students by hand
Using an existing group of students
Selecting Students by Grade
Selecting Students by Gender
Selecting Students by Activity
Any other way you’d like to select them
![Page 39: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/39.jpg)
• Once you have selected your students– Choose Functions– Choose Quick Export– Fill in all the fields you want to export
![Page 40: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/40.jpg)
• You can set your browser to open automatically in Excel
• Delete any columns you don’t want or need
• Save your file
• Close Excel
• Open Word (we are on 2003)
![Page 41: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/41.jpg)
• Choose Tools– Letters and Mailings
• Mail Merge
![Page 42: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/42.jpg)
• From the menu on the right, choose the type of form you are using. Our example will be labels
Click Next to Continue
![Page 43: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/43.jpg)
• Chose Change Document Layout
Choose Label Options
![Page 44: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/44.jpg)
• Select Label
• Press OK
![Page 45: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/45.jpg)
• Select– Next: Select Recipients
![Page 46: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/46.jpg)
Select Browse
Then select your file from where you saved it
![Page 47: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/47.jpg)
If this is your file, click on OK
![Page 48: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/48.jpg)
Click on Next: Arrange your labels
![Page 49: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/49.jpg)
Click on More Item
Choose the fields using Insert, when done, close this box
![Page 50: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/50.jpg)
Click on Update all labels, then click Next: Preview your Labels
Change the layout by editing it i.e.: add a space, a comma, return to put something on next line, etc
![Page 51: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/51.jpg)
A preview of your labels will come up. If they look correct, click on Next: Complete the merge
![Page 52: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/52.jpg)
To complete the process, Click on Print.
Don’t forget to put labels in your printer!
![Page 53: Secretary’s Tool Box 2. Affton School District ~ Converted to PS Jan 2008 Becky Blake – Rogers Middle School, Registrar and Secretary to the Assistant](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfb91a28abf838c9fc53/html5/thumbnails/53.jpg)
Questions?
• We’ll be happy to answer any questions
• Becky Blake, 314-633-5973 [email protected]
• Samantha Kurtzeborn, 314-633-5924 [email protected]