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

208 responses to “Formula To Calculate Moving To Hybrid

  1. DSW2Contributor

    Gov. Kemp and Dr. Toomey just did a Covid news conference. It had been 8 and half weeks since their last one.

  2. @ Staffing Question
    I also have a question.

    Enrollment is down. Will staff be moved to other schools? This usually happens every year. If people are going to be moved, they need to be informed.

    Enrollment Article
    https://www.ajc.com/news/atlanta-news/metro-atlanta-school-districts-report-drops-in-enrollment-fewer-kindergarten-students/IQ4SHPEIWRDE7CL5XRWUMI57UY/

  3. My cousin teaches in Cherokee. He caught it. He can’t even handle his dog right now so he had to have someone come take her. This isn’t a joke of a disease. 9 have another teacher friend in Gwinnett who was hospitalized because of COVID-19. How are her students getting what they need with her out for who knows how long. Frankly, the word I’m getting from Gwonnett is that teachers are sitting at their desks talking to webcams. Students who are in the buildings are on their devices watching the teacher teach via Zoom so the students at home get the same lesson.

    Why rush this? Why put people at risk? It is too soon to think about forcing educators back into buildings, much less students.

    12
  4. DSW2Contributor

    ^^ Joy, schools just had to submit their data to the palace, so the reassignments should be coming soon.

    I knew enrollment was down, but didn’t realize it was down 5% as the AJC reported — I hope layoffs can be avoided!

    1
  5. Thank you DWS2. I appreciate the information. Some educators drop off their children on their way to work. Some people car pool. If DeKalb is planning to reopen F2F, school based people need to know where they will be located. Some years schools have been able to keep extra staff. It doesn’t seem like that will be possible this year.

    1
  6. Dunwoody Dad

    @New Normal Won’t Be Normal at All

    Not getting “my way” at all. My way would have been back to in-person instruction 5 days a week back in August. But this is at least a long overdue step in the right direction. Hoping DeKalb stays strong and doesn’t give in to the cries of the vocal, fear-porn addicted minority on this one and gets things back to the “new normal” as soon as possible.

    1
  7. Stan, you along with the board members should know that the numbers of COVID-19 cases will increase with Thanksgiving & Christmas approaching. Most of the district employees won’t show up or going out on leave with no one to teach the kids. How can people lives be based on a graph chart. Every district that attempted to open or opened now has a COVID-19 case!!!!! So sad what you all are doing to the employees.

    6
  8. Dunwoody Dad

    @Renee

    Are you seriously worried about “a” Covid case? Like, one case? Talk about a low bar! What about “a” case of the seasonal flu in a school? A 31-year old Vanderlyn Elementary teacher actually DIED from the flu in February. Were you up in arms about the district putting “people lives” at risk by continuing to keep schools open during flu season? If not, why don’t you care enough about “people lives” to demand that schools keep teachers and students safe from the risk of the seasonal flu, or bus or car rides to school, etc.?

    Obviously, if schools open, there will be additional cases. Just like there are right now with schools NOT open! This is a virus, it’s going to be here, likely forever, just like every other virus. If you aren’t willing to accept that FACT, just stay holed up in your house for the rest of your life, away from ANYTHING else that might cause you harm moving forward. Doesn’t sound like much of a way to live to me, but hey, at least you won’t catch Covid!

    Also, show me the districts or private schools that have opened that have had these massive, devastating outbreaks of Covid, with the hospitalizations & deaths that we have all been assured will follow. Seriously, show me. I’m sure it won’t be easy because they don’t exist.

    1