Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Create A Student Response Box

Google sheets merge cells

Google Sheets: Create A Student Response Box

Google sheets merge cells

Google Sheets Merge Cells

One of my favorite things is spreadsheets. Spreadsheets are great tools for students to use to organize information. When creating a spreadsheet template it can be helpful to create a box for students to enter a text response. The default size of a cell in a spreadsheet is too small for more than a word or two. Merging cells together to make a large response box is easy and dare I say fun!

Select Range

In the spreadsheet, select the range (group) of cells you want to be merged together into one giant cell.
Select or highlight a range of cells

Using the trackpad on a laptop can be tricky. You can click on one cell and hold down the shift key while using the arrow keys to select your range. Another trick is to click on the upper left cell, hold down the shift key and then click on the lower right cell for the range. This will select the entire range.

Merge Icon

Merging cells is as easy as clicking on the merge icon in the toolbar. It looks like two rectangles fighting.
merge cells icon

Paint Can

My general MO is to have a yellow cell where I want students to fill something out. Click one time on the merged cell and click on the paint can in the toolbar to fill it yellow.
Fill the cell yellow

Centered

By default, the text in the response box is small and in the bottom left-hand corner. In the toolbar are 2 icons for centering. The well recognized icon to center horizontally is to the right of the merge icon. Next to the horizontal centering icon is the vertical centering icon. I recommend centering vertically in the middle and probably horizontally.
text in bottom left

Word Wrap

Since this giant merged cell is for a text response box you will want to turn on word wrapping. The icon to the right of the vertical centering is the word wrap icon. Choose the middle option.
word wrap Google Sheets Merge Cells

Google Sheets Merge Cells

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.

%d