CYCLES OF LEARNING
  • BLOG
  • ABOUT
  • BOOK
  • TED
  • CURRICULUM
  • CONSULTING
  • EMAIL

When curiosity is sparked...

deep cycles of learning can occur. 

Subscribe

Student Metacognitive Portfolios Using Google Sheets

9/10/2019

 
I have already written during the first week of school about my excitement as I embarked on a paradigm shift in how I, and my students, think about, and record work (grades, activities, reading reflections, etc.). 

Three weeks later my excitement has turned into obsession!

I am SO happy this with new process, that, for a lack of a better, less "buzzy" phrase, it feels as if I am leveraging a Google Sheet template as a "Metacognitive Portfolio". A process that, after years of tinkering, really, actually, forces "thinking about thinking" and curates work effectively.

Not something I read on a blog (like this one) or something I was told to do at a workshop or faculty PD session. 

What I mean is this: Rather than recording grades in our grade book, students keep track of their own progress on standards, while I keep track of progress on a paper sheet, and update quarterly.

BUT in addition to standards tracking, students are tracking ALL of their work in a Google Sheet using sub tabs. 

One tab is for tracking standards performance (autogenerated colors help students reflect reassessment needs). One tab is for links to their activity slides (click here for a previous post about this process). Finally,  one tab is for students to track, in a structured way, reflections on class readings. 

Thus, the three things I grade: standards, activities, and readings, are now curated easily, in one place, for students to not only reflect on performance, but also catalog work.

One place for students to gain awareness of performance, build pride around their body of work, and develop appreciation for their readings curated over the course of the year. 

Simple. No website. Easy. Effective. So far...

Plus, I don't have students coming and asking "what is my grade?". I rather have students asking, "have you graded that yet so I can update to my sheet."

It keeps us both honest in the best possible way. 

MOST IMPORTANTLY, whenever I need to access student work, I go to ONE PLACE to access it ALL! Grades, activities, readings, etc. I love it! 

Less tech. Better tech. 

Click here for the template I pushed out on the first day of class for them to track. They shared it with me, I made a folder of their sheets, and thats it.

I have ALL their work. No folder, just a sheet. I love it! (Can you tell I'm excited??)

See images of the system below, along with an embedded video of me reflecting, in an overly excited way after a day of teaching, on the process. (Note: this might not be life changing to any of you, but I have to share it. Simpler=Better IMO. I have tried so many things and this...this my friends...is something I'm truly pumped about!." 

It's like REFLECTIVE PRACTICE CHRISTMAS or something. :) 
​

Comments are closed.
    Picture
    Ramsey Musallam is a full-time science teacher in Santa Rosa California.
    Starter Pack

    RSS Feed

    Categories

    All
    3-Bullet Thursdays
    5E
    5E/Hero's Journey
    Apple Tv
    Arduino
    Assessment
    Assistive Technology
    Biology
    CAD
    Chemistry
    Clips
    Cognition
    Commencement
    Commentary
    Consulting
    Courses
    COVID 19
    COVID-19
    Curiosity
    Design
    Distance Learning
    Engineering
    Feynman
    Flipped Learning
    Friday 5
    Google
    Hack Series
    Hands-On
    Hero's Journey
    Inquiry
    Invention
    Itm
    Lecture
    Maker
    Masterclass
    Megacognition
    Misc.
    Models
    Movies
    Online Teaching
    PBL
    Pd
    Physics
    Podcast
    Presentation
    Presentations
    Products
    Programming
    Public
    Reflection
    Research
    Robotics
    Rubrics
    Science Camp
    Slides
    STEM
    Technology
    Tutorials
    Videos
    What If
    Workshop Materials
    Zoom

    Archives

    January 2023
    March 2022
    January 2022
    August 2021
    June 2021
    March 2021
    February 2021
    December 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    March 2018
    February 2018
    January 2018
    December 2017
    September 2017
    August 2017
    July 2017
    June 2017
    February 2017
    January 2017
    October 2016
    September 2016
    July 2016
    June 2016
    April 2016
    March 2016
    October 2015
    September 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    October 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    January 2014
    November 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    March 2013
    February 2013
    January 2013
    December 2012
    November 2012
    October 2012
    September 2012
    August 2012
    July 2012
    June 2012
    April 2012
    March 2012
    February 2012
    January 2012
    December 2011
    November 2011
    October 2011
    September 2011
    July 2011
    November 2010

  • BLOG
  • ABOUT
  • BOOK
  • TED
  • CURRICULUM
  • CONSULTING
  • EMAIL