Computers and Management Information Systems (CMIS) 245

Overview

This course will help you develop the skills required to use microcomputer applications effectively in a business environment. Using a hands-on approach of "learning by doing," you will learn to use the Microsoft Office 2010 suite of products and develop skills in using software designed to meet today's business needs.

After completing this course, you will have achieved the following course objectives:

• You will be familiar with concepts and terminology common to desktop applications used in business.
• You will be knowledgeable about and proficient in using Microsoft Word, Excel, Access, and PowerPoint software.
• You will have practical knowledge of common business situations in which desktop applications are used, and have a foundation for further independent learning.

The textbook is a comprehensive MS Office tutorial and reference, and it goes somewhat beyond the learning expectations of an introductory course; therefore, not all the chapters in the textbook are covered in the lessons. After you have gained some experience and proficiency in using the software through the lessons in this course, however, you will be able to continue learning and developing new skills independently.

Outline

This course has been organized into 12 lessons, as follows:

Lesson 1: Office Fundamentals

Lesson 2: Microsoft Word Basics

Lesson 3: Editing and Formatting in Word

Lesson 4: Tables and Merge Printing in Word

Lesson 5: Microsoft Excel Basics

Lesson 6: Excel Formulas and Functions

Lesson 7: Excel Charts

Lesson 8: Introduction to Microsoft Access

Lesson 9: Relational Databases and Multi-Table Queries

Lesson 10: Advanced Query Techniques

Lesson 11: Microsoft PowerPoint Basics

Lesson 12: Presentation Development

Evaluation

To receive credit for this course, you must complete four assignments and achieve a minimum grade of “D” (50 percent) on each assignment.

There are no examinations in this course.

The table below summarizes the evaluation activities in this course:

To learn more about assignments and examinations, please refer to Athabasca University's online Calendar.

Course Materials

Textbook

Other Materials

All other materials are available online.

Software Requirements

You must have a PC version of Microsoft Office 2010 that includes the four main applications: Word, Excel, Access, and PowerPoint (note that not all versions of Office 2010 include Access). Due to the widening discrepancy between the Mac and PC versions of Office and the number of issues this creates for students and tutors, students will not be allowed to register in CMIS 245 with the intention of completing the course using a Mac computer.

Challenge for Credit Course Overview

The Challenge for Credit process allows students to demonstrate that they have acquired a command of the general subject matter, knowledge, intellectual and/or other skills that would normally be found in a university level course.

Full information for the Challenge for Credit can be found in the Undergraduate Calendar.

• Undergraduate Challenge for Credit Policy
• Undergraduate Challenge for Credit Procedures

Challenge Evaluation

To receive credit for the CMIS 245 challenge registration, you must complete four assignments and achieve a minimum grade of  “D” (50 percent) on each assignment.

The assignments are based on activities from the course textbook, therefore you must acquire a copy of the textbook in order to complete the challenge requirements. You must also meet the software requirements shown above. The cost of the textbook is approximately $147 plus shipping costs. To confirm the cost or order the textbook, email cmat@athabascau.ca or phone 1-800-788-9041 Ext 6366.

Undergraduate Challenge for Credit Course Registration Form

• Challenge for Credit Form