Teacher Tech

Paperless Is Not A Pedagogy

Menu
  • Teacher
    • Blog Posts
    • Teacher Tech Facebook Group
  • Google Certified Innovator
    • CoffeeEDU
    • Tour of Google Classroom
    • Back to Classroom
  • Author
    • Alice Keeler Books on Amazon
    • Bulk Order Books
  • Developer
    • Schoolytics
    • Google Developer Expert
    • Add-ons By Alice Keeler
      • Doc to Slides by Alice Keeler
      • Roster Extras by Schoolytics
      • TemplateTab
      • toTabs
      • Form Printer
      • Quiz Helper
      • Dice Slides by Alice Keeler
      • Scheduler by Alice Keeler
      • Document Outline by Alice Keeler
      • Missing From (Google Forms™)
      • Randomize Slides by Alice Keeler
      • Speaker Notes by Alice Keeler
      • sheetPusher
      • Seating Chart Slides
      • Hyperlink Slides Choice Board
      • Add-a-Date
      • QuickShare Screenshot
      • Anyone Can View
      • Drive 20
    • Apps Script Tutorials
    • Templates
  • EdTech Coach
    • Premium Membership
    • Free Newsletter
  • Hire Alice
Menu
A spreadsheet a week google sheets alice keeler

Try A Spreadsheet A Week

Posted on June 7, 2018November 4, 2018 by Alice Keeler

A spreadsheet a week google sheets alice keeler

Use Spreadsheets

What can you NOT do in a spreadsheet? It’s just a big table. You can do almost anything in a spreadsheet. Best way to get started using spreadsheets is USE THEM! I challenge you to create and use a spreadsheet at least once a week. Just type text into it.

If you’re making a list… spreadsheet.

If you’re brainstorming… spreadsheet.

If you’re planning something… spreadsheet.

Make a Spreadsheet

sheets.google.com/create

There are many ways to create a spreadsheet. Go to Google Drive, click on the New button and choose “Google Sheets.” You can use the Google Sheets app on your phone. You can go to sheets.google.com. And there are some Chrome extensions that help you create Sheets and other Google apps quickly.

Assign a Spreadsheet in Google Classroom

If you are a Google Classroom user you can ask your students to create something in a spreadsheet. “Click on open, click on the Create button and choose Sheets.” Students can write their answers to questions in a spreadsheet, it’s a big table!
Create Sheets

Make the Column or Row Wider

Notice the letters at the top (column indicators) and the numbers on the left (row indicators). If you hover your mouse in between the columns notice your cursor turns into an arrow. Hold down with your mouse and drag right or left to make the column/row wider or skinnier.
Making columns and Rows wider

Word Wrap

Setting word wrap in a Google Sheets spreadsheet is a super handy skill. Click on the cell (or cells) that have a lot of text in them. Go to the toolbar and find the familiar centering icons and look to the right of it. Look for word wrap

The text wrapping icon looks like a line with an arrow cutting through another line. IF the cell to the right of the cell you are typing in is empty, your text will spill over into the adjacent cells. HOWEVER, if you type something into the cell next to that cell, your text will be clipped or cut off.

word wrap

Click on the tiny triangle next to the text wrapping icon to choose “Overflow,” “Wrap,” or “Clip.” I usually choose wrap. And if you’re feeling like having a little fun, have your mouse slide to the right one more icon to set the text rotation.




Merge Cells

It can also be handy to make a BIG GIANT BOX to type stuff in. Highlight a range of cells and use the merge icon in the toolbar to create a big spot to type in. Look in the toolbar for the paint can icon. To the right of that is the borders icon. To the right of that is the merge icon! It looks like a square with 2 rectangles pointing at each other.
merge cells

Add a Sheet

Google Sheets spreadsheets are MULTIPLE PAGES! Super handy! Look in the bottom left and notice the plus icon to “Add Sheet.”
add sheet google Sheets

Control Z

Spreadsheet users must be masters of Control Z! Control Z is the keyboard shortcut to UNDO! When you single click on a cell and press something on the keyboard it deletes everything in that cell and replaces it with what you’re typing. It’s pretty easy to accidentally do this. No worries, Control Z puts it right back to the way it was supposed to be.
Spreadsheets COntrol Z

Spreadsheet or Not

Tweet me @alicekeeler with spreadsheet or not 🙂 I’ll let you know that you should do that in a spreadsheet (or not… there are some legit reasons a spreadsheet is not the right tool.)




Related

Related Alice Keeler Blog Posts:

  1. Google Sheets: Fill Down Square
  2. Go Slow: Spreadsheet Workshop
  3. 5 Google Sheets Essentials
  4. Google Sheets: Check Multiple Checkboxes At The Same Time

Continue Reading

Next Post:
Get Google Certified with @shakeuplearning
Previous Post:
Google Docs: Press Enter a Whole Bunch of Times

2 thoughts on “Try A Spreadsheet A Week”

  1. Pingback: What Is Going On In This Graph from the NY Times - Teacher Tech
  2. Pingback: Google Sheets: Code Adding Content to Multiple Tabs - Teacher Tech

Leave a Reply Cancel reply

You must be logged in to post a comment.

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

Alice Keeler is a mom of 5. Current High School math teacher. Developer for Schoolytics.com. Google Certified Innovator, Microsoft Innovative Educator, Google Cloud Innovator Champion, and Google Developer Expert. Founder of #coffeeEDU
Teaching with Google Jamboard
Developer Schoolytics
Schoolytics is FREE for teachers.

Find ALL My Blog Posts


Link to List

Google Classroom Books

Alice Keeler: Mom of 5. Current High School math teacher. Developer for Schoolytics. Founder #coffeeEDU. Google Certified Innovator. Microsoft Innovative Educator. Google Developer Expert. EdTech Specialist.

My Referral Links


Custom Stickers, Die Cut Stickers, Bumper Stickers - Sticker Mule

 

©2022 Teacher Tech | Theme by SuperbThemes