Portland Community College | Portland, Oregon

Improve computation skills as related to business by using spreadsheets with emphasis on critical thinking. 

• Develop accurate, readable worksheets for a variety of business applications.

• Use critical thinking to independently design and create complex worksheets.

• Performance tests

• Objective tests

• Individual Project

Themes, Concepts, Issues: 

• Communicate effectively using appropriate spreadsheet vocabulary.

• Use critical thinking in designing spreadsheets for business applications.

• Proofread for accuracy in the entry of data and creation of formulas.

• Assess the document for readability.

• Make effective use of spreadsheets with other applications including the Internet.

Competencies and Skills: 

• Use spreadsheets to manage financial data.

• Create formulas and use functions for business.

• Plan, create, modify, and enhance the appearance of spreadsheets and charts.

• Use list features such as conditional formatting, sorting, and filtering.

• Use pivot tables and PivotCharts to summarize data in lists.

• Create templates and use 3-D referencing to consolidate data.

• Use lookup tables and linking to increase productivity.

• Generate Web pages and hyperlinks to other documents.

• Use spell check and auditing tools to assure accuracy of documents.

• Design spreadsheet applications using natural language, validation, logical, and protection features.

• Create macros using the macro recorder; edit and print macros using Visual Basic Editor.

• Perform cost-volume-profit analysis using one- and two-variable data tables.

• Enhance decision-making skills by using the scenario manager, goal seek, and the solver features.

• Import data into Excel from text files, databases, the Internet, and XML documents.

• Use Visual Basics to enhance business applications.