Microcomputer Applications II
Curriculum guideline
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.
Module 1 – PDF Editor [4]
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 [4]
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 – Web Page Editor [3]
3.1 Create, save, preview, print, close, open, and edit a web page document
3.2 Create web pages with the aid of wizards and templates.
3.3 Insert and complete cascading style sheets to format web pages.
3.4 Create and edit text and graphic hyperlinks.
3.5 Insert, position and resize images.
3.6 Create and insert drawing objects.
3.7 Create a web site utilizing a template.
Module 4 – Presentation Software [3]
4.1 Create and edit the text of a presentation.
4.2 Add animation and transition effects to a presentation.
4.3 Insert a table and chart into a presentation.
4.4 Modify slide layouts.
4.5 Add and custom-animate graphic elements.
The learner has reliably demonstrated the ability to:
- Use the Windows interface to perform basic software functions and to organize and manage directories and files effectively;
- Use the microcomputer as a decision making and problem solving tool;
- 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;
- Use database software to create and maintain a relational customer database, and routinely retrieve information by performing queries and generating reports;
- Use web page editors to design and develop a comprehensive web site;
- Use presentation software to produce slideshows that include animation of text and graphics;
- Produce business documents requiring the integration of all applications found in a typical office suite.
| Assignments/Projects | 20% |
| Web Page Editor/Presentation Software Test | 30% |
| Database Test | 25% |
| PDF Editor Test | 25% |
| Total | 100% |
Textbooks and materials to be purchased by students
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.
Hoisington, Corinne L., and Jessica L. Minnick. Shelly Cashman Series: Adobe Dreamweaver, 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.