Frederick Community College

Microcomputer Applications:  Excel

Hybrid Seven-Week Class

Spring 2009

To be successful in this course, you must have access to Excel 2007 (either at home or at work).   If you need additional access to Excel 2007, the open computer labs on campus are available 8 – 10 Monday through Thursday and Friday mornings.  Please note:  There are MAJOR changes in Excel 2007, and you will not be able to complete the assignments if you use earlier versions of Excel!!!!! No exceptions to any assignments will be made if an earlier version of Excel is used!!!!!

Instructor Information

Name:   Rebecca Yankosky

Work Phone:  301-846-2632

E-mail:  byankosky@frederick.edu

Campus Mail Box Number:  173

Course Information

Credits:  3

Last Day to Drop:  February 25, 2008

Prerequisites: CIS116D or CIS101

Co-requisites:  none

Meeting Day(s):  Wednesday

Meeting Time(s):  5:00 – 7:35 pm

Course Description

Covers the basic and intermediate features of a commercial spreadsheet package.  Students design a variety of worksheets and graphs, create formulas, use functions, work with a spreadsheet’s database feature, apply “what if” techniques, and exchange data with other applications.

Core Learning Outcomes

By the completion of the course students will be able to:

build a spreadsheet using functions, formulas, and values

analyze data presented in a worksheet

complete scenarios

use graphs to interpret data

Instructional Methods

Instructional methods will include lecture, demonstration, and instructor-guided exercises.

Text(s) for Course

Parson, Oja, Ageloff, and Carey, Microsoft Office Excel 2007, Second Edition, Comprehensive, Course Technology.

Evaluation Methods

Final Grade Scale

(Based on Total Points)

Tutorial Assignments       20%

Review assignments        20%

Case Studies                   30%

 Exams                           30%

90% and above      = A

80% - 89%            = B

70% - 79%            = C

60% - 69%            = D

Below 60%             = F

**NOTE: It will be necessary to hand in every required tutorial assignment to receive a grade of  “A” in this course.

Course organization

This course is a hybrid course.  You are expected to attend each class session.  Your work will be submitted through Blackboard and in hard copies depending on the assignment.  All your exams will be given on-line in class.

Progress Report:  

Students will receive an assessment of their progress by the third class.

Attendance Policy:  

Students are expected to attend every class or notify the instructor otherwise.   

Students with Disabilities

FCC provides reasonable accommodations to otherwise qualified students with disabilities in accordance with the Americans with Disabilities Act of 1990 (ADA) and Section 504 of the Rehabilitation Act of 1973 (Section 504) and amendments.  Students with disabilities who are in need of accommodations must contact the Services for Students with Disabilities (SSD) office at 301-846-2408 (A Building, Room 106A) in order to request and apply for services.  The SSD office will require appropriate documentation of a disability.  Questions related to accommodations or services can be directed to the SSD office.  Additional information related to services can be viewed at the following FCC web page:  http://www.frederick.edu/student_services/disability.aspx.

If you currently receive services from the SSD office, please submit your Student Success Plan to me and make an appointment with me to discuss your accommodations and needs in class.  I will hold any information you share with me in strict confidence unless you give me permission to do otherwise.

NOTES:

All assignments are due on the dates listed on the syllabus.  Late assignments will not be accepted unless arrangements have been made with the instructor.

Attendance for presentations/lectures is expected unless other arrangements have been made with the instructor.  Excused absences are awarded at the instructor’s discretion.

The instructor reserves the right to adjust the assignments, schedule, and/or exams.  In the event this is necessary, students will be notified of any changes.  Student make-up exams will be available only with prior notification and instructor permission.

All assignments must be clearly labeled with the student’s name, tutorial number, and assignment number or type.

Failure to properly label work will result in no credit being given.

Course Competencies:

A student who completes this course should be able to:

Work with multiple worksheets and files

Consolidate worksheets

Exchange data among worksheets

Use advanced printing functions

Create charts

Prepare enhanced charts

Prepare enhanced worksheets

Set up, enter data, edit and sort databases in a worksheet

Filter data using AutoFilter and Advanced Filter to sort lists

Use database functions

Work with data tables

Get summary information with subtotals

Convert a worksheet to HTML format

Work with 3-D shapes

Protect cells and worksheets

Use cell comments

Use custom sorts

Use data forms

Link and embed between worksheets and software applications

Create, save, and use customized templates