To ALL US Educators: Spreadsheet Lab Manual (SLM) is YOUR only pre-pandemic, federally-funded, fully remote and automated professional development educator support network dedicated to standardizing spreadsheet modeling in STEM instruction. This grass-roots developed, modular curriculum was built over 15 years to address a growing need for all students and teachers. Being very rapidly differentiated, SLM pedagogy and training are high-value added teacher time investments. SLM delivers evidence-based, remote learning outcomes and sources data fluency skills and experimentation with physical phenomena to teachers. Ensuing time savings prior to lesson delivery boosts student outcomes in STEM learning at the time of instruction by enabling greater direct student support. 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.
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. High-value added adds (objective) + 21st century skills, multiple independent, on-level, evidence-based STEM learning outcomes for students.
US Educators Register by clicking HERE
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. High-value added adds (objective) + 21st century skills, multiple independent, on-level, evidence-based STEM learning outcomes for students.
US Educators Register by clicking HERE
Covid-19 US National STEM Educator CRISIS
RESPONSE PLAN: Free Teacher Resources
Covid-19 Pandemic Module # 403: COVID 19 Population Dynamics Spreadsheet Model Sandbox experimentation. INTRO VIDEO LINK (click here)
Pandemic simulation spreadsheet sandbox experience was written by Prof. Glenn Ledder of University of Nebraska Lincoln. Registered users can earn certified PD hours (registration is free through 2023, all content is permanently licensed to teachers who register and complete any PD hours prior to calendar year 2023)
SLM (Excel and Sheets) content free for any registered professional educator in the USA: We want local dollars to compensate teachers for their time. We only charge for direct Teacher PD support provided, NOT for instructional content.
Opt in for free membership (members will also earn "sweat equity" in the company that pays dividends based on total training hours and/or content contributed as part of your remote PD* (*upon securing NSF SBIR Phase 2 funding with the $91,000 profit margin of Phase 2 research)
Learn More... read on!
Director and Principal Investigator will Lead/Customize Your School PD Plan.
Priorities: inform and equip teachers to experiment remotely by training them with a Covid-19 pandemic sandbox sample population model with latest disease dynamics, (Modeled with NSF SBIR funding), enable innovation by teachers and students alike, define data fluency and action for growth for your students, propagate coding skills, learn to understand with mathematical modeling, multiple points of assessment for differentiation and calibrating for successful outcomes, innovate and develop new ideas, test and share.
(7/1/2019) ..........................................Federal Funding Press Release: Spreadsheet Lab Manual LLC is a federally funded professional learning community (PLC) of US educators. SLM equips teachers to succeed at achieving measurable skills growth. Every student and teacher that make the choice together to succeed will succeed.
Agency website: ...........................(NSF SBIR) ALL SLM MODULES WILL BE provided COMPLETELY FREE FOR ANY/ALL PROFESSIONAL PUBLIC EDUCATORS**: (PI Michael McConnell) **SEE ABSTRACT AND OPEN RESEARCH INVITATION (linked above)
Professional Educators Spreadsheet Modeling Remote Lesson Delivery Support: Email SpreadsheetLabManual@gmail.com and share module Watch Video Demo of Pedagogy in Physics, Chemistry, Biology: Table of Contents
5 STEPS to for teachers to deliver a customized, high-value-added student learning experience:
1. View 2018 SLM Intro Video (5 minutes) on SLM Pedagogy..................................and/or (2012 SLM Pedagogy Video 12 min 33 sec)
2. View the NSF SBIR: SLM PD Training Video that provides a complete illustration of the standardized pedagogy
3. Choose an SLM Module Number from the Table of Contents to Deliver to your students (5 minutes)
4. Email the SLM module number to spreadsheetlabmanual@gmail.com
5. Copy and Paste the lesson plan and follow teacher prep guidelines to customize, and deliver the introduction.
6. Collaborate with your colleagues to plan a unified, building-wide, NGSS aligned, 3D learning experience and literacy assessment with any available screen sharing audio/webinar.
SLM Real-Time Teacher/Administrator Instructional Support: Call (856)-418-6065
Upcoming Speaking Events:
July 13-17 Harvard University Workshop:
Harvard VIRTUAL Workshop: Building a Network to Support and Improve High-School Physics Education
AAPT National Fully Remote Conference. July 19-21 Silver Level Sponsorship.
After School Returns to Normal (or to a "new normal"): We will be certifying our member Teacher PD Hours Earned, Providing a Micro-Credentialed Data Fluency Skills Added Report Endorsing Every Participating Educator's Capacity to Remotely Deliver Spreadsheet Modeling Representations and Skills.
Save Time + Add Learning Value, Lessons Naturally Differentiate, Rapidly Customized, Unlimited Enrichment Possibilities, Empowering Teaches 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.... Multiple, separate benefits in one experience is high-value-added instruction.
Mission: ALL Students Graduate Data Fluent. The 2020 COVID Health Crisis is now the US Public Education Crisis.
Leadership Duty: America's STEM Teachers
Mobilization Plan: Organizing for Innovation Campaign
Rapid Response: Invest time in making high-value skills deliverable to students.
Weapons: Science and Engineering Practices: Experimenting, Modeling, Standardization, Specialization, Sharing Efficiency, Spreadsheet Modeling Fluency and Instructional Value-Added at Every Level.
Spreadsheet Modeling Pedagogy = Essential Skills + Enhanced Content + Inclusive Learning
How?
Automaton and saving capability unleashes mathematical thinking enhancing the learning experience with the computing power of spreadsheets. This interactive math learning accelerates student Q and A turnover with an empowered representation that synthesizes mathematical concepts. This leads students to computational thinking, quantitative awareness and learning high value digital literacy and data skills. This will improve student outcomes in Physics, Chemistry, Biology and Math as well as all future higher education classes and careers in which spreadsheet are used. Spreadsheets are universal because they are efficient.
Everybody needs them and they are standardized: Excel, Sheets, Apple so SLM coding is compatible with whatever your students can access.
ATTENTION STEM TEACHERS: Register Now
Phase 1 Participation Enrollment: 183 STEM Educators
Awarded Phase 1 Funding in June, 2019 by the National Science Foundation Small Business Innovation Research (NSF SBIR) program, Spreadsheet Lab Manual LLC has built and implemented a standardized computational spreadsheet modeling pedagogy and observed student success across all levels and demographics and improve outcomes for under-served English language learners. With NSF support we have formed a new Professional Learning Community (PLC) exclusively for engaging professional educators. Proposed and designed based on a theoretical "knowledge engine" and professional learning community concept, we will use teacher incentives to recruit, train and equip members to develop content and share successes. Teachers define or vote for versions of standardized models as accepted practice of science. Schools can invest Title II funds to pay their own teachers to access to this diverse learning community, which they will improve by sharing their own unique perspectives.
Project Abstract for Congress: "Computer Science for All with Spreadsheet Modeling: Researching How Low-Cost Video Training for Teachers Leads to High Value Programming Skills for Students"
This computational modeling professional learning community is STEM teachers sharing resources that work with an empowering and widely used resource. Spreadsheet fluency is the foundation of data fluency and it will immediately enhance learning making math more meaningful and relevant to students. SLM leverages the computational power of the modern microprocessor with a standardized pedagogy across all STEM disciplines. Modeling in STEM with spreadsheets will be an essential learning fundamental so long as the spreadsheet remains a fundamental tool for managing information in society.
Low cost and high value added instruction with spreadsheets solves a future need. For anybody needing to log, use, interpret and understand data. All students, regardless of background or ability level.
How?
Automaton and saving capability unleashes mathematical thinking enhancing the learning experience with the computing power of spreadsheets. This interactive math learning accelerates student Q and A turnover with an empowered representation that synthesizes mathematical concepts. This leads students to computational thinking, quantitative awareness and learning high value digital literacy and data skills. This will improve student outcomes in Physics, Chemistry, Biology and Math as well as all future higher education classes and careers in which spreadsheet are used. Spreadsheets are universal because they are efficient.
Everybody needs them and they are standardized: Excel, Sheets, Apple so SLM coding is compatible with whatever your students can access.
ATTENTION STEM TEACHERS: Register Now
Phase 1 Participation Enrollment: 183 STEM Educators
Awarded Phase 1 Funding in June, 2019 by the National Science Foundation Small Business Innovation Research (NSF SBIR) program, Spreadsheet Lab Manual LLC has built and implemented a standardized computational spreadsheet modeling pedagogy and observed student success across all levels and demographics and improve outcomes for under-served English language learners. With NSF support we have formed a new Professional Learning Community (PLC) exclusively for engaging professional educators. Proposed and designed based on a theoretical "knowledge engine" and professional learning community concept, we will use teacher incentives to recruit, train and equip members to develop content and share successes. Teachers define or vote for versions of standardized models as accepted practice of science. Schools can invest Title II funds to pay their own teachers to access to this diverse learning community, which they will improve by sharing their own unique perspectives.
Project Abstract for Congress: "Computer Science for All with Spreadsheet Modeling: Researching How Low-Cost Video Training for Teachers Leads to High Value Programming Skills for Students"
This computational modeling professional learning community is STEM teachers sharing resources that work with an empowering and widely used resource. Spreadsheet fluency is the foundation of data fluency and it will immediately enhance learning making math more meaningful and relevant to students. SLM leverages the computational power of the modern microprocessor with a standardized pedagogy across all STEM disciplines. Modeling in STEM with spreadsheets will be an essential learning fundamental so long as the spreadsheet remains a fundamental tool for managing information in society.
Low cost and high value added instruction with spreadsheets solves a future need. For anybody needing to log, use, interpret and understand data. All students, regardless of background or ability 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.