Joseph M. Mahaffy
 Math 124: Calculus for the Life Sciences Spring 2017
|  Course Index  |  Lectures  |  HW Assign  |  Computer Lab  |  WeBWorK  |  Syllabus  |  Miscellaneous  ||  Home

Computer Lab Help 1

This page is designed to provide helpful information about the laboratory questions. You will find more details in the Lab Manual that accompanies this course. Begin this lab and every lab by introducing yourself to your partner. Determine the times when you can meet together during the week before the lab is due at your next Lab session.

You should start this lab and each lab by typing the name of each team member and your computer number on the Lab Cover Page (or a copy of it). For general rules of what is expected in the Lab, read the Laboratory Guidelines. There is a Lab Manual that accompanies this course, which has many detailed worked examples from the labs for this course. This semester I will continue to make revisions to the Lab Manual. There is a link to a document for producing good graphs in Excel 2010. Also, there is additional documentation on what is expected through the link to the Good Graph Document.

Problem 1: You follow the directions in the lab and according to the Laboratory Guidelines to create a good graph of the two intersecting lines. This problem begins by having you generate the graphs of two lines. In the top row you insert labels x, y1, and y2 for the x values and the two lines. In the first column below x, you insert the integers from -10 to 10. (We will demonstrate the pull down feature in Excel in the Lab.) Next you name the x variable by highlighting the first column, going to Formulas on the Main menu, followed by Create from Selection, then accepting the default of Top Row. (Alternately, you can use the submenus labeled Define Name or the Name Manager.) In Columns B and C starting with B2 and C2, you type in your equations for the lines, typing " = m*x + b" where m is the slope of your line and b is the y-intercept. Next you pull down the equation to get the points on your lines.

After you have these data entries for the lines, you highlight the three columns and invoke Chart Wizard. To create a graph in Excel, you go to the Main Menu and select Insert. You will always be selecting the Scatter option, and in this case use the line sub-Chart. When you click on your graph, you will see Chart Tools in the Main Menu. Under Layout you will follow the directions to add Titles, Axis labels, and Gridlines. Select the option to not have a Legend for this graph, but rather use the Text Box option to create labels that you put right next to the particular lines.

Under the Layout there is an Axes label. You will always go to this box to adjust the Primary Horizontal Axis. At the bottom of the box are More ... Options, which allow changing the domain of your function. Less often, but in this problem you do change the Primary Vertical Axis. The details of this process to create a good looking graph will be gone over in your Lab section.

The second part of this problem introduces you to using the Graphing template that is provided. Details of using the Graphing template will be covered in Lab and are detailed in the Lab Manual. This time you create the graph in Excel, then repeat the procedure from Question 1 to obtain a good looking graph.