1 / 31

Tips and Tricks for an Accurate Pupil Count

Tips and Tricks for an Accurate Pupil Count. Laura Siek Greenville Public Schools. Who’s here?. Name School Position Things you might be interested in seeing if PowerSchool can do. A little about Russ. Tech Geek Davenport University School employee for 10 years Network Administrator

danton
Download Presentation

Tips and Tricks for an Accurate Pupil Count

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Tips and Tricks for anAccuratePupil Count Laura Siek Greenville Public Schools

  2. Who’s here? • Name • School • Position • Things you might be interested in seeing if PowerSchool can do.

  3. A little about Russ • Tech Geek • Davenport University • School employee for 10 years • Network Administrator • Married for 8 years • 4 kids

  4. One More Thing to Learn?

  5. Don’t re-invent the wheel!

  6. Quick Easy Steps • Cheat Sheet • PowerSchool • Microsoft Excel - formulas - auto filter - pivot tables • Access database - import - export

  7. BE PRO-ACTIVE • Use PowerSchool to the extent possible and make changes at the source file level BEFORE creating XML file. • XML = Extremely Maddening Language

  8. Power School Cheat Sheet A year’s worth of experience – free!

  9. Identifying fields with Missing Data MSDS will reject files with missing data! /gender=/ back slash yields results for students who are current AND students who are inactive

  10. Power School Quick Export

  11. Start Page > Special Functions > Importing & Exporting > Quick Export *** Power School Quick Export *** breadcrumbs

  12. Identifying fields with Incorrect Data Using Excel Selected fields to export: Student_Number First_name Last_name SchoolID Enrollment_SchoolID =IF(D6=E6,"OK","Problem")

  13. Before Each Count STUDENT FIELD VALUE***Clear prior 10/30 day rule field valuesMass change field values (operating district)Delete FTE for students who exited the district*** valuable for changing multiple students

  14. List Students in Power School • Homeless students • Foreign Exchange students • Non-Resident students • SNE – Supplemental Nutrition students • LEP – Limited English Proficient • Migrant students • Special Education students

  15. List Students in Power School Start Page: Homeless #

  16. List Students in Power School Select a function for this group of students: List Students

  17. List Students in Power School *count will number your students for you

  18. List Students in Power School Right click / Copy / Paste into Word document

  19. Power School Reports • General Collection Validation Report • Official Enrollment Student Roster • MI SRSD Extract • 75% Attendance Report • MI General Collection – generates xml file

  20. Power School Reports

  21. Tips and Tricks = Equals (first_name=Jamaal) < Is less than (grade_level<11) > Is greater than (grade_level>3) <= Is less than or equal to (grade_level<=10) >= Is greater than or equal to (grade_level>=4) # Does not equal football# (football is not blank) In - Value is present in the field (last_name in yang,holt) Contains - value is contained in the field (street contains maple) @ Wildcard (first_name=jacq@) *as_of=00/00/0000

  22. Tips and Tricks Multiple Selections Use a comma between criteria, a semi-colon between fields. Grade_level in 9,11;gender=f

  23. Tips and Tricks Excel Tips =IF(A2=B2,”OK”,”Problem” =LEFT(A1,3) =RIGHT(A1,3) =CONCATENATE(A1,” “,B1)

  24. I LOVE MY JOB! I LOVE MY JOB! • Russell Hoorn II • rhoorn@kvilleps.org Contact info

  25. Contact info • Russell Hoorn II • rhoorn@kvilleps.org

More Related