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.
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]
Semester Contact Hours Lecture
15
Semester Contact Hours Lab
45
Grading Method
Letter grade
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