Course Description
Computer Concepts II is an advanced level class that builds on the skills learned in Computer Concepts I.  Document formatting will include letters with special features, memorandums, tables, agendas, forms, reports, purchase invoices and orders.  Students will create a business plan using various formatting features.  Students will complete several office simulations.  Students will also learn to design simple web pages.  Students will design presentations using presentation software.

  Pre-requisite--Offered to grades 11 and 12.  Student must have attained a passing grade in Computer Concepts I

  Course length—95 hours—once class period per day for one semester.  One-half credit.

  Course outcomes:

1.                  The student will continue to format text with minimum instruction to enhance the appearance of a word processing document.

2.                  Students will continue to work with special word processing tools such as cut and paste and search and replace.

3.                  Students will learn how to create electronic presentations.

4.                  Students will continue to advance skills in database applications.     

5.                  Students will work with graphic layout and design to produce newsletters, brochures, posters, etc.

6.                  Students will extend skills in working with spreadsheets.

7.                  Students will search the web using various strategies to find information.

Course Content:

I.                    LEARN TO CREATE A BUSINESS PLAN

A.     Create a business plan

B.     Demonstrate ability to integrate knowledge and skills into the business plan

II.                 ASSESSING INFORMATION PROCESSING SKILLS

A.     Assess Correspondence formatting skills

B.     Assess column document formatting skills

C.     Assess spreadsheet software skills

III.               DEVELOPING DATA BASE APPLICATIONS

A.     Add records to an existing database

B.     Create a database and table

C.     Create a database table

D.     Create a new table in an existing database

E.      Add new records to update a database

F.      Add new fields

G.     Edit records

H.     Create data source

IV.              ADVANCED DATA BASE APPLICATIONS

A.     Create queries and computed fields

B.     Create forms

C.     Create reports

D.     Combine sources with mail merge

E.      Prepare mailing labels and envelopes

V.                 EXTENDING SPREADSHEET SKILLS

A.     Format cells and columns

B.     Page set up and printing

C.     Proofread and make printing adjustments

D.     Expand entering and formatting skills

E.      Sort and freeze and hide columns and rows

F.      Referencing cells and using functions

G.     Answering “what if” questions and using the IF function

H.     Integrating Worksheets and word processing documents

I.        Integrating worksheets with word processing and the Internet

VI.              CREATING ELECTRONIC PRESENTATIONS

A.     Describe and plan electronic presentations

B.     Create text slides

C.     Insert art and drawing objects

D.     Create diagrams and tables

E.      Create graphs

F.      Use special effects, timing and printing

G.     Create an original presentation

VII.            DESIGNING WEB PAGES

A.     Learn Web page basics

B.     Create Web pages with tables, graphics and pictures

C.     Use hyperlinks in web pages

D.     Construct a simple web page

VIII.         SEARCHING THE WEB

A.     Learn to operate your browser

B.     Learn browser basics

C.     Work with web pages

D.     Conduct Web searches

E.      Apply Web searching strategies

TEXTBOOKS
Century 21, Seventh Edition, Computer Applications and Keyboarding, South-Western Publishing, 2002.

SOFTWARE
Word XP
Excel
Print Shop