Syllabus – CIS200

Autumn ‘08 Syllabus ̵= 1; CSE 200 TR 9:30-10:18pm

Instructor: Debby Gross

Contact Information

Office: Dreese Labs 489 Phone: 614 292-= 7946

Email address: gross.142@osu.edu

Carmen link: = http://carmen.osu.edu

Instructor Website: www.cse.ohio-state.edu/~gros= s

Office Hours:=

Monday 9:30-11:00am, Tuesday & Thursda= y 11:30-12:30am, Wednesday 10:30-12:30, or by appointment. <= o:p>

Please note the following exceptions during Au’08: No office ho= urs on Tues 9/30, Wed 10/1, Tues 10/13, Wed 10/14, Tues 10/21, Wed 10/22.

Required Texts: <= /u>

Online text – with companion printed materials. Order from li= nk on Carmen under Content:Course Materials (http://tosucse200.ichaptersbuy.com - bundle ISBN 1435429265)
Course Notes – available from UniPri= nt at the Tuttle Garage (required for all lectures and labs)

Course Objectives:

The course objective is to familiarize students with the breadth of business software applications

and to provide a working knowledge of spreadsheets and databases. We emphasize using these tools to solve problems. It is our goal that students will f= eel comfortable enough on computers that they will be able to open up an unfami= liar business application and begin learning it on their own, applying these too= ls to solve problems efficiently and effectively. The specific objectives are as follows:

· = Understanding computer basics - hardware, opera= ting systems & communications (1 lecture)

· = Understanding the Ethical principles regarding = the use of technology (throughout)

· = Effectively use spreadsheets to solve problems = (5½ weeks)=

o&nb= sp; Designing spreadsheets so they can be efficiently written and updated including use of relative/absolute cell addressing, & multiple workshee= ts in a workbook.

o&nb= sp; Using functions and understanding syntax/algorithms including SUM, COUNT, MIN, MAX, AVERAGE, COUNTIF, SUMIF, ROUND, LARGE, SMALL, = RANK

o&nb= sp; Using Relational operators and Boolean Logical functions (AND, OR, N= OT, IF functions)

o&nb= sp; Using reference functions – (VLOOKUP, HLOOKUP)

o&nb= sp; Using financial functions (PV, FV, NPER, RATE, PMT)

o&nb= sp; Selecting and using appropriate charts to display data

o&nb= sp; Using spreadsheet data features for filtering, sorting

o&nb= sp; Using Pivot Tables

· = Effectively use presentation graphics software = (1 lecture)

o&nb= sp; Creating slides

o&nb= sp; Using the Master Layout View

o&nb= sp; Creating speaker notes and handouts

o&nb= sp; Using animation and transition effects in presentation

o&nb= sp; Using the MS Office drawing tools

o&nb= sp; Using the MS Office object linking and embedding tools

· = Effectively use database management software to solve problems (3 weeks)

o&nb= sp; Understand the concepts of relational database management system (DB= MS) – primary key, foreign key etc.

o&nb= sp; Be able to design simple tables – fields & field propertie= s

o&nb= sp; Be able to relate tables - foreign keys, referential data integrity rules.

o&nb= sp; Effectively use the query tool to find/organize information including sorting, filtering on multiple criteria, grouping and aggregating data, per= forming calculations. Using inner & outer joins to extract data from multiple tables/existing queries objects. Solving problems requiring data from table= s with many-to-many relationships.

· = Understanding how the Internet works and basic principals of Networking & Building your own Web page (1 lecture)

Grading Policy:

Lab Assignments (10)	20%	200 points
Pop quizzes (best 4 out of 5)	20%	200 points
Midterm	25%	250 points
Final Exam	35%	350 points

**The percentage breakdowns are used as a guide= for determining grades. Final grades are at the discretion of the lecturer.&nbs= p; You must pass the final exam and complete labs 5 & 9 in a satisfactory manner in order to pass the course.

Labs:

Labs c= ontain two parts – a Pre-lab and an In-lab assignment. The pre-lab assignments can be fou= nd in the lab section of your course notes. You may start on them at any time.&= nbsp; The pre-lab lab files are available on Carmen – clic= k on the Content menu and then the Pre-labs link. The Pre-lab assignment for a speci= fic week is due during that week’s closed lab session. When you arrive for your closed lab class, the TA will distribute your In-lab assignment. This will usually consist of one o= r more problems that apply the skills learned in lecture and during the Pre-lab. You will have only 1 hour 48 minutes to complete the in-lab assignment, so come prepared and make sure you have all= the materials (texts, notes etc) as indicated in the Pre-lab write-up.<= span style=3D'mso-spacerun:yes'> To receive credit the lab assignme= nt you must attend lab and submit your files by the end of the class period. When labs are submitted a date/time stamp is given. No credit wil= l be given for late labs. Labs 5 and 9 = must be submitted to pass the course, if you fail to do so – please contact your Lab Instructor.

Homework:

Homework will be assigned but will not be colle= cted. They are for your benefit to complete= . Answers will be provided online (In Carmen click on Content then link to ‘Practice Problems and Solutions= ’ – problem files and solution organized by topic.)

Pop Quizzes:

There will be a serie= s of 5 pop quizzes given during the quarter.&nb= sp; Approximate dates are listed on the syllabus. The dat= es of each pop quiz will be confirmed in the lecture before the quiz is to be given. Each quiz is worth 50 = points and the best 4 out of 5 quizzes will be counted for a maximum point score of 200.

Exams:

Approximate dates of the midterm and final are listed on the syllabus schedule w= hich is attached. Any changes of exam dates will be announced in class – at least one week prio= r to the exam. Such changes will a= lso be posted on the Carmen site homepage under ‘Lecturer Announcements’.

Make-up Policy:

It is the policy of this course that no make-ups will be allowed for labs, quizzes or exams. It is your responsibility to know when assignments are due and when the exams will be given. The only exceptions for extraordinary circumstances are described below. Make-ups will not be g= iven to students who miss assignments due to “over sleeping” or “not knowing of the assignment”.

Extraordinary Circumstances:

At times there are extraordinary circumstances = that may require a make-up of an assignment or exam. The appropriate person will handle= these on a case by case basis. Contact your lecturer for all matters pertaining to exams and quizzes. Contact yo= ur lab instructor in all matters pertaining to labs.

·         Notification mus= t be made and confirmed prior to the assignment due date by e-mail, phone or in person. Leaving a voice mail, or e-mail is= not enough. You must have confirmation by the appropriate person to be consider= ed for a make-up.

·         In a case where a person is unable to notify the proper person (ex. documented medical emergency), notification must be made= as soon as possible. =

Fairness to Students:

We strive to treat students with dignity and fairness and to be particularly sensitive to the diversity that exists within the student body. Students with disabilities who request help will be given reasonable accommodation with the assistance of the University Office of Disability Services (292 - 3307)

Academic Misconduct:

In accordance with Faculty Rule 3335-31-02, all instances of alleged academic misconduct will be reported to the Department Chairperson and the Committee= on Academic Misconduct (COAM). A= lleged misconduct cases will be resolved via COAM’s hearing processes as described in the University’s Code of Student Conduct.   Instructors, lab consultants= and graders will not make an evaluation of the facts of the case, either towards guilt or innocence.

As defined in the University’s Code of Student Conduct, academic miscond= uct is any activity which tends to compromise the academic integrity of the institution or subvert the educational process. Students who violate the University’s policies regarding academic misconduct are stealing acad= emic credit and skewing the grading process against students who are honestly participating in the course. Their actions diminish the value of an academic degree when they falsely represent themselves as competent in a subject mat= ter in the workplace.

Acad= emic misconduct includes, but is not limited to, giving or receiving information= or assistance during an exam or submission of plagiarized work for academic requirements. It also includes changing graded material and turning it back= in to be re-graded for a higher score.

Whil= e we encourage students to learn from each other, each student’s submit= ted work must be entirely their own. We encourage high level discussions of assignments. However, specific discussion of a formula solution is not appropriate. = Examples of appropriate and inappropriate types of assistance are li= sted below:

Examples of appropriate assistance are as follows:

·      =    Students working together on non-graded examples similar to those of the assigned materials. Non-graded examples are provided b= oth in written and electronic format for use by students.

·      =    Studying in groups to learn problem solving techniques and function syntax using non-graded materials provided in the course text and notes.

·      =    Creating study guides for purposes of learning = the materials in preparation for exams and quizzes.

·      =    Getting assistance from a course staff member (Lecturers, TA’s, Lab Consultants). Staff members are trained to help students learn concepts so students can then successfully apply these conce= pts in the completion of their own assignments. Appropriate assistance from course= staff members may take either of the following forms:

o&nb= sp; A student asks for assistance for an un-attempt= ed problem or a problem they do not understand how to approach. The student should be shown how to= do a similar problem and/or directed to specific materials in the course text. Students and staff may also work t= hrough a high level strategy of how to go about solving the problem.

§   Appropriate: “You need to add all of the values that meet a specific criteria and the divide them by the number of items that meet this criteria”

§   Inappropriate: “Use the formula =3DSUMIF(B2:B10, TRUE)/COUNTIF(B2:B20, TRUE)”

o&nb= sp; A student asks for assistance with a mostly completed assignment. The sta= ff member may identify an error and provide appropriate assistance.

§ Appropriate: “The absolute referencing in the formula is incorrect, the price of widgets doesn’t change when copied down the column”

§ Inappropriate: “= Add a $ in front of the 2 so the answer is B$2*C3.”

Additional examples of inappropriate assis= tance are as follows:

·      =    Having another person complete any part of a gr= aded assignment and misrepresenting it as your own work or having another person take an exam or quiz for you.

·      =    Copying any portion of a graded assignment or e= xam, either written or electronic, even if this is later modified. This includes work/files from both current and past quarters, even if you are re-taking the course and it was = your own work. Files may only be c= opied from the course websites and/or directories as specifically directed in an assignment.

·      =    Giving or receiving an answer to a portion of a graded assignment including graded homework, labs, quizzes or exams.

·      =    Helping another student with their homework or = lab as they follow along from your completed or partially completed work.<= /o:p>

·      =    Working together on a graded assignment. High level discussions of problem strategies are allowed, but be advised that near duplicate assignments will= be considered suspect unless the assignment was restrictive enough to justify = such similarities in independent work.

If a student has any questions about what is or= is not permissible, he/she should read carefully the course syllabus and/or ask the course instructor for guidance. Ignorance of the course policies or University’s Code of Stude= nt Conduct is never an excuse for academic misconduct.

Detailed Syllabus Schedule:

The following page contains a detailed tentative schedule.   Exams, quizzes and assignmen= ts are subject to change. Major changes will be announced in class, and on the Car= men site. Additional copies of th= is syllabus and schedule may also be obtained on Carmen from the Content menu = and then by selecting Lecturer Materials.

Pop quizzes (best 4 out of 5)