Fall 2020 ITM 310 Syllabus PDF

Preview

Summary

Homework...

Description

BLOOMSBURG UNIVERSITY OF PA Zeigler College of Business COURSE SYLLABUS

DATE PREPARED:

August, 2020

PREPARED BY:

Yucheng Chen, Ph.D.

CONTACT INFORMATION:

Office: Sutliff Hall, Room 305 Mobile Phone: (860) 931-9587 Email: [email protected] Office Hour: (Zoom) Tuesday, Wednesday, Thursday 2:00 PM – 3:30 PM https://bloomu.zoom.us/j/94766994993 Office Hour: (Others) By appointment (In-Person or Online)

DEPARTMENT:

Information, Technology, Analytics, and Business Education

COURSE INFORMATION:

Course Number: ITM 310.01, 310.02 Course Title: Data Management Essentials for Business Credit Hours: 3 Prerequisites: ITM 175 or instructor approval

CATALOG DESCRIPTION Introduces the management of structured data, semi-structured data, unstructured data, and Big Data assets in the business environment using emerging technologies and methods. The course explores modeling, designing, implementing, and application development with database management systems. This course is required for Information and Technology Management Major and Minor. It is also suitable as an elective for undergraduate students interested in database management. CONTENT DESCRIPTION Analyzing Data in the Enterprise Environment This unit builds the foundation for the course through the evaluation of an enterprise’s data environment and by developing the distinction between the various types of data. Enterprise data evaluation process Structured data Semi-structured data Unstructured data Big Data Designing Data Management Infrastructure

Data Management Essentials for Business – ITM.310, Fall 2020

Page 1

This unit explores the business and technology considerations in the design of data management infrastructures. Business model considerations Emerging technology for structured data, semi-structured data, unstructured data, and Big Data Implementing the Database Model This unit emphasizes the design principles and implementation of the relational database model. This model is the predominate model for capturing business data to support commerce and decision making. Enhanced entity-relationship model Star, multi-start, and snowflake schemas Physical database design Data Definition Language (DDL) Exploring Data Maintenance This unit introduces application development considerations based on the enterprise’s data environment. Structured Query Language (SQL) Performance considerations Security Privacy METHODS Delivery methods used may include video, presentation, meeting, and hands-on technology activities. This class is a combination of on-line presentations, case study review, small group activities, student research projects, student research papers, interactive media, oral presentations, and practice exercises. A computer (desktop, laptop, table, etc.) and interactive access are required. EVALUATION PROCEDURES Students will be evaluated based on a variety of activities. Directions for each activity appear in BOLT Content. Due dates appear in the Course Schedule. Application Assignments: (0 – 400 points) Two (2) assignments are completed during the session to support the learning process. Assignments require software tools, case analysis, and independent research. Missed assignments can NOT be made up. Assessments: (0 – 400 points) Ten (10) quizzes are completed given during the session. The assessments will consist of multiple-choice questions and true/false statements. The topics cover all required readings, class discussions, and course documents. Missed quizzes can NOT be made up. Final Exam: (0 – 200 points) A comprehensive final exam is given at the conclusion of the course. The exam may consist of the following: multiple-choice questions, true/false statements, short answers, exercises, essays, and case analysis.

Data Management Essentials for Business – ITM.310, Fall 2020

Page 2

COURSE SITE INFORMATION: Participation in this course is through BOLT (Bloomsburg Online Learning and Teaching), a Learning Management System which will allow students to access information and communicate with class members on a 24 / 7 basis. Bolt is the site for asynchronous course materials. There are areas for content, the class list, assignments, and grades. A separate folder for each unit appears in the BOLT content area. Please work from this site first, check the site daily for new information, and link to all the online lessons from this site. It recommended that students check the site no less than fives times each week. The BOLT course site will be available beginning August 17, 2020. It is expected that students review all course materials posted in BOLT. To access this course on BOLT, go to the website at: https://bolt.bloomu.edu For help with BOLT call: BOLT Support 1-570-389-2888 There is also a BOLT Student Support Page at: http://departments.bloomu.edu/imdc/boltstudentsupport.html

The BOLT course site is built upon the learning platform Desire2Learn. Information about the Desire2Learn Accessibility Plan can be found at: http://www.desire2learn.com/accessibilityplan/ REQUIRED TECHNOLOGY SKILLS Students must be comfortable using computers and the following tasks:       

Saving files and backing up files to multiple locations Sending and receiving email with the student’s BloomU email account General internet searching skills Word processing (creating documents and saving as .docx and .pdf files) PowerPoint (creating slides with text and images, saving slides and presentations) BOLT navigation skills Uploading files to a server or cloud storage

Most important of all, students must be willing to learn, create, and participate. Please contact the instructor for assistance. TECHNOLOGY REQUIREMENTS The following technology is required for this class:  Desktop or laptop computer (either a Mac or PC computer)  Internet access  Firefox, Google Chrome, or Safari browser  Latest Java version Internet Connection

Data Management Essentials for Business – ITM.310, Fall 2020

Page 3

It is necessary to have access to a computer with Internet connections and email. The faster and better the Internet connection, the better the online experience will be in this class. If a student does not have a high-speed DSL or Cable connection, now is a good time to think about upgrading. Internet Browser

Students can access both the BOLT course web site and SAP web site using either a Mac or PC, and using either Firefox, Google Chrome, or Safari. Since browsers change so frequently, and a student experiences issues with BOLT or SAP, the first recommendation would be to trying using a different internet browser. Based on past experience, Internet Explorer is NOT recommended. REQUIRED SOFTWARE Some course assignments will require the use of Microsoft Office 2016 and accessing Bloomsburg University PhP MySQL Server – cobitmdb.bloomu.edu/phpMyAdmin. COURSE EXPECTATIONS Budget time for class work. Since this is an online course, the work can be completed independently. Experience has shown that it is best for a student to create their own schedule for class work, and try to stay with the schedule. Select specific days and time to work on the assignments. Stay in touch. Check the BOLT course site and BloomU email daily. Announcements and updates will be posted or sent throughout the week. Avoid procrastination. Don’t wait until the last minute for completing assignments. Remember that this course is technology dependent, and technology might temporarily fail. Communicate with the Instructor. The instructor is here to support all students. Please use the available course resources to find answers – such as discussion topics related to course questions. If support is needed, please contact the instructor to schedule a meeting to talk one-on-one. Correspondence from the instructor will be sent to student “huskies.bloomu.edu” email address. Be familiar with BloomU Policies. It is the responsibility of the student to know and observe the policies and regulations of the University. This includes the Policies and Procedures described on the URL: http://bloomu.edu/policies_procedures; specifically: PRP 3506 – Class Attendance PRP 3512 – Academic Integrity PRP 3881 – Student Disruptive Behavior PRP 3516 – Academic Exam Policy Absences. Only students with excused absences may make up a project or exam. An excused absence must be documented and follow the University guidelines explained at http://www.bloomu.edu/policies_procedures/3506.

Data Management Essentials for Business – ITM.310, Fall 2020

Page 4

Grades. Grades will be posted in BOLT. Questions regarding a graded assessment must be raised within one week of the assessment return and posting on BOLT. Assignments. All assignments and correspondence must include the student’s full name and the course name. Assignments and correspondence may NOT be placed in instructor’s College of Business mail box. Each assignment will include submission instructions to BOLT. All assignment/activities will be submitted in BOLT by the specified due date. No late assignments will be accepted. It is the student’s responsibility to confirm the integrity of files submitted to BOLT Dropbox. Do not forward the BOLT Email confirmation to the instructor since this is NOT evidence of a submission to the Dropbox of an assignment that follows the appropriate directions. The process for confirming the integrity of files submitted to BOLT Dropbox will be demonstrated during a synchronous class meeting. A student may not submit an assignment completed in another course for credit in this course. SUPPORTING MATERIALS Research references are part of the Andruss Library collection. BOLT, a course management application, will be used for posting the assignment schedule, submission of assignments, and posting of course documents. The application is available online at the following Web address: http://bolt.bloomu.edu/ REQUIRED TEXT Available at the Bloomsburg University Store Modern Database Management, 13th Edition, 2019 Authors: J.A. Hoffer, V. Ramesh, and H. Topi Publisher: Pearson ISBN 978-0-13-477365-0 GRADING SCALE Grade Percentage A 94 A90 B+ 87 B 84 B80 C+ 77 C 74 C70 D+ 64 D 60 F Below 60 Data Management Essentials for Business – ITM.310, Fall 2020

Page 5

RELIGIOUS OBSERVENCE Students must notify the instructor in writing at least one week prior to a class absence because of religious observance. ACADEMIC INTEGRITY You are expected to act with academic integrity inside and outside of the classroom and will face consequences for failing to do so. The consequence is a zero in the assignment/assessment and the filing of an Academic Integrity Policy Violation Report Form with the Dean of Students. Examples of conduct lacking academic integrity are listed in Bloomsburg University's Policy on Academic Integrity are available at http://www.bloomu.edu/policies/3512.php. If you are unsure whether an act violates the academic integrity policy, consult me before engaging in the act. ZEIGLER COLLEGE OF BUSINESS CODE OF HONOR Honesty, integrity, and professionalism are essential to successful, fair, and responsible business endeavors. To encourage a lifelong commitment to these principles, members of the Zeigler College of Business community shall promote the highest standards of behavior and accountability. Student and faculty in the Zeigler College of Business are responsible for the academic integrity of their work and shall not lie, cheat, or plagiarize. Students and faculty in the Zeigler College of Business shall strive for intellectual engagement and continual improvement, act honestly and responsibly, and exhibit the highest level of integrity. This Code of Honor represents the minimum standard that students and faculty should aspire to as members of the Bloomsburg University Zeigler College of Business. IMPORTANT CLASS POLICIES This course adheres to the Bloomsburg University Academic Integrity Policy and the policies described in the student handbook, The Pilot. It is the responsibility of the student to know and observe the policies and regulations of the University. This includes the Policies and Procedures described on the URL: http://bloomu.edu/policies_procedures; specifically: PRP 3506 – Class Attendance PRP 3512 – Academic Integrity PRP 3881 – Student Disruptive Behavior PRP 3516 – Academic Exam Policy Class correspondence is sent to student “huskies.bloomu.edu” email address.

Data Management Essentials for Business – ITM.310, Fall 2020

Page 6

Assignments and correspondence may NOT be placed in instructor’s Zeigler College of Business mailbox. Each assignment will include submission instructions. All assignments and correspondence must include the student’s full name and the course name. It is the student’s responsibility to confirm the integrity of files submitted to BOLT Dropbox. Do not forward the BOLT Email confirmation to the instructor since this is NOT evidence of a submission to the Dropbox of an assignment that follows the appropriate directions. The process for confirming the integrity of files submitted to BOLT Dropbox is demonstrated in class. This classroom is a place where everyone is treated with respect. Individuals of all ages, backgrounds, beliefs, ethnicities, genders, gender identities, gender expressions, national origins, religious affiliations, sexual orientations, ability – and other visible and nonvisible differences are welcome. All members of this class are expected to contribute to a respectful, welcoming and inclusive environment for every other member of the class. SYLLABUS DISCLAIMER Should unique conditions arise elements of this syllabus and the course schedule may be modified during the semester at the discretion of the instructor.

Data Management Essentials for Business – ITM.310, Fall 2020

Page 7...