1Decision Systems Design BCIS 4660.002 Spring 2012 Classroom: BLB 170, R 2:00 – 4:50 pm Instructor: Dr. Nick Evangelopoulos Office: BLB 365D Telephone: Office: (940) 565-3056 E-mail: [email protected] (preferred way to contact me) OFFICE HOURS TR 1:00-2:00 PM (BLB 365D); W 6:00-6:30PM (Frisco); and by appointment REQUIRED TEXTBOOKS 1. Pratt and Adamski, Concepts of Database Management, 7 th Edition, Course Technology, 2012 (ISBN-13: 978-1-111-82591-1) 2. Adamson and Venerable, Data Warehouse Design Solutions, Wiley, 1998. OPTIONAL TEXTBOOK 3. Marakas, George, Modern Data Warehousing, Mining, and Visualization, Prentice Hall, 2003. COURSE WEB SITE http://www.cob.unt.edu/itds/courses/bcis4660/ COURSE PREREQUISITES BCIS 3610, ACCT 2010 and ACCT 2020 with grades of C or better; Grades of C or better in each previously taken BCIS and DSCI course, or consent of department. COURSE DESCRIPTION & PURPOSE This course investigates model-based approaches to the design of decision systems for business and industry. This includes exploring techniques for data management such as data warehousing, data mining, and data visualization for decision-making in management, management science and accounting. Emphasis will be placed upon data warehousing techniques for financial auditing. This course is intended primarily for Accounting & Decision Sciences majors, but other majors (esp. BCIS) are welcome. Course Datasets Several course datasets (Premiere Products and Henry Books) may be found at: http://www.cob.unt.edu/itds/courses/bcis4660/2GRADING Quizzes 7% 35 points Midterm Exam 24% 120 points Final Exam 26% 130 points Project and Homework 43% 215 points Total 100% 500 points Most course grades will be posted on the Web. Incomplete grades will not be given. You are to check your posted grades at least once a week. You will have one week to ask for a correction to a posted grade and after that period of time the grade will not be changed. This includes quiz grades. Final course grades will be based on total points accumulated and the subjective judgment by the instructor of your performance in this class. Final grades will not be posted. COURSE PROCEDURES AND REQUIREMENTS Examinations and Quizzes The exams will be closed-book. Early or late final exams will not be given. Make-up exams will not be given. Final examination will be comprehensive of all subject matter. Quizzes will be open or closed book at the instructor’s discretion. Late quizzes will not be given, but you will be able to drop some of your lowest Quiz grades. Homework, Projects, and/or Assignments Problems, cases, and readings will be assigned to support and supplement course subject matter. Each assignment which you turn in must have a cover page containing the following information which is typed and centered on the page: your name (“Fname Lname” or “Lname, Fname”), the assignment number, the due date for the assignment, the topic of the assignment, Text Title (if any), Chapter (if any) and page number (if any). For some assignments, late submissions may be accepted for 50% credit (requires consent of the instructor, individual assignments only). All assignments are due at the beginning of class on the date due. All assignments must reflect your original work. Team assignments will include a team member evaluation sheet, which each team member must complete. Attendance/Missed Classes Regular and punctual attendance is essential for this course. While attendance will not be taken, Pop quizzes will be given throughout the semester. If you are not present, you cannot retake the quiz (however, some of your lowest quiz grades will be dropped). All handouts and lecture presentations will be posted on the course Web site. However, you are encouraged to make a friend in the class and use him/her as your source for missed materials.Page 3 of 5 Course Communications All students are encouraged to use e-mail for all communication with Dr. Evangelopoulos or questions about class or assignments. Course and assignment information will also be posted on the Web, at http://www.cob.unt.edu/itds/courses/bcis4660/. Please, check this Web site regularly, and at least once each week! Disability Accommodation The College of Business complies with the Americans with Disabilities Act in making reasonable accommodations for qualified students with disability. If you have an established disability as defined in the "Act" you are encouraged to register with the Office for Disability Accommodation. Academic Integrity This course adheres to the UNT policy on academic integrity. The policy can be found at http://vpaa.unt.edu/academic-integrity.htm. If you engage in academic dishonesty related to this class, you will receive a failing grade on the test or assignment, or a failing grade in the course. In addition, the case may be referred to the Dean of Students for appropriate disciplinary action. SETE The Student Evaluation of Teaching Effectiveness (SETE) is a requirement for all organized classes at UNT. This short Web-based survey will be made available to you at the end of the semester, providing you a chance to comment on how this class is taught. I am very interested in the feedback I get from students, as I work to continually improve my teaching. I consider SETE to be an important part of your participation in this class. Cell Phones As a courtesy to your instructor and to your fellow classmates, you are asked to set your cell phone to vibrate, or switch it off. In case of a personal emergency, if you must use your cell phone, you are asked to step out of the classroom. Campus Closures Should UNT close campus, it is your responsibility to keep checking your official UNT e-mail account to learn if your instructor plans to modify class activities, and how. This may include changing assignment due dates, rescheduling quizzes and exams, etc. Incomplete Grade (I) The grade of "I" is not given except for rare and very unusual emergencies, as per University guidelines. An “I” grade cannot be used to substitute your poor performance in class. If you think you will not be able to complete the class satisfactorily, please drop the course.Page 4 of 5 CLASS SCHEDULE: (Subject to change; effective 1/19/2012) Week Date Topics Readings Assign. Due** 1 Jan 19 Introduction to Data Warehousing Introduction to Database Management Pratt 1 2 Jan 26 Relational Databases QBE; Relational