Data Warehouse Updates

The following information was shared during last week's “EDW User Group” webinar. 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.

Reminders

1. The EDW Team at DESE holds webinars twice a month (1^st Wed at 11am, 3^rd 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. 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??? 

(Thank you to Paula O'Sullivan, Data Specialist for the Greater Boston DSAC, for sharing this summary with me so that I didn't have to re-invent the wheel.)

2012 MCAS Data Now in the EDW Cube

The Education Data Warehouse "cubes" were updated this week to include 2012 data. (Cubes are predefined data tables in the EDW that make on-the-fly data manipulation possible.)

The cubes can be accessed 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. Clicking the link ESE Cubes will open a folder with both the cubes and supporting documentation (a handbook and an up-to-date FAQ). The MCAS Default View cube allows users to start from scratch to analyze data for a particular school or district. The folder Starting Points (Cube Views) provides cube starting points that have 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.

To save a cube view, click the Save As icon in the lower right corner and save it to the 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. 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.

I will offer a regional workshop on using the Data Warehouse cubes if there is enough interest - please email me at laura.tilton@dsacma.org if you're interested in a workshop.