Performing With Microsoft Office

by Blanc,Iris

• ISBN13: 9780619058654
• ISBN10: 061905865X
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2002-10-15
• Publisher: Cengage Learning

Summary

This workbook provides projects that require the creation of documents, forms, presentations, worksheets, databases, Web sites and Outlook management tools for a new business. The projects focus on developing SCANS skills, with emphasis on critical thinking, applying technology to task, and working in teams.

Table of Contents

PART I: TOOL-SPECIFIC PROJECTS
WORD
Word Basics	2	(20)
Basic Editing Review	4	(8)
Basic Formatting Review	12	(10)
Correspondence	22	(25)
Format Business & Personal Documents	24	(10)
Use Templates and Wizards	34	(8)
Compose and Send Documents	42	(5)
Reports and Long Documents	47	(28)
Multiple-Page Letters	48	(6)
Reports	54	(9)
Long Documents	63	(12)
Meeting Documents and Schedules	75	(26)
Documents for a Meeting	76	(12)
Schedules, Lists, and Programs	88	(13)
Sales and Marketing Documents	101	(38)
Flyers, Advertisements, and Press Releases	102	(10)
Invitations and Menus	112	(8)
Publications and Newsletters	120	(8)
Brochures and Catalogs	128	(11)
Integration	139	(14)
Working with Integrated Files	140	(6)
Work with the Web	146	(7)
EXCEL
Excel Basics	153	(14)
Enter and Format Data	156	(4)
Enter and Edit Formulas	160	(4)
Enhance and Edit Worksheet Data	164	(3)
Create Business Forms/Work with Templates	167	(14)
Purchase Orders	168	(4)
Sales Invoices	172	(4)
Work with Templates	176	(5)
Create Accounting Records	181	(17)
Ledger Accounts and Statements	182	(4)
Payroll	186	(4)
Journals	190	(4)
Asset Records	194	(4)
Create Data Analysis Worksheets	198	(22)
Income Statements	200	(6)
Budgets	206	(4)
Sales Analyses	210	(6)
Financial Analysis	216	(4)
Create Financial Reports	220	(26)
Trial Balance	222	(4)
Salary Analyses	226	(4)
Accounting Worksheets	230	(4)
Income Statement	234	(4)
Balance Sheet	238	(4)
Financial Report Analysis	242	(4)
Create Charts	246	(13)
Chart Sales Data	248	(4)
Chart Expense Data	252	(4)
Chart Investment Data	256	(3)
Integration	259	(19)
Integrate Charts and Worksheets into Documents	260	(6)
Other Integration Techniques	266	(6)
Integrate Internet Data into a Worksheet	272	(6)
POWERPOINT
PowerPoint Basics	278	(8)
Navigation, Views, and Printing Review	282	(4)
Informative Presentations	286	(11)
Create and Enhance Informative Presentations	288	(9)
Sales Presentations	297	(15)
Create and Enhance Sales Presentations	298	(14)
Persuasive Presentations	312	(34)
Create and Enhance Persuasive Presentations	314	(16)
Work with Slide Shows and Audience Materials	330	(12)
Work with the Web	342	(4)
Integration	346	(15)
Import and Export Text and Objects	348	(8)
Workgroup Collaboration	356	(5)
ACCESS
Access Basics	361	(11)
Explore a Database	364	(4)
Understand Database Design and Views	368	(4)
Access Tables and Datasheets	372	(17)
Create a Table with the Table Wizard	374	(4)
Create Tables and Enter Data	378	(4)
Enhance and Format Tables	382	(7)
Access Forms	389	(14)
Create and Use Forms	390	(6)
Edit and Enhance Forms	396	(4)
Create a Database Table and Form	400	(3)
Getting Information	403	(19)
Find, Replace, and Filter Data	404	(6)
Query a Database Using Wizards	410	(4)
Query a Database in Design View	414	(4)
Create Relationships and Multi-Table Queries	418	(4)
Access Reports	422	(18)
Create Reports with Wizards	424	(6)
Modify Reports	430	(6)
Create Tables, Relationships, a Form, a Query, and a Report	436	(4)
Integration	440
Import Data	442
Export Data	448
Data Access Pages	452
PART II: INTEGRATED SIMULATION PROJECTS
Organizing a Business Trip	461
New Employee Orientation	473
Starting a New Business	487
APPENDICES
Appendix A Portfolio Basics	506
Appendix B Proofreader's Marks	509
Appendix C Ways to Cite from Source Material	511
Appendix D Rubric for an Oral Report and PowerPoint Presentation Developed from Scratch	512