Linear equations and slope

by Valentyna Parlak


This lesson will be focus on Slope and Linear Equations. This unit is designed to be used in Algebra I and Algebra II classes and can be modified for intermediate grades. This lesson will have students using various forms of technology such as Internet, Microsoft word, Spreadsheet, and PowerPoint.

During this lesson you will learn how to define and interpret the slope in the slope-intercept form to write equations,recognizing connections between graphs and the real world. You will create Power Point to present the slope problems and post it to this blog ,insert the tables in Microsoft Word, and create one table in Microsoft Excel .


Ask me questions  


Excell

                                            

To create a table in Microsoft Excel

  1. Open a new spreadsheet file.
  2. Set   up a spreadsheet file that it contain the following information 
  3. Column C and D name as Change in X and Change in Y.
  4. In Cells A2, A3, A4, A5, A6 type the given domain.
  5.  In Cells B2, B3, B4, B5, B6 insert the formula that calculate the Y-value. For example in cell B2 type: = A2 - 4, in cell B3 type =A3 – 4, and so on.
  6.  In cells C3, C4, C5, C6 insert formulas:

     C3: =A3-A2

     C4: =A4-A3

     C5: =A5-A4

     C6: =A6-A5

9.  In cells D3, D4, D5, D6 insert formulas:

     D3 =B3-B2

      D4 =B4-B3

      D5 =B5-B4

      D6 =B6-B5

Notes