ADMN 245 Office Technology Integration*

This course is designed as a culmination project for Administrative Assistant majors. Students will use advanced applications tools for the production of business documents, organizing and retrieving information managing financial information and working in work groups.

Credits

3

Semester Contact Hours Lecture

15

Semester Contact Hours Lab

45

General Education Competency

[GE Core type]

ADMN 245Office Technology Integration*

Please note: This is not a course syllabus. A course syllabus is unique to a particular section of a course by instructor. This curriculum guide provides general information about a course.

I. General Information

Department

Information Technology

II. Course Specification

Course Type

Program Requirement

General Education Competency

[GE Core type]

Credit Hours Narrative

3

Semester Contact Hours Lecture

15

Semester Contact Hours Lab

45

Grading Method

Letter grade

Repeatable

N

III. Catalog Course Description

This course is designed as a culmination project for Administrative Assistant majors. Students will use advanced applications tools for the production of business documents, organizing and retrieving information managing financial information and working in work groups.

IV. Student Learning Outcomes

Upon completion of this course, a student will be able to:

  • Students will demonstrate advanced document, worksheet, database and presentation skills using the appropriate design and application tools.
  • Students will demonstrate understanding of software applications by resolving errors in documents, worksheets and databases

V. Topical Outline (Course Content)

Create, apply and modify Styles in a Word Document Change the Style Set and Apply a Template Copy Styles between documents Use Advanced Table Features Create Custom Building Blocks Create and Save a Theme Template Create a Document Using Building Blocks Locate Supporting Information and Insert Equations Used Advanced Find and Replace Options Edit and Sort a Data Source Create a Customized Form Modify and Lock a Form Add a Digital Signature to a File Create a Master Document and Subdocuments Create an Index Create a Table of Contents Create a Table of Figures Control the Flow and Formatting of Pages and Text Embed Objects in a Word Document Link Objects to a Word Document Create Macros Integrate Excel Worksheets with Word Documents Use formula auditing tools to troubleshoot Excel worksheets Create advanced charts Edit Queries Modify forms Use functions to return information in an Access query Import and export data from one application to another Embed and link information Create PivotTables and Charts Troubleshoot charts to make the more effective

VI. Delivery Methodologies