June 2020 Professional Development Days

Basic Excel

Each college/school may schedule sessions/workshops specific to their college needs in preparation for Fall 2020 course delivery and support.  College Deans will provide scheduling information and deadlines (if sooner than July 30) in coordination with Executive Directors.

Google Drive Essential Training, Jess Stratton, 4/18/2019

Learn how to work smarter with Google Drive. In this course, Jess Stratton explains how to get started with this popular cloud-based file storage and word processing, spreadsheet, and presentation software. Jess explains how Google Drive fits into the productivity suite from Google and shows how to navigate the interface. She goes into the differences between Drive and Docs, and shares how to organize, sync, and locate your Drive files. She also demonstrates how to create and edit documents, spreadsheets, presentation slides, and drawings, and even how to create a form or survey directly in Google Drive. Plus, Jess explores how to share your files and leverage the mobile app.

Learning objectives 

• Accessing Google Drive 
• Navigating the web interface 
• Uploading files via the web 
• Converting files to Google Doc format 
• Deleting and recovering files 
• Purchasing more storage space for your files 
• Searching files and folders 
• Using Google Docs, Sheets, and Slides 
• Creating drawings 
• Using Google Docs to collaborate with others

Google Sheets Advanced Tips and Tricks, Jess Stratton, 10/25/2016

Get the most out of Google Sheets. Author Jess Stratton provides helpful tips and tricks to boost your productivity, from leveraging Google's wide array of templates and sharing spreadsheets to creating interactive charts and applying conditional formatting. Learn how to use powerful formulas and functions, add data validation, create surveys and charts, and expand the functionality of Google Sheets with add-ons. 

Learning objectives 

• Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch. 
• Name the action you would need to take to make data fit in a column on a Google sheet. 
• List the steps to include multiple lines in a cell. 
• Explain how to use the iframe code for a chart when publishing it to a website. 
• Recall the main advantage of using IFTTT services with Google Sheets. 
• Recognize situations where Google Sheets email notifications would be useful.

Boost your productivity by going beyond basic Google Calendar features. In this course, Jess Stratton helps you become a Google Calendar power user. She demonstrates how to create events with video capabilities, change event time zone settings, and she takes you beyond individual events into managing your entire calendar. She shows you how to use Agenda view and enable different Google Labs to keep yourself on track. You'll also see how to share your calendar with others, embed it on a website, create available appointment slots, and use your calendar in coordination with other Google products. 

Learning objectives 

• List your options for creating an event with the Google search bar. 
• Explain how to create a multiday event. 
• Recall how to identify what calendar an event belongs to after you change the event’s color. 
• Recognize which default view gives you a flat view of all events when customizing a specific calendar to place it on a webpage. 
• Recall whether the year is available by default.

Manage your personal and professional schedules more effectively with Google Calendar. In this concise course, staff instructor Jess Stratton shows how to get started scheduling events, keeping track of your to-dos, and accessing it all on the go. Jess begins by showing how to change the way Google Calendar looks and acts to make it better suit your needs. Next, she moves straight into creating single or repeating events, inviting guests, and adding rooms and resources to an event. She demonstrates how to respond to invitations, and covers the ins and outs of pop-up reminders and email notifications. Jess also shows how to create an additional calendar, share your calendar with others, and access your Google Calendar on your phone or tablet.
 

Learning objectives 

• Navigating Google Calendar 
• Creating events, including all-day and repeating events 
• Inviting guests 
• Adding rooms and resources 
• Responding to invitations 
• Creating secondary calendars 
• Sharing calendars 
• Searching for events 
• Working with the Google Calendar mobile app