5.2.2Tools
Applying Technology to Process Data in Biology — IB Biology SL Revision Notes & Topical Questions
5 min read 5 parts Lesson 6 of 10
Part 1 of 5Spreadsheets

Computers handle repetitive calculation, so people can focus on interpretation.
Recording data
- Raw data are entered in tables with clear headings and consistent units and precision.
Calculations
- Formulae calculate means, percentage changes and rates for many rows automatically.
Statistics
- Built-in functions provide standard deviation, correlation coefficients and tests such as the t-test.
Accuracy
- Formulae reduce arithmetic errors, though the person still has to check that the correct cells and functions are used.
Part 2 of 5Graphs and Models
Graphs and Models
Plotting
- Software draws graphs from raw data quickly, including bar charts, scatter graphs and box plots.
Trend lines
- A trend line or curve can be added, and a coefficient of determination R² shows how well it fits.
Error bars
- Standard deviation or range can be shown as error bars on the plot.
Simulations
- Computer models predict how systems such as populations or enzyme reactions change when variables are altered.
Part 3 of 5Image Analysis
1
Take a digital photograph or micrograph with a scale included.
2
Load the image into analysis software and calibrate the scale.
3
Measure lengths or areas, count cells, or measure colour intensity.
4
Export the results to a spreadsheet for calculation of magnification or mean values.
5
Compare results between images using the same settings to avoid bias.
Part 4 of 5Judging Outputs
Check inputs
- Wrong data entry gives wrong results, even if the software looks professional.
Choose the right test
- A computer will run a test on any data, so the user must decide which test is suitable.
Share data
- Digital files can be shared and combined, which allows larger data sets and collaboration.
Part 5 of 5Exam Checklist & Tips
5.2.2 – Key Points for the Exam
- Spreadsheet Software for organising data in rows and columns and performing calculations.
- Trend line A line drawn through data to show the general relationship.
- Image analysis Use of software to measure or count features in images.
- Simulation A computer model that imitates a real system.
Common Mistakes
- Accepting a computer-drawn line of best fit without checking that it suits the data.
- Failing to calibrate scale in image analysis.
- Using inconsistent decimal places in a spreadsheet table.
- Thinking that software chooses the correct statistical test automatically.
Last updated:
\n