Learn About KnowledgeBase's Educational Materials Store - Or Start Shopping (Purchase Orders Are Welcome)!

Buy "Follow The Leader" (changED - Volume 2) - The Album / Mixtape!

Buy changED (Volume 1) - The Album / Mixtape!

Subscribe To Our Podcast Via Apple Podcasts | YouTube | Amazon Music | Pandora | Pod Chaser | Podcast Index | Email | Android | RSS

Reach – Then Teach (Character Education Guide)

Character Education Crossword Puzzles (Volume 1)

Common Core Math
Word Problem Of The Day

Writing Your First Business Plan (Writing Project)

(All titles available at our Teachers Pay Teachers store - an online marketplace for educators!)

Tuesday, June 25, 2013

Big Ideas About Data Analysis: Data => Information => Knowledge Using Microsoft Excel

By Derrick Brown (follow on Twitter @dbrowndbrown)

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 1. Grade-Level CRCT Proficiency Projections

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!


Derrick Brown – Principal Consultant

About KnowledgeBase

Please share your thoughts on these "Big Ideas" and best practices by leaving comments below. Follow us on Twitter @dbrowndbrown to submit your own "Big Ideas" and best practices!
Copyright © 2013 Derrick  Brown. All Rights Reserved.

No comments:

Copyright © 2020 Derrick Brown and KnowledgeBase, Inc. All Rights Reserved.