Introduction to Computer Applications

Course Number: 
NACT-120
Credits: 
3

This course is an introduction to using general-purpose software tools. The tools to be covered include word processing, spreadsheet, database, and presentation software as well as an email client. Students will do hands-on work in each application

Goals: 
  • To master the basic features of an integrated software package or suite that includes email, word processing, spreadsheet, database and presentation software. 
  • To learn how to select the right application for a task.
  • To learn how to combine the features of several applications in order to perform a task.
  • To develop the computer terminology and technical reading and writing skills to effectively use office applications.
Topics: 
  1. Windows Operating System
    1. Exploring the Basics
    2. Working with Files
  2. Microsoft Word
    1. Creating a Document
    2. Editing and Formatting a Document
    3. Creating a Multiple-Page Report
    4. Desktop Publishing a Newsletter
  3. Microsoft Excel
    1. Using Excel to Manage Financial Data
    2. Working with Formulas and Functions
    3. Developing a Professional-Looking Worksheet
    4. Working with Charts and Graphics
  4. Microsoft Access
    1. Introduction to Microsoft Access
    2. Creating and Maintaing a Database
    3. Querying a Database
    4. Creating Forms and Reports
  5. Microsoft PowerPoint
    1. Creating a PowerPoint Presentation
    2. Appling and Modifying Text and Graphic Objects
  6. Integrating Word, Excel, Access and PowerPoint
Learning Outcomes: 

Outcome:

At the completion of this course, students will be able to:

Assessment Method

  1. Use a word processor to develop documents using specified text formatting, column formatting, graphics, header/footers and data fields such as current dates and page numbers.

Assignment and exams

  1. Use spreadsheet software to format text, automate calculations using functions and formulas, create charts based on selected data, and use advanced features such as themes and conditional formatting.

Assignments and exams

  1. Create and maintain simple databases including creating tables and generating simple queries, forms and reports.

Assignments and exams

  1. Design multimedia presentation material using sample slide layouts and color themes. Print the presentation material as slides, notes or handouts.

Assignments and exams

  1. Utilize features in the email system beyond the simple read, send and delete capabilities such as searching, filtering, and assigning email to folders and using the calendar functions.

Assignments and exams

  1. Identify the type of documentation needed and the appropriate software to accomplish a task.

Assignments and exams

  1. Use features from different applications within a productivity suite to create an integrated document such as a presentation utilizing data from a database, a chart from a spreadsheet software, and text from a word processing application.

Assignments and exams

  1. Identify and describe in writing the computer terminology used in common productivity suites.

Assignments and exams

  1. Use provided or student-selected texts and online multimedia to read and further develop skills to enhance documentation.

Assignments and exams

  1. Write well-formed documentation and utilize available proofreading features.

Assignments and exams

 

Textbooks: 

Microsoft® Office 2010: Illustrated Fundamentals, 1st Edition
Marjorie Hunt
Barbara M. Waxer
ISBN-10: 053874944X  ISBN-13: 9780538749442 

Optional:
SAM 2010 Assessment and Training v2.0
(packaged with the textbook).