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
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
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
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
5. Linear Functions
5.1 Proportionality
5.2 Slopes and y-intercepts
5.3 Linear Equations
5.4 Spotlight on Statistics
6. Exponential Functions
6.1 Constant Percent Change
6.2 Exponential Functions
6.3 Average Percent Change
6.4 Spotlight on Statistics
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
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
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
10. Logically!
10.1 Logical Statements
10.2 Excel’s IF Function
10.3 VLOOKUP
10.4 Random Simulations
Appendix: Spreadsheet Basics
A.1 Introduction to Spreadsheets
A.2 Built-in Functions
A.3 Charts
Eric Gaze is a well-known leader in the quantitative reasoning community. He directs the Quantitative Reasoning (QR) program at Bowdoin College in Maine, and is a Lecturer in the Mathematics Department. He is the current President of the National Numeracy Network (NNN 2013—15). Eric has given talks and led workshops on the topics of QR Across the Curriculum, Creating a QR Entry Point Course, Writing with Numbers, QR Assessment, and Running a QR Program; and has served on review teams of QR programs. He is the Principal Investigator for a NSF TUES Type I grant (2012—14), Quantitative Literacy and Reasoning Assessment (QLRA) DUE 1140562. This collaborative project builds on Bowdoin College's QR instrument which is used for advising purposes and is available to interested schools. Prior to coming to Bowdoin, Eric led the development of a Masters in Numeracy program for K—12 teachers at Alfred University as an Associate Professor of Mathematics and Education.
 |
Ask a Question About this Product More... |
|
