, , , ,

Google Drive: Docs, and Spreadsheets, and So Much More!

Google Drive Logos

Written by: Evan Sanderson

Google Drive isn’t just a great way to organize your personal documents and spreadsheets; it can be an extremely effective tool for the classroom as well! Drive includes a document editor, a spreadsheet creator, a form aggregator, as well as several other tools. Each of these tools synch to the cloud and can be accessed anywhere you have an internet connection (and through any device).

Want to have students submit a paper to an online drive? Need a way of collecting student information? Have an spreadsheet that needs editing, but you don’t have your personal laptop on you? Google Drive can help with all of those issues and more!

To learn more, watch CTRL’s video on Google Drive here:

, , , , ,

Google Forms: Making Your Life Easier, One Form at a Time

Google Forms Icons

Written by: Evan Sanderson

You’re standing in front of class, passing around a sign in sheet, and thinking: There’s got to be a better way to gather my students emails. Or maybe you’ve just taught a particularly tricky concept, and you want to make sure your students have grasped (most of) it. Wouldn’t it be easy to have a system that designs and administers the form for you?

Google thought it would be, and that’s why the came up with Google Forms. Accessible through Google Drive, Google Forms allows users to design and administer “forms”. Pedagogically speaking, forms can take the shape of quizzes or polls, and Forms will even collate and organize the data for you.

To learn more, watch the CTRL instructional video on Google Forms here:

Creating a Chart in Google Docs

Step away from Excel for a few minutes and marvel at the chart building possibilities available on Google Docs.

If you have a Google account (and if you’re an AU student, of course you do), log into your Google account and get to Google Docs. You know that you can upload text files and spreadsheets there. Click on one of the spreadsheets you have (and if you don’t have one uploaded, you can take a spreadsheet you’ve been working on in Excel and upload it to Google Docs).  Up at the top is a little button that looks like a red and blue bar graph. That is where the magic happens.

Click on the “Chart button” and begin building your chart. You can choose from line, bar, pie, trends, map, and other graph options.

On your spreadsheet, select the data you want to include in your chart. Or, you can do that under the “Start” tab once you’ve opened the Chart box.  Google Docs will recommend a chart for your first, but if you decide that is not what you want, you can move on to the “Charts” tab and select another option.  (Google Docs will even let you know if a certain chart is not possible with the data you provided). You’ll be able to preview the chart once you’ve made a selection. Create the title and other labels for your chart in the the “Customize” tab.

When you’re happy with the chart you built, click on “Insert” and it will appear on top of your spreadsheet.

It’s that easy!

For more instructions, read it from Google themselves.