CSCI C153 Course Information

Course Description

(A/CSU)

This hands-on computer course is designed to provide an intermediate understanding of spreadsheets. Learn how to analyze data through list management, using autofilter, sort and pivot table features. Work with multiple worksheets and workbooks, and then create a shared workbook, resolve conflicts, and track changes. Finally, plan and prepare an application using Excel's data validation feature and button creation using macros. This course completes topics required in preparation for the core level Microsoft Excel Office Specialist certification exam. (Prerequisite: None.) Advisory: CSCI C123.

NOTE: Be aware your instructor will ONLY contact you using your school generated email (@email.cerrocoso.edu, @email.bakersfieldcollege.edu, or @email.portervillecollege.edu). Check your school email early and often.

Course Details

Course Name & Number: CSCI 153
CRN: 30138
Course Title: Intermediate Excel
Instructor: Kathy Bultman
Units: 1
Class Meets: March 12 - May 12
Term: Spring 2012
Textbook:
- New Perspectives Microsoft Office Excel 2010 Comprehensive - Parsons, Oja, Ageloff & Carey Publisher: Thompson Course Technology. Copyright 2011.
  13: 978-0-538-74291-7, 10: 0-538-74291-7
Estimated Time per Week: 3 hours
Skill Level: Basic knowledge of spreadsheet creation, design, saving; file saving, email and sending attachments. An understanding of internet navigation and use of web sites is also important.
Special Requirements: MS Excel 2010 software on your pc is required. 2007 can be used but is not recommended as templates will not match.

As the class is designed using MS Windows Excel software, Mac's will not work.

Assignments & Tests: Assignments are on-going throughout the class; we will do assignments each week, that are due at the end of each week of the class. There will be a final at the end of the class, which will showcase the skills you have learned in the class.
Proctored Exams: No
Additional Comments: Note from the Instructor: Welcome to the exciting world of online learning! You are taking advantage of the opportunity to work at home on your own schedule within an eight-week time block. This course assumes that you have basic computer knowledge, including file management, Internet and e-mail experience. Online classes are as demanding as on-campus classes, or even more demanding in some cases. Students are expected to meet weekly assignment deadlines. The most successful online students are those who are able to manage time and manage self--perhaps not too different from any other endeavor. I hope you will enjoy learning more about Excel 2010 - I will try to assure that you find the class, interesting, challenging, interactive and fun!

Disclaimer: The book prices are an approximation only and are subject to change.

This will take you to the Bookstore.

Top

Faculty Resources

:: Resources

CSCI C153 Course Information

Course Description

(A/CSU)

Course Details

Faculty Resources

Related Links