Northeastern State University

College of Business and Technology

Department of IS & Technology

Tahlequah, Oklahoma 74464

INSTRUCTOR:

Debbie Stansell. Office: BT 221H.

Office Hours: 8:00-9:00 & 10:00-11:00 a.m. MWF, 8:30-9:30 a.m. TTH, and by appointment.

Telephone: 918-444-2919.

FAX: 918-458-2337

E-mail: stansell@nsuok.edu  

COURSE TITLE AND NUMBER: CLASS DAYS & TIME:

MIS 3083: Spreadsheet Analysis 2:00 p.m. MW & 9:30 a.m. TTH

PREREQUISITES:

MIS 1003, MIS 1133, or equivalent, or by consent of instructor.

CATALOG DESCRIPTION OF COURSE:

A study of spreadsheet features, concepts, procedures, and integration capabilities with other application programs. Skill development of basic and advanced functions of spreadsheet software will be achieved through hands-on exercises and case studies. Problem solving techniques and decision support will be explored and utilized. Prerequisite: MIS 1003, MIS 1133, or equivalent, or by consent of instructor.

COURSE PURPOSE:

This course is designed to provide you with the ability to use computers readily and comfortably in common business environments. The spreadsheet applications will allow you to manipulate numeric data to produce information in a clear and timely manner. You will learn to transform generic data into information specific job practices. This course provides practical exposure to the basic and advanced spreadsheet tools necessary to accomplish this transformation. Also included in this course are exercises designed to help your understanding of how databases, spreadsheets, and word processors are related and used together.  

EXPECTED COURSE OUTCOMES:

This course is designed to give the student fundamental and advanced hands-on experience with electronic spreadsheets. Students learn the process of sharing data between applications and also tools to develop fully integrated applications. By completing this course the student will be able to:  

1. Demonstrate competence in the development and use of spreadsheets through case-oriented, actual problem solving activities.

2. Apply the practice and principles of spreadsheets to modern management strategies within large and small corporation case studies.  

3. Identify the various types of spreadsheet applications and identify how to integrate them into decision-making strategies.  

4. Demonstrate an understanding of managing workbooks, automating tasks, using and analyzing list data, enhancing charts and worksheets, and working with Excel in job oriented tasks.  

5. Create and record new macros and run macros.  

6. Assign data validation, range names, and protection to cells in a worksheet.  

7. Demonstrate a working knowledge of "what if" analysis, Pivot tables, and the solver tool.  

8. Exchange Excel data with other programs, control worksheet properties and calculations, and program with Excel.

INSTRUCTIONAL MATERIALS:(Required Textbook & Materials)

Parsons, June Jamrich. "Microsoft Excel 2003." Course Technology: Thompson Learning, 2006, ISBN 0619268158. Four 3.5 high density formatted diskettes (1.44 MB) or one CD-RW or a flash drive. Obtain NSU computer account; call EXCELS 458-0888 to find out your USERID and PASSWORD.

ACADEMIC DISHONESTY:

One of the major goals of this course is to allow you to become proficient with spreadsheet applications. You cannot become proficient if you copy someone else's work. Academic Dishonesty includes (among other things) copying another individual's work (or allowing someone to copy your work), or plagiarizing someone else's work as your own. If any type of academic dishonesty is detected (including any violations of the list below) students will be subject to disciplinary action including reduction of a grade(s), expulsion from the class, or expulsion from the university as outlined in the Northeastern State University Catalog.   

Plagiarism:

"Copying a sentence, or a significant part of a sentence that has been written by someone other than the person submitting the paper, and then neglecting to indicate through the use of quotation marks or blocking that the material has been copied; or copying from another writer in such a way as to change one or two words in the sentence, or rearranging the order of the wording, or paraphrasing, or summarizing information and then neglecting to furnish documentation; or any failure to cite sources when appropriate." [Source: http://www.bcc.cc.nc.us/honesty.html] 

Written Evaluations (Exams and quizzes)

· Written evaluations are always closed book/closed notes.

· Everything must be off the desk.

· Calculators are not allowed.

· For lab-based classes, all applications on the computer must be minimized or closed; using Microsoft Help features is not permitted.

· Talking or giving assistance to someone else during a written evaluation is considered cheating.

· Using cheat sheets (or programmed information) is considered cheating.

· The written exams are property of the instructor. Leaving the classroom with a written exam or photocopying any portion of a written exam will result in a grade of 0% on the exam.

All other work 

All other work falls under the Individual Work category below unless (1) the assignment clearly states that it is a Group Project and (2) the instructor has divided the class into groups.   

Group Projects

Special instructions will be provided.   

Individual Work 

· You may use the textbook and any notes.

· It is acceptable to give or receive help. Watching someone else do your work is not considered help.

· Occasionally when doing IN-CLASS computer work, there may not exist enough working machines in the lab for every student to work individually. In these rare cases students may be asked to work together. This is a temporary situation that ends when that class is over.

· When doing OUT-OF-CLASS computer work, it is your responsibility to find a free machine. The argument that only one machine was available will not be accepted as a justification for two or more people working together on the same computer.

· If you need help, the instructor will also be glad to assist you during posted office hours.

· Any and all materials turned in for credit should be the result of your own individual effort. 

Most of the class time will be used to explain new material and to practice in the computer labs. Students are encouraged to ask questions at any time. Students will be responsible for all topics covered in the textbook, handouts, and assigned URLs whether or not they are covered in the lectures.   

All assignments submitted for evaluation are to be prepared using appropriate software applications. All work should be spell checked, printed on good quality paper and submitted in 8.5 x 11 inch form with one staple in the upper left-hand corner. Handwritten work is unacceptable and will receive a grade of zero. When taking the written quizzes and exams you may write in any color but RED. 

INSTRUCTIONAL PROCEDURES:

The expected course outcomes will be realized through a variety of instructional strategies to complement students' life experiences. Those strategies include, but are not limited to, the following: self-paced, hands-on exercises, case study tutorials, lecture, and individual problem solving techniques.

Spreadsheet Analysis

1) Level 1: Creating and Editing Excel Worksheets (Weeks 1-5)

a) Downloading files from the Internet

b) Using Excel to manage data

c) Working with formulas and functions

d) Developing a professional-looking worksheet

e) Working with charts and graphics

Exam 1 (Tutorials 1-4)

2) Level II: Applying specific areas of Excel (Weeks 6-10)

a) Working with Excel lists

b) Working with multiple worksheets and workbooks

c) Working with Excel’s editing and web tools  

Exam 2 (Tutorials 5-7)

3) Level III: Applying specific areas of Excel, Continued (Weeks 11-15)

a) Developing an Excel Application

b) Data tables and scenario management

c) Using solver for complex problems  

Final Examination (Tutorials 8-10)

STUDENT PERFORMANCE ACTIVITIES:(Attendance/Punctuality)

Consistent and punctual attendance is both expected and required for your successful completion of the course. Absences will be evaluated on a case-by-case basis. Students will be expected to make up any work missed as a result of absence, whether or not the absence was justified. Unannounced Pop Quizzes may not be made up. Five (5) absences will reduce the final grade for the course by one letter grade.

ASSIGNMENT DUE DATES:

Assignments are due at the beginning of the class period on the date indicated when the assignment is given. After the assignment due date, work will be accepted up to one week late, with penalty. Assignments turned in up to 1-week late will receive no more than 50% credit. If assignments are not turned in at the beginning of the class period on the due date, they are marked as late. If you need to check your work, you need to do so before the class starts during posted office hours. Assignments may not be turned in more than one week late. Reading assignments and chapter tutorial work are considered preparation for the lecture period. The student is responsible for all material assigned even if not discussed in class. Quizzes over assignments may be given without prior announcement.

STUDENT EVALUATION:

Student evaluation is based on performance on tests and assignments. Test and assignments will be based on the material presented in the textbooks, material discussed in class and on skills developed. The division of the total grade is as follows:  

· Two performance exams, plus a final performance exam, 60% of final grade.

· Daily performance assignments, 40% of final grade.

 The exams will be production applications done on the computer. All students are expected to be present on exam day. The instructor makes decisions on make-ups at her discretion. The student is responsible for any assignments made or material covered when absent. The student must catch up outside the classroom setting, as time does not permit re-teaching of a topic due to absence.  

1. Performance on examinations and subsequent cumulative course averages will be based upon standard definitive grade values as indicated below:  

90-100 = A 60-69 = D

80-89 = B Below 60 = F

70-79 = C  

2. The final examination will be administered at 1:00 p.m., Monday, April 30, 2007 for MW class and 9:00 a.m., Thursday, May 3, 2007 for TTH class.

3. Students are advised that the last date during the semester when they may drop a course with an automatic "W" will be Friday, April 27, 2007. The grade of "W" can be assigned in classes dropped between April 7 and April 27 only if the student has a passing grade at the time the class is dropped. An "F" will be assigned if you stop attending and have not turned in assignments or have not taken scheduled exams prior to the drop date.  

4. Students wishing to visit with the professor about their standing in the class may visit her in her office, during posted office hours, which is located in the Business and Technology Building, Room BT 221H. Office hours indicated above are also posted adjacent to the door.

GRADE APPEALS:

A student may petition a grade change by using the Grade Appeals Process if satisfactory resolution cannot be achieved after consultation with the instructor and/or Dean. The Grade Appeals Process must be formally initiated with a written appeal to the Dean within four months following awarding of the original grade. Please contact the dean of the college in which the grade was given for a copy of the grade appeals process.  

ADA COMPLIANCE:

If any member of the class feels that he/she has a disability and needs special accommodations, please advise the instructor of such disability and the desired accommodations at the first class attended.

INCLEMENT WEATHER / DISASTER POLICY:

The following are basic premises for the inclement weather policy at Northeastern State University:  

1. Classes are expected to be held if at all possible.

2. It is the student's responsibility to receive the information when weather is questionable.

3. Neither students nor faculty are expected to risk life or limb.

4. Faculty members are obligated to hold classes if the University is not closed, unless the faculty member is unable to get to campus.  

Policy: During times of inclement weather, decisions concerning day classes will be made by 6:00 a.m. in order for the media to be notified and for students to receive the announcement before they leave home. Decisions concerning night classes will be made by 3:00 p.m.  

The following media will be notified regarding closing of the campus:  

Radio Stations: Television Stations:

KRMG 740 AM Tulsa KJRH Channel 2 Tulsa

KAYI 107 FM Tulsa KOTV Channel 6 Tulsa

KTLQ 1350 AM Tahlequah KTUL Channel 8 Tulsa

KEOK 102 FM Tahlequah KFSM Channel 5 Fort Smith

KBIX 1490 AM Muskogee Cable Channel 96 Tahlequah

KMMY 97 FM Muskogee

KVOO 1170 AM Tulsa

The automated attendant message on 918-456-5511 will be modified to include information concerning campus operations during inclement weather. 

COURSE SCHEDULE AND ASSIGNMENTS (SUBJECT TO REVISION)

WEEK	DATE	TOPIC	ASSIGNMENT	IN CLASS ACTIVITY
1	01/08	INTRO/ORIENT TUTORIAL 1	REVIEW & CASE 4	DOWNLOAD & CHAP WORK
2	01/15	TUTORIAL 2	REVIEW & ALL CASES	CHAP WORK
3	01/22	TUTORIAL 3	REVIEW & CASE 3	CHAP WORK
4	01/29	TUTORIAL 4	CASE 2 & 4	CHAP WORK
5	02/05	FINISH, REVIEW EXAM		EXAM
6	02/12	TUTORIAL 5	REVIEW, CASE 3 & 4	CHAP WORK
7	02/19	TUTORIAL 5 (CONT.)
8	02/26	TUTORIAL 6	REVIEW & CASE 2	CHAP WORK
9	03/05	TUTORIAL 7	REVIEW & CASE 1	CHAP WORK
10	03/12	TUTORIAL 7 (CONT)
11	03/17-03/25	SPRING BREAK
12	03/26	FINISH, REVIEW EXAM		EXAM
13	04/02	TUTORIAL 8	REVIEW & CASE 4	CHAP WORK
14	04/09	TUTORIAL 9	REVIEW & CASE 4	CHAP WORK
15	04/16	TUTORIAL 10	CASE 3 & 4	CHAP WORK
16	04/23	TUTORIAL 10 (CONT)		EXTRA CASES
17	04/30	FINALS		FINAL EXAM

THIS CLASS WILL BE CONDUCTED WITH BOTH LECTURE AND INDIVIDUAL PROBLEM SOLVING TECHNIQUES. I WILL HELP YOU WITH YOUR ASSIGNMENTS IN CLASS AS TIME PERMITS.