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

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


  • 95 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 school day 1

2012 Data Coach Training – High SchoolDay 1

Dr. Yuwadee WongbundhitCurriculum and Instruction


Data coach training goal

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

Expectation

Data Coach will:


Data rich analysis poor

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

Assumptions:

You...


Norms

NORMS


Data coach s website http osi dadeschools net datacoach

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


Day 1 topics

Day 1 Topics


2012 data coach training high school day 1

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.


2012 data coach training high school day 1

Continuous Instructional Improvement System

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


2012 data coach training high school day 1

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


2012 data coach training high school day 1

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


2012 data coach training high school day 1

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


Purpose of this monitoring tool

Purpose of this Monitoring Tool


Grade 5 math sample page 1 e

Grade 5- Math Sample (Page 1-E)


Grade 8 reading sample page 1 m

Grade 8 Reading Sample (Page 1-M)


Algebra i eoc page 1 s

Algebra I EOC (Page 1-S)


What s in the tool

What’s in the Tool


Features

Features


2012 data coach training high school day 1

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

NGSSS Benchmarks Monitoring Tools

Link to School Performance Report


Subject area and grade availability

Subject Area and Grade Availability


Move or copy worksheet page 2

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


2012 data coach training high school day 1

Overview of FCAT 2.0 Scores

Link to Understanding FCAT 2.0 Reports, Spring 2011


2012 data coach training high school day 1

2011 FCAT 2.0 Scores


2012 data coach training high school day 1

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 mathematics reporting categories

New FCAT 2.0 MathematicsReporting Categories


2012 data coach training high school day 1

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


2012 data coach training high school day 1

Achievement Levels for the FCAT Reading Equivalent DSS


2012 data coach training high school day 1

Achievement Levels for the FCAT Math Equivalent DSS


2012 data coach training high school day 1

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

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

Reading Reporting Categories Changing


2011 fcat 2 0 possible points reading reporting category

2011 FCAT 2.0 Possible Points Reading Reporting Category

Content Focus


2011 fcat 2 0 possible points grades 3 5 mathematics reporting category

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


Fcat 2 0 mathematics grade 3 5

FCAT 2.0 Mathematics, Grade 3 - 5


2011 fcat 2 0 possible points grades 6 8 mathematics reporting category

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


Fcat 2 0 mathematics grade 6 8

FCAT 2.0 Mathematics, Grade 6 - 8


2012 data coach training high school day 1

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

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

End-of-Course


2012 data coach training high school day 1

Statewide Comparison

Points Earned by Content Area

Test Form

EOC-Scale Score

1

2

3


Algebra end of course reporting category

Algebra End-of-CourseReporting Category


2012 data coach training high school day 1

Algebra 1 EOC Scores(Full Animation)

Raw Score

Algebra Content Scores

EOC-Scale Scores(20 to 80)

Achievement Level(1 to 5)


2012 data coach training high school day 1

2012 Algebra 1 EOC Scores

Raw Score

Algebra Content Scores

EOC-Scale Scores(20 to 80)

Achievement Level(1 to 5)


T scores

T Scores

Average Score


2011 district algebra eoc results of of students at statewide comparison by thirds

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

2011 Statewide Algebra EOC: Average % Correct by Grade Level


Baseline assessment analysis

Baseline Assessment Analysis

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


Protocols for baseline assessment

Protocols for Baseline Assessment


2012 data coach training high school day 1

% Proficient Report


2012 data coach training high school day 1

Average % Correct Report


2012 data coach training high school day 1

% Proficient Report


2012 data coach training high school day 1

Average % Correct Report


2012 data coach training high school day 1

% Proficient Report


2012 data coach training high school day 1

Average % Correct Report


2012 data coach training high school day 1

Reading – Grade 3 by Subgroup

Reading – Grade 4 by Subgroup


2012 data coach training high school day 1

Reading – Grade 6 by Subgroup


2012 data coach training high school day 1

Reading – Grade 9 by Subgroup

Geometry by Subgroup


Data com questions oct 4 5 2011

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


2012 data coach training high school day 1

NGSSS and

EOC Monitoring Tool

Interim Assessment by subgroup

Baseline

Fall Interim

Winter Interim


Subject area selection

Subject Area Selection

Elementary

Middle


High schools subject area selection

High Schools Subject Area Selection


2012 data coach training high school day 1

2011-2012 Baseline Assessment by Subgroup


Report layout

Report Layout


2012 data coach training high school day 1

Adequate Yearly Progress (AYP) Benchmark


Enrollment fact

Enrollment Fact


Eoc subject areas

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.


2012 data coach training high school day 1

What is the difference?


2012 data coach training high school day 1

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


2012 data coach training high school day 1

Math


2012 data coach training high school day 1

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

Baseline Assessment Fact


2012 data coach training high school day 1

2011-2012 Baseline Assessment by Subgroup


What did you see independent work p3

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

Digging into Data

Reporting Category Analysis

Benchmark Analysis

Item Analysis

Identified Students


Benchmark analysis report

Benchmark Analysis Report


2012 data coach training high school day 1

Selection of School Report

List of Schools

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


2012 data coach training high school day 1

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


2012 data coach training high school day 1

Selection of School Report

List of Schools

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


Benchmark analysis report1

Benchmark Analysis Report


2012 data coach training high school day 1

Math

Reading


Benchmark analysis

Benchmark Analysis


Dig deeper into data

Dig Deeper into Data


Edusoft reports for data analysis

Edusoft Reports for Data Analysis


Item analysis report

Item Analysis Report


Item analysis report grade 5 math

Item Analysis Report, Grade 5 Math


Item analysis report grade 5 math1

Item Analysis Report, Grade 5 Math


Item analysis report grade 5 math2

Item Analysis Report, Grade 5 Math


Item response report

Item Response Report


Item response analysis

Item Response Analysis


Protocols for baseline interim assessment p6

Protocols for Baseline/Interim Assessment (P6)


2012 data coach training high school day 1

Essential Questions


2012 data coach training high school day 1

Essential Questions


Tips for analyzing data

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

Basic Data Tools

  • “disaggregated”

  • “longitudinal”

  • “cross-tabulated”

Do you have …

… data?

… for digging beneath the averages!


2012 data coach training high school day 1

The secret of data analysis is

pattern recognition.

Peter Holly

(Personal communication, Ames, Iowa, 1992)


Answer these questions

Answer These Questions?

1


Guiding questions to inform the problem solving process

Guiding Questions to Inform the Problem-Solving Process


2010 2012 ideal data file

2010-2012 Ideal Data File


Student data sources

Student Data Sources

PMRN – Progress Monitoring Reporting Network


Student master file

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

Accountability Reports on Principal Portal


2012 data coach training high school day 1

Other Reports on Principal Portal


2012 data coach training high school day 1

Accountability Reports on Principal Portal


2012 data coach training high school day 1

Accountability Reports on Principal Portal


Principal accountability report

Principal Accountability Report

School

Grade

Export Data

Print

View Report


Accountability report data elements

Accountability Report Data Elements


Insert pivot table for data analysis p7

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

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 questions1

Answer These Questions?

1


Using pivot table to create the following tables

Using Pivot Table to Create the following tables


Spi school data elements

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

Student Performance Indicators (SPI)


Instruction for acct spi templates

Instruction for Acct-SPI Templates


2012 data coach training high school day 1

File Download Manager

Demographic

Class

Academic

Download File

ESE

ESOL

Testing


2012 data coach training high school day 1

File Download Manager


2012 data coach training high school day 1

Algebra Baseline Student File from Edusoft


2012 data coach training high school day 1

Algebra Baseline Student File from Edusoft


Vlookup function

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