Untitled document
Upon completion of this course, students will be able to:
1. Explain the Word, Excel, PowerPoint, and Access windows and narrative dialogue boxes.
2. Create Word documents, Excel worksheets, PowerPoint presentations, and Access databases.
3. Modify, edit, enhance, and use text, formats, graphics, and Format Painter in all four programs.
4. Manage multiple Excel worksheets.
5. Using Excel, input data, create formulas, use absolute cell references, and create 3-D pie charts.
6. Using Access, compile data, design a database, and create reports.
7. Using Access, create queries, use compound criteria in queries, and join tables in queries.
8. In PowerPoint, create title and text slides with bullets, graphics, links and ClipArt.
Untitled document
1. Creating Documents with Microsoft Word
2. Formatting and Organizing Text
a. Changing document and paragraph layout
b. Creating and modifying lists
c. Creating a research paper
3. Creating a Worksheet and Charting Data
4. Managing Workbooks and Analyzing Data
a. Navigating a Workbook and renaming Worksheets
b. Entering dates, clearing contents and formats
c. Editing and formatting multiple Worksheets at the same time
d. Constructing formulas that refer to cells in another Worksheet
e. Formatting and printing multiple Worksheets in a Workbook
f. Designing a Worksheet for What-if Analysis
g. Creating a Line Chart and comparing data
5. Getting Started with Access Databases and Tables
a. Starting Access, creating and naming a folder, and creating a database from a new blank database
b. Adding records to a table
c. Renaming the fields in a table in datasheet view
d. Modify the design of a table
e. Adding records to a second table
f. Adjusting column widths and printing a table
g. Using the Simple Query Wizard to create a query
h. Creating and using a form
i. Creating and printing a Report
j. Creating a new database using a template
k. Organizing database objects in the navigation pane
l. Creating a new table and changing its design
m. Using the Access Help System
6. Sorting and Querying a Database
a. Opening and renaming an existing database while resolving security alerts
b. Creating table relationships and enforcing referential integrity
c. Sorting records in a table in ascending or descending order
d. Sorting records in a table on multiple fields
e. Creating a new select query in design view
f. Creating a new query from an existing query
g. Specifying criteria in a query
h. Creating a new table by importing an Excel worksheet
i. Specifying numeric criteria in a query
j. Using AND or OR criteria in a query
k. Creating a query based on more than one table
l. Using Wildcards in a query
m. Using calculated fields in a query
n. Using group data and calculating statistics in a query
7. Getting Started with Microsoft PowerPoint
a. Open, view, and save a PowerPoint presentation
b. Edit a presentation
c. Format a presentation
d. Creating headers and footers and printing a presentation
e. Starting a new presentation and inserting slides from an existing presentation
f. Using Slide Sorter view
g. Selecting, moving and deleting slides
h. Adding pictures and Clip Art images to slides
i. Moving and sizing images
j. Accessing PowerPoint Help
8. Designing a PowerPoint Presentation
a. Formatting slide elements
b. Inserting and formatting pictures and shapes
c. Applying slide transitions to a Presentation
d. Reorganizing presentation text and clearing formats
e. Creating and formatting a SmartArt graphic