Personal tools
You are here: Home Academics Syllabi Spring 2009 Syllabi M&IS 24053 Spring 2009 Steinberg and Fay
Navigation
 

M&IS 24053 Spring 2009 Steinberg and Fay

M&IS 24053 Computer Applications  Spring 2009

 

Professors              Dr. Geoffrey Steinberg        Mr. Byron Fay II

Office Hours:           Tue/Thr 11-12:30              MW 3-5:15 pm & TR 8:15-8:30 pm

E-mail                  drgsteinberg@gmail.com        byronfay@gmail.com

                                                      672-1162

 

 

Course Theme

 

Solving information related problems using computers, networks, software and data.  

 

 

Course Objectives

 

The fundamental objective is for you to develop an appreciation for the contribution that computers and software can make to your life as a student and as a professional. It is expected that during this term you will develop competency in the operation of the hardware and software to which you are exposed. It is further expected that as you master the course material your confidence in your ability will increase. A secondary objective is for this to be an enjoyable and fun learning experience.   

 

 

Textbook and Other Materials

 

The course's text book is Information Technology, Steinberg, Geoffrey, Kendall-Hunt. 2008. Use the course weekly schedule (at end of syllabus) as a guide so that you read the appropriate chapters before that material is covered in class. You should read the material before coming to class so that you are ready to participate in the class discussion.

 

Class Slide Presentations

 

Copies of the instructor's classroom slide presentations are found in a workbook included with the textbook. You will find these copies very handy when you take class notes. The workbook has exact images of many of the slides used by the instructor. Take your notes directly on the copies. It will make note taking easier and more accurate. You will find it easier to study for quizzes too.

 

Jump Drive

 

You should use the jump drive which is packaged with the book. The drive has sufficient space to complete your assignments and can also be used for your other course work.

 

Handouts

 

You will find additional course material in Pamela (see below).

 

 

Pamela

 

Most of your course activities are interactive and involve using the Pamela on-line application.

 

  • Quizzes and homework are administered and graded instantly by Pamela.
  • Each regular assignment must be completed by the due date.
  • The grade on record at the due date is your grade.
  • Pamela’s timeline shows the due dates for each assignment.
  • Pamela is available 24/7.
  • Each time anything is graded a fresh copy of your grade status report will be put on the Internet for you to access. See "Status Report" on the Pamela main page for access to your personal report.

 

Follow these steps to log on to Pamela: Start a web browser: Go to this web address: http://solarsystemssoftware.com/

 

 

Homework

 

There are 12 regular assignments. To view specifics about assignments use your ID and password to log on to Pamela and view the Timeline.

 

  • You may submit any regular assignment three times until the due date.
  • The grade recorded is what you earn on your last attempt (which may or may not be your highest score).
  • If your score goes lower when you resubmit an assignment then the lower score is what counts toward your grade.
  • You will complete most of your regular assignments using a storage device such as the one included with the text.
  • Each homework is worth 1 point (1% of your course grade).

 

 

Quizzes

 

  • There are 5 objective quizzes (multiple choice, true-false, fill in the blank).
  • Each is worth 16 points (16% of your course grade).
  • Each quiz is administered in the College of Business Lab during a quiz period (one week -- five weekdays only).
  • Quizzes are not curved.
  • Each quiz contains material covered in class during the three weeks prior to the beginning of the quiz period.
  • Textbook reading assignments are also material for the quizzes.
  • There is no final exam. The last quiz is also non-comprehensive and is taken during finals week.
  • Quizzes are open notes and you may use other software while taking a quiz.
  • You may submit a quiz only one time.
  • You must make a reservation on Pamela to take a quiz. On Pamela you may make a reservation for a quiz start time (in the College of Business Lab) two days before the quiz's period begins. Check “Reservations” on the timeline.
  • You must bring a picture ID (KSU, driver license, etc.) to the lab to begin a quiz.

 

Prerequisites

 

  • You may not begin any quiz until you demonstrate your understanding of the syllabus by completing the Syllabus Contract.
  • Each quiz has other prerequisites as well and it is your responsibility to be aware of the schedule.
  • You may attempt the exercises as often as you wish until you accomplish the required grade of 100 on each prerequisite.
  • To learn what the specific prerequisites are click “Prerequisites” on the timeline.

 

Taking a Quiz

 

  • Bring your student ID to the College of Business Computer Lab (2nd floor) during the quiz period.
  • No quiz may be started less than X minutes before a proctor is due to leave the lab Where X is the length of the quiz - see the study guide.
  • Each quiz is of different time length - it is your responsibility to check this.
  • Make sure it is now the time of your quiz reservation.
  • READ EVERYTHING IN THE INSTRUCTIONS.
  • Open any programs you will need BEFORE you begin the quiz.
  • Read ALL dialog boxes.
  • Request that a proctor (look around the lab for one) check your id (name and picture). You may not begin a quiz without proper identification.

 

Viewing Results

 

Once a quiz period has ended (midnight of the last day of a quiz period) you may view your quiz (all questions and answers) for up to seven days by locating the quiz in your status report.

 

Instructor Review of Your Quiz

 

  • You may request that your instructor review specific questions from your quiz for up to seven days after the end of the quiz period.
  • Before contacting your instructor note the specific question numbers.
  • Quizzes will not be examined after the seven days have elapsed.

 

Study Guides and Practice Tools

 

  • To view a study guide:
    • Log on to Pamela.
    • Click the quiz in the timeline.
    • Click “View Instructions”.

 

  • Practice quizzes are available for each quiz. Click the practice quiz name (on the timeline) to begin.

 

 

Pop Quizzes

 

There will be eight points (8% of your course grade) based on in-class unannounced pop quizzes. If you are absent on a pop quiz day you will receive a zero on that pop quiz unless you have an excused absence.

 

 

Syllabus Contract

 

This syllabus is a contract between you and the instructor. Your responsibilities are described in this document. Before you are permitted to attempt any of the the five course quizzes you must demonstrate that you understand the contract (syllabus) by earning a perfect score (100%) on a syllabus survey. You will find the Syllabus Contract Survey on the timeline.

 

  • You are permitted to attempt the Syllabus Contract Survey as often as you like until you reach 100%.
  • You may attempt the Syllabus Contract Survey from any Internet connected computer using Internet Explorer.
  • It is strongly suggested that you print this syllabus and use it while completing the Syllabus Contract Survey.
  • You must score 100% on the Syllabus Contract Survey before attempting any of the five course quizzes.

 

 

Extra Credit

 

You may earn up to 5 extra-credit points during the course this way:

 

Pop Questions -- 4 points possible:

 

  • At various times when logged on to Pamela you will be given the opportunity to answer questions about course content.
  • Each correct answer will result in an award of 0.10 credit points.
  • During the semester you will receive up to 40 extra credit pop questions for a possible 4 points.
  • The pop credit questions are all objective (multiple choice, true-false, fill in the blank).
  • Points earned from correctly answering pop credit questions are available for Gift Catalog purchases (see below).
  • There may be additional extra credit opportunities available to those who attend class.

 

Extra Credit Assignments -- 1 point possible:

 

  • During the course three extra credit homework assignments are available.
  • Completion of all assignments is worth a maximum of 1.0 extra credit points.
  • These points are not used for Gift Catalog purchases.

 

 

Gift Catalog

 

You may purchase gifts from the Gift catalog by using pop credit points that you earned. Click "Gift Catalog" on the timeline. Gifts available include:

 

  • A due date extension
  • An additional homework submission
  • Erase a grade and start over

 

 

Lateness

 

You may complete overdue assignments late but you will be assessed a late fee. This is different from the Gift Catalog because with rewind you do not spend pop credit to begin a late course requirement but you are assessed a penalty for lateness. To begin any assignment late click it on the timeline.

 

 

Early Bird Special

 

Get rewards for completing assignments early. Look for “Early Bird Special” on the timeline for details.

 

 

How Your Grade is Computed

 

  • Your semester grade is the weighted average of the 5 quizzes (16 points each) + 12 homework assignments (1 point each) + 8 points of pop quizzes.
  • Each quiz and homework is to be completed on time by the due date. Penalties apply for lateness.
  • Up to 5 points of extra credit may be added to your quiz and homework average.
  • Nothing is curved: not homework assignments, not quizzes and not the semester final grades.
  • Only full letter grades are use. +/- grades are not used.
  • Grades are rounded, so 89.5 becomes 90 which is an A.

 

This grading scale is used:

 

90+

A

80-89

B

70-79

C

60-69

D

0-59

F

 

 

 

Tutors and Supplemental Instruction

 

Tutors are available to help you during certain hours each week. They can be found on the 4th floor of the College of Business near Dr. Steinberg's office. Hours will be announced.

 

A Supplemental Instruction (SI) component is provided for all students who want to improve their understanding of the material taught in this course.  SI sessions are led by a student who has already mastered the course material and has been trained to facilitate group sessions where students can meet to compare class notes, review and discuss important concepts, develop strategies for studying, and prepare for exams.  Attendance at SI sessions is voluntary and students may attend as many times as they choose.  SI sessions normally begin the second week of classes and continue throughout the semester.  A session schedule will be announced in class and an updated schedule will also be posted on the SI website at: www.kent.edu/si.

 

 

 

Rules

 

In order to be fair to all students the following rules are enforced:

 

Excused Absence and Lateness

 

The following are the Kent State accepted excuses for absence and late homework submission or permission to take a quiz late.

 

  • sickness with medical note
  • athletic event - with coach's note
  • religious observation
  • military responsibility with documentation
  • death in family with documentation

 

No other excuses for lateness are accepted. If you miss homework or quiz due date then you may purchase an extension from the gift catalog or use the rewind option if you wish to complete that assignment. Here are some excuses that are invalid and will be ignored:

 

  • your Mom will call me to let me know why
  • your alarm didn't go off
  • your kids were sick
  • your parents needed your help
  • you had to work
  • you forgot the due date
  • you check your email, but you don't check Pamela
  • you have to get a good grade in here
  • your computer died
  • you went to a movie
  • you cannot access Pamela
  • your diskette will not work
  • there was no lab assistant to proctor
  • the lab was in use by a class, etc.
  • your car quit
  • you had an accident
  • you had to watch a television show
  • it is raining
  • you are lazy
  • you did not want to do the assignment
  • any new excuse we haven't heard which you come up with as your contribution to next semester's syllabus

 

Attendance is not mandatory but:

 

  • You are responsible for all material presented.
  • Do not ask for special consideration claiming that you miss material because you were not in class.
  • If you miss class you are not eligible for special in-class awards (unless the absence is covered by one of the Kent State accepted excuses for absence).
  • Do not ask the instructor for a re-cap of a missed class (unless you have an excused absence).
  • Attendance is recorded - the instructor distributed attendance tokens which you submit to Pamela. Sufficient attendance (75%) is required for e-mail assistance by the instructor.

 

Classroom rules:

 

  • Respect the other students in class. This means never ridicule anyone for asking a question. Laughing at or ridiculing another student is grounds for dismissal from this course with a grade of F.
  • Use of a cell phone or pager during class is grounds for removal from the class.
  • If you arrive to class late:
    • You may be denied permission to participate in In-Class Awards
    • You may be required to sit in the front row.
    • The instructor may deny entrance to anyone more than 15 minutes late.

 

In-Class Special Awards

 

  • In-class extra credit awards are given to students directly by the instructor.
  • These awards are known as tokens.
  • Only students present in class are eligible for these awards.
  • Any student claiming an award obtained from other than the instructor is dishonest and will be dealt with according to Kent State University regulations concerning student conduct.
  • Possession of a token not directly received from the instructor is grounds for failure in this course.

 

Cheating

 

Cheating is grounds for immediate dismissal and automatic failure from this course with no opportunity to complete any further assignments. Cheating includes, but is not limited to:

 

  • Submitting work (homework, pre-requisites, quizzes) that is not yours.
  • Providing answers to (homework, pre-requisites, quizzes) to another student.
  • Possession of a token not personally received from the instructor.
  • Giving a token to another student.
  • Possession of a copy of quiz questions in any form including printed or electronic versions of a quiz.
  • Illegally copying software.
  • Using electronic communication with another person during a quiz.

 

e-mail

 

You may communicate with your instructor using e-mail. There are some rules, however, that you must observe to use e-mail effectively. Little tolerance is granted for email messages that violate these guidelines:

 

  • Use the e-mail address shown at the top of this syllabus. No other e-mail addresses are used by the instructor.
  • Make sure that your spelling and grammar are correct.
  • Get to the point. Do not be long-winded. No jumbled verbiage.
  • Be organized. Be clear.
  • Be honest.
  • Use proper English - no slang.
  • DO NOT TYPE IN ALL CAPS!
  • Be respectful.
  • Say who you are.
  • Never write something like “respond ASAP.”
  • Allow 24 hours for a reply.

 

The instructor will not answer e-mail:

 

  • About a homework assignment on the due date for that particular assignment.
  • About a pre-requisite on the day that the dependent assignment is due.
  • If your attendance is less than 75% based on recorded tokens.
  • On weekends or evenings.
  • Written in a rude or demanding way.

 

 

Other Information

 

Students with Disabilities

 

In accordance with University policy, if you have a documented disability and require accommodations to obtain equal access in this course, please contact the instructor at the beginning of the semester or when given an assignment for which accommodation is required. Students with disabilities must verify their eligibility through the Office of Student Disability Services (SDS) in the Michael Schwartz Services Center (672-2972).

 

Thinking about a Major or Minor in Information Systems?

 

Enrollment in the initial courses (24060 - Systems Analysis and 24070 Principles of System Development) requires permission. Ask your instructor for information.

 

 

Daily Class Schedule and Reading Assignments

 

  • The daily schedule indicates the topics covered during each class session.
  • You are expected to complete the reading assignments prior to each class meeting.
  • Reading assignment pages shown below in ().
  • The Quiz column indicates what quiz covers the material shown to the left.
  • Quizzes 1-4 are MTWRF of the following week (example: Quiz 1 is MTWRF of week 4).
  • NOTE: Quiz 5 is different! It begins Friday (not a Monday) and is also available MTWR of the next week (finals week). It is not available Friday of finals week.

 

Week

Tuesday

Thursday

Quiz

1

1/20 Syllabus

     Introduction (1-9)

1/22 Information Systems

1

2

1/27 Windows (255-287)

1/29 Windows

1

3

2/3 Hardware & Software (3-51)

2/5 Hardware & Software

1

4

2/10 Data & Information (181-197)

2/12 Data & Information

     SQL Queries (535-543)

2

5

2/17 SQL Queries

2/19 Excel (377-414):

  • Functions & Formulas
  • Formatting
  • Analyzing Data
  • Importing Data

2

6

2/24 Excel

2/26 Excel

2

7

3/3 Excel (433-450):

  • Copy/Move Cells
  • Cell Addressing
  • Logic

3/5 Excel

3

8

3/10 Excel

3/12 Impact of Computing on Society

3

9

3/17 Internet & Communications (71-118)

3/19 Internet & Communications

3

10

3/31 Excel (425-430; 450-460):

  • Merging Tables
  • Linking Sheets
  • Charts & Presentation
  • Statistics

4/2 Excel

4

11

4/7 Excel

4/9 SQL Joins(543-544)

4

12

4/14 SQL Joins

4/16 Database Design (514-518)

4

13

4/21 Access  (507-513)

  • Introduction
  • Queries

4/23 XML in Excel and Access (609-613)

5

14

4/28 Access Complex Queries (519-523)

4/30 XHTML (555-576)

5

15

5/5  Creating a Database (526-530)

  • Tables
  • Table Relationships

5/7 Security & Privacy (139-174)

5

 

 

 

Document Actions