Site Map
Learning Pathway
Activities

Activity 9 : Linear graphs


 

 

2 hrs



 

In this activity you will draw the graphs of a straight line and a parabolic curve using MS Excel.

Activity

To draw a graph of a straight line we create a table of values of y at the different x values.

To draw the graph of y = 3x +7,

Open the linear graphs workbook on the "linear graphs" worksheet. You will find a table of values with the first row of each column completed.
  1. Highlight the first two x values and use the Autofill feature to create values from -5 to +5.
  2. Then highlight the first row and create the whole table using Autofill.
  3. Draw the graph of y = 3x +7, using Excel. If you are not familiar with drawing graphs in Excel, you may like to consult the Tip Sheets on Charts.
  4. On the same system of axes, draw three other graphs to show that by keeping the gradient of a straight line the same, the resultant graphs will be parallel.
  5. Use a different set of axes to show the effect of changing the gradient for graphs with the same y intercept.
  6. If you have created a resource with charts share this document online with your group (using the subject heading "Resource with Charts"). Explain how you think these graph drawing tools could be useful in your classroom. Your tutor will stimulate an online discussion amongst your peers based on these responses.

Complete your e-diary on how you think ICT can help to make mathematics more exciting.

 

NEXT

Once you have completed this activity, click here to move to Activity 10. Here you have two options: You can either try:

Activity 10A - Tricky graphs.

OR

Activity 10B - Quadratic graphs.

 
ICT Maths Resources for Educators
Site Map | Learning Pathway | Activities

Copyright SchoolNet SA and SCOPE. All Rights Reserved.