Design your Google Forms to provide immediate feedback by utilizing branching options. Create multiple sections in your Form and add only one question per section that determines which section to jump to next. Answer correctly and the branching should take the student to the next question. Answer incorrectly and be taken to a section […]
Twitter chats are a great way for educators to interact with other educators. Interacting with teachers not just at our school widens our access to ideas, resources, and teaching techniques. I have created a spreadsheet to help you moderate or participate in a Twitter chat. Template alicekeeler.com/twitterchat Moderating a Twitter Chat A twitter chat
My good friend Christine Pinto was telling me she was having her Kindergartners do some pumpkin activities this week in anticipation of going to a pumpkin patch. I thought alicekeeler.com/pixelart would be a fun way for kids to make a pumpkin since after all, the answer is always a spreadsheet! Using my pixel art template
You have more than one spreadsheet of data. You need the information from one spreadsheet to interact with the data in another spreadsheet. There are 2 ways to do this in Google Sheets. Copying and pasting from one spreadsheet to another has the problem that if the data in the other spreadsheet is updated then
When pasting text into a spreadsheet sometimes you do not want one cell to have all of the text. The best example being when you have first and last name in the same cell. Data Menu Highlight the cells that have text you wish to split up. Use the Data menu to choose “Split text
I want to fully live in the cloud. I want ONE version and 100% confidence that it is the correct version. NO COPIES. I do not want to work on a document, share it with someone else and we have two different versions, different documents. If I make updates whoever I shared it with
Google Sheets Checkboxes Checkboxes in Google Sheets has become a spreadsheet staple! Incredibly easy in Google Sheets. Highlight the range you want checkboxes and use the Insert menu to choose “Checkbox.” True or False The checkboxes are the value of the cell. When checked the value is true. When not checked the value is false.
In the modern world collaboration and getting along with a team is essential. Assigning students to group work can sometimes be tricky. Use my Add-on GroupDocs to assign students to groups and give each group a copy of a collaborative document. alicekeeler.com/groupdocs Steps Make a copy of the template. Set the group size. Copy and
Use Google Sheets to create multiple, different, Bingo boards from your own list. Template alicekeeler.com/bingo As with all Apps Script coding projects you need to wait a minute for the code to load. Look for the “Bingo” menu to load up next to the Help menu. Choose setUp and authorize the Add on. 25 Checkboxes
