1 / 38

Analyzing Attendance using WVEIS and Excel

Analyzing Attendance using WVEIS and Excel. Glenn Sweet Attendance Director Barbour County Schools. Originally this was Sufficient. What Changed. A New Board of Education A New Superintendent A Chart From Monroe County A Challenge Indeed. The Chart Looked Like This!. Where To Start.

telyn
Download Presentation

Analyzing Attendance using WVEIS and Excel

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. Analyzing Attendanceusing WVEISand Excel Glenn Sweet Attendance Director Barbour County Schools

  2. Originally this was Sufficient

  3. What Changed A New Board of Education A New Superintendent A Chart From Monroe County A Challenge Indeed

  4. The Chart Looked Like This!

  5. Where To Start • I Called Maury in Monroe County • Maury Ran Several WVEIS Reports • Then He Counted Kids and Put it Into Excel • Then I Called Susan Harker at RESA VII • Please Create a Query to Download into Excel • Then I Talked to A Barbour County Excel Guru • Please Create a Spread Sheet Using Given Data

  6. So What Happened? Maury had a One Month Warning to Meet the Challenge. I was Given a Six Month Warning. I Believed That The Data Could Be Manipulated. I Recruited the Right People.

  7. Susan’s Work

  8. Susan’s Work

  9. Susan’s WorkSteps 1 & 2

  10. Susan’s Work Steps 3 & 4 Run by Simply Running the Program The File is Now Created

  11. Transfer the Data to Excel

  12. Transfer the Data to Excel

  13. Transfer the Data to Excel

  14. Transfer the Data to Excel

  15. Transfer the Data to Excel

  16. Transfer the Data to Excel

  17. Transfer the Data to Excel

  18. Transfer the Data to Excel

  19. Transfer the Data to Excel

  20. Transfer the Data to Excel

  21. Transfer the Data to Excel

  22. Transfer the Data to Excel

  23. Add Formula to Column I=D1+F1

  24. Drag the Formula to the Bottom of the Chart

  25. Copy This Chart

  26. Open Attendance ChartYTD Previous Month

  27. Paste New Chart into Previous

  28. Save As New Chart

  29. Sharon’s Work Automatically is Applied to Each School Chart

  30. Low SES

  31. Special Education

  32. Ability to Drill Down to Students

  33. Sort for Easier Identificationof Issues School Specific Largest To Smallest

  34. Focus on Specific Students By Student ID

  35. A Principal’s Exercise Principal’s are Overwhelmed They Need Something Easy to Guide Them for Diagnostics A Chart Was Developed

  36. Attendance Workbook

  37. Questions

  38. Glenn J. Sweet Director/Manager Attendance, Facilities,& Technology Barbour County Schools 105 South Railroad Street Philippi, WV 26416 (304) 457-3030 extension 127 (304) 457-3559 (FAX) Have a 'POSITIVE Day!

More Related