10
Lesson 9-7 Editing and
Commenting ............................194
Lesson 9-8 Using the Revision
History .....................................197
Lesson 9-9 Downloading and Printing
a Document ..............................199
Skill Review .................................202
Lesson Application ......................202
Chapter 10
Google Sheets ..............................205
Using Google Sheets ....................206
Sharing Google Sheets ....................207
Formatting Spreadsheets ..................207
Using Formulas and the Auto-Fill
Handle ..........................................208
Sorting and Charting Data ................209
Lesson 10-1 Collaborating in a Shared
Spreadsheet .............................211
Lesson 10-2 Formatting Cells ........213
Lesson 10-3 Basic Formulas ..........220
Lesson 10-4 Sorting and Filtering
Data ........................................223
Lesson 10-5 Creating a Chart and
Working with Multiple Sheets .....227
Lesson 10-6 Printing and Publishing a
Spreadsheet .............................231
Skill Review .................................233
Lesson Application ......................233
Chapter 11
Google Slides ...............................235
Using Google Slides .....................236
Creating a Presentation ................236
Navigating Google Slides .................236
Adding Visuals to Presentations ........238
Adding Movement to Presentations ..238
Presenting and Publishing ............240
Lesson 11-1 Automatic Conversion on
Upload ...........................................241
Lesson 11-2 Adding Images and
Video ..............................................245
Lesson 11-3 Inserting a Table .........248
Lesson 11-4 Drawing Shapes .........251
Lesson 11-5 Adding Animations and
Transitions ...............................254
Lesson 11-6 Using Themes, Backgrounds,
and Speaker Notes .....................257
Lesson 11-7 Presenting a Slide
Show ..............................................260
Lesson 11-8 Publishing, Sharing, and
Downloading a Presentation ......262
Skill Review .................................265
Lesson Application ......................265
Chapter 12
Google Forms ...............................267
Using Google Forms .....................268
Creating and Distributing a Form ......268
Managing Form Data ........................269
Lesson 12-1 Creating a Form .........272
Lesson 12-2 Distributing a Form ....276
Lesson 12-3 Viewing and Managing
Responses ...............................278
Lesson 12-4 Editing a Form ...........281
Skill Review .................................283
Lesson Application ......................283
Unit 3 Review .............. 285
Unit 4
Google Sites ................ 286
Chapter 13
Creating and Managing a Site
......
287
Using Google Sites ..........................288
Creating a Website............................288
Working with Web Page and
Announcement Templates ............290
Working with File Cabinet and List
Templates .....................................291
Managing a Site ................................292
Lesson 13-1 Creating a New Site ....293
Lesson 13-2 Editing a Site .............296
Lesson 13-3 Adding an Announcement
Page to a Site .......................... 300
Lesson 13-4 Managing Posts .........305
Lesson 13-5 File Cabinet Pages .....309
Lesson 13-6 Creating a List Page ...313
Lesson 13-7 Managing a Site through
Collaboration............................317