GAFE for Classroom Data

July 10, 2017 No Comments

GAFE for Classroom Data

July 10, 2017 No Comments
Use Google Apps for Education to manage classroom data.  Use Google Sheets to create a data sheet for collecting student data and format it to provide quick analysis. Use share function of Google sheets to collaborate with others, share with team members, administration, and parents.

Am I alone in saying that Google has been a God-send for teachers?  With the rise of the Google empire, we’ve been able to connect, collaborate, engage, and organize like never before.  For those of you that are familiar with Google Apps for Education (GAFE, for short), you know that they can be used to simplify a teacher’s life tremendously.  I use them pretty much exclusively for my classroom needs, including for lesson planning, data collection, data analysis, and collaborating.

This post is designed to give the Google beginner some tips and tricks for using Google in the classroom.  While there are a million ways to use Google with students, I also love utilizing it for my own personal organization and efficiency.  Today, I’m going to explain to you how to use GAFE to collect, analyze, and share student data.

Let’s face it, no one became a teacher because they like to look at data.  Or maybe they LOVED to grade papers as a kid, but quickly realized that the follow-up work as a teacher made it almost unbearable.  The reality is that our jobs are highly tied to data now and rightfully so.  Collection and analysis of data makes it easy for us to track where students are and make plans to accelerate their learning or intervene as necessary.

I personally love using the GAFE suite to collect and analyze data.  I originally started a data sheet on Microsoft Excel but quickly moved it to Google Sheets after realizing that I did not have to be tied to one device in order to access it.  I can pull up my data on my laptop,  a school desktop, a colleague’s computer, or any iPad.  (I will say that I’ve tried to access the GAFE suite on my Kindle Fire and it’s a little more complicated.  I’m not sure about other Android devices.)  I also love that I can share my spreadsheet with anyone. This is especially helpful when we are looking at classroom data in our professional learning community and is great to modify and share with parents.

1.  Collect student data.

I collect student data in a couple of ways.  First, I use it to keep track of the universal screener data we collect in the fall, winter, and spring of every year.  For example, we assess students using the Developmental Spelling Assessment, the Developmental Reading Assessment, and the Test of Word Reading Efficiency three times a year.  This data is all compiled in one Google Sheet.

Use Google Sheets to manage universal screening data given three times a year.

Additionally, my data sheet has essentially taken the place of my grade book and I use it to keep track of weekly formative assessment data. My data sheet is set up very much like a standard grade book, with the name of the student going down the left side and the assessments going across the top.  The biggest difference is that each of the assessments are grouped by standard so that I can easily track progression within the standard.

2.  Analyze student data.

Once the data is collected, this sheet becomes my life.  It’s very simple to format the data so that it tells a story about each student, as well as your teaching.  Below are a few ways I format my data sheet to help tell the story of our classroom:

  • Color coding – I use red for novice, yellow for apprentice, green for proficient, and blue or purple for distinguished.  This is my favorite part of the data analysis because I can easily see who is performing at grade level and who needs interventions after every assessment.  You can easily do this by selecting the data, choose Format at the top, and then select Conditional Formatting.  From there, you can set the formatting for each cell based on a simple “If.. Then” statement.
  • Class averages – I can look at a glance to see how to entire class performed on the assessment.  This gives me a clue into my effectiveness of teaching.  When I have a bad week, the data shows.  You can calculate averages by selecting a row or column of data, then clicking the Functions (pointy E) button and selecting “SUM.
  • Standard average – This is my way to evaluating student progress toward the standard.  While we don’t use standards based grading (yet), this is a great way for me to plan small groups and intervention.
3.  Share with others.
In the top right corner of every GAFE product, there is a “Share” button.  Use this button to share with your professionally learning community, administrators, and others.  For example, I keep all of our grade level data in one Google sheet and it is shared with my team mates, our instructional coach, the school interventionist, and our administrators.  If anyone has a question about a student’s progress, all they have to do is look at the data sheet that has been shared with them.  No need to call and ask.
We also have a Google sheet with the entire school’s universal screening data and every teacher in the building has access to it.  I love this because it creates a very transparent culture.  It also creates a sense of collaboration even though we might not be able to have common planning times.
It is also possible to utilize this data to share with parents.  Of course, be careful and don’t EVER share the entire document with them.  But you can highlight their student’s score, paste them in a word document or another Google sheet and share them that way.  Since scores automatically average once you’ve set the Sheet up, you can easily transfer the data to weekly or monthly progress reports.
So, that’s just one way that I utilize Google Apps for Education in my own classroom.  How are you using it to make your data management more manageable?  I’d love to hear!

sherylwoods

All posts

No Comments

Leave a Reply

Join the #TeacherLadyKY tribe!

About Me

About Me

Hi! My name is Sheryl and I am so thankful you've found your way to the TeacherLadyKY blog! I'm an elementary educator from Louisville, Kentucky who is passionate about building relationships and literacy skills with my students. I've taught everything from kindergarten to fifth grade and I can't wait to share my experiences with you! Enjoy! Read More

Instagram

  • This week's #bulletjournal setup. Usually, I do a day at a time, but after binge watching see @amandarachlee on YouTube this weekend, I thought I'd set it all up at once. One thing I love about my #bujo is that I can do WHATEVER I want, WHENEVER I want to. 😁
.
.
#bulletjournals #bulletjournaling #bujoweeklyspread  #bujoideas #bujoinspiration #penguins
  • ⭐ D R E A M E R ⭐
.
.
Honestly, there are so many good MLK, Jr. quotes, it was hard to choose just one. Instead of choosing one of his justice-oriented quotes (which are completely relevant at the moment and let's not forget that), I decided to go with this one.
.
.
At the end of the day, all you have is your dreams. Don't let someone else take that you. Know what you want and make it manifest in your life.#besavagenotaverage #thebestisyettocome #teacherladyky .
.
#teacherbsn #teacherblogger #teachersofinstagram  #mlkjrday #martinlutherkingjr #martinluutherkingjrquotes #mlkquotes #mondaymotivation #motivationalmonday #motivationalquotes #dreams #dreamers
  • A couple of nights ago, this sweet boy scared the crap out of us. He couldn't stand and, once he did stand, he just lobbed from side to side like he was unable to hold his balance. Then, as suddenly as it started, it was over. Five minutes at the most. .
.
It's happened once before, months ago, and the vet who saw him a few hours after it happened said he checked out perfectly healthy. We think it's vertigo, but it happens so suddenly and goes so quickly, that it seems there's nothing we could do to stop it from happening.  I hate that I don't know when it will happen (or if it even will happen again) and I have there's nothing I can do for my sweet boy.
.
.
Also, side note, be thankful that you can't smell through Instagram because this boy needs a BATH.
.
. 
#dogsofinstagram #instagramdogs #teacherladyky
  • I'm working on something for the blog that involves these babies. 😍 If you had told me five years ago that I'd be obsessed with dice, I would have laughed in your face. Oh, how things change.  I mean, how can you not be obsessed with something that comes in so many beautiful colors?
.
.
#teachersofinstagram #iteach456 #teacherbsn #teacherlife #roleplayinggames #rpg #dungeonsanddragons #pathfinder #tabletopgames #polyhedraldice #dice #teacherladyky
  • S A T U R D A Y
.
.
I've spent my morning doing lesson plans and working on some new TPT products. I have housework to do (so much housework to do), but I love a good laid back, productive Saturday morning and I wish every day could be this way.
.
.
What are you doing on this dreary day? And, if you're local, what's your snow prediction? πŸ€”β„οΈπŸ€”β„οΈπŸ€”
.
.
#teachersofinstagram #teachersfollowteachers #teacherinstagram #iteachtoo #iteachfifth #iteachfifthgrade #iteach456 #teacherpreneur #thebestisyettocome
  • You are not here to please someone else.  You are not here to fall into someone else's story, play someone else's sidekick, or help someone else achieve their dreams.  This life is YOUR story and it is your purpose to fulfill YOUR own dreams.
.
.
If your dream is to serve others, then by all means, go do THAT.  But do not put their needs above your own.  If what is happening in your life doesn't align with the goals that you've set forth in your life, it's time to let it (or them) go.  You only purpose to be the best, most authentic version of you.  First, foremost, and always.
.
.
#teachersofinstagram #teachersfollowteachers #thebestisyettocome #besavagenotaverage #youareabadass #jensincero #iteachtoo #quote #quotesofinstagram #instagramquotes #motivationalquotes #motivationmonday
  • *Trying to do report cards*
Crow: But, mom, it's windy outside and I'm scared...
.
.
One day, I'm going to be able to stay home and work with him in my lap all day and I can't wait. #BeSavageNotAverage #thebestisyettocome
.
.
#dogsofinstagram #instadogs #instadog #teacherlife #teachersofIG #teacherladyky #teacherBSN #teachersfollowteachers #teacherblogger #teacherbloggersellernetwork
  • β€’ G R O W I N G β€’
.
.
I spent the majority of the day attending doctor's appointments and listening to Brendon Burchard's book, "High Performance Habits." Like I've mentioned before, I've been stuck lately and the first part of his book is about finding clarity in your life.
.
.
I NEEDED to hear him tell the story of one of his clients who was great at what she did, but still felt stuck. It's hard not to feel guilty about admitting that what you're doing isn't what you want, especially when you've poured years of work and thousands of dollars to get there. That's where I'm at right now. I feel restless, unfulfilled, and uninspired.
.
.
Let me be clear, I LOVE what I do. I love my job, my students, and my life. But something is off and it's not enough. I've been searching for a long time trying to figure out what it is and I am getting closer.  I AM a teacher, but so much more than that too. I am always learning, always growing, always working on my next great adventure. I hope you are too. #BeSavageNotAverage #thebestisyettocome
.
.
#teachersfollowteachers #teachersofinsta #teachersofinstagram #teachersofIG #iteachtoo #iteach456 #highperformancehabits #brendonshow #gogetterspodcast #
  • What a day, y'all. I was expecting my fifth graders to be tired and dragging, but no such luck.  They met me in full force this morning and we went nonstop to 8:50 to 4:00.
.
.
Honestly, I enjoyed my break and I was ready to delve into the some personal projects, so I dreaded heading back today.  I've got big goals and dreams for the future, but being with my kiddos was exactly what I needed. I love my job and, more importantly, I love my students. Everything that I do for my business is for students, for the ones currently in my classroom and those that may never sit in classroom.  TeacherLadyKY is about making an impact to change the world and it may be small now, but my dreams are big. Believe that. #BeSavageNotAverage #thebestisyettocome
.
.
#teachersofinsta #iteachtoo #iteach456 #iteachfifthgrade #teacherBSN #teacherbsn #teacherladyky #teachertribe #teacherbloggersellernetwork #teacherblogger #teachersofinstagram #teachersfollowteachers

Follow Me!

Twitter

Blog Archive

Credits

The TeacherLadyKY blog header and logo were designed by Sheryl, using fonts from A Primary Kind of Life and Brittney Murphy Design.Β  Clip art is courtesy of Irina Bandyk, whose Etsy shop is WatercolorCliparts.Β Β The blog theme used is Emilia by Georgia Lou Studios.

 

 

×