Home

CIS 100 Lab Home

Overview

Lab Slides

Multimedia

Tutorial

Workshop

References

Project Details

Project Groups

Examination

Summary

 

 

Overview


Course Description

This is an introductory course on the use of the Office suite of software for both professional and personal applications. The purpose of the course is to provide the required computer literacy in Office applications that would enable the students to function effectively in today's digital world. The focus is on the personal computer and its use for personal and professional productivity. Emphasis will be placed on hands-on learning of the software applications. 

The applications intended for coverage are Word, Excel, Access and PowerPoint. In addition to covering the frequently used features of these applications, a few advanced features of the applications are also slated for coverage. The following gives a brief outline of the course.

Course Outline

Section 1: Introduction
Chapter 1: Introduction to Microsoft Vista

Section 2: Word
  
Chapter 1: Creating and Editing a Word Document
Chapter 2: Creating a Research Paper

Chapter 3: Creating Cover Letter and a Resume
Chapter x: Creating a Web Page Using Word

Section 3: Excel

Chapter 1: Creating a Worksheet and an Embedded Chart
Chapter 2: Formulas, Functions, Formatting and Web Queries
Chapter 3: What-if Analysis, Charting and Windows with Large Worksheets
Chapter X: Creating Web Pages Using Excel
 
Section 4: Access

Chapter 1: Creating and Using a Database
Chapter 2: Querying a Database
Chapter 3: Maintaining a Database 
Chapter X:  Sharing Data Among Applications

Section 5: PowerPoint

Chapter 1: Creating and Editing a Presentation
Chapter 2: Creating a Presentation with Illustrations and Shapes
Chapter x: Creating Web Pages Using PowerPoint

Outcome

At the end of the quarter, the students completing this course is expected to have acquired the knowledge and skills in the following.

  • basic operations of the Windows operating system

  • creating and editing a word document 

  • writing a research paper based on the MLA documentation style with citations, footnote, bibliographical list etc. using the features provided in Word

  • writing a cover letter, resume and an addressed envelope using Word

  • creating a worksheet with charts and performing calculations on data using Excel

  • using formulas and functions to calculate average, maximum etc. and performing similar calculations using Excel

  • performing what-if analysis, creating 3-D charts and formatting a worksheet using Excel

  • developing and using a database by creating tables, storing data in tables and querying the table using Access

  • Querying, retrieving and displaying data based on a variety of retrieval criteria using  Access

  • Maintaining a database by storing and updating the data using forms and by employing validation rules in Access

  • Creating, editing and presenting a PowerPoint slide show

  • Including illustrations and shapes in a PowerPoint presentations

  • Incorporating various video and audio effects in the presentation

Text Book

Gary B. Shelly, Thomas J. Cashman, Misty E. Vermaat, Microsoft Office 2003: Introductory Concepts and Techniques, Second Edition, Course Technology, 2005.

Delivery of Instruction

This evolving website will play an important role in disseminating course related information. In-class meetings may be reduced by a certain length of time to enable the students to take full advantage of Technology Mediated Learning (TML) facilitated by this website and the future release of multimedia instructional modules.

References

There are no suggested references excepts for those provided during the course of the lab exercises.


(c) Professor N. Ganesan, All Rights Reserved.