Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Science & Engineering Beginner

Physics with Spreadsheets: Motion, Forces & Energy

Units and significant figures, kinematics, projectiles, Newton's laws with friction, energy, momentum, orbits and a pendulum simulation: 8 hands-on mechanics labs in SI units with g = 9.81 m/s².

8 lessons 8 labs 2.1 h Certificate

  • One-time payment
  • 14-day money-back guarantee
  • Secure checkout with Stripe

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.

  • Convert six lab measurements to SI units, round values to a given number of significant figures with ROUND and LOG10, and report a calculated speed with the right precision.
  • Build a second-by-second table of position and velocity for an accelerating test car, graph the position and work out the braking distance.
  • Calculate the flight time, maximum height and range of a kicked ball and chart its path from a table of x and y over time.
  • Split the weight of a crate on a loading ramp into its components, calculate the friction force, the acceleration when it slides and the push needed to move it up.
  • Calculate the potential and kinetic energy of a coaster cart at five points, check how much energy friction took and find the power of the lift motor.
  • Calculate the momentum of two air-track carts and their velocities after a perfectly inelastic and after an elastic collision, then check what is conserved.
  • Calculate the centripetal force a car needs in a curve, the top speed before it skids, and the speed and period of a satellite in a low orbit.
  • Calculate a pendulum's exact period, simulate its swing with small time steps (the Euler-Cromer method) and compare the simulated period with the formula.

About this course

Physics problems become much clearer when you can change one value and watch every result update. This course uses that approach to work through classical mechanics. You start with SI units, conversions and significant figures, then model constant acceleration in a time table with a graph. Projectile labs calculate flight time, maximum height, range and the full path. Newton's second law is applied to a block on a ramp with friction, and a roller-coaster energy check links work, energy and power. You compare elastic and inelastic collisions through momentum, analyse circular motion and orbital gravitation and finally step through simple harmonic motion with a pendulum. Suited to secondary and first-year university students and teachers looking for practice material.

Curriculum

Course content

8 lessons · 8 labs · 2.1 h · final exam

  1. SI Units, Conversions & Significant FiguresLab14 min4 checked tasks
    Unlocked when you buy the course
  2. Kinematics: Constant Acceleration, a Time Table & a GraphLab16 min4 checked tasks
    Unlocked when you buy the course
  3. Projectile Motion: Flight Time, Height, Range & the PathLab16 min4 checked tasks
    Unlocked when you buy the course
  4. Newton's Second Law: Friction on a RampLab15 min4 checked tasks
    Unlocked when you buy the course
  5. Work, Energy & Power: A Roller-Coaster Energy CheckLab16 min4 checked tasks
    Unlocked when you buy the course
  6. Momentum & Collisions: Elastic vs InelasticLab15 min4 checked tasks
    Unlocked when you buy the course
  7. Circular Motion & Gravitation: Curves and OrbitsLab15 min4 checked tasks
    Unlocked when you buy the course
  8. Simple Harmonic Motion: A Pendulum, Step by StepLab18 min4 checked tasks
    Unlocked when you buy the course
  9. Final exam12 questions, 75% to pass, unlimited retries.

Certificate

Finish with a certificate you can verify

Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.

  • Names the course, your score and the date of issue
  • A verification link for your CV or LinkedIn profile
  • 12 questions, 75% to pass, unlimited retries.

A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.

Illustration. Your certificate shows your own name, course and credential ID.

Before you buy

Questions about this course

Is this a subscription?

No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.

What exactly do I get?

All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.

Can I get a refund?

Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.

When can I start?

Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.

Do I need Excel or other software?

No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.

Is the certificate an official qualification?

No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.

Full details are in our Terms · hello@tutorvo.com

Browse all Science & Engineering courses →
$9.99one-time payment
Buy course