Computer Applications II

Curriculum Guideline

Effective Date:
Return to Course
Print Guideline
Course
OADM 1346
Discontinued
No
Course Code
OADM 1346
Descriptive
Computer Applications II
Department
Office Administration
Faculty
Commerce & Business Administration
Credits
3.00
Start Date
End Term
202030
PLAR
Yes
Semester Length
4 x 15 = 60 hrs.
Max Class Size
30
Contact Hours
Lecture 3, Lab 1
Method(s) Of Instruction
Lecture
Lab
Learning Activities

A combination of lecture, demonstration, guided practice, web-based training, and self-paced lab assignments and simulation projects may be used. Active learning is an integral part of this course, and major emphasis will be placed on a "hands-on" environment to allow students to work both independently and collaboratively to learn and apply computer application skills and techniques.

Course Description
This course is a "hands-on" computer course. The students will build on their working knowledge of computers while developing new skills in using spreadsheets, presentation software, databases, and PDF editors. Students will apply the knowledge and use of these tools to solve problems encountered in an office environment. Students will be expected to integrate their learning and to incorporate the use of these tools in the production of professional documents that adhere to workplace standards.
Course Content

Module 1 - Presentation Software [2]

  1. Create and edit the text of a presentation.
  2. Add animation and transition effects to a presentation.
  3. Add and format clip art, pictures, shapes, smartart, video and audio in presentations.
  4. Insert and format a table and chart in presentations.

Module 2 - Databases [5]

  1. Create a relational database with multiple tables.
  2. Modify and update tables while establishing validation rules.
  3. Establish and use input masks.
  4. Perform a variety of queries and generate related forms and reports.
  5. Create, modify, print and save forms.
  6. Create, modify, print and save reports.
  7. Create a form with a sub-form.
  8. Create and use a lookup field.
  9. Create and use a calculated field.
  10. Add controls to both forms and reports.

Module 3 - Spreadsheets [4]

  1.  Solve problems involving the PMT, FV, AND, OR, VLOOKUP, HLOOKUP, IFERROR, COUNTIF, SUMIF, and AVERAGEIF functions.
  2. Work with large spreadsheets--freeze panes, hide rows/columns.
  3. Use relative, absolute, and mixed references.
  4. Create, format and filter a spreadsheet table.
  5. Create, filter and sort a PivotTable and related PivotChart.
  6. Link cells in multiple worksheets.
  7. Link multiple workbooks.
  8. Use conditional formatting.
  9. Use defined names in formulas.
  10. Protect contents of worksheets and workbooks and create an application utilizing a macro.

Module 4 - PDF Editors [3]

  1. Create a PDF document from various sources.
  2. Arrange, insert and delete PDF document pages.
  3. Edit and format PDF document text and images.
  4. Add, modify, arrange and format bookmarks.
  5. Create, resize and align links.
  6. Add notes, text and drawing markups.
  7. View, organize and summarize comments.
  8. Create, format and modify fillable forms.
  9. Create, format and modify multimedia presentations.

 

Learning Outcomes

The learning has reliably demonstrated the ability to:

  1. Use the operating system interface to perform basic software functions and to organize and manage directories and files effectively;
  2. Use database software to create and maintain tables in a relational database, and routinely retrieve information by performing queries to generate a variety of forms and reports;
  3. Use presentation software to produce slideshows that include clip art, pictures, shapes, smartart, tables, charts, video, and audio, and animates both text and graphics;
  4. Use spreadsheet software to solve a variety of business problems requiring mathematical solutions;
  5. Use a PDF editor to produce a variety of business documents meeting industry standards for timely completion, correctness of content and format, and professional appearance;
  6. Use the computer as a decision-making and problem-solving tool; and
  7. Produce business documents requiring the integration of all applications found in a typical office suite.
Means of Assessment
PowerPoint Test         10-15%
Access Test   25-30%
Excel Test   15-25%
PDF Test   15-20%
Assignments       5-10%
Project(s)   5-15%
Total   100%
Textbook Materials

Zimmerman, Beverly B., Zimmerman, S. Scott, and Katherine T. Pinard. New Perspectives on Microsoft PowerPoint, Introductory, Latest Ed., Nelson Education: Course Technology Cengage Learning.

Adamski, Joseph J. and Kathleen T. Finnegan. New Perspectives on Microsoft Access, Introductory, Latest Ed., Nelson Education: Course Technology Cengage Learning.

Parsons, June Jamrich, Oja, Dan, Ageloff, Roy and Patrick Carey. New Perspectives on Microsoft Excel, Introductory, Latest Ed., Nelson Education: Course Technology Cengage Learning.

Adobe Acrobat: Classroom in a Book. Latest Ed., Adobe Press.

Skills Assessment Manager (SAM), Latest Ed., Nelson Education: Course Technology Cengage Learning.

Or other textbooks and online assessment tools as approved by the department.

Prerequisites

OADM 1246 or OADM 1256