Spreadsheet Lab Manual (SLM) is the only pre-pandemic, federally-funded, fully-remote professional development and educator support platform dedicated to standardizing spreadsheet modeling in STEM instruction.
SLM provides evidence-based, (in-person or remote) learning outcomes with training and providing instructional materials that deliver data fluency skills and enhanced capability to experiment with physical phenomena to teachers and their students.
Requires only Microsoft Office or Google Suite of products.
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 capability, aligned to the Next Generation Science Standards (NGSS). SLM modules provide teachers with a comprehensive resource for 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 ideal/linear formulas to model continually changing, non-ideal phenomena. This enables guided inquiry study, so students make sense of math naturally by using observable, meaningful and engaging numerical and graphical outputs on spreadsheets.
SLM provides evidence-based, (in-person or remote) learning outcomes with training and providing instructional materials that deliver data fluency skills and enhanced capability to experiment with physical phenomena to teachers and their students.
Requires only Microsoft Office or Google Suite of products.
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 capability, aligned to the Next Generation Science Standards (NGSS). SLM modules provide teachers with a comprehensive resource for 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 ideal/linear formulas to model continually changing, non-ideal phenomena. This enables guided inquiry study, so students make sense of math naturally by using observable, meaningful and engaging numerical and graphical outputs on spreadsheets.
Past Speaking Events:
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.