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-5 (elementary), 6-8 (middle school), 9-12 (high school) and uses NCES data (school year '22/'23, 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 is K-8 grades, then the model will assume establishing two teachers. You can adjust the model below if a state wants to factor in multiple teachers per school. You can also look at the cost to just establish teachers at certain grade levels.
-- 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 -->Connecticut
7
8
Approximate number of public/charter elementary schools745
Source: NCES database, # of schools with any K-6 grades
9
Approximate number of public/charter middle/high schools721
Source: NCES database, # of schools with 7-8 or 9-12 grades
10
11
Approximate % of schools that don't teach CS#REF!
K-12 CS Access Report, 2024
advocacy.code.org/stateofcs
12
13
Assumption of number of teachers/elementary school1
14
Assumption of number of teachers/middle/high school school
15
16
Number of new elementary school CS teachers needed#REF!
17
Number of new middle/high school CS teachers needed#REF!
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#REF!
23
Total cost: middle/high school#REF!
24
TOTAL COST#REF!
25
Total new CS classrooms#REF!
26
27
28
29
30
31
32
33
34
35
36
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