EdTech Links of the Week - 9-26-22

Each week I keep an eye out for the latest edtech resources through blogs, social media, podcasts, videos, user groups, and more. I then try to reshare these resources in many ways.

One way I share these is here on the blog in these "EdTech Links of the Week" posts. See below to explore the latest batch of resources, and be sure to share with others who may benefit.

If you want to make sure you don't miss new resources, you can:

📰 Sign up for my weekly email newsletter here: Newsletter link

🐦Follow me on Twitter here: Twitter link

🔗 Subscribe to the RSS feed for this blog here: RSS feed link

And as always, please let me know of any resources that you recommend. I would love to learn from you!

My 2023 FETC Sessions

I am excited and honored to be presenting at the Future of Education Technology Conference (FETC 2023) in New Orleans, Louisiana on January 23th through 26th, 2023.

I always look forward to an opportunity to see old friends, make new friends, share some ideas, and learn so many new things from others.

You can register for FETC at https://www.fetc.org/

Below is a list of sessions I will be presenting at FETC 2023, along with any associated resources. Please feel free to join me for any of these sessions. I look forward to sharing, learning, and chatting with you!

Google Sheets in 20 Minutes

Google Sheets is easily one of the most powerful tools in the Google Workspace suite of programs. I use it every day in one way or another.

It can be used for many tasks such as:

• Analyzing student data to identify at-risk students
• Tracking student behavior
• Managing inventory
• Collecting attendance from a PD session and generating certificates
• Providing conditional formatting feedback in learning activities
• Building a learning database for students to draw conclusions from
• Making pixel art
• Creating interactive learning games and activities
• And much more!

Unfortunately many people can feel intimidated by spreadsheets and not be sure where to begin. I want to take that fear away and help ease you into the wonderful world of spreadsheets!

To help with, below you will find a 20-minute crash course video on Google Sheets where we cover topics including view options, freezing rows and columns, sorting data, filtering data, formulas, charts and graphs, sparklines, conditional formatting, and even pivot tables.

You will also find templates you can make copies of to follow along and try out each of the features demonstrated. I am excited to see what you do with these skills, and welcome any questions you have as you learn!

Supercharge Google Docs with Add-ons

Google Docs is a powerful word processing program with many unique features including voice typing, the Explore tool, Version History, web fonts, and much more. 

However, Google knows that even with all of those features, Docs may not be able to do everything you want it to do. So Google Docs allows you to install Add-ons to extend the capabilities of the program.

Add-ons are third-party tools that provide extra features for Docs. Over time the amount of available Add-ons has grown tremendously. So how do you wade through all of these to find the best ones and the hidden gems? 

To help out I have collected a list of my favorite Add-ons for Docs. Certainly this is not a comprehensive list, and there are other awesome Add-ons beyond my list, but these will give you a good place to start. Some of these Add-ons will likely be familiar to you, but hopefully you will find a few new ones or be encouraged to dig deeper into one you have tried before.

See below for my list of recommended Docs Add-ons, what they do, ideas for how they can be used in schools, and a quick overview of how to install, use, and remove Add-ons. And be sure to let me know which Add-ons you would recommend to add to the list. I would love to learn from you!

EdTech Links of the Week - 9-19-22

Each week I keep an eye out for the latest edtech resources through blogs, social media, podcasts, videos, user groups, and more. I then try to reshare these resources in many ways.

One way I share these is here on the blog in these "EdTech Links of the Week" posts. See below to explore the latest batch of resources, and be sure to share with others who may benefit.

If you want to make sure you don't miss new resources, you can:

📰 Sign up for my weekly email newsletter here: Newsletter link

🐦Follow me on Twitter here: Twitter link

🔗 Subscribe to the RSS feed for this blog here: RSS feed link

And as always, please let me know of any resources that you recommend. I would love to learn from you!

4 Free eSignature Options for Google Docs

Google Docs is a wonderful tool, and new features are constantly being added. However one option that is still missing is an easy way to digitally sign and insert your signature into a Google Doc.

Now certainly there are some paid solutions for this, but many of them involve turning the Google Doc into a PDF, which may not be what you want, and of course they cost money.

To help with this I have brainstormed four ways that you can sign a Google Doc that are free and put the signature right into the document. These include:

✍️ Using handwriting fonts

📷 Inserting a signature image

✒️ Signing an embedded Google Drawing

⚙️ Using the "Simple Signature" add-on

See below for a tutorial video where I demonstrate each of these options, as well as detailed written directions.

Google Tools to Support All Learners

Technology can be a powerful tool to assist students when learning, as it provides accessibility and accommodations to support everyone. In particular the Chrome web browser allows users to install a wide variety of web extensions that provide tools that can help all learners.

In this blog post we will take a look at dozens of Chrome web extensions and apps and other tools and features that can assist students in seven main categories:

🗣️ Text to Speech

🎙️ Speech to Text  

👓 Readability

📗 Reading Comprehension

🔊 Audio Support  

☑️ Behavior, Focus, and Organization

🧭 Navigation

 
Some of the tools fit into more than one topic, but each is only listed once. Certainly this list does not cover all of the useful web extensions and tools available for learners, but it is a great place to begin. 

In addition to the list of extensions and tools, I have also linked in the video from a webinar I did on "Google Tools to Support All Learners" along with my ever-growing resource document and slideshow from the session.