Analyzing Attendance using WVEIS and Excel

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
Susans Work
8
Susans Work
9
Susans WorkSteps 1 2
10
Susans 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 ID1F1
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
Sharons 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 Principals Exercise

• Principals 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 [phone] extension 127 [phone]
(FAX) Have a 'POSITIVE Day!