Coordinate Geometry with Spreadsheets: Distance, Slopes, Lines, Circles & Polygons

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Measure six planned paths on a park site plan from their end-point coordinates, find each path's midpoint for a lamp post and total the paving length.
• Calculate the slope, the direction angle and the pitch of six lines on a facade drawing and check the entrance ramp against a 1:12 limit.
• Turn two roads given by surveyed points into y = mx + b, use the point-slope form to find a point on a road and calculate where the two roads cross.
• Test five walls of a rotated floor plan against the front wall: slope product, the angle between the lines and a verdict with a tolerance, plus the slope a perpendicular wall needs.
• Write a planned road as ax + by + c = 0, measure the perpendicular distance of seven buildings to it, find which side each one is on and count those inside the noise buffer.
• Convert a sprinkler's centre and radius into the general circle equation, test seven plants for inside / on edge / outside, and read centre and radius back from a CAD equation.
• Calculate the area of an irregular building plot from its corner coordinates with the shoelace formula, once row by row and once with SUMPRODUCT, and find the plot's centroid.
• Scale an L-shaped logo outline ×1.5, rotate it 30° about the origin, move it to its spot on a poster and plot the original and the placed outline in one scatter chart.