A spreadsheet is not faster arithmetic. It is arithmetic that does exactly the same thing to every row — which is precisely where doing it by hand goes wrong.
📚 What you need to know
Spreadsheets organise raw data into rows and columns, calculate with one formula applied down a whole column, and visualise the result as a graph.
Scatter and line graphs show trends and correlations; bar charts and pie charts compare separate categories.
A calibration curve plots a measured signal against the concentration of known standards, so an unknown can be read off it.
Reading a value inside the plotted range is interpolation and is reliable; going outside it is extrapolation and is not.
The gradient of a best-fit line often is the answer — a rate, or the constant linking signal to concentration.
Computer modelling and 3D visualisation tools show molecular shape and bond angles, and can explore systems that are impractical to build.
What a spreadsheet is actually for
Three jobs, and they come in order. First it holds the raw data in a sensible structure. Then it does the repetitive arithmetic. Only then does it draw the graph.
Applying one formula to a whole column is the real gain. Ten titres averaged by hand is ten chances to slip; ten titres averaged by formula is one instruction, applied identically.
Choosing the right graph
The graph type follows from the question you are asking, not from what looks nicest.
Concentration, time and temperature are continuous, so they belong on a scatter graph. Four named catalysts are categories, so they belong on a bar chart.
There is a good test for this. Ask whether a point between two of your x-values would mean anything. Halfway between 10 s and 20 s is 15 s, which is real, so plot a scatter. Halfway between “nickel” and “platinum” is nothing at all, so use bars.
Calibration curves
This is the single most examinable use of a graph in this topic. A colorimeter or spectrophotometer does not tell you a concentration — it tells you an absorbance. To convert one into the other you first measure a set of standard solutions whose concentrations you already know, plot absorbance against concentration, and draw a line of best fit through them.
The line passes through the origin because a solution of zero concentration absorbs nothing. Forcing it through (0, 0) is chemically justified here, which is not true of every graph.
The gradient of that line is the conversion factor. Here it is close to 1.50, so absorbance = 1.50 × concentration, and any measured absorbance divides straight through.
Reading between your plotted points is interpolation and is fine. Continuing the line beyond the highest standard is extrapolation and is not, because you have no evidence the relationship stays linear out there — and for absorbance it usually does not. If the unknown is too concentrated, dilute it by a known factor, read it off, then multiply back.
Modelling and visualisation
Computational models let chemists investigate processes that would be slow, expensive or impossible to study experimentally. At your level, two uses matter.
3D structure builders. Free browser tools let you draw a structure and rotate it in three dimensions, which is far more useful than a flat diagram for seeing shape and bond angles.
Property prediction. Software can return calculated values — enthalpies, polarity, molecular orbitals — that you can compare against measured or database values.
The same caution from the previous page applies. A calculated value is an output of a model. It belongs in a comparison, next to your experimental result and a literature value, rather than standing in for either.
WORKED EXAMPLE
Standard solutions of a coloured complex give absorbances of 0.148, 0.305, 0.447, 0.603 and 0.752 at concentrations of 0.100, 0.200, 0.300, 0.400 and 0.500 mol dm–3. An unknown gives an absorbance of 0.480. Determine the gradient of the calibration line and the concentration of the unknown.
Step 1 — find the gradientThe line passes through the origin, so use the furthest point for the best precision.gradient = 0.752 ÷ 0.500 = 1.50Step 2 — check the relationshipEvery point gives roughly the same ratio, so absorbance is proportional to concentration across this range.A = 1.50cStep 3 — use it on the unknownc = 0.480 ÷ 1.50 = 0.3200.32 mol dm⁻³0.480 sits between the third and fourth standards, so this is interpolation and the answer can be trusted.
WORKED EXAMPLE
A second unknown gives an absorbance of 1.35, which is beyond the highest standard. Explain why the concentration should not be found by extending the line, and suggest what to do instead.
Why extending failsThe straight line is only supported by evidence between 0.100 and 0.500 mol dm⁻³. Beyond that there are no standards, and absorbance commonly stops being proportional to concentration at high values.extrapolating assumes a linearity you have not testedWhat to do insteadDilute the unknown by a known factor, for example ten-fold, so its absorbance lands inside the calibrated range.c(original) = c(diluted) × 10read it off, then multiply back by the dilution factorThe alternative is to prepare more concentrated standards and extend the calibration properly.
WORKED EXAMPLE
State the most appropriate type of graph for each set of results and justify your choice: (a) first ionisation energy against atomic number for the first twenty elements; (b) the percentage yield obtained with four different catalysts.
(a) ionisation energyAtomic number is a continuous ordered variable, and the point of the graph is to reveal a repeating pattern across it.a line or scatter graph(b) four catalystsThe catalysts are separate categories with no order and nothing meaningful between them, so the graph is comparing four values rather than showing a trend.a bar chartThe giveaway is whether a value between two x-values would mean anything. For atomic number it does; for catalyst names it does not.
💡 Exam tip
Justify a graph type by whether the x-variable is continuous or categorical.
For a calibration curve, say it is built from standards of known concentration and used by interpolation.
Take the gradient using widely separated points on the line, not two raw data points close together.
Name extrapolation explicitly when criticising a reading taken beyond the plotted range.
Say a spreadsheet applies one formula to a whole column, which removes repeated arithmetic slips.
Keep raw data and processed data in separate columns, both shown.
⚠️ Common mix-up
Using a bar chart for continuous data. Concentration and time belong on a scatter graph.
Extending a calibration line past the last standard and reading a value off it.
Joining data points dot-to-dot instead of drawing a single line of best fit.
Forcing a line through the origin when there is no chemical reason for it to pass through.
Reporting a computed or modelled value as a result. It is a prediction to compare against.
That completes Tool 2. Collecting the data and processing it are two halves of the same skill: a logger that produces three thousand readings is only useful if the spreadsheet turns them into one gradient you can defend.
Want this explained one-to-one?
Book a free session with an experienced IB Chemistry tutor and get your trickiest topics made simple.
