Lesson 13

Part III (Continuation of Spreadsheet, continued)

In this part, you will learn how to create a scatter plot and then fit a regression curve to it. Many times people will collect data to help them try to predict the future. Once they have enough data, they can plot the data and try to fit a curve to it. This curve is called a regression curve.

1. Creating a Scatter Plot

2. Experimenting with Regression Curves

3. Experimenting with Regression Curves (continued)

Part III


Practice Exercises

  1. Please open the eActivity application.
  2. Open the eActivity named L13_PartIII_a in the Lesson13 folder.
  3. Within the eActivity, expand the Spreadsheet strip and create a scatter plot using columns A and B.
  4. Get a screen capture and paste it into your Lesson13 document (under a title of PART III).
  5. We should zoom the data. Open the View menu and select Zoom Box. Click and drag a box about your scatter plot. Your box will become the new window size.
  6. Get a screen capture. Add two blank spaces following the first screen capture and then paste this one.
  7. Draw a regression curve that you think best fits the data. Select your regression curve so that its equation shows in the status bar.
  8. Get a screen capture. Add two blank spaces following the second screen capture and then paste this one.
  9. You do not have to save this eActivity!

Before continuing to Part IV, please back up your Lesson 13 activities:

  1. Begin by opening the Exchange Window. [Hint: Right click on the ClassPad emulator.]
  2. Click on the + sign in front of the Active Document folder and the ClassPad Manager folder.
  3. Click on the + sign in front of the Lesson_13 file and then the eActivities folder.
  4. Next, click on the folder named Lesson 13 to see the eActivities you just completed. Are they there?
  5. Press (left click) on the Lesson 13 folder and drag it to the CP101_Backup vcp file.

Part IV

Written Exercises

Please copy and paste the following questions into your Lesson13 document (under a title of Part IV) and answer them.

  1. If cell C2 contains =3xB2 and we copy C2 to B5, what will B5 contain?
  2. What does Fill Sequence do?
  3. How do you insert a row?
  4. Name two ways to insert a column.

Reflection Exercises

You have just completed the thirteenth lesson in ClassPad 101. Excellent. Please take a few moments to copy and paste the following four questions at the end of your Lesson13 document and answer them.

  1. Approximately how long did it take you to complete this lesson?
  2. Which activity did you find particularly useful?
  3. Did you find any part of this activity difficult to follow? If so, which part? Also, how did you overcome the difficulty?

Assessment 13a: Continuation of Spreadsheet

Assessment 13b: Uploading your Lesson_13.vcp file