Google Classroom | Grading

Google Classroom is a free collaboration tool for teachers and students. Teachers can create an online classroom, invite students to the class then create and distribute assignments. Within the Google Classroom students and teachers can have conversations about the assignments and teachers can track the student’s progress. As COVID-19 swept through the nation, more and more of our schools took to remote learning. Currently, there are no integration features for many Student Information Systems (SIS) & Learning Management Systems (LMS) that teachers across the nation use. This case study is ongoing, and will be updated as it develops.


Step One: The Problem

Assumptions

  • Many K-12 schools are now operating solely online.
  • Google Classroom is used by many districts.
  • 80 million users utilize G Suite for Education (Pre-COVID)
    • 30 million use Google Classroom
  • A potential solution will:
    • Improve productivity
    • Increase ease of use
    • Decrease stress

Risks & Uncertainties

  • Will people leave Google Classroom for our competitors?
  • What if districts won’t buy a Google Classroom/PowerSchool integration?
  • How do we navigate our budget?
  • Who is our market? Who are our users? Who are the decision makers? Who are the buyers?
  • Will PowerSchool exist in a few years? If Google Classroom changes the API, will the integration continue?

Step Two: Target Market

Market Research

Using TrustRadius, we’ve developed a competitive analysis between Google Classroom & it’s major competitors (PowerSchool Unified Classroom, Canvas, & Blackboard Learn). Looking into some of the key features of Google Classroom, we can see how it compares to the other education platforms. It ranks average among the UI, lower with the support rating, and on the lower end of likelihood to recommend. As far as SIS Integration goes, you can see that there is a significant lack of integration among many of the education platforms.

Google ClassroomPowerSchool Unified ClassroomCanvasBlackboard Learn
User Friendly UI97910
Support Rating7.98.58.87.8
SIS IntegrationInfinite CampusPowerSchoolPowerSchool, Infinite Campus, & OthersPowerSchool
Application IntegrationGoogle DriveOffice 365, Google DriveGoogle Drive, Office 365Office 365, Google Drive
Likelihood to Recommend8.78.59.37.5

User Research

Upon sending out a user survey, we received 22 responses from teachers across the US. From these surveys, we were made aware of 3 main pain points:

  • Feedback – The current feedback feature allows generalized feedback for the document/assignment as a whole, but does not allow for feedback on specific parts.
  • Grading UI – Slow, does not allow for filtering, and there is no way to transfer one student (& their grades) to another teacher or class.
  • SIS Integration – There is no way to integrate with many of the SIS platforms that districts & school systems require for grade reporting.

User Interviews

“….importing grades from Google Classroom to PowerSchool SUCKS! It’s usually easier to type them by hand!”

-US Teacher

“Grades don’t transfer between classes when students transfer so I enter them manually. In the past, I have never received scores from other teachers, so when they transfer from another teacher they start with a grading blank state. So all scores would be exempt from anything previous to their move which could help or hurt the student.”

-US Teacher

User Personas

Teacher Persona
Buyer Persona

Step Three: Product Strategy

DHM Framework

Using the DHM Framework, my team & I worked together to brainstorm some ideas for each of the questions that the DHM Framework asks.

Delight UsersHard-to-CopyMargin-Enhancing
  • Simple, streamlined UI
  • Fast, easy integration
  • Faster way to grade (multiple assignments, auto-grade)
  • Organized UI (labeling, filtering)
  • Google search integration
  • Google Drive accessibility/integration (free)
  • Brand loyalty/market share
  • Increase retention b/c ease of use
  • Increase market share – draw in more customers

High-Level Road Map

Using the DHM Framework answers, we developed a list of potential strategies to implement as the Google Classroom PMs. We also chose a few proxy metrics to measure each of the strategies, and mapped these to a high-level road map.

Now (0-3 mo)Next (next qtr)Later (6+ mo)
Deliver Exceptional UXImprove the UIReduce Churn
Improve the UIParent/Guardian PortalIncrease Market Share
Centralize GradingLabel Options (e.g.,”late assignment”)Integrate with PowerSchool

 Step Four: Solution

Value Proposition

Following some deeper competitive analysis & using the Kano model, we came up with a value proposition for our ideas to improve Google Classroom.

Google Classroom teachers want a simple grading solution. Providing integration with PowerSchool & easy transfer of grades between teachers meets this desire. Google Classroom currently beats the competition except in this area. This solution will keep Google Classroom as a market leader.

Wireframes

Using our value proposition, I sketched out some simple wireframes displaying our potential solutions & feature additions. These include:

  • Way to transfer students between classes
  • Way to transfer student information to SIS
  • UI improvements to filter & toggle views of students
  • Option to exempt student from assignment
  • Option to mark assignment as late
  • Ability to grade with student names hidden
  • Ability to send reminders about missing grades
  • Ability to email guardians of student

After talking it over with my group & discussing what we wanted for our solution, we came up with this idea:

This solution has options to select one, multiple, or all students & then click the export button. The button offers a pop-up with the options to transfer to PowerSchool or to another teacher.

Prototypes

I worked on Figma to prototype out what this solution might look like:

This frame shows toggle options for each student or selecting all, as well as an export button.
Once the export button is pressed, there’s an option to transfer the selected student either within the district or to a CSV file. This shows the within the district option and allows you to select a teacher from the dropdown.
Once the export button is pressed, there’s an option to transfer to PowerSchool.
This shows the exporting to CSV option with the ability to toggle grades and assignments, as well as add in a personal note for the new teacher.

Use Cases & User Stories

Using the prototype and user testing feedback, we came up with a few use cases & user stories that our improvement to Google Classroom would require.

Use Case #1: Transfer from Google Classroom to PowerSchool
User Story Acceptance Criteria
As a teacher I want to transfer all student grades from Google Classroom to PowerSchool.
  • Select all students from course
  • Option to transfer assignment comments, specific data, etc
  • Transfer to PowerSchool via API
As a teacher I want to transfer one student or assignment from Google Classroom to PowerSchool.
  • Select one student from course
  • Select one assignment from course
  • Option to transfer assignment comments, specific data, etc
  • Transfer to PowerSchool via API
As a teacher I want to transfer specific aggregate data from Google Classroom to PowerSchool.
  • Select one or more students from course
  • Option to transfer grades by semester, quarter, testing average, etc
  • Transfer to PowerSchool via API
Use Case #2: Transfer from Teacher to Teacher
User StoryAcceptance Criteria
As a teacher I want to transfer a student to another teacher so the student can continue their school year without losing their prior work.
  • Select one student from course
  • See a list of available teachers for transfer
  • Require transfer confirmation from receiving teacher
As a teacher I want to receive a student transferred into my class, so I can incorporate their previous grades into the rest of their school year.
  • Receive notification of student transfer
  • Accept or reject transferred student
    Option to transfer in specific grades, assignments, etc.
  • Option to exempt student from any prior assignments
As a teacher I want to move a student from one of my class periods to a different class period in order to meet requirements & maintain their assignments.
  • Select one student from course
  • Select transfer to self
  • List of available periods/classes to transfer to
  • Options to transfer in specific grades, assignments, etc
  • Option to exempt student from any prior assignments
Prioritization

We took the above user stories and evaluated them based on impact, required effort, and our confidence to determine the prioritization.

User StoryTeacher ImpactStudent ImpactEffortConfidenceRank
As a teacher I want to transfer a student to another teacher so the student can continue their school year without losing their prior work.58680%3
As a teacher I want to receive a student transferred into my class, so I can incorporate their previous grades into the rest of their school year.88680%2
As a teacher I want to move a student from one of my class periods to a different class period in order to meet requirements & maintain their assignments.984100%1
As a teacher I want to transfer all student grades from Google Classroom to PowerSchool.94750%4
As a teacher I want to transfer one student or assignment from Google Classroom to PowerSchool.54550%5
As a teacher I want to transfer specific aggregate data from Google Classroom to PowerSchool.63650%6
User Story Mapping

We mapped each of the user stories to their overarching use case, as well as developed tasks for each of our “teams” to get done. Check out our user story mapping below!

To see the user story mapping as a whole, download the pdf below!

Release Planning

Using our story mapping, we determined a release plan working in sprints to get our product out as early as possible. We broke it down into three different release plans:

Dev Release Plan: We started by breaking down our user stories into different sprints in order to give our “team” enough time to work on each user story & meet the acceptance criteria. This also included some administrative planning like securing beta testing schools, marketing, and working with the pricing to determine how these new features would affect the pricing of the Google Classroom Suite.

Beta Testing Plan: This was to verify that our beta testing would go for a certain length of time, specifically the first 9 weeks of the Spring semester in order to ensure our beta testers would be utilizing every aspect of our new features. This plan also includes the start of user research based off of those interactions with our beta testers.

Overall Release Plan: In order to tie all of our planning together, we decided to make an overall release plan that doesn’t go into as much detail as the other two plans. This one includes everything post-beta testing that we believe we need in order to get our product to market.

Last Updated: October 14, 2020

Connect with me!