Office Administration

Microsoft Excel 2007

OST 2852C Online Syllabus

Term: Fall 2008
and Spring 2009
 

Course Description and Objectives:

OST 2852C will take you from the basics of Excel 2007 all the way through many advanced features. Some of the topics covered include: creating professional well-organized spreadsheets and charts, working with lists,  advanced functions such as =IF and =VLOOKUP, simple macros, using 3D references in formulas to consolidate data and much, much more. Emphasis is on building "real world" skills through hands on activities using practical applications of topics.

Orientation:

There is no on campus orientation meeting for this class. All the materials and information you need are available online. Please review this syllabus carefully.

Textbook and Materials: 

Textbook bundles may be purchased at the SCC bookstore or ordered online at www.scc.bkstr.com. The required bundle is
ISBN 1-4283-6628-8 or 9781428366282 which includes:

• Textbook: New Perspectives on Microsoft Office Excel 2007, Introductory by Parsons, Oja, Ageloff, and Cary.
  ISBN 1-4239-0584-9 or 978-1-4239-0584-4
   
• CaseGrader Microsoft Office Excel 2007 Casebook with Autograding Technology by Thad, Crews & Chip Murray.
  ISBN 1-4239-9823-5 or 978-1-4239-9823-5
  (Do NOT buy this book used. The booklet contains a key code that can only be used once. You must purchase this book new!)

Hardware and Software Requirements:

You are required to have access to a computer with Microsoft Office 2007 Excel, an Internet connection, an e-mail address, a file compression program (included in Windows XP or later and Vista) and a virus checker program. You must be familiar with using the Internet as all class communications will be conducted on-line. For best results, a high speed Internet service is recommended.

To ensure that your computer has all the requirements for running Microsoft Office 2007, review the following checklist. Please note that you do not have to have the Vista operating system to run Office 2007. It will run with most current Windows versions. You can also visit the Microsoft Office site for more information.

If you would like to purchase the MS Office 2007 program, Microsoft Office is currently offering Microsoft Office Ultimate 2007 to students for for $59.95. This a fantastic deal! Click here for more details. Go to  www.theultimatesteal.com to make your purchase.

You can also purchase  MS Office 2007 Professional which includes Word, Excel, Access, PowerPoint, Publisher, Access and Outlook at the SCC bookstore for $199.98.

Students will have access to computer labs with the required hardware and software on all SCC campuses. If you experience technical difficulties with your personal computer, be prepared to come to a campus lab to complete your assignments as no extensions will be granted due to computer problems. Click here for more information on campus lab locations and hours.

Course Requirements / Grading:

Your grade in Excel will be determined by the following:

Activity	Points
Orientation Activities	20
Module Activities:
Hands on Projects from Textbook: Tutorials & Cases	280
Multiple Choice / True False Quizzes	160
Technology News Activity or Feedback Survey	40
Unit Review Activities:
Review Exercises using CaseGrader	200
Exams	200
Final Culminating Project	100
Total	1000

 

*Note: Total points may vary slightly.

Grading Scale:

The following scale will be used to determine your final grade:
A = 900 - 1000, B = 800 - 899, C = 700 - 799, D = 600 - 699, F = 0 - 599

General Course Guidelines:

Overview of Course Material

The course is divided into two units. Each unit is comprised of four modules.  Each module consists of variety of activities including:

• Tutorial in textbook with hands on activities
• Multiple Choice / True False Question Quiz on Tutorial
• Technology News activity

At the end of each unit, there will be review activities including:

• Review Cases using CaseGrader
• Exam

At the end of the semester, students will complete the course by creating a final comprehensive project on a topic of your own choice. This project will allow you to apply everything you have learned throughout the semester in a "real world" scenario.

 

Due Dates

Activities in each module should be completed by the weekly due dates listed on the schedule. Completing your work weekly on a regular basis will help ensure your success in this course! It is suggested that you post a copy of the Schedule (see link at top of page or in Content area of ANGEL) somewhere where you will see it so that you do not forget due dates. It is your responsibility to complete all assignments on time. You can also use the Calendar tool in ANGEL to keep track of due dates.

Late Work

Tutorial and Case project assignments and Technology News Activities will be accepted up to 7 days late with a 10% penalty.

Quizzes will be accepted up until the end of the Unit. Once the Unit is over, no quizzes will be accepted.

Unit Exams, CaseGrader assignments, and the Final Culminating Project will NOT be accepted late.

Extra Credit

Extra credit may be announced periodically in ANGEL throughout the semester.

Specific instructions on all assignments are posted under the Content area of ANGEL.

Tutorials & Cases

You will be responsible for reading and working through each page of the textbook for the assigned Tutorials. You must have the textbook and use a computer to do all assignments. You should read each page carefully and do every step in the Tutorial before completing the assigned case project at the end of the Tutorial. Tips and Additional resources will be provided in ANGEL. Communication tools, such as a Q&A Discussion Board and email, will be available so that you can receive assistance at any time with your assignments. These assignments will be worth 30 points for Tutorials 1-4 and 40 points for Tutorials 5-8. Projects will be accepted up to 7 days late with a 10% penalty.

All work will be submitted in ANGEL. You must save all files with your initials in the filename. Omit any headers mentioned in the text and add a header with your name, the Tutorial #, the Case # (if applicable), and the date. Switch to the Page Layout view to add the required header. This header identifies each of your printouts. Credit for the work will NOT be given if this header information is not included at the top of each page.

Technology News Activity & Feedback Surveys

These activities will vary for each module. They will include fun assignments regarding new technology or simply feedback surveys asking how you feel about assignments. These assignments will be worth 5 points each. Technology New Activities will be accepted up to 7 days late with a 10% penalty.

Quizzes

At the end of each tutorial, a quiz consisting of 20 Multiple Choice and True False questions will be given. You may take each quiz up to 3 times. Your highest score will count. The questions on each quiz attempt will vary. Quizzes should be completed by the module due date listed on the Schedule. However, quizzes will remain available up until the end of the unit. No quizzes will be given after the unit due date. Each quiz will be worth 20 points.

Review Cases using CaseGrader

For each Unit Review, four cases will be given using CaseGrader. The cases will be very similar to those created at the end of each Tutorial. No CaseGrader projects will be accepted after the due date. Each case will be worth 25 points.

Exams

The Unit Exams will consist of multiple choice and true false questions. Exams will be administered  according to the dates on your Schedule.  No Unit exam may be taken late. Failure to take the exam by the assigned deadline will result in a grade of zero. Each Unit exam will be worth 100 points.

Final Culminating Project

Students will complete a comprehensive project utilizing skills learned throughout the semester. The project can be on any topic and each student's project will be unique. A description of required elements and a grading rubric will be provided. The final culminating project is worth 100 points and must be submitted by the due date listed on the Schedule. No late work will be accepted.

Academic Integrity:

You are expected to maintain the highest standards of academic honesty and integrity while in this course and as a student at Seminole Community College. In short, lying, cheating, stealing, or deception of any type will not be tolerated in any way, shape, or form. This means you may not use another student's work as your own. You may not allow another student to use your work. You may not work with another student on your assignments to the extent that you replicate each other's work. You may not obtain copies of prior semester's work or exams from previous students for your own use. If you submit work which is not completed by you or allow another student to submit your work, a failing grade will be given and I will pursue all academic sanctions available as listed in the college Student Handbook including dismissal from the college. If you have any questions about the college's code of academic conduct, please consult the SCC Student Handbook or contact me. 

Participation / Attendance:

This course will be conducted entirely online within the ANGEL environment. (Students can not login to ANGEL until the first day of the semester.) ANGEL is a course management program which allows for course delivery over the internet. Student tracking, lecture notes, grades, testing, etc. will all take place within the ANGEL course site.

For more information about ANGEL, please refer to the Using ANGEL @ SCC on the Distance Learning web site at http://www.scc-fl.edu/dl/angel. You may also stop by the DL office (L-110, Sanford/Lake-Mary campus) to pick up a print copy if you happen to be on campus.

Your participation is crucial to your success in this class. Online course require a time commitment equivalent to on campus classes. Be prepared to spend 4 - 6 hours per week to be successful in this course. It is expected that you check into ANGEL to review the Discussion Board and check your e-mail several times a week. You will also be reviewing lecture notes and assignment material. This is how you attend class.  It does not matter what time of day or night you check in.  This is the way the instructor and your classmates correspond with you. Please use the e-mail feature within ANGEL once the course begins and everyone can log in.

Postings to the discussion boards can be viewed by anyone in the class at any time, so if you have a question, post it to the board and another student or I will answer your question for you. The discussion board should should not be used for grade-related questions. You can email your instructor with questions, comments or concerns at anytime. Emails will be answered within 24-48 hours Monday through Friday. Please try asking and answering questions on the board rather than e-mailing the instructor. That way everyone can benefit from both the questions and answers. Chat rooms are available as well if anyone wants to set a date and time to meet and study. These tools will serve as your support system and can alleviate the disconnected feeling some distance learning students experience. Distance learning is about learning, not a classroom. The instructor is a facilitator more than a teacher.  Learning is your responsibility and will be accomplished by working within the virtual environment created with the students in the course.

If you do not access ANGEL several times per week, then you are not participating in class. School policy indicates that any student who is absent from class ten percent of the time may be dropped from the class without warning. If you are having difficulties and are unable to keep up with class, please let me know. I will try to help you in any way I can. If the problems persist and you are unable to complete this course, I expect you to administratively withdraw from the class. The deadline for withdrawing from a class is just before the midpoint of the semester. It is not the instructor's responsibility to withdraw students from class. Students who fail to withdraw will receive zeroes for incomplete assignments and exams which will result in a grade of F for the course. Last date of attendance will be determined by the the last email, discussion posting or assignment submitted.

Withdrawal From A Course:

If you encounter any difficulties at all or if you are considering withdrawing from the course for any reason, please contact your instructor without delay. The instructor may have suggestions that will allow you to successfully complete the course.

Students may withdraw themselves from any course without academic penalty up until the deadline set by the college. Once the deadline for withdrawing has passed, the instructor will not withdraw a student. Students who do not submit their assignments on time and who do not officially withdraw from the course will receive a failing grade.

You must enroll as an Audit student at the time of registration to receive an audit grade. 

Disability Services:

Any student who has a disability and is in need of special services should contact Disability Support Services (Room S-002, Phone 407-328-2109) by the second week of class.

PBL (Phi Beta Lambda)

Students enrolled in SCC’s computer courses are encouraged to participate in the local chapter of the national student organization Phi Beta Lambda. SCC’s chapter has a history of success in state and national competitions, as well as service to our community. For further information, contact Sherry Jenkins in the Office Management Technology Department or visit the PBL Web site at http://www.scc-fl.edu/career.programs/ceo/office/pbl/default.htm

The Microsoft Certified Application Specialist Program is explained in detail in Appendix D of the Textbook. This certification provides a valuable industry credential or proof that you have the Office application skills required by employers. Our textbook is a Microsoft-approved textbook that covers the required objectives for the various exams. The Web page http://www.scsite.com/off2007/cert includes links to general information on certification, choosing an application for certification, preparing for, taking and passing the certification exam.

Emergency Conditions:

To verify that the college is open and classes are being held, please call: 407-328-2290 or 407-328-4722. The Seminole Community College website features updated announcement at http://www.scc-fl.edu.

To Get Started:  

Before the term starts, it is recommended that you do the following:

1. Review the syllabus (above) and Schedule (see link at top of this page). Ninety-five percent of your questions are answered in the syllabus.

2. Purchase the textbook bundle and review the table of contents so that you can see the depth of the work and assignment material.  Reviewing the syllabus, class schedule, and the textbook will give you an idea of what will be expected of you in the course. To be successful, plan on spending approximately 4 - 6 hours per week on this course each week.

3. Have Windows or Vista and Excel 2007 loaded on your computer and ready to go THE FIRST WEEK OF CLASS.  There is no slack time and you must have everything in place.  If you experience technical difficulties, you need to come to one of SCC's labs to do your assignments and exams.

4. Once the semester begins, login to ANGEL. Click on the Welcome/Orientation icon in the Content area for details on starting your course work.

   You will not be able to enter the course in ANGEL until the first week of the term.  If you register during the Add/Drop period, there will be a slight delay getting your login and password entered in ANGEL.

   Refer to the Using ANGEL @ SCC at  http://www.scc-fl.edu/dl/angel/  for more information on logging into ANGEL or visit the DL web site. You will need to have your ANGEL Login ID and Password ready to log in to ANGEL.

   The URL for ANGEL at SCC is: http://ecampus.scc-fl.edu/angel or click on the link at the top of this page.

   If you have any difficulty logging into ANGEL, please fill out the online problem form available at:  http://www.scc-fl.edu/dl/students/problem-form.php or call the DL office at (407) 328-2424.

If you have any problems, feel free to e-mail your instructor at orre@scc-fl.edu. Be sure to mention the course number in the Subject line. (Once you have logged into ANGEL, do not use the SCC e-mail address. Please use the e-mail within ANGEL.) I look forward to working with you this semester!