background preloader

8 Powerful Extensions to Use on Google Spreadsheet

8 Powerful Extensions to Use on Google Spreadsheet
March 12, 2014 As I mentioned in an earlier post today , Google recently announced the introduction of add-ons to Google Docs and Spreadsheets. With these add-ons installed, users will have access to a plethora of new features and services that were not available before. In this post, I am sharing with you some of the important add-ons you can install on your Spreadsheet to make it more practical. If you are looking for add-ons to use with Google Docs , check this post. Add-ons for Spreadsheet: 1- Flubaroo Flubaroo is a FREE add-on to Google Forms/Sheets which lets you quickly grade and analyze student performance on multiple choice and fill-in assignments. * Get scores for each student, and identify students in need of extra help. * View average score, and a histogram of scores. * Quickly identify questions which a majority of the students missed. * Email students their scores, along with optional notes to the class and/or to each student. 2- Doctopus Related:  GSuiteEDUGoogle Apps for Educatorsjnclark

Teaching Writing with Google Docs One of the key results of flipping my writing and literature classes has been that my students do much of their writing in-class on computers provided by the college. All of these computers have Microsoft Word on them, but I prefer to use Google Docs/Drive instead. Given that MS Word is the standard word processor for my college and most of the rest of the world, then this preference may require some defence. After all, my colleagues expect all of their papers to be submitted in doc or docx format, and my students are most familiar with Word, so what are the benefits of Google Docs that make it worth swimming against the tide? Why Google Docs? First, Google Docs can do the job. But if Google Docs can only do what MS Word already does, then the switch would not be worth it. Sharing The first truly huge advantage has to do with sharing. But the sharing doesn’t start there. My students learn about writing as they are writing. Plagiarism Peer-editing Research

Overview - Welcome to Flubaroo The grades created by Flubaroo will be located in an adjacent worksheet called "Grades", as shown: For each submission, Flubaroo will show which questions were answered correctly ("1" point"), which incorrectly ("0" points), and which were not graded. If less than 60% of students got a question correct, the question will be highlighted in orange to alert you. Additionally, students who scored less than 70% on the assignment will be highlighted in red. The Flubaroo menu will now offer you the ability to email each student their grades, view a summary report, or regrade the assignment. You might want to regrade the assignment if more students submitted answers, or if you want to throw out a question that most students got wrong. If you choose to email each student their grade, you'll be given the option to include an answer key in the email. Choosing "View Report" shows you a summary report of the grading. Want to try it out?

Important New Updates to Google Sheets Teachers Should Know about Google has recently rolled out some more important updates to some of its services in Google drive and Google Sheets is one of them. Google Sheets has been revamped with a new look and feel. The new version of Google Sheets is faster and supports larger spreadsheets. it also has a wide range of interesting features such as : It can work offline. So just like Google Docs and Slides, you can now make edits to Sheets offline. When you reconnect to the Internet, your edits will automatically sync.

Klikaklu: Picture Treasure Hunts and Scavenger Hunts on Your iPhone 5 Ways to use Google Presentations (Slides) NOT as Presentations This is reblogged from my post on Edudemic. It is a part of my Google Drive series that includes “10 Things Every Teacher Should be able to do on Google Docs” and “5 Time Saving Ways Teachers can use Google Forms” If you’re a user of Google Drive, then no doubt you have also heard of and likely used Google Presentations (Google’s version of PowerPoint). It’s a great tool to create slick presentations in the cloud, especially after its most recent overhaul. However, Google Presentations is also a handy tool for doing some great projects with your students that have nothing to do with public speaking. Visual Note/Flash Cards Imagery is a powerful tool in all subjects. Visually Outline a Project Presentation slides are a great way to engage in pre-writing exercises. Create Visual Prompts & Virtual Discussion If you’ve ever used Voicethread then you’re familiar with the idea of providing students with a visual prompt and then allowing them to discuss the image. Digital WorkBooks Like this:

An Easy and Quick Way to Grade Quizzes on Google Drive Using Super Quiz Tool February 22, 2015 Super Quiz is an excellent Google Sheets add-on that allows teachers to add some amazing functionalities to the quizzes they create through Google Forms. For instance, when you create a quiz, you only need to complete it once with an answer key and all future submissions will be automatically graded according to the answers you provided. Another important feature of Super Quiz is that it enables you to get a break down of class understanding and a list of incorrect students' answers for each question in case you want to stage an intervention. Also, “By filling out a few cells of information, you can also generate personalized differentiated written feedback emailed to students as soon as they submit a response. Watch the video below to learn more about Super Quiz

Internet Arcade : Free Software : Download & Streaming by Sega software eye favorite 228 comment 10 1 Player Start 1 2 Players Start 2 Coin 1 5 Coin 2 6 Service 1 9 Service Mode F2 Gear Shift SPACE or Mouse B2 Paddle Analog Mouse X Paddle Analog Dec LEFT Paddle Analog Inc RIGHT P1 Pedal 1 Analog N/A P1 Pedal 1 Analog Dec None P1 Pedal 1 Analog Inc LCONTROL P1 Pedal 2 Analog N/A P1 Pedal 2 Analog Dec None P1 Pedal 2 Analog Inc LALT favoritefavoritefavoritefavorite ( 10 reviews ) by Williams favorite 153 comment 15 Defender is an arcade video game developed and released by Williams Electronics in February 1981. by Mylstar favorite 30 comment 2 The Three Stooges, fully titled as The Three Stooges in Brides is Brides on the title screen, is a 1984 arcade game by Mylstar Electronics. favorite 38 comment 5 Astro Blaster is a shoot 'em up arcade game released by Sega in 1981. by Stern Electronics favorite 75 comment 12 Berzerk is a multi-directional shooter video arcade game, released in 1980 by Stern Electronics of Chicago. favorite 177 comment 11 favorite 10 Mr.

38 Ideas to Use Google Drive in Class August 11, 2014 This is the third post in a series of posts aimed at helping teachers and educators make the best out of Google Drive in classrooms. This series comes in a time when teachers are getting ready to start a new school year and hopefully will provide them with the necessary know-how to help them better integrate Google Drive in their teaching pedagogy. The two previous posts featured in this series were entitled consecutively "New Google Drive Cheat Sheet" and "Teachers Visual Guide to Google Drive Sharing". Today's post covers some interesting ideas and tips on how to go about using Google Drive in your classroom. This work is created by Sean Junkins from SeansDesk. Google Docs

Important Tips on How to Create, Edit and Share Forms and Quizzes Using Google Forms March 12, 2017 Google Forms is an important tool teachers can use to create, edit and share surveys, forms, and quizzes. If you are using or planning to start integrating Forms in your instruction the chart below will be of great help. It is basically a set of guidelines provided by the folks in Google Forms to help you learn more about how to create a wide variety of forms. More specifically, you will get to learn how to create, edit and format forms; how to share your forms and collect responses; how to set rules for your form and use add-ons and apps script. This chart is part of a series of EdTech charts we have recently started posting covering different Google services.

The 6 Most Popular Google Docs Templates for Teachers July 23, 2015 In today’s post we are sharing with you a set of handy document templates created and provided for free download by the folks in Google Docs. These are the six most popular and most downloaded templates in Google Docs Template Gallery (in Students & Teachers category). As a teacher, you can re-appropriate the content of the docs to suit your teaching purposes. These ready-made document templates are particularly useful for teachers to use in class to enhance their teaching workflow and boost their productivity. The templates span different topics and can be utilized for various purposes including: writing student reports, grading essays, taking notes in class, creating lesson plans and more. Before you download any of these templates, make sure you check it in preview mode to see if it works for you. 1- Student Report 2- Class Notes 3- Essay Grading Rubric 4- Syllabus: Basic 5- Syllabus: Simple 6- Lesson Plan: Basic

Chromebook Creation: Slides, Thinglink & Snagit - From Greg Kulowiec This post first appeared on Free Technology for Teachers. With Chromebooks being adopted as the 1:1 tool of choice in schools throughout the country, it is helpful to note that there a number of options that allow for student creation that go beyond the suite of Google tools. One example of this creative potential takes advantage of a staple in the Google Apps library, Slides, and works in combination with Thinglink as well as the Chromebook screencasting option from TechSmith, Snagit. In the image below, the process is outlined where a student could create an image or poster in Google Slides, export the image as a PNG or JPEG file, and then upload that file to Thinglink. Once in Thinglink, the hotspot tags can be added to include text, links, or even YouTube videos. Below is a final screencast that demonstrates the entire creation process and what a final Thinglink screencast created with Snagit could look like. Learn more about Chromebook Creation this Summer! Related