Course of Study

SYLLABUS

Course Title: Keyboarding/Computer Applications

Department: Business

Teacher:  Mr. Ross  and Ms. Hogue

Office Hours:  7:30am-8:00am  3:00pm-3:30 M-F

I. Basic Facts:

1. Course Title: Keyboarding/ Computer Applications

2. Grade Level: 9-12

3. Type of course: Elective

4. Prerequisite: None

5. Length of course: One Year

II Course Description:

This course is designed to introduce keyboarding skills on the computer and then computer applications using Microsoft Office. The content of the course will include proper keyboarding fundamentals, word processing, spreadsheet, database, and slideshow presentation.

III Instructional Materials:

Basic Textbooks:

Velsoft Computer Training Courseware

Software:

Typing Master

Microsoft Office 2003

IV Goals: To possess adequate touch keyboarding skills for efficient computer use. To provide the basic operations of a computer through the use of word processing, spreadsheets, and databases.

V Course Outline:

Keyboarding

LESSON 1     Home Rove E and I

LESSON 2    R and V

LESSON 3     G and H

LESSON 4     C and Capitals

LESSON 5     M and V

LESSON 6     Y and T

LESSON 7     N and B

LESSON 8     O and W

LESSON 9     P, Q and Z

LESSON 10     X and Dot

LESSON 11     Text and Revision

LESSON 12     Numbers and Specials

LESSON 13     Review

Word Processing (Word)

Chapter One: The Fundamentals
Chapter Two: Working with and Editing Text
Chapter Three: Formatting Characters and Paragraphs
Chapter Four: Formatting Pages
Chapter Five: Working with Tables

 

SPREADSHEETS (Excel)

Chapter One: The Fundamentals
Chapter Two: Editing a Worksheet
Chapter Three: Formatting a Worksheet
Chapter Four: Creating and Working with Charts
Chapter Five: Managing Your Workbooks

 

DATABASE (Access)

Chapter One: The Fundamentals
Chapter Two: Creating and Working with a Database
Chapter Three: Finding, Filtering, and Formatting Data
Chapter Four: Working with Tables and Fields
 

Presentation (PowerPoint)

Chapter One: The Fundamentals
Chapter Two: Editing a Presentation
Chapter Three: Formatting Your Presentation

Chapter Four: Drawing and Working with Graphics

 Time Permitting - Publisher

 VI Course Objectives:

The objectives of this course are for students to learn proper keyboarding fundamentals, to become familiar with word processing, spreadsheet, database, and presentation software that will be useful to them their entire life.

VII Evaluation:

Students turn in assignments weekly. These assignments are evaluated and returned in a timely manner with a computerized grade print out. Late work will only be accepted two weeks after due date and graded at a lesser value.

90-100 = A
80-89 =   B
70-79 =   C
69- 60 =  D
Below =  F