Site Map
Learning Pathway
Activities

Activity 10A: Tricky graphs


 

1 hr



 

In this activity you will be required to represent a set of data using a graph in MS Excel. You may find the tip sheet on Plotting graphs useful.  

Activity

Use your e-diary to record your thoughts about drawing graphs in Excel.

The graphs of the three trigonometric ratios, sine, cosine and tangent can easily be plotted using MS Excel.

  1. First we create a table of values from 0o to 360o.

  2. Then we convert the degree values into radians using the Excel function radian ()

  3. Then we plot the graphs.

Open the Excel workbook sine graphs on the "trig graphs" worksheet and use the data tables to:

  • Plot a graph of sin(A)
  • Plot multiple graphs on the same system of axes of sin(A), sin(2A) and 2sin(A)

Open the Excel workbook trig identities worksheet on the "trig identities" worksheet and create a sample of graphs that graphically prove the following trigonometric identities or any other identity.

sin (A + B) = sin A cos B + cos A sin B
and

sin2 A = ½ (1 - cos2A).
  1. Once you have created the graphs in MS Excel, save them and attach them in email to your tutor (using the subject heading "Tricky graphs").
  2. If you have created a teaching resource share the document online with your group using the same subject heading.
Complete your e-diary on this activity
Optional exercise: Quadratic Graphs
Once you have completed this activity, you are welcome to try Activity 10B - Quadratic graphs as an optional activity, if you want more practice.
 

NEXT

Once you have completed this activity, click here to move to to Activity 11 - a new look worksheet.

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

Copyright SchoolNet SA and SCOPE. All Rights Reserved.