In education there are times when we gather data into a sheet and need to share parts of the form out to others. How does one do that so that it populates automatically over time without copying and pasting time and time again?
Warning: My goal is to take the questions people have about technology and provide solutions. This is just one solution. If you have other ideas or methods to solving the same issue, then please leave a comment or reach out so we can showcase the method. This is not the only method, but simply one that I use.
For those who don’t want to watch a video, here is a quick guide. To do this tutorial you need to have open
Existing spreadsheet with the data you want to move to another Sheet
The new Sheet you want to create
Grab the key from the URL of the Google Doc you want to import.
Write down or take a mental note of the columns or range you want to import. You can import entire columns by entering something like Tab Title!A:F. Or, for a specific range, something like Tab Title!A6:F100.
Go to your new Sheet that you are creating. Enter the following data in the Sheet where you want it to appear.
A question was posed to me today. I love it when questions come my way where I don’t know the answer and am challenged to find the answer.
The challenge was that a few teachers wanted to use Google Forms as a rubric. They want to be able to quickly and efficiently score the work of a student using a Form and organize all their grading in one spreadsheet.
Easy and check.
They wanted to use the same spreadsheet for students to upload their self evaluations using the same Form.
Easy and check.
They also wanted to be able to take the scoring/feedback of each student from the spreadsheet and email the students their assessment in real time
Do what? Is that possible?
Today I am happy to report that indeed it is possible. It is amazing. It is efficient. It eliminates stacks of unnecessary papers and provides real time feedback that requires very little extra time on the teacher side of things.
What is this mystery? How do I harness the magic powers of all of this in which you speak?
Check out the video as I attempt to walk you through it. As always, I am super excited to see examples of how this plays out in real classrooms.
Even more important I plan to run PD and do live trainings to help those who need it. I really think this could be something big for teachers and students.
The tip this week is super simple, short, and easy. We have all had the moment where we have sent out an email and instantly wished we could take it back. Whatever your reason for wanting to bring your words back, there is a way to make it happen quick and easy.
As always please let me know what you think, tips, ideas, and questions. Each week I will share another tip to help make your life easier and more productive with the GaFE interface.
This week we will take a look at Google Drive and uncover three way to provide feedback quickly to students. We all know that time is of the essence and as teachers continue to have larger class sizes, more students on their rosters and mix this with all the mandates of teaching we need to find shortcuts.
Every single second is precious in the life of a teacher. If we don’t find ways to be productive, then our balance of work and life suffer.
What are other tips that you use to be more productive in giving feedback to students? If you want to join and crowdsource the Master List of Comments please use this document. It is open to everyone while the link above is for BMS staff.
These ideas were derived from Catlin Tucker as well as several other sites that have shared these tips in the past. I just made sure I could actually do the work and that I would actually use these tools which is why the video and such was created.
I was asked this great question by a fellow friend and educator last week about how to help another teacher eliminate students from sharing Google Quizzes. Students were sharing the quizzes to their friends ahead of class so they could prepare and see the questions.
For example, I give a quiz period 1. A student could copy the link and share to friends in a later period to prepare. Is there a way to prevent this?
At the time I was not sure what the answer was to this question. I was fascinated. How can we trump students who try to defy the system?
I should have known better. By now I should know that this constant tension is something all educators face. However, I had to stop and think more deeply:
Is this question more about learning environments and control disguised as a tech question?
Now, before you answer I want you to know that I address both topics. The video will discuss some things to ponder about why this is a problem in the first place AND then I deal with the reality that this is indeed an issue no matter how great our classrooms are organized. There will always be that one kid who pushes the envelope. I share 5 ways in which you can minimize students cheating/sharing quizzes online.
Shuffle answer order
Shuffle question order
Turn quiz on/off
I cannot wait to hear other tips and strategies as well as future conversation about this topic as a whole.
So what this means is that we can now organize our assignments and posts by topic. What this will create is a column on the left side that students can click a topic and all posts will appear. Think about this for a minute. You can now sort by unit, standard, project, chapter, etc. Whatever works for you as a teacher can now be done.
No more strolling for days to find that one post from a month ago!
Check it out and let us know how this can help your classroom organization.