Instructor resources
A week-by-week teaching plan for the released chapters. Each week pairs a chapter with the datasets it uses, the Excel skills it builds, and a suggested assignment. Dataset mappings are the author's best fit and may be adapted freely under the CC BY 4.0 license.
| Week | Chapter | Topics | Datasets | Excel skills | Suggested assignment |
|---|---|---|---|---|---|
| Week 1 | What Healthcare Data Analytics Is and Why It Matters | Topics: data, information, insight, and action; the four types of analytics; the four domains of healthcare analytics; why healthcare is a distinctive analytics environment | Datasets: DS2_appointments_clean.csv, DS1_facility_dim.csv | Excel skills: opening a CSV in Excel; navigating a large file | Assignment: compute the overall no-show rate from the appointment file and write a one-paragraph interpretation of what it does and does not show |
| Week 2 | Understanding Healthcare Systems, Stakeholders, and Data Sources | Topics: care settings and the continuum of care; patients, payers, providers, and regulators; source systems; primary versus secondary use; dimension versus fact tables | Datasets: DS4_inpatient_clean.csv, DS5_claim_header_clean.csv, DS2_appointments_clean.csv | Excel skills: inspecting table structure; freeze panes and filters for data exploration | Assignment: trace three fields in the inpatient file to their source systems and state each field's primary operational use |
| Week 3 | Excel as the Analyst's Workbench | Topics: the four-layer workbook; Excel Tables and structured references; named ranges; the analyst's function core; Power Query, PivotTables, the Analysis ToolPak, and Solver; validation and formula auditing | Datasets: DS2_appointments_clean.csv | Excel skills: Excel Tables; structured references; named ranges; COUNTIFS; XLOOKUP; data validation | Assignment: rebuild the no-show rate workbook with raw, analysis, and output sheets using structured references throughout |
| Week 4 | Working with Data: Structure, Measures, and Study Design | Topics: tidy data; quantitative and qualitative variable types; primary and foreign keys; joins and the star schema; unit of analysis; defining measures; observational studies, experiments, and sampling | Datasets: DS1_patient_dim.csv, DS2_appointments_clean.csv, DS8_sampling_scenarios.csv, DS8_studies_master.csv | Excel skills: PivotTables for regrouping grain; XLOOKUP joins; COUNTIFS for defined groups | Assignment: change the unit of analysis from visits to patients with a PivotTable and explain how and why the count changes |
| Week 5 | Healthcare Coding, Terminology, Governance, Privacy, and Ethics | Topics: ICD-10-CM, CPT, SNOMED CT, and other code systems; coding and payment incentives; data governance; HIPAA privacy and the minimum necessary standard; bias and ethics | Datasets: DS5_claim_header_clean.csv, DS4_inpatient_clean.csv | Excel skills: lookup tables for grouping codes; TEXT functions for code formats; filtering by group | Assignment: group diagnosis chapters with a lookup table and chart claim denial rates by group |
| Week 6 | Excel Foundations: Formulas, Functions, References, and Charts | Topics: worksheet navigation; writing formulas; relative, absolute, and mixed references; core calculation functions; descriptive statistics; sorting, filtering, and charts; the one-page scorecard | Datasets: DS2_appointments_clean.csv, DS3_ed_throughput_clean.csv | Excel skills: reference types; SUM, COUNTIFS, SUMIFS, AVERAGEIFS, IF; MEDIAN, STDEV.S, MIN, MAX; sorting, filtering, and chart selection | Assignment: build a one-page clinic scorecard that recalculates itself when the data changes |
| Week 7 | Importing Data and Building a Reusable Excel Workflow | Topics: to be announced | Datasets: to be announced | Excel skills: to be announced | Assignment: to be announced |
| Week 8 | Cleaning, Transforming, and Validating Data | Topics: to be announced | Datasets: to be announced | Excel skills: to be announced | Assignment: to be announced |
| Week 9 | Summarizing Data: Descriptive Statistics and Grouping | Topics: to be announced | Datasets: to be announced | Excel skills: to be announced | Assignment: to be announced |
| Week 10 | Distributions, Variation, and Statistical Inference | Topics: to be announced | Datasets: to be announced | Excel skills: to be announced | Assignment: to be announced |
| Week 11 | Data Visualization, Dashboards, Benchmarking, and Performance Monitoring | Topics: to be announced | Datasets: to be announced | Excel skills: to be announced | Assignment: to be announced |
| Week 12 | Simple Linear Regression for Numerical Outcomes | Topics: to be announced | Datasets: to be announced | Excel skills: to be announced | Assignment: to be announced |
| Week 13 | Multiple Linear Regression and Holding Factors Constant | Topics: to be announced | Datasets: to be announced | Excel skills: to be announced | Assignment: to be announced |
| Week 14 | Logistic Regression for Binary Outcomes and Risk Stratification | Topics: to be announced | Datasets: to be announced | Excel skills: to be announced | Assignment: to be announced |
| Week 15 | Applied Healthcare Analytics, Decision Support, and Capstone Communication | Topics: to be announced | Datasets: to be announced | Excel skills: to be announced | Assignment: to be announced |
Adopting this book
The book text and figures are licensed CC BY 4.0: reuse, remix, and redistribute them, even commercially, with attribution to Hoshiar J Sher, EdD. All teaching datasets are fully synthetic and free to use for teaching and practice. Build scripts are MIT licensed. Questions about adoption are welcome through the source repository.