Hi , The 🔚end of the semester is near for many of us and its a great time to review concepts and engage students using 🎲games. Try out some of the 🕹️games I have created digitally. Also, follow the hashtag #EdTechCruise🚢 beginning now, to discover tranquility amid the 🌊waves of education. Lastly, Figma.com now has a converter ⚙️tool that converts your Jams to Figjam quickly and efficiently. ✅Check out the video.

Figjam Converter Video

🎲🎲♠️♠️GAMES! Yahtzee in Google Sheets, Battleship in Desmos, Farkle in Sheets/Slides,

🎟 The passcode is winteriscoming

PLEASE SIGN IN! I respond

☀️ What Is Up This Week

1. 🖊️SIGN IN with the passcode winteriscoming
2. 📅 Be added to the events calendar for the week. (do this every week!)
3. 🔺 Premium Add-on: Play Connect 4 in Google Sheets

4.💧 🆕Drip Workshop-One Lesson Per Week (online course) Go Slow for the Holidays

5..☑️Check alicekeelermembership.com with passcode winteriscoming for resources & events.

6.⏺️ Webinar Recording with Alice: How To Change the Background in Google Meet

7.⏺️ Webinar Recording with Alice: The Goal is NOT DOK 4

8.✅ Check out: Jeopardy in Figjam

🤝Share A Copy of a Google Form

🔵1)📁 Put your Google Form in a folder--Press F in Google Drive for a new folder
🟣2) Change folder 🤝sharing permissions to View access
🟠3) Share Form 🔗link with /copy instead of /edit at the end
🟡Sample: https://docs.google.com/forms/d/1F6EKgeGpze2QQDxzd3-SCgUhV8ihPgo2l7Y8-zvzoas/copy…

🆒 Word Wrap in Google Sheets❇️

🔑A key skill to know when using Google Sheets is how to wrap the text within a cell. You want to be able to view all of the text that is in your spreadsheet and not have any of cut off. Setting word wrap can be a bit tricky until you know where to look.

Word Wrap In Google Sheets Video

⚙️Setting Word Wrap

🟪By default the text in a cell will spill into the next cell. This is particularly problematic because if you put content into the next cell your text will be cut off. It usually does not make sense for your text to be cut off. Note that “cut off” is not literal, the text is still there. Double click on the cell to view the full text. The extra characters are simply cut off from viewing.

🔍Find the Icon

🟥Setting word wrap starts by selecting the cell or range of cells that you wish to have wrapped text in. In the toolbar, look for the centering icon.

👀You may not see the icon if your screen width is too small. In that case, you will see 3 dots in the toolbar. 🖱️Click on the 3 dots to see more icons, including the centering and wrap icon.

🔷The centering icon is generally well known to people and is easy to spot in the toolbar. The icon to the right of the centering icon is an arrow pointing down to a horizontal line. That allows you to center your text vertically, another favorite of mine. The icon that is to the right of that is the text wrapping icon.

3️⃣3 Options

The default option is to overflow the text from the one cell to the next cell, if the next cell is available. This is only visually and does not actually put the text into the next cell. The value of the cell to the right remains blank.

🟨The middle option is the one you want, it wraps the text in the cell.

🟩The 3rd option is to cut off your text. I will use this for cells where I am pasting long URL’s and it doesn’t matter for the person to see the full URL.

📏Adjusting Column Width in Google Sheets

🟪It is also helpful to be able to adjust the width of the column. If you have a lot of text in your cell than a width of 120 pixels will be very difficult to read, even when the text is wrapped.

Hold your 🖱️mouse between the column indicators. Click and hold the mouse down to drag the width of the column wider.

Adjusting The Column Width Video