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, as well as empowering teachers around me to be leaders and rockstars. I've taught everything from kindergarten to fifth grade and I can't wait to share my experiences with you! Enjoy! Read More

Instagram

  • I love my job. But I miss being home with this guy during the day. That big nose and those sweet ear wispies just take melt my heart.

Crow. ❤️ #teacher #teachersofinstagram #teachersonsummerbreak #teacherpets #dog #dogsofinstagram #goldenretrievermix #dogstagram
  • I could get used to this drive every morning.  Who doesn’t love a beautiful sunrise mixed with that ever-present bourbon-in-the-making smell?

Six months ago, I had no idea I’d be where I am today.  Six months ago, I didn’t think it would get better. I didn’t know there was another side. I didn’t realize that there was better things on the way.  Not just with work, but in all parts of my life. I felt out of sorts. I doubted everything that I was doing.

I do remember telling a certain someone in early April that if all goes well, things will look completely different this time next April. We’re on track for that. 🥰

I am so grateful that I’m here. In this place. With these people. Living this life. For so long, I wondered why the door was constantly slammed in my face, without so much as an explanation. I realize NOW that every closed door was paving a clear path to THE door that I was supposed to walk through.

Just.... all up in my feelings today.  So thankful. So grateful. So blessed.
  • This team.

You know, I prayed that I’d find my place for so long. A place where my voice felt heard, where my talents felt useful and appreciated. I prayed for a place where the energy was so strong, it felt electric - where I could dream a crazy idea and with the almost same breath, see it come to life.

It’s been two weeks, which is hardly enough to judge the outcome of this big life jump I made. But I can tell you right now that THIS TEAM and the staff we support and the kids we empower are going to change the world.

This  P  L  A  C  E (and not the building or the town, but the feeling in my heart) was worth the wait.

Watch out, world. Because @foster.heights is doing the #npossible this year - and we can’t wait to share it with you. #FHhuskyproud
  • I moved into my house in late June of 2012. As I was sitting on the porch, less than a week later, this black and white baby came running through my yard and up to me, eager for some loving. 
She was tiny for her breed - nearly 20 pounds underweight and basically a bag of bones. She was so dirty.  Kids from the neighborhood said they had no idea who she belonged to - she’d been running for a while now. I took her in the backyard and she became a part of our family almost immediately. 
It took her a while to trust us. She wouldn’t let us pick her up. She bolted out the door anytime it was open. Even to this day, she hated fireworks and thunderstorms, which gave her such anxiety that she’d pant, pace, and shake.  We had no idea how old she was,  but we knew she’d seen a lot in her years. She had been terribly abused and, with us, she found a new life of love. 
And she loved so deeply. After a while, she learned that there were plenty of pets, kisses, and treats to go around. She leaned into our sides when she wanted some attention. She begged for walks and car rides. The last seven years of her life were good - so good.  She loved us all, but her Grandpa Dennis Boyd especially. She made our family of puppies complete and we couldn’t imagine life before her. 
Our sweet Hallie Grace crossed the rainbow bridge this afternoon, joining our Annabelle. I will miss her, just like I deeply miss my Belle, but I take comfort in knowing that they are together. ❤️❤️❤️
  • A couple of months ago, I posted about how I’d be moving from fifth grade down to fourth. Well, things change!

This week I accepted an offer to serve as the Backpack Leader at Foster Heights Elementary in Nelson County. I am so thrilled for this position since it allows me to work with teachers and help them level up their skills, but also allows me to stay grounded in my first love: teaching. I will still be responsible for a group of students each day and focused on deep learning with them.

It is bittersweet leaving a school and a district that I love - but when I feel the need to jump, I jump.  I can’t wait to do amazing things with some amazing people in NCS! #npossible
  • A rare day in summer when my makeup is on and my hair is down.  I am absolutely loving these lazy, summer days, but I’m also excited about all of the professional learning that will be happening over the next two weeks.

I’ll admit - it’s hard for me to take a break. But when I do, I break HARD! Learning how to balance and make process, while still taking care of myself.

Enjoy your summer, teachers! You’ve deserve it!

#teacher #teachersofinstagram #teachersonsummerbreak #teacherlife #teachersummer #professionallearning
  • It’s true. You are only as good as the people with whom you surround yourself.
  • Anyone else read two books at once? I keep switching between the two of these. They both started out slower than I wanted, but are starting to pick up.

Brave, Not Perfect is about learning to combat your inner perfectionist and focusing on being brave instead.  It’s a powerful message that more people need to hear and take to heart, myself included.

Everything All At Once is the story of Lottie, whose very famous writer aunt recently passed away, leaving her with 24 letters that includes directions for accomplishing specific tasks. It’s starting to get really good!

#bookstagram #booksofinsta #bookstagrammer #bookstagramit #bravenotperfect #everythingallatonce #teachersofinstagram #summerreading #summerreadinglist #teachersonsummerbreak
  • Did you know that elephants like to give triceratopses piggy nose rides? *Not to scale.

@ktberry9515

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.

 

 

×