Menu

Class Homepage

Syllabus

Homework
Assignment
Calendar

WebCT

Mario's Homepage

CIS Homepage

 

Welcome to the Class

Class Begins on Monday June 13, 2011

This course is for students who want to learn the comprehensive functions of Microsoft Excel, a powerful spreadsheet program which is part of the Microsoft Office Suite. This course prepares students for Microsoft certification testing but is also useful for students who want a deeper understanding of the program. No previous experience with this software is required. 

No previous experience with this software is required.

Upon completion of this course students will be able to use the robust features of MS Excel. This course will also prepare students to take the Microsoft Office Specialist (MOS) Exam for Microsoft Excel. This course will cover all the topics specified by the MOS Program - Expert Level. Upon completion of this course, if so desired by the student, they may take the MS Excel MOS Expert Level Exam at any Authorized Testing Center (ATC). Students passing the Exam will receive an Industry Certificate stating that Microsoft Corporation considers them an Expert in MS Excel.

Upon completion of the course students will be able to:

  1. Perform basic to advanced spreadsheet operations required of students and workforce professionals
  2. Plan, design and produce spreadsheet documents by using the features of the Excel software.
  3. Determine which features can be appropriately used in various situations.
  4. Solve common issues by using the software's features.
  5. Develop problem-solving skills and the ability to work as a team member using the collaboration tools of the software.

The purpose of this course is to Learn the comprehensive functions of Microsoft Excel, as a precursor for Microsoft certification testing as well as a deeper understanding of the program. This course is a core requirement for the Computer Information Systems Certificate of Achievement.

Upon completion of the course students will be able to:

SLO#1. produce spreadsheets with formulas.

SLO#2. develop charts based on spreadsheet data.

SLO#3. apply the use of formula auditing to troubleshoot formulas and functions.

Helpful Videos to Watch Before Class Begins

Video - Tips for Success

Video - How to Logon to WebCT

Video - How to Use the Discussion Board in WebCT


Student Files - Located on the CD in the back of the textbook

OR You can download the studnet files from here and UnZip them

Click Here to Download Student Files (Zipped)


Videos for Using CCC Confer & Online Office Hour Info

CCC Confer is an Online Office Hour website (like WebEx) that allows you and me to share a screen so I can help you via the Internet and telephone.

How to Test Your Computer to Use CCC Confer

Video: Click Here for Test Your Mac Video

Video: Click Here for Test Your Windows PC Video

How to Login to Mario's CCC Confer Office Hour

Video: How to Login to CCC Confer Office Hour

Login to CCC Confer Office Hour - Connection Info
Available:
Mondays = 10am - 11am (except 6/20)
Tuesdays = 8:30am - 9:30am

On your computer:
> Go to www.cccconfer.org
> Under the Meet & Confer logo => Click the Participant Log In button
> Locate your meeting => seach for Mario Tejada - DVC CIS Office Hour
> Click Go.
> Fill out the form and enter the password: 831093

On your telephone:
> Dial your telephone conference line: (888) 886-3951
> Enter your passcode: 831093


Can't See the Video?

Do you Need to Install the Free Flash Player?
Click Here

Can't See the PDF files?

Do you need to Install the Free Adobe Reader?
Click Here

New DVC Student Email System - InSite Email (available starting Spring 2011)

All students registered for Summer 2011 classes and beyond will receive a FREE email account. Students have been notified via their personal email when the accounts were ready.

Communications from Instructors, Campus Student Email Blasts, Critical deadlines and essential class information now ONLY available through the InSite portal and InSite mail. 

Important Links to Review - Please Read:

View InSite Portal and InSite Mail FAQs:
http://www.4cd.edu/webadvisor/faqs.aspx

About DVC Email:
http://www.dvc.edu/org/departments/a-and-r/vikingemail.htm

This is a YouTube video on
How to forward your new DVC InSite@edu email account
to your personal account. This video refers to the system as Live@Edu.