Course Information and Outline
Upon completion of this course, the student should be able to understand how to use Google Apps in the following areas:
1. Use District-assigned Google account to access Google Drive
2. Create, edit, manage, and share word processing documents, spreadsheets, and presentations
3. Download Microsoft Office files into Google Drive
4. File management
5. Communicate using Email using proper business etiquette
6. Create and use forms
7. Share and collaborate files with others
8. Enhance organization skills by creating and maintaining a calendar
9. Practice Internet safety
Course Syllabus
*Learning objectives are listed below but are not limited to those of which included.
Unit 1: Internet Safety
1. Identify and practice safe and secure Internet practices
2. Inform others of importance of Internet safety
Unit 2: Documents
1. Create a Google document
2. Name/delete a document
3. Create folders to organize files
4. Format bulleted and numbered list
5. Create a link to a bookmark
6. Customize title, subtitles, headings and text styles
Unit 3: Sheets
1. Edit a cell
2. Change cell data type
3. Copy and paste
4. Add links in a spreadsheet
5. Add images in a spreadsheet
6. Repeat or extend patterns with auto-fill
7. About formulas
8. Shortcuts for entering formulas
9. Quick sum
10. Import data from web-pages
11. Split cell text into multiple cells
12. Move or copy sheets
13. Hide sheets
14. Adjust rows and columns
15. Merge cells horizontally or vertically
16. Spreadsheet formatting and rules
17. Basic sorting
18. Create charts from spreadsheet data
Unit 4: Presentations
1. Insert a slide
2. Duplicate a slide
3. Delete a slide
4. Organize slides
5. Import slides from another existing presentation
6. Use and identify Themes
7. Add text or objects to a slide
8. Add animations to a slide
9. Insert word art into a slide
10. Print a presentation
Unit 5: Forms
1. Create a new form
2. Form Limitations
3. Form question types
4. Add and edit questions
5. Add a section header
6. Add a page break
7. Edit questions, headers, and page breaks
8. Format form appearance
9. Control your form's page-to-page navigation
10. Provide respondents a custom form submission message
11. Access the form with a URL
12. Allow individuals to edit form responses
13. Edit a submitted form response
14. Stop accepting form responses
15. Store responses in a spreadsheet
16. Change your response destination
17. Manage responses
Unit 6: Search
1. Navigate Google Search.
2. Identify information.
3. Narrow search results
4. Create Citations
5. Work Cited page building
Unit 7: Calendar
1. Log into Google Calendar
2. Identify and use Calendar’s main features
3. Create a calendar event
4. Customize Calendar settings
5. Attach Google Drive files to events
6. Print a calendar
7. Share and collaborate with others on Calendar
8. Share calendars
9. Add a friend’s calendar
10. Move or copy events between calendars
Unit 8: Sharing & Collaborating
1. Share Documents, Spreadsheets, Presentations, Calendar, Forms, and sites
2. Communicate with others using Gmail, Chat, Meet
3. Collaborate with others to create documents, spreadsheets, presentations, forms, and sites
Business Technology Communications and Collaboration