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

  • Puppy noses and happy smiles are my favorite.
.
.
#dogsofinstagram #dogstagram #crow #dogwalk #retriever #retrievers #retrieversofinstagram
  • Wake up and be awesome today. Make it happen.
.
.
.
#teachersofinstagram #motivationalquotes #mondaymotivation #monday #mondayquotes #mondaymood #fitgirldiary
  • Not going to lie, I had a self-hatred moment this morning. I haven’t been to the gym in ages and I keep putting it off because, what’s another day, right?  So, so wrong.

I hated how I looked in the mirror this morning. I hated how there were rolls where there shouldn’t be and dimples in places there should be no dimples. I literally wanted to throw up. Is that normal? Probably not. It’s not healthy, for sure, but it’s something most women go through.

Why?

But then, friends, I put on my face and opened the windows and felt that wet hair-fresh mind-sunshine kind of feeling and I felt better. Not 100%, but better.

I’m going to the gym today. Or at least walking the dog around the neighborhood. I’ll keep you posted.
  • He’s my favorite person to do stuff with.
  • Project based learning in progress. These kiddos came up with their own business plan to serve the community. They created missions, visions, slogans, and logos. Now they’re building their businesses. I can’t wait to see them finished!
.
.
#teachersofinstagram #teachersofog #iteachtoo #iteachfifth #fifthgrade #pbl #projectbasedlearning #business #communities
  • It's been a busy (and really weird) couple of weeks. Things have been messy, jumbled, cancelled, redone, and just over all insane. It's always nice to start a new week: clean, fresh, and organized.

I've been trying new weekly layouts each week of March this far... I'll let you know which one I liked best at the end.  This week's is more open, but still horizontal. Maybe a vertical layout next week? Stay tuned... #bujodaily #bujolayout #bujoideas #bujoinspiration #bujo #bulletjournal #bulletjournaling #bulletjournals #marchbulletjournal #march #cactus #cacti #succulents #freshweek #saturday #sunday
  • I attended #ECET2Bardstown this weekend and was in awe of how BEAUTIFUL Thomas Nelson High School is. The inspiration and empowerment run rapid at this place and you can feel it in every corner. #SchoolGoals #goodmojo
.
.
#teacherbsn #teachersofinstagram #teaxhertribe #schoolleadership #schoolsleaders #blbs
  • Finally.... My March bullet journal! It was hard to choose a theme, but I grabbed some inspiration from @amandarachlee's 2018 (2017?) March spread. I love it so far! Swipe to see my first weekly spread  and flip through of my monthly calendar, habit tracker, and mood tracker. Do you approve of my cacti/succulent theme, @jmeier205?
.
.
What's your March spread look like? I'd love to see them!
.
.
#bujoideas #bujoinspiration #march #marchbulletjournal #marchbujo #bujo #bujoweeklyspread #bujodaily #bujolayout #art #doodles #bujodoodles #bulletjournal #bulletjournaling #bulletjournals #planwithme #planning #plannergirls #cactus
  • One of my colleagues shared this with me today. He meant it about my students, but he doesn't realize how much it resonated with me personally.
.
.
It's no secret I've been broken lately. It's felt like destruction, but I'm slowly breaking the surface and recognizing the growth and potential that like ahead.
.
.
#teacherbsn #teacherladyky #teachersofinstagram #teachertribe #ecet2 #growth

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.

 

 

×