8 Google Sheets Add-ons Every Teacher Should Know about

Yesterday we covered what we think are some of the best Google Docs add-ons teachers should know about. In today's post we are featuring another collection of important add-ons but this time for Google Sheets.  Using these applications will enable you to add a wide range of functionalities to your Sheets.  These include the ability to grade and analyze online assignments, send mass emails using Gmail, access a huge library of professionally designed Sheets templates, assess and organize students projects in Google Drive, create PDFs from spreadsheets, convert a Google Sheets spreadsheet into a Google Doc, and many more. We invite you to check them out and share with us your feedback.

8 Important Google Sheets for Teachers and Educators

1- Flubaroo
‘Flubaroo helps you quickly grade and analyze online assignments and assessments, as well as instantly share scores with students!’

2- Mail Merge with Attachments
‘Send personalized mass emails with Gmail, schedule emails, insert different attachments for each recipient and track email opens.’

3- Template Gallery
‘Save time by using professionally designed documents and spreadsheet templates created by Vertex42.com.’

4- Doctopus
‘An octopus for docs! Teacher-built tool for scaffolding, managing, organizing, and assessing student projects in Google Drive.’

5- AutoCrat
‘Flexible, easy to use document merge tool that creates PDF or shared Documents from spreadsheet data.’

6- Flippity
‘Easily turn a Google™ Spreadsheet into a Set of Online Flashcards and Other Cool Stuff.’

7- Save As Doc
‘Convert any Google Sheets spreadsheet into a Google Document for improved legibility of lengthy cell text entries.’

8- Add Reminders
‘Send automatic email notifications before / after a specific date (deadline) is reached for each row of your spreadsheet.’
First appeared here

Comments

Post a Comment

Popular posts from this blog

Educational Tools for Creating Digital Portfolios

Image
Digital portfolios are great teaching, learning, and assessment tools. In today’s post we are focusing on the learning part and are looking at e-portfolios from a student-centric perspective. To learn how teachers can leverage the powerful of portfolios in their instruction, check out Arter and Spandel (1992) paper (see reference list at the bottom of this page). By definition, a portfolio, according to Arter and Spandel, ‘is a purposeful collection of student work that exhibits to the student, or others, her efforts or achievement in one or more areas’ (cited in  Baki and Birgin, 2007, p. 77). The key word here is ‘purposeful’, a portfolio is different from a folder in that it has a purpose and is guided by a number of learning objectives and expected outcomes. Without intentional planning, a portfolio becomes a mere receptacle of one’s work. Three processes are involved in portfolio creation: collection, selection, and reflection. Each of these processes trains students in a numb...
Read more

SAMR Model Explained for Teachers

Image
With the pervasive use of technology inside our classrooms, pedagogical concerns related to the effectiveness of technology in transforming education and creating optimal learning experiences come to the surface. Every teacher drawing on technology in their instruction has probably, at a certain point in time, mulled over questions such as: does technology always work for every instructional task? Does it enhance students learning? How about distractive features that come with this technology. Do they affect students learning? The strengths and weaknesses of technology is a topic that has been extensively covered in a wide variety of studies and the extant literature  in this regard features multiple examples.  The stance we have always espoused towards technology is one that celebrates its strengths and capitalizes on the advantages and affordances it provides for us in education while also working diligently to raise awareness of its inconveniences and help minimize their im...
Read more

6 Good Websites to Help You with Your Professional Growth

Image
One of the best advantages of the Internet and web technologies is that they have levelled the educational playground making education and learning accessible to anyone anywhere in the world with a computer and Internet connection. Whether you want to pick up a foreign language or learn the basics of a craft from scratch, 'you Google it and you find it'. With the widespread of open courseware and MOOCs, everybody now can have access to a plethora of high quality lessons and learning materials offered by distinguished scholars from top universities around the world. In the collection below, we are sharing with you some of the best platforms that provide open and free courses for learners. 1- Khan Academy ‘Khan Academy offers practice exercises, instructional videos, and a personalized learning dashboard that empower learners to study at their own pace in and outside of the classroom. We tackle math, science, computer programming, history, art history, economics, and more. Our m...
Read more