Technology Utilization

Course Outline

The computer is viewed as a tool in the education process. This one-semester course is designed to allow students to develop an understanding of the basic concepts involved in processing information with a computer. This course is designed around the basic applications of word processing, the electronic spreadsheet, graphic presentations and Internet research. By learning to use these applications, students will become much more productive in the educational process.

Prerequisites: None; required course for all students

I. CSW Network Basics

A. Policies

B. Responsibility

C. Security

D. Access CSW's LAN

1. Personal folder

2. File management

3. Maintain Backups

E. Access the Internet

II. Word Processing (Microsoft Word)

A. Basic Skills

1. Create a new document

2. Save a document

3. Open an existing document

4. Use on-line help

5. Access different file types

a. Word document file

b. Text file

c. Picture file

6. Shortcuts and function keys

a. F1 – online help

b. F4 – repeat last action

c. Undo and redo last operation(s)

7. Terminology

a. Character

b. Word

c. Line

d. Sentence

e. Paragraph

f. Screen

g. Page

h. Document

i. Header

j. Footer

B. Viewing a document

1. Different document views

a. Page layout view

b. Normal view

c. Print preview

d. Outline view

2. Rulers

a. Horizontal ruler

b. Vertical ruler

3. Tool bars

a. Standard

b. Formatting

c. Drawing

d. Picture

e. WordArt

4. Navigating the Document

a. Arrow keys

b. Home & End

c. Page Up & Page Down

d. Scroll bars

5. Selecting Text

a. Mouse button

b. Selection bar

c. Shift or Ctrl

d. Navigation keys

e. Extend selection

6. Show and hide special characters

7. Printing a document

C. Document layout

1. Paper size

2. Page orientation

a. Landscape

b. Portrait

3. Page margins

a. Left & right margins

b. Top & bottom margins

4. Header & footer margins

5. Paragraph margins

a. First line indent

b. Left margin

c. Right margin

d. Text wrapping

D. Typing text

1. Typing modes

a. Insert mode

b. Overwrite mode

2. Import text from another file

3. Copy and Paste

a. Clipboard

b. Format Painter

c. Dragging

4. Erasing text

a. Backspace

b. Ctrl + Backspace

c. Delete

d. Ctrl + Delete

5. Text Breaks

a. Start new paragraph

b. Start new line

c. Start new page

d. Start new column

e. Move to next tab stop

6. Special characters

7. Field codes

a. Current date

b. File name

c. Page number

8. Spelling and grammar checking

E. Formatting

1. Horizontal alignment

a. Left aligned

b. Right aligned

c. Centered

d. Justified

2. Vertical alignment

a. Line spacing

b. Space before and after paragraph

3. Tab stops

a. Default tab stops

b. Setting and clearing

c. Left, right, and center tab stops

d. Decimal tab stop

e. Tab leaders

4. Font

a. Type

b. Size (points)

c. Bold, italic, & underlining

d. Color

e. Subscript & superscripts

f. Character spacing

g. Small caps

h. Special Effects

5. Borders and Shading

a. Applied to:

i. Text

ii. Paragraph

iii. Multiple paragraphs

iv. Page

v. Cells within a table

b. Line type, color, width

c. Distances from edge or text

d. Art borders

e. Fill color

f. Pattern

6. Bullets and numbering

7. Columns

F. Tables

1. Creating a new table

2. Inserting and deleting rows and columns

3. Resizing rows and columns

4. Merging and splitting cells

5. Alignment of text within a cell

6. Formatting data within cells

7. Inserting tabs within a cell

G. Drawing objects and pictures

1. Inserting pictures

a. Clipart

b. From a file

c. From the internet

2. Lines, arrows, and shapes

3. Text Boxes

4. Word Art

5. Manipulating objects

a. Aligning

b. Ordering

c. Grouping and Ungrouping

d. Moving

e. Handles

6. Sizing objects

a. Resizing

b. Aspect ratio

c. Cropping

7. Wrapping

a. In line with text

b. Float over text

c. Above and below

d. Left and right alignment

e. Square and tight wrapping

f. Object anchor

8. Picture Appearance

a. Fill

b. Borders

c. Image control

d. Contrast control

e. Brightness control

f. Transparent color

III. Spreadsheets (Microsoft Excel)

A. Basic Skills

1. Create, save, and open a workbook

2. Insert, delete, copy, and rename a worksheet

3. Insert and delete rows and columns

4. Import data from other files

B. Formatting data and cells

1. Cell height and width

2. Number formatting

3. Alignment

4. Font style

5. Borders

6. Shading

C. Numerical calculations

1. Formulae

2. Using functions

a. Sum

b. Average, maximum, and minimum

c. Count

d. Table lookup functions

3. References

a. Relative

b. Absolute

4. Sorting

5. Range names

D. Formatting

1. Page layout

2. Print and print preview

3. Drawing tools

4. Headers and footers

E. Charts

1. Chart types

a. Column

b. Scatter

c. Line

d. High, low, close

2. Non-adjacent ranges

3. Titles

4. Legends

5. Changing types

6. Axis formatting

IV. Graphical slide presentation (Microsoft PowerPoint)

A. Basic Skills

B. Slide layouts

1. Slide master

2. Background

3. Header and footer

4. Slide number

5. Existing templates

C. Slide construction

1. Creating new slides

2. Slide layouts

3. Font styles

4. Bullets and numbering

5. Clip art

6. Drawing tools

7. Sound and movies

D. Custom animation

1. Animating objects

2. Timing and order of animation

3. Building slides on bullets

4. After animation effects

E. Slide transition

1. Transition

2. Timing

F. Viewing show

1. Slide sorter view

a. Change order of slides

2. Notes

3. Outline view

4. Slide show

a. End with black slide

5. Printing

V. Internet Research

A. Search engines

B. Book marking sites

C. Advance search strategies

D. Accessing U of DE search databases

E. Citing references

F. Evaluating sources

VI. Investment project

This is a course-long project that gives students to apply what they have learned.