Computer Information Science American River College
Courses

CISA 318: Exploring Spreadsheet Software

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