background preloader

Forms and Sheets

Facebook Twitter

Doctopus - Google Sheets add-on. Harnessing the Power of Google Forms for Just-in-Time Teaching. Not long after I began flipping my writing and literature classes—delivering the course content remotely mostly through outside readings and online videos, readings, and exercises and then practicing the content in the face-to-face classroom—I quickly discovered a serious drawback: my students were not likely to do the outside, online work without serious motivation.

Busy, non-traditional college students would likely skip any work that didn’t have an immediate pay-off, and for them, that meant a grade. If the teacher didn’t check what they did and assign a grade to it, then they would ignore that work in favor of work, social, and family demands. I can hardly blame my students. In a busy life, you don’t do anything that doesn’t count. That’s efficiency. Still, the discussions, exercises, games, homework, and writing that we do in my classes seldom make sense or work well with students who are not prepared by the outside, online readings and viewings. Just in Time Teaching Google Forms. Delivering Peer Feedback with Google Forms. Posted by Alice Keeler, Google Certified Teacher Editor's note: Today’s guest author is Alice Keeler, a Google Certified Teacher, New Media Consortium K12 Ambassador and LEC Admin & Online and Blended certified.

Alice taught high school math for 14 years and is an Adjunct Professor of Curriculum, Instruction and Technology at California State University Fresno. Alice coaches teachers and administrators on using technology in the classroom. In my high school and college classes, I’m one teacher working with up to 150 students. With this kind of ratio, I just can’t give students feedback fast enough; but giving that feedback as immediately as possible helps increase their motivation and accelerate learning opportunities. Peer evaluation allows students to get feedback faster, learn from each other, and helps them better understand the grading rubric by applying it to their classmates. Google Forms makes peer evaluation possible and simple.

Google Sheets: Managing Students Names for Group Work. I use spreadsheets to organize group projects. I have created a step by step tutorial for how take a list of students and put them into groups. Go through each tab for each step. Double click on cells to view the formulas. Click Here to create a copy of the tutorial. Copyright secured by Digiprove © 2015 Like this: Like Loading...

5 Things You Did Not Know About Google Forms. Google Forms allows you to create pages so that all of the questions are not all on one screen. In some circumstances the questions do not apply for every student. If students answer no they are not participating in a sport the section of questions about which sports the student participates in can be skipped.

If you are using a Google Form as a formative assessment quiz you can direct students to a page with instruction on the topic if they get the question wrong or go to the next question if they get the question correct. Start by creating all of your pages. For Multiple Choice questions there is an option to “Go to page based on answer.” When students finish filling out a Google Form the default message is “Your response has been recorded.” If some of the fields of your Google Form are highly likely to have a specific answer or if you reuse your Form it can be handy to pre-select some of the answers in Form. The option to “Get pre-filled URL” is located under the “Responses” menu.