Feb 21, 2019  
Middlesex Community College Academic Catalog 2018-19 
    
Middlesex Community College Academic Catalog 2018-19

CAP 155 - Spreadsheet Applications

3

Course Description: Spreadsheet Applications provides students and professionals with advanced spreadsheet tools to help solve complex problems. Through demonstration and hands-on computer exercises, students apply advanced problem solving tools to capture, display, manipulate and analyze data in such areas as budgeting, loan analysis, and business graphics.
Prerequisite(s): Completion of CAP 101
Corequisite(s): MAT 070 or completion of Modules 1-8 in Preparation for College Math
Note(s): Specific configurations of hardware and software may vary by campus.


Course Student Learning Outcomes:
  •  Apply spreadsheet financial formulas and functions to determine loan payments, future values of investments, and loan amortization to calculate the principal repayment of a loan over a period of time
  •  Apply spreadsheet database functions to sort, query, and analyze database table data 
  •  Utilize the spreadsheet charts feature to display data graphically, simulate interest rates, illustrate key points, and make numbers easier to understand
  •  Develop macros to automate multiple common repetitive tasks into one-step keystrokes
  •  Create and organize related spreadsheet data into a structured database table
  •  Create pivot tables scenarios to analyze, compare, and extract large database fields into unique values


Click here for course schedule details, to register for this course, or to view required books for this course.