Course Outline

Master Document

mohawk400BW5in      

              

 

1.0 IDENTIFICATION

COURSE INFORMATION

            Course Name

Computer Basics with Windows, Word, and Excel

            Course Code

INFO10053

            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-234-4

 

Computer Basics with Windows XP 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 XP - 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: Looking at Windows

            Upon successful completion of this lesson, the student will understand

  • the purpose and role of a computer’s operating system.
  • why different versions of Windows exist.

            Lesson 2: Looking at the Desktop

            Upon successful completion of this lesson, the student will be able to

  • identify the various parts of the computer desktop
  • efficiently use a computer mouse
  • navigate around various windows
  • access data/programs via the Start menu
  • access data/programs via the Taskbar
  • manipulate the taskbar

            Lesson 3: Working with Windows

            Upon successful completion of this lesson, the student will be able to

  • distinguish between a window and a dialog box
  • move and resize a window
  • use scroll bars to find information within a window

            Lesson 4: Exiting Windows

            Upon successful completion of this lesson, the student will be able to

  • exit Windows properly
  • exit Windows from a networked and non-networked environment
  • use various accepted methods for restarting a computer

            Lesson 5: Getting Help

            Upon successful completion of this lesson, the student will be able to

  • use the Windows Help and Support feature to find information
  • use the Favorites, Index, and History features of the Help program
  • get help in a dialog box
  • get additional technical support Using Windows Help and Support

            Lesson 6: Running Application Programs

            Upon successful completion of this lesson, the student will be able to:

  • start application programs
  • use the Run command to start application programs
  • open and close a typical program
  • create, save, and open files

·         use the My Recent Documents feature

  • multitask different windows and programs

            Lesson 7: Looking at Files and Folders

            Upon successful completion of this lesson, the student will be able to

  • understand the difference between files and folders
  • understand the purpose of a desktop shortcut
  • use the My Computer Feature
  • change the view in the My Computer feature
  • create folders

            Lesson 8: Using Windows Explorer

            Upon successful completion of this lesson, the student will be able to

  • understand when to use Windows Explorer
  • use various methods to select files and folders
  • copy and move files and folders
  • rename files and folders
  • view file and folder properties
  • find files using the Search feature

            Lesson 9: Using the Recycle Bin

            Upon successful completion of this lesson, the student will be able to

  • understand what files and folders go to the Recycle Bin
  • find files and folders in the Recycle Bin
  • delete files and folders to the Recycle Bin
  • restore files and folders from the Recycle Bin
  • empty the Recycle Bin
  • identify common problems with files

            Lesson 10: Managing Disks

            Upon successful completion of this lesson, the student will be able to

  • check for errors on a disk
  • defragment a disk
  • clean up a disk

            Lesson 11: Customizing System Settings

            Upon successful completion of this lesson, the student will be able to

  • customize the Desktop Display
  • change the Date and Time
  • customize the Mouse
  • customize the Keyboard
  • change the volume
  • use fonts
  • print files

            Lesson 12: Installing and Uninstalling Programs

            Upon successful completion of this lesson, the student will be able to

  • install a new program
  • uninstall a program

 

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