Google Sheets

Click here to learn how to get started with Google Sheets

Switching from Excel to Google Sheets...Click here!

My Life’s Complete with Forms and SheetsMy Life’s Complete with Forms and Sheets bit.ly/aetcsheets

Productivity Tools

Activities

Google Sheets: Split and Transpose - Teacher TechNeed to split up your data that is in a single cell? This will split it up horizontally. Use transpose to turn that split data vertically. Google Sheets.

Google Sheets: Split and Transpose - Teacher TechNeed to split up your data that is in a single cell? This will split it up horizontally. Use transpose to turn that split data vertically. Google Sheets.

Google Sheets: Find Unique Entries - Teacher TechFilter your Google Form data to pick unique entries for a raffle. Add a random number. Sort the range in Google Sheets pick a winner

Bring In a Google Doc into a Spreadsheet - Teacher TechUse this template Get Docs to create a spreadsheet that pulls in the text from multiple Google Docs at once into a single list.

Google Sheets: Split Text to Columns - Teacher TechGoogle Sheets: Split Text to Columns When you copy and paste into Google Sheets you will notice an option will automatically appear allowing you to split the text into columns. Choose the delineator and poof, text is split. Data Menu You can also manually activate text to columns by highlighting your data and choosing “Split …

Google Sheets: It's A Worksheet Game- Help Me - Teacher TechUse this Google Sheets worksheet game template to ask students questions, have their avatar move around the game board and then send feedback.

Google Sheets: Pixel Art Trick - Teacher TechTry this pixel art trick. Hold down shift to select a range of cells. Hold down the control key and press enter to duplicate the value in the upper left.

Google Sheets: Students Protect Their Work - Teacher TechI am a big fan of collaborative documents. Having all students in the class on the same spreadsheet allows you to collect student ideas and crowdsource information. Once concern about collaborative documents is students accidentally deleting each others work. If a spreadsheet is explicitly shared with the students, Google Classroom does this automatically, the student …

Ten Frames Activity in Google Sheets - Teacher TechUse Google Sheets spreadsheets with students as young as four to use ten frames and write formulas to check their work. Math and conceptual understanding.

Google Sheets: Pixel Art Template - Teacher TechUse this Google Sheets Pixel art template to allow students to model their understanding.

Try This It's Easy - Google Sheets: Count Stuff - Teacher TechGoogle Sheets can be used by even the most basic users. Quick activity is to use Google Sheets count stuff quickly. Create a chart, insert in Google Slides

Report abuse