24053-Steinberg
M&IS 24053 Computer Applications Intersession 2014
Dr. Geoffrey Steinberg / gsteinbe@kent.edu
Objective
The fundamental objective is for you to develop competency in handling data using various programs. An additional objective is that you 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.
Theme
The course theme is data & information & decision making.
Learning Outcomes
Develop data analysis skills
Develop software manipulation skills
Learn to use data and information for decision making
Learn about the role of IT throughout business
Become a better writer
Learn to manage your time
Develop software manipulation skills
Learn to use data and information for decision making
Learn about the role of IT throughout business
Become a better writer
Learn to manage your time
Self-Study Course
This is a self-study course. All of the material you need to learn to complete assignments and quizzes is in the e-book (described below). You need no other sources.
You are going to need to be self-motivated. You will learn a lot and be capable of advanced data manipulation and analysis when the course is complete.
You are going to need to be self-motivated. You will learn a lot and be capable of advanced data manipulation and analysis when the course is complete.
Sources of Information
You have several main sources of information for this course:
- The e-book
- The e-book's interactive lessons
- Me (email me with questions)
- Online Topic Presentations
- Study guides for each course unit
- Class presentation downloads for you to use as you study
BONGO
Most of your course assignments (homework and quizzes) are interactive and involve using the course website BONGO. The instructor will provide access.
- Assignments administered by BONGO are graded instantly .
- BONGO is available 24/7.
- Your course grade report, always available, is updated on BONGO each time anything is graded.
- RESOURCES (handouts for you to download and use) are provided here.
Textbook
The course's text book is Dancing with Data, 2013, Active Learning Lab, Kendall-Hunt, 978-1-4652-4090-3. The textbook is an e-book and includes:
- Numerous interactive lessons
- Interactive checkpoints - you get EXTRA CREDIT for answering the checkpoint questions and some are quiz questions.
- Many other beneficial features including highlighting and note taking are explained in the book's preface.
- Use the course schedule (later in syllabus) and know what chapters to read for each course unit.
Other Materials
Microsoft Excel
OpenOffice
SQL (database)
Text Editor
Class Presentation Resources
For this course you will use Microsoft Excel (2007 or any newer version). Excel may be used on your computer if you have it or in the College of Business computer lab or other labs on campus.
The version of Excel you use must permit Excel macros to operate.
If you do not have Excel installed but would like it you can obtain a 60 day trial copy from www.microsoft.com for free.
You can purchase Microsoft Office (which includes Excel) for a special price here: http://www.kent.edu/is/helpdesk/microsoft.cfm
The version of Excel you use must permit Excel macros to operate.
If you do not have Excel installed but would like it you can obtain a 60 day trial copy from www.microsoft.com for free.
You can purchase Microsoft Office (which includes Excel) for a special price here: http://www.kent.edu/is/helpdesk/microsoft.cfm
OpenOffice
This is a free equivalent for some of Microsoft Office. We will use the database program BASE from OpenOffice instead of Access from Microsoft Office. This avoids the cost of purchasing the premium version of Microsoft Office. We use no other components of OpenOffice. Access may be used if you wish but we do not discuss it in class.
Get OpenOffice Base for free http://www.openoffice.org/download/
Get OpenOffice Base for free http://www.openoffice.org/download/
SQL (database)
You will use an on-line interface to an SQL database. This will be provided for you by a link from BONGO.
Text Editor
Notepad for the PC or TextEdit for the Mac are fine.
IMPORTANT for MAC users: If you use TextEdit make your TXT files "plain text" from the "Format" menu.
IMPORTANT for MAC users: If you use TextEdit make your TXT files "plain text" from the "Format" menu.
Class Presentation Resources
To help you follow along while learning the software demonstration part of the class download example files from the RESOURCES \ CLASS PRESENTATIONS on the BONGO menu. Use them as you try out what you are learning.
Topic Presentations
To further your understanding of topics you read about there are a series of topic presentations in RESOURCES \ GENERAL.
Study Guides
You will find a study guide for each unit in RESOURCES
Assignments
Homework Assignments
There are fourteen homework assignments. You may attempt each assignment up to three times. Your highest score is the grade of record.
Log on to BONGO, click My Assignments; select an assignment; follow the directions. BONGO will guide you to the specific exercises to be completed.
Log on to BONGO, click My Assignments; select an assignment; follow the directions. BONGO will guide you to the specific exercises to be completed.
Quizzes
There are six quizzes. You may attempt each quiz one time. Quizzes are open book, open notes, and take home. The quiz content is later in this syllabus.
Prerequisites - Some quizzes have prerequisite assignments. Check BONGO for details this way:
Prerequisites - Some quizzes have prerequisite assignments. Check BONGO for details this way:
- Login to BONGO
- Click MY STATUS on the course menu
- Click MY PREREQUISITES
Content - Each quiz is a blend of material from class presentation, the textbook, homework assignments.
Final Exam
There is no final exam.
Extra Credit
Answering CHECKPOINTS in e-book
Up to ten points of extra credit are awarded based on you completing reading assignments in the e-book and answering questions ("checkpoints") as you read. To learn how to record your earned extra credit in BONGO:
- Login to BONGO
- Click RESOURCES on the course menu
- Click HOW TO DO THINGS
- Read the document: "GETTING EXTERNAL EXTRA CREDIT SCORES"
Grading Scale
Minimum Score | Letter Grade |
90 | A |
80 | B |
70 | C |
60 | D |
0 | F |
+/- grades are not used. Grades are not rounded up. No curves.
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
Email Communication with the Instructor – Read Carefully!
Communicate with your instructor using e-mail. There are some rules, however, that you must observe. Follow 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.
- 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.
- That contains “ASAP”.
- That begins with "Hey"
Office Hours
There are no office hours - this is an online course. Contact the instructor with questions. Use the address at top.
Course Content
The course has six units. This table lists the textbook chapters and their relationship to homework, prerequisites, quizzes, extra credit for each unit.
See RESOURCES in BONGO for a study guide for each unit.
See RESOURCES in BONGO for a study guide for each unit.
UNIT |
CHAPTER |
HOMEWORK |
PREREQUISITE |
QUIZ |
EXTRA CREDIT |
1 |
INTRODUCTION INFORMATION SYSTEMS SYSTEM DEVELOPMENT OPERATING SYSTEMS DATA & INFORMATION |
HOMEWORK 01 HOMEWORK 02 |
QUIZ 1 |
INTRODUCTION INFORMATION SYSTEMS SYSTEM DEVELOPMENT OPERATING SYSTEMS DATA & INFORMATION |
|
2 |
EXCEL Beginning-Date and Time Functions Data Analysis: Beginning-Pivot Table ANALYTICS AND VISUALIZATION |
HOMEWORK 03 HOMEWORK 04 HOMEWORK 05 |
DATA ANALYSIS EXCEL BASICS |
QUIZ 2 |
EXCEL- BASICS DATA ANALYSIS SECURITY and PRIVACY ANALYTICS AND VISUALIZATION |
3 |
EXCEL Cell Addresses & Operations External Data Merging Tables Naming Data and Formulas SOCIAL IMPACT |
HOMEWORK 06 HOMEWORK 07 |
ABSOLUTE ADDRESSING IMPORT |
QUIZ 3 PART A QUIZ 3 PART B |
EXCEL- ADDRESSING EXTERNAL DATA MERGE NAMES SOCIAL IMPACT |
4 |
EXCEL Logic Database Operations THE INTERNET WWW |
HOMEWORK 08 |
LOGIC |
QUIZ 4 |
EXCEL- LOGIC DATABASE OPERATIONS THE INTERNET WWW |
5 |
DATABASE SQL HARDWARE OPENOFFICE BASE ERP / SAP SOFTWARE |
HOMEWORK 09 PART A HOMEWORK 09 PART B HOMEWORK 10 |
SQL EXPORT BASE EXPORT |
QUIZ 5 PART A QUIZ 5 PART B |
DATABASE SQL HARDWARE SOFTWARE |
6 |
EXCEL Charts Functions-Statistical Functions Data Analysis-Statistical Techniques COMMUNICATION & NETWORKING |
HOMEWORK 11 HOMEWORK 12 HOMEWORK 13 HOMEWORK 14 |
QUIZ 6 | EXCEL- STATISTICS COMMUNICATION & NETWORKING |
Quiz Preparation
This section should help you prepare for each quiz. The material you are responsible for on each quiz is listed below.
It is your responsibility to read the named topics/chapter in the e-book. o learn how to record your earned extra credit in BONGO see the section about extra credit earlier in the syllabus.
Quiz # Unit # |
Topics/Chapters |
1 | Information Systems Operating Systems Data and Information System Development |
2 | Excel Introduction Formatting Functions Formulas Data Types Data Analysis Security & Privacy |
3 | Cell and Formula Naming Cell Addressing Excel Table Merge Data Import Social Impact |
4 | Excel Logic Excel Database Operations The Internet WWW |
5 | Database SQL Hardware BASE/Access Software |
6 | Excel Statistics and Charts |
--- Official KSU/College of 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.