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

Tuesday, September 20, 2011

EDW – New & Improved

By now you have probably noticed a new EDW available in the security portal, along with the older version you know so well. DESE released this newer version (EDW v3.0) over the summer, and it is fast! Reports are easier to find, and require fewer clicks to run. If you had access to the old version, you automatically now have access to both. Here are a few key points:
  • There are three main tabs: 1) Assessment – District, 2) Assessment – School, and 3) Assessment – Student.  Each tab has only the reports available at that level. Within the tab, the reports are grouped under categories, such as Item Analysis, Achievement Analysis, etc. Each tab also includes an explanatory table that maps the new reports to the older versions.
  • Student reports run in mere seconds, so it is no longer necessary to set them up to run in the background or overnight.
  • The prompt selections (e.g. ELA, 2011, grade 5) are located directly on the report, allowing you to easily change the selections and run the report again.
  • Reports open in a new tab or window (depending on your browser). You’ll need to get used to closing a report window, or clicking another tab to get back to the report list, but it's nice to be able to have multiple reports (tabs/windows) open at once.
  • MEPA student rosters are available.
There are three particular reasons for which you may want to revisit the old EDW:
  1. Any report views you may have saved in the old EDW are not available in the new EDW. You will need to create new report views and personal folders (using same steps as in the old EDW). You may want to go back to the old EDW to review what you had and how you set up the folder structure. 
  2. There are some reports that are still under development for EDW 3.0, including some multi-year reports and the R-616 Test Item Analysis Roster (which allows you to create a customized roster for any group of students). In addition, the Item reports in the new system are sorted only by item number, not by % correct, or strand, or the other options available in the old EDW. 
  3. The cubes are not yet available in the new EDW.

For more information, please see the following support documents from DESE:
The GBDSAC will be offering EDW workshops in October and November. More details will be posted soon. Meanwhile, take a peak and let me know what you think!