|
Frederick Community College CIS111E-ONL Spreadsheets
(Excel 2007) Spring 2009
|
||
|
Class
Begins:
1/22/2009 |
Class
Ends:
5/15/2009 |
Last
Day to Drop:
4/3/2009 |
|
You must send your email address to
the instructor before class begins |
|
Instructor Information |
|
|
|
|
|
Name: Susan Boyne |
Office: C222 |
|
E-mail: sboyne@frederick.edu |
Phone Number:
301-846-2410 |
|
Office Hours: See faculty information in Bb |
Campus Mail Box #: 107 |
|
Course Information |
|
|
|
|
|
Credits: 3 |
|
|
On-campus Meetings: Orientation |
On-campus Exams:
2 |
|
Prerequisites: CIS 101 or CIS116D |
Co-requisites: None |
|
Course Description |
|
|
|
This course 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: |
|
1. build a spread sheet using functions, formulas, and values |
|
2. analyze data presented in a worksheet |
|
3. complete scenarios |
|
4. use graphs to interpret data |
|
Instructional Methods |
|
|
|
Reading assignments (text and online) |
|
Software hands-on activities |
Course organization
|
|
|
|
This course is to be taken on the Internet. With the exception of an orientation and
two on-campus examinations, all correspondence, class instruction and notes,
communication (both with students and instructor), assignments and quizzes
are to be completed online using Blackboard (Bb). |
|
Text for Course |
|
|
|
Microsoft Excel 2007 Comprehensive, New
Perspectives Series, June Jamrich Parson, Dan Oja, Patrick Carey and Roy
Ageloff, Copyright 2007, Course Technology, Thompson Learning |
|
Evaluation Methods |
Final Grade Scale |
|
|
|
|
Hands on assignments 40% of grade On-line
theory quizzes 20% of
grade Theory exams 40% of grade |
90% & above =
A** 80% - 89% = B 70% - 79% = C 60% - 69% = D Below 59% = F |
|
If the graded
performance for online assignments differs significantly from the grade
average for proctored assignments, the instructor reserves the right to
administer additional tests. **NOTE: It
will be necessary to hand in every required tutorial assignment to receive an
“A” grade in this course. |
|
|
Attendance/Participation Policy |
|
|
|
Attendance: Attendance on campus is required for the
examinations. You will have a week to
take the exam in the testing center.
You will be required to sign in and provide a photo id at the testing
center. Exams are not timed. Participation: Students are required to participate in
this class through their assignments, quizzes, exams, and e-mails. Please submit all work via the Bb Assignments
area by the due date. Late assignments
will be accepted with points deducted.
However, late assignments will NOT be accepted once the exam for the
tutorial has been completed. Occasionally, the discussion board will be used
to post questions and provide responses to students’ questions. |
|
Privacy and Communication in this course |
|
|
|
E-mail is an instructional tool essential to
student-instructor and student-student communication. In the Bb environment
by default, your e-mail address is available to all students in this
course. However, students are
permitted to use e-mail addresses of other students in this course only for
the purpose and the duration of this course.
Students are required to use their myfcc e-mail address for this course. The instructor can be expected to respond to
regular student e-mail inquiries (grades, posted assignments, and tests
excluded) within the time frame of 48 hours. |
|
Academic Honesty |
|
|
|
Work in this course is
subject to the provisions of the FCC Code of Academic Honesty. Plagiarism in
any form will not be tolerated. As a student, it is your job to practice
academic honesty at ALL times. Make
sure that all sources, particularly Internet sources, get proper credit for
quotations, paraphrases, and ideas. |
|
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. |
|
Progress Report |
|
|
|
Grades will
continually be posted in the Grade Book section of the Bb site. Students can monitor their grades
throughout the semester. By the end of the sixth week of the semester,
you will have an opportunity to evaluate your progress in this course and
decide if you need to make any adjustments (additional study, tutoring,
conference with instructor) to assure your success in this course. |
|
Notes: |
|
|
|
1.
Within each week, you will be working in a
self-paced environment in which you set the pace for reading and practicing
the assigned tutorials and completing the assignments by their due
dates. You are advised to use your time
wisely and efficiently in order to set your work speed, to make decisions and
to set priorities in order to meet the weekly tutorial, assignment and quiz
deadlines. 2.
You must have access to
Excel 2007 (either at home, work, or make time available to use computer
lab). Please note: There are MAJOR changes in Excel 2007 and
you will not be able to following the directions in the book if you use
earlier versions of Excel!!!!! 3.
It
is the student’s responsibility to gather the assignments and due dates from
the Bb site and adhere to the schedule.
Students may hand in assignments late; however, points will be
deducted. Tutorial assignments will NOT
be accepted after the exam for that tutorial has been graded. 4. Computer problems or failure to connect to
the Internet to access Bb/e-mail will not excuse the student from completing
the course requirements by the due dates.
The computer lab is available during posted hours. 5. Student data files will be downloaded from the text's Web site. There is a link to the text's Web site in
Student Data Files folder in Bb and the link is also listed in the text. Read the directions on downloading files BEFORE you attempt to download the
data files. 6. In order to fully understand the concepts
introduced in each tutorial, to successfully complete the required assignments/cases
at the end of the tutorial, and to receive the best possible grade in this
course, all tutorial exercises will be completed and submitted as part of the
hands-on assignment grade. FYI: In the past, students were unsuccessful
in this course if they did not read the required tutorials and complete the
exercises within the tutorials. 7. All assignments will be saved as directed in the book with one
modification: Please include your last name as the first part of the
file name. e.g. Boyne_Financial_Services.xlsx 8. You are welcomed (and encouraged) to send your assignments to me as
soon as you finish them (as opposed to waiting until the due date). I can then provide immediate feedback and
grading, which may help in completing remaining assignments. 9. All graded work will be submitted via Bb's Assignment folder. 10. Quizzes:
Online theory quizzes must be taken each week. Quizzes are only available in the
Assessments folder of Bb during the assigned timeframe. Quizzes will expire and will no longer be
accessible after the due date. 11. Please notify the instructor immediately of
any change in phone number(s), residence address, or any other means of
contact. Also make these changes in Bb. 12. You are required to use your myfcc email address. 13.
If you have any questions
or concerns, please notify the instructor by e-mail. |
|
TOPICAL
OUTLINE |
||
|
Week |
Topic |
Assessments |
|
Week 1 Week of: 1/25/2009 |
Reviewing the basics: Tutorial 1: Getting Started
with Excel |
Quiz for
Office 2007 Assignment
for Tutorial 1 |
|
Week 2 Week of: 2/1/2009 |
Tutorial 2: Formatting a Workbook
|
Assignment
for Tutorial 2 Quiz for
Tutorial 2 |
|
Week 3 Week of: 2/8/2009 |
Tutorial 3: Working with
Formulas and Functions |
Assignment for Tutorial 3 Quiz for Tutorial 3 |
|
Week 4 Week of: 2/15/2009 |
Tutorial 4: Working with
Charts and Graphics |
|
|
Week 5 Week of: 2/22/2009 |
Theory Exam
1: Tutorials 1, 2, 3, 4 The exam will be a
multiple choice, theory test given in the Testing Center |
|
|
Week 6 Week of: 3/1/2009 |
Tutorial
5: Working with Excel Tables,
PivotTables, and PivotCharts |
|
|
Week 7 Week of: 3/8/2009 |
Tutorial
5: Working with Excel Tables,
PivotTables, and PivotCharts |
Assignment for Tutorial 5 Quiz for
Tutorial 5 |
|
Week 8 Week of: 3/15/2009 |
Tutorial
6: Managing Multiple Worksheets and Workbooks |
Assignment for Tutorial 6 Quiz for
Tutorial 6 |
|
Week 9 Week of: 3/22/2009 |
Tutorial
7: Using Advanced Functions,
Conditional Formatting and Filtering |
Assignment
for Tutorial 7 Quiz for
Tutorial 7 |
|
Week 10 Week of: 3/29/2009 |
Appendix
A: Working with Functions and Creating
Custom Formats |
|
|
4/6 – 4/12 |
Spring Break FCC Closed |
|
|
Week 11 Week of: 4/12/2009 |
| |