Collecting Data from the String Art Project with Excel (Corrected 4/15/02)

Make two different Excel charts based on a section of your String Art Project.

Both Excel charts are due before Friday, April 19, 2002.

1. The first Excel chart should show the lengths of each of the line segments in the section you are studying. The segments should be labeled A1A, B1B, etc. Begin by putting titles in the boxes as shown to the right.

 

2. The second Excel chart should have 8 columns that show the following:
Begin by creating a chart like the one below.

  • segment
These should be titled: first line = A1A; second line = B1B...
Points on vertical lines should be labled A1, B1, C1, ... Z1, AA1, BB1
Points on horzontal lines should be labled A, B, C, ... Z, AA, BB
  • coordinates (x1,y1) of the first endpoint of a segment.
The coordinates should be in two different columns. (See Columns A and B, above.)
  • cordinates (x2,y2) of the second endpoint of that segment.
These coordinates should also be in two different columns (See Columns D and E, above.)
  • slope 
     
m=(Y2 - Y1)/(X2 - X1).
1. Click in the cell just below "Slope..." (F2)
2. Type an = sign in this cell.
3. Type a parenthesis, then click on a known y2 and subtract a second known y1 form the same row.
4.  Divide by the difference between the (x2 - x1).
Be sure to use the addresses of the boxes, not the actual numbers or values.

5. Press Enter, then highlight the number that appears and the rest of Column F.
6. With the cells in Column F highlighted, find Fill in Edit, and click on Down (Ctrl-D). All of the values for slope should appear.

  • y-intercept
     
b = y-mx
1. Click in the cell just below "y-intercept..." (G2)
2. Type an = sign in this cell.

3. Insert a know y1 by clicking, for example, on C2. 
4. Subtract the slope in this row ( F2)
5. Click on the star at the top of 8 (*) to show that you are miltiplying by a known x1.
6. Click on B2.
7. Enter, then highlight Column G, find Fill in Edit, and click on Down. All of the values for the y-intercepts should appear. 

NOTE: Select all the cells that either have numbers in the already or that will have numbers, and go to Cells in Format. Click on the Number tab, then click on Number, and Click on Fraction and Up to two numbers.

  • equation for each of the line segments
Write the equation for each line using the y-intercept form: y = mx + b. See these examples in Column H:

 

 

3. Print both the length chart and the second chart. Before you do, click on Gridlines under Sheet in Page Setup.

 

 Click here to print this page.