Friday, May 17, 2024

Tech Tips and News for May 17, 2024

It's mid-May, we're so close ...and yet so far from the end of the school year. The kids are wired and teachers are exhausted trying to cram the last bit of content in before 2023-2024 reaches the finish line. On one hand you may be counting the days until June 6th, but on the other the dwindling number of days is stressing you out because there's so much still to be done. There's very little left in everyone's tank at this point. This week I've included some ways to take some of the stress off. I realize wellness really has very little connection to technology - unless it's unplugging from technology, or finding simple ways to make technology save time for us. I wanted all of you to know I see your dedication and fatigue as we near the end of the school year. If there's anything I can do to take away any tech-related frustration, or help you find an easier way to do something, please let me know. As the school year gets busier and busier in its wind-down, it's important for all of us to make time for self-care. It feels like an endurance contest, but we can do this with a little TLC!

Updates

Tips and Tutorials




Google Drive:  Find Files With Updated Keyboard Shortcuts and By Entering First Letters


Very soon it will be easier to find your files in Google Drive. When you see a list of files in Drive, you'll be able to find the one your looking for by typing in the first letter(s) of the file and it will highlight the first matching file in the list. If there is more than one file starting with the same letter, pressing the same letter again will move to the next file alphabetically. To turn this feature on, select it when the banner notification appears, or go to Drive > Settings > Keyboard shortcuts > Update now.  By August 1, 2024, this feature will be turned on for everyone. You can find more information on using keyboard shortcuts here

Google Sheets:  Quickly Create & Format a Table

Simply highlight your data range, select Format > Convert to Table, and Sheets will do the work to organize and format your data into a nice looking table, including column types, filters, color coding, dropdown menus and more. You'll save lots of time not needing to align your columns, color code, adjusting row height, etc. You can set the column type (date, currency, dropdown, etc.) Above the table you'll see a menu option to manage the table settings. When you convert the table in Sheets, it will assign a name to the table and each column header that you'll be able to refer to in formulas. You will also be able to easily group your data in the table. There are also pre-built tables for tasks like project management, inventory management, event planning, etc. Learn more about using tables in Sheets here. The details for this update can be found in this Keyword post. We should see this update in late May or early June.

Google Sheets:  Easily Make Drop Down Lists From the Data You've Entered

With this update you'll be able to select the data in a column and quickly create a drop down list for the fields in the column. Highlight the data in the column, select Convert to Dropdown Chips. To insert dropdown chips on your own, enter @dropdown in the field. This feature should be available by the end of May/beginning of June. You can learn more about inserting smart chips in Google Sheets here.

Google Sheets:  What's the New Looker Studio Option? 

If you use extensions frequently in Google Sheets, you'll have noticed a Looker Studio (new) option in the Extensions menu. You can now create reports and dashboards for your data using Looker Studio from within Google Sheets. This will allow you to easily share and analyze the data in your sheet. The Looker Studio report remains connected to your sheet, and can be refreshed to reflect any updates to your data. Here's how you can create a Looker Studio report within any Google Sheet.


Don't Let Your Phone Bully You, 4 Ways to Stop the Interruptions

The very first thing I do when I add an app, or get a new phone is turn off nearly all notifications. Group texts? Mute them. The constant interruptions drive me crazy. The emails, texts and social media posts will still be there when you have time to deal with them. 

Find Your AI Teaching Assistant Series: AI Can Help You Tutor Your Students

Isn't there always a student or two who just doesn't grasp the concept you are trying to teach? Give them some interactive review or a deeper dive into a topic with these tutoring tools. Unfortunately at this time, subject and age options for tutoring tools is a little more limited than some of the other AI tools, but as with all things AI, more will be coming. Both Sorcerer and CK-12 Flexi are free, but Khanmigo is a paid service. I included it so teachers can evaluate it to see if it might be a worthwhile subscription for the school. 

Sorcerer

  • Sorcerer is an AI-powered tool that asks you questions about topics to see what you know and help you learn more.
  • Start by putting in a topic that you are learning about.
  • Sorcerer then asks questions to determine your knowledge and understanding.
  • Sorcerer provides help along the way if you get stuck or do not know the answers.
  • Sorcerer can be set to five levels of difficulty including middle school, high school, undergraduate, masters, and PhD.
  • Demo Sorcerer - https://antimatter.systems/sorcerer/control-alt-achieve 

CK-12 Flexi

  • Flexi is a free AI-powered digital tutor for students from CK-12 for MS and HS science and math.
  • Provides immediate feedback to help students learn complex topics with real world applications.
  • Answers students’ questions and provides interactive examples to help them understand the underlying concepts.
  • Tests students’ knowledge of a concept by giving them relevant questions at their skill level.
  • Supports students with the right amount of help via hints, content recommendations, and reinforcement of foundational concepts.

Khanmigo

  • Khan Academy's AI powered chatbot that is designed to help students without giving the answers. Activities include:
    • Tutor Me - Math, Science, Humanities
    • Refresh - Practice my knowledge
    • Write - Craft a story, Brainstorm an admissions essay
    • Debate - Elementary, middle school, or high school topics
    • Chat - Literary characters, historical figures
    • More!
This is the fifth in a series of ways teachers can work smarter by use AI as a teaching assistant. Previous articles included Multi-Tasking Tools That Take the Guesswork Out of PromptsCommunication Tools to Use With Students, Save Time With Assessment Tools, and  Train Your TA to Grade For You. Coming soon...AI differentiation tools.

Generative AI for Educators

Google has created a course for teachers to learn about generative AI, which is the type of AI that creates new content, such as text, images, or other media. The course is designed to help you explore how to use generative AI tools to assist you by saving time on everyday tasks, personalizing instruction, and enhancinig lessons and activities. The estimated time to complete the course is 2 hours. Get started here

Email Writing for Students

Email Writing for Students, from TCEA by Lori Gracey
This is a terrific guideline for teaching students how to properly use email. 

Radical Wellness: The Self-Care Nobody Is Talking About

Radical Wellness: The Self-Care Nobody Is Talking About, from Ditch That Textbook by Matt Miller with Guest Post by Kim Strobel
Nourish your emotional well-being.

Practicing Self-Care: 5 Tips for Teachers

Practicing Self-Care: 5 Tips for Teachers, From Understood by Brittney Newcomer, MS, NCSP
Feeling overwhelmed with no time for self-care? Here is how other teachers do it. 

20 Ways Google Tools Can Make the End of the School Year Rock

20 Ways Google Tools Can Make the End of the School Year Rock, from Ditch That Textbook by Matt Miller
20 end of the year activities you can do with your students using Google Workspace. 

100+ Best Teacher Influencers To Follow on Instagram

100+ Best Teacher Influencers To Follow on Instagram, from We Are Teachers by Malia Bartek
Looking for some inspiration, comedy relief, or just other teachers to commiserate with? These suggestions are broken down by grade level and specialty.

No comments:

Post a Comment