2012 data coach training high school day 1
Sponsored Links
This presentation is the property of its rightful owner.
1 / 130

2012 Data Coach Training – High School Day 1 PowerPoint PPT Presentation


  • 103 Views
  • Uploaded on
  • Presentation posted in: General

2012 Data Coach Training – High School Day 1. Dr. Yuwadee Wongbundhit Curriculum and Instruction. Data Coach Training Goal. To enable data coaches to be effective data users that can assist administrators and teachers to use data to improve teaching and learning. Expectation.

Download Presentation

2012 Data Coach Training – High School Day 1

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


2012 Data Coach Training – High SchoolDay 1

Dr. Yuwadee WongbundhitCurriculum and Instruction


Data Coach Training Goal

To enable data coaches to be effective data users that can assist administrators and teachers to use data to improve teaching and learning.


Expectation

Data Coach will:


Data Rich….Analysis Poor!

It would be very easy to get “analysis paralysis” by spending time pulling data together but not spending time using the data.


Assumptions:

You...


NORMS


Data Coach’s WebsiteHttp://osi.dadeschools.net/datacoach


Day 1 Topics


District-wide Instructional Focus

The District’s Pacing Guides and Instructional Focus Calendars are aligned with the timing and content of the District Interim Assessment, working together to provide both guidelines for instruction and tools for monitoring student progress throughout the year.


Continuous Instructional Improvement System

Create meaningful data for administrators, coaches, and teachers….


http://curriculum.dadeschools.net/schoolperformancereports.asp


http://curriculum.dadeschools.net/schoolperformancereports.asp


http://curriculum.dadeschools.net/schoolperformancereports.asp


Purpose of this Monitoring Tool


Grade 5- Math Sample (Page 1-E)


Grade 8 Reading Sample (Page 1-M)


Algebra I EOC (Page 1-S)


What’s in the Tool


Features


DATA/COM

Five Years Trend

Safe Harbor Est.

Year-at-Glance

Benchmark Report

2012 SIP Goals

NGSSS and

EOC Monitoring Tool

Interim Assessment by subgroup

Baseline

Fall Interim

Winter Interim


NGSSS Benchmarks Monitoring Tools

Link to School Performance Report


Subject Area and Grade Availability


Move or Copy Worksheet (Page 2)

Right click on worksheet tab

Select “Move or Copy

Under To Book: Select the designated file

Select (Move to End)

Select Create a copy

Click OK


Overview of FCAT 2.0 Scores

Link to Understanding FCAT 2.0 Reports, Spring 2011


2011 FCAT 2.0 Scores


2011 FCAT 2.0 Scores

Equivalent Scale Score(100 - 500)

Equivalent Achievement Level(1 to 5)

Equivalent DSS(86 to 3008)

Raw Score

Reading Content Scores

V: Vocabulary

RA: Reading Application

LA: Literary Analysis

IR: Informational Text/Research Process


New FCAT 2.0 MathematicsReporting Categories


Scale Score vs. Developmental Scale Score

G10

G4

G3

100

100

100

500

500

500

Scale Score

86

Developmental Scale Scores

3008

Grade 3

Grade 10


Achievement Levels for the FCAT Reading Equivalent DSS


Achievement Levels for the FCAT Math Equivalent DSS


2011 FCAT 2.0 Scores

2007 NGSSS

1996 SSS

Base scale of FCAT

Base scale of FCAT 2.0

New FCAT 2.0 Scale – 2012:

In January 2012, the new achievement-level cut scores for the FCAT 2.0 will be created for the FCAT 2.0 in reading (G3-10) and mathematics (G3-8).

FCAT 1999

FCAT 2001

FCAT 2.0 2012

FCAT 2002

FCAT 2.0 Equivalent Scores

FCAT 2.0 2011

FCAT 2010


Equipercentile Linking Example

  • The black and green lines represent scores on two different assessments

  • The lines show how the raw score relates to the percentile rank

  • A “black” score of 260 and a “green” score of 340 are both at the 50th percentile rank and are “equivalent”


Reading Reporting Categories Changing


2011 FCAT 2.0 Possible Points Reading Reporting Category

Content Focus


2011 FCAT 2.0 Possible Points, Grades 3-5 Mathematics Reporting Category


FCAT 2.0 Mathematics, Grade 3 - 5


2011 FCAT 2.0 Possible Points, Grades 6-8 Mathematics Reporting Category


FCAT 2.0 Mathematics, Grade 6 - 8


2011 Algebra 1 EOC Scores

Raw Score

Algebra Content Scores

EOC-Scale Scores(20 to 80)

Population Thirds(low, middle, upper)


2011 Algebra EOC Scale Distribution - Statewide

Upper Third

(EOC SS >54)

State: 35% MDCPS: 28%

Lower Third (EOC SS < 46)

State: 32% MDCPS: 40%

  • 210,004 Students tested

  • Average Scale Score is 49.43;

  • Average Raw Score is 21 out of 52(41% Correct)


End-of-Course


Statewide Comparison

Points Earned by Content Area

Test Form

EOC-Scale Score

1

2

3


Algebra End-of-CourseReporting Category


Algebra 1 EOC Scores(Full Animation)

Raw Score

Algebra Content Scores

EOC-Scale Scores(20 to 80)

Achievement Level(1 to 5)


2012 Algebra 1 EOC Scores

Raw Score

Algebra Content Scores

EOC-Scale Scores(20 to 80)

Achievement Level(1 to 5)


T Scores

Average Score


2011 District Algebra EOC Results of % of Students at Statewide Comparison by Thirds

* Does not include small numbers of students in Grade 6 and Adult Education Programs.


2011 Statewide Algebra EOC: Average % Correct by Grade Level


Baseline Assessment Analysis

http://curriculum.dadeschools.net/schoolperformancereports.asp


Protocols for Baseline Assessment


% Proficient Report


Average % Correct Report


% Proficient Report


Average % Correct Report


% Proficient Report


Average % Correct Report


Reading – Grade 3 by Subgroup

Reading – Grade 4 by Subgroup


Reading – Grade 6 by Subgroup


Reading – Grade 9 by Subgroup

Geometry by Subgroup


DATA/COM Questions (Oct. 4-5, 2011)


NGSSS and

EOC Monitoring Tool

Interim Assessment by subgroup

Baseline

Fall Interim

Winter Interim


Subject Area Selection

Elementary

Middle


High Schools Subject Area Selection


2011-2012 Baseline Assessment by Subgroup


Report Layout


Adequate Yearly Progress (AYP) Benchmark


Enrollment Fact


EOC Subject Areas

Algebra 1

Geometry

1206310 - Geometry

1206320 - Geometry Hon.

1206810 - IB Middle Years Program Geometry Hon.

1209820 - Pre-AICE Mathematics 2

  • 1200310 - Algebra 1

  • 1200320 - Algebra 1 Hon.

  • 1200380 - Algebra 1B

  • 1209810 - Pre-AICE Mathematics 1

  • 1200390 - IB Middle Years Program – Algebra 1 Hon.

Biology

  • 2000310 - Biology 1

  • 2000320 - Biology 1 Hon.

  • 2000322 - Pre-AICE Biology

  • 2000430 - Biology Technology

  • 2000800 - Biology 1 PreIB

  • 2000850 - IB Middle Years Program Biology Hon.

  • 2002440 - Integrated Science 3

  • 2002450 - Integrated Science 3 Hon.


What is the difference?


Raw Score Distribution: Grade 3 Math of Fall IA, 2010-11

Proficient at 50% Cutoff

P at 70% Cutoff

67% of Students

36% of Students

Average Score is 17.7 or

Average % Correct of 59


Math


Subgroups Classifications

Multi-Eth.?

ED-Economically DisadvantagedStudents-eligible for free or reduced price lunch.

ELL-Students who are ESOL levels 1-4 and who are NOT the first year LEP students and those who exited the ESOL program within 2 years of the assessment.

(First year LEP students are included in the participation rate for AYP.)

SWDStudents with Disabilities, other than gifted

Total


Baseline Assessment Fact


2011-2012 Baseline Assessment by Subgroup


What did you see? (Independent Work) P3

1. Who are the targeted students? Which grade/sub-group/subject area?

2. What is the overall performance of the targeted group?

3. Which reporting categories are the weakest areas? Which grade/sub-group/subject area?


Digging into Data

Reporting Category Analysis

Benchmark Analysis

Item Analysis

Identified Students


Benchmark Analysis Report


Selection of School Report

List of Schools

http://curriculum.dadeschools.net/schoolperformancereports.asp


Selection of School Report

School and Subject Selection

Step 1. Select a school from the drop down list below.

List of Schools

Grade 8

Grade 7

School Performance Reports

Grade 6

Mathematics

Benchmark List Description

Grade 8

Grade 7

Grade 6

Step 2. Click on a subject/grade button below to go to that specific sheet.

Grade 8

Grade 7

School Performance Reports

Grade 6

Reading

Benchmark List Description

Grade 8

Grade 7

Grade 6

N/A

N/A

Grade 8

School Performance Reports

Science

Benchmark List Description

Grade 8

N/A

N/A

http://curriculum.dadeschools.net/schoolperformancereports.asp


Selection of School Report

List of Schools

http://curriculum.dadeschools.net/schoolperformancereports.asp


Benchmark Analysis Report


Math

Reading


Benchmark Analysis


Dig Deeper into Data


Edusoft Reports for Data Analysis


Item Analysis Report


Item Analysis Report, Grade 5 Math


Item Analysis Report, Grade 5 Math


Item Analysis Report, Grade 5 Math


Item Response Report


Item Response Analysis


Protocols for Baseline/Interim Assessment (P6)


Essential Questions


Essential Questions


Tips for Analyzing Data

  • Formulate key questions

  • Obtain data to answer them

  • Find the storyline to bring it all together

  • Determine priority areas for action

  • Share the data with the staff

  • Seek technical assistance if needed

  • Celebrate your achievement results!

  • Use the data to communicate, inform, provoke, and persuade ... and

  • ImproveYour System!


Basic Data Tools

  • “disaggregated”

  • “longitudinal”

  • “cross-tabulated”

Do you have …

… data?

… for digging beneath the averages!


The secret of data analysis is

pattern recognition.

Peter Holly

(Personal communication, Ames, Iowa, 1992)


Answer These Questions?

1


Guiding Questions to Inform the Problem-Solving Process


2010-2012 Ideal Data File


Student Data Sources

PMRN – Progress Monitoring Reporting Network


Student Master File

Student ID

Student ID

Student ID

Student ID

“Student ID” is used as a lookup value to merge the data from different files using Excel formula “V-Lookup”

=VLOOKUP(LOOKUP_VALUE, TABLE_ARRAY, COLUMN INDEX NUMBER, FALSE)


Accountability Reports on Principal Portal


Other Reports on Principal Portal


Accountability Reports on Principal Portal


Accountability Reports on Principal Portal


Principal Accountability Report

School

Grade

Export Data

Print

View Report


Accountability Report Data Elements


Insert Pivot Table for Data Analysis (P7)

Click on Cell A2

On main menu, select “Insert”

Click on “Pivot Table” then select “Pivot Table”

Create Pivot Table will appear.

Check Table/Range to make sure it is correct. Then click OK.

Pivot Table appear with Pivot Table Field List.

1


Continued (P8)

  • 1. Click A3 and select “Options” under “PivotTable Tools”.

  • 2. Next click on “Options” under . PivotTable Name. Next, select “Options” under “PivotTable Tools”.

  • 3. Select “Display” Tab

  • 4. Check on Classic Pivot Table layout


Answer These Questions?

1


Using Pivot Table to Create the following tables


SPI School Data Elements

  • CLASS_SCHOOL

  • STUDENT_NAME

  • STUDENT_ID

  • STUDENT_STATUS_CODE

  • GENDER

  • STUDENT_ETHNICITY

  • STUDENT_GRADE

  • STUDENT_HOMEROOM

  • LEP_Entry_Date

  • LUNCH_CODE

  • Birthdate

  • ESE_INFO

  • LEP_INFO

  • FCAT_CURR_GROUP

  • FCAT_TEST_YEAR

  • FCAT_TEST_MONTH

  • FCAT_GRADE

  • FCAT_NRT_MATH_SCALE

  • FCAT_NRT_MATH_PERCENT

  • FCAT_NRT_MATH_STANINE

  • FCAT_NRT_READ_SCALE

  • FCAT_NRT_READ_PERCENT

  • FCAT_NRT_READ_STANINE

  • FCAT_SSS_MATH_SCORE

  • FCAT_SSS_MATH_LEVEL

  • FCAT_SSS_MATH_DEVELOP

  • FCAT_SSS_MATH_NS (Rpt. Cat. 1)

  • FCAT_SSS_MATH_M (Rpt. Cat. 2)

  • FCAT_SSS_MATH_GS (Rpt. Cat. 3)

  • FCAT_SSS_MATH_AT (Rpt. Cat. 4)

  • FCAT_SSS_MATH_DA

  • FCAT_SSS_READ_SCORE

  • FCAT_SSS_READ_LEVEL

  • FCAT_SSS_READ_DEVELOP

  • FCAT_SSS_READ_WP (Rpt. Cat 1)

  • FCAT_SSS_READ_MIP (Rpt. Cat 2)

  • FCAT_SSS_READ_C (Rpt. Cat 3)

  • FCAT_SSS_READ_RR (Rpt. Cat 4)

  • FCAT_SSS_SCI_SCORE

  • FCAT_SSS_SCI_LEVEL

  • FCAT_SSS_SCI_PC

  • FCAT_SSS_SCI_ES

  • FCAT_SSS_SCI_LE

  • FCAT_SSS_SCI_ST

  • FCAT_SSS_WRITE_PT

  • FCAT_SSS_WRITE_SCORE

  • FCAT_READ_PASS_FAIL

  • FCAT_MATH_PASS_FAIL


Student Performance Indicators (SPI)


Instruction for Acct-SPI Templates


File Download Manager

Demographic

Class

Academic

Download File

ESE

ESOL

Testing


File Download Manager


Algebra Baseline Student File from Edusoft


Algebra Baseline Student File from Edusoft


VLOOKUP FUNCTION

=VLOOKUP(LOOKUP_VALUE, TABLE_ARRAY, COLUMN INDEX NUMBER, FALSE)

Lookup_Value:

What value are you searching for?

Excel will look for a match to this value in the leftmost column of the lookup table

Table_Array:

Where do you want to search?

Use absolute references to “lock” the range by pressing F4 key

Col_index_num

Which column contains the search result?

Count over from the first column to figure out what this number should be, starting with 1.

FALSE

To force Excel to lookup value be exact match

=VLOOKUP($A3,'ALG BL'!$B$13:$O$739,3,FALSE)


  • Login