Course Outline

Master Document

mohawk400BW5in      

              

 

1.0 IDENTIFICATION

COURSE INFORMATION

            Course Name

Computer Basics with Vista, Word, and Excel

            Course Code

INFO10113

            Course Classification

Specialized

            Course Type

Optional

            Program Code and Name

Business Computer Applications Certificate

            Total Course Hours

36

            Credit Value/Grade Type

3

            Development School

Continuing Education

            Department

Business Computers

            Developed by

Peggy Daniel

            Development Date

Spring 2008

            Academic Year

Fall 2008-Spring 2009

            Approving Associate Dean

Pat MacDonald

            Approval Date

Fall 2008

2.0 LEARNING OVERVIEW

SUBSECTION

 

Course Description

Learn Word 2007 features required in creating, editing, formatting, printing, and saving letters, memos, reports, and tables.   Recommended prerequisite:  INFO10053

 

Status of Resources

REQ= Required

REC= Recommended

REF= Reference

 

Type of Resources

Text Book OR Supply

 

Code

or

ISBN

Name or Title

Author/Publisher/Vendor or Website

Version/ Edition

 

Type

 

Status

978-1-55332-233-7

 

Computer Basics with Windows Vista and Microsoft Office 2007

CCI Learning Solutions

 

Text Book

REQ

Pre-requisite(s)

Course Code

Course Name

Details

INFOBW001

Workshop for Windows

 

 

OR  Working knowledge of Windows

 

Prior Learning Assessment and Recognition

CH

Challenge

3.0 COURSE CONTENT

Major Modules, Themes, or Topics

Unit 1A

Using Windows Vista - 10 hours

Unit 1B

MoCoMotion – 3 hours

Unit 2

Common Elements – 1 hour

Unit 3

Using Microsoft Word – 9 hours

Unit 4

Using Microsoft Excel – 10 hours

Exam

Practical and Theory exams – 3 hours

5.0 COURSE LEARNING OUTCOMES

Upon successful completion of the course learning outcomes, the student will reliably demonstrate the ability to:

LO01A

Upon successful completion of this unit, the student will demonstrate an ability to move around effectively and efficiently in the Windows environment and demonstrate good file management techniques.

Learning Elements

            Lesson 1: Introducing Windows Vista

            Upon successful completion of this lesson, the student will understand

·         What is Windows Vista

·         Recognizing Windows and Dialog Boxes

·         What’s New in Windows Vista?

·         Understanding Networks

·         Logging On

·         Using the Welcome Center

·         Looking at the Desktop

·         Navigating using the Mouse and Keyboard

·         Using the Start Button

·         Looking at a Typical Window

·         Working with Program Windows

·         Working with Scroll Bars

·         Working with Help

            Lesson 2: Customizing Windows Vista

            Upon successful completion of this lesson, the student will understand

·         Customizing the Start Menu

·         Starting Programs Automatically

·         Working with the Taskbar

·         Using the Windows Sidebar

·         Working with Desktop Icons

·         Modifying the Aero Interface

            Lesson 3: Using the Control Panel

            Upon successful completion of this lesson, the student will understand

·         About Control Panel

·         Changing the Screen Appearance

·         Working with Mouse Settings

·         Working with Sound Settings

·         Working with Themes

·         Understanding the Power Plans

·         Working with Multiple Monitors

·         Managing User Accounts

            Lesson 4: Working with Windows Explorer and Folders          

            Upon successful completion of this lesson, the student will understand

·         About Folders and Files

·         File Paths

·         Understanding Windows Explorer

·         Navigating Windows Explorer

·         Applying Windows Explorer Layouts

·         Working with Folder Views

·         Organizing Folder Contents

·         Working with Folder Options

·         Creating and Modifying Folders


            Lesson 5: Working with Files

            Upon successful completion of this lesson, the student will understand

·         About Vista Programs

·         Working with WordPad

·         Renaming, Moving and Copying Files

·         Deleting Files

·         Working with File Properties

            Lesson 6: Powerful Searching

            Upon successful completion of this lesson, the student will understand

·         About Searching

·         Searching within Windows Vista

·         Searching using the Start Menu

·         Customizing Start Menu Searches

·         Searching Folders and Views

·         Using Advanced Search Tools

·         Saving Searches

·         Working with the Search Index

LO01B

This unit is designed to introduce new users to Mohawk’s web Portal, MoCoMotion, and to some of the Course Tools features available. Upon successful completion of this unit, students should be able to:

Learning Elements

            Understand what MoCoMotion is

            Log in and out of MoCoMotion

            Navigate around in MoCoMotion

            Access their course

            Download files form the course page

            Send an email message to the instructor with an attachment

            Submit files to the course page

            Access their email

 

LO02

Upon successful completion of this unit, the student will demonstrate an understanding of the Windows setup of Word and Excel.  Upon successful completion of this unit, students should be able to:

Learning Elements

            Recognize an Office 2007 screen

            Use the Office Button

            Use the Quick Access Toolbar

            Use the Ribbons

            Use the Mini Toolbar

            Use Quick Styles

            Get Help

            Customize Options

            Set Spelling and Grammar Options

            Locate the View Options

            Use the Keyboard

            Work with Files

                        Trouble shoot options

 

LO03

Upon successful completion of this unit, the student will be able to create a simple document in Word, edit it, format it, save it, and print it out.

Learning Elements

            Lesson 14: Creating Documents

            Upon successful completion of this lesson, the student will understand

·         The Word Screen

·         Working with Text

·         Working with Documents

            Lesson 15: Manipulating Text

            Upon successful completion of this lesson, the student will understand

·         Selecting Text

·         Editing Text

            Lesson 16: Formatting Content

            Upon successful completion of this lesson, the student will understand

·         Formatting Characters

·         Formatting Paragraphs

·         Organizing List Information

·         Using Spacing


            Lesson 17: Formatting Documents

            Upon successful completion of this lesson, the student will understand

·         Setting Up the Document

·         Using Headers and Footers

            Lesson 18: Getting Ready to Print

            Upon successful completion of this lesson, the student will understand

·         Preparing to Print

 

 

LO04

Upon successful completion of this unit, the student will be able to create a simple worksheet in Excel, edit it, format it, save it, generate a chart based on the data, and print out both the chart and the data.

Learning Elements

            Lesson 19: Getting Started

            Upon successful completion of this lesson, the student will understand

·         What is an Electronic Spreadsheet?

·         Looking at the Excel Screen

·         Understanding the Ribbon User Interface

·         Creating a New Blank Workbook

·         Entering Data in a Worksheet

·         Selecting Cells

            Lesson 20: Manipulating Items

            Upon successful completion of this lesson, the student will understand

·         Copying and Moving Data

·         Adjusting the Columns and Rows

·         Inserting and Deleting Rows and Columns

·         Managing Worksheets

            Lesson 21: Using Formulas

            Upon successful completion of this lesson, the student will understand

·         Creating and Editing Simple Formulas

·         Using Common Functions with Cell Ranges

·         Using Absolute and Relative Cell References

·         Displaying and Printing Formulas

            Lesson 22: Formatting the Worksheet

            Upon successful completion of this lesson, the student will understand

·         Formatting a Cell

·         Clearing Cell Contents and Formatting

·         Formatting Worksheets

            Lesson 23: Preparing to Print

            Upon successful completion of this lesson, the student will understand

·         Previewing Worksheets

·         Customizing the Printout

·         Adjusting the Margins

·         Printing the Worksheet

            Lesson 24: Working with Charts

            Upon successful completion of this lesson, the student will understand

·         Creating a Basic Chart

·         Changing Chart Types

·         Working with Pie Charts

·         Changing the Chart Layout

·         Moving and Resizing Charts

·         Printing Charts

 

LO05

Students will complete theory and practical exam

 

 

6.0 ASSESSMENT (ASSESSMENT DETAILS TO BE PROVIDED BY FACULTY)

Assessment Method

Weight

 

            Assignment 1  

15%

Windows assignment

            Assignment 2

15%

Word assignment

            Assignment 3

20%

Excel Assignment

            Test (last class)

50%

 

 

 

 

TOTAL

100%

 

 

7.0 STUDENT SUCCESS – POLICIES AND PROCEDURES

 

 

Mohawk College has developed several policies and procedures designed to protect students and provide an enriching and rewarding learning experience in which the rights of individuals are respected.

 

Please be advised that these policies and procedures are subject to change.  For the most up to date information on the following policies and procedures, consult

http://www.mohawkcollege.ca/dept/stactiv/affairs/vp/codes.html#2