Tag Archives: sheets

Google Sheets: Rotate Text

rotate text google sheets

Google Sheets: Rotate Text Google has been on a roll adding new features to G Suite and Google Apps that you’ve been desperate for! First, you can add videos to Google Slides from Google Drive and now you can rotate your text in Google Sheets. Formatting Text rotation formats the text. You will find options […]

Read more

Google Apps: Create a Copy for EACH Class

CopyDocs for Classes by Alice Keeler

Google Apps: Create a Copy for EACH Class If you teach multiple sections of the same class you might find yourself making a copy of a collaborative template for each class. This can be tedious. CopyDocs for Classes My Add-on script CopyDocs for Classes does the hard work for you. Simply pick the Google Docs, Sheets, […]

Read more

Quickly Create 7 Copies of DiscussionTab

-Discussion Tab multiple classes

My DiscussionTab template allows you to facilitate class discussions using Google Sheets. Create a list of discussion questions in Column A (and tab names in Column B) and run the DiscussionTab menu to create a sheet for each question. Share the spreadsheet with the class with editing permissions. Template alicekeeler.com/discussiontab  Multiple Classes If you teach multiple […]

Read more

Mock Twitter Chat with Your Students

mock twitterchat with discussiontab

Mock Twitter Chat with Your Students I love Twitter chats. They are exactly one hour Allow for everyone’s voice to be heard It is okay to have a side conversation about one part of the topic to go deeper while the rest of the conversation continues Guaranteed to get through 5-10 questions in an hour […]

Read more

Self Reflection Reading Goals @JSerravallo

reading self reflection tool

Self Reflection Reading Goals @JSerravallo I saw this tweet about Jennifer Serravallo’s Reading Goals Self Reflection form from her book. My first thought is of course that this would be better as a Google Form. My biggest beef with PDF’s is they do not collect data. Switching to a Google Form allows the teacher to […]

Read more

TemplateTab: All Students on One Spreadsheet

templateTab

View Upcoming events at alicekeeler.org for TemplateTab workshops. TemplateTab TemplateTab is an Add-on script I wrote to make it easier to have all students working on the same spreadsheet. Instead of collecting 30 digital documents, you have ONE where all students contributed to the same one. This makes it easier to manage digital work and […]

Read more

Google Classroom: Pull Student Paragraphs and Give Feedback

google classroom pull student responses

Google Classroom: Pull Student Paragraphs and Give Feedback I like to joke that the “Make a copy for each student” option is really the “Make a giant pile of paperwork for yourself” option. When you ask students to use the “Create” button and create a Google Doc or you give them a template on a […]

Read more

Google Sheets: Split and Transpose

google sheets split and transpose

Google Sheets: Split and Transpose This Google Sheets trick helps you to extract lines of text out of a single cell and have the text in individual cells. Rubric Where I was doing this was using a rubric. Multiple criteria were entered into a single cell, but this made it difficult to mark each of the […]

Read more

Google Sheets: Pixel Art Trick

pixel art trick

Google Sheets: Pixel Art Trick Students love using pixel art. It is basically paint by number. There are lots of ways for students to use pixel art for academic reasons. Check out this brownie division activity adapted from a Jo Boaler Mathematical Mindsets activity. To represent their understanding of division multiple ways students use the […]

Read more

Insert Drawings into Google Apps

drawing google apps

Insert Drawings into Google Apps I live for collaboration and feedback conversations instead of comments. This is what I love about using G Suite with Google Apps. Instead of scribbling comments onto a kids paper that they probably do not get a lot of learning out of, switching to inserting comments in a Google Docs, […]

Read more

Google Sheets: Split Text to Columns

split text to columns

Google 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 […]

Read more

Google Sheets: Construct Formulas with the INDIRECT Function

Indirect Google Sheets

Google Sheets: Construct Formulas with the INDIRECT Function One of many things that is great about spreadsheets is the ability to use formulas to create patterns. This can oftentimes be a huge timesaver from manually typing a long list. For example, if I have first names in one column and last names in another column I […]

Read more

Google Sheets: Select a Range

google sheets select a range

Google Sheets: Select a Range Using a trackpad in Google Sheets to select a range of cells can sometimes be tricky. Here are a few tricks to select a range of cells. Range Each cell has an address such as A1 which is the first column, first row. B10 is the 2nd column, 10th row. […]

Read more

Math Puzzle, Get Students Thinking

math puzzles strategic thinking

Math Puzzles, Get Students Thinking Google Home was just introduced, this allows you to shout out questions to the universe and have the answer. Wouldn’t it be interesting to get a Google Home for the classroom so students could shout out “Ok Google, what is the perimeter of a square with a width of 7 […]

Read more

Google Sheets: Merge Data into One Column

onecolumn google sheets spreadsheet merge columns of data

Merge Data into One Column Sometimes I need to have a need to take columns of data in a spreadsheet and put them into one column. What I normally do, if it isn’t a lot of data, is use Control-X to cut out one column of data and put it underneath the other. However, why […]

Read more