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

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.

GCCS Data Analysis Kit: Work Process Step 1 of 5

GCCS Data Analysis Kit: Work Process Step 1 of 5

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.

Read More

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

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.

GCCS Data Analysis Kit: Work Process Step 2 of 5

GCCS Data Analysis Kit: Work Process Step 2 of 5

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.

Read More

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

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.

GCCS Data Analysis Kit: Work Process Step 3 of 5

GCCS Data Analysis Kit: Work Process Step 3 of 5

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.

Read More

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

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.

GCCS Data Analysis Kit: Work Process Step 4 of 5

GCCS Data Analysis Kit: Work Process Step 4 of 5

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.

Read More

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

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.

GCCS Data Analysis Kit: Work Process Step 5 of 5

GCCS Data Analysis Kit: Work Process Step 5 of 5

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.

Read More