Spreadsheet: 97656d1296767468-subtotal-and-countif-with-range-of-values-mattr_sample
Sheet: Template

Algebra I   2010 - 2011
 |  |  |  |  |  |  |  | How to use this template
 |  |  |  |  |  |  |  | Step 1: | Locate and select the Report titled "Algebra 1 Benchmark Analysis 2010 - 2011 V1"
Number of Students | Performance   Bands
 | 0-20% |  |  |  |  |  |  | Step 2: | Export the results by selecting the Excel icon, this should open a new excel file
 | 20.01-40%
 | 40.01-60% |  |  |  |  |  |  | Step 3: | Highlight and copy all of the report data STARTING in cell box A2.  DO NOT COPY THE FIRST ROW
 | 60.01-80%
 | 80.01-100% |  |  |  |  |  |  | Step 4: | Paste the data below in this template beginning in cell box A38
 |  |  |  |  |  |  |  | Step 5: | Use the filter tool (         ) to display various groups of data: 1st period only, all level 3 students, etc.
 |  |  |  |  |  |  |  |  | You can then print page 1 of this worksheet for future reference.
 |  |  |  |  |  |  |  | Please E-mail me with any suggestions!
Percent Correct By [NAME]
Benchmark | Base Line Average | Progress Monitoring 1 Average | Mid Year Average | % Increase Baseline to Mid-Year
MA.912.A.2.3 |  | N/A |  |  |  | Teacher:_____________
MA.912.A.3.1 |  |  |  |  |  | Period:______
MA.912.A.3.4
MA.912.A.3.5
MA.912.A.3.8 |  | N/A
MA.912.A.3.9 |  | N/A
MA.912.A.3.10 |  | N/A
MA.912.A.3.11 |  | N/A
 |  |  |  |  |  | As of 2/3/11
Lastname | Firstname | Period | 09-10 Scale Score | 09-10 Ach Level | BL - MA.912.A.2.3 | [NAME] | BL - MA.912.A.3.1 | PM 1 - MA.912.A.3.1 | [NAME] | BL - MA.912.A.3.4 | PM 1 - MA.912.A.3.4 | [NAME] | BL - MA.912.A.3.5 | PM 1 - MA.912.A.3.5 | [NAME] | BL - MA.912.A.3.8 | [NAME] | BL - MA.912.A.3.9 | [NAME] | BL - MA.912.A.3.10 | [NAME] | BL - MA.912.A.3.11 | [NAME] | Mid-Year Total Percent Score
 |  | 5 | 319 | 3 | 33.33 | 80 | 33.33 |  | 60 | 33.33 |  | 100 | 66.67 |  | 0 | 33.33 | 20 | 33.33 | 20 | 33.33 | 40 | 33.33 | 80 | 45
 |  | 5 | 356 | 4 | 100 | 80 | 66.67 | 66.67 | 100 | 100 | 66.67 | 66.67 | 66.67 | 60 | 80 | 0 | 100 | 0 | 80 | 66.67 | 60 | 66.67 | 100 | 82.5
 |  |  | 363 | 4 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0
 |  | 5 | 377 | 5 | 66.67 | 100 | 33.33 | 86.67 | 60 | 0 | 33.33 | 100 | 100 | 60 | 60 | 66.67 | 100 | 0 | 100 | 33.33 | 60 | 66.67 | 100 | 85
 |  |  | 350 | 3 | 100 |  | 66.67 | 60 |  | 0 | 0 |  | 66.67 | 60 |  | 66.67 |  | 0 |  | 66.67 |  | 66.67
 |  |  | 401 | 5 | 100 | 60 | 66.67 | 80 | 60 | 0 | 66.67 | 100 | 33.33 | 80 | 80 | 33.33 | 60 | 0 | 60 | 66.67 | 80 | 66.67 | 100 | 75
 |  | 4 |  |  | 0 |  | 100 | 53.33 |  | 0 | 66.67 |  | 0 | 60 |  | 0 |  | 0 |  | 66.67 |  | 0
 |  | 2 | 343 | 3 | 33.33 |  | 33.33 |  |  | 0 |  |  | 33.33 |  |  | 33.33 |  | 66.67 |  | 0 |  | 33.33
 |  | 2 | 342 | 3 | 33.33 | 40 | 33.33 | 60 | 60 | 33.33 | 100 | 66.67 | 33.33 | 40 | 40 | 33.33 | 80 | 33.33 | 40 | 0 | 40 | 33.33 | 40 | 50
 |  | 1 | 329 | 3 | 66.67 | 80 | 66.67 | 73.33 | 60 | 66.67 | 33.33 | 33.33 | 66.67 | 60 | 40 | 33.33 | 60 | 0 | 60 | 33.33 | 0 | 0 | 80 | 55
 |  | 5 | 286 | 2 | 0 | 40 | 33.33 | 33.33 | 80 | 0 | 0 | 33.33 | 33.33 | 0 | 40 | 33.33 | 40 | 66.67 | 40 | 33.33 | 20 | 33.33 | 80 | 45
 |  | 2 | 277 | 2 | 66.67 |  | 66.67 | 40 |  | 0 | 0 |  | 0 | 20 |  | 100 |  | 33.33 |  | 0 |  | 66.67
 |  | 5 | 312 | 3 | 66.67 | 40 | 66.67 | 46.67 | 80 | 33.33 | 33.33 | 66.67 | 33.33 | 40 | 40 | 33.33 | 40 | 0 | 60 | 0 | 40 | 66.67 | 60 | 55
 |  |  | 350 | 3 | 0 | 0 | 33.33 | 46.67 | 0 | 0 | 33.33 | 0 | 66.67 | 80 | 40 | 0 | 40 | 0 | 20 | 0 | 40 | 33.33 | 80 | 27.5
 |  | 2 | 270 | 2 | 66.67 | 40 | 66.67 | 86.67 | 40 | 0 | 33.33 | 0 | 33.33 | 40 | 40 | 33.33 | 20 | 66.67 | 20 | 33.33 | 60 | 33.33 | 60 | 40
 |  |  | 387 | 4 | 0 |  | 33.33 | 53.33 |  | 0 | 0 |  | 100 | 60 |  | 0 |  | 0 |  | 0 |  | 33.33
 |  | 1 | 330 | 3 | 33.33 | 80 | 66.67 | 80 | 60 | 33.33 | 0 | 0 | 33.33 | 80 | 80 | 0 | 80 | 33.33 | 60 | 33.33 | 20 | 100 | 40 | 55
 |  | 2 | 396 | 5 | 66.67 | 100 | 100 | 80 | 80 | 66.67 | 66.67 | 100 | 100 | 40 | 60 | 100 | 100 | 100 | 100 | 33.33 | 100 | 66.67 | 100 | 92.5
 |  |  | 388 | 5 | 66.67 | 80 | 66.67 | 73.33 | 80 | 33.33 | 33.33 | 66.67 | 33.33 | 80 | 80 | 66.67 | 80 | 33.33 | 80 | 66.67 | 40 | 100 | 100 | 75
 |  |  | 369 | 4 | 100 | 60 | 100 | 73.33 | 80 | 0 | 66.67 | 100 | 100 | 40 | 60 | 100 | 100 | 33.33 | 80 | 100 | 100 | 66.67 | 80 | 82.5
 |  | 3 | 353 | 4 | 100 | 60 | 33.33 | 73.33 | 0 | 33.33 | 33.33 | 66.67 | 33.33 | 60 | 80 | 33.33 | 60 | 0 | 60 | 0 | 40 | 0 | 100 | 55
 |  | 1 | 301 | 3 | 66.67 |  | 33.33 |  |  | 0 |  |  | 0 |  |  | 66.67 |  | 0 |  | 66.67 |  | 33.33
 |  | 3 | 287 | 2 | 0 | 40 | 33.33 | 53.33 | 40 | 0 | 0 | 33.33 | 0 | 60 | 40 | 33.33 | 60 | 0 | 60 | 33.33 | 20 | 66.67 | 80 | 45
 |  |  | 500 | 5 | 100 | 40 | 33.33 | 80 | 80 | 33.33 | 100 | 66.67 | 100 | 60 | 40 | 66.67 | 100 | 0 | 100 | 33.33 | 100 | 66.67 | 100 | 80
 |  | 4 | 302 | 2 | 66.67 | 40 | 33.33 | 66.67 | 40 | 33.33 | 33.33 | 33.33 | 0 | 20 | 40 | 66.67 | 60 | 33.33 | 40 | 33.33 | 20 | 0 | 40 | 42.5
 |  | 2 | 306 | 3 | 0 |  | 66.67 |  |  | 33.33 |  |  | 0 |  |  | 33.33 |  | 33.33 |  | 33.33 |  | 0
 |  | 2 | 335 | 3 | 0 | 60 | 66.67 | 86.67 | 80 | 0 | 33.33 | 33.33 | 66.67 | 40 | 60 | 0 | 80 | 33.33 | 80 | 33.33 | 40 | 66.67 | 60 | 62.5
 |  | 6 | 310 | 3 | 33.33 | 60 | 0 | 73.33 | 60 | 0 | 33.33 | 33.33 | 0 | 60 | 60 | 33.33 | 60 | 33.33 | 40 | 0 | 20 | 33.33 | 80 | 50
 |  | 2 | 302 | 3 | 66.67 | 60 | 0 | 73.33 | 100 | 33.33 | 0 | 100 | 0 | 20 | 60 | 66.67 | 60 | 0 | 100 | 0 | 60 | 0 | 80 | 77.5
 |  | 5 | 305 | 2 | 33.33 | 60 | 33.33 | 86.67 | 80 | 33.33 | 66.67 | 100 | 33.33 | 40 | 60 | 33.33 | 40 | 0 | 40 | 0 | 20 | 66.67 | 60 | 57.5
 |  | 5 | 277 | 2 | 0 |  | 0 |  |  | 33.33 |  |  | 66.67 |  |  | 0 |  | 0 |  | 0 |  | 100
 |  | 6 | 314 | 3 | 66.67 | 80 | 33.33 |  | 80 | 33.33 |  | 100 | 33.33 |  | 40 | 33.33 | 60 | 0 | 40 | 0 | 20 | 0 | 100 | 62.5
 |  | 3 | 263 | 2 | 66.67 |  | 100 | 33.33 |  | 33.33 | 33.33 |  | 33.33 | 60 |  | 66.67 |  | 66.67 |  | 0 |  | 0
 |  | 2 | 361 | 4 | 33.33 | 80 | 33.33 | 73.33 | 60 | 0 | 33.33 | 66.67 | 66.67 | 20 | 40 | 0 | 60 | 0 | 60 | 0 | 20 | 33.33 | 80 | 60
 |  | 4 | 285 | 2 | 0 | 40 | 0 | 40 | 40 | 0 | 33.33 | 0 | 33.33 | 40 | 60 | 33.33 | 20 | 0 | 20 | 0 | 20 | 66.67 | 40 | 32.5
 |  | 2 |  |  | 33.33 |  | 33.33 | 53.33 |  | 33.33 | 66.67 |  | 33.33 | 20 |  | 33.33 |  | 33.33 |  | 0 |  | 33.33
 |  | 2 | 264 | 2 | 33.33 | 40 | 33.33 | 33.33 | 40 | 0 | 0 | 0 | 33.33 | 40 | 0 | 66.67 | 60 | 66.67 | 0 | 33.33 | 20 | 0 | 0 | 20
 |  | 4 | 327 | 3 | 66.67 |  | 100 | 60 |  | 66.67 | 66.67 |  | 33.33 | 60 |  | 66.67 |  | 66.67 |  | 33.33 |  | 66.67
 |  | 3 | 309 | 2 | 0 | 20 | 33.33 |  | 80 | 33.33 |  | 66.67 | 0 |  | 40 | 33.33 | 60 | 33.33 | 60 | 0 | 40 | 33.33 | 40 | 47.5
 |  | 4 | 281 | 1 | 33.33 |  | 100 | 33.33 |  | 33.33 | 33.33 |  | 33.33 | 40 |  | 66.67 |  | 66.67 |  | 33.33 |  | 0
 |  | 6 | 342 | 3 | 66.67 | 60 | 66.67 | 66.67 | 60 | 66.67 | 66.67 | 100 | 0 | 60 | 60 | 0 | 60 | 33.33 | 100 | 100 | 100 | 66.67 | 100 | 77.5
 |  | 2 | 327 | 3 | 33.33 | 60 | 66.67 | 73.33 | 40 | 0 | 0 | 0 | 0 | 40 | 60 | 0 | 0 | 33.33 | 60 | 0 | 20 | 33.33 | 60 | 37.5
 |  | 7 | 333 | 3 | 0 | 60 | 0 | 60 | 20 | 0 | 0 | 33.33 | 33.33 | 40 | 60 | 33.33 | 60 | 0 | 60 | 33.33 | 20 | 0 | 80 | 50
 |  | 5 | 372 | 4 | 0 | 20 | 33.33 | 46.67 | 60 | 33.33 | 33.33 | 33.33 | 0 | 80 | 60 | 0 | 40 | 0 | 60 | 0 | 20 | 33.33 | 60 | 47.5
 |  | 6 | 269 | 2 | 33.33 | 60 | 66.67 | 13.33 | 40 | 0 | 0 | 33.33 | 33.33 | 0 | 40 | 33.33 | 60 | 33.33 | 40 | 33.33 | 0 | 33.33 | 60 | 42.5
 |  | 2 | 315 | 3 | 66.67 | 60 | 33.33 | 46.67 | 60 | 100 | 33.33 | 100 | 0 | 60 | 40 | 33.33 | 80 | 33.33 | 80 | 66.67 | 80 | 66.67 | 80 | 67.5
 |  | 3 | 374 | 4 | 33.33 |  | 33.33 | 26.67 |  | 33.33 | 33.33 |  | 33.33 | 0 |  | 0 |  | 66.67 |  | 0 |  | 33.33
 |  | 3 | 288 | 2 | 33.33 | 20 | 33.33 | 33.33 | 60 | 33.33 | 33.33 | 0 | 0 | 40 | 60 | 33.33 | 40 | 0 | 20 | 0 | 0 | 33.33 | 20 | 30
 |  | 1 | 263 | 1 | 66.67 |  | 66.67 |  |  | 0 |  |  | 0 |  |  | 33.33 |  | 0 |  | 0 |  | 0
 |  | 1 | 320 | 3 | 100 | 80 | 33.33 | 20 | 80 | 33.33 | 0 | 66.67 | 33.33 | 80 | 20 | 0 | 40 | 0 | 40 | 0 | 20 | 33.33 | 40 | 47.5
 |  | 2 | 320 | 3 | 66.67 | 20 | 66.67 | 60 | 80 | 33.33 | 0 | 66.67 | 33.33 | 60 | 60 | 0 | 20 | 0 | 80 | 66.67 | 20 | 33.33 | 80 | 52.5
 |  | 5 | 304 | 2 | 33.33 | 40 | 33.33 |  | 20 | 33.33 |  | 33.33 | 0 |  | 80 | 33.33 | 40 | 0 | 60 | 33.33 | 0 | 33.33 | 60 | 45
 |  | 5 | 310 | 3 | 0 | 40 | 66.67 | 53.33 | 80 | 33.33 | 0 | 66.67 | 0 | 80 | 60 | 66.67 | 20 | 33.33 | 40 | 33.33 | 20 | 33.33 | 20 | 42.5
 |  |  | 387 | 4 | 0 | 80 | 0 | 60 | 60 | 0 | 66.67 | 33.33 | 0 | 40 | 40 | 0 | 60 | 0 | 40 | 0 | 80 | 0 | 80 | 60
 |  | 1 | 336 | 3 | 0 | 80 | 33.33 | 60 | 60 | 33.33 | 66.67 | 33.33 | 0 | 40 | 80 | 33.33 | 60 | 0 | 60 | 0 | 40 | 33.33 | 60 | 60
 |  | 2 | 319 | 3 | 33.33 | 60 | 100 |  | 60 | 33.33 |  | 66.67 | 0 |  | 60 | 33.33 | 40 | 0 | 80 | 33.33 | 20 | 66.67 | 20 | 50
 |  | 5 | 325 | 3 | 66.67 | 80 | 66.67 | 33.33 | 100 | 33.33 | 33.33 | 0 | 33.33 | 40 | 40 | 0 | 100 | 0 | 20 | 66.67 | 20 | 100 | 80 | 60
 |  | 3 | 327 | 3 | 66.67 | 80 | 100 | 60 | 60 | 33.33 | 0 | 66.67 | 0 | 60 | 80 | 0 | 100 | 0 | 80 | 0 | 20 | 100 | 60 | 67.5
 |  | 5 |  |  | 100 |  | 66.67 | 53.33 |  | 0 | 0 |  | 0 | 80 |  | 33.33 |  | 33.33 |  | 33.33 |  | 33.33
 |  | 4 | 373 | 5 | 100 | 60 | 66.67 | 73.33 | 80 | 66.67 | 33.33 | 66.67 | 66.67 | 20 | 60 | 0 | 100 | 33.33 | 100 | 0 | 100 | 66.67 | 80 | 82.5
 |  | 5 | 349 | 4 | 33.33 | 40 | 33.33 | 33.33 | 40 | 0 | 0 | 33.33 | 0 | 40 | 20 | 0 | 20 | 33.33 | 40 | 0 | 20 | 66.67 | 20 | 27.5
 |  | 2 | 348 | 4 | 33.33 | 60 | 33.33 | 53.33 | 60 | 33.33 | 33.33 | 33.33 | 33.33 | 40 | 40 | 33.33 | 60 | 0 | 20 | 0 | 60 | 33.33 | 100 | 55
 |  | 7 | 310 | 3 | 33.33 | 40 | 66.67 | 33.33 | 40 | 33.33 | 0 | 0 | 33.33 | 40 | 40 | 33.33 | 20 | 33.33 | 60 | 0 | 0 | 66.67 | 80 | 37.5
 |  | 1 | 362 | 4 | 100 | 80 | 66.67 | 86.67 | 80 | 33.33 | 33.33 | 100 | 66.67 | 40 | 60 | 66.67 | 100 | 33.33 | 80 | 0 | 40 | 66.67 | 100 | 80
 |  |  | 357 | 4 | 66.67 | 60 | 66.67 | 73.33 | 40 | 66.67 | 33.33 | 33.33 | 66.67 | 40 | 60 | 33.33 | 60 | 33.33 | 80 | 33.33 | 80 | 0 | 80 | 62.5
 |  | 6 | 346 | 3 | 33.33 | 100 | 33.33 | 60 | 60 | 33.33 | 66.67 | 66.67 | 33.33 | 60 | 80 | 0 | 100 | 33.33 | 80 | 33.33 | 60 | 33.33 | 80 | 77.5