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, every quiz answer, the Lab 2 charge-on-a-plate report + calculator + guide, and the new Lab 3 equipotential-surfaces report + data logger + guide. 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
🍽️
Lab 2 — Charge on a Plate report ⭐
Full rubric-matched write-up (research question, methods + calibration, results table, discussion via F=2kQ²/A, error analysis, conclusion, co-author roles) — fill only the red [ ] spots: force readings, area A, computed Q, screenshots.
↓ .docx
Lab 2 — Plate charge calculator ⭐
Enter each trial's Mean force F (N) + plate area A (m²) → charge Q = √(F·A/2k), average, and std dev auto-compute (yellow input cells).
↓ .xlsx
🎈
Lab 2 — Charge on a Balloon report (alternative)
Full write-up for the balloon method — fill only the red [ ] spots: names, mass, separations, photo. Use if you do the balloon-balance version.
↓ .docx
Lab 2 — Balloon charge calculator
Enter each trial's mass m (kg) + separation r (m) → charge q = r·√(mg/k), the average, and the uncertainty auto-compute.
↓ .xlsx
🗺️
Lab 3 — Equipotential Surfaces report ⭐
Full rubric-matched write-up (research question, methods incl. DAC/GND/A7 + 3.3 V config, results table + photo placeholders for both plates, discussion of symmetric vs asymmetric + field⟂equipotential, error analysis, conclusion, co-author roles). Fill the red [ ] spots.
↓ .docx
📈
Lab 3 — Equipotential data logger
Two tabs (symmetric + asymmetric plates) to log line #, target voltage, probe points, measured V, and x/y positions as you map each equipotential.
↓ .xlsx
💡 Before submitting a lab: rename with your group number (e.g. Lab0_7.xlsx, Lab2_7.docx, Lab3_7.docx).

🍽️ Lab 2 — Estimating Charge on a Plate

Charge can't be measured directly, so you get it from a force: charge two plates, hold them close and parallel, and let the IOLab force sensor read the electric push between them. A parallel-plate model then converts that force into the charge.

⚠️ The #1 rule: the charged plates must be insulators (plastic lid, styrofoam or plastic plate). Aluminum foil is a conductor — it won't hold charge by rubbing and drains the moment you touch it, so a foil plate reads ~0 force. Use two insulating plates, same size, handled by the edges only.

The model

For two parallel charged plates: F = 2k·Q² / A  →  Q = √( F · A / (2k) )  (F = measured force in N, A = plate area in m², k = 9×10⁹). Compare force close vs far — the model predicts it's roughly constant. A sensible result is ~0.01–1 µC.

📐
Illustrated setup guide — open →
Foolproof step-by-step with labeled SVG diagrams & force arrows: build 2 insulator plates → measure area A → calibrate the force sensor → charge hard → read the force close vs far → calculate Q. Includes a foolproofing checklist + the High-Gain foil backup.
Open →
  1. Build 2 insulating plates the same size; tape a handle on each; measure the area A (m²).
  2. IOLab → select the Force sensor and CALIBRATE it (zero at rest). Mount plate #1 on the force probe.
  3. Charge both plates hard on carpet/wool; handle by the edges only.
  4. Record → 2 s baseline → bring plate #2 parallel, CLOSE (~2–3 cm), hold still → read the Mean force (N).
  5. Repeat at FAR (~8–10 cm); do 3–5 trials each, recharging every time.
  6. Punch F & A into the calculator/formula → Q = √(F·A/2k), average, uncertainty → paste into the report.
🔁 Two alternatives if the force is too tiny to read: (A) High-Gain foil sensor — charge a plastic lid, sense with foil on G+/G−→GND, read the induced voltage (needs the handout's V→Q calibration; confirm your instructor accepts it). (B) Balloon balance — the balloon guide → and its report/calculator below. Both are in the setup guide.
🌵 Static tips: dry hands + dry room · charge hard · work fast (charge leaks in seconds) · never touch the charged faces · calibrate the force sensor first.

🗺️ Lab 3 — Equipotential Surfaces

Map the "voltage contour lines" around two electrodes. Put salt water in a styrofoam plate, drive 3.3 V across it between two pennies (one on the IOLab DAC, one on GND), and probe the water with a clip on A7 to find points at the same voltage — those points trace an equipotential line.

The idea

An equipotential line connects points of equal voltage. Lines never cross (a point can't have two voltages), and electric field lines cross them at 90°. You'll map a symmetric and an asymmetric penny arrangement and compare the patterns — like reading a topographic map.

📐
Illustrated setup guide — open →
Beginner step-by-step with SVG diagrams: salt-water plate + 2 pennies wired to DAC/GND, the A7 probe, the software config (3.3 V + A7 + digital meter), symmetric vs asymmetric mapping, connect + label the lines, and the failure-mode checklist.
Open →
  1. ~¼" salt water in a styrofoam plate (tap water + stir in salt).
  2. Alligator clip + penny on each of two opposite sides (edge submerged) → one to DAC, one to GND. A third clip (no penny) → A7 = probe.
  3. Software: gear → Chart Display → check Output ConfigurationDAC = 3.3 V → turn on Analog 7 → click the chart title to collapse it into a digital voltage meter.
  4. Probe the water; find several points at the same voltage; mark each with a shallow dent (don't puncture!). Repeat at other voltages.
  5. Empty + dry, connect same-voltage dots with a sharpie, label each line's voltage.
  6. Do two plates — symmetric & asymmetric — and photograph both for the report.
⚠️ The "calibration" for this lab = setting DAC = 3.3 V (with Output Configuration checked) + turning on A7 + clicking into meter mode. No reading? Check those. Too weak a gradient? Add more salt & submerge the penny edges. Keep the two pennies from touching (short).

🔌 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)