Spreadsheet Lab Manual (SLM) was established in 2008, organized and incorporated in 2018. SLM is fully-remote, professional learning community (PLC) and educator support platform dedicated to sharing standardized spreadsheet-based mathematical models.
What does EVERY SLM Lesson have?
1. ALL students first code a spreadsheet model
2. Students then interact with the model they built
HOW? SLM gives detailed, exact, evidence-based* procedures. These enable math to be automated on Excel or Sheets then studied with inquiry and experimentation.
SLM is instructional materials and training. SLM enhances mathematical capability, such as capacity to experiment with physical phenomena, to both teachers and their students. Other benefits: growth in skills on spreadsheets and data fluency.
*Evidence-based means delivered in practice to a student group with known outcome.
SLM Requires only Microsoft Office or Google Suite of products.
PLC Inquiring, New or Prospective Members: email [email protected] from your school email address to request a meeting. or sign up on the contact page.
Click to Download: Spreadsheet Lab Manual Fact Sheet
Pedagogical Description: Spreadsheet modeling is programming/coding a spreadsheet to depict models of STEM phenomena. Students can first code and then interact with a math model by performing actual experimentation, aligned to the Next Generation Science Standards (NGSS). SLM modules provide teachers with a comprehensive resource offers credentialed PD training, as well as instructional materials with a unified, standardized approach to math modeling on a spreadsheet. Delivers 21st century skills, multiple independent, on-level, evidence-based STEM learning outcomes for students.
How it works: Coding a spreadsheet model is akin to automating math. It can use simple (ideal or linear) formulas to model complex (continually changing, non-ideal) phenomena. This enables study by inquiry. Result: Students make sense of math naturally. Users can code and then simulate any quantitative phenomenon with observable, meaningful and engaging numerical and graphical outputs on spreadsheets.
What does EVERY SLM Lesson have?
1. ALL students first code a spreadsheet model
2. Students then interact with the model they built
HOW? SLM gives detailed, exact, evidence-based* procedures. These enable math to be automated on Excel or Sheets then studied with inquiry and experimentation.
SLM is instructional materials and training. SLM enhances mathematical capability, such as capacity to experiment with physical phenomena, to both teachers and their students. Other benefits: growth in skills on spreadsheets and data fluency.
*Evidence-based means delivered in practice to a student group with known outcome.
SLM Requires only Microsoft Office or Google Suite of products.
PLC Inquiring, New or Prospective Members: email [email protected] from your school email address to request a meeting. or sign up on the contact page.
Click to Download: Spreadsheet Lab Manual Fact Sheet
Pedagogical Description: Spreadsheet modeling is programming/coding a spreadsheet to depict models of STEM phenomena. Students can first code and then interact with a math model by performing actual experimentation, aligned to the Next Generation Science Standards (NGSS). SLM modules provide teachers with a comprehensive resource offers credentialed PD training, as well as instructional materials with a unified, standardized approach to math modeling on a spreadsheet. Delivers 21st century skills, multiple independent, on-level, evidence-based STEM learning outcomes for students.
How it works: Coding a spreadsheet model is akin to automating math. It can use simple (ideal or linear) formulas to model complex (continually changing, non-ideal) phenomena. This enables study by inquiry. Result: Students make sense of math naturally. Users can code and then simulate any quantitative phenomenon with observable, meaningful and engaging numerical and graphical outputs on spreadsheets.
Past Speaking Events:
Presenter: Chesapeake Area AAPT Spring Conference (2023).
NJ AAPT Demo Day
July 13-17, 2020 Harvard University Workshop:
Harvard VIRTUAL Workshop: Building a Network to Support and Improve High-School Physics Education
AAPT National Conference. July 19-21, 2020
Chicago Public Schools Googlepalooza August 17-21, 2020 Presenter.
Save Time + Add Learning Value: HOW? Lessons Naturally Differentiate, Rapidly Customize, Provide Unlimited Enrichment Possibilities, Empower Teachers and Students with Data Fluency and Interactive, Multi-modal, Mathematical Modeling in Physics, Chemistry, Biology and Math at the high school, Community College, and University Level.
2 Student Engagement Tasks:
Task 1: Model Development Task 2: Experimentation, Analysis
Task 1: Model Development Task 2: Experimentation, Analysis
Multiple Points of Assessment: (1) Every student succeeds at programming the spreadsheet model using the steps that precisely guide them (starting from a blank spreadsheet or blank template file). (2) After verifying the model is programmed correctly experimentation is done by altering variables. This enables students to interact with graphs and directly observe model predictions. Interacting with the model in this way helps students learn about the mathematical nature of Science through investigation and discovery while gaining skills on spreadsheets simultaneously.
SLM lessons are truly multidisciplinary, NGSS aligned and engage students in all 8 Science and Engineering Practices despite being written years ahead their adoption.
SLM lessons are truly multidisciplinary, NGSS aligned and engage students in all 8 Science and Engineering Practices despite being written years ahead their adoption.
3 Fundamental Priorities in Pioneering SLM:
- Grow Student Data Fluency: Enhance productivity with spreadsheets (both for future applications and productivity in learning)
- Innovative Computational Models with Sound Science: Aligned to NGSS high school STEM curriculum content
- Easy to Implement: Across all disciplines, all starting skill levels for students and teachers, many ways to differentiate instruction, highly engaging and self guiding so students learn at their own pace with a minimal teacher time investment.