COURSE DESCRIPTION

Holy Names University

Ms. Ana Weston Solomon, MA Ed.

CSCI 10C Spreadsheets

Nov 9, 16, 23 2004

Office Hours: By arrangement

Web site: www.asolomon.com

Phone 510-382-9281 * Before 8PM

Excel – Introduction to Excel is a 6 hour class course designed to acquaint students with the basics of spreadsheet operation. Students will learn to create spreadsheets, input and edit data, build formulas, evaluate information, and create charts and polished spreadsheets. Students will use MS Excel as the operative spreadsheet program.

COURSE DATA

Class meets Tuesday 6 to 8 PM. Additional lab time will be required.

MATERIALS NEEDED

Storage media: either floppy disc, zip disc or flash drive.

COURSE OBJECTIVES

Academic Achievement: Students will demonstrate an understanding of spreadsheet design and manipulation using MS Excel through in-class assignments and homework projects.

Critical Thinking: Students will learn to make appropriate decisions about the content and aesthetics of a spreadsheet report.

Technological application: Students will practice using MS Excel to develop spreadsheets and formulate information.

MEANS OF ACHIEVING COUSE OBJECTIVES

Computer Lab Work: Learning Excel to create spreadsheets, homework assignments.

EVALUATION

Evaluations of students’ assignments, homework assignments.

REGARDING ABSENCES

If you are going to be absent call me and let me know ahead of time. If you miss a class you are required to make up any homework due and if possible, turn it in on time. Failure to do this, without calling to make arrangements, will result in penalties with your grade. Missing more than one class will require you to drop the course. If you have any questions, please call me for more information. New concepts will be taught each session.

Tuesday, November 9, 2004 - Class One

Spreadsheet Basics

Moving Around the Worksheet

Enter Labels and Numbers

Widen Columns

Use Auto-Fill

Edit Data

Move Text

Copy Text

Save your work

Save file with a different name

Open a file

Working with Formulas

Input a formula

Copy a formula

Sum Shortcut

Auto Fill to copy a formula

Copy Groups of formulas

Work with Functions

Use Sum Function

Use Function Wizard

Use Average Function

Work With A Series

Replace Contents Of Cells

Format Column and Row Headings

Tuesday, November 16 - Class Two

Copy Ranges Of Data

Format Numbers for Currency

Format Percent

Format Data

Review

Insert rows and columns

Merge Cells and Center Data

Use tabs to access multiple worksheets

Use If Statements

Preview the Worksheet

Change Page Orientation

Change Margins

Add a Header and Footer

Use 3 D Formulas

Tuesday, November 23 - Class Three

Format Borders and Shading

Create Charts and Graphs

Final Project

HOMEWORK

Homework assignments are posted on my web site: www.asolomon.com

GRADES

Will be based on attendance, homework assignments and final in-class project,

Grading for

Homework Assignments 25%

In class Projects 25%

In class Final Project 50%

Grades

100-96 A

95-90 B

89-80 C

79-70 D

69 or less F