Jan

Spreadsheets

Goals
- Learn to create and manipulate a spreadsheet
Resources
- The tool: OpenOffice.org Calc
- The learning resource: InPictures Web Site Tutorials, http://inpics.net/calc.html
Terms
- cell
- cell format (number, text, value, function, calculation, date, currency)
- row
- column
- label
- macro
- replicate
- template
- worksheet
- “what if” questions
- range
- absolute
- relative reference
Concepts
- Basic Calculations
- Formatting Worksheets
- Manipulating Data
- Advanced Calculations
- Making Data Visible
Projects
- Basic Calculations
  - Add
  - Subtract
  - Multiply
  - Divide
  - Calculate averages
  - Find the maximum value
- Formatting Worksheets
  - Format text
  - Format cells
  - Adjust columns and rows
  - Print worksheets
- Manipulating Data
  - Move, copy, and paste
  - Add/delete columns
  - Add/delete rows
  - Employ multiple worksheets
  - Employ AutoFill
  - Insert/delete worksheets
- Advanced Calculations
  - Create formulas across worksheets
  - Employ absolute references
  - Employ the function wizard
- Making Data Visible
  - Add notes
  - Freeze panes
  - Create charts

Posted by sleduc Uncategorized Subscribe to RSS feed