Session Companion Guide


Table of Contents

Collecting Data

Copy To

Import

VLookUp

Manipulating Data

Text to Columns

Concatenate

Freezing Rows/Columns

Text Wrap

Conditional Formatting

Formulas You Must Know

Sorting Your Data

Filtering Your Data

Sharing Data

Protect a Sheet or Range

Visualizing your Data

Publish

Embed


Presenter Info

Ryan Bradford

@mrbradfordtech

www.mrbradfordonline.com

Collecting Data

Copy To

Import

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

This feature allows you to import other Google Sheets files or upload Excel and csv files into your Google Sheet.

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

Text to Columns

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.

Freezing Rows/Columns

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.

Conditional Formatting

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.

Sorting Your Data

Filtering Your Data

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

Visualizing your Data

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.  

Publish

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