Introduction to Google Sheets

Google Spreadsheets allows you to organize, edit and analyze different types of information using spreadsheets. In this lesson, you’ll learn about the different ways you might use spreadsheets and how to navigate the Google Spreadsheets interface. You’ll also learn the basic ways to work with cells and cell content, including how to select cells, insert content, copy and paste cells, and more. Watch the video to learn how to navigate the Google Spreadsheets interface.

Every row and column of a new spreadsheet is always set to same height and width. As you begin to work with spreadsheets, you will find that these default sizes are not always well-suited to different types of cell content. Watch the video to learn about modifying columns, rows, and cells, including wrapping text and merging cells.

A quick how-to guide for sorting and filtering in Google Spreadsheet

A convenient and time-saving feature of Google Spreadsheets is its ability to add, subtract, multiply, and divide numerical information for you. Spreadsheets uses mathematical expressions called formulas that make handling these calculations easy. In this lesson, we are going to focus on formulas that contain one mathematical operator.

Most of the time you will be using a cell’s address in the formula. This is called using a cell reference. The advantage of using cell references is that you can change a value in a referenced cell and the formula will automatically recalculate. Using cell references in your formulas will make sure the values in your formulas are accurate. Watch the video to learn how to work with simple formulas in Google Spreadsheets.


Collaborative Editing – Docs, Sheets, Slides

If you’re not using the collaborative features of Google Apps, you’re not getting your money’s worth.

If you’re used to Track Changes, we’ve got Suggested Edits, which allows comments and responses to changes. We also have Comments, which you can tag people in. Did you know you can format font in comments as bold, italics, or strikethrough?

And if the idea of collaboration makes you nervous, check out Revision History. You can flip back and forth between different versions of your document, spreadsheet, or slides.

Google Forms – Getting started

I consider Forms the unsung hero of Google Apps. Users tend to get stuck in the Google Docs world and may not even realize this program exists. Forms is a very useful program with many classroom applications.

If you want to explore Forms on your own, this video (9:05) will get you started, but I feel it leaves out some important information that can make Forms easier for you. My suggestion, poke around Forms for a short while (like 10 minutes), and then contact me before you roll-out your first classroom activity so we can fine tune things a bit. I’m sure you’re going to like this program.

Update: 7/2/15 An alternative video about getting started with forms.