Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Organizing Student Group Projects

Organizing Student Group Projects

YouTube video

I like to arrange students in groups, however I am lazy. I do not like typing “group 1,” “group 2,” “group 3,” etc… It’s repetitive  Anything repetitive  I have to ask myself… there must be a better way!

My answer to pretty much everything is to use a spreadsheet. First I will type a 1 and then a 2 into two cells on the spreadsheet. Highlight the 2 cells and grab the box in the bottom right corner and fill down to finish out the pattern.

Then in adjacent cells I type the repetitive text, however I will do this as a formula. All text must be in quotation marks.

=”group ”

Notice the spacebar after the p.

One of the best words ever invented… “concatenate.” Not only does it sound really cool, it does magical things. Concatenation joins things together. While there is an =concatenate(  function, I never use it. I always use the symbol for AND (&).

=”group “&A1
=”group “&A2
=”group “&A3

Now, remember that I am lazy, I don’t actually type that 3 times. I only type it once, grab the box in the corner and fill down.

Using concatenation I have saved myself at least…. 2 minutes of typing. However, I can extend that out and save myself some serious time if I have a lot of groups. But even if I only have to do it 5 times, I dislike repetitive tasks and spreadsheet magic makes me happy.

Before you get too excited, realize that you now have a list of formulas. If you delete the 1, 2, 3, 4…. then your text becomes messed up. After you have the text looking the way you want it to, highlight the cells containing the text. Copy (command C). RIGHT CLICK and choose paste special -> paste values. This will strip out the formula and leave you just with the text you wanted. Now you can delete the 1, 2, 3, 4….

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

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