MIS 24053 Summer 2010 Steinberg
Computer Applications – Intersession 2010
Dr. Geoffrey Steinberg
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.
On Line Course
In this course you will work at your own pace. You may complete the assignments on a schedule that works for you. All work must be complete by midnight of the last day of the term. All work is automatically and immediately graded by the online system, BOBGOPOWER that you will use. All assignments are available from the beginning of the term, so you may work as fast as you wish. The instructor is available by email.
Textbook and Other Materials
The course's text book is Information Technology – Second Edition, Steinberg, Geoffrey, Kendall-Hunt, 2010, 978-0-7575-7224-1. 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.
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 schedule. You will have a hard time if you do not read the book.
Workbook
Copies of relevant illustrations are found in a workbook included with the textbook. You will find these copies very handy. Study the illustrations in the workbook and attempt to fill in the blanks. Doing this will ensure that you have mastered the relevant material. It will help you study for quizzes (many of the quiz questions are based on the illustrations).
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 other course work. If you do not have that jump drive any jump drive may be used.
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.
Tutorials
The online system that you will use, BONGOPOWER, provides tutorials that you should attempt and complete. The tutorials are found on the BONGOPOWER menu by clicking “My Tutorials”. The bottom line is that you will complete homework faster and do better on quizzes if you complete the tutorials.
BONGOPOWER
All of your course assignments are interactive and involve using the BONGOPOWER on-line 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”.
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 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.
· 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.
· Written in a rude or demanding way.
Your Grade
Your grade is the weighted average of ten homework assignments and four quizzes as follows:
Ten homework @ 4% each 40%
Four quizzes @15% each 60%
100%
Homework
Log on to BONGOPOWER and click “My Assignments”. Select the assignment you wish and follow the directions. BONGOPOWER will guide you to the specific textbook exercises to be completed. Return to BONGOPOWER to have your work graded.
You may attempt each assignment up to three times. Your last grade 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.
Quiz Reservation
You will need a reservation time to begin a quiz. Your instructor will explain this. There are ample reservation times for everyone but if you delay in making your reservation you may not get the time you want. It is up to you to get a reservation and take the quiz. If you do not find the time you want get a different time. Do not ask the instructor to get a specific time for you. No special deals are made for anyone regarding reservations. No deals – do not ask!
Quiz Prerequisites
Each quiz has prerequisites that must be completed before you may begin a quiz. To learn what the prerequisites are click “My Assignments” then click “My Prerequisites” then click “Prerequisite Report”.
All prerequisites are found in the textbook. BONGOPOWER will guide you to them.
Do not wait to do the prerequisites until just before you schedule a quiz reservation. If you wait you are not likely to complete the prerequisites. If any are not completed you will not be allowed to attempt the quiz and you will receive a quiz score of zero.
This grading scale is used:
|
89.5+ |
A |
|
79.5 |
B |
|
69.5 |
C |
|
59.5 |
D |
|
0 |
F |
Extra Credit
None.
Drop Lowest Quiz
Not happening.
Special Deals for You Only
None – do not ask.
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.
· sickness with medical note
· athletic event - with coach's note
· religious observation
· military responsibility with documentation
· death in family with documentation
Schedule
Since this is a self study course there is no specific classroom schedule. The instructor may schedule class meetings from time to time if such meetings are needed. If so you will be informed.
The schedule is arranged around four quizzes. Each quiz has associated homeworks and three of the quizzes have prerequisites that must be completed before you begin the quiz.
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.
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
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 with out 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!
QUIZ 3
· Excel Logic (9: 214-225) [7]
· Data Communications and Networks (14)
· XHTML (11: 284-298)
· 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
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)
· 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.
--- 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, you have until Sunday, January 31, 2010 to correct the error. If registration errors are not corrected by this date 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.
