Quick Links
Skip to main contentSkip to navigation

Clarendon ISD

Portrait of a Bronco

Working...

Ajax Loading Image

 

High School - Basic Math Models

Spreadsheets and Finances

Story image 1_0
5a58de2139502
Story image 1_1
5a58de2139502
Story image 1_2
5a58de2139502
Story image 1_3
5a58de2139502
Story image 1_4
5a58de2139502
Story image 1_5
5a58de2139502
Story image 1_6
5a58de2139502
Story image 1_7
5a58de2139502
Story image 1_8
5a58de2139502
Story image 1_9
5a58de2139502

Quality: Technology Literate-Discern and Synthesize Information; Use technology as a tool to accomplish tasks and be a life-long learner

Evidence: Students had to learn how to use spreadsheets to learn how to understand simple interest, compound interest, and business loans. 

Simple Interest:First, the students had to recognize and understand how to get interest. Next, they had to determine if it was annually or monthly interest rate. Then, the students had to compute amount owed for a specific principal, annual rate, and time. Once the students had their spreadsheets set up, they had to determine what the formula to use in order to complete the spreadsheet for each column. The objective for this lesson was to compute simple interest, given principal, rate, and time.

Compound Interest: Students had to figure out the formulas for monthly interest rate, how many months had to be figured for each scenario, and what the total amount owed. After they had the formulas for the first line, each student had to come and verify if the formulas were correct before continuing on with the assignment. The ladies decided to work together and discuss their formulas on the first day.  Each student chose to work individually the second day. Each student had to apply his/her knowledge about simple interest and compound interest to walk themselves through the process.  At times, students had to remember to change the annual rate to a decimal form before figuring out how to complete the process.  This lesson was a definite multi-step process. The objective for this lesson was to compute the new amounts owed when interest is compounded semiannually, quarterly, and monthly.

Business Loans: Each student had to apply the knowledge learned from simple interest and compound interest in order to figure out how much line of credit was needed for each scenario.  Again, this was a multi-step process where prior knowledge was a requirement and annual rate had to be converted before figuring out interest. The objectives for this lesson was to determine lines of credit based on a company’s value and to calculate interest on credit for given periods of time.

Cash Flow: The objectives for this lesson are understand cash flow, explain why managing cash flow is important, and use short-term credit to manage cash flow. Students have to figure out the Total Revenue and Total Expenses for a business and determine if the cash flow is a positive or a negative one. They had to figure out how much money a company needed to borrow in order to meet expenses for a specified month.