2012 data coach training high school day 1
Download
1 / 130

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


  • 119 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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha

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...



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



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








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



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

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

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



2011 fcat 2 0 possible points grades 6 8 mathematics reporting category
2011 FCAT 2.0 Possible Points, Grades 6-8 Mathematics Reporting Category



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)



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.



Baseline assessment analysis
Baseline Assessment Analysis

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









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 9 by Subgroup

Geometry by Subgroup



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







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

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

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




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



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



2012 data coach training high school day 1

Math

Reading




Edusoft reports for data analysis
Edusoft Reports for Data Analysis











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)





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)






Principal accountability report
Principal Accountability Report

School

Grade

Export Data

Print

View Report



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




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




2012 data coach training high school day 1

File Download Manager

Demographic

Class

Academic

Download File

ESE

ESOL

Testing





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)


ad
  • Login