QMBE 1320: Quantitative Analysis and Data Management ...

1 10:20 section: 202E GLC Bosley 12:40 section: 106 East Hall Spring 2015 1:50 section: 203E GLC The Hamline School of Business 1 Where the business, government, and non-profit sectors intersect to educate and collaborate for the common good. QMBE 1320: Quantitative Analysis and Data Management COURSE SYLLABUS Organizations have more data than ever before. While automated systems can store and categorize incoming data, well-educated individuals must apply Analysis and interpretation converting data into information and successfully communicate findings to non-technical audiences.

2 Building on statistics, this course will develop knowledge of mathematical models and Quantitative skills, useful for Analysis -driven decision-making in business and Management . To complement knowledge of models and analytical techniques, we will also focus on the use of technological tools ( , Microsoft Excel and Access) useful in data Analysis . As the first of a set of Hamline courses in Business Analytics, this class will provide a foundation of useful knowledge and skills, whether you become an analyst or are more broadly involved in organizational decision-making. Instructor Dr. Stacie Bosley (Assistant Professor, Economics) Office: 237W Giddens/Alumni Learning Center Phone: 651-523-2436 Email: **preferred method of contact** Office Hours I encourage you to visit me to discuss any questions you might have.

3 If these office hours conflict with your schedule, please communicate with me personally to schedule an appointment outside of these times. Mondays 11:30-12:30 Wednesdays 8:30-10:00 Fridays 8:30-10:00 and 11:30-12:30 or by appointment Required Materials Essentials of Business Analytics (2015), Camm, Cochran, Fry, Ohlmann, Anderson, Sweeney and Williams, 1st edition. US edition only (ISBN-9781285187273) Basic calculator that includes square roots, exponents, and logarithms. You may prefer to use a statistical/mathematical/graphing calculator but it is not required. Calculators on mobile devices will not be allowed for exams and calculators cannot be shared between students during exam periods.

4 Microsoft Excel and Microsoft Access software - note that all Hamline lab computers are equipped with the software needed so you are not required to have a personal laptop. If you have a Mac, please note that I am not a Mac-user so I encourage you to utilize the lab PCs or be sure you can perform Analysis required on your personal computer. Lab exams will be performed on PCs in DSC 2. 10:20 section: 202E GLC Bosley 12:40 section: 106 East Hall Spring 2015 1:50 section: 203E GLC The Hamline School of Business 2 Where the business, government, and non-profit sectors intersect to educate and collaborate for the common good.

5 Course Topics (for specific order of topics, see daily schedule) Chapter/Resource Introduction to Model Development; Profit and Break-Even Analysis Chapter 1 Time Value of Money (NPV and IRR) Instructor Provided Descriptive Statistics Chapter 2 Data Visualization Chapter 3 Linear Regression Chapter 4 Time Series Forecasting Chapter 5 Spreadsheet Modeling Chapter 7 Linear Optimization Models Chapter 8 Nonlinear Optimization Chapter 10 Simulations Chapter 11 Decisions under Uncertainty & Risk Chapter 12 Data Management with Access Instructor Provided and Appendix B Additional Topics: Macros Instructor Provided Preparation for Class Sessions: Our class sessions will build on short pre-class videos posted on Blackboard.

6 Before each class session (unless otherwise announced): (1) view the short video designed to prepare you for the upcoming class session posted on Bb under Content/Video Collection/Pre-Class Videos, (2) read the designated textbook sections, and (3) respond to a pre-class quiz in Blackboard. The pre-class video not a replacement for reading. The quiz can include questions based on the video and/or textbooks reading. Each quiz will close at 10:00 am on the day of that class session. Class Session Protocol: Our class sessions will be a combination of problem demonstrations (interactive) and group problem solving.

7 Be sure to bring a calculator and your textbook to each class. You are welcome to utilize your laptop/tablet during group problem-solving time, though we will do the vast majority of our computer-based problem solving in our lab sessions each Wednesday. Regular attendance is critical to learning this material and will be therefore a part of your overall grade. You will be responsible for all material presented in class, and some material will go beyond the coverage of your textbook. Questions during class are HIGHLY encouraged. I also hope/expect that you will visit office hours. While it is often easiest to discuss this content in person, I also welcome questions via email.

8 There will be a tutor for this course be sure to use this valuable resource in the basement of Bush Library! Your course tutor has been selected based on (1) outstanding performance in this course and (2) a desire to work with students on this subject. It is your responsibility to obtain notes, handouts, and assignments in the event that class is missed. There is a Blackboard site for this class. Check Blackboard for handouts that you might have missed as well as videos/problem sets/grades/data files/assignments for the course. Check your Hamline email daily as I will use this as a way to communicate information to you between class sessions.

9 10:20 section: 202E GLC Bosley 12:40 section: 106 East Hall Spring 2015 1:50 section: 203E GLC The Hamline School of Business 3 Where the business, government, and non-profit sectors intersect to educate and collaborate for the common good. Student Learning Outcomes As part of an ongoing process, the Hamline School of Business is assessing various aspects of student learning to help improve our undergraduate majors, concentrations and minors. If the outcomes for this class are assessed during this semester, this assessment may be done by the course instructor and/or guest faculty.

10 This assessment will not impact your grade for the course. Your grade is calculated based on the grading structure contained in the course syllabus. HSB will not be looking at your individual performance but will instead be analyzing the overall performance of its students, to identify potential program improvements. Your instructor will provide you with the assessment rubric that will be used to evaluate student work so that you are aware of what is being assessed. A Hamline graduate will be able to: serve, collaborate, and lead in a community solve problems in an innovative, integrative, analytical, and ethical way work and create understanding across cultural differences locally, nationally, and internationally use information and technology competently and responsibly communicate effectively in writing and in speaking apply theories and methods of a field of expertise engage independently and reflectively in lifelong learning An HSB business undergraduate will be able to.