Learning Computer Applications: Projects and Exercises

by Bucki, Lisa

• ISBN13: 9781585771295
• ISBN10: 1585771295
• Edition: 3rd
• Format: Paperback
• Copyright: 2005-01-01
• Publisher: Pearson College Div

Table of Contents

Introduction
I. Introduction to Computers and Applications
Computer Basics	1	(3)
Types of Applications	4	(3)
Understanding Features of Windows & Windows Applications	7	(5)
Understanding Features of Macintosh & Macintosh Applications	12	(8)
II. File Management
Manage Your Files	20	(14)
Explore Your Desktop
Work with Folders
Find Files
Quiz Break 1	30	(4)
III. Word Processing
Create and Save Documents Skills Covered:	34	(17)
Create new documents
Save new documents
Close an open document
Move the insertion point in the document
Check spelling in a document
Use voice recognition to create text
Open and Edit Documents	51	(18)
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
Text Alignments and Enhancements	69	(20)
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
Format and Edit Documents	89	(17)
Set margins and indent text
Adjust line spacing
Set tabs
Copy format in a document
Copy and move text in a document
Additional Formatting and Editing	106	(18)
Create and edit an outline
Work with styles
Use the thesaurus and hyphenation
Find and replace text in a document
Quiz Break 2	122	(2)
Working with Multiple-Page Documents	124	(32)
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
Formatting Columns and Tables	156	(26)
Work with newspaper-style columns
Set custom widths in columns
Table basics
Format and edit a table
Sort information in a table
Merge Documents	182	(19)
Merge basics
Work with main and data documents
Create envelopes and labels
Work with Multiple Documents and Repetitive Text	201	(21)
Copy and move text between documents
Work with automatic text entries
Use text shortcuts
Create and run macros
Insert a file into a document
Quiz Break 3	220	(2)
IV. Desktop Publishing
Working with Graphics, Rules, and Boxed Text	222	(24)
Get started with clip art
Enhance a document with lines, borders, and shading
Work with text and graphics
Create a graphic with a caption
Using Drawing Tools	246	(18)
Work with shapes
Create different effects with layered shapes
Enhance drawing lines with width and color
Compose grouped objects
Adding Special Effects	264	(27)
Work with text design, reverse text, and letter spacing
Create drop capitals in newsletters
Enhance a document with watermarks
Format text with pull quotes
Quiz Break 4	287	(4)
V. Spreadsheet
Create, Save, and Exit a Spreadsheet	291	(14)
Create a spreadsheet
Move within a spreadsheet
Enter information in a spreadsheet
Print a spreadsheet
Save and close a spreadsheet file
Use Formulas; Spreadsheet Enhancements	305	(11)
Work with formulas and quick sums
Format a spreadsheet
Apply number and date formats
Use Formulas; Spreadsheet Enhancements	316	(14)
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
Use Functions and Range Names	330	(9)
Function basics
Name spreadsheet ranges
Use range names in functions
Working with common functions
Print and Chart Spreadsheet Information	339	(18)
Set up print options
Work with headers and footers
Preview a spreadsheet
Create and label a chart
Quiz Break 5	353	(4)
VI. Database
Plan, Create, and Save a Database Table and Form	357	(17)
Plan a database
Create a database
Save a database
Work with forms
Add Records and Print a Database	374	(15)
Work with forms and tables
Add records
Adjust column and field width
Preview and print a database
Edit and Enhance a Database	389	(17)
Work with fonts and font attributes
Adjust margins in a data table
Practice inserting and deleting records
Apply filters
Find Records and Query a Database	406	(20)
Find matching records one at a time
Create a simple query
Use operators to create a more powerful query
Sort the database
Use a report
Quiz Break 6	422	(4)
VII. Presentation Graphics
Create, Save, and Print a Presentation	426	(14)
Create a presentation
Work with views
Add speaker notes to a presentation
Print a presentation
Save and close a presentation
Edit and Enhance Slides	440	(21)
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
Work with Slide Shows	461	(12)
Work with transitions, builds, and animation
Run a slide show
Quiz Break 7	469	(4)
VIII. Integration & Communications on CD
These lessons are on the CD that comes with this book. See the introduction for information on accessing these files
Use Programs and Files Together	473	(23)
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
Save word processing or spreadsheet information in alternate formats
Export a database's contents
Work with Web Design Features	496	(20)
Save a word processing document as a Web page
Work with Web page formatting in your word processing program
Save a spreadsheet as a Web page
Save a presentation as a Web page
View database information in Web format
Insert and use hyperlinks
Work on the Web	516	(9)
Find help and information on the Web
Practice with your browser
Search for information on the Web
Download extras from the Web
Manage Your E-Mail	525	(14)
E-mail from an application
E-mail a file
E-mail from your e-mail program
Work with your e-mail
Work with your address book
Manage Your Time	539
Build a to-do list
Track and print your appointments
Work with an appointment reminder
Make a task assignment
Quiz Break 8	551
IX. APPENDIXES
Appendix A: Spreadsheet Grid
Appendix B: Database Planning Worksheet
X. Index