|
Outline
Concepts of information technology
Overview of information technology
Hardware and storage devices
Software
Networks
Computers and society
Computers in daily life
Impact of IT on society
Security and legal issues
Using computers and managing files
Basic computer operations
The Help and Support Center
The desktop
Working with windows
Windows XP system settings
Folder and file management
File and folder structure
Basic text editing
Manipulating files and folders
Managing files and folders
Deleting and restoring files
Printer and virus management
Printer management
Viruses
Word processing
Getting started
Basic view settings
Getting help
Adding and modifying text
Working with text
Editing documents
Finding and replacing text
Formatting text
Paragraphs and tables
Formatting paragraphs
Formatting documents
Creating and managing tables
Graphics and mail merge
Graphics
Letters and mailings
Proofing and printing documents
Proofing documents
Printing
Spreadsheets
Getting started
Working in the Excel environment
| Spreadsheet structure
Entering and editing data
Finding, replacing, and sorting data
Manipulating worksheets
Formulas and formats
Formulas and functions
Formatting
Charts and printing
Working with charts
Printing and proofing worksheets
Databases
Database basics
Getting started
Database tables
Getting help
Working with tables
Working with fields
Manipulating records
Managing tables
Relating tables
Printing options
Forms and queries
Creating forms
Modifying forms
Finding, sorting, and filtering records
Using queries
Previewing and printing forms and queries
Reports
Creating reports
Working with reports
Printing reports
Presentations
Getting started
Getting help
Saving and closing presentations
Creating and formatting presentations
Creating presentations
Formatting text
Working with text
Using drawing tools
Drawing objects
Working with text in objects
Working with graphics Customizing presentations
Using templates
Working with slide masters
Customizing slide shows
Customizing the environment
Working with speaker notes
Charts
Creating and formatting charts
Organization charts
Proofing and delivering presentations
Proofing presentations
Printing presentations
Saving presentations for Web delivery
The Internet and Internet Explorer
Introducing the Internet
Introducing Internet Explorer
Getting help
Exploring the Web
Working with Web pages
Searching the Internet
Performing advanced searches
Customizing Search features
Working with Web pages
Working with Favorites
Using links and toolbars
Using the History list
Printing Web content
Internet transactions and security
Internet transactions
Web security
Outlook basics
Understanding e-mail basics
Using Outlook
Using Outlook Help
Working with e-mail messages
E-mail accounts
E-mail messages
Working with attachments
Managing e-mail
Using personal folders
Searching and sorting messages
Printing messages
Using address books
|
After completing this course, students will know how to:
- Explain what information technology is.
- Describe the influence of computers on society.
- Perform basic computer operations and use file management techniques.
- Explore the contents of a hard disk, manage files and folders, and use a basic
text editor to create and save documents.
- Manage a printer, monitor print jobs, protect computers from viruses, and scan
files for viruses.
- Start and explore Word, use templates, change the basic view settings, and use
Help and the Office Assistant.
- Add text in Word, insert special characters, use the Undo and Redo commands,
edit text, find and replace text, and format text.
- Format paragraphs, format documents, and create and manage tables.
- Insert clip art, charts, and pictures in Word; add an AutoShape; create form
letters and a data source; and use Mail Merge to create mailing labels.
- Use the Spelling and Grammar feature in a document, and preview and print
documents.
- Start Excel, and create, open, save, and close a workbook.
- Insert and manipulate data in a worksheet; find, replace, and sort data;
manipulate rows and columns; and insert, move, copy, delete, and rename
worksheets.
- Enter formulas, use arithmetic functions, format numbers and text, set
alignments, and use the Format Painter.
- Create and format charts, identify types of charts, and preview, proof, and
print worksheets.
- Define and plan a database; open, create, and close a database in Access;
create, save, close, and delete a table; and use Help.
- Add and delete fields; set field properties; manipulate data in a table; sort,
filter, and navigate in a table; and set table relationships.
- Create, modify, save, and close forms; sort and filter records in forms; create
and modify queries; and preview and print forms and queries.
- Create, save, manipulate, and print reports.
- Start PowerPoint, run a presentation, use Help, and save and close a
presentation.
- Create a new PowerPoint presentation, add and delete slides, format slides, and
work with text.
- Work with objects, add and edit AutoShapes, add text to objects and adjust the
text, insert images and clip art, apply color effects, and edit images.
- Use templates, work with the slide master, customize slide shows and the
PowerPoint environment, and add speaker notes to a presentation.
- Create and modify a chart, and create, modify, and add levels to an
organization chart.
- Check the spelling and style in a presentation; print a presentation, a slide,
handouts, and Notes Pages; save and publish presentations; add links to the
text in a presentation; and send a presentation through e-mail.
- Describe the Internet and the World Wide Web, start Internet Explorer, navigate
in the browser, and use Help.
- Work with Web pages, use the Search Companion pane, use the Advanced Search
option, and customize the search features.
- Use Favorites, the Links bar, and the History list in Internet Explorer, and
print Web pages.
- Understand the concepts of Internet transactions and Web security.
- Work with e-mail, understand security considerations, explore the Outlook 2003
environment, and use Outlook Help.
- Work with e-mail accounts, e-mail messages, and attachments in Outlook.
- Create personal folders, delete and restore messages, search for messages, sort
messages, print messages, and use address books.
|