1 / 38

Streamlining Attendance Analysis in Barbour County Schools Using WVEIS and Excel

This document outlines a comprehensive approach to analyzing attendance data within Barbour County Schools using WVEIS and Excel. With input from key stakeholders, including Maury from Monroe County and Susan Harker from RESA VII, the process includes creating a query to efficiently download and manipulate data. The focus is on developing an easy-to-use attendance workbook that assists school principals in diagnosing issues related to attendance, special education, and socio-economic status, ultimately optimizing support for students in need.

telyn
Télécharger la présentation

Streamlining Attendance Analysis in Barbour County Schools 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