KEYBOARDING

           

 

Course Length:  Trimester

Credits:  0.5

Grade Level(s):  9-12

Prerequisite:  None

Text:  Century 21 Computer Applications & Keyboarding,  7th Edition, South-Western Publishing.

LCC College Now Credit:  3 credits for CIS 101, Computer Fundamentals

 

Course Description:  This class introduces and reinforces touch typing, speed and accuracy development, and other general computer operations.  Students will be exposed to word processing, spreadsheets, and presentation software using Microsoft Office.

 

 

Outcome

Introduced

Applied

Tested

Develop Touch Typing Skills

 

 

 

 Alphabetic/numeric/symbols/punctuation

x

x

x

Demonstrate Basic Computer Operations and Knowledge

 

 

 

      Basic Windows operating system use

x

x

 

      General computer terminology

x

x

x

      Use of technology in society

x

x

 

      Ethical computer operations

x

x

 

Apply Basic Word Processing Skills Using Microsoft Word

 

 

 

Format text

x

x

x

Create a new document

x

x

x

Save a document

x

x

x

Edit

x

x

x

Spell Check

x

x

x

Print

x

x

x

Retrieve/Open

x

x

x

Text formatting

x

x

x

Date text/code

x

x

x

Page breaks

x

x

x

Page numbering

x

x

x

Table

x

x

x

Ruler/tabs/indents

x

x

x

Prepare Common Documents Using Microsoft Word

 

 

 

Letters—personal-business

x

x

x

Memorandums

x

x

x

E-mail formatting

x

x

x

Unbound reports

x

x

x

Simple tables

x

x

x

Proofreader marks

x

x

x

Create Simple Spreadsheets Using Microsoft Excel

 

 

 

Identify Excel window features

x

x

x

Cells/columns

x

x

x

Labels/values

x

x

x

Formatting cell contents

x

x

x

Moving and copying data

x

x

x

Entering and editing formulas

·         Mathematical operators

·         Autosum

·         Paste function

·         Count/Max/Min/Average functions

·         Cell references:  Absolute, relative, mixed

x

x

x

Charts

·         Pie/bar/column/line

x

x

x

Create Electronic Presentations Using Microsoft PowerPoint

 

 

 

Identify PowerPoint window features

x

x

x

Create a new presentation

x

x

x

Use the AutoContent wizard

x

x

x

Apply Autolayouts

x

x

x

Understand Views:  slide/outline/slide sorter/slide show

x

x

x

Apply slide designs

x

x

x

Create slide transitions

x

x

x

Animate objects

x

x

x

Insert Clipart

x

x

x

Use Internet for presentation content

x

x

x

Measure Keyboarding Speed and Accuracy

 

 

 

Three-minute timings

x

x

x

 

Evaluation:

            35%    Keyboarding Technique    

            25%    Assignments and Quizzes

            20%    Employability            (attendance, work habits, participation, etc.)                  

            10%    Final Exam                          

            10%    Timings (average of best five 3-minute timings)                                   

                        A = 35+wpm  B = 30-34 wpm  C = 25-29 wpm  D = 20-24 wpm