Using Google Docs for Classroom Management and Supporting Student Subgroups

Mark Wagner, Ph.D.

Yes, free online tools can help with classroom management. Learn how you can move many of your management tasks online – and how you can help improve the classroom environment (and student behavior) by extending and building the classroom community online. Collaborative tools such as Google Docs (and others) make this possible. This session will also focus on the use of Google Docs to support at-risk students, including special education students, English Language Learners, and others that directly affect your API. Learn strategies for differentiating instruction, documenting student learning, providing scaffolding with templates, and implementing frequent formative assessments (with immediate feedback) – plus much more. This one tool can be invaluable for your support of at-risk students.


Agenda


Welcome Activity
  • Are you using Google Docs?
  • Could you explain Google Docs to a colleague?
  • Are you using Google Docs for classroom management and supporting student subgroups?


Proof-of-Concept Projects
  • Follow along with the examples below... keep an eye out for something that you might actually want to use.
  • Create a document, presentation, spreadsheet, or form that illustrates the answer to one of the questions below:
    • How can Google Docs be used for classroom management?
    • How can Google Docs be used to support student subgroups?
    • How can Google Docs help my students (or my staff)?
  • TIP: Consider starting with one of the templates shared below - and then customizing it to your needs!
  • Share the document with: markdwagner@gmail.com
  • We'll share projects at the end of the session (time permitting).


Introduction to Google Docs

Please see the outline for the previous session!


How can Features of Google Docs be used for classroom management?

Manage Student Work and Group Work (or Behavior Data)
Manage Assessments and Assessment Data

Bonus: Create a student interest form to start class. (Via Elizabeth Calhoon)


Sample Uses of Google Docs for Classroom Management (Templates)

Manage Student Behavior and Behavior Data
Manage Student Work and Group Work
Manage Assessments and Assessment Data


How can Features of Google Docs be used to support student subgroups?

Differentiated Learning
  • Sharing One-to-one with Teacher OR Collaborative Group Work
  • Creating Inquiry-Driven and/or Project-Based Assignments (See examples below... )
Document Student Learning (Process and Progress)
Scaffolding
Frequent Formative Assessments
ePortfolios


Sample Uses of Google Docs to Support Student Subgroups (From Student & Teacher Templates)

ELD Lesson Plan Template
Special Education Meeting Reflections
SST Follow Up Form
RtI assessment data e-portfolio template
RtI Log
Research Paper Template
Physics Lab Template
More from Todd Roth...
Search ALL Student and Teacher Templates...
Bonus: Scantron Template (For frequent assessment and feedback.)


More Specific Examples of Google Docs for Project-Based Learning (from Google Certified Teachers)

Examples from GCT Sallie Hill
Example from GCT Thomas Cooper
  • Vernal Ponds project uses Google Docs. Students collect data on the vernal
    ponds around their school over a period of time, and then use Google forms
    and spreadsheets to upload and share the data between student groups, and
    then docs to collaboratively create data charts and write reports.
    http://sites.google.com/site/vernalpondsproject/
Example from GCT Nic Finnelli
  • A first-year teacher at one of my elementary schools has just jumped on
    board with Google Docs and is trying this with her class. Students in
    specific reading groups are to read their chosen WWII historical fiction
    book (each group was given a different choice of books within their reading
    level), work together to make a presentation about the book. They are to
    include the following: book title and author, short summary of the text,at
    least one multimedia file (video, pictures, audio, etc.), what you
    learned about World War II when reading the text, whether or not you would
    recommend this book to others and why
    She just started this on Monday, but it is neat to see things in action and
    the process. This is definitely a work in progress.
    Her school site with directions and links to docs made by students
    http://www.lex5.k12.sc.us/webpages/bkendrick/ela.cfm?subpage=48923
New Examples from GCT Angela O'Dowd


Using Google Forms for Peer-Assessment (For Frequent Assessment with Immediate Feedback)

Example from GCT Katie Morrow
  • Providing authentic assessment in project based classrooms is challenging. Google forms has allowed for the self and peer evaluation process to be much smoother, faster to tabulate, and has provided much more authentic feedback to all students involved in the learning projects. In addition I have found that when I use a google form for peer assessment, that the students' NEXT projects improve by leaps and bounds as opposed to just receiving feedback from me (it seems the kids listen better to their peers than their teacher!) Here are a couple of examples.
  • First the form is created with the assessment criteria
  • Then the link to the form is shared with students (I personally love how easy it is to embed within an iWeb site). Google Apps for Ed allows me to share with the entire domain at once, also.
  • Students submit their peer and/or self assessments and refresh their page before the next presentation
  • After the results are tabulated in the Google spreadsheet, I sort by student name and add an average formula if I need a numerical grade. The most valuable part, however, is sharing the honest, anonymous feedback with the students who created each project-- either digitally or just printed on paper and cut apart.


BONUS: Create a self-grading quiz! (For Frequent Assessment with Immediate Feedback)

Create a form with a small number of quiz questions.
Create an IF formula for each question to "grade" the question. (Each IF formula needs to be in a new column - to the right of the form data.)
Fill Down so that the IF formulas you've written can "grade" all the responses at once! (After responses have been submitted!)
Advanced: Create a SUM formula to total up the total score for each person that took the quiz. Then create another formula to calculate the percentage. Advanced: Finally, create a nested IF formula to convert the percentages to letter grades!


Additional Google Docs Resources

Google Docs at the Google Teacher Academy (from GCT Erica Hartman)
Googe Docs at the Google Teacher Academy (from GCT Lainie McGann)
Googe Docs at the Google Teacher Academy for Administrators (from GCT Sarah Rolle)
Google Docs at CUE's Google Workshop for Educators (from many GCTs, including Cory Pavicich)
Google Docs at CUE's Google Workshop for Administrators (from many GCTs, including Mark Wagner and Kyle Brumbaugh)


Proof-of-Concept Projects
  • Follow along with the examples below... keep an eye out for something that you might actually want to use.
  • Create a document, presentation, spreadsheet, or form that illustrates the answer to one of the questions below:
    • How can Google Docs be used for classroom management?
    • How can Google Docs be used to support student subgroups?
    • How can Google Docs help my students (or my staff)?
  • Share the document with: markdwagner@gmail.com
  • We'll share projects at the end of the session (time permitting).


Reflection Activity

What is one thing you want to implement soon?
What is one thing you want to implement someday?


Online Evaluation (A Google Form!)