As AI becomes more prevalent and important in the classroom, we can use the power of AI to do things with Apps Script that we could not do formerly without a lot of knowledge of coding in Javascript. We will explore some uses of Apps Script to extend the functionality of Google Workspace tools and enlist the help of ChatGPT or Gemini to help us write code. We will learn to use the script editor to add the code to our projects and test it out!
Working with sheets can be fun, productive and really helpful for classroom and data management. We will explores some tips and tricks for using sheets to do some of your tasks more quickly and efficiently.
In this session we will explore some features of google workspace of which you may not be familiar:
Gmail Layouts for newsletters - Unfortunately Google Workspace for education versions does not have this feature
Embed google sheets data into docs or slides which will automatically update
Embed google drawings into google docs and sheets
Tips for using slides in innovative ways.
Looker Studio - visualize your sheets data with a web interface, sort, filter, and keep other people off your sheets
Figma (third party tool)
Canva (third party tool)