BSN-FY11

Google Slides Course Outline

Slides Fundamentals

1	Create Presentations
2	Open a Presentation
3	File Management
4	Print Presentations
5	Get Help

Edit and Organize a Presentation

1	Add and Lay Out Slides
2	Cut, Copy, and Paste
3	Undo and Redo
4	Find and Replace
5	Add Speaker Notes
6	Add Slide Numbers
7	Move and Skip Slides
8	Duplicate and Copy Slides
9	Change Views

Formatting and Themes

1	Format Text
2	Borders and Shading
3	Format Lists
4	Insert Links
5	Copy and Clear Formatting
6	Use Themes

Graphics and Animations

1	Insert and Edit Shapes
2	Insert Images
3	Edit Images
4	Arrange Objects
5	Format Objects
6	Apply Slide Transitions
7	Add Animations to Objects

Insert Objects

1	Insert a Text Box
2	Insert Charts
3	Insert Tables
4	Insert Diagrams
5	Insert Word Art
6	Insert Videos

Deliver a Presentation

1	Present a Slideshow
2	Use Slideshow Tools
3	Use Presenter View

Share, Collaborate, and Convert

1	Download and Email Presentations
2	Share Presentations
3	Collaborate
4	Work with Versions
5	Add-Ons

Google Sheets Course Outline

Sheets Fundamentals

1	Create Spreadsheets
2	Open a Spreadsheet
3	Navigate Spreadsheets
4	File Management
5	Print Spreadsheets
6	Get Help

Edit Spreadsheets

1	Select Cells and Ranges
2	Edit Cell Data
3	Cut, Copy, and Paste Data
4	Undo, Redo, and Repeat
5	Use Paste Special
6	Insert and Move Cells
7	Delete Cells
8	Hide Rows and Columns
9	Find and Replace Text
10	Check Spelling

Format Spreadsheets

1	Format Text
2	Align and Merge Cells
3	Cell Borders and Background Colors
4	Format Numbers and Dates
5	Adjust Row Height and Column Width
6	Freeze Rows and Columns
7	Copy Formatting
8	Apply Conditional Formatting

Formulas and Functions

1	Formula Basics
2	Autofill
3	Sums and Averages
4	MIN and MAX
5	COUNT
6	Insert Functions
7	Absolute and Relative Cell References
8	Cell Range Names

Manage Sheets and Data

1	Insert, Rename, and Delete Sheets
2	Duplicate, Move, and Hide Sheets
3	Sort Data
4	Filter Data
5	Data Validation
6	Protect Spreadsheets

Insert Objects

1	Insert a Chart
2	Customize a Chart
3	Insert Images
4	Insert Links

Share, Collaborate, and Convert

1	Upload and Convert Spreadsheets
2	Download and Email Spreadsheets
3	Share Spreadsheets
4	Collaborate
5	Work with Versions
6	Add-Ons

Google Forms Course Outline

Create Forms

1	Create a New Form
2	Add Questions
3	Edit Questions
4	Add Images and Video
5	Change Theme Options
6	Form Sections
7	Form Navigation
8	Change Form Settings
9	Create a Quiz

Share Forms and Track Responses

1	Send a Form
2	Collect and View Responses
3	Print a Form
4	Grade and Return a Quiz
5	Export Results

Google Drive Course Outline

Google Drive

1	Google Drive Views
2	Find Files
3	Open Files and Folders
4	Create Files and Folders
5	Move and Add Content to New Locations
6	Star and Color Code Content
7	Manage Workspaces
8	Delete and Restore Files
9	Share Content
10	Change Access to Content
11	Upload and Download Files
12	Manage File Versions
13	Sync with Your Computer
14	Manage Notifications