CMAP 252 - Spreadsheet Applications

Provides study in the creation, design, and use of spreadsheets for business applications. Emphasis focuses on formatting and enhancing spreadsheets, maintaining workbooks, working with lists, using appropriate functions, interpreting data, and template design. PREREQUISITE(S): CMAP 120 or consent of department. Three hours each week. Formerly CA 252.

3 semester hours

Course Outcomes:
Upon course completion, a student will be able to:

Apply alignment and font style formatting.
Apply font color and fill color.
Create and print a Bar and a Pie Chart, using data from the spreadsheet.
Create and run a Macro within spreadsheets.
Create and save an income/expense spreadsheet for a business
Format the spreadsheet for currency, numbers, dates, and percentages.
Sort a column in a spreadsheet in ascending order
Write a formula using the IF, PMT, Sum, Average, Max, and Min Function.

View Schedule of Classes