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 Name & Number: CSCI
Instructor: Kathy Bultman
Meets: March 12 - May 12
Term: Spring 2012
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
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
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.
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