One of the coolest parts of a Montessori Highschool or Montessori Middle school is the electives! At LMSS our Adolescent Program students take interim classes between their academic units. These interim courses are a chance to dive into specific subjects that they might not get to in their regular classes (we are still a public school and have standards to meet!). Some of the classes students are taking are Woodshop, Etymology and Entomology, and How to Cheat at Math Using Spreadsheets!

In other math interims, we’ve learned about non-Euclidean geometry and game theory. This time, students are learning basic to advanced spreadsheet skills while also practicing their algebra and geometry skills. Students have made function tables and graphed them. They’ve calculated standard deviations and learned many of the stats-related spreadsheet functions such as =AVERAGE(), =MODE(), =STDEV, etc. They have built equation solvers for a variety of types of equations. They have learned to sort, filter, and link sheets. The list goes on. Of course in order to make spreadsheets a little bit more fun, we’ve also played some spreadsheet variants of classic games such as bingo, battleship, and chess. We spiced things up by adding some competition. Students were put into four teams: Latveria, Arendelle, Narnia, and Panem.
On day one, the Olympic torch was lit. Students competed in both games and Spreadsheet Throwdowns to see who was the quickest and most skilled at the spreadsheet skills they’ve learned. On day one, Arendelle and Narnia were neck and neck, and Panem was bringing up the rear. The competition was HEATED. (Competitions are not normally part of classes in a Montessori classroom – making the teens even more excited!) Scores were tracked on the “Score Card” sheet of the “Master Spreadsheet” ← check it out! Here are the scores as of Day 7.

On day 5, students celebrated Circle Day. It’s like Pi Day or Tau Day, but it marks one year since the Earth made a full rotation around the sun. Technically, every day is Circle Day! We celebrated by making pizzas and pies, as well as pi charts. Circle day is really just an excuse to talk about circles, circle theorems, and circle constants. You can see the full schedule of the course on the “Schedule” sheet of the Master Spreadsheet. ← Again, check it out!
You might notice that a fifth team entered the race. MORDOR. The final boss of math in spreadsheets has to be … math in a spreadsheet. Mordor’s score was calculated with the following:
=I7+AVERAGE(J3-I3, J4-I4, J5-I5, J6-I6)*1.05^(COLUMN(J7)-5)
Mordor increased with other teams’ scores, and it increases more each day. If Mordor catches a team, they will be eliminated. Panem was almost eliminated, but the Wonder Wheel allowed them to steal some points from another team. Will Panem or even Latveria be eliminated in the last two days? Only time will tell. Final projects include creating their own Master Spreadsheets, making music videos about math and/or spreadsheets, or creating programs and lesson plans to be used with other classrooms.

What is the purpose of classes like this? In addition to allowing students to access new academics that are outside of the standards or above and beyond, the value of classes like this stems from giving the students a chance to learn to love math. This class about math and spreadsheets brought so much joy and energy to students that maybe aren’t really into math or spreadsheets. Yet now, they have valuable skills that they can bring into their classes and take with them even when they graduate.