This course is designed to allow the student the opportunity to learn computer spreadsheet application skills using spreadsheet software (currently Microsoft Office Excel 2003) on the computer. This is a basic course to allow the student to learn how to use the program to create basic spreadsheets and to use formulas and functions.  In this course you will learn to design and produce a variety of business spreadsheets. You will learn to create, format and edit spreadsheets well, produce charts from your spreadsheet data, write and copy formulas, and basically get comfortable with spreadsheets. This is an intensive course with a strong emphasis on production. You will become quite familiar with using this program as you produce numerous spreadsheets.

 

SPREADSHEET & BUSINESS MATH
 

DAILY SCHEDULE
Day Date/Activity
 

day 1

MONTH

- Discuss syllabus.

- The Computer System. The Four Components of the Computer System:

HARDWARE

SOFTWARE

USER &

PROCEDURES
day 2 - The Fundamentals

1.1 Starting Excel

1.2 What's new in Excel 2003?

1.3 Understanding the Excel Program Screen

1.4 Using Menus
day 3 - The Fundamentals

1.5 Using Toolbars

1.6 Filling Out Dialogue Boxes

1.7 Keystroke & Right Mouse Button Shortcuts

 
day 4 - File Management

1.8 Opening a Workbook

1.9 Saving a Workbook

Do Lesson 1A, p. 27
day 5 - The Fundamentals

1.10 Moving a Cell Pointer

1.11 Navigating a Worksheet

1.12 Entering Labels in a Worksheet

1.13 Entering Values in a Worksheet and Selecting a Cell Range

Do Lesson 1B, p. 34

Do Practice 1
day 6 - The Fundamentals

1.14 Calculating Value Totals with AutoSum
day 7 - The Fundamentals

SLIDE PRESENTATION #1

1.15 Entering Formulas

1.16 Using AutoFill

1.17 Previewing & Printing a Worksheet

1.18 Getting Help

1.19 Changing the Office Assistant & Using the Help Button

1.20 Closing a Workbook and Exiting Excel

Do Lesson 1C, p.40
day 8 - Lesson IC

Lesson 1.15

Lesson 1.16

Packet A

Practice 1
day 9

- Review 1.15 Entering Formula

Table 1 - 7

Operators, References & Formula

Lesson Summary

Quiz Review

Do Packet A (Saving a Workbook, Renaming Worksheets and Data Entry)
 

day 10

 Recap:

1. Data Entry

Exercise #1 - Packet A

2. Data Entry and Formula

Exercise #2 - Practice 1

Exercise #3 - Homework 1, pp. 56 - 57

(Format, Gridlines, Header/Footer:  Name, Exercise #, Date)
day 11 - Review pp 52 - 58

Practice 2 (The * operator)

Part I - Vocabulary

Part II - The Excel Screen

Part III - Multiple Choice

Part IV - Application Tests 1 & 2
day 12

MID - TERM EXAM
day 13 - Chapter 2 - Editing a Worksheet, p. 59

Objectives

Do Exercises:

2.1 Entering Date Values and Using AutoComplete, pp. 60 -61

2.2 Editing, Clearing, and Replacing Cell Contents, p. 63

2.3 Cutting, Copying, and Pasting Cells, p. 65

2.4 Moving and Copying Cells with Drag and Drop, p. 67

Gridlines, Name, 2.1, Date

Explain Packet A

g:\share\customguide\excelpractice\Lesson2A
day 14 - Work with Packet A

2.6 Working with Absolute and Relative Cell References

Relative Cell Reference -

Absolute Cell Reference -

day 15 - Chapter 2 -

2.6 Working with Absolute and Relative Cell References

2.7 Using the Paste Special Command

2.8 Inserting and Deleting Cells, Rows, and Columns
day 16 - Work with Packet B (Data Entry, Formulas, Formatting)

- Chapter 3 - Formatting a Worksheet

Discussion

Demonstration

Do Exercises:

3.1 Fonts

3.2 Values

3.3 Row Height, Column Width

3.4 Cell Alignment

 
day 17

- Chapter 3 - Formatting a Worksheet

Do Exercises:

3.5 Adding Borders

3.6 Applying Colors & Patterns

3.7 Using Format Painter

3.8 Using AutoFormat

day 18

- Chapter 3 - Formatting a Worksheet

Do Exercises:

3.9 Creating a Custom Number Format

3.10 Creating, Applying, and Modifying a Style

3.11 Formatting Cells with Conditional Formatting

3.12 Merging Cells, Rotating Text, and Using AutoFit
day 19 - Chapter 4 - Creating and Working with Charts

4.1 Creating a Chart

4.2 Moving and Resizing a Chart

4.3 Formatting and Editing Objects in a Chart

4.4 Changing a Chart's Source Data

4.5 Changing a Chart Type and Working with Pie Charts
day 20 - Chapter 4 - Creating and Working with Charts

4.6 Adding Titles, Gridlines, and a Data Table

4.7 Formatting a Data Series and Chart Axis

4.8 Annotating a Chart

4.9 Working with 3-D Charts

4.10 Selecting and Saving a Custom Chart

4.11 Using Fill Effects
day 21

REVIEW.
day 22

End of class.  FINAL EXAM

Submit all required exercises and make-ups.

 

 

SEATTLE VOCATIONAL INSTITUTE

COURSE SYLLABUS

The Business Computer Applications Department prepares knowledgeable, highly skilled and motivated employees who provide dedicated and professional service to their employers and community.

Course Title:  Spreadsheet I (ADM 160)

Program:  Administrative Office Professional

Instructor:  Gesito L. Juanich
Office:  Rm. 505-C Division:  Business Computer Applications
Phone:  587 - 4944 E-mail:  gjuanich@sccd.ctc.edu

Quarter:  Winter 2007

Clock Hours:  33 hrs.

Meeting Times:  W & F (1:00 p.m. – 2:30 p.m.)                  Room:  506

Prerequisites:  Office Support Applications (ADM 140) concurrently taken

Course Description:  This course is designed to allow the student the opportunity to learn computer spreadsheet application skills using spreadsheet software (currently Microsoft Office Excel 2003) on the computer. This is a basic course to allow the student to learn how to use the program to create basic spreadsheets and to use formulas and functions.

Course Purpose And Goals:  In this course you will learn to design and produce a variety of business spreadsheets. You will learn to create, format and edit spreadsheets well, produce charts from your spreadsheet data, write and copy formulas, and basically get comfortable with spreadsheets. This is an intensive course with a strong emphasis on production. You will become quite familiar with using this program as you produce numerous spreadsheets.

Program Outcomes:  To successfully complete this course you will need to demonstrate an ability to:

1. begin a new workbook or open an existing workbook.

2. use the various icons to assist in creating spreadsheets.

3. create, format, and edit basic business spreadsheets.

4. write formulas to calculate sums, averages, and percentages.

5. determine information using SUM, AVERAGE, MAX, and MIN functions.

6. efficiently select, copy, move, and paste ranges using mouse pointers, icons and keys.

7. efficiently copy formulas using absolute and relative cell reference.

8. work with functions, formulas, and charts.

ADA Statement:  If you need course adaptations or accommodation because of a disability, if you have emergency medical information to share with your instructor, or if you need special arrangements in case the building must be evacuated, please make an appointment with the instructor as soon as possible.

Instructional and Learning Methods:  Lectures, discussions, questions and answers, hands-on computer production of business documents, testing

Course Text:  Microsoft Office 2003:  Essentials

Course Materials:  Handouts will be given as needed in class.

Student Assignments:  Production of a large number or business spreadsheets

Learning Resources:  Computer labs (rooms 410, 505, 506, 507, 509, 516) are available from 8:00 a.m. to 5:00 p.m. Monday through Friday when an instructor, instructional technician, or tutor is available.

Feedback/Evaluation:  Feedback will be given by the instructor as needed based on the program outcomes stated above. You will have regular tests to show the competencies you have learned.

Grading Policy:  SVI uses the following grading system:

A = 4.0 – 3.5, B = 3.4 – 2.5, C = 2.4 – 1.5, D = 1.4 – 0.7, F = 0.6 - 0.0

Grades will be based on meeting the program outcome competencies listed above.

Attendance Policy:  SVI as a clock-hour institution has a 100% attendance policy. Any hour that you are absent from class, you must make up. A student must have a total attendance of no less than 91% to maintain Satisfactory Attendance Progress. If a student does not meet the attendance requirement for the course, the student may arrange with the instructor to make up the hours necessary to complete the attendance requirement.

Course Content Outline:                                                                                                           Hours

I. Basic Commands, Icons, Menus, Mouse Pointers  6
II. Creating, Formatting, Editing Basic Spreadsheets 12
III. Formulas  6
IV. Functions  6
V. Absolute and Relative Cell Reference  3

Behavioral Expectations:  The classroom is a learning environment. Only behavior that allows the classroom to remain a learning environment is acceptable.