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.