Instructor

Patty Ralph

Phone

Office Phone: 269-965-3931, Ext. 2265

Office Hours:

By appointment.

It is best to contact me via the course discussion board or email.  I will respond to email within two working days.  If you use Excel HELP in your subject line, I will give your e-mail top priority.

Course Prerequisites

 Before enrolling in this course, the student should be familiar with basic touch-typing fundamentals and have some experience working in a windows environment with a mouse. You will need access to a computer with Office 2007 and an Internet Browser.

Textbook

See http://bookstore.kellogg.edu.  Note: Textbook information is generally not available until a few weeks before the semester begins.

Online Course Features and Requirements

Number of tests:  2 of which 2 must be proctored.    

Required on campus sessions:  0

Special labs or practicum:  0

Number of assignments:  Seven assignments which consist of 3-4 problems.

Estimated time per week:  2-3 hours

Scheduled activities or self paced: self paced

Technical Requirements:  Please see http://www.kellogg.edu/is/coursetec/bbreqs.html for information on connecting to Blackboard from your home computer.

Course Site:

http://bb.kellogg.edu/

Description

 This course introduces students to the basic features of Excel and presents introductory information about the Microsoft Office Specialist certification exam program.  Major topics will include:  creating a worksheet and embedded chart; formulas, functions, formatting, and web queries:  what-if analysis, charting, and working with large worksheets; creating static and dynamic web pages using Excel; and using Microsoft's Help system.

Objectives

•  Describe the Excel worksheet window
• Start, Create, Edit, Print and Save a worksheet
• Select, copy or move a cell or range of cells
• Format a worksheet
• Use the AutoSum button to sum a range of cells
• Create a simple chart
• Use the Excel Help System

• Use the Ask a Question box
• Use the F1 key to get Help
• Use the Help command on the Help Menu
• Use the Help button on the Standard Toolbar

• Identify and enter formulas using the keyboard and the Point mode
• Identify the arithmetic operators +, -, *, /, %, and ^ and their order of operations
• Apply the basic functions of SUM, MIN, MAX, and AVERAGE
• Determine a percentage
• Verify a formula
• Format numeric cells
• Change the alignment and width of a column and height of a row
• Preview and format a printed copy of the worksheet
• Use a Web query to get real-time data from a Web site and send e-mail from Excel

• Understand what Microsoft Office Specialist Certification is
• Know the benefits of becoming Microsoft Certified
• Know where to find the Core Exam Skills

• Use the formatting capabilities to create an attractive report title for a worksheet
• Work with segments of the worksheet
• Use the NOW and the IF functions
• Use and copy absolute cell references in a formula
• Display and dock toolbars
• Create and format 3-D Pie chart on separate sheet
• Rearrange sheets in a workbook
• Use Excel to answer what-if questions
• Use the Goal Seek command to analyze worksheet data

• Preview a Workbook as a Web Page
• Save a Workbook as a Static Web Page to a New Folder
• View a Web Page Using Your Browser
• Save an Excel Chart as a Dynamic Web Page
• View Your Dynamic Web Page Using Your Browser

Grading

Grading Scale

Disclaimer

Information contained in this syllabus was, to the best knowledge of the instructor, considered correct and complete when distributed for use at the beginning of the semester. However, this syllabus should not be considered a contract between Kellogg Community College and any student, nor between any student and the instructor. The instructor reserves the right, acting within the policies and procedures of Kellogg Community College, to make changes in course content or instructional techniques without notice or obligation.

Computer Access at KCC

It is assumed that students enrolled in this course have at their disposal appropriate equipment and software to complete the course work and communicate with other students.  If there are problems with your equipment and/or software, it is possible to come the KCC's Campus and use the open computer lab in the Learning Resource Center.  See KCC's web site for campus maps and lab times. 

Online Materials Submission

Students will be expected to use e-mail attachments and the blackboard site for this class to submit materials. 

ADA Statement

Kellogg Community College does not discriminate in the admission or treatment of students on the basis of disability.  KCC is committed to compliance with the American Disabilities Act and Section 504 of the Rehabilitation Act.