PHYS 1164 · Physics 2 Lab (online) · Instructor: jtestin@unomaha.edu · IOLab + Excel

Physics 2 Lab — everything in one place.

Your complete PHYS 1164 lab archive: the finished Lab 0 Excel file, the Lab 1 heart-rate report template + BPM calculator, the full IOLab setup guide with wiring photos, and every quiz answer. Saved so you can look back anytime.

📁 Lab files (download)

📊
Lab 0 — Intro to Excel (completed)
Data table, all formulas (speed, %dev, mean, STDEV.S/STDEV.P), scatter chart w/ trendline + R² + error bars, Q A–I answered. Verified in Excel.
↓ .xlsx
📄
Lab 1 — Heart Rate report template
Setup steps, 5 screenshot placeholders, fill-in blanks, pre-written procedure + reflection + conclusion, co-author roles.
↓ .docx
❤️
Lab 1 — BPM auto-calculator
Enter beats + interval in the yellow cells → heart rate auto-computes (beats/interval×60) and checks the expected range.
↓ .xlsx
💡 Before submitting a lab: rename with your group number (e.g. Lab0_7.xlsx, Lab1_7.docx).

🔌 IOLab setup (web version — no install)

  1. Put 2× AA batteries in the IOLab and turn it on.
  2. Plug the USB dongle into the laptop.
  3. Open Chromeiolab.science/iolabweb (works without installing anything).
  4. Click Connect → when the browser asks, select the dongle and Allow.
  5. Not found? Turn the device OFF, hold + while turning it back ON (Discovery Mode) → Pair.
  6. Test: Record → wiggle it → if the graph moves, you're connected. ✅
⚠️ Used device (eBay): no license/registration needed — the software is free. Just make sure the dongle is paired to your device.
IOLab setup diagram

❤️ The 5 heart-rate graphs (3 methods + resting/active)

Method 2 · Pulse Oximeter (Light sensor) — ⭐ start here, easiest

Dropdown: 40: Light(4800) or 6: Light(400) → Configure → Record. Shine your phone flashlight into the pad of a finger and press that finger against the light sensor. Zoom + smooth. Each dip = a beat.

Light sensor / pulse oximeter setup

Method 1 · ECG (electrical / high-gain) — the penny trick

Dropdown: 48: ECG(400) or the HG combo → Configure → Record → Smoothing = 25. Wire #1 → G+ terminal, wire #2 → G− terminal; alligator clip on each free end; clip each to a penny (dab hand sanitizer for contact); hold one penny in each hand, very still. Sharp spikes = beats.

ECG high-gain penny setup

Method 3 · Accelerometer (motion)

Dropdown: 33: Accel(800) or 2: Accel(400) → Configure → Record. No wires — rest the IOLab flat on your chest, lie very still, apply heavy smoothing. Small bumps = beats.

Accelerometer setup

Graphs 4 & 5 · Resting vs Active

Use the light sensor both times. Record resting (sitting calm), then do ~30 s jumping jacks and immediately record active — beats will be spaced closer together (faster).

How to smooth noisy data

How to smooth data in IOLab
Every graph: zoom → Highlight several consecutive beats (shows μ + time span) → note interval & beats → Win+Shift+S screenshot (no phone photos!) → paste into the report → enter numbers in the BPM calculator.

📊 Lab 0 — Intro to Excel (reference)

Data: Distance/Time of a moving cart. Speed = d/t. Scatter (Time = x, Distance = y), linear trendline.

Key results (to check your own work)
  • Speeds: 0.52, 0.79, 0.97, 1.00, 1.10 m/s
  • Mean speed 0.88 · Sample SD (STDEV.S) 0.23
  • Toy-car times mean 4.90 s · Population SD (STDEV.P) 0.14 s (= error bar value)
  • Trendline y = 1.51x − 2.03 · R² ≈ 0.997
  • Predict at 6.0 s → ≈ 7.03 m
Wrap-up answers A–I
  • A Speed is a calculated quantity (from measured d & t) — keep measured vs calculated separate.
  • B Slope = speed/velocity (rate of change of distance with time).
  • C y-intercept = distance at t=0 (initial position); slightly negative = small offset.
  • D R² near 1 = strong linear fit (variables highly correlated).
  • E Graph Y (professional: title, labeled axes w/ units, trendline, equation, R²).
  • F y = 1.51(6.0) − 2.03 ≈ 7.03 m.
  • G The (3.5 s, 3.4 m) point is farthest — random measurement error.
  • H Error bars ±0.14 s ≈ 3% of 4.90 s → fairly precise.
  • I (1.10 − 0.88)/0.23 ≈ 1.0 standard deviation.

✅ Quiz answers

Pre-lab 0.1 (IOLab + Excel videos)
  • iOLab purpose → collect & send data to a computer for real-time analysis
  • iOLab lets students → explore experiments independently & understand science broadly
  • Scatter plot → highlight data → Insert → Scatter Plot
  • Label axes → ensures accurate data interpretation
  • Excel version → Windows desktop version
  • Professional graph → titles for graph & axes
  • Trendline purpose → identify/describe the relationship between variables
Lab 1 pre-lab video quiz
  • Heart contracts all at once → False (coordinated sequence: atria then ventricles)
  • Camera detects heart rate → by tiny color changes in the skin over time
  • Accelerometer chip replaces ball-and-spring with → a comb-like silicon structure with flexible supports
  • Smartphone accelerometer main function → detect orientation and motion
  • Large error bars indicate → high uncertainty
Lab 0 post-lab assessment
  • Slope of trendline → relationship between distance and time (= speed)
  • Copy formula down → drag the fill handle (bottom-right square)
  • Objective of Excel lab → input, organize, analyze, visualize experimental data
  • Independent variable axis → the x-axis
  • Average function → =AVERAGE
⚠️ A timer logs whether you actually watched the videos (used for grade rounding) — let them play while you answer.

📦 PHYS 1164 take-home kit (provided — return at end)

You don't buy these; you're accountable for returning them. For Lab 1 you only need the IOLab, dongle, 2× AA, your phone, and — from the kit — 2 male-to-male wires + alligator clips (ECG method).

ItemQtyUsed for
Alligator clips5ECG leads (clip to pennies)
Male-to-male wires2ECG → G+/G− terminals
Breadboard + resistors (100/1k/10k Ω)Ohm's law / RC circuits (later)
Diode1Circuits (later)
Capacitors (22 µF, 220 µF)2RC circuits (later)
Hanging magnet + copper wireInduction / magnetism (later)
Polarizer film ×2, ruler, protractorOptics (later)
Balloons ×33Electrostatics (later)
4× AA + battery holderCircuit power (later)