Butler Community College Business, Technology, and Workforce Development

Carol Klein Spring 2001

Advanced Computer Applications

Course Description

BE 245. Advanced Computer Applications. Three hours credit. Prerequisite: Microcomputer Applications, Information Processing Systems, or consent of instructor. This course will teach advanced applications in Word Processing, Spreadsheet, and Database, that are not covered in other courses. Students will use advanced features such as creating hypertext, generating form letters, managing workbooks, data tables, developing forms, building complex reports, macros, and customizing presentations.

Required Material

Text: Flynn, Meredith and Rutkosky, Rita. (2000). Advanced Microsoft Office 2000. St. Paul, MN: EMC Paradigm. ISBN: 0-7638-0265-4.

Software: Microsoft Office 2000, Windows 98, Internet access (available in computer labs and classrooms)

Course Objectives

At the successful completion of this course, the student should be able to:

Microsoft WORD:

A. Format with Special Features

1. Use AutoText
2. Apply paragraph and section shading
3. Use textflow options
4. Use Bookmarks
5. Create a cross-reference
6. Create and balance columns

B. Merge Form Documents, Mailing Labels, and Envelopes

1. Create a main document and data source
2. Merge
3. Sort and filter records to be merged
4. Prepare mailing labels and envelopes
5. Create catalogs and lists.

C. Sort and Select Data

1. Sort text in paragraphs and columns
2. Sort text in tables
3. Select records

D. Work with Shared Documents

1. Track changes
2. Insert comments
3. Create a template
4. Create multiple versions of a document
5. Create a master document and subdocuments

E. Create Tables and Indexes

1. Create a table of contents
2. Create an index
3. Create a table of figures
4. Create a table of authorities

F. Customize features

1. Create a macro
2. Run a macro
3. Format with Styles
4. Customize toolbars

G. Create Forms

1. Create a form
2. Fill in a form document
3. Customize form field options

H. Add Visual Elements

1. Insert and customize clip art
2. Create a watermark
3. Import worksheets
4. Create a chart

Microsoft EXCEL:

A. Apply Advanced Formats to Worksheets and Charts

1. Apply accounting, fraction, and scientific formats
2. Create a custom format
3. Use AutoFormats
4. Apply conditional formats
5. Apply styles and data validation
6. Enhance the appearance of worksheet charts.
7. Hide and unhide rows, columns, and sheets
8. Rename sheets.

B. Work with Templates and Workbooks

1. Create and edit templates
2. Use a workspace
3. Consolidate data
4. Link and share workbooks.

C. Use Advanced Functions

1. Use Financial Functions--PMT, PV
2. Use Math Functions--ROUND, RAND, SUMIF
3. Use Statistical Functions--COUNTIF
4. Use Named Ranges
5. Use Lookup Functions
6. Use the IF Function.

D. Work with Lists

1. Create and enter data
2. Use data validation
3. Sort data
4. Outline a worksheet
5. Subtotal a list
6. Filter a list.

E. Work with Analysis Tools and PivotTables

1. Create scenarios
2. Create a PivotTable report and chart
3. Use Goal seek
4. Use Solver.

F. Manage and Audit Worksheets

1. Record and run a macro
2. Work with toolbars
3. Use auditing tools.

G. Collaborate with Workgroups

1. Protect workbooks
2. Track Changes
3. Work with multiple worksheets
4. Use the report manager.

H. Import and Export Data

1. Import and export data
2. Place data on the web
3. Round-trip a workbook
4. Link and embed objects.

Microsoft ACCESS:

A. Build and Modify Advanced Tables

1. Modify table design
2. Define the primary key for a table
3. Use validation rules and text
4. Create and modify input masks
5. Set lookup fields.

B. Build and Modify Forms

1. Create and modify a form
2. Modify a control object
3. Create and modify a calculated control
4. Modify form properties
5. Create a switchboard page.

C. Refine Queries

1. Use filter by selection
2. Use filter by form
3. Create a totals query
4. Create a crosstab query
5. Create a parameter query
6. Create an action query
7. Use AND and OR expressions.

D. Use Advanced Report Features

1. Create and modify a report
2. Sort and group records
3. Add graphics
4. Modify properties
5. Calculate a total or average.

E. Work with Relationships in Tables and Queries

1. Create relationships among multiple tables
2. Enforce referential integrity
3. Create a query using related tables.
4. Set Cascade update and delete.

F. Use Access Tools

1. Set and remove a password
2. Encrypt and decrypt
3. Set startup options
4. Compact a database
5. Link an external table
6. Create a command button
7. Create a macro.

G. Integrate Access with Office Applications

1. Export to Excel
2. Create a data access page
3. Group and sort a data access page
4. Create hyperlinks.

If time allows-----

Microsoft POWERPOINT:

A. Add Visual Elements to Presentation

B. Import and Export Data

C. Customize a Presentation

D. Create a Slide Show

E. Create Output

F. Deliver Presentations

G. Link and Embed Objects.

Microsoft OUTLOOK:

A. Use Outlook for e-mail

B. Manage Contacts, Calendar, and Tasks

C. Manage Outlook's components.

Topical Outline of Units

WORD:

A. Format with Special Features

1. AutoText
2. Paragraph and section shading
3. Textflow
4. Bookmarks
5. Cross-reference
6. Columns

B. Mail Merge

1. Main document and data source
2. Merge
3. Sort and filter
4. Mailing labels and envelopes
5. Catalogs and lists.

C. Sort and Select Data

1. Sort text in paragraphs
2. Sort text in tables
3. Select records

D. Shared Documents

1. Track changes
2. Comments
3. Template
4. Multiple versions
5. Master document and subdocuments

E. Tables and Indexes

1. Table of contents
2. Index
3. Table of figures
4. Table of authorities

F. Customize features

1. Macro
2. Run a macro
3. Styles
4. Customize toolbars

G. Forms

1. Create a form
2. Fill in a form
3. Form field options

H. Visual Elements

1. Clip art
2. Watermark
3. Import
4. Chart

EXCEL:

A. Advanced Formats

1. Accounting, fraction, and scientific formats
2. Custom format
3. AutoFormats
4. Conditional formats
5. Styles and data validation
6. Appearance of worksheet charts.
7. Hide and unhide
8. Rename sheets

B. Templates and Workbooks

1. Create and edit
2. Workspace
3. Consolidate
4. Link and share

C. Advanced Functions

1. PMT, PV
2. ROUND, RAND, SUMIF
3. COUNTIF
4. Named Ranges
5. Lookup Functions
6. IF Function

D. Lists

1. Create and enter data
2. Data validation
3. Sort
4. Outline
5. Subtotal
6. Filter

E. Analysis Tools and PivotTables

1. Scenarios
2. PivotTable report and chart
3. Goal seek
4. Solver.

F. Audit Worksheets

1. Macro
2. Toolbars
3. Auditing tools

G. Workgroups

1. Protect
2. Track Changes
3. Multiple worksheets
4. Report manager

H. Import and Export

1. Import and export
2. Web
3. Round-trip
4. Link and embed objects

ACCESS:

A. Advanced Tables

1. Table design
2. Primary key
3. Validation rules
4. Input masks
5. Lookup fields.

B. Forms

1. Create and modify
2. Control object
3. Calculated control
4. Form properties
5. Switchboard page.

C. Queries

1. Filter by selection
2. Filter by form
3. Totals query
4. Crosstab query
5. Parameter query
6. Action query
7. AND and OR.

D. Advanced Report Features

1. Create and modify
2. Sort and group
3. Graphics
4. Properties
5. Total or average.

E. Relationships

1. Create relationships
2. Referential integrity
3. Related tables.
4. Cascade update and delete.

F. Tools

1. Password
2. Encrypt and decrypt
3. Startup options
4. Compact
5. Link
6. Command button
7. Macro.

G. Integrate Access

1. Export
2. Data access page
3. Group and sort
4. Hyperlinks.

If time allows-----

POWERPOINT:

A. Visual Elements

B. Import and Export

C. Customize

D. Slide Show

E. Output

F. Deliver

G. Objects.

Microsoft OUTLOOK:

A. E-mail

B. Contacts, Calendar, and Tasks

C. Components.

Method of Instruction

1. Lecture
2. Class discussion
3. Lab

Methods of Evaluation

A. Assignments from textbook and/or other reading material

B. Tests and quizzes

C. Lab assignments