Course Outline/Calendar
CSUN
Business 312
Data Literacy for Business
Fall, 2024
20795
Mon/Wed 11:30am - 12:45pm (Mon 8/26 - Mon 12/9, 16 weeks)
BB2206
(in-person format)
Fri, Dec 13, 2024
[updated: Friday, December 13, 2024]
"There are five managerial roles; they are to set objectives, organize, motivate and communicate, measure, and develop people."
-Peter Drucker (1909-2005)
Course Outline/Calendar
The purpose of this web site is to provide information and materials for students enrolled in Wayne Smith's Business 312 course, Class # 20795, for the Fall, 2024 semester.
This course meets Mon/Wed 11:30am - 12:45pm (Mon 8/26 - Mon 12/9, 16 weeks) in BB2206 [ Campus Map ].
This course is taught in the in-person format.
This course is offered by the College of Business and Economics at California State University, Northridge (CSUN). CSU Northridge is one of 23 campuses in the California State University system.
The following summary identifies the key terms used in the course outline.
Note: Materials listed as (CSUN only) are restricted to CSUN students, faculty, and staff only. To access these restricted materials, CSUN stakeholders will need to enter their full CSUN email address and their CSUN password. There is a small chance this type of authentication may not work for some smartphones or tablets; in that case, simply use a laptop or desktop computer.
- Question:
- A general organizing question to place this particular material in context
- Topic(s):
- General topic(s) to be discussed
- Richardson/Watson:
- Readings from the textbook
- Library:
- Readings from the library materials (or occasionally, a direct, online resource)
- Supplemental:
- Miscellaneous Readings
- Due:
- Assignment or report due at the immediate beginning of class
- Review:
- Usually a student-led review of an assignment or report
- Exercise:
- done individually or in teams (announced and collected in-class)
- Activity:
- done individually or in teams (announced and done either in-class or as homework)
- Lecture:
- a lecture or presentation done by the instructor
- Video Clip(s):
- Video Clip(s) shown in class, typically from a movie or TV show
- Quiz:
- a relatively short test
- Exam:
- a relatively long test
- (contingency)
- Slack time embedded during the course to cover unforeseen events
The following is the detail of the course in chronological order. Students must complete the readings and assignments before the due date.
Week 1: Mon. Aug 26, 2024
- Topic(s): Enrollment Management, Class Materials, Class Introduction
- Assumptions I'll Make About You:
- Supplemental: Review of First Principles (Fundamentals): Lower-Division Core [ .pptx ]
- Teams and Teamwork [ .pdf ] (Sat. Aug 5, 2023)
- Sample Quiz - Spreadsheets [ .pdf ]
- Examples of Strong Writing: Sentences [ .pptx ], Paragraphs [ .pptx ], Arguments [ .pptx ], and Style [ .pptx ]
- Examples of Areas for Improvement: Language Use and Grammar [ .pptx ]
- Detailed Writing Errors [ .xlsx ]
- Lecture: Professional Influence (Elements of an Argument) [ .pptx ]
- Lecture: Public Speaking Tips (pp. 12-5 to 12-10) [ .pdf ]
- Lecture: Introductory Background Lecture [ .pptx ] (Thu. Sep 19, 2024)
- Library: Sandberg (Tardiness Contagion)
Week 1: Wed. Aug 28, 2024
- Lecture: Guest, Craig Oka/Danielle Rodriguez/Karla Ayala (Director/Coordinator(s), Nazarian College Career Education and Professional Development (CEPD) Office)
- office: BB2234, phone: 818-677-4697
- Activity: Nazarian CEPD 'Handshake' Registration (answer the questionnaire to set up a profile)
- Login [ .html ]
- Assignment Details [ .pdf ]
- Due (Fri. Sep. 13, in Handshake): Update your Handshake profile
- Activity: Nazarian CEPD 'VMock' Registration (create a login with your CSUN email address and upload your current resume twice)
- Login [ .html ]
- Assignment Details [ .pdf ]
- Due (Fri. Sep. 13, in VMOCK): Upload an initial Résumé and an updated Résumé
- Supplemental: Important Career Dates For Fall, 2024
- Industry Night Thu., September 26th, 2024, 6pm - 9pm, CSUN USU Northridge Center - [ .html ] (All Nazarian students)
- Meet the Firms - Tue., September 17th, 2024, 6pm - 9pm, Odyssey Restaurant - Registration -> [ .html ] (Accountancy students)
Week 2: Mon. Sep 2, 2024
- (no class, Labor Day Holiday)
Week 2: Wed. Sep 4, 2024
- (please place non-needed items in the back shelves or "cubbyholes")
- Activity: Discuss Assignment: Data Opportunity/Challenge Essay
- Richardson/Watson: Ch. 1, Using Business Analytics to Address Business Questions (Textbook Powerpoint slides) [ .pptx ]
- Lecture: Introduction to Data and Analytics [ .pptx ]
- Library: Moss (Zara/Dresses/Data/Profits)
- Question: Which elements of Zara's strategy are related to which theories from your prior courses?
- Question: Which elements of Zara's strategy employ which elements of Analytics?
- Lecture: Basic Excel and Canvas
- Excel file management (with Canvas)
Week 3: Mon. Sep 9, 2024
- Richardson/Watson: Ch. 2, An Introduction to Business Data Sources (Textbook Powerpoint slides) [ .pptx ]
- Richardson/Watson: Appendix E, Installing Excel's Analysis Toolpak Add-in
- Richardson/Watson: Appendix F, Installing Excel's Solver Add-in
- Lecture: Locating and Using Quality Data Sources
- Library: Lin (Farmers' Data Surplus)
- Library: Pohle (AirBnB Reviews)
- Lecture: Introductory Excel
- ACME Sales [ .xlsx ]
- ACME Sales [ .csv ] (may need to press "Alt" and click to load into Excel)
- Menus, Ribbon, Files (.csv/.xlsx/.pdf), Formatting (numbers, lines, other)
- Quick Navigation (keyboard), Freeze Panes, Inserting/Deleting Rows, Basic Functions, Getting Help
- Relative/Absolute References, InterWorksheet References, Copy/Paste Special
- Installing Analysis Toolpak, Installing Solver Addin
- Lecture: Introductory Excel (try it on your own)
- ACME Performance Evaluation [ .xlsx ]
- ACME Performance Evaluation [ .csv ] (may need to press "Alt" and click to load into Excel)
Week 3: Wed. Sep 11, 2024
- Richardson/Watson: Ch. 6, Using Data Visualization
- Lecture: Visualization in Excel and PivotTables/Charts in Excel
- ACME Sales [ .xlsx ]
- Data Sort, Data Filter
- Data Dictionary
- Exploratory Graphing, Results Graphing
- Pre-Charting/Wrangling, Types of Charts (Continuous data/Discrete data), Formatting, Documentation
- Pivot Tables
- Pivot Charts
- Lecture: Visualization in Excel and PivotTables/Charts in Excel (try it on your own)
- ACME Performance Evaluation [ .xlsx ]
Week 4: Mon. Sep 16, 2024
- Due: Assignment: Data Opportunity/Challenge Essay
- Richardson/Watson: Ch. 3, Statistics and Tools Required in Business Analytics (Sections 3.1 - 3.5)
- Library: Cheng (Logarithms)
- Lecture: Using the Excel Data Analysis Tools (Menu | Data | Data Analysis)
- ACME Sales Profit/Loss Descriptive Statistics [ .xlsx ]
- Descriptive Analytics - Rank and Percentile, Descriptive Statistics
- Diagnostic Analytics - Histogram, z-Test, t-Test, F-test, Analysis of Variance (ANOVA)
- Predictive Analytics - Correlation, Regression
- Other (FIN) - Covariance
- Other (MKT) - Sampling
- Other (SOM 306) - Exponential Smoothing, Moving Average
- Other (misc.) - Random Number Generation
- Other (Engineering) - Fourier Analysis
- Lecture: Using the Excel Data Analysis Tools (Menu | Data | Data Analysis) (try it on your own)
- ACME Performance Evaluation [ .xlsx ]
Week 4: Wed. Sep 18, 2024
- Presentation (Fall, 2024): President Alejandra Castillo and Vice-President of Communications Katrina Estrada, Financial Management Association (.html), Presentation (.pdf), Flyer (.pdf)
- Lecture: Team Assignment
- Lecture: Data Analytics Case choices [ .pdf ] (Thu. Sep 19, 2024)
- Richardson/Watson: Ch. 3, Statistics and Tools Required in Business Analytics (Sections 3.6 - 3.7)
- Lecture: Exploratory Data Analysis (Descriptive Analytics)
- ACME Sales [ .xlsx ]
- Measures of Central Tendency - Mean, Median, Mode
- Measures of Dispersion - Range, Variance, Standard Deviation, Skewness, Kurtosis
- ACME Sales Profit/Loss t-test [ .xlsx ]
- ACME Sales Profit/Loss Histogram [ .xlsx ]
- Ratios - Coefficent of Variation
- Lecture: Exploratory Data Analysis (Descriptive Analytics) (try it on your own)
- ACME Performance Evaluation [ .xlsx ]
Week 5: Mon. Sep 23, 2024
- (please remember to sit with your team for the rest of the semester)
- Presentation (Fall, 2024): (speaker tbd), Volunteer Income Tax Assistance (VITA) (.html)
- Richardson/Watson: Ch. 3, Statistics and Tools Required in Business Analytics (Section 3.8, part 1 of 2)
- Library: Hopkins (Evaluating Drug Efficacy)
- Library: Glickman (Rite Aid's AI/Facial Recognition)
- Lecture: Hypothesis Test ('June at the Multiplex' Case)
- Supplemental: Case Text - [ .pdf ]
- Supplemental: Case Questions - [ .pdf ]
- Supplemental: Case Data File - [ .xlsx ]
- Supplemental: Case Analysis - [ .pptx ]
- Supplemental: Case Solution Data File - [ .xlsx ]
- Lecture: Hypothesis Tests in Excel (Diagnostic Statistics)
- z-Test (use for discrete data, e.g., proportions)
- t-Test (use for continuous data e.g., intervals)
- Confidence Intervals
- Lecture: Hypothesis Tests in Excel (Diagnostic Statistics) (try it on your own)
- ACME Performance Evaluation [ .xlsx ]
Week 5: Wed. Sep 25, 2024
- (no class, just work in your teams)
- Richardson/Watson: Ch. 3, Statistics and Tools Required in Business Analytics (Section 3.8, part 2 of 2)
- Video Clip(s): Big Bang Theory (clip) Hypothesis Testing - "The Fuzzy Boots Corollary" (Season 1, Disk 1, Episode 3) (YouTube clip) [ .html ]
- (contingency)
Week 6: Mon. Sep 30, 2024
- Richardson/Watson: Ch. 3, Statistics and Tools Required in Business Analytics (Section 3.8)
- Lecture: Hypothesis Test ('June at the Multiplex' Case, continued, if needed)
- Library: Smith (Predicting Swimsuit Sales)
- Lecture: Linear Regression in Excel (Predictive Statistics)
- ACME Sales [ .xlsx ]
- Scatterplots, Correlation
- Simple (single independent variable) Linear Regression
- Lecture: Linear Regression in Excel (Predictive Statistics) (try it on your own)
- ACME Performance Evaluation [ .xlsx ]
Week 6: Wed. Oct 2, 2024
- Due: First, second, and third Data Analytics Case choices
- Lecture: Description of Data Analytics Case deliverables: analysis (written and presentation) [ .html ]
- Richardson/Watson: Ch. 4, Business Analytics (Descriptive and Diagnostic Analytics)
- Library: King (Cellphone Data/Retailers)
- Library: Tau (Spy Agencies Know Your Secrets)
- Ethical Decision-making [ .pptx ] (Sat. Jul 16, 2022)
- Supplmental: Artificial Intelligence: The Global Landscape of Ethical Guidelines (Nature Journal) [ .pptx ]
- Supplmental: A Guide to Ethical Data Science (Royal Statistical Society) [ .pptx ]
Week 7: Mon. Oct 7, 2024
- Richardson/Watson: Ch. 5, Confirmatory Business Analytics (Predictive Analytics and Prescriptive Analytics)
- (contingency)
Week 7: Wed. Oct 9, 2024
- Richardson/Watson: Ch. 12, Putting It All Together: Three Capstone Projects
- Library: Whelan (Disney Pay Dispute)
- (contingency)
Week 8: Mon. Oct 14, 2024
- Lecture: Analysis of Disney Gender Pay Gap Dispute
- Lecture: Questions, Exploratory Visualizations, Descriptive Analytics, Diagnostic Analytics, and Predictive Analytics
- Disney Salary Data [ .xlsx, .csv ]
- Lecture: Intermediate Excel (Introduction to Multiple Linear Regression)
- statistical significance (want high "t's and low p's)
- R-squared (the variance in Y explained by the variance in X or X's)
- 'dummy' variables (use for categorical variables)
- 'parsimony' (the best, elegant solution--that is, the highest R-squared with the smallest number of X's)
- Lecture: Intermediate Excel (Simple Data Joins and Queries)
- ACME Sales [ .xlsx ]
- Special Tools: =VLOOKUP, =DSUM, =DCOUNT, =DAVERAGE
- Example: =VLOOKUP [ .xlsx ]
- Example: =DSUM [ .xlsx ]
- Lecture: Intermediate Excel (Simple Data Joins and Queries) (try it on your own)
- ACME Performance Evaluation [ .xlsx ]
Week 8: Wed. Oct 16, 2024
- Activity: Personal Reflection #1
- Mid-course Team Evaluation
- Activity: Informal Team Evaluation [ .pdf ] (Sat. Aug 5, 2023)
- Activity: Performance Improvement [ .pptx ] (Sun. Apr 14, 2024)
- Activity: Team meeting with the Instructor (if necessary)
- Library: Rana (Trading on a Typo)
- Library: Needleman (Stock Symbol Gaffes)
- Supplemental: Data Analytics Case (Common Errors and Omissions) [ .pptx ] (Mon. Mar 4, 2024)
- Activity: Review Disney Data Analytics
- (contingency)
Week 9: Mon. Oct 21, 2024
Week 9: Wed. Oct 23, 2024
- Richardson/Watson: Ch. 7, Marketing Analytics
- Library: Flint (NFL Audience Data)
- Library: Zumbrun (Data Aren't Getting Better)
- Lecture: Intermediate Excel (Multiple Linear Regression)
- ACME Sales [ .xlsx ]
- Review of (Simple, single independent variable) Linear Regression
- Multiple (multiple independent variables) Linear Regression, Diagnostics/Issues
- Avoiding Multicollinearity
- Example: [ .xlsx ]
- Lecture: Intermediate Excel (Introduction to Analysis of Variance)
- Lecture: Intermediate Excel (Multiple Linear Regression) (try it on your own)
- ACME Performance Evaluation [ .xlsx ]
Week 10: Mon. Oct 28, 2024
- Richardson/Watson: Ch. 8, Accounting Analytics
- Library: Maurer (Disclosure Data)
- Library: Maidenberg (OpenTable Data)
- Lecture: Intermediate Excel (Analysis of Variance-Review)
- Lecture: Intermediate Excel (Locking Cells and Protecting Sheets)
- Lecture: Intermediate Excel (Named Ranges)
- Lecture: Intermediate Excel (Reproducible Spreadsheets)
- ACME Sales [ .xlsx ]
- Using Analysis Toolpack
- When to use built-in functions
- When to use custom mathematical functions
- Other aspects of Extraordinarily Well-Documented Spreadsheets
- Useful functions in Accounting spreadsheets
- Lecture: Intermediate Excel (Reproducible Spreadsheets) (try it on your own)
- ACME Performance Evaluation [ .xlsx ]
Week 10: Wed. Oct 30, 2024
- Richardson/Watson: Ch. 9, Financial Analytics
- Library: Eaglesham (Insurers/Risk)
- Library: Cheng (Exponentials)
- Lecture: Intermediate Excel (Financial Functions)
- Activity: Canvas Lab Assignments (to be done in class with a student laptop)
- Lecture: Intermediate Excel (Reproducible Spreadsheets) (try it on your own)
- ACME Performance Evaluation [ .xlsx ]
- (contingency)
Week 11: Mon. Nov 4, 2024
- Richardson/Watson: Ch. 10, Operations Analytics
- Library: Beaton (The Craziest NFL Day)
- Library: Henderson (Quantum Computing/Airport Connections)
- Lecture: Opimization (Linear Programming)
- Video Clip(s): Big Bang Theory (clip) Optimization - "The Financial Permeability" (Season 2, Disk 3, Episode 14) (YouTube clip) [ .html ]
- Lecture: Excel Solver (Mathematical Optimization/Linear Programming)
- (SOM 306, Production) Dessert Diet ('Minimization' Problem) Set-up [ .xlsx ]
- (SOM 306, Production) Dessert Diet ('Minimization' Problem) Solution [ .xlsx ]
- (MKT 304, Operations) Greek Foods ('Maximization' Problem) Set-up [ .xlsx ]
- (MKT 304, Operations) Greek Foods ('Maximization' Problem) Solution [ .xlsx ]
- (FIN 303, Investment Portfolios) (tbd) Set-up
- (FIN 303, Investment Portfolios) (tbd) Solution
- (MGT 360, Staffing) Persons-Tasks ('Assignment' Problem) Set-up [ .xlsx ]
- (MGT 360, Staffing) Persons-Tasks ('Assignment' Problem) Solution [ .xlsx ]
- Library: Levinson (Efficient to a Fault)
Week 11: Wed. Nov 6, 2024
- Due: Assignment: Data Analytics Case (Written)
- Richardson/Watson: Ch. 11, Advanced Analytics
- Library: Bousquette (GM Third-Party Apps)
- Lecture: Other Excel Capabilities (Automation/Programming)
- ACME Sales [ .xlsx ]
- Macros (Automatically recorded keystrokes)
- Visual Basic For Applications (VBA)
- PowerBI (Excel 'Business Intelligence' addin--slightly better Data Analysis)
- Lecture: Other (Excel) Statistical Methods
- Analysis of Variance (ANOVA) (hypothesis testing but when there are more than two groups)
- Time Series/Forecasting (when the x-axis is time)
- Maps/Geography (set Data Type = 'Geography' for Zip Code or Lat/Lon column)
- Lecture: Other (non-Excel) Statistical Methods
- Classification analysis (like regression, but the dependent Y variable is a categorial/qualitative variable such as "yes/no")
- Logistic Regression analysis (like regression, but the relationship between X and Y is a curve not a line)
- Cluster analysis (segment the rows/observations into distinct categories)
- Lecture: Other (non-Excel) Tools
- Other GUI Spreadsheets - Google Sheets (part of Google Docs), Apple Numbers (comes with MacOS), LibreOffice (open source, all OSs)
- Other CSUN Business Analytics GUI Applications - SPSS (students get it free for a year)
- Other Business Analytics GUI Applications
- 'Automated' Business Analytics GUI Applications - Alteryx, Qlik
- CLI Programming Applications (more academic, more statistical) - R (sample in the web, webr), (download, free download, CRAN)
- CLI Programming Applications (more business, more general purpose) - Python free download, Anaconda Python
- (contingency)
Week 12: Mon. Nov 11, 2024
- (no class, Veterans Day Holiday)
Week 12: Wed. Nov 13, 2024
- Lecture: Presenter Team's Responsibilities
- Supplemental: Requirements for Oral Presentations [ .pdf ]
- Supplemental: Formatting Requirements for Presentation Deliverables [ .pdf ]
- Lecture: Presentation Examples (Powerpoint presentations from my prior BUS 302 classes) [ .pptx ]
Week 13: Mon. Nov 18, 2024
- Lecture: Audience Teams' Responsibilities
- Lecture: Discussion ("Challenge") Question Template [ .pdf ]
- (contingency)
Week 13: Wed. Nov 20, 2024
- (no class - just practice your presentations)
- (contingency)
Week 14: Mon. Nov 25, 2024
- Due: Data Analytics Case (Presentation) - Team 1
- Due: Data Analytics Case (Presentation) - Team 2
Week 14: Wed. Nov 27, 2024
- Due: Data Analytics Case (Presentation) - Team 3
- Due: Data Analytics Case (Presentation) - Team 4
Week 15: Mon. Dec 2, 2024
- Due: Data Analytics Case (Presentation) - Team 5
- Due: Data Analytics Case (Presentation) - Team 6
Week 15: Wed. Dec 4, 2024
- Due: Data Analytics Case (Presentation) - Team 7
- Due: Data Analytics Case (Presentation) - Team 8
Week 16: Mon. Dec 9, 2024
- Supplemental: Upward (or Outward) Influence [ .pptx ] (Fri. Dec 13, 2024)
- Activity: Personal Reflection #2
- Activity: Formal Team Evaluation
- (Fall: student evaluations of faculty) (please complete by Tue. Dec 10 at 11:59pm) [ .html ]
- Learning Excel Through Practice (What Data are You Passionate About?)
- by Individual Passion - Rescued Dogs, Spayed/Neutured Cats, Entrepreneurship, Latin America, US/Mexico Trade
- by Your Economic Life - online trading/investing, online gaming
- by Your Personal Life - wearables (e.g., Fitbit, Apple Watch, Oura Ring, Blood Glucose Monitor)
- by Sport - MLS, WNBA, NFL, MLB, College, et al.
- by Major/Career - Acct (SEC EDGAR, CalcBench), FIN (Google Finance)
- by Gov't Jurisdiction - City-level, County-level, State-level, Federal-level
- in CSUN Library ('Statistical Data') - DataPlanet, US Census, Statista, US Trade Online
- by courses this semester - FIN/SOM/MKT, core or elective (reproduce a paper problem or calculator problem in Excel)
- by courses next semester - FIN/SOM/MKT, core or elective (get the syllabus/outline/book, try a couple of exercises)
- Additional Software Tools (What Software Might You Need or Want?) - myCSUNsoftware (Apporto) [ .html ]
- (note: *any* student can run *any* software-the following are just examples)
- Accounting majors - Tableau (like PivotTables and Powerpoint combined...and more powerful)
- Business Analytics majors - Power BI Desktop (partly automated analysis), R/RStudio (statistics, command-line interface)
- Finance majors - (install and run Python on your own computer--and learn machine learning too)
- Information Systems majors - Microsoft Access (databases), Microsoft Visio (diagrams)
- Marketing majors - IBM SPSS (statistics, graphical user interface)
- Systems and Operations majors - Microsoft Project (project management)
- Upcoming events (What Can You Learn About Data with Others?)
- 'Data Con LA' - Sat. Nov. 16., 2024 at CSU Long Beach, inexpensive [ .html ]
- (contingency)
Finals Week: Wed. Dec 11, 2024
- Note: Special Time - (10:15am - 11:15am)
- Note: This day and time needs to be verified by each student individually in SOLAR after the beginning of the semester (especially to make sure there are no conflicts).
- Exam: Final Exam