Skip to main content
guest
Join

Help

Sign In
ICS Tampa Wikis
Home
guest

Join

Help

Sign In
Wiki Home
Recent Changes
Pages and Files
Members
ICS School Wiki Home
Spanish Lessons
Gr 6 Scratch Programming
Gr 7 Technology Research
Gr 8 Media Literacy
Digital Citizenship
Spreadsheet
Links:
Coders 3_4
Scratch MIT
Spreadsheet Calculations
Edit
12
…
0
Tags
No tags
Notify
RSS
Backlinks
Source
Print
Export (PDF)
An introduction to Spreadsheets Using OpenOffice
If you do not have OpenOffice, download it for free from
OpenOffice.org
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..
After completing the tutorials complete the
Art of Budgeting Assignment
.
Next complete the
Assignments  Planets
.
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
2. Edit Data
3. Format Numbers
4. Cells, Formatting, Formulas
5. Formatting, Graphs & Charts, Column Widths
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
7. AutoSum Formula
8. Entering Formulas  (Note: He messes up the first formula but then gets it right!)
Show the completed work to Mrs. Carrier
After completing the Tutorials above, complete each of the assignments below.
Assignments  Planets
.
Art of Budgeting Assignment
Javascript Required
You need to enable Javascript in your browser to edit pages.
help on how to format text
Turn off "Getting Started"
Home
...
Loading...
An introduction to Spreadsheets Using OpenOffice
View and listen to the OpenOffice Spreadsheet Tutorials: Open an OpenOffice Spreadsheet on your computer. Follow along with the instructions.
1. Enter Data
2. Edit Data
3. Format Numbers
4. Cells, Formatting, Formulas
5. Formatting, Graphs & Charts, Column Widths
6. Sorting Data
7. AutoSum Formula
8. Entering Formulas  (Note: He messes up the first formula but then gets it right!)
After completing the Tutorials above, complete each of the assignments below.
Assignments  Planets.
Art of Budgeting Assignment