|This spreadsheet approximates the one-time cost of expanding access to computer science to offer a basic K-12 pathway in every school in a state. This does not model teacher attrition or long-term costs. Once teachers are established, existing state/federal funding streams should address this issue.|
This is a rough, top-down approximation. The assumptions are informed by the work of Code.org and similar organizations.
-- The cost to establish a computer science program is based on preparing an in-service teacher, NOT hiring a new teacher.
-- The major grade bands where teachers will be established are K-6 (elementary), 7-8 (middle school), 9-12 (high school) and uses NCES data (school year '14/'15, which is the most recent year) to determine how many unique schools each state has in these grade bands
-- This model assumes establishing one teacher per grade major grade band at a school using NCES data for number of unique schools at each grade band. For example, if a school has both K-6 grades and middle school grades, then the model will assume establishing two teachers. It also assumes that one K-6 teacher (such as technology teacher that reaches all students or a librarian) will be established per school. This figure may need to be adjusted (which is supported below) if states/districts want to establish more than one elementary school teacher per school.
-- Only Public and Public Charter School Districts would be eligible for this funding.
-- The model assumes some cost overhead compared to the work of private organizations such as Code.org
|Choose Your State -->||New Jersey|
|Approximate number of public/charter elementary schools||1,694|
Source: NCES database, # of schools with any K-6 grades
|Approximate number of public/charter middle and high schools||1,365|
Source: NCES database, # of schools with 7-8 or 9-12 grades
|Approximate % of schools that don't teach CS||75%|
K-12 CS Access Report, 2018
|Assumption of number of teachers/elementary school||1|
|Assumption of number of teachers/middle/high school school||1|
|Number of new elementary school CS teachers needed||1,271|
|Number of new middle/high school CS teachers needed||1,024|
|Cost to an elementary school to establish a CS teacher||$500|
|Cost to establish a middle or high school CS teacher||$6,000|
|Total cost: elementary school||$635,250|
|Total cost: middle/high school||$6,142,500|
|Total new CS classrooms||2,294|
|Students per teacher in elementary school (assuming elementary school librarian or computer teacher)||150||55|
Based on Code.org's programs in tens of thousands of elementary schools
|Students per computer science teacher in middle and high school||150||40|
Based on Code.org's programs in thousands of high schools
|Number of elementary school students impacted per year when CS courses are fully deployed*||190,575||69,878|
|Number of middle and high school school students impacted per year when CS courses are fully deployed*||153,563||40,950|
|Number of elementary school students impacted over 5 years||952,875||349,388|
|Number of middle and high school students impacted over 5 years||767,813||204,750|
|* There's an implicit assumption that schools aren't teaching CS in every single year of the K-12 pathway. Therefore, the number of students reached per year doesn't need to be all students, because most students are in grades that aren't learning CS|