Learning Computer Applications: Projects & Exercises : Step-By-Step Exercises and Applications

by Bucki, Lisa A.; Fischer, Judy

• ISBN13: 9781562437503
• ISBN10: 156243750X
• Format: Paperback
• Copyright: 1999-05-01
• Publisher: Prentice Hall

Table of Contents

Introduction
I. Introduction to Computers and Applications
Computer Basics	1	(3)
Types of Applications	4	(2)
Understanding Features of Windows and Windows Applications	6	(6)
Understanding Features of Macintosh and Macintosh Applications	12	(8)
II. Word Processing
Getting Started with Word Processing	20	(11)
Skills Covered:
Create new documents
Save new documents
Close an open document
Move the insertion point in the document
Check spelling in a document
Basic Editing	31	(13)
Skills Covered:
Open an existing document
Insert and delete text
Work with proofreader's marks
Print an open document
Preview an open document
Mark edits in a document
Accept or reject edits
Formatting Basics	44	(19)
Skills Covered:
Align text in a document
Center text in a document
Apply text attributes
Work with fonts and font sizes
Use superscript, subscript, and symbols
Insert bullets
Correct errors with the Undo feature
Advanced Formatting	63	(16)
Skills Covered:
Set margins and indent text
Adjust line spacing
Set tabs
Copy format in a document
Copy and move text in a document
Improving Organization, Appearance, and Word Choice	79	(16)
Skills Covered:
Create and edit an outline
Work with styles
Use the theasurus
Find and replace text in a document
Working with Multiple-Page Documents	95	(32)
Skills Covered:
Create page and section breaks in a document
Work with multiple-page letters and reports
Enhance a document with headers, footers, and page numbers
Add headers and footers to multiple-page documents
Use endnotes
Add comments to a document
Practice moving and copying text in multiple-page documents
Creating Columns and Tables	127	(25)
Skills Covered:
Work with newspaper-style columns
Set custom widths in columns
Table basics
Format and edit a table
Sort information in a table
Creating Documents with Merge	152	(19)
Skills Covered:
Merge Basics
Work with main and data documents
Create envelopes and labels
Advanced Word-Processing	171	(16)
Skills Covered:
Copy and move text between documents
Work with automatic text entries
Create and run macros
Insert a file into a document
III. Desktop Publishing
Enhancing Documents with Graphics, Rules, and Boxed Text	187	(21)
Skills Covered:
Get started with clip art
Enhance a document with lines, borders, and shading
Work with text and graphics
Create a graphic with a caption
Mastering the Drawing Tools	208	(17)
Skills Covered:
Work with shapes
Create different effects with layered shapes
Enhance drawing lines with width and color
Compose grouped objects
Advanced Tools and Effects	225	(25)
Skills Covered:
Work with text design, reverse text, and letter spacing
Create drop capitals in newsletters
Enhance a document with water marks
Format text with pull quotes
IV. Spreadsheet
Getting Started with Spreadsheet Basics	250	(14)
Skills Covered:
Create a spreadsheet
Move within a spreadsheet
Enter information in a spreadsheet
Print a spreadsheet
Save and close a spreadsheet file
Entering Formulas and Formating a Spreadsheet	264	(11)
Skills Covered:
Work with formulas and quick sums
Format a spreadsheet
Apply number and date formats
Spreadsheet Enhancements	275	(14)
Skills Covered:
Adjust column width in a spreadsheet
Add borders and shading to a spreadsheet
Work with copy and move features
Use the fill feature
Enhance a spreadsheet with automatic formats
Printing Options and Working with Functions	289	(23)
Skills Covered:
Function basics
Set up print options
Work with headers and footers
Preview a spreadsheet
V. Database
Getting Started with Database Basics	312	(17)
Skills Covered:
Plan a database
Create a database
Enter information into a database
Save a database
Work with forms
Basic Database Editing and Printing	329	(14)
Skills Covered:
Work with forms and tables
Adjust column and field width
Preview and print a database
Formatting a Database	343	(21)
Skills Covered:
Work with fonts and font attributes
Adjust margins in a data table
Practice inserting and deleting records
Apply filters
VI. Presentation Graphics
Getting Started with Presentation Graphics	364	(11)
Skills Covered:
Create a presentation
Work with views
Add speaker notes to a presentation
Print a presentation
Save and close a presentation
Editing and Formating a Presentation	375	(20)
Skills Covered:
Add slides to a presentation
Enhance a presentation with clip art and design templates
Format slide text with decorative fonts and text alignments
Work with charts and tables on slides
Design a slide master
Setting Up a Slide Show	395	(9)
Skills Covered:
Work with transitions, builds, and animation
Run a slide show
VII. Integration and Internet Features
Application Integration	404	(19)
Skills Covered:
Integrate a word processing outline and a presentation
Add a spreadsheet to a word processing document
Add a spreadsheet to a presentation
Use a database to create a merge document
Import information from a spreadsheet to a database
Using Internet Features	423
Skills Covered:
Find help and information on the Web
E-mail from an application
E-mail a file
Save a word processing document as a Web page
Save a spreadsheet as a Web page
Save a presentation as a Web page
View database information in Web format
Insert and use hyperlinks
VIII. Appendixes
Appendix A: Spreadsheet Grid	444
Appendix B: Database Planning Worksheet	446
IX. Glossary
X. Index
XI. Bonus Lessons on CD
Supplementary Word Processing Exercises
Skills Covered:
Use templates to create documents
Create a resume
Format a bibliography and news release
Creating Charts in a Spreadsheet
Skills Covered:
Chart basics
Present data using bar charts and pie charts
Add labels to a chart
Create stacked bar charts
Finding Records and Querying a Database
Skills Covered:
Find matching records one at a time
Create a query
Use operators to create a more powerful query
Sorting a Database and Creating Reports
Skills Covered:
Master the sort feature
Present information in a report
Enhance and print a report
Work with grouped data