Office Administration

Microsoft Excel 2007

OST 2852C On Campus Syllabus

Fall 2009 - Section 12957

Meeting on Mon & Wed 11:00 am - 12:15 pm in Room J105
 

Course Description:

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.

Course Objectives:

• Design a spreadsheet with labels, values and formulas

• Create graphs

• Apply formatting to spreadsheets and graphs

• Perform business related analysis using built-in Excel functions

• Create, sort and subtotal a data list

• Create and edit macros

• Create hyperlinks and range names

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!)

If you would like to purchase the MS Office 2007 program for use on your personal computer, Microsoft Office is currently offering Microsoft Office Ultimate 2007 to students 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.

Before installing MS Office 2007 on your personal computer, review the checklist to ensure that your computer has all the requirements for running Microsoft Office 2007. 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.

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:

 

Module Activities	Points
Hands on Projects from Textbook: Tutorials & Cases	280
Multiple Choice / True False Quizzes	160
Technology News Activity	60
CaseGrader	200
Unit Exams	200
Total	900

 

 

Grading Scale:

The following scale will be used to determine your final grade:
A = 810 - 900, B = 720 - 809, C = 630 - 799, D = 540 - 629, F = 0 - 539

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 (chapter) and Case problem in textbook
• CaseGrader Project
• Multiple Choice / True False Question Quiz
• Technology News Activity

At the end of each unit, there will be a Unit Exam comprised of multiple choice and true/false questions.

Due Dates

Activities in each module should be completed by the due dates listed on the schedule. Completing your work on a regular basis will help ensure your success in this course!

Late Work

All assignments, except Unit exams, may be submitted up to 7 days late with a 10% penalty. No late work will be accepted after 7 days. No Unit exams may be taken late unless prior arrangements have been made with your instructor.

Extra Credit

Extra credit assignments assignments will be available at the end of the semester.

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 by your instructor in class. These assignments will be worth 30 points for Tutorials 1-4 and 40 points for Tutorials 5-8.

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.

Projects using CaseGrader

In each module, cases will be given using CaseGrader. The cases will be very similar to those created at the end of each Tutorial. Cases will be completed using the CaseGrader web site. The CaseGrader program will grade your work automatically. The program is very picky so check your work carefully before submitting. Each case will be worth 25 points.

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.

Technology News

These activities will be available in ANGEL. The activities will vary for each module. They will include fun assignments regarding new technology and additional Excel activities. These activities will be worth 5 – 10 points each.

Exams

The Unit Exams will consist of multiple choice and true false questions. Exams will be administered according to the dates on your Schedule.  The exams will be password protected. Passwords will be given in class. No Unit exam may be taken late unless prior arrangements are made with your instructor. Failure to take the exam by the assigned deadline will result in a grade of zero. Each Unit exam will be worth 100 points.

 

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:

Your attendance and participation in class is crucial to your success in this class. Be prepared to spend 4 - 6 hours per week to be successful in this course. School policy indicates that any student who is absent from class ten percent of the time may be dropped from the class without warning.

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.

For additional information on ADA compliance in ANGEL, go to http://www.angellearning.com/products/lms/accessibility.html

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.

The Microsoft Certified Application Specialist Program 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 Microsoft Office site provides  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 announcements.