OIT-181-milliken-fall2008

OIT 181 - Beginning Excel 2007

Fall 2008

Instructor:

Carol Milliken

Phone:

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

Office Hours:
Online:

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

Required: Shelly Cashman MicrosoftExcel 2007 Comprehensive ISBN:1428367179 You will also need one high-density, 3 1/2 inch formatted disk or USB Flash drive is preferred. The book may be ordered on line at http://www.coursedirect.com or through the Kellogg Community College bookstore at http://www.kellogg.edu.

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

Group interaction required: None

Scheduled activities or self paced: Self paced

Requirements:

Students must have access to the following:

Equipment: You will need a computer that is able to access and interact with the Web. For best results, a Pentium or PowerMac with a 56 Kbps or faster modem and 256 MB or more of RAM should be considered the minimal system.
Software: You will need one of the following Internet browsers: Microsoft Internet Explorer 6 or higher; Firefox; Mac users may use Safari or Firefox.
Internet connection: Home users need Internet access through an Internet Service Provider (ISP) that offers a reliable connection to the Internet.

Other requirements: Excel 2007

Course Site:

http://bb.kellogg.edu

Course 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.

Course Goal

Upon completion of this course the successful student will have (1) gained the skills necessary to start preparing for the Microsoft Office Specialist Core Excel 2007 Examination and (2) learned how the Excel 2007 skills acquired can be used in the business world.

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

100-A+	89-86-B+	79-76-C+	69-66-D+
99-94-A	85-83-B	75-73-C	65-63-D
93-90-A-	82-80-B-	72-70-C-	62-60-D-
			59--F

Grading For This Course

Homework-Class Assignments	60%
Final Exams-Theory and Application	40%

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 Submitting Materials 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.

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 Submitting Materials	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.