Fri, Mar 5, 2027Spring (Semester 2) · Week 7Day 32 of 6780-min block

Statistics lab analysis

Today's target

Analyze your physiology dataset using descriptive statistics and a comparison test.

Due today · Lab report Required

Spreadsheet statistical analysis: summary statistics per condition, t-test result with interpretation, and reproducible step documentation.

Your 4 steps today
  1. 1
    Do this
    Analyze your physiology dataset using descriptive statistics and a comparison test.
  2. 2
  3. 3
    Submit this
    Lab report: Spreadsheet statistical analysis: summary statistics per condition, t-test result with interpretation, and reproducible step documentation.
  4. 4
    Submit it here
    1. 1CMSD website. Go to clevelandmetroschools.org and click the Clever button.
    2. 2Clever. Clever opens. Sign in if it asks.
    3. 3Microsoft (district) login. Use your district Microsoft account (the one for school).
    4. 4Schoology. Open Schoology, then your class, then Assignments, and find the file named below.
    The file to submit is named: Biotechnology for Health (Biomedical Innovations) › Bias, error, graph choice, CER conclusion, limitations. › Lab report
    Open Schoology
Were you absent? Jump to the make-up plan
Where this fits
Tested on (Ohio WebXam)
Biotechnology for Health and Disease · 072125
PLTW lesson
BI · Statistics lab analysis
WebXam domain
Microbiology Testing and Technology
Evidence to produce
Lab report
Lab / skill
Khan Academy Statistics and Probability
Quick glossary
CER:
Claim, Evidence, Reasoning — make a claim, back it with evidence, explain your reasoning.
SOP:
Standard Operating Procedure — the exact steps to follow (especially in a lab).
Tracker:
Your PLTW progress log where you record completed evidence.
myPLTW:
The PLTW course site where you do the online activities — you open it through Schoology.
Learn first

Minute-by-minute · 80-minute block

💡 Big idea: A statistical analysis is only as trustworthy as the steps you took to produce it -- reproducibility is not optional in scientific reporting.

  1. 0-10Open the spreadsheet dataset and verify it matches your submitted data table
  2. 10-30Compute summary statistics for each condition: mean, SD, and count
  3. 30-55Run or interpret a t-test comparing the two conditions; record the result and what it means
  4. 55-65State whether the difference is statistically meaningful and explain in plain language
  5. 65-77Record all analysis steps so they are reproducible; submit the completed analysis
  6. 77-80Exit check: what would change in your conclusion if your sample size had been twice as large?
Mr. Mendoza's 5-minute intro
  • Today you run the full statistical analysis on your physiology dataset.
  • You will use a spreadsheet to compute summary statistics and run or interpret a t-test.
  • Every step must be documented so the analysis can be reproduced -- undocumented analysis is not publishable.
  • Statistical analysis appears directly in the Molecular and Genetic Technology and data-skills strands of WebXam 072125.
Do this, step by step
  1. 1Compute summary statistics for each condition in a spreadsheet.
  2. 2Run or interpret a t-test comparing your conditions.
  3. 3Determine whether the difference is statistically meaningful.
  4. 4Record the analysis steps so they are reproducible.
  5. 5Submit your completed statistical analysis.
You'll be able to
  • Your analysis reports statistics and a comparison result.
  • You can state whether a difference is statistically meaningful.
Know by the end
  • How to compute summary statistics for each condition in a spreadsheet and interpret what they mean.
  • How to run or interpret a t-test and state whether the result is statistically meaningful.
  • Why recording every analysis step enables someone else to reproduce your result.
📺 Tutor me: Khan Academy Statistics and Probability
Do the work

Your PLTW work today

Open this PLTW section today

Bias, error, graph choice, CER conclusion, limitations. · Statistics lab analysis

Day 3 of this lesson. Open this exact section in myPLTW (reached through Schoology), then do the work below.

Do this: Open Problem 2 in your myPLTW course shell and locate the statistics-analysis or data-interpretation activity to review the spreadsheet format and t-test guidance.

Complete

Mark the statistics-analysis lab activity complete in your tracker after submitting your analysis.

How far to get

The graph draft is done; by end of today your full statistical analysis with summary stats, t-test result, and reproducible steps should be submitted.

Upload as evidence

Spreadsheet with computed summary statistics, t-test result, and reproducible steps recorded, submitted to Schoology.

All PLTW activities are completed inside the PLTW course environment — this page only gives direction. Submit producibles on Schoology.

The plan

Today's PLTW tracker

Check things off as you work, then submit. This tells Mr. Mendoza how you're doing so he can help the class. It does not replace turning in your producible on Schoology.

Use the code Mr. Mendoza gave you, not your name. Saved on this device.

Bias, error, graph choice, CER conclusion, limitations.Day 3 of this projectSee the full week plan
Today's PLTW target

Bias, error, graph choice, CER conclusion, limitations. · Statistics lab analysis

Open Problem 2 in your myPLTW course shell and locate the statistics-analysis or data-interpretation activity to review the spreadsheet format and t-test guidance.

The graph draft is done; by end of today your full statistical analysis with summary stats, t-test result, and reproducible steps should be submitted.

This is how Mr. Mendoza sees the class keeping pace with PLTW. Be honest, it only helps if it is accurate.

1 · What you do today

🎯 Analyze your physiology dataset using descriptive statistics and a comparison test.

  • Compute summary statistics for each condition in a spreadsheet.
  • Run or interpret a t-test comparing your conditions.
  • Determine whether the difference is statistically meaningful.
  • Record the analysis steps so they are reproducible.
  • Submit your completed statistical analysis.
2 · Turn in today

Lab report: Spreadsheet statistical analysis: summary statistics per condition, t-test result with interpretation, and reproducible step documentation.

Submit on Schoology

Upload by 11:29 PM for full credit.

3 · Who's doing what (team)
TaskWho
Compute summary statistics for each condition in a spreadsheet._______
Run or interpret a t-test comparing your conditions._______
Determine whether the difference is statistically meaningful._______
Record the analysis steps so they are reproducible._______
Submit your completed statistical analysis._______

Working solo? Put your own name in "Who" for every row.

4 · Words I can use correctly
5 · I'm successful today when I can…
  • Your analysis reports statistics and a comparison result.
  • You can state whether a difference is statistically meaningful.
6 · Reflection & next steps
Where are you today?0/7 checked
Pick your period and code first.
Explore

Teacher-posted resources

Classroom documents for this lesson. Ones marked “Open the file” open right here; the rest are posted in Schoology. Use the label on each card to choose the right move.

Catch-up / reteachFor: Need extra support
PLTW BI Activity 2.1.3 Making Results Meaningful
worksheet/handoutOpens here
Open the file

Use this if you were absent, got stuck, or need another pass before you submit the lesson artifact.

Placement rationale

Matched Statistical analysis and t-test reasoning by path:Biomedical-Innovations/Problem-2_Human-Physiology/2.1_Human-Physiology; keywords:statistical analysis. Score 138. Visibility: student-schoology (student-facing resource; link through Schoology rather than local path).

Catch-up / reteachFor: Need extra support
PLTW BI 2.1.3 Statistical Analysis Three Examples Resource
worksheet/handoutOpens here
Open the file

Use this if you were absent, got stuck, or need another pass before you submit the lesson artifact.

Placement rationale

Matched Statistical analysis and t-test reasoning by path:Biomedical-Innovations/Problem-2_Human-Physiology/2.1_Human-Physiology; keywords:statistical analysis. Score 134. Visibility: student-schoology (student-facing resource; link through Schoology rather than local path).

Use during lessonFor: Everyone
BI Project 2.1.1 Scientific Research Student Activity
worksheet/handoutOpens here
Open the file

Open this when the class reaches this activity and use it to complete the required lesson artifact.

Placement rationale

Matched Statistical analysis and t-test reasoning by path:Biomedical-Innovations/Problem-2_Human-Physiology/2.1_Human-Physiology. Score 126. Visibility: student-schoology (student-facing resource; link through Schoology rather than local path).

How to get there: open the CMSD website, click Clever, sign in with your Microsoft (district) account, then open Schoology from Clever.

Lab day

Lab & supplies

Bring / set up
Lab computers with spreadsheet softwareSaved physiology dataset from prior weekGraphing or charting toolCER conclusion templateCalculatorProjector for sharing graphs
Khan Academy Statistics and Probability
Words

This unit's vocabulary

biaslimitationreplicationstatistical significanceevidence

Tap the speaker to hear a term. Weekly vocabulary task: add two of these terms to your notebook glossary with a definition and an example in your own words.

Check yourself

WebXam practice

Tap an answer to check it · nothing is recorded or graded
Where should you locate information on the maintenance history of a glucometer?
A centrifuge begins to vibrate excessively at 10,000 RPM. After safely stopping it, what should the technician check in the equipment log?
You expected a drug to raise heart rate, but the data shows it stayed the same. What should you do?
An SDS lists a corrosive pictogram and the statement “causes severe skin burns,” but the PPE section says no gloves are required. Why is this incorrect?
Check yourself

Cumulative WebXam review

A quick mixed-review pulling questions from earlier units plus today, so the WebXam material stays fresh.

Tap an answer to check it · nothing is recorded or graded
[Review: Prototyping the ER: floor plans, process flow, and human factors] How should you properly prepare hydrochloric acid (HCl) for disposal?
[Review: Pitch and revise: evidence-based feedback and intro to study design] Experimental results fall significantly outside the expected range. What should you do first?
[Review: Reading the body's data: study types, sample size, and the t-test] What is the purpose of an experiment measuring blood glucose after giving a drug or a placebo?
Where should you locate information on the maintenance history of a glucometer?
Explore

Where this leads — careers

Safety net

What to do if you were absent

Today was a lab — do this instead

Complete the statistics analysis on your spreadsheet dataset: compute summary statistics, run or interpret a t-test, and record reproducible steps with the result.

Khan Academy Statistics and Probability

Then submit your Lab report on Schoology.

If MR. MENDOZA is absent

Class still runs. Complete the online activity above (it's self-guided). Need the concept taught without a teacher? Use this authoritative explainer:

Khan Academy Statistics and Probability
How this is graded
For: Lab report — Spreadsheet statistical analysis: summary statistics per condition, t-test result with interpretation, and reproducible step documentation.
  • Complete
    Every required part of the artifact is present, nothing left blank.
  • Accurate
    The science and the data are correct and match the evidence.
  • Scientific reasoning
    You explain your claim with evidence and reasoning (CER), not just an answer.
  • Professional communication
    Clear, organized, labeled, and written the way a clinician or scientist would.
  • Submitted
    Turned in the right way (Schoology for routine work) and confirmed.
Submission Zone

Drop your Fri, Mar 5, 2027 · Statistics lab analysis here. Use a clear file name (your initials + project). Routine work still goes to Schoology (via the CMSD portal).

Upload a project