David White 1/2/21 David White 1/2/21

cmd-002. a data analysis tool that helps teachers deliver targeted instruction.

PROJECT COMPLETED: January 2016

Global Community Charter School Data Analysis Kit | Spreadsheet by David White — **Global Community Charter School Data Analysis Kit** | Spreadsheet by David White

THE STORY OF THIS PROJECT

Stakeholder’s Problem: “We need a way to quickly identify the areas where our students are strong and where they need more support.”

Global Community Charter School (GCCS) is a tuition-free, independent charter school located in New York City. It serves 400 children in Kindergarten through Grade 5. GCCS is committed to inclusiveness and serving all children in its community (Harlem and Washington Heights). The school employs a rigorous, inquiry-based model of education and it has been authorized by International Baccalaureate to offer the IB Primary Years Programme (PYP).

After giving students practice exams and other assessments, GCCS teachers needed to determine specifically what their students’ strengths and weaknesses were. After the tests, they knew that they may need to review or possibly re-teach certain topics. However, it was unclear exactly which topics needed to be reviewed and specifically which students needed extra help to master those skills. To solve this problem, I designed and built a data analysis kit for GCCS. The data tool I built helped teachers quickly identify which topics they needed to re-teach and specifically which students needed help where. The data analysis kit I built saved teachers’ time and it helped them deliver better, more targeted instruction.

Work Process:

Here’s the design process I used to complete this project—

Featured

Case Study 002. GCCS Mock Exam Data Analysis Kit: Step 1

CSY-002, Global Community Charter School

Step 1 - Discovery

My first step was to meet with teachers and instructional coaches to determine specifically what their challenges were and what kind of tools they needed. We looked at the testing schedule and the topics to be covered by each test. We identified that the targets were for each classroom on each test.

CSY-002, Global Community Charter School

Case Study 002. GCCS Mock Exam Data Analysis Kit: Step 2

CSY-002, Global Community Charter School

Step 2 - Sketch

Spreadsheets can often be overwhelming to look at and difficult to use. I wanted to avoid those problems by making the new tool both aesthetically-pleasing and user-friendly. I sketched out what I wanted the tool to look like and how it would function.

CSY-002, Global Community Charter School

Case Study 002. GCCS Mock Exam Data Analysis Kit: Step 3

CSY-002, Global Community Charter School, Microsoft Excel, Google Sheets

Step 3 - Prep Data

The data tool predicted the students’ performance on future exams. In order to accomplish this, I researched past state exams and mapped them to the material on the practice exams.

CSY-002, Global Community Charter School, Microsoft Excel, Google Sheets

Case Study 002. GCCS Mock Exam Data Analysis Kit: Step 4

CSY-002, Global Community Charter School, Microsoft Excel, Google Sheets

Step 4 - Build

To build the tool, I used Microsoft Excel. I chose Excel because it was available to everyone in the organization and it was a tool that staff members were already familiar with and felt comfortable using.

CSY-002, Global Community Charter School, Microsoft Excel, Google Sheets

Case Study 002. GCCS Mock Exam Data Analysis Kit: Step 5

CSY-002, Global Community Charter School, Microsoft Excel, Google Sheets

Step 5 - Publish

I published the finished data kit on the school’s shared drive where all staff members could easily access it. The tool was used by teachers, school leaders and instructional coaches during their weekly meetings and it helped them with lesson planning and organizing small-group instruction.

CSY-002, Global Community Charter School, Microsoft Excel, Google Sheets

Final Results:

View Live Completed Project on Google Sheets [PRIVATE INFO REDACTED]

David White 1/1/21 David White 1/1/21

cmd-001. an online data dashboard for a nonprofit board of trustees.

PROJECT COMPLETED: February 2017

Global Community Charter School Dashboard | Dashboard by David White — **Global Community Charter School Dashboard** | Dashboard by David White

THE STORY OF THIS PROJECT

STAKEHOLDER’S PROBLEM: “We need an easy way to monitor progress and ensure accountability within our organization.”

In accordance with state law, GCCS is governed by a Board of Trustees that oversees the school’s operations to ensure fidelity to its educational mission, fiscal responsibility and compliance with all city, state and federal regulations. In order to accomplish this, the Board must review large volumes of data on a regular basis. To complicate matters, the Board of Trustees’ offices are not located inside the school building itself but rather Board members work off-site in different locations, in some cases, internationally. In order to monitor the school and ensure accountability, the Board of Trustees was in need of a consolidated, up-to-date, reliable and easy-to-use source of data that summarized the state of the school at a glance. To solve this problem, I designed and built an interactive online data dashboard for GCCS.

Work Process:

Here’s the design process I used to complete this project—

Featured

CSY-001, Global Community Charter School

Step 1 - Discovery

To begin the process of creating the dashboard, I met with members of the board and with school leaders. I listened to the concerns they had and the challenges they were facing. I began to form an idea of what information needed to be included in the dashboard and what raw data needed to be gathered.

CSY-001, Global Community Charter School

CSY-001, Global Community Charter School

Step 2 - Sketch

Given the volume of information involved, I felt it was essential to design a display that was clear and easy to read. My strategy here was twofold: 1. Provide a high level overview of each of the main areas of the organization and 2. In each of those areas, provide users with the option to “drill down” to view more detailed information on a topic that is of particular interest to them.

CSY-001, Global Community Charter School

CSY-001, Global Community Charter School, Microsoft Excel

Step 3 - Prep Data

This step was the heavy lift in this project. To complete it, I took the following actions:

I identified exactly what data needed to be displayed.
I identified sources for each of those data points.
I exported that data from school information systems (or requested a data export from an outside source).
I cleaned up and organized the data exports.
I compiled the data into Tableau-ready csv data files.

CSY-001, Global Community Charter School, Microsoft Excel

CSY-001, Global Community Charter School, Tableau

Step 4 - Build

Now we come to the fun part—taking dry, lifeless data files and turning them into vibrant, engaging data visualizations. For this organization’s needs, I felt that Tableau was the best tool for the job.

CSY-001, Global Community Charter School, Tableau

CSY-001, Global Community Charter School, Tableau

Step 5 - Publish

I published the dashboard online using Tableau. Board members and school leaders could access their new dashboard on any computer or mobile device from anywhere in the world. Once the dashboard was in use, I noticed a big change in the way Board meetings were conducted—rather than using the meetings to gather information as they had before, now, since they had up-to-data information constantly available to them through the dashboard, every member arrived at the meeting already conversant in the data. The meetings went from an exercise in simply finding out what’s happening and turned into a forum to discuss why things are happening. Thanks to the dashboard, Board meetings were now more directly focused on finding solutions.

CSY-001, Global Community Charter School, Tableau

Final Results:

View Live Completed Project on Tableau [PRIVATE INFO REDACTED]