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

Sunday, July 14, 2013

Big Ideas About Data Analysis: Provost Academy Georgia's Data Management Team

By Derrick Brown (follow on Twitter @dbrowndbrown)

Provost Academy Georgia's Data Management Team

During the 2012-2013 school year, KnowledgeBase helped Provost Academy Georgia (PAGA) (an online Georgia state-chartered special school (SCSS)) organize and launch its data management team by hosting two workshops.

Workshop 1: Data Management Team Planning Session

Goal: To establish a culture of effective data use at PAGA.

Approach: Using a SWOT (Strengths, Weaknesses, Opportunities, Threats) analysis technique, we created a “pin-point”, “ten-point” set of SMART (Specific, Measurable, Achievable, Relevant, and Timely) PAGA data use strategies that could be implemented during the Spring 2013 semester.

We generated the strategies by considering the following …

1. Uses (What will we use data to do?)
2. Inventory (What do we need / have, and how well can it be analyzed?)
3. Sources (What can we access, and from whom can we access it?)
4. Calendar (When, how, and how often can we access new data?)
5. Skills (What do we need to learn in order to efficiently analyze and report?)
6. Drills (What should we consistently review, and how often?)

Workshop 2: Skills & Drills: Building Pivot Tables Using Microsoft Excel

A key workshop 1 strategy was to have the entire PAGA Data Management Team learn to build Micorosft Excel Pivot Tables (concise data summaries built using a "drag & drop" approach).

We delivered a customized "skills and drills" training session to 4 members of the team that used the following "disaggregated" data set ...

 ... to produce the following Pivot Table ...

Team members were then challenged to build their "skill" by completing a "drill" that involved using progressively larger versions of the dataset above.

Using larger data sets helps to build a user's appreciation for the accuracy, efficiency, and simplicity with which Pivot Tables are constructed - no matter how much data needs to be summarized!

To probe further, please check out the tutorial video below that summarizes Workshop 2 ...

Unable to display content. Adobe Flash is required.


Derrick Brown – Principal Consultant

Email:  derrick.s.brown@att.net

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.