Thursday, December 6, 2012

EDW Updates!

The following information was shared during yesterday’s “EDW User Group” webinar, along with the accompanying slides. See the bottom of this post to learn how you too can be part of the user group and hear this information first-hand!

Additional Data Now Available
With the addition of the 2011-12 End-of-Year Student Course Schedule data and EPIMS data:

1. The Classroom reports now have two years of data available. These reports currently include:
  • Classroom Item Analysis Roster (IT516)                         
  • Classroom Results by Standard (PE506)
  • Performance and Growth by Teacher (PE520)

These reports are only available to users who have been assigned the "DW-Evaluator" role. ESE has developed guidance around assigning this role, available on the "Home" tab within the EDW. 

2. The Student Profile report (PR600) now displays two years of course data for the selected student(s).

Additional Functionality
1. The ability to view your data either by the  “old” MA2004 standards or by the new Common Core standards has been added to the Student Assessment Detail report (PE606) and the Student Item Analysis Roster report (IT616), bringing the total to six EDW reports with this option (the Test Item Analysis Summary reports (IT301/IT401) and the Results by Strand and Topic reports (CU306/CU406) already had this option). This option will soon be added to the Classroom Item Analysis Roster (IT516) and the Classroom Results by Standard report (PE506).

2. The Student Assessment Detail report (PE606), which previously printed one page per student, now has the option for a roster display (list of many students on one page).

3. The Growth Distribution reports (GR302/GR402) now have an option to display multiple years of data for a particular grade level for trend analysis.

1. The EDW Team at DESE holds webinars twice a month (1st Wed at 11am, 3rd Wed at 2pm) to share information regarding new features and data in the EDW. Participants have an opportunity to share comments, questions and/or suggestions. To join the listserve and receive reminders about these webinars, please see the bottom of the EDW home page.

2. The supported browsers for the EDW are Internet Explorer and Firefox. You may experience issues with other browsers, as I did last week when I tried to run the cubes using Google Chrome. See, even I forget sometimes! It is expected that at some point in the future Safari and Chrome will also be supported.

3. The old EDW (v2.6) will be put out to pasture after this month (i.e. no longer available). Is anyone still using the old version???

Friday, November 9, 2012

DART in Profiles!

The folks at ESE have now integrated the DART (District Analysis and Review Tool) into the School and District Profiles. All of the functionality in the DART for Districts and DART for Schools workbooks is now available through your school or district’s profile, on a tab labeled “Analysis – DART”. Comparisons and analyses can be made with respect to enrollment, curriculum/instruction/assessment, achievement gap, and finance/management.

The Excel-based versions of the DARTs are still available, including the DART Detail tools (for ELLs and Staffing/Finance) and were all updated as of October 2012.

Friday, October 26, 2012

2012 Cohort Graduation Rate Data – Ready for Review

Cohort graduation rate data is available for review! The notice below was in the weekly Commisioner's Update from DESE. As you all know, the cohort graduation rate is one of the indicators in the state accountability and assistance system so please, if you are involved in this data, take this opportunity to review the accuracy of the information your district has submitted! It could impact the final rates that are released later this winter.

"ESE has posted 2012 cohort graduation rate data for districts to review and make corrections to individual student data. See "2012 Graduation Rate Reports" on the Security Portal at Aggregate rates have not yet been provided. Corrections will not be accepted through email or over the phone. The only mechanism to make corrections to these data is through the October SIMS submission. The final graduation rates will be made publicly available in January 2013 once the October 2012 SIMS data have been certified and the calculations have been completed. The application can be accessed with a username, password, and the SIMS Data User role. Should you or your staff have any questions on the correction process, please contact your District Support Specialist. A listing of those individuals is located at The deadline to correct these graduation rate data coincides with the October SIMS submission deadline, which is Nov. 15."

Tuesday, October 9, 2012

EWIS Data for Grades 1-12 Now Available

DESE released Early Warning Indicator System (EWIS) data recently for all students in grades 1-12. The EWIS provides information for each student enrolled in grades 1-12 on their likelihood of reaching important education milestones along the academic continuum. There are three risk levels: Low, Moderate, and High. A student that is “low risk” is predicted likely to meet the academic goal(s) for his/her grade grouping.

DESE is offering two more webinars to discuss EWIS (Oct 11th at 8:30 and Oct 18th at 3:00). The webinar will provide an overview of the EWIS, including: how it was developed, key concepts, what it is/ is not, and how to access. Click on this link to register.

All districts have EWIS student-level reports (by grade level) and EWIS overview, Q&A, and district summary documents in the College and Career Readiness Dropbox in the Security Portal. This may be accessed with the district role of College and Career Readiness User. Your district’s Directory Administrator (DA) can assign staff this role. You can find your DA in this list:

Wednesday, October 3, 2012

2012 MCAS in the Cubes and new FAQ

DESE recently updated the EDW MCAS cubes with 2012 data. You can find the cubes from either the District tab or the School tab in the EDW, near the bottom on the left side of the page, under the header “Data Analysis Cube”. If you click the link ESE Cubes, you will open a folder with both the cubes and supporting documentation (a handbook and an up-to-date FAQ). If you want to analyze data for your school or district, you should open the MCAS Default View cube. You could also open the folder “Starting Points (Cube Views)” to see cube views that may meet your needs. A cube view has already been manipulated and saved to present the data in a particular way. The currently available cube views include:
  • MCAS % Correct by Strand and Topic Trend
  • MCAS CPI Trends by Grade Level
  • MCAS Demographic Trends
  • MCAS Performance by Grade Level
  • MCAS Performance by Year
  • MCAS Performance by Gender by Subject
  • MCAS Special Education Performance Gap Trends
  • MCAS Subject, Strand, Topic, Question Type, % Correct compared to State by Subgroup (SPED)
  • MCAS Weighting by Strand and Topic Level

The State MCAS Default View cube is available for training purposes and contains only state-level data.

If you manipulate the cube and would like to save it as your own cube view, you can click the Save As icon in the lower right corner and save it to your My Folders tab or your District Folder. (Don't worry, you can't accidentally overwrite the public cube views.) This is similar to saving Report Views. If you'd like to convert the cube view to PDF for printing/saving outside of the EDW, click the File button in the toolbar at the bottom of the screen (looks like a page) and choose Export PDF. The File button will also allow you to export the data into Excel. 

Thursday, September 20, 2012

2012 MCAS and Accountability Data in Profiles

The 2012 MCAS and Accountability information for Massachusetts public schools and districts is now available through the School and District Profiles page on the ESE Web site. (

The easiest way to find a school or district is by using the "Quick Search" box in the upper left corner of the Profiles page. After clicking the name of the desired school or district, the "Assessment" tab will provide information about MCAS performance and growth for 2012 (as well as prior years). The "Accountability" tab will provide information about the school/district accountability/assistance level and the data behind the PPI calculations.

For detailed information about the calculation of PPI and the new accountability system, please refer to the About the Data page link in the accountability reports as well as the Interpretive Materials, including the School Leader's Guide to the 2012 Accountability Determinations. Of particular value in the Guide are the Level explanations on page 5, and the PPI breakdown on page 10. There is also a downloadable Excel file with the summary accountability information for all schools and districts in the state.

Please let me know if you have questions regarding the data ( Of course you may also contact DESE at or 781-338-3550.

Thursday, September 13, 2012

Accountability Documentation Posted

DESE has posted on the public website several documents that may help you to understand and explain the state accountability system:
  1. School Leader's Guide to the 2012 Accountability Determinations (9/4/12 update)
  2. Summary of Changes to Annual Accountability Determinations as a result of Massachusetts' Approved ESEA/NCLB Flexibility Waiver
  3. District & School Accountability & Assistance Levels & Required Actions
  4. Methodology for Identifying Level 3 Schools, Level 3 "Focus Schools", & Level 4 Schools
  5. Glossary of 2012 Accountability Reporting Terms
As I'm sure you know by now (see last week's post), preliminary data was posted last week, DESE's webinars concluded today, and it is expected that the accountability data will be released to the public next week. Please let me know if you have any questions!

Friday, September 7, 2012

Preliminary Accountability Data Available

DESE released preliminary school and district accountability data via the Department’s Security Portal yesterday. The data include preliminary 2012-13 school and district accountability and assistance levels and Progress and Performance Index (PPI) data for 2009-2012. DESE states “to avoid public dissemination of potentially erroneous and misleading information, please maintain the confidentiality of these data and use them only for internal review and planning purposes”.  The Department anticipates releasing official data in mid-September.

Within the DESE Security Portal, district staff with the security role "Accountability (District Level)" will see a “2012 Accountability Data” application and will have access to all accountability data for their district. School staff with the security role "Accountability (School Level)" will see for their school only. If you need assistance accessing data in the Security Portal, please speak with the Directory Administrator in your district, as he/she is responsible for assigning access. 

Beginning this school year, accountability reporting has changed significantly as a result of Massachusetts' approved ESEA/NCLB flexibility waiver. Detailed documentation related to the accountability reporting is available via each school and district preliminary data page. DESE will also run three webinars next week (Tues. 9/11 at 10am, Wed. 9/12 at 12noon, and Thur. 9/13 at 3pm) to provide an overview of the preliminary accountability data and answer questions.

Friday, August 10, 2012

EDW Updates

The 2012 preliminary Math and Science results are now in the EDW. If you haven’t been in the EDW for awhile, here are a few new things to note:
  • There is an “EDW Home” tab which contains information about recent updates and improvements as well as what's coming soon to the EDW. 
  • All of the reports from the “old” EDW have been migrated to the new EDW 3.0. Please note that although the link is still available from the security portal, the old EDW is no longer being updated and will be retired in October.
  • The Test Item Analysis reports now have the option to map the test items to EITHER the old or new curriculum frameworks for Math and ELA. 
  • There is a "Super" student profile report which provides SIMS, attendance, course, MCAS, and CD status information for any selected student.
  • There are several new classroom-level reports which utilize SCS data for a given instructional group (classroom, course section, etc.) These reports are only available to users who have been assigned the "DW-Evaluator" role. ESE has developed guidance around assigning this role to EDW users which they will post on the EDW home page shortly. (Watch for a more detailed blog post once this guidance document is available online.)
If you feel rusty on maneuvering in the EDW, check out this one-page tip sheet and/or register for an EDW training.

Wednesday, August 8, 2012

EDW Fall 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 Education Data Warehouse (EDW). These workshops are designed to support your continuous efforts to effectively use data to improve student learning and achievement. Additional dates will be added if there is enough interest.

Introduction to the Education Data Warehouse: This workshop will focus on the basic functionality of the 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. 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.

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.

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

Registration: To register, send an email to 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.

Priority Registration Date for Level 3 Districts
Introduction to the EDW
Thurs Sept 27, 9am-Noon
Fri Sept 14th
EDW Advanced
Wed Oct 3, 9am-Noon
Fri Sept 21st
Introduction to the EDW
Tues Oct 16, 9am-Noon
Fri Sept 28th