Professional Learning Scaling Cost Model for States
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
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.
3
This is a rough, top-down approximation. The assumptions are informed by the work of Code.org and similar organizations.
4
Assumptions/limitations:
-- 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
5
6
Choose Your State -->New Jersey
7
8
Approximate number of public/charter elementary schools1,694
Source: NCES database, # of schools with any K-6 grades
9
Approximate number of public/charter middle and high schools1,365
Source: NCES database, # of schools with 7-8 or 9-12 grades
221
10
11
Approximate % of schools that don't teach CS75%
K-12 CS Access Report, 2018
https://code.org/files/2018_state_of_cs.pdf
12
13
Assumption of number of teachers/elementary school1
14
Assumption of number of teachers/middle/high school school1
15
16
Number of new elementary school CS teachers needed1,271
17
Number of new middle/high school CS teachers needed1,024
18
19
Cost to an elementary school to establish a CS teacher$500
20
Cost to establish a middle or high school CS teacher$6,000
21
22
Total cost: elementary school$635,250
23
Total cost: middle/high school$6,142,500
24
TOTAL COST$6,777,750
25
Total new CS classrooms2,294
26
27
28
EnrollmentMax capacity
Conservative Estimate
29
Students per teacher in elementary school (assuming elementary school librarian or computer teacher)15055
Based on Code.org's programs in tens of thousands of elementary schools
30
Students per computer science teacher in middle and high school15040
Based on Code.org's programs in thousands of high schools
31
32
Number of elementary school students impacted per year when CS courses are fully deployed*190,57569,878
33
Number of middle and high school school students impacted per year when CS courses are fully deployed*153,56340,950
34
35
Number of elementary school students impacted over 5 years952,875349,388
36
Number of middle and high school students impacted over 5 years767,813204,750
37
38
* 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
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
Loading...
Main menu