Units: |
1.00 |
Prerequisite: |
None. |
Hours: |
18 hours lecture |
Description: |
The course introduces
spreadsheet software. Topics include navigating a
spreadsheet, editing and formatting data, using
formulas and functions, inserting and formatting
charts and graphics, basic database features, and
analyzing data. |
|
Section 3: Learning Outcomes and Objectives
Upon completion of this course, the
student will be able to:
- plan, build, test, and document worksheets
- create formulas and manipulate data using
mathematical operators in addition to financial,
statistical, and logical functions
- format a spreadsheet using colors, patterns, and
borders
- design worksheet entries with relative, mixed, and
absolute cell references
- plan and construct various types of charts based on
the most effective and appropriate display of data
- analyze worksheet data using "what-if" scenarios and
"Goal Seek"
- evaluate basic database sorting and filtering
techniques
- assess data from the Internet using a browser,
search, and hyperlink capabilities
- use web query features to get real-time spreadsheet
data from web sites
- design headers, footers, annotations, and other
documentation
|