Muutke küpsiste eelistusi

GO! with Microsoft Office 2019 Getting Started [Spiraalköide]

  • Formaat: Spiral bound, 432 pages, kõrgus x laius x paksus: 100x100x100 mm, kaal: 780 g
  • Ilmumisaeg: 02-Jun-2021
  • Kirjastus: Pearson
  • ISBN-10: 0135672791
  • ISBN-13: 9780135672792
Teised raamatud teemal:
  • Formaat: Spiral bound, 432 pages, kõrgus x laius x paksus: 100x100x100 mm, kaal: 780 g
  • Ilmumisaeg: 02-Jun-2021
  • Kirjastus: Pearson
  • ISBN-10: 0135672791
  • ISBN-13: 9780135672792
Teised raamatud teemal:

Now live! SUMMER 2020 DIGITAL UPDATE for digital content
Microsoft Office 365 updates are reflected in the eText and associated MyLab for this title. To learn more, contact your Pearson representative.

For introductory courses in Microsoft® Office.

Seamless digital instruction, practice, and assessment
For over 17 years, instructors have relied upon the GO! series to teach Microsoft Office successfully. The series uses a project-based approach that clusters learning objectives around projects, rather than software features, so students can practice solving real business problems. Gaskin uses easy-to-follow Microsoft Procedural Syntax so students always know where to go on the ribbon; she combines this with a Teachable Moment approach that offers learners tips and instructions at the precise moment they’re needed. Updated to Office 365, GO! with Microsoft® Office 365®, 2019 Edition, Getting Started adds tips for Mac users, revised instructional projects, and improved coverage of the what, why, and how of skills application.

Also available with MyLab IT
MyLab is the teaching and learning platform that empowers you to reach every student. By combining trusted author content with digital tools and a flexible platform, MyLab personalizes the learning experience and improves results for each student. MyLab IT 2019 delivers trusted content and resources through an expansive course materials library, including new easy-to-use Prebuilt Learning Modules that promote student success. Through an authentic learning experience, students become sharp critical thinkers and proficient in Microsoft Office, developing essential skills employers seek. Learn more about MyLab IT.



Now live! SUMMER 2020 DIGITAL UPDATE for digital content
Microsoft Office 365 updates are reflected in the eText and associated MyLab for this title. Instructors, to learn more, contact your Pearson representative.

For introductory courses in Microsoft® Office.

Seamless digital instruction, practice, and assessment
For over 17 years, instructors have relied upon the GO! series to teach Microsoft Office successfully. The series uses a project-based approach that clusters learning objectives around projects, rather than software features, so students can practice solving real business problems. Gaskin uses easy-to-follow Microsoft Procedural Syntax so students always know where to go on the ribbon; she combines this with a Teachable Moment approach that offers learners tips and instructions at the precise moment they’re needed. Updated to Office 365, GO! with Microsoft® Office 365®, 2019 Edition, Getting Started adds tips for Mac users, revised instructional projects, and improved coverage of the what, why, and how of skills application.

Also available with MyLab IT
By combining trusted author content with digital tools and a flexible platform, MyLab personalizes the learning experience and improves results for each student. MyLab IT 2019 delivers trusted content and resources through an expansive course materials library, including new easy-to-use Prebuilt Learning Modules that promote student success. Through an authentic learning experience, students become sharp critical thinkers and proficient in Microsoft Office, developing essential skills employers seek.

Note:
 You are purchasing a standalone product; MyLab IT does not come packaged with this content. Students, if interested in purchasing this title with MyLab IT, ask your instructor to confirm the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.

Microsoft Office and Windows 10
1(100)
Chapter 1 Microsoft Office Features and Windows 10 File Management
1(100)
Project 1A Chef Notes
2(5)
Objective 1 Explore Microsoft Office
3(1)
Activity 1.01 Exploring Microsoft Office
4(2)
Objective 2 Create a Folder for File Storage
6(1)
Activity 1.02 Creating a Folder for File Storage
7(1)
More Knowledge Creating a Microsoft Account
7(18)
Objective 3 Download and Extract Zipped Files, Enter and Edit Text in an Office Application, and Use Editor to Check Documents
10(1)
Activity 1.03 Downloading and Extracting Zipped Files from MyLab IT and Entering and Editing Text in an Office Program
11(3)
Activity 1.04 Checking Spelling
14(1)
Objective 4 Perform Office Commands and Apply Office Formatting
15(1)
Activity 1.05 Performing Commands from a Dialog Box
15(3)
Activity 1.06 Using Undo and Applying Text Effects
18(1)
Activity 1.07 Performing Commands from and Customizing the Quick Access Toolbar
19(2)
Activity 1.08 Performing Commands from the Ribbon
21(4)
Activity 1.09 Minimizing the Ribbon
25(1)
More Knowledge Displaying KeyTips
25(1)
Activity 1.10 Changing Page Orientation and Zoom Level
25(1)
More Knowledge Zooming to Page Width
26(15)
Activity 1.11 Formatting Text by Using Fonts, Alignment, Font Colors, and Font Styles
27(3)
Activity 1.12 Using Format Painter
30(2)
Activity 1.13 Using Keyboard Shortcuts and Using the Clipboard to Copy, Cut, and Paste
32(4)
Activity 1.14 Adding Alternative Text for Accessibility
36(1)
Objective 5 Finalize an Office Document
37(1)
Activity 1.15 Inserting a Footer, Inserting Document Info, and Adding Document Properties
37(1)
Activity 1.16 Inspecting a Document
38(1)
Activity 1.17 Inserting a Bookmark and a 3D Model
39(1)
Activity 1.18 Printing a File and Closing a Desktop App
40(1)
More Knowledge Creating an Electronic Image of Your Document
41(3)
Objective 6 Use the Office Help Features
41(1)
Activity 1.19 Using Microsoft Office Tell Me, Tell Me More, the Help Tab, and Adding Alt Text to an Excel Chart
41(3)
More Knowledge Don't Type, Talk! With the New Dictate Feature
44(1)
Project 1B Hotel Files
45(14)
Objective 7 Explore Windows 10
46(1)
Activity 1.20 Recognizing User Accounts in Windows 10
47(2)
Activity 1.21 Turning On Your Computer, Signing In, and Exploring the Windows 10 Environment
49(4)
Activity 1.22 Pinning a Program to the Taskbar
53(1)
Objective 8 Prepare to Work with Folders and Files
54(1)
Activity 1.23 Creating a New Folder to Store a File
54(5)
More Knowledge Use OneDrive as Cloud Storage
59(1)
Activity 1.24 Creating and Saving a File
59(1)
More Knowledge Jump to a Lettered Section of the Apps List Quickly
60(5)
More Knowledge The Hamburger Icon
65(18)
Activity 1.25 Downloading and Extracting Zipped Files
65(1)
Activity 1.26 Locating and Inserting a Saved File Into a PowerPoint Presentation
66(1)
Activity 1.27 Using Snap and Task View
66(4)
Objective 9 Use File Explorer to Extract Zipped Files and to Display Locations, Folders, and Files
70(1)
Activity 1.28 Navigating with File Explorer
71(2)
Activity 1.29 Using File Explorer to Extract Zipped Files
73(1)
Activity 1.30 Using File Explorer to Display Locations, Folders, and Files
74(4)
Objective 10 Start Programs and Open Data Files
78(1)
Activity 1.31 Starting Programs
78(2)
Activity 1.32 Opening Data Files
80(3)
More Knowledge Do Not Clutter Your Desktop by Creating Desktop Shortcuts or Storing Files
83(8)
Activity 1.33 Searching, Pinning, Sorting, and Filtering in File Explorer
84(1)
Objective 11 Create, Rename, and Copy Files and Folders
85(1)
Activity 1.34 Copying Files from a Removable Storage Device to the Documents Folder on the Hard Disk Drive
85(2)
Activity 1.35 Creating Folders, Renaming Folders, and Renaming Files
87(2)
Activity 1.36 Copying Files
89(1)
Activity 1.37 Moving Files
90(1)
More Knowledge Using Shift + Click to Select Files
91(3)
Activity 1.38 Copying and Moving Files by Snapping Two Windows
92(2)
More Knowledge Deleting Files and Using the Recycle Bin
94(1)
GO! To Work
95(1)
End of
Chapter
96(1)
Summary; GO! Learn It Online
96(1)
Glossary
97(4)
INTRODUCTION TO Microsoft world 2019
101(68)
Chapter 1 Creating Documents with Microsoft Word
103(66)
Project 1A Flyer
104(3)
Objective 1 Create a New Document and Insert Text
105(1)
Activity 1.01 Creating a New Word Document
105(2)
More Knowledge Word's Default Settings Are Easier to Read Online
107(2)
Activity 1.02 Inserting Text from Another Document
107(1)
Objective 2 Insert and Format Graphics
108(1)
Activity 1.03 Formatting Text by Using Text Effects
108(1)
More Knowledge Clear Existing Formatting
109(5)
Activity 1.04 Inserting Pictures
109(1)
Activity 1.05 Wrapping Text Around a Picture Using Layout Options
110(1)
Activity 1.06 Resizing Pictures and Using Live Layout
111(1)
Activity 1.07 Positioning a Picture
112(2)
Activity 1.08 Applying Picture Effects
114(1)
More Knowledge Applying Picture Styles
114(10)
Activity 1.09 Applying Artistic Effects
114(1)
Activity 1.10 Adding a Page Border
115(1)
Objective 3 Insert and Modify Text Boxes and Shapes
116(1)
Activity 1.11 Inserting, Sizing, and Positioning a Shape
116(1)
Activity 1.12 Typing Text in a Shape and Formatting a Shape
117(1)
Activity 1.13 Inserting a Text Box
118(1)
Activity 1.14 Sizing and Positioning a Text Box and Formatting a Text Box Using Shape Styles
119(1)
Objective 4 Preview and Print a Document
120(1)
Activity 1.15 Adding a File Name to the Footer by Inserting a Field
120(2)
Activity 1.16 Adding Document Properties and Previewing and Printing a Document
122(2)
GO! With Google Docs
124(2)
Objective Create a Flyer Using Google Docs
124(2)
Project 1B Information Handout
126(11)
Objective 5 Change Document and Paragraph Layout
127(1)
Activity 1.17 Setting Margins
127(1)
Activity 1.18 Aligning Paragraphs
128(2)
Activity 1.19 Setting Line Spacing
130(1)
Activity 1.20 Indenting Text
131(2)
Activity 1.21 Setting Space Before and After Paragraphs
133(1)
Objective 6 Create and Modify Lists
134(1)
Activity 1.22 Creating a Bulleted List
134(1)
Activity 1.23 Creating a Numbered List
135(2)
More Knowledge To End a List
137(10)
Activity 1.24 Customizing Bullets
137(2)
Objective 7 Set and Modify Tab Stops
139(1)
Activity 1.25 Setting Tab Stops
139(2)
Activity 1.26 Modifying Tab Stops
141(2)
Objective 8 Insert and Format a SmartArt Graphic and an Icon
143(1)
Activity 1.27 Inserting a SmartArt Graphic
143(1)
Activity 1.28 Sizing and Formatting a SmartArt Graphic
144(1)
Activity 1.29 Inserting an Icon
145(2)
GO! With Google Docs
147(2)
Objective Create an Information Handout
147(2)
GO! To Work
149(1)
End of
Chapter
150(19)
Summary; GO! Learn It Online; GO! Collaborative Team Project
150(1)
Project Guide for Word
Chapter 1
151(1)
Glossary
152(1)
Chapter Review
153(6)
Content-Based Assessments: Mastery, Critical Thinking, and Problem Solving
159(8)
Content-Based Assessment Rubric
167(1)
GO! Think
168(1)
INTRODUCTION TO Microsoft Excel 2019
169(72)
Chapter 1 Creating a Worksheet and Charting Data
171(70)
Project 1A Sales Report with Embedded Column Chart and Sparklines
172(16)
Objective 1 Create, Save, and Navigate an Excel Workbook
173(1)
Activity 1.01 Starting Excel, Navigating Excel, and Naming and Saving a Workbook
173(3)
Objective 2 Enter Data in a Worksheet
176(1)
Activity 1.02 Entering Text, Using AutoComplete, and Using the Name Box to Select a Cell
176(1)
Activity 1.03 Using Auto Fill and Keyboard Shortcuts
177(2)
Activity 1.04 Aligning Text and Adjusting the Size of Columns
179(2)
Activity 1.05 Entering Numbers
181(1)
Objective 3 Construct and Copy Formulas and Use the SUM Function
182(1)
Activity 1.06 Constructing a Formula and Using the SUM Function
182(2)
Activity 1.07 Copying a Formula by Using the Fill Handle
184(1)
Objective 4 Format Cells with Merge & Center, Cell Styles, and Themes
185(1)
Activity 1.08 Using Merge & Center and Applying Cell Styles
185(1)
Activity 1.09 Formatting Financial Numbers
186(2)
Activity 1.10 Changing the Workbook Theme
188(1)
More Knowledge Formatting a Cell's Font, Style, Size, or Color with Individual Commands
188(13)
Objective 5 Chart Data to Create a Column Chart and Insert Sparklines
188(1)
Activity 1.11 Charting Data and Using Recommended Charts to Select and Insert a Column Chart
188(3)
Activity 1.12 Using the Chart Tools to Apply Chart Styles
191(3)
Activity 1.13 Creating and Formatting Sparklines
194(1)
Objective 6 Print a Worksheet, Display Formulas, and Close Excel
195(1)
Activity 1.14 Creating a Footer and Centering a Worksheet
195(2)
Activity 1.15 Adding Document Properties and Printing a Workbook
197(1)
Activity 1.16 Printing a Section of the Worksheet
198(1)
Activity 1.17 Changing Page Orientation and Displaying, Printing, and Hiding Formulas
198(3)
GO! With Google Sheets
201(2)
Objective Create a Sales Report with an Embedded Column Chart Using Google Sheets
201(2)
Project 1B Inventory Valuation
203(9)
Objective 7 Check Spelling in a Worksheet
204(1)
Activity 1.18 Checking Spelling in a Worksheet
204(2)
Objective 8 Enter Data by Range
206(1)
Activity 1.19 Entering Data by Range
206(1)
Objective 9 Construct Formulas for Mathematical Operations
207(1)
Activity 1.20 Using Arithmetic Operators
207(1)
Activity 1.21 Using the Quick Analysis Tool
208(2)
Activity 1.22 Copying Formulas Containing Absolute Cell References
210(2)
More Knowledge Calculate a Percentage if You Know the Total and the Amount
212(7)
Objective 10 Edit Values in a Worksheet
212(1)
Activity 1.23 Editing Values in a Worksheet
212(1)
Activity 1.24 Formatting Cells with the Percent Style
213(1)
Objective 11 Format a Worksheet
214(1)
Activity 1.25 Inserting and Deleting Rows and Columns
214(1)
Activity 1.26 Adjusting Column Widths and Wrapping Text
215(1)
Activity 1.27 Changing Theme Colors
216(3)
GO! With Google Sheets
219(2)
Objective Creating an Inventory Valuation Report
219(2)
GO! To Work
221(1)
End of
Chapter
222(19)
Summary; GO! Learn It Online; GO! Collaborative Team Project
222(2)
Glossary
224(2)
Chapter Review
226
Project Guide for Excel
Chapter 1
223(9)
Mastering Excel
232(7)
Rubric
239(1)
GO! Think
240(1)
INTRODUCTION TO Microsoft Access 2016
241(78)
Chapter 1 Getting Started with Microsoft Access 2019
243(76)
Project 1A Student Advising Database with Two Tables
244(7)
Objective 1 Identify Good Database Design
245(1)
Activity 1.01 Using Good Design Techniques to Plan a Database
245(1)
Objective 2 Create a Table and Define Fields in a Blank Desktop Database
246(1)
Activity 1.02 Starting with a Blank Database
247(2)
Activity 1.03 Assigning the Data Type and Name to Fields
249(2)
More Knowledge Create Fields by Entering Data
251(3)
Activity 1.04 Renaming Fields, Changing Data Types, and Setting Field Size in a Table
251(1)
Activity 1.05 Adding a Record to a Table
252(2)
More Knowledge Renaming or Deleting a Table
254(6)
Activity 1.06 Adding Additional Records to a Table
254(1)
Activity 1.07 Importing Data from an Excel Workbook into an Existing Access Table
254(3)
Objective 3 Change the Structure of Tables and Add a Second Table
257(1)
Activity 1.08 Deleting a Table Field in Design View
257(2)
Activity 1.09 Adding Field Descriptions and Changing Field Size
259(1)
More Knowledge Add a Table Description
260(18)
Activity 1.10 Viewing the Primary Key in Design View
260(1)
Activity 1.11 Adding a Second Table to a Database by Importing an Excel Spreadsheet
261(3)
Activity 1.12 Adjusting Column Widths and Viewing a Table in Print Preview
264(2)
Activity 1.13 Viewing a Table in Print Preview
266(3)
Objective 4 Create a Query, Form, and Report
269(1)
Activity 1.14 Creating a Query by Using the Simple Query Wizard
269(3)
Activity 1.15 Creating a Form
272(2)
Activity 1.16 Creating and Modifying a Report
274(3)
Objective 5 Close a Database and Close Access
277(1)
Activity 1.17 Closing a Database and Closing Access
277(1)
GO! With Google
278(3)
Objective Export an Access Table to an Excel Spreadsheet, Open as a Google Sheet, Edit a Record, and Save to Your Computer
278(3)
Project 1B Student Workshops Database
281(8)
Objective 6 Use a Template to Create a Database
282(1)
Activity 1.18 Using a Template to Create a Database
282(1)
Activity 1.19 Building a Table by Entering Records in a Multiple-Items Form and a Single-Record Form
283(2)
Activity 1.20 Appending Records by Importing from an Excel Spreadsheet
285(1)
Objective 7 Organize Objects in the Navigation Pane
286(1)
Activity 1.21 Grouping Database Objects in the Navigation Pane
286(2)
Objective 8 Create a New Table in a Database Created with a Template
288(1)
Activity 1.22 Using the Table Tool to Create a New Table
288(1)
More Knowledge Create a Table from a Template with Application Parts
289(3)
Activity 1.23 Entering Records Into a New Table
289(2)
Objective 9 View a Report
291(1)
Activity 1.24 Viewing a Report
291(1)
GO! With Google
292(2)
Objective Export an Access Table to a Word Document, Save to Google Drive, Add a Record, and Save to Your Computer
292(2)
GO! To Work
294(1)
End of
Chapter
295(24)
Summary; GO! Learn It Online; GO! Collaborative Team Project
295(1)
Project Guide for Access
Chapter 1
296(1)
Glossary
297(2)
Chapter Review
299(7)
Mastering Access
306(10)
Rubric
316(1)
GO! Think
317(2)
INTRODUCTION TO Microsoft PowerPoint 2019
319(2)
Chapter 1 Getting Started with Microsoft PowerPoint
321(1)
Project 1A Company Overview Presentation
322(1)
Objective 1 Create a New Presentation
323(1)
Activity 1.01 Identifying Parts of the PowerPoint Window
323(2)
Activity 1.02 Entering Presentation Text
325(1)
Activity 1.03 Applying a Presentation Theme
326(1)
Objective 2 Edit a Presentation in Normal View
327(1)
Activity 1.04 Inserting a New Slide
327(3)
Activity 1.05 Increasing and Decreasing List Levels
330(1)
Activity 1.06 Adding Speaker Notes to a Presentation
331(1)
Activity 1.07 Displaying and Editing Slides in the Slide Pane
331(2)
Objective 3 Add Pictures to a Presentation
333(1)
Activity 1.08 Inserting a Picture from a File
333(2)
Activity 1.09 Applying a Style to a Picture
335(1)
Activity 1.10 Applying and Removing Picture Artistic Effects
336(1)
Objective 4 Print and View a Presentation
337(1)
Activity 1.11 Viewing a Slide Show
337(1)
Activity 1.12 Using Presenter View
338(2)
Activity 1.13 Inserting Headers and Footers on Slide Handouts
340(1)
Activity 1.14 Inserting Slide Numbers on Slides
341(2)
Activity 1.15 Printing Presentation Handouts
343(2)
Activity 1.16 Printing Speaker Notes
345(1)
GO! With Google Slides
346(2)
Objective Create a Company Overview Presentation in Google Slides
346(2)
Project 1B Itinerary Presentation
348(3)
Objective 5 Edit an Existing Presentation
349(1)
Activity 1.17 Changing Slide Size
349(1)
Activity 1.18 Inserting Slides from an Existing Presentation
350(1)
More Knowledge Inserting All Slides
351(16)
Activity 1.19 Displaying and Editing the Presentation Outline
352(1)
Activity 1.20 Deleting and Moving a Slide
353(1)
Activity 1.21 Finding and Replacing Text
354(1)
Objective 6 Format a Presentation
354(1)
Activity 1.22 Applying a Theme Variant
354(1)
Activity 1.23 Changing Fonts and Font Sizes
355(1)
Activity 1.24 Changing Font Styles and Font Colors
356(1)
Activity 1.25 Aligning Text
357(1)
Activity 1.26 Changing Line Spacing
358(1)
Activity 1.27 Changing the Slide Layout
359(1)
Objective 7 Use Slide Sorter View
359(1)
Activity 1.28 Deleting Slides In Slide Sorter View
360(1)
Activity 1.29 Moving a Single Slide in Slide Sorter View
360(1)
Activity 1.30 Selecting Contiguous and Noncontiguous Slides and Moving Multiple Slides
361(2)
Objective 8 Apply Slide Transitions
363(1)
Activity 1.31 Applying Slide Transitions to a Presentation
363(1)
Activity 1.32 Setting Slide Transition Timing Options
364(1)
Activity 1.33 Displaying a Presentation in Reading View
365(2)
GO! With Google Slides
367(2)
Objective Create an Itinerary Presentation in Google Slides
367(2)
GO! To Work
369(1)
End of
Chapter
370(1)
Summary; GO! Learn It Online; GO! Collaborative Team Project
370(1)
Project Guide for PowerPoint
Chapter 1
371(1)
Glossary
372(1)
Chapter Review
373(6)
Mastering PowerPoint
379(7)
Rubric
386(1)
GO! Think
387
Glossary 1(1)
Index 1
About our authors Shelley Gaskin (series editor) is a professor in the Business and Computer Technology Division at Pasadena City College in Pasadena, California. She holds a bachelor's degree in Business Administration from Robert Morris College (Pennsylvania), a master's degree in Business from Northern Illinois University, and a doctorate in Adult and Community Education from Ball State University (Indiana). Before joining Pasadena City College, she spent 12 years in the computer industry, where she was a systems analyst, sales representative, and director of Customer Education with Unisys Corporation. She also worked for Ernst & Young on the development of large systems applications for their clients. She has written and developed training materials for custom systems applications in both the public and private sector and has also written and edited numerous computer application textbooks.

Alicia Vargas (Word and Excel author) is a faculty member in Business Information Technology at Pasadena City College. She holds a master's and a bachelor's degree in business education from California State University, Los Angeles, and has authored several textbooks and training manuals on Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.

Debra Geoghan (PowerPoint author) is a Professor of Computer Science in the STEM department at Bucks County Community College, teaching computer classes ranging from basic computer literacy to cybercrime, computer forensics, and networking. She has certifications from Microsoft, CompTIA, and Apple. Deb has taught at the college level since 1996 and alsospent 11 years in the high school classroom. She holds a B.S. in Secondary Science Education from Temple University and an M.A. in Computer Science Education from Arcadia University.

Throughout her teaching career Deb has worked with educators to integrate technology across the curriculum. At BCCC she serves on many technology committees, presents technology workshops for BCCC faculty, and heads the Computer Science Area. Deb is an avid user of technology, which has earned her the nickname gadget lady.

Nancy Graviett (Access author) is a professor and department chair in Business Technology at St. Charles Community College inCottleville, Missouri. She holds a bachelor's degree in marketing and a master's degree in business education from the University of Missouri and has completed a certificate in online education. Nancy has authored textbooks on WordPerfect, Google, Microsoft Outlook, and Microsoft Access.