MIS 24053 Summer 2011 Intersession Steinberg

Computer Applications – Intersession 2011

Dr. Geoffrey Steinberg

A418 College of Business

drgsteinberg@gmail.com

Objective

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 computer programs to which you are exposed. It is further expected that as you master the course material your confidence will increase.

Special Message

Read this syllabus carefully and understand the rules and requirements. Take the schedule seriously. Do not ask prior students about the course because it has been restructured.

Sources of Information

You have five main sources of information for this course:

·         Class lecture / discussion

·         The textbook and workbook that comes with it (bring both to class)

·         Slide presentations (online - take notes from these directly into your workbook)

·         Tutorials (online)

·         Me (email me with questions or visit me)

Tip:

This course is easy if you:

·         Stay up to date in reading (textbook and online tutorials)

·         Come to class

·         Record notes into the workbook

·         Do the work on time

If you do not do the above you will have a very difficult time and get a poor grade.

Textbook and Components

·         Textbook

The course's text book is Information Technology – 2nd Edition, Steinberg, Geoffrey, Kendall-Hunt, 978-0-7575-8720-7. Use the course 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.

The prerequisites (discussed later) relate to material from the textbook. The textbook is also a source of many of the questions found in quizzes and for homework assignments. Read the textbook according to the class schedule. You will have a hard time if you do not read the book.

·         Workbook

Copies of the instructor's classroom slide presentations are found in a workbook included with the textbook. Bring the workbook to class. You will find these copies very handy when you take class notes. The workbook has exact (but incomplete) images of most 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.  Many of the quiz questions are based on the illustrations in the workbook.

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

Do not use the same jump drive as another student. If you do, BONGOPOWER will assume you are cheating and you will not get a grade in the assignment you submitted.

Other Materials

·         Interactive Tutorials

The online system that you use, BONGOPOWER, provides many interactive tutorials.  Click “My Tutorials” on the menu for access. You will complete homework faster and do better on quizzes if you complete the tutorials.

The tutorials are divided into topic areas. As you read chapters and look at homework assignments (or prerequisites) look at the tutorial list and open those that relate to what you are doing at that time.

·         Microsoft Office

For this course you will use software including Microsoft Office (2007, 2008, or 2010). Office may be used on your computer if you have it or in the College of Business computer lab or other labs on campus.

If you do not have Office installed but would like it you can obtain a 60 day trial copy from www.microsoft.com for free. NOTE: many computers have Office without Access. You will need Access for this course.

You can purchase Office for a special price here: http://www.kent.edu/is/helpdesk/microsoft.cfm

·         SQL (database)

You will use an online interface to an SQL database. This will be provided for you by a link from BONGOPOWER.

·         Notepad

This is a Windows only program. If you have a Mac these assignments must be completed on a Windows computer.

Your Grade 

Your grade is the weighted average of and quizzes as follows:   

Ten homework @ 4% each                           40%                      

Four quizzes @15% each                               60%      

                                                                                100%                    

This grading scale is used:

                89.5+     A

                79.5+     B

                69.5+     C

                59.5+     D

                0+           F

BONGOPOWER

All of your course assignments (homeworks and quizzes) are interactive and involve using the BONGOPOWER online application. Your instructor will inform you about how to gain access to BONGOPOWER.

·         All assignments are administered and graded instantly by BONGOPOWER.

·         The grade on record at the due date is your grade.

·         BONGOPOWER is available 24/7.

·         Your course grade report is updated on BONGOPOWER each time a homework or quiz is graded.  Click “My Status”.

To Find Assignments

1.       Log on to BONGOPOWER

2.       Select this course

3.       Click “My Assignments”

4.       Select an assignment category on the left hand side of the assignment page

5.       Select the assignment you wish to begin

Assignments

·         Homework

Log on to BONGOPOWER, click “My Assignments”, select an assignment, follow the directions. BONGOPOWER will guide you to the specific textbook exercises to be completed.

You may attempt each homework up to three times. Your last attempt is the grade of record. Your grade is not the highest score (unless that is also the last grade received).

·         Quizzes

Quizzes are open book, open notes, and take home.  Quizzes are objective questions and administered online by BONGOPOWER. You may attempt each quiz one time only. The content you need to prepare and master for each quiz is listed at the end of this syllabus.

Quiz Prerequisites

Quizzes have prerequisites that must be completed before you may begin the quiz. Most prerequisites are found in the textbook. BONGOPOWER will guide you to them. To learn what the prerequisites are:

1.       Click “My Assignments”

2.       Select a quiz on the left hand side of the page

3.       All prerequisites and homework that related to the selected quiz will then be listed.

Lateness

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

·         sickness with medical note

·         athletic event - with coach's note

·         religious observation

·         military responsibility with documentation

·         death in family with documentation

eMail Communication with the Instructor – Read Carefully!

You may communicate with your instructor using e-mail. There are some rules, however, that you must observe. 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.

·         Do not send attachments of your work to your instructor unless specifically invited to do so.

·         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 eMail:

·         About an assignment on the due date for that particular assignment.

·         On weekends or evenings.

·         Written in a rude or demanding way.

Office Hours

By Email.

Schedule

The sequence of topics is as follows:

Introduction

Information Systems

Windows

Data and Information

SQL

Excel - Functions & Formulas, Data & Data Analysis (Sort, Subtotal, Filter, Pivot Table)

Excel- Copy and Move, Cell Addressing

Internet – WWW

Excel - Logic

Data Communications and Networks

Excel – Statistics

Hardware & Software

Excel - Merge

Database Theory

Access

Quiz Preparation

This section should help you prepare for each quiz:

·         There are chapters and portions of the textbook to read (see below). 

·         If you want a better grade, do not forget to complete workbook illustrations as described above before attempting the associated quiz.

·         Many questions come from the workbook.

The dates for quizzes found in BONGOPOWER (click “MyAssignments”) are tentative – the instructor will announce changes if needed.

Legend:

·         Chapter to read and study for a quiz. Chapter numbers shown in ()

·         Homework that relates to a quiz shown in []

QUIZ 1

·         Introduction (1)

·         Information Systems (2)

·         Windows (3) [1]

·         Data and Information (4) [2]

·         SQL (5) [3]

·         TIP: Learn how to write SQL queries for Quiz 1. You will answer questions about a SQL database while working on Quiz 1. Topic include:

o   Data and Information

o   Information Systems

o   Windows

o   SQL Queries

·         Before beginning Quiz 1:

o   Open the SQL Lab – the link is in Resources.

QUIZ 2

·         Excel Introduction, Functions & Formulas, Data & Data Analysis (6) [4][5]

·         Internet (12: 314-328) & WWW (12: 328-341)

·         Excel Copy and Move, Cell Addressing (7: 160-167) [6]

·         TIP: Learn to use the pivot table in Excel. You will do poorly on Quiz 2 without it. You will need to have Excel open before starting Quiz 2. Topics include:

o   Internet & WWW

o   SQL query export

o   Excel topics: analysis of data (records), sort, date/time, cell addressing & cell copy/move

·         TIP: Cell addressing (relative & absolute) is one of the most difficult topics for students in this course. Take the time to learn it! Read the tutorials.

·         You need QUIZ 2.XLSX open for Quiz 2. Do this before beginning Quiz 2:

o   1. If you need it download it from the Resources page.

o   2. Open it and follow the instructions inside it.

QUIZ 3

·         Excel Logic (9: 214-225) [7]

·         Data Communications and Networks (14) **

·         Excel Statistics (9: 226-230) [8]

·         Hardware (13: 344-370) & Software (13: 370-395) **

·         TIP: Have Excel open before beginning the quiz. Topics include:

o   Excel copy and move cells. Cell addressing. IF, logic, LOOKUP, statistics.

o   Data and networking

o   Hardware software

o   HTML

·         Before beginning Quiz 3:

o   Download and open QUIZ 03.XLSX – get it from Resources.

o   Open the XHTML lab before beginning the quiz. The link is in Resources.

QUIZ 4

·         Excel Merge Tables (7:167-172) [9]

·         Database Theory (7: 172-178) & SQL Joining Tables (7: 178-181)

·         Access Introduction (8: 184-187) [10]

·         Access Queries – Simple and Join (8: 187-190)

·         Access Creating a Database (8: 200-206)

·         XHTML (11: 284-298)

·         TIP: This quiz assumes that you can use any or all software you learned while completing the course material. Excel and Access should be open before beginning this quiz.

·         Before beginning Quiz 4:

• Download QUIZ 4 JOBS.ACCDB and QUIZ 4 JOBS.XLSX and open them.
• Your computer must have Microsoft Access to open QUIZ 4 JOBS.ACCDB.
• If your computer does not have Access use a computer in the College of Business lab.

--- Official KSU/Business Information Follows ---

Cheating and Plagiarism

Academic honesty: Cheating means to misrepresent the source, nature, or other conditions of your academic work (e.g., tests, papers, projects, assignments) so as to get undeserved credit.   In addition, it is considered to be cheating when one cooperates with someone else in any such misrepresentation.  The use of the intellectual property of others without giving them appropriate credit is a serious academic offense.  It is the University's policy that cheating or plagiarism result in receiving a failing grade for the work or course.  Repeat offenses result in dismissal from the University.

Disabled Students

University policy 3342-3-01.3 requires that students with disabilities be provided reasonable accommodations to ensure their equal access to course content. If you have a documented disability and require accommodations, please contact the instructor at the beginning of the semester to make arrangements for necessary classroom adjustments. Please note, you must first verify your eligibility for these through Student Accessibility Services (contact 330-672-3391 or visit www.kent.edu/sas for more information on registration procedures).

Official Registration

Students have responsibility to ensure they are properly enrolled in classes.  You are advised to review your official class schedule (using Student Tools on FlashLine) during the first two weeks of the semester to ensure you are properly enrolled in this class and section.  Should you find an error in your class schedule it is your responsibility to correct the error.  If registration errors are not and you continue to attend and participate in classes for which you are not officially enrolled, you are advised now that you will not receive a grade at the conclusion of the semester for any class in which you are not properly registered.