College of Business Administration

Spring 2023

BHON 120        Business Intelligence

Course Schedule:  Monday and Wednesday – 3:00-4:15 pm, TAH 1009

 Disclaimer: This syllabus and the schedule of readings, assignments, and activities may be changed by the instructor in order to maximize student learning needs and meet the objectives of the courses. 

 I. Instructor Information

Instructor

Spiros Velianitis, MS/MIS

E-mail

Spiros@CSUS.edu

Web Page

http://www.csus.edu/indiv/v/velianitis  and Canvas

Office Hours

Monday 10:30 am –12:00 pm & Wednesday 4:15 - 5:45 pm

Email access is essential in communicating with the instructor and your peers. Please activate your CSUS e-mail account.

 

II. Academic Learning Resources

Textbook: Ramesh Sharda, et al. Business Intelligence, Analytics, and Data Science, 4/E , 2018, Prentice Hall, ISBN-10: 0-13-463328-8

 Software:

1.      SAP Predictive Analytics

2.      SAP Lumira Designer

OR

3.      SAP Analytics Cloud

How to download the software tools?

Connect to http://worker.cob.csuchico.edu/. Will provide you with a user name and password at the beginning of the semester.

III. Business Concepts

Keywords: Business strategy, Data warehouse, Data acquisition and cleansing, Data mining methods and technology, Data modeling, Statistical analysis, Financial analysis and assessment

IV. Instructional Design

Course Description: Focuses on enterprise problem solving and decision-making using information technology, and data and financial analyses for mission critical and integral applications in planning and control. Alternative solutions are examined and evaluated for their effectiveness in achieving results.  Prerequisite: Completion of all business honors foundation requirements. Graded: Graded student. Units: 3.0.

Course Rationale/Course Overview: As the Northern California region recovers from the economic downturn businesses, not-for-profits and government agencies/departments will begin seeking business graduates who are capable of leading their business units as well-qualified managers. The Business Honors Program will focus on developing our best students to fill these opportunities through a challenging business curriculum that emphasizes cross-functional integration in enterprise planning, problem solving and decision making.  

 Prerequisites: BHON 102, 103, 104, 105, 106, 107, 108, 109, COMS 103.

 Course Learning Objectives:

Primary Learning Objectives:

·         Apply information technology to aid in problem solving

·         Determine the feasibility of alternative solutions using financial analyses, including identifying risk and return tradeoffs

·         Evaluate alternative solutions using statistical analyses

Detailed Learning Objectives:

·         Understand business strategy

·         Identifying, analyzing, interpreting and presenting results

·         Utilizing decision making tools, including optimization and simulation

·         Presenting value

·         Identify data requirements, architecture, and infrastructure of a Data Warehouse

·         Learn how to acquire and cleanse data

·         Learn how to model data

·         Use different data mining methods and technology

·         Perform statistical analysis including model selection, hypothesis formulation, model fitting, testing, interpretation/evaluation, and application

·         Perform financial analysis and assessment

·         Organizational factors that can impede or facilitate BI effectiveness

·         Knowledge management

V. CBA Program-Level Learning GOALS

 Goal 1 Fundamental Business Knowledge

Competence based on fundamental business knowledge.

 1.1 Demonstrate understanding of fundamental business theories, concepts, and skills.

1.2 Ability to analyze business information in performing business related tasks.

 Goal 2 Integrative Business Competence

Business competence integrated with other business knowledge areas and ethical responsibility.

2.1 Ability to identify factors contributing to a managerial problem from a variety of business perspectives.

2.2 Enumerate the costs and benefits that potential solutions will have on the interdependent stakeholders of a firm.

Goal 3 Effective Business Communication

Business communication utilizing contemporary and classic communication techniques and methods.

 3.1 Convey information in a variety of business settings.

3.2 Evaluate the efficacy of business communications.

 Goal 4 Applied Business Capability

Ability to translate knowledge of business and management into practice.

 4.1 Create effective business solutions that are both ethically sound and socially responsible.

4.2 Generate innovative and effective solutions for problem solving and decision making.

VI. Program and Course Level Assessment of learning (what program goals does this course meet, what assignments are assessed, and what is the assessment scoring method?)

Program Learning Goals

Student Learning Outcomes

Assessment Strategy

 

 

Direct Assessment Measure

 

 

1

To critically think about and solve business problems to generate business opportunities.

Exams

Scoring guide

2

Apply information technology to aid in problem solving

Individual Assignment

Peer Assignment

Scoring guide for Individual Assignment @ 30 points and scoring guide for Peer Assignment @ 40 points

3

Determine the feasibility of alternative solutions using financial analyses, including identifying risk and return tradeoffs

Team Project

Team Project scoring guide @ 30 points

VII. Grading Criteria, Guidelines, and Assignments

Course Grading:

I will give two in-class term individual examinations using Canvas. Each exam consists of fifty (40) multiple-choice questions. Prior to the individual examination, you will have a group examination which consists of twenty (20) multiple choice questions. Examination material will be drawn from the textbook reading, any other assigned readings, and class lectures and discussion. Emphasis will be placed on the conceptual understanding of the material and NOT on memory alone. Understanding the application of the concepts will greatly enhance your grade.

 

Final grades will be assigned according to the total points you have obtained through exams and homework assignments relative to the total possible number of points. 

Assignment

Points

2 Individual Exams

160

2 Group Exams

40

Peer Assignment

40

Individual Assignment

30

Team Assignment

30

Total Points

300

Your grade is also affected by the number of unexcused absences. You are allowed to have 5 unexcused absences. For each absence after your allowance, 5 points will be deducted. Note that absences are only excused for a valid reason (health problems, jury duty etc.) and MUST be accompanied with documentation (i.e., health center note with a phone number to call for questions) provided within a week of returning to class.

Pluses and minuses will be awarded along the extremities (i.e., greater than 3% below the upper limit and less than 3% of the lower limit, respectively). 

Based on the total points, your grades will be assigned as follows:

Percent

Grade

90-100

A

80-89

B

70-79

C

60-69

D

0-59

F

Any queries or appeals for a graded component (such as an assignment or an exam) must be directed to the instructor in person within 2 weeks after the graded component is returned. No adjustment will be made for the scores of graded components after the two-week period. Students are responsible for keeping track of their graded components. Uncollected graded components will be kept in the instructor’s office until the end of the current semester.

Grading system may change for compelling reasons. 

VIII. Weekly Outline: the schedule of readings, assignments, and activities may be changed by the instructor in order to maximize student learning needs and meet the objectives of the course.

 Please look at the schedule.htm for our detailed weekly schedule.  

IX. Course Time commitment

Contact Hours and Assignments

Contact Hours

Face-to-face Lectures & Online Meetings

 

 

45 hours

(3 unit course)

Out of Class

Homework Assignments

 

 

6-9 hours per week

 

Reading Assignments

 

Group Project & Presentation

 

Exams

Total Hours per Week

9-12 hours /week

X. Sacramento State Academic Honesty Policy and Regulations excerpt “Definitions of Academic Dishonesty” http://www.csus.edu/umanual/student/STU-0100.htm

Cheating. At Sacramento State, cheating is the act of obtaining or attempting to obtain credit for academic work through the use of any dishonest, deceptive, or fraudulent means. Cheating at Sacramento State includes but is not limited to:

1.      Copying, in part or in whole, from another’s test or other evaluation instrument.

2.      Using crib notes, "cheat sheets," or any other device, including electronic devices not permitted by the instructor as an aid in writing an examination.

3.      Submitting work previously graded in another course unless doing so has been approved by the course instructor or by department policy.

4.      Submitting work simultaneously presented in more than one course, unless doing so has been approved by the respective course instructors or by the department policies of the respective departments.

5.      Altering or interfering with grading or grading instructions.

6.      Sitting for an examination by a surrogate, or as a surrogate.

7.      Any other act committed by a student in the course of his or her academic work that defrauds or misrepresents, including aiding or abetting in any of the actions defined above.

Plagiarism. Plagiarism, as a form of cheating, is the use of distinctive ideas or works belonging to another person without providing adequate acknowledgement of that person’s contribution. Regardless of the means of appropriation, incorporation of another’s work into one’s own requires adequate identification and acknowledgement. Plagiarism is doubly unethical because it deprives the author of rightful credit and gives credit to someone who has not earned it. Acknowledgement is not necessary when the material used is common knowledge. Plagiarism at Sacramento State includes but is not limited to:

1.      The act of incorporating into one’s own work the ideas, words, sentences, paragraphs, or parts thereof, or the specific substance of another’s work without giving appropriate credit thereby representing the product as entirely one's own. Examples include not only word-for-word copying, but also the "mosaic" (i.e., interspersing a few of one’s own words while, in essence, copying another’s work), the paraphrase (i.e., rewriting another’s work while still using the other’s fundamental idea or theory); fabrication (i.e., inventing or counterfeiting sources), ghost-writing (i.e., submitting another’s work as one’s own) and failure to include quotation marks on material that is otherwise acknowledged; and

2.      Representing as one’s own another’s artistic or scholarly works such as musical compositions, computer programs, photographs, paintings, drawing, sculptures, or similar works.

XI. Student services

 

1. Services to Students with Disability (SSWD)

 

“Sacramento State is committed to ensuring an accessible learning environment where course or instructional content are usable by all students and faculty. If you believe that you require disability-related academic adjustments for this class, please immediately contact Services for Students with Disabilities (SSWD) to discuss eligibility. A current accommodation letter from SSWD is required before any modifications, above and beyond what is otherwise available for all other students in this class will be provided.”

 

3. Student Health and Counseling Services

“Your physical and mental health are important to your success as a college student. Student Health and Counseling Services (SHCS) in The WELL offers medical, counseling, and wellness services to help you get and stay healthy during your time at Sac State. SHCS offers: Primary Care medical services, including sexual and reproductive healthcare, transgender care, and immunizations; urgent care for acute illness, injuries, and urgent counseling needs; pharmacy for prescriptions and over-the-counter products; mental health counseling, including individual sessions, group counseling, support groups, mindfulness training, and peer counseling; athletic training for sports injury rehabilitation; wellness services, including nutrition counseling, peerled health education and wellness workshops, and free safer sex supplies; violence and sexual assault support services. Most services are covered by the Health Services fee and available at no additional cost.”

 

3. Crisis Assistance & Resource Education Support (CARES)

“If you are experiencing challenges with food, housing, financial or other unique circumstances that are impacting your education, help is just a phone call or email away. The CARES office provides case management support for any enrolled student

 

XII. Student Resources

 

·              CBA Tutoring Center – Information will be sent to students over BizList when the schedule is finalized and posted.

XIII. Other Information

Late and Make-up Policy:  The general policy for this course is to require completion of assignments as specified in the class schedule.  All assignments are due at the beginning of the class period. Late assignments may be submitted within a week of the due date with a 20% penalty. No late assignments will be accepter after 1 week.  All assignments will be submitted using Canvas (please do not email your assignments). I will send you instructions on how to submit the assignments before the due dates.

Incomplete: An incomplete grade (I) will only be issued in accordance to College of Business Administration policy. Among the conditions imposed by the instructor that must be met are: (1) a current passing grade (70 percent or better), (2) the successful completion of all prior assignments and exams, and (3) an unforeseen and unusual event beyond your control which prevents you from completing the semester, and can be documented and verified (employment-related events do not qualify). (4) An incomplete will only be considered after it has been determined that a withdrawal (W) cannot be issued. If you do not meet (1) through (4), you do not qualify for an incomplete. As stipulated by the University, an incomplete cannot be assigned when it is necessary for the student to attend additional class meetings to complete the course requirements.

Unauthorized Withdrawal (WU) indicates that a student did not officially withdraw from the course but failed to complete it. Among the conditions imposed by the instructor that must be met are: (1) a passing grade (70 percent or better) at the time that the student stopped attending classes, (2) attendance stopped before the 11th week of the semester. If you do not meet (1) and (2), you do not qualify for an unauthorized withdrawal (WU) grade and as a result you will be assigned a failing (F) grade.

Laptop and cell phone regulation: No photographing, recording or text messaging is allowed without permission of the instructor.

A disruptive student is a student who engages in classroom behavior that interferes with the process of teaching and learning. If a student is disruptive to my class, I will follow the Procedures for dealing with incidents of disruptive behavior described in the DEALING WITH INCIDENTS OF DISRUPTIVE STUDENT BEHAVIOR IN THE CLASSROOM document https://www.csus.edu/umanual/student/STU-0112.htm.