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 – Print Google Form Quiz

Have more control over how your Google Form™ Quiz prints. Sometimes you need your Google Form on paper and this solution will help you to do it better! Print Google Form Quiz to a Google Doc and custo…

Something Fun for the End of the Year

What is something fun for students to do at the end of the year? While there are many choices, a fun word search can give students something to do while other students are finishing a task. Try my tem…

Collaborate with Students – reuse TemplateTab

Reuse TemplateTab to collaborate with students and have less paperwork to grade.

First S

CS First is a great way to get started with teaching students computer science even if you as the teacher do not have experience with coding or computer science. First s … science! It is critical th…

4 Tips for Google Bookmark

4 Tips for Google Bookmark. If you use Chrome here are some ways to use the Bookmarking feature.

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.