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.
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.
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.
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.
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.
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.
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.
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.
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.
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.