Computer Information Science American River College
Courses

CISA 316: Intermediate Electronic Spreadsheets

Units: 2.00
Prerequisite: CISA 315 (Introduction to Electronic Spreadsheets) with a grade of "C" or better
Hours: 27 hours lecture, 27 hours laboratory
Description: This course is a continuation of electronic worksheets with emphasis on workbook design and integration, template design, use of complex formulas, and built-in financial, logical, and database functions. It also includes look-up tables, the use of worksheet analysis tools, macros, and data integration.

Section 3: Learning Outcomes and Objectives

Upon completion of this course, the student will be able to:

  • apply conditional formatting by entering parameters for rules, utilizing predefined rules and constructing new rules for individual or grouped worksheets.
  • restrict data entry and ensure data integrity by creating validation criteria and rules.
  • create and edit links to external references and other workbooks.
  • construct formulas using named ranges and advanced features of financial, logical, lookup, and database functions.
  • produce a worksheet database and manipulate, extract, and analyze data by applying advanced math functions and data filtering options.
  • integrate data from various computer applications and web sites into a workbook using consolidation techniques and prepare workbook data for distribution to other applications.
  • create, edit, and format a PivotTable and PivotChart.
  • audit a worksheet using auditing tools to trace precedents, troubleshoot, and resolve errors in formulas.
  • create, edit, and run macros using shortcut key combinations.
Certificates requiring this course: