Course Information Page

Instructor Contact Information
 
  CBTE140 - Microsoft Excel
  Mode of Delivery:  Fully Online
  (Fully Online = All class meetings are conducted online with no on-campus instruction or exams)
 
 

Daisy Cuc Le
San Diego Mesa College
7250 Mesa College Drive
San Diego, CA 92111-4998

619-388-2890
dle@sdccd.edu

 
 
Textbook and Course Material Requirements
 

The Professional Approach Series—Microsoft Excel 2007
ISBN: 978-0-07-351921-0
and Microsoft Excel 2007 software


See District Online Schedule for official list of required and optional textbooks and materials for this class.
Purchase Textbooks Online at the SDCCD Online Bookstore

 
Hardware and Software Requirements
 

Hardware and Software:
To successfully complete this online course, you will be required to meet the minimum hardware and software requirements. View Hardware and Software Requirements.

Internet Browser:
You must use a supported Internet browser in order to successfully work in Blackboard Vista, the online course management system for this course. To see a list of supported Internet browsers, click here.

 
Course Description
 

This course covers the fundamentals of Microsoft Excel and is intended for students without any prior experience with this program.  Topics include creating and formatting worksheets and charts, managing a workbook, and using productivity features to enter functions and analyze data. (FT).  Associate Degree Credit & tranfer to CSU and/or private colleges and universities.

 

Advisory:  CBTE 101 or CBTE 103, and CBTE 114, and ENGL 049, and ENGL 048, each with a grade of "C" or better, or equivalent; or Assessment Skill Levels W5 and R5.


Limitation on Enrollment: This course is not open to students with credit for CBTE 140A.

 
Course Objectives
 

This course will cover the following:

·          Introduction to Excel
* Getting Started with Excel
* Creating a Workbook
* Using Editing and Style Tools
* Exploring Home Tab Commands
·          Working with Formulas and Functions
* Exploring Formula Basics
*  Working with Functions
* Using Logical and Financial Functions
* Rounding and Nesting Functions
·          Enhancing Worksheet Appearance
* Building Charts
* Inserting Shapes
* Using Images and SmartArt Graphics
·          Expanding Uses of Workbook Data
* Using 3-D References
* Working with Tables
* Using Named Ranges and Structured References
·          Auditing, Analyzing, and Consolidating Data
* Using Auditing Tools
* Using What-If-Analysis (optional)
* Consolidating and Linking Workbooks
·          Exploring Macros, Templates, and Workgroups
* Working with Macros
* Using Templates
 
Application and Registration Information
 

REGISTRATION DIRECTIONS:

  1. Complete Online Application (for new SDCCD students). Go to Student Web Services
  2. Receive registration appointment and instructions by email or mail.
  3. Register online at the Reg-e, our online registration system.
  4. Make sure that you pay your tuition so that you don't lose your registration!   Fees and Tuition Information.
  5. Order textbooks online. Visit our online bookstore.
  6. After completion of registration on Reg-e, and several days prior to the start of the semester, you will receive an email with course login instructions. If you don't receive an email please go to http://www.sdccdonline.net and login on the first day of class as follows:

    Type your Blackboard Vista Username = 7-digit College Student Identification (CSID) number
    Type your Password =  mmddyyyy (your birthdate with no hyphens, slashes, or spaces)

    For example:  1010101 (CSID number used at registration)
                           06231980 (password for the birthdate June 23, 1980 )
     
  7. If this course is closed, please login to Reg-e to be placed on a waitlist. If the waitlist is full, you will not be able to add your name to the waitlist.

You will not be able to login to your online course until the first day of the semester!!!
You must login to your online course on the first day of the session to avoid your enrollment being dropped.
Follow the login instructions at www.sdccdonline.net/login.htm

 
Valid XHTML 1.0 Transitional
San Diego City College San Diego Mesa College San Diego Miramar College San Diego Continuing Education