Triangle Counting Master 50 25 10 08 09 Norms by P9DvF6

VIEWS: 8 PAGES: 123

									Creating Triangle Counting Master - Help / Examples
AIMSweb or IL Cut Scores (if three colors)
Red    31 =COUNTIF(C9:C2000,">=0")-COUNTIF(C9:C2000,">=31")
Yellow    =COUNTIF(C9:C2000,">=31")-COUNTIF(C9:C2000,">=51")
Green 51 =COUNTIF(C9:C2000,">=51")
Total    =COUNTIF(C9:C2000,">=0")

AIMSweb or IL Cut Scores (if three colors, and the lowest cut score = 0)
Red    0 n/a [there will be no red]
Yellow    =COUNTIF(N9:N2000,">=0")-COUNTIF(N9:N2000,">=5")
Green 5 =COUNTIF(N9:N2000,">=5")
Total    =COUNTIF(C9:C2000,">=0")

AIMSweb or IL Cut Scores (if three colors, and both cut scores = 0)
Red    0 n/a [there will be no red]
Yellow   n/a [there will be no yellow]
Green 0 =COUNTIF(C9:C2000,"=0")
Total   =COUNTIF(C9:C2000,"=0")

AIMSweb Cut Scores (if four colors)
Red     31 =COUNTIF(N10:N2001,">=0")-COUNTIF(N10:N2001,">=31")
Yellow 51 =COUNTIF(N10:N2001,">=31")-COUNTIF(N10:N2001,">=51")
Yellow/Green =COUNTIF(N10:N2000,">=51")-COUNTIF(N10:N2000,">=80")
Green 80 =COUNTIF(N10:N2001,">=80")
Total       =COUNTIF(N10:N2001,">=0")

AIMSweb Cut Scores (if four colors, and the lowest cut score = 0)
Red     0   n/a [there will be no red]
Yellow 2    =COUNTIF(N10:N2001,">=0")-COUNTIF(N10:N2001,">=2")
Yellow/Green =COUNTIF(N10:N2000,">=2")-COUNTIF(N10:N2000,">=4")
Green 4 =COUNTIF(N10:N2001,">=4")
Total      =COUNTIF(N10:N2001,">=0")

AIMSweb Cut Scores (if four colors, and there are two cut scores = 0)
Red     0 n/a [there will be no red]
Yellow 0 n/a [there will be no yellow]
Yellow/Green =COUNTIF(N10:N2000,">=0")-COUNTIF(N10:N2000,">=3")
Green 3      =COUNTIF(N10:N2001,">=3")
Total       =COUNTIF(N10:N2001,">=0")


Note: adjust for correct cell names
Note: with AIMSweb or IL cut scores, blank cells will not be counted
because the cells have been formatted as “Numbers”

CONDITIONAL FORMATTING (fill color), NO BLANKS:
(use these formulas for the lowest range if this range includes a possible score of zero so that blank cells won’t be
Use “Formula Is”:
=IF(ISBLANK(C8),FALSE,(C8)=0)
*** adjust for correct cell name
=IF(ISBLANK(C8),FALSE,(C8)<4)
=IF(ISBLANK(F8),FALSE,(F8)<4)
=IF(ISBLANK(I8),FALSE,(I8)<4)
*** adjust for correct cell name

AIMSweb or IL CONDITIONAL FORMATTING (fill color), three colors:
Red    Formula is    =IF(ISBLANK(C7),FALSE,(C7)<61) [when 61 = the lower score]
Yellow Cell Value is between (lower score) and (one less than higher score)
Green Cell Value is >= (higher cut score)

AIMSweb CONDITIONAL FORMATTING (fill color), four colors:
Red [color must be added manually]
Yellow      Cell Value is between (10th %ile score) and (one less than 25th %ile score)
Yellow/Green Cell Value is between (25th %ile score) and (one less than 50th %ile score)
Green        Cell Value is >= (50th %ile score)

ISAT Correlates CONDITIONAL FORMATTING (fill color), three colors:
Red    Formula is    =IF(ISBLANK(C7),FALSE,(C7)<61) [when 61 is one more than Below Basic]
Yellow Cell Value is between (one more than Below Basic) and (one less than Proficient)
Green Cell Value is >= (Proficient score)

ROI Formulas:
(use these formulas so that Excel won’t calculate an ROI if at least one cell is blank)
FALL TO WINTER: =IF(ISNUMBER(Q10),+IF(ISNUMBER(N10),(Q10-N10)/15))
WINTER TO SPRING: =IF(ISNUMBER(T10),+IF(ISNUMBER(Q10),(T10-Q10)/15))
FALL TO SPRING: =IF(ISNUMBER(T10),+IF(ISNUMBER(N10),(T10-N10)/30))

ISAT Cut Scores – Background Information from Ben Ditkowski (2/7/08 email)
regarding whether or not ISAT cut scores are considered to be with the higher or lower range:
“The good news is, that in truth the difference is not that important (I believe the reported standard error of measur
are not so precise that we are as concerned about a 5th grade student scoring 94 in Fall as we are a student scori
of just under .5 of meeting standards and 95 is just above .5.
Statistically, there is no difference between a 94 and a 95, or even 94 and 96. We have to draw a line in the sand s
are. So for Fall of Grade 5, I interpret the cut scores to mean:
BELOW BASIC {red = 0-95 [95 is the top score still considered red]}
QUESTIONABLE {yellow = 96-129 [these scores represent some level of insecurity regarding whether or not stude
PROFICIENT {green = 130+ [130 is the bottom score considered green]}”

Formatting cells for four conditions:
[From Excel Help online: When the default formatting of the cells is considered, you can really allow for four conditi
the fourth color as “fill” from the color palette. The range is now pseudo-conditionally formatted to cover all four cas
however. I have suggested an alternative on the information page.

[end - current 08/14/08]
p / Examples




e of zero so that blank cells won’t be filled with that color)
than 25th %ile score)
 than 50th %ile score)



 more than Below Basic]
ne less than Proficient)




 or lower range:
 e reported standard error of measurement for RCBM is 4 points). The cut scores
g 94 in Fall as we are a student scoring 60. In fact, a score of 94 has a probability

 We have to draw a line in the sand somewhere, and that is what the cut scores


curity regarding whether or not students have mastered basic skills]}



d, you can really allow for four conditions. Highlight the range of cells and select
 onally formatted to cover all four cases.] This procedure will also fill in blank cells,
Analyzing Benchmark Data (Excel Spreadsheet)
Save the Triangle Counting spreadsheet as a new file, identifying the current benchmark, before beginning!
Do not make any changes/additions to the master file.


AIMS Benchmark Scores
Open "Student Score Distribution by Service Classification" (the second AIMSweb Scores and Percentiles Report).

Open the Excel spreadsheet for the corresponding classroom/grade level and test.

In AIMSweb, beginning in the upper left corner, drag and copy all names and test scores (top row will include the Tar
far left column will include the teacher names. Select through the last row of scores only (do not include Mean, Media
of Students Assessed). Copy (Ctrl-C).

On the Excel spreadsheet, click in the dark blue “Click here to Paste”cell in Row 9. Paste (Ctrl-
that the Target Scores will be above the first counted cell (and therefore, will not be counted with classroom or grade
NOTE: If administering a test for the first time in Winter or Spring, delete the unneeded benchmark columns BEFORE
(click on the gray number at the top of the column to select the entire column). If, after pasting, the columns still do n
the “Undo Typing” arrow on the toolbar to remove the report, insert/delete column(s) as needed, and then re
long as you insert/delete entire columns, Excel will maintain the integrity of the ROI calculations. [Test scores should
same column as the benchmark name.]

The total number of students tested and the number of students within each cut-score range (and the corresponding
will be automatically calculated.

Before continuing to work, be sure to remove any duplicate names (students might be listed with both their homeroom
as a part of an LDR, TPI or Literacy caseload). To select an entire row, click on the gray row number (far left column
click and select “delete.”

Drag and select the Target scores (cells filled yellow from AIMSweb). Using the paint bucket icon on the toolbar, cho
fill” or select a fill color other than any used for selected ranges of scores. Selecting another fill color will make it les
inadvertently include the target score when formatting for triangle colors, or when copying the column of scores for IS
correlates.

To automatically shade Individual cells to reflect the cut-score range: click the green “Color Format” cell in the approp
click Format Painter on the toolbar (a paintbrush is displayed with the cursor); click/drag to select all cells in the colum
want formatted. For Winter or Spring Benchmark, all three columns can be formatted at the same time: drag to selec
three “Color Format” cells and the blank cells in between; click Format Painter on the toolbar (again, a paintbrush is d
the cursor); click/drag to select all cells in the columns that you want formatted.
Red (below 10th percentile)
Yellow (10th – 24th percentile)
Green/Yellow (25th – 49th percentile)
Green (50th percentile and above)
District 300 has chosen to identify four tiers of student scores for 2008/2009. Excel 2003 allows for conditional forma
color) for only three conditions. So, select only the cells you want to fill with the fourth color [RED]: click the first ce
to be red, then hold down the Ctrl key while clicking any others, then choose the fill color desired [RED] using the pa
on the toolbar. All selected cells will fill with red (refer to the total number of cells that should be red at the top of th

Note regarding Early Literacy probes (Letter Names, Letter Sounds): Early Literacy is not a General Outcome Measu
distribute over 80/15/5). ALL students need to master Early Literacy skills. The goal is the 50th percentile, which is p
success, so only scores in the green are acceptable.
success, so only scores in the green are acceptable.

If you no longer want the “Color Format” cells to appear on the worksheet, drag to select them now, and “delete.”

Note: Percentages represent the number of students whose scores fall within a percentile range, based on national n
determined by AIMSweb. District 300 is interpreting all AIMSweb cut scores to be included in the higher range of sco
10th percentile cut score is “yellow”; “red” scores are those below the 10th percentile).


To Create Triangles
Percentages are included in the Excel spreadsheet calculations (see above). If a visual of the triangles is desired, ho
transfer student numbers from the spreadsheet to the data sheets for Triangles.


ISAT Correlation (use for program evaluation and resource allocation,
not for determining individual student intervention)
Note: Percentages represent the PROBABILITY of students meeting or exceeding standards.

Using ISAT cut scores with the three-tier model:
   Approximately 90% of students in the green will meet ISAT standards
   Approximately 60% of students in the yellow will meet ISAT standards
   Approximately 30% of students in the red will meet ISAT standards

AIMSweb test scores will need to be copied to the ISAT section of the spreadsheet. For example: drag to select all s
from the Fall RCBM column (beginning with row 10). Do not include the AIMSweb Target Score. Copy (Ctrl
(light blue “Paste” cell) in the Fall ISAT column. Paste (Ctrl-P). All scores will be pasted into column C. The total num
students tested and the number of students within each cut-score range (and the corresponding percentages) will be
calculated.

Cells will have maintained the colors assigned to them above based on AIMSweb cut scores. To automatically shade
cells to reflect the ISAT correlates: click the green “color” cell in the appropriate column; click Format Painter on the t
paintbrush is displayed with the cursor); click/drag to select all cells in the column that you want formatted: Green (pr
Yellow (between proficient and below basic); Red (below basic). Follow the procedure mentioned above to format mo
column at a time. These columns can be used to track Summary of Adequate Progress (also referred to as Migration
Chutes and Ladders).

If you no longer want the “Color Format” cells to appear on the worksheet, drag to select them now, and “delete.”

ISAT Correlate Cut Scores =
Red (Below Basic Score and below)
Yellow (“Below Basic Score + 1” to “Proficient Score – 1”)
Green (Proficient Score and above)


ROI (Rate of Improvement)
Expected ROI represents the ROI for the 50th Percentile, AIMSweb Aggregate.

Calculate after Winter and Spring Benchmarks.

The Rate of Improvement for the first student in the list will be automatically calculated. To copy/paste the formula(s)
students: Drag and select the calculated cell(s) for the first student; copy (Ctrl-C); drag/select all destination cells in t
column(s); paste (Ctrl-V). The worksheet is also set up to calculate the ROI between AIMSweb Target Scores (for co

If no score exists for one of the benchmarks, the result of the calculation will be “FALSE.” For these students, you ma
delete this result and enter any information, if desired (e.g. “dropped” or “new 10/9”). For students new to the school,
any initial testing data to calculate an ROI based on the number of weeks the student has been enrolled, and enter th
any initial testing data to calculate an ROI based on the number of weeks the student has been enrolled, and enter th
desired.

The formula is set to 15 weeks between benchmarks, and a total of 30 weeks between Fall and Spring benchmarks
– Fall Score = #WRC / #weeks = ROI).

Cells will be automatically shaded red if the calculated ROI is below the expected ROI for that period. Note: if you ch
remove the “False” result, the cell will adopt the red fill. If you want to remove the fill color, you must delete the condi
formatting for those particular cells: select all blank (red) cells – go to “Format” – select “Conditional Formatting”


Sorting Information
You may do an alphabetical or numerical sort using the information in any single column.

The "Student Score Distribution by Service Classification" report sorts student scores from high to low (or low to high
homeroom groupings. Using the “Sort” command from the “Data” menu on the Excel toolbar, you can re
entire grade level.
    Example #1: Sort by the most recent benchmark scores for ease of identifying grade-level intervention groups.
    Example #2: In the spring, sort by fall benchmark scores (creates a student-by-student migration chart).

It is important to select ALL data before doing the sort. If only a single column is selected, only that column will be re
in the row for one student will be mixed with data in another row with another student). To select all data, begin with
diagonally down and to the right until you reach the last cell containing data. Choose “sort” from the “Data” pulldown
the column on which to base the sort; click “ascending” or “descending” and click “OK.”


Sharing or Printing Reports
Blank columns can be deleted to reduce the size of the report. After you are completely done formatting, you could d
used to format the fill colors.

To print the entire report on one or two pages: Drag to select ALL cells. Select “Print” from the File menu (don’t use t
toolbar). In the “Print What” box, click the circle in front of “Selection.” Click “Preview” (bottom left corner of the dialo
Click the “Set Up” button on the toolbar. Select “Landscape” (orientation) and “Fit to 1 page wide by 1 tall” (scaling). C
Note: you can print approximately 50 students on the one page. For more students, choose additional pages “tall.” A
margins a little will accommodate another student or two.

If you want to copy parts of the spreadsheet to another file and will be including cells that contain formulas based on
you won’t be copying, you will need to lock in the computed values before copying and pasting. From Excel help onl
“freeze” the formula so that it no longer recalculates by replacing the formula with its calculated value. Select the cell
the formula (or group of cells); click the “Copy” icon; click the “Paste” icon of the Standard toolbar; click the arrow nex
Options (in a box with a clipboard), and then click “Values Only.” Caution: When you replace a formula with its value,
Excel permanently removes the formula. If you accidentally replace a formula with a value and want to restore the fo
Undo immediately after you enter or paste the value.


Note: All formulas assume no more than 2000 students per grade level.
[* idea for additional template: copy color formatting to another Excel template that would work with AllGOM
report doesn’t show accuracy for RCBM or Maze, but it does include all tests for each student on a single re


[current as of 8/14/08]
nchmark, before beginning!




eb Scores and Percentiles Report).



st scores (top row will include the Target Scores;
res only (do not include Mean, Median, or Number


  9. Paste (Ctrl-V). Pasting from this row will ensure
  be counted with classroom or grade level scores).
 eeded benchmark columns BEFORE pasting
 , after pasting, the columns still do not line up, click
 n(s) as needed, and then re-paste the report. As
ROI calculations. [Test scores should be in the


 score range (and the corresponding percentages)


ght be listed with both their homeroom teacher and
 he gray row number (far left column); then right


paint bucket icon on the toolbar, choose either “no
ing another fill color will make it less likely you will
n copying the column of scores for ISAT


een “Color Format” cell in the appropriate column;
ck/drag to select all cells in the column that you
atted at the same time: drag to select the two or
n the toolbar (again, a paintbrush is displayed with




cel 2003 allows for conditional formatting (i.e. fill
fourth color [RED]: click the first cell that will need
 fill color desired [RED] using the paint bucket icon
 that should be red at the top of the column).

acy is not a General Outcome Measure (it doesn’t
 oal is the 50th percentile, which is predictive of
to select them now, and “delete.”

percentile range, based on national norms as
e included in the higher range of scores (i.e. the




a visual of the triangles is desired, however,




ng standards.




eet. For example: drag to select all student scores
 b Target Score. Copy (Ctrl-C). Click in cell C10
pasted into column C. The total number of
e corresponding percentages) will be automatically


b cut scores. To automatically shade Individual
column; click Format Painter on the toolbar (a
n that you want formatted: Green (proficient);
edure mentioned above to format more than one
rogress (also referred to as Migration Charts or


to select them now, and “delete.”




 ulated. To copy/paste the formula(s) for all other
 ); drag/select all destination cells in the same
ween AIMSweb Target Scores (for comparison).

“FALSE.” For these students, you may choose to
 /9”). For students new to the school, you can use
udent has been enrolled, and enter that data if
udent has been enrolled, and enter that data if


etween Fall and Spring benchmarks (Winter Score


d ROI for that period. Note: if you choose to
e fill color, you must delete the conditional
  select “Conditional Formatting” – then delete.




cores from high to low (or low to high) within
 xcel toolbar, you can re-sort scores based on the

         level intervention groups.
    student migration chart).

 selected, only that column will be re-sorted (data
udent). To select all data, begin with cell A-10. Drag
oose “sort” from the “Data” pulldown menu; select




mpletely done formatting, you could delete the cells


Print” from the File menu (don’t use the icon on the
view” (bottom left corner of the dialog window).
 t to 1 page wide by 1 tall” (scaling). Click “OK.”
nts, choose additional pages “tall.” Adjusting the


cells that contain formulas based on other cells
ng and pasting. From Excel help online: You can
h its calculated value. Select the cell that contains
 Standard toolbar; click the arrow next to Paste
 you replace a formula with its value, Microsoft
th a value and want to restore the formula, click



ade level.
plate that would work with AllGOMS – this
sts for each student on a single report*]
Use for Practice
3rd Grade Maze
                                Targets   11                     14
Teacher Name A     Student Name A         14    93.30%   G       26
Teacher Name A     Student Name B         19    86.40%   G       26
Teacher Name A     Student Name C         16    94.10%   G       25
Teacher Name A     Student Name D         16   100.00%   G       26
Teacher Name A     Student Name E         15    88.20%   G       29
Teacher Name A     Student Name F         13    81.30%   G       17
Teacher Name A     Student Name G          9    81.80% G     *   17
Teacher Name A     Student Name H         12    75.00% G         16
Teacher Name A     Student Name I         13    86.70% G         13
Teacher Name A     Student Name J          9    81.80% G     *   18
Teacher Name A     Student Name K          7    70.00% G     *   15
Teacher Name A     Student Name L          4   100.00% G     *    8
Teacher Name A     Student Name M                                17
Teacher Name A     Student Name N                                12
Teacher Name A     Student Name O         10    55.60% S     *   13
Teacher Name A     Student Name P                                13
Teacher Name A     Student Name Q
Teacher Name A     Student Name R         19    86.40% G
Teacher Name A     Student Name S          6   100.00% G     *
Teacher Name B     Student Name T          6    75.00% G     *
Teacher Name B     Student Name U          0     0.00% S     *    0
Teacher Name B     Student Name V         22   100.00% G         27
Teacher Name B     Student Name W                                27
Teacher Name B     Student Name X         12    85.70%   G       20
Teacher Name B     Student Name Y         21    95.50%   G       21
Teacher Name B     Student Name Z         15    93.80%   G       22
Teacher Name B     Student Name AA        12    80.00%   S       14
Teacher Name B     Student Name BB        17    94.40%   G       20
Teacher Name B     Student Name CC        12    70.60%   S       15
Teacher Name B     Student Name DD         9    90.00% G     *   13
Teacher Name B     Student Name EE        14    82.40% G         15
Teacher Name B     Student Name FF         5    71.40% G     *    8
Teacher Name B     Student Name GG        11    84.60% G         18
Teacher Name B     Student Name HH        11    84.60% S         17
Teacher Name B     Student Name II                               16
Teacher Name B     Student Name JJ        10   100.00% S     *   10
Teacher Name B     Student Name KK         5    38.50% G     *    9
Teacher Name B     Student Name LL         9    75.00% G     *    6
Teacher Name B     Student Name MM         8    80.00% G     *    7
Teacher Name B     Student Name NN         6    85.70% G     *   12
Teacher Name B     Student Name OO
Teacher Name B     Student Name PP         9    42.90% S     *   10
              15
 96.30%   G   31   100.00%   G
 92.90%   G   29    90.60%   G
 96.20%   G   29    93.50%   G
100.00%   G   29    93.50%   G
 96.70%   G   27    96.40%   G
100.00%   G   24   100.00%   G
94.40% G      23   100.00% G
 88.90% G     21    91.30% G
100.00% G     21    95.50% G
94.70% G      20    95.20% G
78.90% G      20    90.90% G
72.70% G      19    90.50% G
89.50% G      19    90.50% G
85.70% G      18   100.00% G
86.70% S      17   100.00% S
92.90% G      15    78.90% G
              10   100.00% G




               0             S
100.00%   G   33    97.10%   G
 96.40%   G   30   100.00%   G
 90.90%   G   28   100.00%   G
 95.50%   G   25    96.20%   G
100.00%   G   23   100.00%   G
 93.30%   S   22    91.70%   S
 95.20%   G   22   100.00%   G
 88.20%   S   21    91.30%   S
81.30% G      20    87.00% G
83.30% G      19    95.00% G
88.90% G      18    94.70% G
 75.00% G     17    89.50% G
100.00% S     17    85.00% S
 94.10% G     17    94.40% G
83.30% S      16   100.00% S
75.00% G      15    78.90% G
54.50% G      13    92.90% G
70.00% G      13    76.50% G
75.00% G      12    85.70% G
              10    76.90% G
62.50% S       8    53.30% S
ISAT Correlates
             ISAT Cut Scores   Fall                 Winter                 Spring
Below Basic n/a                       0   #DIV/0!            0   #DIV/0!            0   #DIV/0!
Questionable                          0   #DIV/0!            0   #DIV/0!            0   #DIV/0!
Proficient   Dibels based             0   #DIV/0!            0   #DIV/0!            0   #DIV/0!
# Assessed                            0   #DIV/0!            0   #DIV/0!            0   #DIV/0!

                               n/a                  n/a                    n/a

                               n/a                  n/a                    n/a

     No AIMSweb/ISAT correlates are available at this time for Kdg Letter Naming.
Kindergarten LN
                        Cut Scores for F -- W -- Sp   Fall LN                  Winter LN
(<10th %ile)            0 -- 11 -- 23                 n/a                      n/a
(10-24th %ile)          3 -- 24 -- 35                 n/a                      n/a
Red (<50th %ile)                                                 0   #DIV/0!              0   #DIV/0!
Green (>=50th %ile)     14 -- 38 -- 47                           0   #DIV/0!              0   #DIV/0!
Total Assessed                                                   0   #DIV/0!              0   #DIV/0!
(Teacher Name)          (Student Name)                color format             color format
(Click here to paste)
Spring LN
n/a
n/a
           0   #DIV/0!
           0   #DIV/0!            Student's Student's Student's
           0   #DIV/0!   Expected Fall-Winter Winter-Sp Fall-Sprng
color format             ROI      ROI         ROI       ROI
                               0.9 FALSE       FALSE     FALSE
                                    FALSE      FALSE     FALSE
ISAT Correlates
                 ISAT Cut Scores      Fall                    Winter                 Spring
Below Basic 0 -- 7 -- 16*                      0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Questionable                                   0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Proficient   7 -- 16 -- 36                     0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
# Assessed                                     0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
  (*BBasic cut scores per Ben Ditkowski, 1/30/08 training)
                                        * color *              * color *              * color *

                                      (Paste)                 (Paste)                (Paste)
Kindergarten LS
                        Cut Scores for F -- W -- Sp   Fall LS                  Winter LS
(<10th %ile)            0 -- 3 -- 14                  n/a                      n/a
(10-24th %ile)          0 -- 10 -- 23                 n/a                      n/a
Red (<50th %ile)                                                 0   #DIV/0!              0   #DIV/0!
Green (>=50th %ile)     3 -- 22 -- 35                            0   #DIV/0!              0   #DIV/0!
Total Assessed                                                   0   #DIV/0!              0   #DIV/0!
(Teacher Name)          (Student Name)                color format             color format
(Click here to paste)
Spring LS
n/a
n/a
           0   #DIV/0!
           0   #DIV/0!            Student's Student's Student's
           0   #DIV/0!   Expected Fall-Winter Winter-Sp Fall-Sprng
color format             ROI      ROI         ROI       ROI
                               0.9 FALSE       FALSE     FALSE
                                    FALSE      FALSE     FALSE
ISAT Correlates
             ISAT Cut Scores   Fall                 Winter                 Spring
Below Basic n/a                       0   #DIV/0!            0   #DIV/0!            0   #DIV/0!
Questionable                          0   #DIV/0!            0   #DIV/0!            0   #DIV/0!
Proficient   n/a                      0   #DIV/0!            0   #DIV/0!            0   #DIV/0!
# Assessed                            0   #DIV/0!            0   #DIV/0!            0   #DIV/0!

                               n/a                  n/a                    n/a

                               n/a                  n/a                    n/a

  No AIMSweb/ISAT correlates are available at this time for 1st Grade Letter Naming.
1st Grade LN
                        Cut Scores for F -- W -- Sp   Fall LN                  Winter LN
(<10th %ile)            20 -- 25 -- 31                n/a                      n/a
(10-24th %ile)          31 -- 40 -- 46                n/a                      n/a
Red (<10th %ile)                                                 0   #DIV/0!              0   #DIV/0!
Green (>=50th %ile)     42 -- 53 -- 59                           0   #DIV/0!              0   #DIV/0!
Total Assessed                                                   0   #DIV/0!              0   #DIV/0!
(Teacher Name)          (Student Name)                color format             color format
(Click here to paste)
Spring LN
n/a
n/a
           0   #DIV/0!
           0   #DIV/0!            Student's Student's Student's
           0   #DIV/0!   Expected Fall-Winter Winter-Sp Fall-Sprng
color format             ROI      ROI         ROI       ROI
                               0.5 FALSE       FALSE     FALSE
                                    FALSE      FALSE     FALSE
ISAT Correlates
                 ISAT Cut Scores       Fall                   Winter                 Spring
Below Basic 28 -- ?? -- ??                      0   #DIV/0!            0   #DIV/0!            0   #DIV/0!
Questionable                                    0   #DIV/0!            0   #DIV/0!            0   #DIV/0!
Proficient   48 -- ?? -- ??                     0   #DIV/0!            0   #DIV/0!            0   #DIV/0!
# Assessed                                      0   #DIV/0!            0   #DIV/0!            0   #DIV/0!
   (*Fall cut scores per Ben Ditkowski, 1/30/08 training)
                                        * color *             n/a                    n/a

                                       (Paste)                n/a                    n/a

                                                                    No W/Sp correlates at this time.
1st Grade LS
                        Cut Scores for F -- W -- Sp   Fall LS                  Winter LS
(<10th %ile)            9 -- 18 -- 23                 n/a                      n/a
(10-24th %ile)          18 -- 29 -- 33                n/a                      n/a
Red (<50th %ile)                                                 0   #DIV/0!              0   #DIV/0!
Green (>=50th %ile)     28 -- 40 -- 44                           0   #DIV/0!              0   #DIV/0!
Total Assessed                                                   0   #DIV/0!              0   #DIV/0!
(Teacher Name)          (Student Name)                color format             color format
(Click here to paste)
Spring LS
n/a
n/a
           0   #DIV/0!
           0   #DIV/0!            Student's Student's Student's
           0   #DIV/0!   Expected Fall-Winter Winter-Sp Fall-Sprng
color format             ROI      ROI         ROI       ROI
                               0.4 FALSE       FALSE     FALSE
                                    FALSE      FALSE     FALSE
ISAT Correlates
              ISAT Cut Scores   Fall                   Winter                 Spring
Below Basic 0 -- 20 -- 40               0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Questionable                            0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Proficient   20 -- 40 -- 60             0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
# Assessed                              0    #DIV/0!            0   #DIV/0!            0   #DIV/0!

                                 * color *              * color *              * color *

                                (Paste)                (Paste)                (Paste)
1st Grade RCBM
                        Cut Scores for F -- W -- Sp   Fall RCBM                          Winter RCBM
Red (<10th %ile)        0 -- 8 -- 18                  n/a                                             0
Yellow (10-24th %ile)   4 -- 15 -- 34                            0   #DIV/0!                          0
Green/Yellow (25-49)                                             0   #DIV/0!                          0
Green (>=50th %ile)     11 -- 28 -- 59                           0   #DIV/0!   #DIV/0!                0
Total Assessed                                                   0   #DIV/0!                          0
(Teacher Name)          (Student Name)                color format                       color format
(Click here to paste)
                    Spring RCBM
#DIV/0!                          0   #DIV/0!
#DIV/0!                          0   #DIV/0!
#DIV/0!                          0   #DIV/0!
#DIV/0!   #DIV/0!                0   #DIV/0!   #DIV/0!            Student's Student's Student's
#DIV/0!                          0   #DIV/0!             Expected Fall-Winter Winter-Sp Fall-Sprng
                    color format                         ROI      ROI         ROI       ROI
                                                               1.3 FALSE       FALSE     FALSE
                                                                    FALSE      FALSE     FALSE
ISAT Correlates
              ISAT Cut Scores   Fall                   Winter                 Spring
Below Basic xx -- 2 -- 5                0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Questionable                            0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Proficient   xx -- 6 -- 10              0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
# Assessed                              0    #DIV/0!            0   #DIV/0!            0   #DIV/0!

                                       n/a              * color *              * color *

                                n/a                    (Paste)                (Paste)

                                None at this time.
1st Grade MAZE
                        Cut Scores for F -- W -- Sp   Fall MAZE
Red (<10th %ile)        0 -- 0 -- 1                   n/a
Yellow (10-24th %ile)   0 -- 1 -- 4                   n/a
Green/Yellow (25-49)                                             0   #DIV/0!
Green (>=50th %ile)     1 -- 3 -- 8                              0   #DIV/0!   #DIV/0!
Total Assessed                                                   0   #DIV/0!
(Teacher Name)          (Student Name)                color format
(Click here to paste)
Winter MAZE                          Spring MAZE
n/a                                               0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!   #DIV/0!                0   #DIV/0!   #DIV/0!            Student's
             0   #DIV/0!                          0   #DIV/0!             Expected Fall-Winter
color format                         color format                         ROI      ROI
                                                                                0.2 FALSE
                                                                                     FALSE
Student's Student's
Winter-Sp Fall-Sprng
ROI       ROI
  FALSE     FALSE
  FALSE     FALSE
ISAT Correlates
              ISAT Cut Scores   Fall                   Winter                 Spring
Below Basic 30 -- 55 -- 70              0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Questionable                            0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Proficient   45 -- 65 -- 90             0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
# Assessed                              0    #DIV/0!            0   #DIV/0!            0   #DIV/0!

                                 * color *              * color *              * color *

                                (Paste)                (Paste)                (Paste)
2nd Grade RCBM
                        Cut Scores for F -- W -- Sp   Fall RCBM
Red (<10th %ile)        15 -- 30 -- 50                           0   #DIV/0!
Yellow (10-24th %ile)   30 -- 59 -- 75                           0   #DIV/0!
Green/Yellow (25-49)                                             0   #DIV/0!
Green (>=50th %ile)     59 -- 84 -- 100                          0   #DIV/0!   #DIV/0!
Total Assessed                                                   0   #DIV/0!
(Teacher Name)          (Student Name)                color format
(Click here to paste)
Winter RCBM                          Spring RCBM
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!   #DIV/0!                0   #DIV/0!   #DIV/0!            Student's
             0   #DIV/0!                          0   #DIV/0!             Expected Fall-Winter
color format                         color format                         ROI      ROI
                                                                                1.3 FALSE
                                                                                     FALSE
Student's Student's
Winter-Sp Fall-Sprng
ROI       ROI
  FALSE     FALSE
  FALSE     FALSE
ISAT Correlates
              ISAT Cut Scores   Fall                   Winter                 Spring
Below Basic 2 -- 5 -- 8                 0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Questionable                            0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Proficient   4 -- 10 -- 15              0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
# Assessed                              0    #DIV/0!            0   #DIV/0!            0   #DIV/0!

                                 * color *              * color *              * color *

                                (Paste)                (Paste)                (Paste)
2nd Grade MAZE
                        Cut Scores for F -- W -- Sp   Fall MAZE
Red (<10th %ile)        0 -- 3 -- 5                   n/a            #VALUE!
Yellow (10-24th %ile)   2 -- 6 -- 10                             0    #DIV/0!
Green/Yellow (25-49)                                             0    #DIV/0!
Green (>=50th %ile)     4 -- 10 -- 14                            0    #DIV/0!   #DIV/0!
Total Assessed                                                   0    #DIV/0!
(Teacher Name)          (Student Name)                color format
(Click here to paste)
Winter MAZE                          Spring MAZE
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!   #DIV/0!                0   #DIV/0!   #DIV/0!            Student's
             0   #DIV/0!                          0   #DIV/0!             Expected Fall-Winter
color format                         color format                         ROI      ROI
                                                                                0.3 FALSE
                                                                                     FALSE
Student's Student's
Winter-Sp Fall-Sprng
ROI       ROI
  FALSE     FALSE
  FALSE     FALSE
ISAT Correlates
              ISAT Cut Scores   Fall                   Winter                 Spring
Below Basic 60 -- 77 -- 90              0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Questionable                            0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Proficient   80 -- 100 -- 115           0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
# Assessed                              0    #DIV/0!            0   #DIV/0!            0   #DIV/0!

                                 * color *              * color *              * color *

                                (Paste)                (Paste)                (Paste)
3rd Grade RCBM
                        Cut Scores for F -- W -- Sp   Fall RCBM
Red (<10th %ile)        33 -- 47 -- 60                           0   #DIV/0!
Yellow (10-24th %ile)   53 -- 76 -- 89                           0   #DIV/0!
Green/Yellow (25-49)                                             0   #DIV/0!
Green (>=50th %ile)     82 --104 -- 118                          0   #DIV/0!   #DIV/0!
Total Assessed                                                   0   #DIV/0!
(Teacher Name)          (Student Name)                color format
(Click here to paste)
Winter RCBM                          Spring RCBM
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!   #DIV/0!                0   #DIV/0!   #DIV/0!            Student's
             0   #DIV/0!                          0   #DIV/0!             Expected Fall-Winter
color format                         color format                         ROI      ROI
                                                                                1.0 FALSE
                                                                                     FALSE
Student's Student's
Winter-Sp Fall-Sprng
ROI       ROI
  FALSE     FALSE
  FALSE     FALSE
ISAT Correlates
              ISAT Cut Scores   Fall                   Winter                 Spring
Below Basic 5 -- 10 -- 15               0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Questionable                            0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Proficient   10 -- 17 -- 22             0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
# Assessed                              0    #DIV/0!            0   #DIV/0!            0   #DIV/0!

                                 * color *              * color *              * color *

                                (Paste)                (Paste)                (Paste)
3rd Grade MAZE
                        Cut Scores for F -- W -- Sp   Fall MAZE
Red (<10th %ile)        4 -- 6 -- 7                              0   #DIV/0!
Yellow (10-24th %ile)   7 -- 10 -- 10                            0   #DIV/0!
Green/Yellow (25-49)                                             0   #DIV/0!
Green (>=50th %ile)     12 -- 15 -- 15                           0   #DIV/0!   #DIV/0!
Total Assessed                                                   0   #DIV/0!
(Teacher Name)          (Student Name)                color format
(Click here to paste)
Winter MAZE                          Spring MAZE
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!   #DIV/0!                0   #DIV/0!   #DIV/0!            Student's
             0   #DIV/0!                          0   #DIV/0!             Expected Fall-Winter
color format                         color format                         ROI      ROI
                                                                                0.1 FALSE
                                                                                     FALSE
Student's Student's
Winter-Sp Fall-Sprng
ROI       ROI
  FALSE     FALSE
  FALSE     FALSE
ISAT Correlates
              ISAT Cut Scores    Fall                   Winter                 Spring
Below Basic 60 -- 85 -- 95               0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Questionable                             0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Proficient   105 -- 125 -- 140           0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
# Assessed                               0    #DIV/0!            0   #DIV/0!            0   #DIV/0!

                                  * color *              * color *              * color *

                                 (Paste)                (Paste)                (Paste)
4th Grade RCBM
                        Cut Scores for F -- W -- Sp   Fall RCBM
Red (<10th %ile)        52 -- 66 -- 78                           0   #DIV/0!
Yellow (10-24th %ile)   77 -- 94 -- 104                          0   #DIV/0!
Green/Yellow (25-49)                                             0   #DIV/0!
Green (>=50th %ile)     103 -- 118 -- 131                        0   #DIV/0!   #DIV/0!
Total Assessed                                                   0   #DIV/0!
(Teacher Name)          (Student Name)                color format
(Click here to paste)
Winter RCBM                          Spring RCBM
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!   #DIV/0!                0   #DIV/0!   #DIV/0!            Student's
             0   #DIV/0!                          0   #DIV/0!             Expected Fall-Winter
color format                         color format                         ROI      ROI
                                                                                0.8 FALSE
                                                                                     FALSE
Student's Student's
Winter-Sp Fall-Sprng
ROI       ROI
  FALSE     FALSE
  FALSE     FALSE
ISAT Correlates
              ISAT Cut Scores   Fall                   Winter                 Spring
Below Basic 7 -- 13 -- 15               0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Questionable                            0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Proficient   11 -- 18 -- 20             0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
# Assessed                              0    #DIV/0!            0   #DIV/0!            0   #DIV/0!

                                 * color *              * color *              * color *

                                (Paste)                (Paste)                (Paste)
4th Grade MAZE
                        Cut Scores for F -- W -- Sp   Fall MAZE
Red (<10th %ile)        5 -- 9 -- 10                             0   #DIV/0!
Yellow (10-24th %ile)   9 -- 14 -- 14                            0   #DIV/0!
Green/Yellow (25-49)                                             0   #DIV/0!
Green (>=50th %ile)     13 -- 19 -- 19                           0   #DIV/0!   #DIV/0!
Total Assessed                                                   0   #DIV/0!
(Teacher Name)          (Student Name)                color format
(Click here to paste)
Winter MAZE                          Spring MAZE
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!   #DIV/0!                0   #DIV/0!   #DIV/0!            Student's
             0   #DIV/0!                          0   #DIV/0!             Expected Fall-Winter
color format                         color format                         ROI      ROI
                                                                                0.2 FALSE
                                                                                     FALSE
Student's Student's
Winter-Sp Fall-Sprng
ROI       ROI
  FALSE     FALSE
  FALSE     FALSE
ISAT Correlates
              ISAT Cut Scores    Fall                   Winter                 Spring
Below Basic 95 -- 125 -- 140             0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Questionable                             0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Proficient   130 -- 145 -- 155           0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
# Assessed                               0    #DIV/0!            0   #DIV/0!            0   #DIV/0!

                                  * color *              * color *              * color *

                                 (Paste)                (Paste)                (Paste)
5th Grade RCBM
                        Cut Scores for F -- W -- Sp   Fall RCBM
Red (<10th %ile)        64 -- 77 -- 87                           0   #DIV/0!
Yellow (10-24th %ile)   89 -- 102 -- 114                         0   #DIV/0!
Green/Yellow (25-49)                                             0   #DIV/0!
Green (>=50th %ile)     115 -- 132 -- 147                        0   #DIV/0!   #DIV/0!
Total Assessed                                                   0   #DIV/0!
(Teacher Name)          (Student Name)                color format
(Click here to paste)
Winter RCBM                          Spring RCBM
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!   #DIV/0!                0   #DIV/0!   #DIV/0!            Student's
             0   #DIV/0!                          0   #DIV/0!             Expected Fall-Winter
color format                         color format                         ROI      ROI
                                                                                0.9 FALSE
                                                                                     FALSE
Student's Student's
Winter-Sp Fall-Sprng
ROI       ROI
  FALSE     FALSE
  FALSE     FALSE
ISAT Correlates
             ISAT Cut Scores   Fall                   Winter                 Spring
Below Basic 11 -- 16 -- 21             0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Questionable                           0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
Proficient   17 -- 23 -- 28            0    #DIV/0!            0   #DIV/0!            0   #DIV/0!
# Assessed                             0    #DIV/0!            0   #DIV/0!            0   #DIV/0!

                                * color *              * color *              * color *

                               (Paste)                (Paste)                (Paste)
5th Grade MAZE
                        Cut Scores for F -- W -- Sp   Fall MAZE
Red (<10th %ile)        7 -- 10 -- 13                            0   #DIV/0!
Yellow (10-24th %ile)   11 -- 15 -- 18                           0   #DIV/0!
Green/Yellow (25-49)                                             0   #DIV/0!
Green (>=50th %ile)     16 -- 20 -- 24                           0   #DIV/0!   #DIV/0!
Total Assessed                                                   0   #DIV/0!
(Teacher Name)          (Student Name)                color format
(Click here to paste)
Winter MAZE                          Spring MAZE
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!                          0   #DIV/0!
             0   #DIV/0!   #DIV/0!                0   #DIV/0!   #DIV/0!            Student's
             0   #DIV/0!                          0   #DIV/0!             Expected Fall-Winter
color format                         color format                         ROI      ROI
                                                                                0.2 FALSE
                                                                                     FALSE
Student's Student's
Winter-Sp Fall-Sprng
ROI       ROI
  FALSE     FALSE
  FALSE     FALSE

								
To top