Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Add Bitmoji to Your Google Sheets

Bitmoji Google Sheets

Add Bitmoji to Your Google Sheets

Bitmoji Google Sheets

In Google Docs and Slides you can DRAG Bitmoji from the Chrome extension right onto the document. Not true for Google Sheets.

Insert Drawing

One way to add Bitmoji to your spreadsheet is to use the Insert menu and insert a drawing. You can then DRAG your Bitmoji right onto the drawing canvas and the Bitmoji floats on top of the spreadsheet.

=IMAGE()

If you want the Bitmoji IN the cell you want to get the Image Address. Click on the Bitmoji Chrome extension and right click on your Bitmoji of choice and choose “Copy Image Address.”
copy image address

Merge Cells

If you use =image(“https://render.bitstrips.com/v2/cpanel/10139707-128960944_3-s1-v1.png?transparent=1&palette=1” in a cell it will be really tiny! Your picture will be the size of the cell. TIny bitmoji

Instead, first merge some cells together to give you a large BOX for your Bitmoji.
Merge Cells

In the large block of cells now use the formula =IMAGE(”
Notice the quotation mark

Paste the image address of your Bitmoji you copied from the Chrome extension. End with a quote and parenthesis. Press enter.

=IMAGE(“https://render.bitstrips.com/v2/cpanel/10139707-128960944_3-s1-v1.png?transparent=1&palette=1”)

 

 

 

 

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 »

2 thoughts on “Add Bitmoji to Your Google Sheets

  1. Interesting! When I tried the code above (which totally worked last week in your Sheets Go Slow course) it gave me an error today and only worked after I added in a value for the mode (4), the height in pixels, and the width in pixels.

    =image(“https://render.bitstrips.com/v2/cpanel/7973988-124582861_5-s4-v1.png?transparent=1&palette=1”, 4, 398, 398)

Leave a Reply

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

%d