Thursday, December 22, 2011

Creating Student Growth Rosters for Instructional Groups

If you would like to create an MCAS student roster report with growth data for a selected group of students (e.g. classroom, course, intervention group), you can do so in the MA Education Data Warehouse (EDW). The G-602 Student Growth Roster, in the older EDW, provides three years of MCAS performance data (scaled score) and the most recent student growth percentile (SGP) for each student for both Mathematics and ELA. The report also provides a median SGP for the group, if there are 20 or more students with SGPs in the group.

I collaborated with my Southeast DSAC colleague to develop this guide to explain how to create these rosters using an external student list with SASIDs. Here's a quote from a happy Southeast DSAC customer: 
"Our secretary was able to get 3 years instructional groups for me with state IDs. The reports are soooooo easy to do and save!!! You saved me tons of time. I am very excited."

If you'd like assistance with this, please contact me at paula.osullivan@dsacma.org.

Happy Holidays, and Happy Rostering!



Wednesday, December 14, 2011

MCAS Trend Data by Strand and Topic Available in EDW Cube Views

If you want to explore MCAS results by strand and/or topic, there are two relevant cube views available in the old/legacy EDW (the Data Warehouse listed first in the security portal). You can find them by navigating to Public Folders >ESE Cubes >Starting Points (Cube Views) >Cube Views Contributed by District Users.

The first, MCAS % Correct by Strand and Topic Trend 2011 PGO, presents the percent correct by grade, content area, strand and topic for 2006-2011, for any selected district, school, student group, and includes the gap from the state percent correct. If you filter for a particular group of students (e.g. LEP), the state data represents that group as well. The color coding is set to: Green = 10% points or more above the state, Yellow = 10% to 15% points below the state, and Red = 15% or more below the state. You can change the color-coding criteria and other settings, and save as your own cube view to your own folder or your district/school folder. See my post from exactly one year ago today for details on how to do this and other basic cube information.

The second, MCAS Weighting by Strand and Topic Trend 2011 PGO, presents the weighting each strand and topic had by grade over the same time period. This is useful in conjunction with the first cube to identify priority areas for further exploration.

Please let me know if you find these cube views useful and how you have used the data in your school or district. I will compile responses (anonymous if you'd prefer) and share on the blog!

Tuesday, November 15, 2011

Understanding MCAS Growth Data Workshop

The Greater Boston District and School Assistance Center is offering a two-hour workshop focused on MCAS Growth Data. In the workshop, participants will: 
  • Deepen their understanding of the growth model and how to interpret growth reports,
  • Engage with school/district growth data following a data analysis protocol, and
  • Learn what growth reports are available and where to find them.
PRIOR to attending the workshop, participants are asked to view the following DESE on-line tutorials:
  • Data Warehouse Growth Tutorial 1 – Introduction to Growth (11.5 minutes)
  • Data Warehouse Growth Tutorial 2 - Scatter Plots (9 minutes)
  • Data Warehouse Growth Tutorial 3 – Stacked Bar Charts (6 minutes)
The tutorials can be found at http://www.doe.mass.edu/mcas/growth/ under the header “Growth Reports on the Education Data Warehouse”. The workshop will build on these video tutorials, incorporating any questions that participants may have had in response to the on-line tutorials.  

Cost:                NO COST. Provided by the Greater Boston DSAC.
Date/Time:     Wednesday December 7th, 2011. 10am-12noon.
Location:        Shore Educational Collaborative, 100 Revere Beach Parkway, Chelsea MA 02150.
Presenters:     Paula Girouard O’Sullivan, Lisa Hoang, GBDSAC Data Specialists.
Registration: To register, send an email to Joyce E. Jackson (joyce.jackson@dsacma.org).

Thursday, October 27, 2011

DESE Data Tools Overview 11-07-11

Developed and presented by the Greater Boston District and School Assistance Center, this workshop is designed to support your continuous efforts to effectively use data to improve student learning and achievement.  The workshop will provide a basic overview, in presentation format, of the following data tools offered by DESE:

School & District Profiles and Quick Statewide Reports – The profiles provide a wealth of information, publicly available, and easy to download into Excel.

District Analysis and Review Tool - The DART offers a snapshot of district and school performance, allowing users to easily track select data elements over time, and make sound, meaningful comparisons to the state or to "comparable" organizations.

Education Data Warehouse 3.0 – DESE released a new version of the EDW in summer 2011 that is more user-friendly and much faster. Presenters will review the basic interface and any changes that have been made.

Early Warning Indicator Index - The Early Warning Indicator Index (EWII) assigns students who were enrolled in eighth grade one of five risk levels (Very High Risk, High Risk, Borderline, At Risk, or Low Risk) based on a variety of data. This information is made available to districts to assist local staff in identifying and supporting students in grade 9 who may be at risk of not graduating on time from high school.

District Data Team Toolkit – The District Data Team Toolkit (DDTT) is a set of tools and resources available to districts as they support effective data and inquiry practice.

Cost:                NO COST. Provided by the Greater Boston District and School Assistance Center.

Date/Time:     Monday November 7th, 2011. 9am-11am

Location:        Shore Educational Collaborative, 100 Revere Beach Parkway, Chelsea MA 02150.

Registration: To register, send an email to Joyce E. Jackson (joyce.jackson@dsacma.org).


Monday, October 24, 2011

Updated AP and SAT Data Available in DESE Profiles

DESE has updated the School and District Profiles to include information related to the 2009-2010 AP and SAT exams (the latest available to ESE from the College Board). The following reports are available:
The links above provide the data for all schools/districts in the state. You can also find the data on an individual school/district's profile. You may want to use the DART tool to identify "like" organizations for comparison purposes as you explore this AP and SAT data.

Tuesday, October 11, 2011

DART Updated


The DESE DARTs have been updated to include the 2011 MCAS and Accountability. More information, and the tools themselves, can be found at the DESE DART website. New to DART? See my post from last year to learn the basics of what it is.

If you’d like to learn more about the DARTs and other DESE data tools, please join us on Thurs. Oct 13 at Shore Collaborative for a DESE Data Tools Overview. If this workshop looks interesting, but you can’t attend this Thursday, please let me know. If we have enough interest, we can run the workshop again on a future date.

Tuesday, October 4, 2011

DESE Data Tools Overview

Developed and presented by the Greater Boston District and School Assistance Center, this workshop is designed to support your continuous efforts to effectively use data to improve student learning and achievement.  The workshop will provide a basic overview, in presentation format, of the following data tools offered by DESE:

School & District Profiles and Quick Statewide Reports – The profiles provide a wealth of information, publicly available, and easy to download into Excel.

District Analysis and Review Tool - The DART offers a snapshot of district and school performance, allowing users to easily track select data elements over time, and make sound, meaningful comparisons to the state or to "comparable" organizations.

Education Data Warehouse 3.0 – DESE released a new version of the EDW in summer 2011 that is more user-friendly and much faster. Presenters will review the basic interface and any changes that have been made.

Early Warning Indicator Index - The Early Warning Indicator Index (EWII) assigns students who were enrolled in eighth grade one of five risk levels (Very High Risk, High Risk, Borderline, At Risk, or Low Risk) based on a variety of data. This information is made available to districts to assist local staff in identifying and supporting students in grade 9 who may be at risk of not graduating on time from high school.

District Data Team Toolkit – The District Data Team Toolkit (DDTT) is a set of tools and resources available to districts as they support effective data and inquiry practice.

Cost:                NO COST. Provided by the Greater Boston District and School Assistance Center.

Date/Time:     Thursday October 13th, 2011. 9am-11am

Location:        Shore Educational Collaborative, 100 Revere Beach Parkway, Chelsea MA 02150.

Registration: To register, send an email to Joyce E. Jackson (joyce.jackson@dsacma.org).


Wednesday, September 21, 2011

EDW Fall 2011 Trainings

The Greater Boston District and School Assistance Center is offering the following workshops this fall, focused on the Department of Elementary and Secondary Education’s recently redesigned Education Data Warehouse (EDW). These workshops are designed to support your continuous efforts to effectively use data to improve student learning and achievement. Each workshop will be offered twice.

Introduction to the Education Data Warehouse: This workshop will focus on the basic functionality of the new EDW and explore the various MCAS and MEPA reports available in the tool. The workshop is appropriate for district and school administrators, and grade-level or data team leaders who are NOT familiar with the older EDW. 3 hours.

Education Data Warehouse Advanced: This workshop will build on the Introduction course with a focus on the data cube functionality. A data cube is a “multi-dimensional” view of the data that can be customized in many different ways. Participants will learn how to manipulate the EDW MCS data cubes and save “cube views” for future analysis. 3 hours.

Education Data Warehouse Refresher: This workshop is appropriate for district and school administrators who have attended an EDW Introduction course (or EDW 101, 102, 201) and would like to review the basic functionality of the new EDW and the various reports available in the tool. This workshop will move at a faster pace than the Introduction course. 2 hours.

NOTE: In each workshop, participants will have an opportunity to work with their own school/district data. In order to do so, participants should have a username and password for the DESE Security Portal AND the appropriate security role assigned prior to coming to the workshop.
 
Cost: NO COST. Provided by the Greater Boston District and School Assistance Center.

LocationShore Educational Collaborative, 100 Revere Beach Parkway, Chelsea MA 02150.

Registration: To register, send an email to joyce.jackson@dsacma.org. Each workshop has a “Priority Registration” date for Level 3 Districts. After this date, registration will open to all Greater Boston Districts. See table below for dates.

Workshop
Date/Time
Priority Registration Date for Level 3 Districts
Introduction to the EDW
Tues Oct 4, 9:00-12:00
Fri Sept 23rd
EDW Refresher
Tues Oct 18, 9:00-11:00
Fri Oct 7th
EDW Advanced
Tues Oct 25, 9:00-12:00
Fri Oct 14th
Introduction to the EDW
Tues Nov 1, 9:00-12:00
Fri Oct 21st
EDW Refresher
Tues Nov 15, 9:00-11:00
Fri Nov 4th
EDW Advanced
Tues Nov 29, 9:00-12:00
Fri Nov 18th