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.