Using Excel to crunch numbers

We’re going to the library for the next few periods. Download the instructions using the link below. Use your own LO3 data instead of the numbers I have provided.

By the end of this activity you will be able to;

  • manipulate raw data using formulae in cells
  • plot a graph of your results
  • add error bars to your graph
  • add a line of best fit
  • calculate the gradient and y-axis intercept of your line

national 5 exam questions – electricity and energy

Here are the exam-style questions to cover the electricity and energy unit.  I have included a copy of the relationships (equation) sheet and some data tables that you may need to attempt all the questions.  Apologies for the larger file size, it’s due to all the circuit diagrams.

Use the link below to download your own copy.

the challenge of mars

“We choose to go to the Moon in this decade and do the other things, not because they are easy, but because they are hard.” – President John F. Kennedy (12th September, 1962)

It’s 45 years since the success of Apollo 11 and nobody has tried to send a person further away than the Moon.  Why is that?

It turns out there are many challenges to be overcome if we want to send astronauts to another planet, e.g. Mars.  Earlier this year, the BBC Horizon programme looked at the issues.  Here is the episode. I have split the film into three parts.


mission to Mars – part1 from mr mackenzie on Vimeo.

mission to Mars – part2 from mr mackenzie on Vimeo.

mission to Mars – part3 from mr mackenzie on Vimeo.

Use the link at the end of this post if you want to download a copy to watch later.