Excel simulation for the Planck constant with LEDs experiment.
Students gather striking voltage for each colour by changing te pd, then plot pd vs 1/λ where the gradient is hc/e.
The password to unlock is: physics
This is work in progress. Please comment below if you think of something you would like added.
Last updated: 3rd December 2020
; general terms ; CTRL+SHIFT ; x, gives × 10 ^+x:: Send, × 10 return ; o, gives ohm symbol ^+o:: Send, Ω return ; a, gives α symbol ^+a:: Send, α return ; b, gives β symbol ^+b:: Send, β return ; g, gives γ symbol ^+g:: Send, γ return ; u, gives μ symbol ^+u:: Send, μ return ; r, gives ρ symbol ^+r:: Send, ρ return ; w, gives ω symbol ^+w:: Send, ω return ; Superscript ; SHIFT+WIN ; Shift + Win + 1, 2, 3, 6, 9 and - will give the superscript +#-:: Send, ⁻ return +#1:: Send, ¹ return +#2:: Send, ² return +#3:: Send, ³ return +#6:: Send, ⁶ return +#9:: Send, ⁹ return +#e:: Send, ⁻¹⁹ return ; Subscript ; CRTL+WIN ; Ctrl + Win + 1, 2, 3, x, y, t (total) and - will give the superscript of the key or (value) #^1:: Send, ₁ return #^2:: Send, ₂ return #^3:: Send, ₃ return #^x:: Send, ₓ return #^y:: Send, ᵧ return #^n:: Send, ₙ return #^t:: Send, ₜₒₜₐₗ return
Basic simulation of scalar readings for variable thicknesses of lead. Readings are valid but change randomly and can be used to determine the half thickness.
Version 1.2 allows you to take a background count. You can change the background count parameters in the secret [Settings] tab.
The password to find the secret [Settings] tab (unlock the workbook in Review > Unprotect Workbook/Sheet) is physics.
In case 1.2 borks, here is version 1.0:
A spreadsheet to give the students the opportunity to measure the resistivity of a piece of wire. The spreadsheet lets them “place” (type) crocodile clips (^) against a “wire” and gives them resistance readings that have built in uncertainty. There are also photos of their micrometer readings.
The password on the sheets and workbook is physics, and there is a hidden sheet where you can set the resistivity of the wire and the uncertainty.
Another nice simulation that is prety close to actually doing it.
Quite realistic simulation with all the readings needing to be done with the uncertainty that entails. Hard to show with images, but the thermometer reading goes up, as does the plunger.
You actually get to drop the weights and have to read from the mm scale. It gives you a zoomed in view.
Test on the AQA 7407 Spec Materials including Young Modulus and Hooke’s Law