JANUARY 2024 – PRESENT
Google Workspace
Overview
The Patterson Foundation uses Google Workspace applications in various ways to create, connect, and collaborate with people, organizations, and communities.
By developing and honing each of our Google applications skills, we strengthen our ability to provide strategic and tactical support and expertise to TPF’s various initiatives.
Logistics
The main applications include:
- Drive – Store, share, and collaborate on files and folders from your mobile device, tablet, or computer. Drive integrates with Docs, Sheets, Slides, and cloud-native collaboration apps, enabling your team to create content and collaborate more effectively in real time – Similar to OneDrive. Think of it as a file cabinet.
- Calendar – A shareable online calendar that combines all your calendars in one place so you can manage work, personal life, and everything in between. Similar to Outlook or Apple’s calendar.
- Gmail – A free web-based email service that provides users with 15 GB of email storage. Similar to Outlook or Yahoo.
- Docs – Create and collaborate on online documents in real time and from any device. Edit together in real-time with easy sharing, and use comments, suggestions, and action items to keep things moving. Or use @-mentions to pull relevant people, files, and events into your online Docs for rich collaboration. – Similar to Word. (Think of it as working side by side on a single document in the office with a fellow TPFer).
- Forms – Create custom forms for surveys, registrations, and questionnaires. Easily share forms with specific people or to a broad audience by sharing a link, embedding them on your website, and watching responses appear. Real-time collaboration helps you create your form faster and lets you analyze results together without sending around multiple file versions.
- Sheets – Create and collaborate on online spreadsheets in real time and from any device. Sheets is thoughtfully connected to other Google apps you love, saving you time. Easily analyze Google Forms data in Sheets or embed Sheets charts in Google Slides and Docs. – Similar to Excel.
- Slides – Create, present, and collaborate on online presentations in real time and from any device. Stay in sync in your slides with easy sharing and real-time editing. Use comments and assign action items to build your ideas together. Similar to PowerPoint.
FAQ's
What is Google Workspace, and how does it work?
Relevant Google Workspace applications include:
- Gmail – Send and receive mail.
- Drive – Store, access, and share your files in one secure place. Store any and every file. Access files anytime, anywhere, from your desktop and mobile devices. Control how files are shared.
- Calendar – Google Calendar brings all of your calendars together in one place so you can manage work, personal life, and everything in between.
- Google Docs – Word processing for teams. Create and edit text documents in your browser—no dedicated software is required. Multiple people can work simultaneously, and every change is saved automatically.
- Sheets – Collaborative, smart, secure spreadsheets for fast-moving organizations.
- Slides – Create and edit polished presentations in your browser—no software required. Multiple people can work simultaneously, so everyone always has the latest version.
How does The Patterson Foundation use Google Workspace Applications?
- Gmail – To send emails.
- Drive – To store initiative files, including documents, photos, videos, etc.
- Calendar – To manage and schedule both in-person and virtual meetings.
- Docs – To create meeting agendas, run of shows, frameworks, etc.
- Sheets – To track event registration, book inventory, and engagement.
- Slides – To create presentations for Zoom meetings.
- Forms – To create registration forms and sign-up sheets.
What are essential Gmail skills for a TPFer?
Note: A majority of these key functions are best done on a laptop or desktop computer rather than an iPhone, iPad, Android smartphone, or tablet. To do some of these functions on a phone, you will be required to download an application. Some functions will not be able to be completed on a device other than a computer.
Overview of Concepts
Key Functions for Beginners- Writing and Sending Emails
- Adding Cc and Bcc Recipients
- Formatting Your Fonts and Colors
- Sending and unsending messages
- Written Instructions: Computer, Android, iPhone and iPad
- Fixing Spelling and Grammar
- Sending attachments and images
- Written Instructions: Computer, Android, iPhone and iPad
- Scheduling Emails
- Written Instructions: Computer, Android, iPhone and iPad
- Change your Gmail profile picture
- Written Instructions: Computer, Android, iPhone and iPad
- Changing Your Inbox Layout
- Written Instructions: Computer, Android, iPhone and iPad
- Creating Labels to Organize Gmail
- Written Instructions: Computer, Android, iPhone and iPad
- Adding A Signature
- Written Instructions: Computer, Android, iPhone and iPad
- Creating a vacation reply
- Written Instructions: Computer, Android, iPhone and iPad
- Create and Schedule Events in Gmail
- Written Instructions: Computer
- Changing and Updating Settings
- Written Instructions: Computer, Android, iPhone and iPad
- Searching in Gmail
- Written Instructions: Computer, Android, iPhone and iPad
- Open and download Attachments
- Written Instructions: Computer, Android, iPhone and iPad
- Marking Messages Read Or Unread
- Written Instructions: Computer, Android, iPhone and iPad
- Starring Emails
- Written Instructions: Computer, Android, iPhone and iPad
- Marking Emails As Spam
- Written Instructions: Computer, Android, iPhone and iPad
- Delete & Recover Emails
- Written Instructions: Computer, Android, iPhone and iPad
- Send & open confidential emails
- Written Instructions: Computer, Android, iPhone and iPad
- Sending Emails
- Managing Emails
What are essential Calendar skills for a TPFer?
Note: A majority of these key functions are best done on a laptop or desktop computer rather than an iPhone, iPad, Android smartphone, or tablet. To do some of these functions on a phone, you will be required to download an application. Some functions will not be able to be completed on a device other than a computer.
Overview of Concepts
Key Functions for Beginners
- Changing Your Calendar View
- Written Instructions: Computer, Android, iPhone and iPad
- Search on Google Calendar
- Written Instructions: Computer, Android, iPhone and iPad
- Creating a Single Event
- Written Instructions: Computer, Android, iPhone and iPad
- Creating a Recurring Event
- Written Instructions: Computer, Android, iPhone and iPad
- Inviting People to Your Calendar Event
- Written Instructions: Computer, Android, iPhone and iPad
- Create and Schedule Events in Gmail
- Written Instructions: Computer
- Manage Google Calendar Notifications
- Written Instructions: Computer, Android, iPhone and iPad
- Sharing Your Calendar
- Written Instructions: Computer
- Subscribe to Someone’s Google Calendar
- Written Instructions: Computer
- Using Color Labels to Track Calendar Entries
- Written Instructions: Computer
- Adding Attachments to Events
- Written Instructions: Computer, Android, iPhone and iPad
- Creating & Managing Tasks
- Written Instructions: Computer, Android, iPhone and iPad
Advanced
- Adding Google Calendar events to Apple Calendar
- Written Instructions: Computer
- Syncing Calendar with a phone or tablet
- Written Instructions: Android, iPhone and iPad
- Creating a Bookable Appointment Schedule
- Written Instructions: Computer
- Sharing a Bookable Appointment Schedule
- Written Instructions: Computer, Android, iPhone and iPad
What are essential Drive skills for a TPFer?
Note: A majority of these key functions are best done on a laptop or desktop computer rather than an iPhone, iPad, Android smartphone, or tablet. To do some of these functions on a phone, you will be required to download an application. Some functions will not be able to be completed on a device other than a computer.
Overview of Concepts
Key Functions for Beginners- Creating files
- Upload files & folders to Google Drive
- Written Instructions: Computer, Android, iPhone and iPad
- Downloading Files
- Written Instructions: Computer, Android, iPhone and iPad
- Storing & Playing Videos In Google Drive
- Written Instructions: Computer, Android, iPhone and iPad
- Managing Drive’s Storage
- Written Instructions: Computer
- Sharing Files In Drive
- Written Instructions: Computer, Android, iPhone and iPad
- Managing Files
- Reordering Files and Folder
- Written Instructions: Computer, Android, iPhone and iPad
- Creating Folders In Drive
- Written Instructions: Computer
- Sharing Folders In Drive
- Written Instructions: Computer, Android, iPhone and iPad
- Moving Files In Drive
- Written Instructions: Computer, Android, iPhone and iPad
- Managing Share Settings
- Written Instructions: Computer, Android, iPhone and iPad
- Finding Files Shared With You In Drive
- Written Instructions: Computer, Android, iPhone and iPad
- Searching for Files In Drive
- Written Instructions: Computer, Android, iPhone and iPad
- Finding and Recovering Files
- Written Instructions: Computer, Android, iPhone and iPad
What are essential Docs skills for a TPFer?
Note: A majority of these key functions are best done on a laptop or desktop computer rather than an iPhone, iPad, Android smartphone, or tablet. To do some of these functions on a phone, you will be required to download an application. Some functions will not be able to be completed on a device other than a computer.
Overview of Concepts
Key Functions for Beginners- Text Basics
- Formatting Text
- Using Indents & Tabs
- Using Text Boxes and Shapes
- Adding Text Styles
- Adjusting Margins
- Create, view, or download a file
- Written Instructions: Computer, Android, iPhone and iPad
- Sharing a Doc
- Written Instructions: Computer
- Copying and Pasting Text and Images
- Written Instructions: Computer, Android, iPhone and iPad
- Deleting a Document
- Written Instructions: Computer, Android, iPhone and iPad
- Creating Tables
- Adding Headers and Footers
- Written Instructions: Computer, Android, iPhone and iPad
- Customizing Paragraphs and Fonts
- Written Instructions: Computer, Android, iPhone and iPad
- Adding a Table of Contents
- Written Instructions: Computer, Android, iPhone and iPad
- Inserting Links
- Written Instructions: Computer, Android, iPhone and iPad
- Creating Tables in Docs
- Written Instructions: Computer, Android, iPhone and iPad
- Working with Images
- Inserting and Deleting Images & Videos
- Written Instructions: Computer, Android, iPhone and iPad
- Inserting Emojis & Special Characters
- Written Instructions: Computer, Android, iPhone and iPad
- Suggesting in Docs
- Written Instructions: Computer, Android, iPhone and iPad
- Commenting in Docs
- Written Instructions: Computer, Android, iPhone and iPad
- Checking Spelling and Grammar in Docs
- Written Instructions: Computer, Android, iPhone and iPad
- Using Search, Find and Replace in Docs
- Written Instructions: Computer, Android, iPhone and iPad
- Downloading a Doc
- Written Instructions: Computer, Android, iPhone and iPad
- Inserting Charts on Docs
- Written Instructions: Computer, Android, iPhone and iPad
- Viewing Version History on Docs
- Written Instructions: Computer, Android, iPhone and iPad
- Counting Words in a Doc
- Written Instructions: Computer, Android, iPhone and iPad
- Using Google Docs Mobile App
- Using Offline Mode
- Restoring Files
- Written Instructions: Computer, Android, iPhone and iPad
What are essential Forms skills for a TPFer?
Note: A majority of these key functions are best done on a laptop or desktop computer rather than an iPhone, iPad, Android smartphone, or tablet. To do some of these functions on a phone, you will be required to download an application. Some functions will not be able to be completed on a device other than a computer.
Overview of Concepts
Key Functions for Beginners- Creating a New Form
- Written Instructions: Computer, Android, iPhone and iPad
- Editing a Form
- Written Instructions: Computer
- Formatting Forms
- Written Instructions: Computer
- Sending Forms
- Written Instructions: Computer
- Share Form With Collaborators
- Written Instructions: Computer
- Saving Form Responses
- Written Instructions: Computer
- View & Manage Form Responses
- Written Instructions: Computer
- Customizing Form’s Theme
- Written Instructions: Computer
Advanced
What are essential Sheet skills for a TPFer?
Note: A majority of these key functions are best done on a laptop or desktop computer rather than an iPhone, iPad, Android smartphone, or tablet. To do some of these functions on a phone, you will be required to download an application. Some functions will not be able to be completed on a device other than a computer.
Overview of Concepts
Key Functions for Beginners- Creating a Sheet
- Written Instructions: Computer, Android, iPhone and iPad
- Editing and Formatting a Sheet
- Written Instructions: Computer, Android, iPhone and iPad
- Add or Move Columns & Cells
- Written Instructions: Computer, Android, iPhone and iPad
- Formatting Cells
- Written Instructions: Computer, Android, iPhone and iPad
- Freeze or merge rows & columns
- Written Instructions: Computer, Android, iPhone and iPad
- Formatting Numbers in a Sheet
- Written Instructions: Computer, Android, iPhone and iPad
- Change the Color of Text, Objects, and Backgrounds
- Written Instructions: Computer
- Adding an Image to a Sheet
- Written Instructions: Computer, Android, iPhone and iPad
- Sorting and Filtering Data
- Written Instructions: Computer, Android, iPhone and iPad
- Create In-cell Dropdown Lists
- Written Instructions: Computer
- Adding & Using checkboxes
- Written Instructions: Computer, Android, iPhone and iPad
- Using Basic Formulas
- Written Instructions: Computer, Android, iPhone and iPad
- Printing Sheets
- Written Instructions: Computer, Android, iPhone and iPad
- Google Sheets: Modifying Cells
- Creating Simple Formulas
- Written Instructions: Computer, Android, iPhone and iPad
- Creating Complex Formulas
- Working with Functions
- Written Instructions: Computer, Android, iPhone and iPad
- Adding and Editing Charts
- Written Instructions: Computer, Android, iPhone and iPad
- Add Data Labels, Notes, or Error Bars to a Chart
- Written Instructions: Computer
- Editing Chart Axes
- Written Instructions: Computer
- Saving and Publishing Charts
- Written Instructions: Computer
What are essential Slides skills for a TPFer?
Note: A majority of these key functions are best done on a laptop or desktop computer rather than an iPhone, iPad, Android smartphone, or tablet. To do some of these functions on a phone, you will be required to download an application. Some functions will not be able to be completed on a device other than a computer.Overview of Concepts
Key Functions for Beginners
- Slide Basics
- Written Instructions: Computer, Android, iPhone and iPad
- Adding Transitions
- Written Instructions: Computer
- Adding Animations
- Written Instructions: Computer
- Presenting Your Slide
- Written Instructions: Computer, Android, iPhone and iPad
- Inserting & Adding Videos
- Written Instructions: Computer, Android, iPhone and iPad
- Adding and Editing Free Templates
- Adding Audio
- Printing and creating PDF files
- Insert and arrange text, shapes, diagrams, and lines
- Written Instructions: Computer, Android, iPhone and iPad
- Insert or delete images & videos
- Written Instructions: Computer, Android, iPhone and iPad
- Crop and adjust images
- Written Instructions: Computer, Android, iPhone and iPad
- Add and edit tables
- Written Instructions: Computer, Android, iPhone and iPad
- Link a chart, table, or slides to Google Docs or Slides
- Written Instructions: Computer
- Change the theme, background, or layout in Google Slides
- Written Instructions: Computer, Android, iPhone and iPad
- Using Templates
- Written Instructions: Computer, Android, iPhone and iPad
What Google Workspace classes are offered for TPFers?
- Optimizing Your Use of Gmail: Provides an opportunity to learn to use Gmail functions.
- Discover Drive: Provides an opportunity to learn to use Gmail functions.
- Dive into Docs: Provides an opportunity to learn, practice, and hone in on essential Doc skills.
- Connect and Collaborate With Calendar: Provides an opportunity to learn, practice, and hone in on essential Calendar skills.
- Forms for Beginners: Provides an opportunity to learn, practice, and hone in on essential Form skills.
- Simplifying Sheets (Beginner): Provides an opportunity to learn, practice, and hone in on essential Sheet skills.
- Optimizing Sheets (Advanced): Provides an opportunity to learn, practice, and hone in on advanced essential Sheet skills such as charts and formulas.
- Presenting With Slides: Provides an opportunity to learn, practice, and hone in on essential Slide skills.
What additional learning resources are available?
Calendar
- Cheat Sheet
- Productivity Guides: Tips to manage your time in Calendar
- Productivity Guides: Tips to manage Calendar events in Gmail
- Productivity Guides: Tips to collaborate in Calendar
- Productivity Guides: Tips to share calendars
- Cheat Sheet
- Productivity Guides: Tips to access and find your files
- Productivity Guides: Tips to share your files
- Productivity Guides: Tips to edit and collaborate on files
- Keyboard shortcuts for Google Drive on the web
- Cheat Sheet
- Productivity Guides: Optimize your Gmail inbox
- Productivity Guides: Tips for reading and sending emails in Gmail
- Productivity Guides: Manage important or sensitive emails
- Productivity Guides: Manage unwanted messages in Gmail
- Keyboard Shortcuts
- Cheat Sheet
- Productivity Guides: Tips to format & customize documents
- Productivity Guides: Tips for strong proposals
- Productivity Guides: Set up citations and bibliographies in Docs
- Productivity Guides: Tips to edit and collaborate on files
- Keyboard Shortcuts – Video
- Cheat Sheet
- Productivity Guides: Create a quiz with Google Forms
- Productivity Guides: Tips to customize your forms
Sheets
- Cheat Sheet
- Productivity Guides: Tips to format & clean up data
- Productivity Guides: Tips to analyze data
- Productivity Guides: Tips to edit and collaborate on files
- Functions List
Slides
- Cheat Sheet
- Productivity Guides: Tips for great presentations
- Productivity Guides: Tips to share content in a video meeting