CISA 101 Office Application Overview
This course will explore the features and functions of commonly used computer applications including by not limited to work processors, spreadsheets, presentation software and databases.
CISA 101Office Application Overview
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
Credit Hours Narrative
3 Credits
Semester Contact Hours Lecture
Dependent on modality of instruction
Semester Contact Hours Lab
Dependent on modality of instruction
Semester Contact Hours Clinical
Dependent on modality of instruction
Grading Method
Letter grade
III. Catalog Course Description
This course will explore the features and functions of commonly used computer applications including by not limited to work processors, spreadsheets, presentation software and databases.
IV. Student Learning Outcomes
Upon completion of this course, a student will be able to:
- Students will demonstrate the proper use of application software in performing the objectives listed below
- Students will manipulate software to design solutions for academic, professional, and everyday tasks and problems.
V. Topical Outline (Course Content)
Sign in and out of Windows, identify the features of an operating system, create a folder and save a file.
Manage files and folders, copy and move files and folders, and use the Recycle Bin.
Create, save, and print a Microsoft Office 2013 document.
Use the ribbon and dialog boxes to perform commands in Microsoft Office 2013.
Create a flyer with a picture.
Format text, paragraphs, and documents.
Format a resume by using a Word table.
Write a cover letter and use a template to create a cover sheet.
Create a research paper that includes citations and a bibliography.
Create a multiple-column newsletter and merged mailing labels.
Create a sales report with an embedded column chart and sparklines.
Calculate the value of an inventory.
Analyze inventory by applying statistical and logical calculations to data and by sorting and filtering data.
Summarize the data on multiple worksheets.
Present fund data in a pie chart.
Make projections by using what-if analysis and present projections in a line chart.
Create a new database.
Create a database from a template.
Sort and query a database.
Create complex queries.
Create forms to enter and delete records and to display data in a database.
Create reports to display database information.
Create a company overview presentation.
Create a new product announcement presentation.
Format a presentation to add visual interest and clarity.
Enhance a presentation with WordArt and SmartArt.
Customize a presentation with animation and video.
Create a presentation that includes data in tables and charts.
VI. Delivery Methodologies
Required Assignments
End of application MyIT lab capstone grader project
Specific Course Activity Assignment or Assessment Requirements
End of application MyIT lab capstone grader project