Teacher to student feedback with Google Sheets and Orange Slice Rubric add on

By Anonymous -
We know that providing feedback to students during their learning process is one of the most effective ways to help kids reach their learning goals (John Hattie, 2011).  Figuring out how to provide each student with specific, actionable feedback within the constraints of a single class period is quite a challenge for teachers.  Technology tools can be used by the teacher to shorten the feedback loop so that students know more quickly where they are on the learning continuum and how to reach their goal.  
This blog post will provide you with a few technology-based suggestions to help teachers give feedback more quickly.  The tech tools included are conditional formatting in Google Sheets and Orange Slice rubric add-on for docs.


Google Sheets conditional formatting is great for giving students feedback regarding whether or not the answer is correct.  A teacher sets up a spreadsheet so that it contains questions in one column A and students place answers B.  With a little preplanning on the teacher’s part, the spreadsheet can be formatted so that the color of each answer cell changes when the student inputs the correct answer.

This strategy could be a great bellringer to check student’s understanding of a previously learned concept, preassess for future learning, or loop back in material from units long ago. Conditionally formatted Google Sheets could also be deployed as a station strategy so that students can learn new content Individually, check their understanding using the Google Sheet, and then seek assistance from the teacher if needed. This strategy does require some teacher set up on the back end. See below.


Task level feedback is certainly a valid conversation to have with students in the classroom but often times students need more support than simply knowing if their answer is correct or incorrect.  This is where rubrics can come into play.  Grading assessments with rubrics can become a paperwork nightmare, however, and shuffling all these different sets of papers around for all the students we teach can leave a teacher to want to abandon rubrics all together.  This next tool, Orange Slice, combines student work and rubrics in a single document and adds functionality of color coding progress on the rubric and auto-calculating points to make the entire process much more manageable.  Check it out.

In an upcoming post,  we will cover how you can do some planning in advance to automate some feedback processes using two Google Apps: Google Classroom and Google Forms.


Comments

Post a Comment

Popular posts from this blog

Chat GPT- Your New Personal Assistant

By -
Image
What if I told you that within seconds, you could have a well-written speech, have directions on how to fix your leaky sink, or even generate a personalized workout plan? All of these things are just a small part of what can be done with Chat GPT, and it is revolutionizing how we approach everyday tasks and even the type of work we assign to our students as educators. Chat GPT is a new artificial intelligence (AI) phenomenon that emerged on the scene in November 2022. Users can type in a question and the chatbot will generate a personalized, human-like response to your question. It stands in its own category by itself, for now. Though most people utilize AI through technology like Alexa, Siri, website chat box assistants, and even that autocorrect feature that you so frequently enjoy when typing text. However, Chat GPT is a little different from these tools. It is chartering new territory and causing everyone, especially teachers, to pay attention to just what it can do. Since its arr
Read more

The 5 steps of Focused Note-taking (with Google Slides!)

By Anonymous -
Image
For years, the AVID instructional framework recommended a specific note-taking strategy, called Cornell Notes, to support students in processing the information they learn in class.  Recently, however, AVID revised the note-taking recommendations to be more broad rather than solely focusing on Cornell Notes. The new recommendation is that educators teach students to use a focused note-taking strategy.  This is fantastic because it allows for student choice and voice in how they process their learning and can incorporate technology in powerful ways.  This blog post will overview the 5 steps of focused note-taking along with some digital strategies that align with each step. Step 1: Taking the notes This is an obvious first step!  In this phase, students are capturing information using a method they feel most comfortable.  If students are new to taking notes, very young, or have instructional accommodations, teachers can just share the notes and skip step 1.  Plenty of learning, as
Read more

Reading with a purpose and teachers gathering data

By Anonymous -
Image
In our connected world, people find themselves gathering information from online sources much more frequently than print sources.  Interestingly, the way our brains work to scan digital texts has changed based on the typical layout of websites that present information.  For example, our eyes are more likely to remain focused on the left side of a webpage, where menus and additional links are typically placed rather than scan the entire page fully.  Readers, young and old, typically scan pages in an “F” pattern, tracing their eyes along the text in heavy left-to-right patterns at the beginning of paragraphs but not throughout the entirety of the passage.  Source: https://www.nngroup.com/articles/f-shaped-pattern-reading-web-content/ This isn’t altogether horrible if students are simply scanning to gather rudimentary information but when we are asking students to complete sustained and detailed reading online, these habits suggest that a support for students may help them read more
Read more