Spreadsheet+Calculations

An introduction to Spreadsheets Using OpenOffice

 * 1) If you do not have OpenOffice, download it for free from OpenOffice.org
 * 2) To learn to create and use spreadsheets, view and listen to each of the tutorials below. Let Mrs. Carrier see your work after Tutorial 5 and 8..
 * 3) After completing the tutorials complete the Art of Budgeting Assignment.
 * 4) Next complete the Assignments - Planets.
 * 5) View Statistics on TED


 * View and listen to the OpenOffice Spreadsheet Tutorials: Open an OpenOffice Spreadsheet on your computer. Follow along with the instructions.**

**1. Enter Data**
media type="youtube" key="yKlxTNrfaKU" height="315" width="420"

2. Edit Data
media type="youtube" key="w2yd_rsfGx4" height="315" width="420"

media type="youtube" key="NVBiI-y7sDY" height="315" width="420"
 * 3. Format Numbers**

**4. Cells, Formatting, Formulas**
media type="youtube" key="fT7KdzwAnr4" height="315" width="420"

**5. Formatting, Graphs & Charts, Column Widths**
media type="youtube" key="Bj8bNCbfjVE" height="315" width="420"
 * **You need a spreadsheet with data to crate the chart. Enter the following information on a spreadsheet with the words Week 1 in cell C3.**
 * **You can copy the data below and paste in a spreadsheet to get it started.**
 * **Note that my numbers below do not exactly match those on the tutorial, but they are close enough to use for the graph.**
 * **The title is Takings for the Week. The X axis is Weeks and the Y axis is Value in Dollars.**
 * **Show the completed graph to Mrs. Carrier.**
 * || Week 1 || Week 2 || Week 3 || Week 4 ||
 * Monday || 12.80 || 17.30 || 11.36 || 14.97 ||
 * Tuesday || 14.80 || 18.80 || 17.48 || 17.17 ||
 * Wednesday || 6.80 || 14.76 || 12.56 || 12.23 ||
 * Thursday || 3.40 || 7.48 || 5.23 || 5.08 ||
 * Friday || 58.90 || 61.90 || 29.00 || 10.47 ||

6. Sorting Data
media type="youtube" key="3EblW2DLq0g" height="315" width="560"

7. AutoSum Formula
media type="youtube" key="R93YI6D1OM8" height="315" width="560"

8. Entering Formulas - (Note: He messes up the first formula but then gets it right!)
media type="youtube" key="-cA_x7RV0iw" height="315" width="560"
 * **Show the completed work to Mrs. Carrier**

=After completing the Tutorials above, complete each of the assignments below.=
 * 1) ==Assignments - Planets.==
 * 2) ==Art of Budgeting Assignment==