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 […]
Twitter Chat Template – Teacher Tech Read More »
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
Fall into Pumpkins – Teacher Tech Read More »
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
Linking Data Sets in Different Google Sheets Read More »
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
Google Sheets: Text to Columns in a spreadsheet Read More »
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.
Checkbox: Check It – Teacher Tech Read More »
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
GroupDocs: A Copy Per Group Read More »
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
BINGO! – Teacher Tech Read More »
A theme has been consistently popping up in my day to day conversations regarding the rapid pace of the digital marketing world. These discussions have gone on to expand upon how difficult it is to keep up. Today, the Twittersphere was abuzz sharing an ebook titled, “It Doesn’t Have to Be Crazy at Work,” published
Keeping Up in the Digital Marketing World Read More »
During a recent dive into an auction insights report for one of my clients, I noticed that one of our top paid search competitors was declining in impression share. Our Search dominance was prevailing and I proudly looked down on the competitor <10% stat. I was excited to share the news with my client, but
Ways to Gain Competitor PPC Insights Read More »
Many advertisers today are looking for ways to create their sales funnels within platforms for several reasons. It helps reduce friction, keeping users within the platform and eliminating issues with conversion-rate optimization and bounce rate once the user lands on a webpage. It also avoids issues with using potentially sensitive customer data to build a
Building an In-Platform Facebook Funnel Read More »
