[[
spreadsheet_class
]]
Bworks wiki
Trace:
»
spreadsheet_class
Table of Contents
Spreadsheet Class
Use of Spreadsheets
Parts of a Spreadsheet
Help File
Ideas for Assignment/Lecture
Spreadsheet Class
A spreadsheet class is being considered for the 2008
Adult Earn-A-Computer Classes
.
Use of Spreadsheets
Accounting
Mathematics
Invoices
Graphing / Charts, business analysis
Point out upside/downside of spreadsheets and alternatives
Quick, customizable
Can be over-used and become the Hammer in the “If all you have is a Hammer, everything looks like a nail” analogy.
Can be used as small databases/storage, but usually only stores 64,000 rows of data.
Quicken / Microsoft Money
Peachtree Accounting
Other business / computational software that is more specialized.
Parts of a Spreadsheet
Formulas
Cells
Absolute versus Relative Cell references.
Formatting (Important)
Data Types (Date, Numeric)
Worksheets
Functions
Graphs/Charts
Free and Commercial Plug-ins
Help File
Most important part of the program!
Searching help file
Ideas for Assignment/Lecture
The instructor could create a
simple
checkbook register
Or, stock performance tool
Show the myriad of accounting functions, just to give students a starting point for something they might want to do.
spreadsheet
,
excel
,
calc
,
adult-earn-a-computer
spreadsheet_class.txt · Last modified: 2008/08/20 11:42 by nate