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

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.
Test on the AQA 7407 Spec Materials including Young Modulus and Hooke’s Law