Copy of OPSI exam admin data 8-28-24 DBK.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- RFR for Conference spaces
- Solicitation number
- BD-25-1087-REG01-REG01-105269
- Issued by
- Massachusetts
About this file
This file is a comprehensive Excel spreadsheet tracking exam administration data across multiple zones in Massachusetts from September 2023 through August 2024. The data shows exam sessions conducted in four zones, primarily in Taunton, Holyoke/Amherst, and Devens, with typically two sessions per day (8:00 AM and 10:00 AM) in each location. The data indicates that Zone 1, which previously operated in Charlestown, and Zone 2, both currently operating in Taunton, would benefit from separate venues, with Zone 1 needing a location closer to north of Boston.
The spreadsheet reveals consistent monthly exam administration patterns with attendance ranging from 600 to 1,353 total persons per month. March 2024 notably required three sessions per day at multiple locations to accommodate higher attendance volumes, which according to notes happens two to three times per year. Total monthly exam counts fluctuated between 824 and 1,951, with most months averaging around 1,100 to 1,300 exams administered. The data consistently shows higher attendance in morning sessions compared to later sessions across all zones and locations.
View the file
Other files
Show all 12
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| Zone | Location | Date | AM_PM | Person Totals | Exam Totals | |
| 1 | Taunton | 8/14/24 | 8:00 AM | 136 | 225 | Zones 1 and 2 are both being conducted |
| 1 | Taunton | 8/14/24 | 10:00 AM | 73 | 73 | in Taunton, but they are two different |
| 298 | geographic areas that would be better | |||||
| 2 | Taunton | 8/15/24 | 8:00 AM | 133 | 229 | served with two venues. |
| 2 | Taunton | 8/15/24 | 10:00 AM | 65 | 66 | Zone 1 used to be in Charlestown, and |
| 295 | would be better for constituents if we | |||||
| 3 | Holyoke | 8/13/24 | 8:00 AM | 120 | 199 | had a venue closer to just North of |
| 3 | Holyoke | 8/13/24 | 10:00 AM | 51 | 51 | Boston. |
| 250 | ||||||
| 4 | Devens | 8/12/24 | 8:00 AM | 123 | 206 | |
| 4 | Devens | 8/12/24 | 10:00 AM | 47 | 47 | |
| 253 | ||||||
| Totals | 748 | 1096 | ||||
| Zone | Location | Date | AM_PM | Person Totals | Exam Totals | |
| 1 | Taunton | 7/17/24 | 8:00 AM | 136 | 215 | |
| 1 | Taunton | 7/17/24 | 10:00 AM | 78 | 78 | |
| 293 | ||||||
| 2 | Taunton | 7/18/24 | 8:00 AM | 121 | 216 | |
| 2 | Taunton | 7/18/24 | 10:00 AM | 83 | 83 | |
| 299 | ||||||
| 3 | Holyoke | 7/16/24 | 8:00 AM | 121 | 173 | |
| 3 | Holyoke | 7/16/24 | 10:00 AM | 33 | 33 | |
| 206 | ||||||
| 4 | Devens | 7/15/24 | 8:00 AM | 120 | 196 | |
| 4 | Devens | 7/15/24 | 10:00 AM | 52 | 52 | |
| 248 | ||||||
| Totals | 744 | 1046 | ||||
| Zone | Location | Date | AM_PM | Person Totals | Exam Totals | |
| 1 | Taunton | 6/12/24 | 8:00 AM | 133 | 215 | |
| 1 | Taunton | 6/12/24 | 10:00 AM | 140 | 168 | |
| 383 | ||||||
| 2 | Taunton | 6/13/24 | 8:00 AM | 141 | 248 | |
| 2 | Taunton | 6/13/24 | 10:00 AM | 140 | 176 | |
| 424 | ||||||
| 3 | Amherst | 6/11/24 | 8:00 AM | 101 | 177 | |
| 3 | Amherst | 6/11/24 | 10:00 AM | 90 | 90 | |
| 267 | ||||||
| 4 | Devens | 6/10/24 | 8:00 AM | 147 | 254 | |
| 4 | Devens | 6/10/24 | 10:00 AM | 128 | 136 | |
| 390 | ||||||
| Totals | 1020 | 1464 | ||||
| Zone | Location | Date | AM_PM | Person Totals | Exam Totals | |
| 1 | Taunton | 5/15/24 | 8:00 AM | 143 | 244 | |
| 1 | Taunton | 5/15/24 | 10:00 AM | 117 | 117 | |
| 361 | ||||||
| 2 | Taunton | 5/16/24 | 8:00 AM | 133 | 241 | |
| 2 | Taunton | 5/16/24 | 10:00 AM | 136 | 137 | |
| 378 | ||||||
| 3 | Amherst | 5/14/24 | 8:00 AM | 100 | 160 | |
| 3 | Amherst | 5/14/24 | 10:00 AM | 63 | 63 | |
| 223 | ||||||
| 4 | Devens | 5/13/24 | 8:00 AM | 143 | 223 | |
| 4 | Devens | 5/13/24 | 10:00 AM | 97 | 97 | |
| 320 | ||||||
| Totals | 932 | 1282 | ||||
| Zone | Location | Date | AM_PM | Person Totals | Exam Totals | |
| 1 | Taunton | 4/10/24 | 8:00 AM | 131 | 177 | |
| 1 | Taunton | 4/10/24 | 10:00 AM | 129 | 165 | |
| 342 | ||||||
| 2 | Taunton | 4/11/24 | 8:00 AM | 136 | 207 | |
| 2 | Taunton | 4/11/24 | 10:00 AM | 137 | 187 | |
| 394 | ||||||
| 3 | Amherst | 4/8/24 | 8:00 AM | 100 | 175 | |
| 3 | Amherst | 4/8/24 | 10:00 AM | 93 | 94 | |
| 269 | ||||||
| 4 | Devens | 4/9/24 | 8:00 AM | 142 | 226 | |
| 4 | Devens | 4/9/24 | 10:00 AM | 142 | 167 | |
| 393 | ||||||
| Totals | 1010 | 1398 | ||||
| Zone | Location | Date | AM_PM | Person Totals | Exam Totals | |
| 1 | Taunton | 3/13/24 | 8:00 AM | 120 | 228 | Note: As happens from time to time, we |
| 1 | Taunton | 3/13/24 | 10:00 AM | 120 | 166 | had to schedule three sessions in each |
| 1 | Taunton | 3/13/24 | 1:00 PM | 109 | 109 | location to accommodate the number of |
| 503 | ||||||
| 2 | Taunton | 3/14/24 | 8:00 AM | 140 | 252 | applicants. This happens two or three |
| 2 | Taunton | 3/14/24 | 10:00 AM | 143 | 238 | times per year and one or more locations. |
| 2 | Taunton | 3/14/24 | 1:00 PM | 120 | 120 | |
| 610 | ||||||
| 3 | Amherst | 3/12/24 | 8:00 AM | 100 | 183 | |
| 3 | Amherst | 3/12/24 | 10:00 AM | 100 | 100 | |
| 3 | Amherst | 3/12/24 | 1:00 PM | 42 | 42 | |
| 325 | ||||||
| 4 | Devens | 3/13/24 | 8:00 AM | 145 | 259 | |
| 4 | Devens | 3/13/24 | 10:00 AM | 142 | 182 | |
| 4 | Devens | 3/13/24 | 1:00 PM | 72 | 72 | |
| 513 | ||||||
| 1353 | 1951 | |||||
| Zone | Location | Date | AM_PM | Person Totals | Exam Totals | |
| 1 | Taunton | 2/14/24 | 8:00 AM | 120 | 194 | |
| 1 | Taunton | 2/14/24 | 10:00 AM | 67 | 67 | |
| 261 | ||||||
| 2 | Taunton | 2/15/24 | 8:00 AM | 134 | 202 | |
| 2 | Taunton | 2/15/24 | 10:00 AM | 37 | 37 | |
| 239 | ||||||
| 3 | Amherst | 2/13/24 | 8:00 AM | 103 | 137 | |
| 3 | Amherst | 2/13/24 | 10:00 AM | |||
| 137 | ||||||
| 4 | Devens | 2/12/24 | 8:00 AM | 120 | 168 | |
| 4 | Devens | 2/12/24 | 10:00 AM | 19 | 19 | |
| 187 | ||||||
| Totals | 600 | 824 | ||||
| Zone | Location | Date | AM_PM | Person Totals | Exam Totals | |
| 1 | Taunton | 1/10/24 | 8:00 AM | 136 | 238 | |
| 1 | Taunton | 1/10/24 | 10:00 AM | 92 | 92 | |
| 330 | ||||||
| 2 | Taunton | 1/11/24 | 8:00 AM | 131 | 243 | |
| 2 | Taunton | 1/11/24 | 10:00 AM | 103 | 103 | |
| 346 | ||||||
| 3 | Amherst | 1/9/24 | 8:00 AM | 100 | 143 | |
| 3 | Amherst | 1/9/24 | 10:00 AM | 36 | 36 | |
| 179 | ||||||
| 4 | Devens | 1/8/24 | 8:00 AM | 121 | 208 | |
| 4 | Devens | 1/8/24 | 10:00 AM | 57 | 57 | |
| 265 | ||||||
| Totals | 776 | 1120 | ||||
| Zone | Location | Date | AM_PM | Person Totals | Exam Totals | |
| 1 | Taunton | 12/13/23 | 8:00 AM | 138 | 266 | |
| 1 | Taunton | 12/13/23 | 10:00 AM | 133 | 140 | |
| 406 | ||||||
| 2 | Taunton | 12/14/23 | 8:00 AM | 120 | 219 | |
| 2 | Taunton | 12/14/23 | 10:00 AM | 85 | 85 | |
| 304 | ||||||
| 3 | Amherst | 12/11/23 | 8:00 AM | 100 | 146 | |
| 3 | Amherst | 12/11/23 | 10:00 AM | 28 | 28 | |
| 174 | ||||||
| 4 | Devens | 12/12/23 | 8:00 AM | 120 | 194 | |
| 4 | Devens | 12/12/23 | 10:00 AM | 49 | 49 | |
| 243 | ||||||
| Totals | 773 | 1127 | ||||
| Zone | Location | Date | AM_PM | Person Totals | Exam Totals | |
| 1 | Taunton | 11/15/23 | 8:00 AM | 137 | 252 | |
| 1 | Taunton | 11/15/23 | 10:00 AM | 125 | 126 | |
| 378 | ||||||
| 2 | Taunton | 11/16/23 | 8:00 AM | 144 | 275 | |
| 2 | Taunton | 11/16/23 | 10:00 AM | 129 | 146 | |
| 421 | ||||||
| 3 | Amherst | 11/13/23 | 8:00 AM | 100 | 175 | |
| 3 | Amherst | 11/13/23 | 10:00 AM | 99 | 99 | |
| 274 | ||||||
| 4 | Devens | 11/14/23 | 8:00 AM | 120 | 203 | |
| 4 | Devens | 11/14/23 | 10:00 AM | 106 | 106 | |
| 309 | ||||||
| Totals | 960 | 1382 | ||||
| Zone | Location | Date | AM_PM | Person Totals | Exam Totals | |
| 1 | Taunton | 10/18/23 | 8:00 AM | 139 | 247 | |
| 1 | Taunton | 10/18/23 | 10:00 AM | 107 | 107 | |
| 354 | ||||||
| 2 | Taunton | 10/19/23 | 8:00 AM | 132 | 245 | |
| 2 | Taunton | 10/19/23 | 10:00 AM | 119 | 135 | |
| 380 | ||||||
| 3 | Amherst | 10/16/23 | 8:00 AM | 101 | 172 | |
| 3 | Amherst | 10/16/23 | 10:00 AM | 46 | 47 | |
| 219 | ||||||
| 4 | Devens | 10/17/23 | 8:00 AM | 120 | 205 | |
| 4 | Devens | 10/17/23 | 10:00 AM | 50 | 50 | |
| 255 | ||||||
| Totals | 814 | 1208 | ||||
| Zone | Location | Date | AM_PM | Person Totals | Exam Totals | |
| 1 | Taunton | 9/13/23 | 8:00 AM | 130 | 230 | |
| 1 | Taunton | 9/13/23 | 10:00 AM | 100 | 100 | |
| 330 | ||||||
| 2 | Taunton | 9/14/23 | 8:00 AM | 126 | 208 | |
| 2 | Taunton | 9/14/23 | 10:00 AM | 76 | 76 | |
| 284 | ||||||
| 3 | Amherst | 9/11/23 | 8:00 AM | 100 | 165 | |
| 3 | Amherst | 9/11/23 | 10:00 AM | 44 | 44 | |
| 209 | ||||||
| 4 | Devens | 9/12/23 | 8:00 AM | 120 | 194 | |
| 4 | Devens | 9/12/23 | 10:00 AM | 37 | 37 | |
| 231 | ||||||
| Totals | 733 | 1054 |
File details come from the government source that posted it. Updated .