Docstoc

Blank Template

Document Sample
Blank Template Powered By Docstoc
					Video instructions will be online at http://www.teachnorth.com/oscc/eqao/



     Instructions for Using This Spreadsheet
     For questions/comments, please contact Scott Monahan
     scott.monahan@yrdsb.edu.on.ca or monahan.scott@gmail.com

     1. Download the IIR Reports from the EQAO Website in MS Excel format for Grade 3 and 6, Reading, Writing, and Math
     2. Open the IIR Report for Grade 3 Reading
     3. Scroll to the bottom of the page where you will see the Summary Results (looks like picture below).




     4. Copy the summary results for Grade 3 Reading from the cell in the A column that says Summary Results
     reach the end of the table and the large number that represents all students in the province at a level 3 or 4.
     5. Copy the data using the Copy button on your toolbar or pressing [CTRL] and [C] on your keyboard.
     6. Switch to this workbook and go to the EQAO Data tab.




     7. Go to the section where it tells you to paste the data for Grade 3 Reading EQAO results. In this case, Cell A15.
     8. Paste the data you copied from the IIR report into the EQAO Data spreadsheet by pressing the Paste
     pressing [CTRL] and [V] on your key board.
     9. Repeat Steps 2 - 8 for each IIR report making sure to pay attention to where you are pasting it in the EQAO Data spre
     10. There is a data valadation tool (it's not perfect) but it checks the provincial data and headings you copied against the
      headings that should be the same for all schools. If you copy something and it appears correct, it will turn green and sa
      If you do something wrong, it will turn red and say "Oops" in the cell. In the example below, it looks like I copied the Gr
     incorrectly.




     11. If you do make a mistake and see an "Oops", press the "Undo" button or [CTRL] and [Z] on your keyboard.
nd 6, Reading, Writing, and Math

 e picture below).




 ys Summary Results§§ down and right until you
ovince at a level 3 or 4.
your keyboard.




ults. In this case, Cell A15.
ressing the Paste button on your toolbar, or by

e pasting it in the EQAO Data spreadsheet.
nd headings you copied against the provincial data and
 s correct, it will turn green and say "Good" in the cell.
 below, it looks like I copied the Grade 3 Writing Data




nd [Z] on your keyboard.
School Name:

Data Validation


The cells below will turn green if you have pasted your data in the right
location. If not, they will turn red and say "Oops". Please check and make
sure that you have all of the cells pasted in the correct spot.
                   Grade 3                                 Grade 6
Reading              Writing      Math        Reading Writing       Math




Paste your Grade 3 Reading EQAO Summary Results in Cell A13.




Paste your Grade 3 Writing EQAO Summary Results in Cell A22.




Paste your Grade 3 Math EQAO Summary Results in Cell A31.




Paste your Grade 6 Reading EQAO Summary Results in Cell A40.
Paste your Grade 6 Writing EQAO Summary Results in Cell A49.




Paste your Grade 6 Math EQAO Summary Results in Cell 58.
Grade 3 Reading Numbers                      Grade 3 Writing Numbers
Summary Results                              Summary Results
School    Board     Province                 School    Board      Province




         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0

School       Board       Province       0   0 School       Board       Province
         0           0              0                  0           0              0
         Grade 3 Math Numbers
         Summary Results
         School    Board     Province




                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0
                   0           0              0


0   0   0 School       Board       Province       0   0   0
                   0           0              0
Grade 6 Reading Numbers                      Grade 6 Writing Numbers
Summary Results                              Summary Results
School    Board     Province                 School    Board      Province




         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0                  0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0
         0           0              0

School       Board       Province       0   0 School       Board       Province       0
         0           0              0                  0           0              0
     Grade 6 Math Numbers
     Summary Results
     School    Board     Province




               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0
               0           0              0

0   0 School       Board       Province
               0           0              0
                                                           78f8982d-2392-40c1-b42e-c9b6fd646236.xlsx




                                     Grade 3 EQAO Summary Report
Scores for School, Board and Province represent average percentage of students responding at or above level 3 for open response or
written answers, and percentage of students with correct answer for multiple choice questions.

                                                      Grade 3 Reading

Number of students assessed at this school:                    0
Each student represents this percentage of total:           #DIV/0!

                                                          Number of
                                                          Questions            School              Board            Province
Multiple Choice                                              26                  0.0                0.0                0.0
Open Response                                                10                  0.0                0.0                0.0

                                                          Number of
Overall Expectations                                      Questions            School              Board            Province
R 1.0                                                        16                  0.0                0.0                0.0
R 2.0                                                        10                  0.0                0.0                0.0
R 3.0                                                        10                  0.0                0.0                0.0

                                                          Number of
Skills                                                    Questions            School              Board            Province
Explicit Understanding                                        4                  0.0                0.0                0.0
Implicit Understanding                                       16                  0.0                0.0                0.0
Making Connections                                           16                  0.0                0.0                0.0

                                                          Number of
                                                          Questions            School              Board            Province
Overall                                                      36                  0.0                0.0                0.0




Gr. 3 Summary                                                                                                                        12/18/2011
                                                          78f8982d-2392-40c1-b42e-c9b6fd646236.xlsx




                                                      Grade 3 Writing

Number of students assessed at this school:                   0
Each student represents this percentage of total:          #DIV/0!

                                                         Number of
                                                         Questions            School               Board   Province
Multiple Choice                                             8                   0.0                 0.0       0.0
Short Written Response                                      6                   0.0                 0.0       0.0
Long Written Response                                       3                   0.0                 0.0       0.0

                                                         Number of
                                                         Questions            School               Board   Province
Topic Development                                           6                   0.0                 0.0       0.0
Conventions                                                 3                   0.0                 0.0       0.0


                                                         Number of
Overal Expectations                                      Questions            School               Board   Province
W1.0                                                        5                   0.0                 0.0       0.0
W2.0                                                        6                   0.0                 0.0       0.0
W3.0                                                        6                   0.0                 0.0       0.0

*Total questions do not match because some questions were assessed for two overall expectations.

                                                         Number of
                                                         Questions            School               Board   Province
Overall                                                     17                  0.0                 0.0       0.0




Gr. 3 Summary                                                                                                         12/18/2011
                                                      78f8982d-2392-40c1-b42e-c9b6fd646236.xlsx




                                                    Grade 3 Math

Number of students assessed at this school:              0
Each student represents this percentage of total:     #DIV/0!

                                                     Number of
                                                     Questions          School           Board    Province
Multiple Choice                                         28                0.0             0.0        0.0
Open Response                                            7                0.0             0.0        0.0

                                                     Number of
                                                     Questions          School           Board    Province
Number Sense and Numeracy                               9                 0.0             0.0        0.0
Measurement                                             9                 0.0             0.0        0.0
Geometry and Spatial Sense                              6                 0.0             0.0        0.0
Patterning and Algebra                                  7                 0.0             0.0        0.0
Data Management and Probability                         4                 0.0             0.0        0.0

                                                     Number of
                                                     Questions          School           Board    Province
Application                                             15                0.0             0.0        0.0
Knowledge and Understanding                             12                0.0             0.0        0.0
Problem Solving                                          8                0.0             0.0        0.0

                                                     Number of
                                                     Questions          School           Board    Province
Overall                                                 35                0.0             0.0        0.0




Gr. 3 Summary                                                                                                12/18/2011
                                                           78f8982d-2392-40c1-b42e-c9b6fd646236.xlsx




                               Grade 6 EQAO Summary Report

Scores for School, Board and Province represent average percentage of students responding at or above level 3 for open
response or written answers, and percentage of students with correct answer for multiple choice questions.

                                                    Grade 6 Reading

Number of students assessed at this school:                 0.00
Each student represents this percentage of total:          #DIV/0!

                                                         Number of
                                                         Questions         School           Board         Province
Multiple Choice                                             26               0.0             0.0             0.0
Open Response                                               10               0.0             0.0             0.0

                                                         Number of
Overall Expectations                                     Questions         School           Board         Province
R 1.0                                                       21               0.0             0.0             0.0
R 2.0                                                       9                0.0             0.0             0.0
R 3.0                                                       6                0.0             0.0             0.0

                                                         Number of
Skills                                                   Questions         School           Board         Province
Explicit Understanding                                      6                0.0             0.0             0.0
Implicit Understanding                                      18               0.0             0.0             0.0
Making Connections                                          12               0.0             0.0             0.0

                                                         Number of
                                                         Questions         School           Board         Province
Overall                                                     36               0.0             0.0             0.0




Gr. 6 Summary                                                                                                            12/18/2011
                                                           78f8982d-2392-40c1-b42e-c9b6fd646236.xlsx




                                                    Grade 6 Writing

Number of students assessed at this school:                 0.00
Each student represents this percentage of total:          #DIV/0!

                                                         Number of
                                                         Questions        School          Board        Province
Multiple Choice                                             8               0.0            0.0            0.0
Short Written Response                                      6               0.0            0.0            0.0
Long Written Response                                       3               0.0            0.0            0.0

                                                         Number of
                                                         Questions        School          Board        Province
Topic Development                                           6               0.0            0.0            0.0
Conventions                                                 3               0.0            0.0            0.0

                                                         Number of
Overal Expectations                                      Questions        School          Board        Province
W1.0                                                        6               0.0            0.0            0.0
W2.0                                                        6               0.0            0.0            0.0
W3.0                                                        5               0.0            0.0            0.0

*Total questions do not match because some questions were assessed for two overall expectations.

                                                         Number of
                                                         Questions        School          Board        Province
Overall                                                     17              0.0            0.0            0.0




Gr. 6 Summary                                                                                                     12/18/2011
                                                         78f8982d-2392-40c1-b42e-c9b6fd646236.xlsx




                                                    Grade 6 Math

Number of students assessed at this school:               0.00
Each student represents this percentage of total:        #DIV/0!

                                                        Number of
                                                        Questions      School         Board          Province
Multiple Choice                                            28            0.0           0.0              0.0
Open Response                                              8             0.0           0.0              0.0

                                                        Number of
                                                        Questions      School         Board          Province
Number Sense and Numeracy                                  8             0.0           0.0              0.0
Measurement                                                8             0.0           0.0              0.0
Geometry and Spatial Sense                                 6             0.0           0.0              0.0
Patterning and Algebra                                     7             0.0           0.0              0.0
Data Management and Probability                            7             0.0           0.0              0.0

                                                        Number of
                                                        Questions      School         Board          Province
Application                                                16            0.0           0.0              0.0
Knowledge and Understanding                                8             0.0           0.0              0.0
Thinking                                                   12            0.0           0.0              0.0

                                                        Number of
                                                        Questions      School         Board          Province
Overall                                                    36            0.0           0.0              0.0




Gr. 6 Summary                                                                                                   12/18/2011
                                                     on lt.
                                    Ch / Cor Code
                                                           u
                                                         se
                                            e R ect M
                                                         n
                                                      tio
                        r
                    be




                                                  cta


                                       ble core

                                                esp
                                                   r
                                                  r
                  um

                                 e


                                             x pe




                                                                     vg.
                              mb




                                Po hest S
        ll




                                            e
     Ski


                tN




                                        ll E
                                       Typ




                                                                  lA
                                       oic
                         Nu
                  e




                                        l
    et




                                     oo




                                                                oo
                                    era
               okl




                                  Hig
                                   ssi
                          m

                                    m
     g




                                Sch




                                                               Sch
  Tar




                                Ov
                      Ite

                                Ite
             Bo



 Expl. Und.      L1       7          MC   R3.0    c    0                   0
 Expl. Und.      L1       17         MC   R3.0   b     0                   0
 Expl. Und.      L2       6          MC   R1.0    c    0                   0
 Expl. Und.      L1       18         OR   R1.0   40    0                   0
 Impl. Und.      L1       1          MC   R2.0   d     0                   0
 Impl. Und.      L1       3          MC   R3.0    c    0                   0
 Impl. Und.      L1       8          MC   R3.0   d     0                   0
 Impl. Und.      L1       9          MC   R1.0   d     0                   0
 Impl. Und.      L1       15         MC   R1.0    a    0                   0
 Impl. Und.      L2       3          MC   R3.0   d     0                   0
 Impl. Und.      L2       4          MC   R2.0   b     0                   0
 Impl. Und.      L2       7          MC   R1.0   d     0                   0
 Impl. Und.      L2       8          MC   R1.0    a    0                   0
 Impl. Und.      L2       9          MC   R3.0    c    0                   0
 Impl. Und.      L2       18         MC   R2.0    a    0                   0
 Impl. Und.      L2       19         MC   R1.0   d     0                   0
 Impl. Und.      L2       20         MC   R1.0   b     0                   0
 Impl. Und.      L2       21         MC   R3.0   b     0                   0
 Impl. Und.      L1       12         OR   R2.0   40    0                   0
 Impl. Und.      L2       12         OR   R2.0   40    0                   0
  Mk. Con.       L1       2          MC   R1.0   d     0                   0
  Mk. Con.       L1       4          MC   R3.0   b     0                   0
  Mk. Con.       L1       10         MC   R2.0    c    0                   0
  Mk. Con.       L1       14         MC   R3.0   b     0                   0
  Mk. Con.       L1       16         MC   R2.0    c    0                   0
  Mk. Con.       L2       1          MC   R2.0    a    0                   0
  Mk. Con.       L2       2          MC   R1.0   b     0                   0
  Mk. Con.       L2       5          MC   R3.0   b     0                   0
  Mk. Con.       L2       10         MC   R2.0   d     0                   0
  Mk. Con.       L1       5          OR   R1.0   40    0                   0
  Mk. Con.       L1       6          OR   R1.0   40    0                   0
  Mk. Con.       L1       11         OR   R1.0   40    0                   0
  Mk. Con.       L1       19         OR   R1.0   40    0                   0
  Mk. Con.       L2       11         OR   R1.0   40    0                   0
  Mk. Con.       L2       22         OR   R1.0   40    0                   0
  Mk. Con.       L2       23         OR   R2.0   40    0                   0


Multiple Choice                           26
Open Response                             10
Expecation               R1.0   16
                         R2.0   10
                         R3.0   10

Skills
Explicit Understanding           4
Implicit Understanding          16
Making Connections              16


Total Questions                 36
                                                 g.
                                               Av
g.




                    g.
                  Av




                                    ce




                                                ce
                                vin




                                            vin
       ar d




                ar d




                             Pro




                                         Pro
     Bo




              Bo
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
     0                   0   0                        0
                     vg.




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
    Pro
       vin
           ce
                 (Le
                     ve    l3
                                or
                                   H   igh
                                           er)




    Pro
       vi
    Av nce (L
      g.     eve
                           l3
                                or
                                   H   igh
                                           er)




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




    Hig
       h   er
                or




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




                     Low
    Hig                 er
       h   er                Bo
                or              a




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




                     Low rd?
    Hig                 er
       he            Pro
    Pro r or L          vin
    10 vince owe            ce?
      %o L         r
             eve than
    bo r gre l 3
      ard     a
          or ter bor Hig
            pro elo he
                vin w r
                   ce?
                                                                    e Res ect Mult.
                                                          n

                                                                    ble/ C Code
                                                    ctatio




                                                                               e
                    r




                                                                          pons
               umbe
       ype




                                                                           orr
                                                                            re
                           ber




                                               Expe

                                                                     st Sco




                                                                         g.
 tion T




                                                                                            Avg.
                                    d for
                       Nu m
              let N




                                                                   ol Av
                                                 all




                                                                                          Board
                                                              Highe
                             Sc o re




                                                              Choic
Ques




                                                              Possi
             Book




                                            Over




                                                              Scho
                      Item




 MC          L2       13           MC       W2.0                   d                  0            0
 MC          L2       14           MC       W1.0                    c                 0            0
 MC          L2       15           MC       W1.0                   b                  0            0
 MC          L2       16           MC       W3.0                    c                 0            0
 MC          L2       25           MC       W2.0                   b                  0            0
 MC          L2       26           MC       W3.0                   d                  0            0
 MC          L2       27           MC       W3.0                    a                 0            0
 MC          L2       28           MC       W2.0                   b                  0            0
 SW          L1       13          OR-CV     W3.0                   30                 0            0
 SW          L1       13          OR-TD     W2.0                   40                 0            0
 SW          L1       13          OR-TD     W1.0                   40                 0            0
 SW          L2       17          OR-CV     W3.0                   30                 0            0
 SW          L2       17          OR-TD     W1.0                   40                 0            0
 SW          L2       17          OR-TD     W2.0                   40                 0            0
 LW          L2       24          OR-CV     W3.0                   30                 0            0
 LW          L2       24          OR-TD     W1.0                   40                 0            0
 LW          L2       24          OR-TD     W2.0                   40                 0            0




Multiple Choice                                        8
Short Written                                          6
Long Written                                           3


Topic Development                                      6
Conventions                                            3

Expectations
W1.0                                                   5
W2.0                                                   6
W3.0                                                   6
    Provi
            nce A
                  vg.




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
    Provi
          nce
    Highe (Level 3 o
           r) Avg   r
                  .




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




    Highe
          r   or Lo
                   wer Bo
    Highe                 ard?




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




           r or L
    Provi         ower
          nce?
    Highe
           ro
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




    Provi r Lower th
          nce L
    Highe       evel 3 an
           r           or

    10%
        or g
    board reater be
          or pr       lo
                ovinc w
                     e?
    Colum
          n6
0
                                                                            lt.
                                                                       t Mu
                                             n



                                                          ble/ C Code
                                       ctatio




                                                                     e
                                                                 orrec
                                                                pons
                                                                  re
                         ber


                                  Expe



                                                           st Sco




                                                               g.




                                                                                        Avg.
                                                          e Res
                    Nu m
                    Type




                                                         ol Av
                                    all
 d




                                                                                      Board
                                                    Highe

                                                    Choic
Stran




                                                    Possi
                               Over




                                                    Scho
              Item
               Item



                                            Skill
Num. Sen.     1      MC        NV3           KU            c                      0            0
Num. Sen.     3      MC        NV2           AP            c                      0            0
Num. Sen.     4      MC        NV3           AP            a                      0            0
Num. Sen.     6      MC        NV3           PS            b                      0            0
Num. Sen.     12     MC        NV3           AP            b                      0            0
Num. Sen.     20     MC        NV1           PS            d                      0            0
Num. Sen.     31     MC        NV1           KU            d                      0            0
Num. Sen.     9      OR        NV2           PS           40                      0            0
Num. Sen.     26     OR        NV3           AP           40                      0            0
  Meas.       10     MC        MV2           AP            d                      0            0
  Meas.       15     MC        MV1           KU            a                      0            0
  Meas.       16     MC        MV2           KU            a                      0            0
  Meas.       17     MC        MV1           KU            d                      0            0
  Meas.       23     MC        MV2           KU            d                      0            0
  Meas.       24     MC        MV1           AP            b                      0            0
  Meas.       30     MC        MV1           AP            d                      0            0
  Meas.       34     MC        MV2           PS            b                      0            0
  Meas.       8      OR        MV2           PS           40                      0            0
  Geom.       21     MC        GV2           KU            d                      0            0
  Geom.       22     MC        GV1           AP            a                      0            0
  Geom.       33     MC        GV3           AP            c                      0            0
  Geom.       35     MC        GV2           KU            d                      0            0
  Geom.       7      OR        GV2           PS           40                      0            0
  Geom.       25     OR        GV3           AP           40                      0            0
 Patt. Alg.   2      MC        PV1           KU            d                      0            0
 Patt. Alg.   5      MC        PV2           AP            b                      0            0
 Patt. Alg.   11     MC        PV2           KU            d                      0            0
 Patt. Alg.   18     MC        PV1           KU            b                      0            0
 Patt. Alg.   19     MC        PV2           AP            a                      0            0
 Patt. Alg.   32     MC        PV1           PS            b                      0            0
 Patt. Alg.   27     OR        PV1           AP           40                      0            0
Data Prob.    13     MC        DV3           AP            d                      0            0
Data Prob.    14     MC        DV2           AP            c                      0            0
Data Prob.    29     MC        DV2           KU            a                      0            0
Data Prob.    28     OR        DV2           PS           40                      0            0
Multiple Choice   28
Open Response      7

Strand
Num. Sen.          9
Meas.              9
Geom.              6
Patt. Alg.         7
Data Prob.         4

Skill
AP                15
KU                12
PS                 8

Total Questions   35
    Provi
            nce A
                  vg.




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0   Provi
          nce
    Highe (Level 3 o
           r) Avg   r
                  .




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




    Highe
          r   or Lo
                   wer Bo
    Highe                 ard?




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




           r or L
    Provi         ower
          nce?
    Highe
           ro




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




    Provi r Lower th
          nce            an
    Highe Level 3 o
           r            r
    10%
        or g
    board reater be
          or pr       lo
                ovinc w
                     e?
    Colum
          n6
                                                             se lt.
                                                                    u
                                                       esp t M
                                                                  n


                                                   e R orrec e
                                                               tio

                                             Ch ble/ C Cod
                              r
                            be




                                                           cta




                                                           on
                                               ssi core
                          er
                        um




                                                        xpe




                                                       vg.
                       mb
     ll




                                                                                   vg.
                                     e
   Ski




                  tN




                                                    st S
                                            ll E
                                  Typ




                                                    lA
                    Nu




                                                                                 A
                    e
   get




                                                 oo
                                           era




                                                                              rd
                                                 he
                okl




                                                oic
                         m


                                  m




                                                                               a
                                             Sch
                                             Hig
Tar




                                         Ov
                        Ite


                               Ite
             Bo




                                                                            Bo
                                             Po
Expl. Und.     L1         1       MC     R1.0       d                   0                0
Expl. Und.     L1          7      MC     R1.0       b                   0                0
Expl. Und.     L2          3      MC     R1.0       d                   0                0
Expl. Und.     L2          6      MC     R1.0       d                   0                0
Expl. Und.     L2          8      MC     R3.0       b                   0                0
Expl. Und.     L2         18      MC     R1.0        c                  0                0
Impl. Und.     L1          2      MC     R3.0       b                   0                0
Impl. Und.     L1          4      MC     R1.0       a                   0                0
Impl. Und.     L1         10      MC     R1.0       b                   0                0
Impl. Und.     L1         15      MC     R2.0        a                  0                0
Impl. Und.     L1         16      MC     R1.0       b                   0                0
Impl. Und.     L1         17      MC     R3.0       b                   0                0
Impl. Und.     L2          1      MC     R2.0       b                   0                0
Impl. Und.     L2          2      MC     R1.0        c                  0                0
Impl. Und.     L2          4      MC     R2.0        a                  0                0
Impl. Und.     L2          5      MC     R1.0        c                  0                0
Impl. Und.     L2          9      MC     R1.0       b                   0                0
Impl. Und.     L2         10      MC     R1.0       b                   0                0
Impl. Und.     L2         19      MC     R1.0        c                  0                0
Impl. Und.     L2         20      MC     R2.0       d                   0                0
Impl. Und.     L1          6      OR     R2.0       40                  0                0
Impl. Und.     L2         11      OR     R2.0       40                  0                0
Impl. Und.     L2         12      OR     R1.0       40                  0                0
Impl. Und.     L2         22      OR     R2.0       40                  0                0
 Mk. Con.      L1          3      MC     R2.0       b                   0                0
 Mk. Con.      L1          8      MC     R2.0        c                  0                0
 Mk. Con.      L1          9      MC     R3.0        a                  0                0
 Mk. Con.      L1         14      MC     R1.0        c                  0                0
 Mk. Con.      L2          7      MC     R3.0       d                   0                0
 Mk. Con.      L2         21      MC     R3.0       d                   0                0
 Mk. Con.      L1          5      OR     R1.0       40                  0                0
 Mk. Con.      L1         11      OR     R1.0       40                  0                0
 Mk. Con.      L1         12      OR     R1.0       40                  0                0
 Mk. Con.      L1         18      OR     R1.0       40                  0                0
 Mk. Con.      L1         19      OR     R1.0       40                  0                0
 Mk. Con.      L2         23      OR     R1.0       40                  0                0
Multiple Choice                 26
Open Response                   10

Expecation               R1.0   21
                         R2.0    9
                         R3.0    6

Skills
Explicit Understanding           6
Implicit Understanding          18
Making Connections              12


Total Questions                 36
                                      er)




                                                                                                    e?




                                                                                                     r
                                                                                                   he
                                   igh




                                                                                                in c
                                                                ?




                                                                                               Hig
                                                                rd
                                H




                                                                                               w
                                                                                       el 3 n
                                                                                             rov
                                                             oa




                                                                                   Lev r tha


                                                                                   pro elo
                             or




                                                                                           ce?
                                                                                            or
                                                           rB


                                                                                           rP
                              l3




                                                                               o r er b
                                                                                       v in
                                                            e


                                                                        e


                                                                                      we
                           eve




                                                        Low


                                                                    Low
       vg.




                                                                          ard reat
                                                                                  r Lo
                 Av nce (L
         A




                                                     or


                                                                 or




                                                                               n1
                                                                              rg
      ce




                                                                              ce
                                                                              ro
                                                       r


                                                                   r




                                                                          lum
   vin




                                                                           vin

                                                                         %o
                                                    he


                                                                he


                                                                           he
                    vi
                   g.
Pro




                 Pro




                                                                       Pro
                                                Hig


                                                            Hig


                                                                       Hig




                                                                       Co
                                                                       bo
                                                                       10
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
             0                              0   0          0            0
                                                                                    lt.
                                                                               t Mu
                                                        n


                                                                  ble/ C Code
                                                  ctatio




                                                                             e
                    r




                                                                         orrec
                                                                        pons
               umbe
       ype




                                                                         re
                                    ber




                                             Expe


                                                                   st Sco




                                                                                                g.
 tion T




                                                                                                           Avg.
                                                                  e Res
                               d for
                               Nu m
              let N




                                                                                           ol Av
                                               all




                                                                                                         Board
                                                            Highe
                        Sc o re




                                                            Choic
Ques




                                                            Possi
             Book




                                          Over




                                                                                          Scho
                      Item




MC            L2      13          MC       W3.0                       a                              0            0
MC            L2      14          MC       W1.0                       d                              0            0
MC            L2      15          MC       W1.0                        c                             0            0
MC            L2      16          MC       W2.0                       d                              0            0
MC            L2      25          MC       W1.0                       d                              0            0
MC            L2      26          MC       W2.0                        c                             0            0
MC            L2      27          MC       W3.0                       d                              0            0
MC            L2      28          MC       W2.0                       a                              0            0
SW            L1      13         OR-CV     W3.0                       30                             0            0
SW            L1      13         OR-TD     W1.0                       40                             0            0
SW            L1      13         OR-TD     W2.0                       40                             0            0
SW            L2      17         OR-CV     W3.0                       30                             0            0
SW            L2      17         OR-TD     W1.0                       40                             0            0
SW            L2      17         OR-TD     W2.0                       40                             0            0
LW            L2      24         OR-CV     W3.0                       30                             0            0
LW            L2      24         OR-TD     W1.0                       40                             0            0
LW            L2      24         OR-TD     W2.0                       40                             0            0




Multiple Choice                                       8
Short Written                                         6
Long Written                                          3


Topic Development                                     6
Conventions                                           3

Expectations
W1.0                                                  6
W2.0                                                  6
W3.0                                                  5

Total Questions                                      17
    Provi
            nce A
                  vg.




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
    Provi
          nce
    Highe (Level 3 o
           r) Avg   r
                  .




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




    Highe
          r   or Lo
                   w    er Bo
                             ard?




0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




    Highe
          r   or Lo
                   wer Pr
                          ovinc
    Highe                       e?


0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0




           r or L
                  ower
    Provi
          nce L        th
                evel 3 an
                        or Hi
    10%                      gher
        or gre
    board        ater b
            or pr      elo
                  ovinc w
                       e?
    Colum
            n6
                                                               e Res ect Mult.
                                             n




                                                               ble/ C Code
                                       ctatio




                                                                          e
                                                                     pons
                                                                      orr
                                                                       re
                         ber


                                  Expe




                                                                st Sco




                                                                    g.




                                                                                       Avg.
                    Nu m
                    Type




                                                              ol Av
                                    all
 d




                                                                                     Board
                                                         Highe

                                                         Choic
Stran




                                                         Possi
                               Over




                                                         Scho
              Item
               Item




                                                 Skill
Num. Sen.     1      MC         NV1               KU           c                 0            0
Num. Sen.     5      MC         NV2               AP           c                 0            0
Num. Sen.     23     MC         NV2               KU           c                 0            0
Num. Sen.     31     MC         NV3               AP           d                 0            0
Num. Sen.     32     MC         NV1               PS           b                 0            0
Num. Sen.     34     MC         NV3               PS           a                 0            0
Num. Sen.     8      OR         NV1               AP          40                 0            0
Num. Sen.     28     OR         NV3               PS          40                 0            0
  Meas.       3      MC         MV2               AP           b                 0            0
  Meas.       4      MC         MV2               AP           a                 0            0
  Meas.       19     MC         MV2               KU           a                 0            0
  Meas.       21     MC         MV2               KU           d                 0            0
  Meas.       22     MC         MV2               PS           b                 0            0
  Meas.       24     MC         MV2               PS           c                 0            0
  Meas.       33     MC         MV2               AP           a                 0            0
  Meas.       10     OR         MV2               AP          40                 0            0
  Geom.       6      MC         GV3               PS           a                 0            0
  Geom.       16     MC         GV3               AP           b                 0            0
  Geom.       17     MC         GV1               PS           c                 0            0
  Geom.       18     MC         GV1               KU           a                 0            0
  Geom.       7      OR         GV2               AP          40                 0            0
  Geom.       29     OR         GV3               PS          40                 0            0
 Patt. Alg.   2      MC         PV1               AP           c                 0            0
 Patt. Alg.   14     MC         PV2               KU           d                 0            0
 Patt. Alg.   15     MC         PV1               PS           c                 0            0
 Patt. Alg.   20     MC         PV1               AP           b                 0            0
 Patt. Alg.   25     MC         PV1               AP           b                 0            0
 Patt. Alg.   30     MC         PV1               KU           c                 0            0
 Patt. Alg.   26     OR         PV1               AP          40                 0            0
Data Prob.    11     MC         DV2               AP           d                 0            0
Data Prob.    12     MC         DV3               AP           b                 0            0
Data Prob.    13     MC         DV2               AP           d                 0            0
Data Prob.    35     MC         DV3               PS           d                 0            0
Data Prob.    36     MC         DV2               KU           c                 0            0
Data Prob.    9      OR         DV2               PS          40                 0            0
Data Prob.    27     OR         DV3               PS          40                 0            0
Multiple Choice   28
Open Response      8

Strand
Num. Sen.          8
Meas.              8
Geom.              6
Patt. Alg.         7
Data Prob.         7

Skill
AP                16
KU                 8
PS                12

Total Questions   36
                                                                     ard?




                                                                                        ovinc w
                                                           evel 3 an



                                                                                              lo
                                 r




                                                               er Bo




                                                                                             e?
                                                                  or
                 Highe (Level 3 o




                                               Provi r Lower th




                                                                            board reater be
                                                             ower
                                                 w
       vg.




                               .




                                            or Lo
                        r) Avg




                                                                                  or pr
                                                      r or L
 nce A




                                                     nce L
                                                     nce?




                                                                                  n6
                                                                                or g
                       nce




                                                      ro
                                               r




                                                      r




                                                                            Colum
                                         Highe

                                               Highe


                                               Highe

                                               Highe
Provi




                 Provi




                                               Provi




                                                                            10%
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0
             0                       0     0         0            0

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:12
posted:12/19/2011
language:English
pages:45