Session Companion Guide

Collecting Data

Copy To

Import

VLookUp

Manipulating Data

Text to Columns

Concatenate

Freezing Rows/Columns

Text Wrap

Conditional Formatting

Formulas You Must Know

Sharing Data

Protect a Sheet or Range

Publish

Embed

Presenter Info

Collecting Data

Import

The Copy To function copies a sheet from one Google Sheets file to another.

VLookUp

VLookUp is a formula that allows you to look up data in a range. This is your secret weapon for surviving the Datapocalypse because it saves you time!

How to write the VlookUp Formula

Manipulating Data

Concatenate

Text to Columns separates fixed-width text into multiple columns. This is super helpful for separating a single student name column into first and last name columns.

The CONCATENATE function takes data from different cells in a spreadsheet and combines the data into one cell. This is super helpful for combining first and last name columns into a student name column.

Text Wrap

Freezing a row/column keeps the data in the same place as you scroll through the sheet. Freezing the header row is highly suggested when you are working on large sheets.

Text wrapping allows you to see the full value in a cell without having to change the cell’s width. It does change the cell’s height.

Formulas You Must Know

Conditional Formatting is a tool that will automatically format your cells based off the value of the cell. Conditional Formatting is helpful for quickly color coding your data.

You can conditional format after your data is entered.

You can also conditional format your cells prior to entering your data.

Countif

The countif formula is great for creating summaries of your data. The formula looks in a specific range for data that meets certain criteria.

Sum

The sum formula adds together the numerical values of different cells. This formula is helpful for counting the total number of students in a column

Average

The average formula will calculate the average for a range of cells. This formula is helpful for quickly seeing how your class did on an assessment.

The quickest way to sort data is to organize it based on alphabetical or numerical order. You can sort your data from A-Z/Largest number to smallest number or Z-A/Z smallest number to largest number.

Sorting a range is helpful when you are trying to organize your data based off the data in two columns. In the example below I sorted the data by period and then by scores.

When you quickly want to hide information you can use a filter. A filter will temporarily hide data on your sheet so you can focus on the information that you select.

Sharing Data

Protect a Sheet or Range

One of the most frustrating parts of sharing a collaborative spreadsheet is having someone delete or modify a cell. To prevent this from happening you can protect a sheet or a range.

Protecting a Sheet

Protecting a Range

If you need certain people to have editing access to a protected sheet/range you can give them permission to edit the protected sheet/range.

This feature allows you to quickly analyze your data. Highlight the data you want to analyze and then click on explore in the bottom right hand corner.

If you want to be more specific with what data you are visualizing you can create a chart. If you are not sure what type of chart you should create Google Sheets will give you chart recommendations based off your data.

Embed

Publishing your document makes the document visible to anyone on the web. This feature is helpful for when you want to share your data but don’t want to share the spreadsheet.

Example of a published sheet

This feature allows you to place an interactive copy of the spreadsheet on a webpage.

Example of an embedded sheet