Published by Pearson (August 31, 2023) © 2024
Spreadsheet Basics
A.1 Introduction to Spreadsheets
A.2 Built-in Functions
A.3 Charts
Chapter 1: An Excel-lent Approach to Relationships
1.1 Functions
1.2 Analytic Representations: Equations
1.3 Numerical and Graphical Representations: Tables and Charts
1.4 Spotlight on Statistics
Chapter 2: Ratios and Proportions
2.1 Ratios and Proportions
2.2 Weighted Averages
2.3 Proportionality
2.4 Financial Literacy
2.5 Spotlight on Statistics
Chapter 3: Units, Conversions, Scales, and Rates
3.1 Units and Conversions
3.2 Scales
3.3 Rates
3.4 Dosages and Concentrations
3.5 Spotlight on Statistics
Chapter 4: Percentages
4.1 Percentages
4.2 Part-to-Whole Ratios
4.3 Percent Change and Difference
4.4 Data Tables with Percentages
4.5 Spotlight on Statistics
Chapter 5: Linear Functions
5.1 Proportionality
5.2 Slopes and y-intercepts
5.3 Linear Equations
5.4 Spotlight on Statistics
Chapter 6: Exponential Functions
6.1 Constant Percent Change
6.2 Exponential Functions
6.3 Average Percent Change
6.4 Spotlight on Statistics
Chapter 7: Logical Arithmetic
7.1 Logarithms
7.2 Doubling Times and Half-Lives
7.3 Annual Percentage Yield
7.4 Continuous Growth and Euler’s Number: e
7.5 Spotlight on Statistics
Chapter 8: Curve Fitting and Correlation
8.1 Correlation, Causation, and Confounding Factors
8.2 Best-Fit, Least-Squares, and Regression Lines
8.3 Correlation Coefficient and Coefficient of Linear Determination
8.4 Spotlight on Statistics
Chapter 9: Financial Health
9.1 Retirement
9.2 Securities: Cash, Stocks, Mutual Funds, and Bonds
9.3 401(k) Plans
9.4 Built-in Financial Functions
9.5 Loans
Chapter 10: Logically!
10.1 Logical Statements
10.2 Excel’s IF Function
10.3 VLOOKUP
10.4 Random Simulations
Chapter 11: Chance, Risk, and Likelihood
11.1 Risk and Decision Making
11.2 Probability and Counting
11.3 Conditional Probabilities
11.4 Unions and Complements
11.5 Spotlight on Statistics
NEW - Chapter 12: Statistically Speaking
12.1 Data Distributions: Frequency and Probability
12.2 Binomial and Normal Distributions
12.3 Sampling Distributions and Confidence Intervals
12.4 Hypothesis Testing
NEW - Chapter 13: Modeling the Real World
13.1 Modeling Basics
13.2 Rate (Population) Models
13.3 Stochastic (Random) Models
13.4 Linear Programming (Optimization) Models
13.5 Spotlight on Statistics
Play
They say you can’t judge a book by its cover. It’s the same with your students. Meet each one right where they are with an engaging, interactive, personalized learning experience that goes beyond the textbook to fit any schedule, any budget, and any lifestyle.
Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.