This unique course introduces students to the basics of algebra by providing them real life data-management experiences using spreadsheets. Students play algebra-based games, learn spreadsheet computations and automation, and build a working algebra-based business model in their journey to learn the basics of algebra and understand how ubiquitous it is in the world. The topics covered in this course include algebraic expressions and equations, solving equations, dependent and independent variables, coefficients and constants, order of operations, charts, number lines and more. A Chromebook or any computer/PC with internet connectivity is required to join the course.
​
COURSE DURATION:
​
Course Outline
-
Project 1 - The Dice Roll Game
-
Students play a 6 round dice-based game, keep track of their scores, automate score-keeping and analyze their scores.
-
Lesson 1 - Introduction to the Game: Students get introduced to the dice roll game. They play a pre-game round to learn about equations and expressions and the definition of algebra. They apply the identity properties of addition and multiplication and the commutative and associative properties of addition.
-
Lesson 2 - Applying properties of addition and multiplication: Students apply the commutative and associative properties of multiplication and the PEMDAS order of operations as they progress in the game. They play the first round of the dice-roll game and populate a table with their scores.
-
Lesson 3 - Spreadsheets and Variables: Students learn the basic functions of spreadsheets, like adding content, inserting rows and columns, resizing cells, and copy-pasting data. Students explore their Round 1 scorecards and learn about independent and dependent variables.
-
Lesson 4: Using Equations to Calculate the Score: As students progress through the game, they build multi-variable equations to calculate their scores and learn about the different parts of algebraic equations.
-
Lesson 5: Automation using equations and conditional formatting: Students learn how to add equations in their spreadsheets. They learn how to manipulate, copy and paste equations as required. Students learn how to apply conditional formatting in their spreadsheets using if statements.
-
Project 2 - Lemonade Stand Business Model:
-
Students develop a working business model for a lemonade stand and show data for six months of business growth:
-
Lesson 1 - Introduction and Data Collection: Students get introduced to the project and are given all the required information to begin working on their business model. They identify the materials, material quantities, and material costs involved in running a lemonade stand. They represent this data in a spreadsheet and format the data using text formatting, borders, and color fill.
-
Lesson 2 - Calculating Cost Price of Product: Students write equations to calculate the lemonade costs. They solve for “C,” the cost of one serving of lemonade. Students enter the equation to automatically calculate “C” in their spreadsheet, setting the stage for later experimentation with cost optimization.
-
Lesson 3: Analysing Business Variables and Representing Inequalities: Students identify, write equations for, and calculate all the variables related to their business, such as the cost price, sale price, revenue, and profit. Students then represent the maximum profit, revenue, and sale price using inequalities on number lines.
-
Lesson 4 - Analysing Business Variables and Representing Sales: Students add the defined business variables to their business model, and link them up using equations. Students set up a variable dashboard, where the costs can be tweaked to reflect projected revenues. Students also generate charts from one week of sales data.
-
Lesson 5 - Automating Reports and Scaling Up: Students learn about algorithms and automate their sales report generation using macros. With the goal of keeping the cost of lemonade to 1 dollar, students re-tool the costs to suit bulk purchasing, add in marketing costs and create a pitch for investment for scaling up their business.

Algebra with Spreadsheets
Gr 6-7


Approved for Standards Alignment


Approved for Quality PD

Member
Jake H, Principal, St Johns Lutheran
"We have had students interested in coding, but did not have staff with content knowledge to teach it. Whizara did a wonderful job of providing the curriculum and the expertise to give our students great success with their first experience in coding. The students grew tremendously throughout the class, as the instructor was kind, knowledgeable and related well with the students. The scope and sequence of the curriculum was excellent and I couldn’t believe how much progress the students made in just 10 weeks. Our school looks forward to working with Whizara again in the future! "
Hattie M, Founder, Crete Academy
"Whizara program further developed our students' creativity. Using the program not only taught them coding but also critical thinking and reasoning skills that go beyond coding and support students in all subjects. "
Cindy J, Principal, Santa Fe Springs Christian School