Computing MAP Predicted Target Growth

In Inform, we annually upload multiple measures for NWEA's Measures of Academic Progress in Reading and in Mathematics. These annual measures are:
  • MAP-Read-05--This represents the fifth grade (represented by the "05") Reading RIT score. This is a Spring assessment entered once annually in late May. These scores are displayed in Inform using the ISBE Performance Levels Proficiency Profile (Exceeds Standards, Meets Standards, Below Standards, and Academic Warning). At the time of this posting, the level at which each score appears is determined by the NWEA Illinois Alignment Study from 2011.
  • MAP-MTRdg-05--This score is whether or not the student has met his or her Target Growth in Reading from 4th grade to 5th grade. Again, the "05" represents fifth grade. "MT" stands for "Met Target." This assessment is uploaded in the Spring following Spring MAP testing and based on the most recent year-to-year growth. If a student has met his or her Target Growth from the previous Spring, the score will be a 1. If he/she has not met Target Growth, the score will be a 0. Only students in third grade or higher who participated in the previous Spring's NWEA MAP assessment will be included in this query.
  • MAP-PTRdg-05--This assessment is loaded in the Fall of the new school year after the previous Spring's MAP assessment. This score is the student's predicted score at the end of the current school year. In other words, this score is derived from the student's RIT score from last Spring with the addition of the student's predicted Target Growth from NWEA. (Previous RIT + Target Growth = Predicted Target RIT Score) The proficiency profile for this assessment is the same one that is used in the Spring, so teachers can begin looking at where students are likely to end the year (though, hopefully, with targeted differentiated lessons within engaging, authentic units, students will surpass these predictions).

So, how do you determine how much growth the student is actually predicted to make by NWEA if you want that information in addition to the student's RIT score from last Spring and the student's predicted RIT score for the MAP assessments that will be administered later this school year?

You can easily access all of these pieces of information by creating the following query in Inform. (You will have to repeat this procedure separately for reading and for math.)

query_computePTG

The above query is written for "current" sixth graders (current in the 2010-2011 school year). Key selections include:
  • Select "" Years
  • Then, select the previous Spring's MAP RIT score (2009-2010--The year prior to 2010-2011)
  • Finally, select the current Fall's MAP Predicted Target RIT score (PT) (2010-2011, the "current" school year)

Now, click the "Create Report" button. The resulting graph will display.

query_showstudents

When the graph appears, click on either bar for the current school year's Predicted Target Growth assessment. Mouse over "Students in >" and select "All categories".

This will display a table with student information (pictured below). Each student will appear in two consecutive rows.

query_studentscorescompute

The scores are on the right side. All you need to do to compute their target growth amount for this year is subtract last year's RIT score (in the rectangle above) from this year's Predicted Target RIT score (in the oval above). The difference is the amount of growth that the student is predicted to show for the current year.