ALL of the following shared capabilities are available via Google Drive through the SLM Forever License Training Program:

       SLM Table of Contents File (linked)


Every SLM Module...

• Provides a student procedure to code a math model (from a blank spreadsheet)

 

• Uses established variable conventions.

 

• Provides new student engagement method (by "automating" math)

 

• Delivers new capability, data skills and fluency

 

• Developed by practicing teachers. (evidence based)

 
The SLM file structure and user network is organized for collaboration as a shared Google Drive. Edit permissions are provided to all active users who are practicing professional teachers in every module PD folder.  Asynchronously collaborate with teachers across the USA. 


SLM is Computer Science for ALL delivered as a math modeling regimen for all STEM teachers. 

How SLM changes what students can do...

1. automates math which adds experimentation capability
2. transforms learning with actual engagement
3. unlocks and simplifies math* with help of computing power
4. adds skills that enhance STEM content learning

*this is done by linearizing continually changing (real life) phenomena by utilizing fundamental principles of calculus while at the same time making math more inclusive to students of all levels.  

SLM Instructional enhancements for teachers...

1. illustrates mathematical behavior/phenomena as you explain it
2. allows for highly realistic models with simplified math
3. easy to assess performance based learning
4. lessons can be instantly delivered to any student remotely

Capability you can share instantly with the SLM Forever License!
 


What's included in SLM? 

• 84 instantly deliverable lesson modules with standardized methodology across both Google Sheets an Microsoft Excel

Standardized coding procedures for students to build every model. And if a module does not meet your immediate student needs, a procedure to certify any modifications or preparation work needed as professional development hours. 


Earn Certified PD hours and SLM Forever License for any first time prep work for any module. Time is too valuable to spend trying to reinvent an already proven approach to computational modeling. 

​
​ 

PD With a Purpose. 
SLM usage in teaching practice leads to added fluency with math modeling and computing with spreadsheets. In addition skills become electronically sharable.  As teachers can then leverage this benefit to empower and advance student learning.  This is certified outcome for any teacher member of the SLM PLC as teachers earn certifications of fluency for the established SLM standard models.  

Get Training

Who should train?  Any educator wanting to realize the limitless value added of spreadsheets for STEM learning...  

SLM in action:  Titration Simulation Video  
Chemistry Module 302 Titration Simulation together a with hands-on lab helps students visualize and connect the math to the content.

SLM Teacher User: "I used the Titration spreadsheet to work out the mid and end points of titrations, which was a great help. The students I teach also loved the spreadsheet, easily applying it to their work to double check against their own calculations and constructing their own graphs."
​

​
Multiple representations (hands on + spreadsheet + analytical equation) together synthesize STEM learning:

1. Hands on labs and demonstrations (observation)
2. Spreadsheet based (Numerical and Graphical) models (express results)
3. Analytical equations (traditional problem solving)

Supplementing your already great instruction with SLM models enriches and enhances student learning by providing engagement.  The best and largest advances in learning happen due to the student engaging the model with instant responses (which modern students need) with readily observable, analytical connections (made clearly visible both while coding the model or clicking on a cell to display the cell to cell connections highlighted as part of basic spreadsheet function. 

See Video Demonstration:  SLM Standardized Gravitational Fields (with color coded scaffolding)

HOW?  Building and studying a spreadsheet-based mathematical model offers high value-added to STEM instruction. It synthesizes the above representations while accomplishing 3 primary goals: 

1. study STEM content standards
2. provide relevant 21st century skills
3. improve mathematical fluency

SLM modeling experiences accomplish all 3 simultaneously.  ​

Additional Spreadsheet Benefits: (fill handle replication of formulas in cells)

• Instant feedback loop enables inquiry and experimentation 
• Students reflect on the outcome of the calculation (an often omitted but essential step)
  • Students appreciate the importance and value added of the spreadsheet (psychological memory activation)
• Large numbers of calculations can be done (and redone) with immediate results (enhanced engagement)
• Redefines "possible": Unlocking previously impossible modeling examples and scenarios
  • This illustrates, utilizes fundamentals of calculus to model and build complex and continually changing (non-ideal) phenomena using only linear equations.

​What SLM can do for any teacher?

1. Turn Google Sheets into a powerful STEM learning resource and collaboration tool
2. Install math modeling anywhere to enhance the student experience
3. Share capabilities with students as quickly you can share a file
4. Choose from 100s of original math modeling applications

The professional educators at Spreadsheet Lab Manual LLC can organize a training regimen that is credentialed by deliverable student skills added for each module completed.  (PD certificates provided)

Benefits of Automation of Mathematical Formulas: 

• Enhance hands on labs with side by side simulation
• Accelerate mathematical thinking ​instantly and interactively
• Students experiment on and observe "living" graphs
• Instant feedback helps students internalize the Q & A process essential to learning

​

​Benefits of Standardization with Cross-Curricular Math Models:

• Gain familiarity with one, have it for all others. All modules apply the same proven pedagogy (saving time for both students and teachers) 
• Ease of collaboration: Community-wide tracking by module numbers
• Class-wide interaction in a spreadsheet model (students teach each other skills)
• As student fluency grows and skills sets are expanded, teach beyond "the basics" in pursuit of added depth of knowledge and enhancement of learning.

Propose to your colleagues and administration school wide initiative: Implement SLM during regularly scheduled PD time.  Then teachers can collaborate, share ideas, sequence skills coverage for all students. Divide up the work and multiply out the benefits.

This produces a homogeneous student experience across classes (and all curriculum content) regardless of who teaches the class. 

Get Started

SLM Pedagogy Explained:  Designed and tested by teachers, for teachers. 
*Each SLM Module has standardized and uniformly formatted file suffixes, which saves time and simplifies collaboration. 
     -0. Lesson Plan (.xls) - NGSS aligned with DCIs, SEPs and CCCs, objectives, content area, strategies, skills, assessment.
     -1.  Teacher Prep/PD Guild (.doc) - Quick start to prepare for class AND earn credentialed PD hours.
     -2. Student Handout (.doc) - Objective, Discussion, Programming Procedure, Guided Inquiry, and Assessment.
     -3. Introductory Slide Show (.ppt) - Quickly sets the objective and summarizes the modeling process for students.
     -4. Blank Template (.xls) - Saves class time by filling in data labels and column headings, students must still program the model.
     -5. Completed Spreadsheet (.xls) - Teachers have immediate access to completed models (to demo or provide the completed model to students).
     -6. Answer Key (.doc) - Describe how to solve every problem along with answers, sample solutions, sample writings. 


SLM Pedagogy is adaptive, video training will ensure that every student in any school can keep pace with the evolution of spreadsheet modeling.
1 - First time only prep work during PD time:  Access Teacher Preparation File-1 and follow procedure to review experience from student point of view. 
2 - Pre-Class prep:  Print/Post Files -2 (student handout doc file) and -4 (Blank Template sheets/xls file)
3 - Start of Class: Present Slides/ppt file -3 quickly and allow students build and then explore a math model.
4 - During Class:  Proctor (as students) Program and study the model.  During this time observe and assess their performance
5 - When grading & documenting evidence of learning:  Student Submissions on LMS (i.e. Google Classroom) include timestamped metadata.
Go back to step 1 any time before next time you teach it until you are satisfied with the outcome.  This has taken SLM this far, but only you can deliver it to your students. 
​
Subject Areas:  010 Level: Training, 100 - Mathematics, 200 - Physics, 300 - Chemistry, 400 - Biology/Environmental, 600 - Automotive  
Organizational Coding: Subject Area, Module #, - File Type (Biology, Genetics Simulation, Answer Key Code #: 405-6)

Spreadsheet Lab Manual Physics Module # 202 Terminal Velocity:
Comprehensive Module Applications Training Video (19 minutes) Play this video while exploring module files and preparing your lesson.
Free Sample Instructional Materials: Quick Prep Guide: Teacher Preparation and PD SOP file-1
202-​0. Terminal Velocity Lesson Plan (.xls) - NGSS DCIs: HS-PS2-1, HS-PS4-2, HS-ETS1-4   SEPs: 1-8 (All), CCCs: 1-4
202-1.  Terminal Velocity Teacher Preparation (.doc)
202-2.  Terminal Velocity Student Handout (.doc)
202-​3. Terminal Velocity Introductory Slide Show (.ppt)
202-4. Terminal Velocity Blank Template (.xls)
202-5. Terminal Velocity Completed Spreadsheet (.xls)
202-6.  Terminal Velocity Answer Key (.doc)
202S:  Supplement File (this contains supplemental teacher sourced questions, extensions and applications to this simulation)

Prepare, learn, and earn PD credit:   On July 1 2019, Spreadsheet Lab Manual LLC has been funded by the National Science Foundation Small Business Innovation Research (NSF SBIR Phase 1), America's Seed Fund, to innovate new products and bring them to market that will have a broad societal impact and benefit.  Seed-funding has accelerated Spreadsheet Lab Manual LLC to deliver the highest quality learning resources to teachers in pursuit of the public good and national interests to provide essential data analysis skills to students in a growing number of schools.  This has been further supported by the New Jersey Commission on Science, Innovation and Technology as an investment in STEM education.  Without the support of these agencies, this product offering would not be possible.