For faculty

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.

WeekChapterTopicsDatasetsExcel skillsSuggested assignment
Week 1What Healthcare Data Analytics Is and Why It MattersTopics: data, information, insight, and action; the four types of analytics; the four domains of healthcare analytics; why healthcare is a distinctive analytics environmentDatasets: DS2_appointments_clean.csv, DS1_facility_dim.csvExcel skills: opening a CSV in Excel; navigating a large fileAssignment: 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 2Understanding Healthcare Systems, Stakeholders, and Data SourcesTopics: care settings and the continuum of care; patients, payers, providers, and regulators; source systems; primary versus secondary use; dimension versus fact tablesDatasets: DS4_inpatient_clean.csv, DS5_claim_header_clean.csv, DS2_appointments_clean.csvExcel skills: inspecting table structure; freeze panes and filters for data explorationAssignment: trace three fields in the inpatient file to their source systems and state each field's primary operational use
Week 3Excel as the Analyst's WorkbenchTopics: 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 auditingDatasets: DS2_appointments_clean.csvExcel skills: Excel Tables; structured references; named ranges; COUNTIFS; XLOOKUP; data validationAssignment: rebuild the no-show rate workbook with raw, analysis, and output sheets using structured references throughout
Week 4Working with Data: Structure, Measures, and Study DesignTopics: 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 samplingDatasets: DS1_patient_dim.csv, DS2_appointments_clean.csv, DS8_sampling_scenarios.csv, DS8_studies_master.csvExcel skills: PivotTables for regrouping grain; XLOOKUP joins; COUNTIFS for defined groupsAssignment: change the unit of analysis from visits to patients with a PivotTable and explain how and why the count changes
Week 5Healthcare Coding, Terminology, Governance, Privacy, and EthicsTopics: 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 ethicsDatasets: DS5_claim_header_clean.csv, DS4_inpatient_clean.csvExcel skills: lookup tables for grouping codes; TEXT functions for code formats; filtering by groupAssignment: group diagnosis chapters with a lookup table and chart claim denial rates by group
Week 6Excel Foundations: Formulas, Functions, References, and ChartsTopics: worksheet navigation; writing formulas; relative, absolute, and mixed references; core calculation functions; descriptive statistics; sorting, filtering, and charts; the one-page scorecardDatasets: DS2_appointments_clean.csv, DS3_ed_throughput_clean.csvExcel skills: reference types; SUM, COUNTIFS, SUMIFS, AVERAGEIFS, IF; MEDIAN, STDEV.S, MIN, MAX; sorting, filtering, and chart selectionAssignment: build a one-page clinic scorecard that recalculates itself when the data changes
Week 7Importing Data and Building a Reusable Excel WorkflowTopics: to be announcedDatasets: to be announcedExcel skills: to be announcedAssignment: to be announced
Week 8Cleaning, Transforming, and Validating DataTopics: to be announcedDatasets: to be announcedExcel skills: to be announcedAssignment: to be announced
Week 9Summarizing Data: Descriptive Statistics and GroupingTopics: to be announcedDatasets: to be announcedExcel skills: to be announcedAssignment: to be announced
Week 10Distributions, Variation, and Statistical InferenceTopics: to be announcedDatasets: to be announcedExcel skills: to be announcedAssignment: to be announced
Week 11Data Visualization, Dashboards, Benchmarking, and Performance MonitoringTopics: to be announcedDatasets: to be announcedExcel skills: to be announcedAssignment: to be announced
Week 12Simple Linear Regression for Numerical OutcomesTopics: to be announcedDatasets: to be announcedExcel skills: to be announcedAssignment: to be announced
Week 13Multiple Linear Regression and Holding Factors ConstantTopics: to be announcedDatasets: to be announcedExcel skills: to be announcedAssignment: to be announced
Week 14Logistic Regression for Binary Outcomes and Risk StratificationTopics: to be announcedDatasets: to be announcedExcel skills: to be announcedAssignment: to be announced
Week 15Applied Healthcare Analytics, Decision Support, and Capstone CommunicationTopics: to be announcedDatasets: to be announcedExcel skills: to be announcedAssignment: 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.