Author Archives: Stan Jester

Formula To Calculate Moving To Hybrid

DeKalb Schools administration stated the school district will begin the transition to a hybrid learning model if the Cases Per 100K (Last 2 Weeks) is below 100 for 14 days straight. How do we calculate that?

The data comes from the Georgia Department of Public Health Daily Status Report. If you roll over DeKalb, you will see the statistics for DeKalb County. If you roll over the bar graph on the right, you will get the Confirmed Cases for that day.

Cases (last 2 weeks): The sum of the Confirmed Cases for the last 14 days
Population: 793,154 – Using 2018 U.S. Census data to derive population
Cases per 100k (last 2 weeks) = 100,000 x Cases (last 2 weeks) / Population

 click to enlarge image
DeKalb Cases Per 100k


CASES PER 100K (LAST 2 WEEKS)

It’s been 4 months since the Shelter In Place time period and it was the last time DeKalb Schools has seen less than 100 cases per 100K (last 2 weeks). Here are the cases per 100K (last 2 weeks) for every day since July.

DeKalb Schools Cases Per 100K Last 2 Weeks

57 CASES PER DAY = 100 cases per 100K
If DeKalb County averages 57 cases per day for 14 days, that will be 100 cases per 100K (last 2 weeks). Since July, DeKalb has gone under 57 cases for the day half a dozen times.

RAW DATA – CASES PER 100K (LAST 2 WEEKS)
Date Cases That Day Cases per 100K (Last 2 Weeks) Date
9/21 30 117 9/21
9/20 65 115 9/20
9/19 82 116 9/19
9/18 52 117 9/18
9/17 67 118 9/17
9/16 75 123 9/16
9/15 76 122 9/15
9/14 77 124 9/14
9/13 44 121 9/13
9/12 82 122 9/12
9/11 77 122 9/11
9/10 71 124 9/10
9/9 60 126 9/9
9/8 71 128 9/8
9/7 11 131 9/7
9/6 72 135 9/6
9/5 94 135 9/5
9/4 55 137 9/4
9/3 112 144 9/3
9/2 68 150 9/2
9/1 91 152 9/1
8/31 55 165 8/31
8/30 48 166 8/30
8/29 80 171 8/29
8/28 92 175 8/28
8/27 88 183 8/27
8/26 81 189 8/26
8/25 93 200 8/25
8/24 39 211 8/24
8/23 76 224 8/23
8/22 105 237 8/22
8/21 111 255 8/21
8/20 164 269 8/20
8/19 86 279 8/19
8/18 187 292 8/18
8/17 69 286 8/17
8/16 84 296 8/16
8/15 112 303 8/15
8/14 155 317 8/14
8/13 135 322 8/13
8/12 168 330 8/12
8/11 184 332 8/11
8/10 137 337 8/10
8/9 185 337 8/9
8/8 243 330 8/8
8/7 227 327 8/7
8/6 244 335 8/6
8/5 188 330 8/5
8/4 138 337 8/4
8/3 147 342 8/3
8/2 142 337 8/2
8/1 222 345 8/1
7/31 192 357 7/31
7/30 199 355 7/30
7/29 187 354 7/29
7/28 218 358 7/28
7/27 139 357 7/27
7/26 129 381 7/26
7/25 222 386 7/25
7/24 288 381 7/24
7/23 208 381 7/23
7/22 245 382 7/22
7/21 178 378 7/21
7/20 106 386 7/20
7/19 204 387 7/19
7/18 315 392 7/18
7/17 181 383 7/17
7/16 187 382 7/16
7/15 222 392 7/15
7/14 206 395 7/14
7/13 327 7/13
7/12 173 7/12
7/11 184 7/11
7/10 283 7/10
7/9 217 7/9
7/8 213 7/8
7/7 241 7/7
7/6 114 7/6
7/5 245 7/5
7/4 242 7/4
7/3 176 7/3
7/2 269 7/2
7/1 245 7/1

COVID-19 Cases Trending Down

Over the last few days the COVID-19 “Cases per 100K (last 2 weeks)” in DeKalb have gone from 122 to 117. DeKalb Schools will begin the transition to a hybrid learning model if the Cases per 100K (last 2 weeks) is below 100 for 14 days straight.

DeKalb Schools Calculations To Move To Hybrid are the conditions under which the school district would transition to a hybrid learning environment. The Georgia Department of Public Health provides a daily report with the data points used to make these calculations.

click to enlarge image

Kindergarten and Pre-K Enrollment
Enrollment is generally down across the district, but Pre-Kindergarten and Kindergarten seem to have been hit the hardest. Total K enrollment for the district is 4,982. DeKalb Schools originally forecasted to have 7,484 students in Kindergarten. There are 2,502 fewer kindergarten students than projected. Pre-K enrollment is down by 453 students. The originally projected Pre-K enrollment was 2,555.

Chromebook Distribution
The administration tells me this is the current status of Chromebook distribution.

• Phase I – Distribution to Grades 3-12 – 100% Complete
• Phase II – Distribution to Grades 1-2 – 100% Complete
• Phase II – Distribution to K and PreK – 0% Complete (Waiting on shipment of devices)

IT is shifting the repair strategy to prioritize new student repair requests balanced with the existing repairs form this summer.