How to Send Emails from a Google Spreadsheet Have you ever found yourself sending strikingly similar though slightly different emails to all of your students or all of their parents at the same time? If so, you may have entered the email address, copied and pasted a message into the message, modified it slightly, then pressed send before repeating the process for the next message. That can be time consuming. Applications for Education Using this Google Spreadsheet script could be a great way to send similar though slightly customized messages to students and their parents.
Excellent Tutorials to Help You Create Presentations on Google Drive January 13, 2015 Here is a set of practical video tutorials on Google Slides (formerly Presentation) I have bookmarked over the last couple of months. The purpose behind this collection is to provide teachers, especially beginner users of Slides, with practical know-how to assist them in creating, editing and sharing Google Slides. Google Slides is one of the easiest and simplest presentation creation tool out there. It is also part of Google Drive suit which makes its integration with other Drive services a seamless process. 1- How to add slides to Google Slides by Vickie Henson 2- How to Animate presentations by Navitend 3- How to insert a background and video in your slides by Sethi 4- How to insert images and add new slides by Alaina Beaver 5- How to add sound to a Google Slide by Kit Hard 6- How to use Google Drive Presentation App by Dottotech 7- Google Presentation tutorial by Ian O’Byrne
How to Filter Data in Google Docs Spreadsheet? How to filter data in Google Docs Spreadsheet? Explanation Data can be filtered based on the required values which will be helpful for the user to get the result for a particular portion.Filter option can be used with the following steps.Step 1: Choose filter option using any of the following options,Option 1: Click Data → Filter. Option 2: Click Filter icon in the toolbar. Step 2: First row will be added with Filter as shown below, Step 3: Click the downwards arrow and select the fields to be filtered. Add values to filter:Step 1: Click the downward arrow.Step 2: Click "Clear". Step 3: Select the value to filter and click "OK". Data in the worksheet is filtered with "Tester" value. Add Filter to selected Columns:Step 1: Click Data → Filter. Step 2: Filter is added only to the selected columns A and B as shown below. Related Topics
Tech Tip: How to manage, organize student projects with Doctopus Are you using add-ons for Google Apps? These wonderful tools — available for Documents, Sheets and Forms — make Google Apps even better. One of my favorite add-ons is Doctopus. This tool lets teachers create, manage, organize and evaluate student projects in Google Drive. Here’s how it works: Start by creating your roster in Google Sheets. Voila! Different ways to share documents, including individual all the same, individual differentiated, project groups, whole class;Word counts and comment counts based on revision history. If you use Google Classroom, you will find that Doctopus serves a similar purpose, but it has different features. Editor’s note: Additional step-by-step directions – with screenshots – for using Doctopus can be found here. Diane Main is the director of learning, innovation and design for grades 9 through 12 at The Harker School in San Jose, Calif. Tech Tips is a content collaboration between SmartBrief Education and GreyED Solutions. Miss a Tech Tip? Related Posts
How To Use Google Forms To Create Your Own Self-Grading Quiz Are you a teacher or trainer? Someone involved in a hiring process? Do you need to check somehow that other people have the skills or knowledge that you expect them to? Google Forms are amazing tools, allowing you to do some really advanced tricks with forms as the front-end and spreadsheets at the heart. Create A Self-Grading Quiz Creating a form in Google Forms is very self-explanatory: you open Google Docs, create a new form and get typing (or read this if you want a general guide to using Google Forms). For this example, we have used one form question to ask for the person’s name and written out 5 spelling test “fill in the blank” questions. You will need to click on “Choose Response Destination” and tell the form to put responses into a spreadsheet. In the Form Responses tab, you need to use a couple of lines to add the answers and the value for the answers. Now, create a new tab for your test scores, so you can cross reference each person’s answer with the results. Use A Template
Google Sheets: Splitting Numbers from Text In my attempt to create my own gamified gradebook I needed to be able to give a student a score and comments. The problem is how do you input both values into the same cell?! My solution was to separate the score from the comments using a comma. For example: 12, You did a great job! The first problem I had to overcome was locating where to split up the number from the comment. =Find() The formula =find will locate a text string and return the location of the text string. =find(“,”, A1) Remember that all of your text strings need to be in quotation marks. In my examples the score is the characters to the left of the text string. =left() The formula =left() will return the characters on the left hand side of text string. =left(A1, 2) The formula =left(A1, 2) will return the left 2 characters. =left(A1, find(“,”, A1) -1) The dilemma is that the numbers we extracted from the text string still are considered text, not a number. =value The formula =value() will convert text to a number. =right() =len()
Tech Tip: How to create interactive timelines from Google Sheets Timelines are useful tools for helping students conceptualize how individual events fit into a given time period. My favorite timeline app is TimelineJS, an open-source tool from Northwestern University’s Knight Lab that lets you build timelines from Google Sheets. Here is one I built about the Japanese-American internment. There are only four steps to creating a timeline. Open the Google Sheet template, remove the sample items and add your own content (dates, photos, Tweets, Google Maps, text and media links). And that’s it! Gail Desler is a technology integration specialist for the Elk Grove Unified School District in California. Tech Tips is a content collaboration between SmartBrief Education and GreyED Solutions. Miss a Tech Tip? Related Posts
5 Google Drive Add-ons You Need To Use Long ago, productivity enthusiasts were relegated to using desktop software for writing documents or organizing with spreadsheets. Thanks to the advance of the Internet and cloud computing, there are now wonderful products like Google Drive to enhance daily productivity. What makes services like Google Drive so great? They key here is to put things like Google Spreadsheet and Google Docs to good use in your life, and the best way to do that is to enhance those services with some of the best add-ons available. Google Docs and Google Spreadsheet are both amazing free services as-is, but when you include some of the add-ons listed below, it can really breathe new life into those tools. AbleBits Suite AbleBits is a company that actually offers paid professional add-ons for Microsoft Excel. Lucky for Google Drive users, Ablebits offers a whole list of highly useful Add-ons for Google Drive apps. Then, it lets you define exactly what sort of data you’re looking to identify. Mapping Sheets
Google Spreadsheets: Transpose in 2 easy steps Today Google announced some new features for Google Sheets on their blog. Many of the new features are exciting, but one I am particularly excited about is “paste transpose.” One feature of Excel that I use a lot is to paste special and transpose cells, unfortunately this was not a feature in Google Sheets, until now. Transpose is to switch from horizontal to vertical or vice versa. In other words from rows to columns (or columns to rows.). Copy a list of either vertical or horizontal cells. Right click in a blank cell. Notice the list of names now goes across the cells. Like this: Like Loading...
Control Alt Achieve: Spreadsheet Activities for all Subjects Spreadsheets are often thought of as a tool for math or statistics. Something just for crunching numbers and making graphs. Although those are excellent uses for spreadsheets, there are so many other ways they can be used for teaching and learning in all subject areas. Recently I did a webinar where we took a look at five main ways that spreadsheets can be used by students. There are certainly more uses than five, but these activities provide a nice variety to show how spreadsheets can apply to a wide range of subjects. Random GeneratorsEducational GamesPixel ArtLearning DatabasesAnalyzing Data For each of these examples I demonstrated how to do these activities with Google Sheets, although you can accomplish the same activities with Microsoft Excel or other modern spreadsheet program. See below for the full video, as well as links to additional resources for each of the activities. Webinar Video (1 hour) Session Slideshow 1) Random Generators RANDBETWEEN(low,high) 2) Educational Games
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
How to automatically pull data between different Google Spreadsheets | Dave Foord's Weblog Posted on November 4, 2011 by davefoord I have been using Google Docs for quite a few years now, and in particular Google spreadsheets. One feature of Google spreadsheets is there is a function called ImportRange that allows you to pull data out of one sheet and into another. This can be really useful, if for example you have a spreadsheet that you are using to collaborate with others, and then somewhere along the line you want another person to be able to see some of the data in the sheet but not all of it. e.g. if you are using this to track student grades, you could have a master sheet that you and other tutors can see all of, you could then create a separate sheet for each student, and pull through only the data that refers to them (you then share that sheet with the student) and they have a live constantly updating record of what they have achieved etc. Here is a video showing the basic principle of this idea. Like this: Like Loading...