Big Ideas About Data Analysis: DataRules (CharterLeader (July 12, 2013))

By Derrick Brown (follow on Twitter @dbrowndbrown)

CharterLeader Seminar (July 12, 2013)

Talk: "DataRules" (17m42s)

KnowledgeBase Principal Consultant Derrick Brown defines "data (facts & figures)", "information (understood data)", "knowledge (actualized information)", and "performance management (converting data to information to knowledge to drive improvement)".

View In New Window

TMTYL

1. Provost Academy (February 6, 2013)
2. Data Roles (July 27, 2013)
3. CharterData SWTO (July 12, 2013)
4. School Improvement Plans & Processes
5. Photo

 Reach - Then Teach

1. Reach - Then Teach  (Workshop)
2. Reach - Then Teach (Book)
3. Change The World (150-Word Commencement Speech) 
4. Talk To Me
5. Using TTM
6. Now You Know - WIWIHK 
7. Now You Know - Money Math
8. Nine Mens' Morris
9. HISTORhYmes
10. Writing Your First Business Plan 
11. TPT Store: http://bitly.com/tpt_db

DataTalk: CRCT Performance Index Honor Roll

KnowledgeBase Principal Consultant Derrick Brown leads a "DataDialogue" to analyze 2013 CRCT results.

1. CRCT Performance Index Honor Roll (Meets & Exceeds) (PDF)
2. CRCT Performance Index Honor Roll (Scale Score) (PDF)
3. CRCT Analysis (2011-2013) (M&E) (XLS)
4. EOCT History
5. "Superset" Card 
6. 2011-2012 Annual Report
7. Data-Driven Dialogue (per Susan Cannon) (PDF)

Demo: GCSA Performance Management Data System (PMDS), Tableau, Microsoft Excel

1. Tableau - CCRPI
2. Tableau - Georgia's Charter Schools 
3. Tableau - Bibb County Voting Example
4. Pivot Table Workbook
5. PMDS - CRCT Example
6. PMDS - CCRPI Example  

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

All 6 members of the CharterLeader cohort learned to build Micorosft Excel Pivot Tables (concise data summaries built using a "drag & drop" approach).

We delivered a customized "skills and drills" training session 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 the workshop ...

View In New Window

Big Ideas About Data Analysis: 2013 CRCT Performance Index Honor Roll

By Derrick Brown (follow on Twitter @dbrowndbrown)

2013 CRCT Performance Index Honor Roll

We have analyzed and synthesized school-level results from Georgia's 2013 Criterion-Referenced Competency Test (CRCT).

The Georgia DOE published results from its system-level analysis on June 25, 2013.


Our Approach

We analyzed all 1800+ Georgia schools whose students took the CRCTs using the following two measures:

Performance Index = Sum of schoolwide "meets & exceeds" rates for each of the 5 CRCTs (English & Language Arts, Math, Reading, Science, and Social Studies)

Gain (Loss) = Sum of the increase (decrease) of schoolwide "meets & exceeds" rates for each CRCT


Data => Information

Several key findings regarding independent startup charter schools emerged from the data ...

Performance Index (Overall)

1. 4 independent startup charter schools ranked among the top 100 schools in Georgia in 2013 CRCT overall performance index (SEE TABLE 1 BELOW):

LAKE OCONEE CHARTER (7)
Museum School Avondale Estates (40)
Fulton Sunshine Charter Elementary (43)
Charles R. Drew Charter School (93)

2. 10 independent startup charter schools ranked among the top 100 schools in Georgia in 2013 CRCT performance index comparison (difference between school's performance index, and the average performance index for other schools in its local comparison district) (SEE TABLE 2 BELOW):

LAKE OCONEE CHARTER (4)
Museum School Avondale Estates (9)
Charles R. Drew Charter School (20)
Neighborhood Charter School (21)
Kipp Strive Academy (29)
DeKalb PATH Academy Charter School (32)
Kindezi (33)
KIPP West Atlanta Young Scholars Academy (42)
DeKalb Academy of Technology and the Environment Charter School (48)
Pataula Academy (74)

One-Year Gain (Overall)

3. 6 independent startup charter schools ranked among the top 100 schools in Georgia in one-year CRCT performance index gain (SEE TABLE 3 BELOW):

Heritage Preparatory Academy School (5)
Lanier Career Academy (17)
KIPP VISION (23)
Georgia Connections Academy (49)
Ivy Preparatory Academy for Girls at Kirkwood (94)

4. 5 independent startup charter schools ranked among the top 50 schools in Georgia in one-year CRCT performance index gain comparison (difference between school's one-year performance index gain, and the average one-year performance index gain for other schools in its local comparison district) (SEE TABLE 4 BELOW):

Heritage Preparatory Academy School (5)
Lanier Career Academy (15)
KIPP VISION (21)
Georgia Connections Academy (35)
Ivy Preparatory Academy for Girls at Kirkwood (44)

Two-Year Gain (Overall)

5. 4 independent startup charter schools ranked among the top 50 schools in Georgia in two-year CRCT performance index gain (SEE TABLE 5 BELOW):

Lanier Career Academy (1)
KIPP VISION (18)
Coweta Charter Academy (24)
Fulton Leadership Academy (28)


6. 4 independent startup charter schools ranked among the top 20 schools in Georgia in two-year CRCT performance index gain comparison (difference between school's two-year performance index gain, and the average two-year performance index gain for other schools in its local comparison district) (SEE TABLE 6 BELOW):

Lanier Career Academy (2)
KIPP VISION (7)
Coweta Charter Academy (11)
Fulton Leadership Academy (13)


The Details

We present detailed independent startup charter school results in several "Top 10" lists below. Reply and let us know what these numbers tell you!

Table 1. Performance Index (Overall)

Table 2. Performance Index (Compared To Local District)

 

Table 3. Total One-Year Performance Index Gain (Loss)

 

Table 4. Total One-Year Performance Index Gain (Loss) (Compared To Local District)

 

Table 5. Total Two-Year Performance Index Gain (Loss)

Table 6. Total Two-Year Performance Index Gain (Loss) (Compared To Local District)

Sincerely,

Derrick Brown – Principal Consultant
KnowledgeBase
Cell:  678.467.1256 | 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.