Spreadsheets in the Curriculum

Spreadsheets are one of those tools that quietly fit into almost every subject—you just have to frame them around what students are already learning. Here’s a broad, practical set of ideas across different high school classrooms:

Math

• Model linear, quadratic, and exponential functions with tables and graphs

• Explore statistics: mean, median, standard deviation, distributions

• Run probability simulations (dice rolls, random events)

• Solve systems of equations using tables

• Investigate sequences and series (e.g., compound growth)

• Sample file : linear, polynomial, exponential functions - Trendlines

 Science (Biology, Chemistry, Physics)

• Record and graph lab data (temperature vs. time, velocity, etc.)

• Analyze experimental error and calculate averages

• Model population growth or decay (e.g., bacteria, ecosystems)

• Track chemical reaction rates

• Use formulas to calculate force, acceleration, or energy

• Sample File: Bond energy - Show how reaction energy is caculated

Social Studies / History

• Create timelines with sortable data

• Analyze census or economic data (population, GDP, employment)

• Compare historical trends (e.g., inflation, migration patterns)

• Budget simulations for historical scenarios (e.g., wartime economies)

• Track election results and visualize voting patterns

• Study underlying causes of a Conflict 

• Sample Files: Causes of the Civil War

English / Language Arts

• Track reading progress or vocabulary development

• Analyze word frequency in a text (basic text data work)

• Organize research sources and citations

• Plan essays with structured outlines

• Peer review tracking and feedback logs

• Sample File:  American Literary Works

Business / Economics

• Build budgets (personal finance, business startup costs)

• Simulate stock market investments and track gains/losses

• Analyze supply and demand data

• Create profit/loss statements

• Forecast revenue using trends

Sample File: Loan calculations

 Art / Design

• Plan project timelines and materials lists

• Budget for art supplies or exhibitions

• Track creative project progress

• Analyze survey data on design preferences

• Organize portfolios or submissions

• Sample Files: Famous American works of art

Computer Science / Tech

• Introduce basic data analysis and visualization

• Teach logic through formulas (IF statements, conditions)

• Work with datasets (sorting, filtering)

• Simulate simple algorithms or decision trees

• Connect spreadsheets to coding concepts (data structures)

Health

• Track fitness goals (steps, heart rate, workouts)

• Analyze nutrition logs (calories, macros)

• Monitor progress over time with charts

• Study trends in sleep or activity levels

• Set and evaluate personal health goals

• Sample File :  Diet and Nutrition - Health related issues

Physical Education

• Track fitness goals (steps, heart rate, workouts)

• Analyze nutrition logs (calories, macros)

• Monitor progress over time with charts

• Study trends in sleep or activity levels

• Set and evaluate personal health goalss

• Sample File: Baseball Standings and Statistics