Home » Google » ELA – 4 Google Sheets Essential Skills

ELA – 4 Google Sheets Essential Skills

ELA teachers you NEED spreadsheets!! Google Sheets is just like a Google Doc but better. It is a big table. Have students organize their work in Google Sheets!

1. Make Columns Wider

You might think Google Sheets is not for you because you need full sentences and a spreadsheet has these little tiny boxes. Make the column wider!!! Get your cursor in between two columns and drag the column so it is wider.

2. Word Wrap

The most essential skill for Google Sheets to help you love spreadsheets is Word Wrap. You can not be an ELA teacher using spreadsheets and not use this one! First, look for the CENTERING icon in the toolbar. This is the same icon as in Google Docs for centering text. The icon to the right of that is vertical centering (another favorite of mine.) The icon to the right of that is WORD WRAP!!

3. Merge Cells

PUT YOUR ANSWER IN THE BIG BOX! I use merge cells a lot. Take one tiny cell and combine it with a bunch of cells. Make a giant answer box! Highlight a bunch of cells. Look for a broken square with 2 arrows in it. This will merge the highlighted cells into one big cell. Use the paint can to shade the giant box so students know to put their answer in there.

Tip: Click on ONE cell, hold down the shift key and use the arrow keys to select multiple cells.

4. Automatic Numbering

You do not need to use any numbers or math to use spreadsheets. Spreadsheets are for everyone! . Now while you do not need math, sometimes it is helpful to organize your document by numbering questions or steps. Google Sheets will do this for you! You want to establish a pattern in the spreadsheet of at least 2 numbers. Highlight the pattern and then use the fill down square in the bottom corner to pull down and continue the pattern.

Better Progress Reports Webinar
Free OTIS Webinar: Better Progress Reports

Join Alice Keeler December 9th, or watch the recording afterwards, for a FREE OTIS webinar on better progress reports in Google Classroom.

Google Jamboard: Bring It UP

A key element of Google Jamboard is the ability to add sticky notes to share ideas. However, layers in Jamboard will hide content. Knowing how to alternate what order elements on the Jam are in provid…

3 Google Sites Things to Try

Google Sites is a great way to provide students tutorial documents. Try these 3 features to customize your Google Sites pages.

How to Create Google Slides Games

Free Game templates for Google Slides that use Dice. Install Dice Slides by Schoolytics to have Google Dice.

Connect Your Class to Formative

Easily create formative assessments digitally with formative.com. Sync your Google accounts to Formative.

1 thought on “ELA – 4 Google Sheets Essential Skills”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.