Calculating Data with Excel

In order to calculate data on Heat Flux for the above activities, you need a Heat Flux calculator. The Alaska Lake Ice Observatory Network has developed such a calculator using Excel software. Two calculators are available below, one for snow data taken on frozen lakes, the other for snow data taken on the ground: Snow […]

Calculating Heat Flux

Students in grades 3-12 can collect the data on snow and temperature needed for these calculations. Middle school and high school students can carry out the calculations needed to determine the conductive heat flow. Conductive heat flow (Fa) (also known as heat flux) is a function of: (a) snow temperature gradient (Ts–Tb/Zs); and (b) snow […]