Course Description, Objectives, and Outcomes

Course Description

This course is designed to teach computer users how to develop electronic spreadsheets using spreadsheet software such as Microsoft Excel, to solve business related quantitative problems. Topics of instruction include data entry, formulas, functions, charts, macros, and other beginning to intermediate level features of spreadsheet software. BEFORE ENROLLING: Students should be able to save and retrieve files and perform other basic file management tasks on the computer. (CSU, AVC)

Course Objectives

At the completion of the course the successful student will:

*Describe and explain the purpose of electronic spreadsheets in a business or financial environment.
*Utilize spreadsheet software to enter, format, edit, and manipulate text and numerical data.
*Design and develop spreadsheets using formulas and functions to solve quantitative problems.
*Utilize spreadsheet software to manage multiple worksheets and workbooks.
*Design and develop spreadsheets to conduct what-if analysis.
*Utilize spreadsheet software to create charts and graphs, including sparklines and data bars.
*Incorporate the use of tables, PivotTables, and PivotCharts to filter and analyze quantitative data.
*Design and develop spreadsheet applications, including the use of macros.

Student Learning Outcomes (SLO)

Expected student-learning outcomes for this course are as follows.

Students will plan, develop, and format electronic spreadsheets utilizing formulas and functions to manage financial data in a business environment.
Students will plan, develop, and format electronic spreadsheets utilizing charts and what-if analysis tools to manage financial data in a business environment.

Click the Next button to continue with the syllabus....