Modeling the cost of K-12 CS in U.S.
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Modeling the one-time cost of expanding access to K-12 computer science (CS)
2
This spreadsheet approximates the one-time cost of expanding access to computer science to offer a K-12 pathway in every U.S. school
3
This is a rough, top-down approximation. The assumptions are informed by the work of Code.org and similar organizations in tens of thousands of schools across the nation.
4
The model assumes a significant amount of scaling cost overhead compared to the work of private organizations such as Code.org
5
Additional assumptions:
The cost to establish a computer science program is based on preparing an in-service teacher + district support for that teacher, NOT hiring a new teacher.
Only Public and Public Charter School Districts would be eligible for this funding.
6
7
8
Approximate number of public/charter primary schools in US
73,000based on 2012 numbers
https://nces.ed.gov/fastfacts/display.asp?id=84
9
Approximate number of public/charter secondary schools in US
31,000based on 2012 numbers
https://nces.ed.gov/fastfacts/display.asp?id=84
10
11
Approximate % of primary schools that don't teach CS75%2015 Gallup survey
http://csedu.gallup.com/home.aspx
12
Approximate % of secondary schools that don't teach CS75%2015 Gallup survey
http://csedu.gallup.com/home.aspx
13
14
Number of new primary school CS teachers needed54,750
15
Number of new secondary school CS teachers needed23,250
16
17
Cost to an elementary school to establish a CS teacher$3,000
Note: Code.org's cost is $150 for a very basic offering in K-5. This model assumes a more complete offering for middle school.
18
Cost to a secondary school to establish a CS teacher$10,000
Note: Code.org's cost is $5,000. NSF-funded programs cost between $5,000 - $7,000
19
20
Total cost: primary school$164,250,000
21
Total cost: secondary school$232,500,000
22
TOTAL COST$396,750,000
23
Total new CS classrooms78,000
24
25
26
EnrollmentMax capacityDefault
27
Students per teacher in primary school (assuming elementary school librarian or computer teacher, and a middle school elective course)15055
Based on Code.org's programs in tens of thousands of elementary schools
28
Students per computer science teacher in secondary school
15040
Based on Code.org's programs in thousands of high schools
29
30
Number of primary school students impacted per year*8,212,5003,011,250
31
Number of secondary school students impacted per year*
3,487,500930,000
32
33
Number of primary school students impacted over 5 years
41,062,50015,056,250
34
Number of secondary school students impacted over 5 years
17,437,5004,650,000
35
36
* 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
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
Loading...
 
 
 
Sheet1