ABCDEFGHIJKMNOPQRSTUVWXYZ
1
1. Student Data on Chronic Absence
2
Quickstart: Enter information in the light blue cells. All the other areas get automatically generated. More detailed instructions are in the "Guide" tab.
3
A. Classroom Information
4
In Cell B4: Enter your name or classroom numberIn Cell D4: Enter time period (e.g., Fall Semester 2017)In Cell F4: Enter total number of school days within time period. (Enter whole numbers only)
5
6
B. Student Information
7
Type or paste into columns A through F beginning on row 10. Do not paste over columns G through J.
8
(Optional) Enter Student IDEnter Student's First NameEnter Student's Last NameEnter the number of days student has been present (within timeframe)Enter the total number of days student has been absent (within timeframe)(Optional) Indicate whether the student was chronically absent last school year using drop-down menuDo not enter data below. Sort by clicking on the arrow on row 9 and selecting "sort."Do not enter data below. Do not enter data below.Double check cells D and E in the same row if this column does not say "adds up."
9
Student _IDFirst_NameLast_NameDays_PresentDays_Absent
Prev_Year_Chronic_Absence
Chronic Absence Rate
Chronic Absence Tier
Color codingCheck
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100