Contact Us Cerritos Home Databook Home Information Technology and Development Cerritos Home Sandra Elizondo Home Cerritos Home Campus Information Admissions Academic Resources Student Resources Administration Personnel Services Search Cerritos CollegeSandra Elizondo

MICROSOFT EXCEL LEVEL 1 & 2

BCOT 113

INSTRUCTOR: DR. SANDRA E. ELIZONDO

TELEPHONE: (562) 860-2451, Ext. 2743

E-MAIL: selizondo@cerritos.edu

OFFICE: SS32 or BE14

OFFICE HOURS: MW: 7:00 – 7:30 P.M.

Online: T/TH 9:00 – 10:00 P.M.

SUPPLIES: UCB Flash drive; CD comes with book

MATERIALS OF INSTRUCTION:

Microsoft Excel 2007 Specialist & Expert (Benchmark Series) by Nita Hewitt Rutkosky & Audrey Rotkosky Roggenkamp, Paradigm Publishing, includes Student Resources Version 1.0 (data Disk)

 Level 1

Week

Course Topics/Skill Area

Resources

1

2

 

Overview of Class

 

Preparing an Excel Worksheet

Chapter 1 -

Inserting Formulas in a Worksheet

Chapter 2 –

 

 

3

Formatting an Excel Worksheet

Chapter 3 –

 

 

4

Enhancing a Worksheet

Chapter 4 –

 

 

5

LEVEL 1 UNIT 1 Performance Assessment

Unit 1 –

5

Moving Data within and between Workbooks

Chapter 5 –

 

 

6

Maintaining Workbooks

Chapter 6 –

 

 

7

8

Creating a Chart in Excel

Chapter 7 –

Adding Visual Interest to Workbooks

Chapter 8 –

 

 

9

LEVEL 1 UNIT 2 Peformance Assessment

Unit 2  -

 

Level 2

Week

Course Topics/Skill Area

Resources

10

11

Formatting Excel Worksheets Advanced Formatting Techniques

Chapter 1 -

Advanced Functions and Formulas

Chapter 2 –

 

 

12

Working with Tables and Data Features

Chapter 3 –

 

 

13

Summarizing and Consolidating Data

Chapter 4 –

 

 

13

LEVEL 2 UNIT 1 Performance Assessment

Unit 1  -

14

Using Data Analysis Features

Chapter 5 –

 

 

15

Protecting and Sharing Worksheets

Chapter 6 –

 

 

16

 17

 

Automating Repetitive Tasks and Customizing Excel

Chapter 7 –

Importing, Exporting, Distributing Data

Chapter 8 –

Review

 

18

Level 2 Unit 2 Performance Assessment

Unit 2  -

 

COMPUTER TIME

Approximately 15 to 20 hours per week of computer time is recommended for successful completion of course requirements.  It is highly recommended that you sign up for BCOT 3T in case, you need some help on campus.  The Lab is a .5 credit course that allows you to attend the lab.

All assignments must be completed in order to satisfactorily complete the requirements of this course.

COURSE POLICIES

Assignments: All assignments are due at the beginning of class on the date due. All assignments must be completed in order to satisfactorily complete the requirements of this course.

Academic Dishonesty: Plagiarism and cheating are serious offenses and may be punished by failure on exam, paper or project; failure in course; and or expulsion from the College. For more information refer to the "Academic Dishonesty" policy in the College Catalog.

Need for Assistance: If you have any condition, such as a physical or learning disability, which will make it difficult for you to carry out the work as I have outlined it, or which will require academic accommodations, please notify me as soon as possible.

No Children are allowed in the classroom at any time.

GRADING POINTS
LEVEL 1 & 2 - SKILLS ASSESSMENTS - LAB

136 POINTS

There will be 68 CLASS/LAB PRODUCTION ASSIGNMENTS each worth 2 points.
All assignments must be turned in complete to receive full credit.

EXCEL LEVEL 1 ASSESSING PROFICIENCY

80 POINTS

Each assessment is worth 5 pts. each.
Unit 1 -- 35 pts. ( 7 assessments)
Unit 2 -- 45 pts. ( 9 Assessments)

EXCEL LEVEL 2 ASSESSING PROFICIENTS

 60 POINTS

Each assessment is worth 5 pts. each.
Unit 1 -- 30 pts. ( 6 assessments)
Unit 2 -- 30 pts. ( 6 assessments)

CONCEPTS CHECK HOMEWORK

16 POINTS

Each chapter Concepts Check Homework assignment will be worth one point.
Homework must be handed in on time.

CLASS PARTICIPATION

8 POINTS

TOTAL POINTS POSSIBLE (Final Grade): 300 POINTS
270—And Above Points = A
240—269 Points = B
210—239 Points = C
180—209 Points = D

ASSIGNMENT SHEET

 

Last update: 01/13/09