Data => Information => Knowledge Using Microsoft Excel
During the 2012-2013 school year, KnowledgeBase helped Heritage Prep Academy (HPA) (a Georgia state-chartered special school (SCSS)) analyze and synthesize results from the Northwest Evaluation Association's (NWEA's) Measures of Academic Progress® (MAP) assessment.
MAP is a set of computerized adaptive assessments that provide detailed, individualized, actionable performance data about each student's unique academic progress.
We quickly and efficiently converted a mountainous volume of results from HPA's Fall, Winter, and Spring MAP administrations into comprehensive, readable summaries using Microsoft Excel Pivot Tables ...
Table 2. Grade-Level CRCT Proficiency Projections (By Teacher)
Table 3. Goals Summary (By Testing Strands)
After each quarterly MAP administration, we presented these summaries to HPA's academic stakeholders to help synthesize the results into thoughtful, simple, strategic schoolwide interventions. The success of each quarter's intervention was then measured using results from the subsequent quarterly administration.
The ultimate success of this approach will be measured by HPA's performance on the 2013 Criterion-Referenced Competency Tests (CRCT). Stay tuned for those results!
UPDATE (AUGUST 30, 2013)
The
early success of the DVC’s work was validated by HPA's performance on the 2013
Criterion-Referenced Competency Tests (CRCT). The school’s overall performance
improved by a total of more than 71 points. This was the 8th-best one-year
improvement in the state of Georgia on the CRCT!Sincerely,
Derrick Brown – Principal Consultant
KnowledgeBase
About KnowledgeBase
Copyright © 2013 Derrick Brown. All Rights Reserved.