Now that you have collected and organized your data it is time to share it. Data that only lives on your Google Drive is not impactful data. This page will cover how to get your data to your different stakeholders.

1. Visuals are always best. Believe it or not a lot of people do not like looking at spreadsheets. The more visual you can make your data the better.

2. Think about what the end user needs to know when you create graphs or share data. Always keep in mind student privacy laws when sharing data.

3. If you add charts to Google Docs or Slides always link the chart. Doing this will allow you to update the chart with one click instead of having to recreate the entire thing.

4. You can set up charts before you data is populated into your sheet. Below are two examples of charts that I made before this session started. As people completed the form at the beginning of the session the charts updated. This is a huge time saver and gives you real time feedback!

Your To Do:

1. Create a chart that summarizes the session demographics.

How to Create a Chart in Google Sheets

The explore feature allows you to quickly analyze your data. This is a great feature for quick charts.

Steps:

1. Highlight the range of the data you want to explore.
2. Click on the explore button in the bottom right corner.

If you want to have more control over how your chart looks you will want to use the chart builder. If you are not sure what type of chart you should create Google Sheets will give you chart recommendations based off your data.

Steps:

1. Highlight the range of the data you want to use to create your chart.
2. Click on insert in the menu and then chart.
3. Select the type of chart you want to insert. You can customize your chart to fit your needs.

Examples of Custom Charts Created in Google Sheets

Your To Do:

1. Protect the summary sheet so only your group members can modify the data.

How to Protect a Sheet

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 an entire sheet so only certain people have the ability to modify the data.

Steps:

1. Click on the upside down triangle next to the sheet name at the bottom of the screen.
2. Select protect sheet. This will open up a sidebar menu.
3. Click on the green set permissions button.
4. Select the permissions you want to have applied to your sheet.
5. Click on Done.
6. You will now see a lock next to the protected sheet.

Your To Do:

1. Protect a range of your data so people can not edit the range.

How to Protect a 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 an entire sheet so only certain people have the ability to modify the data.

Steps:

1. Click on the upside down triangle next to the sheet name at the bottom of the screen.
2. Select protect sheet. This will open up a sidebar menu.
3. Click on the word Range.
4. Click on the green icon to select your range. When you are done click on ok.
5. Click on the green set permissions button.
6. Select the permissions you want to have applied to your range.
7. Click on Click on Done.
8. You will now see a lock next to the protected sheet.