Microcomputer Applications II

Curriculum guideline

Effective Date:
Course
Discontinued
No
Course code
OADM 1356
Descriptive
Microcomputer Applications II
Department
Office Administration
Faculty
Commerce & Business Administration
Credits
3.00
Start date
End term
201430
PLAR
Yes
Semester length
15 Weeks x 4 Hrs. per week = 60 Hrs.
Max class size
30
Contact hours
Lecture: 3 Hrs. Seminar: 1 Hr. Total: 4 Hrs.
Method(s) of instruction
Lecture
Seminar
Learning activities

A combination of lecture, demonstration, guided practice, web-based training, and self-paced lab assignments and projects will 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 microcomputer application skills and techniques.

Course description
This course is a “hands-on” microcomputer course. The students will build on their working knowledge of microcomputers while developing new skills in using desktop information management, presentation software, databases, PDF editors and web page 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 - PDF Editor [3]

1.1        Create a PDF document from various sources.
1.2        Arrange, extract and delete PDF document pages.
1.3        Edit and format PDF document text.
1.4        Add, modify, arrange and format bookmarks.
1.5        Create, resize and align links.
1.6        Add notes, text mark-ups and drawing mark-ups.
1.7        View, organize and summarize comments.

Module 2 - Database [3]

2.1        Create a form with a sub form.
2.2        Create and use a lookup field.
2.3        Add controls to forms and reports.
2.4        Create, modify, save, copy and run macros.
2.5        Create, modify and use switchboards.

Module 3 - Outlook [1]

3.1      Entering, editing, and moving appointments and events.
3.2      Displaying and printing calendars in assorted views.
3.3      Creating, organizing, and printing contact lists.
3.4      Exporting, importing, and deleting folders.

Module 4 - Web Page Editor [4]

4.1      Create, save, preview, print, close, open, and edit a FrontPage document
4.2      Create web pages with the aid of wizards and templates.
4.3      Insert, complete and format a FrontPage table.
4.4      Create and edit text and graphic hyperlinks.
4.5      Insert, position and resize images.
4.6      Create and insert drawing objects.
4.7      Utilize various web components.
4.8      Modify the properties and contents of frames.
4.9      Develop and manage interactive forms.

Module 5 – Presentation Software [2]

5.1      Create and edit the text of a presentation.
5.2      Add animation and transition effects to a presentation.
5.3      Insert a table and chart into a presentation.
5.4      Modify slide layouts.
5.5      Add and custom animate graphic elements.

Learning outcomes

The learner has reliably demonstrated the ability to:

 

  1. Use the Windows interface to perform basic software functions and to organize and manage directories and files effectively;
  2. Use the microcomputer as a decision making and problem solving tool;
  3. 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;
  4. Use database software to create and maintain a relational customer database, and routinely retrieve information by performing queries and generating reports;
  5. Use a desktop information management program to organize a schedule and keep a record of contacts;
  6. Use web page editors to design and develop a comprehensive web site;
  7. Use presentation software to produce slideshows that include animation of text and graphics;
  8. Produce business documents requiring the integration of all applications found in a typical office suite.
Means of assessment
PDF Test   20%
 Access Test   20%
 Outlook/PowerPoint Test    20%
 FrontPage Test   20%
 Assignments/Projects   20%
Total  100%
Textbook materials

Textbooks and Materials to be Purchased by Students

 

Grauer, Robert T. and Maryann Barber.  Microsoft Office, Volume I, Latest Ed., New Jersey: Pearson Education. [used in OADM 1256]

Grauer, Robert T. and Maryann Barber.  Microsoft Office: Access, Volume II, Latest Ed., New Jersey: Pearson Education.

Marghitu, Daniela. Microsoft Office: FrontPage, Latest Ed., New Jersey: Pearson Education.

Springer, Michael. Course ILT: Acrobat. Latest Ed., Massachusets: Thomson Learning.

Prerequisites
Which prerequisite