Effective: 2023-05-01

Course Description

The course outline below was developed as part of a statewide standardization process.

General Course Purpose

This course is designed to provide students with a working knowledge of a major microcomputer spreadsheet program. Emphasis is on the functional rather than the technical approach to understanding, using, and managing electronic spreadsheets for business analysis and systems.

Course Objectives

• Civic Engagement
• Communicate information legally and ethically using a variety of channels directed at a range of audiences.
• Critical Thinking
• Demonstrate the importance of decision-based analysis tools within spreadsheets.
• Demonstrate the ability to make data driven decisions based on a variety of frameworks.
• Demonstrate the ability to forecast future trends with scenario tools.
• Written Communication
• Demonstrate competency to create charts and spreadsheets to present data.
• Demonstrate the ability to format charts and spreadsheets to enhance usability and data driven decisions.
• Apply spreadsheet design principles to worksheets, tables, and charts.
• Quantitative Literacy
• Demonstrate the creation and design of spreadsheets.
• Create functions and formulas within spreadsheets.
• Create macros as a time-effective way to prepare and maintain spreadsheets.
• Professional Readiness
• Recognize the importance of spreadsheets and data analysis in business systems.
• Demonstrate the use of spreadsheets in business systems.
• Apply data analysis tools in decision making for business systems
• Scientific Literacy
• Demonstrate the use of scientific and/or mathematical formulas to have a better understanding how a spreadsheet can assist with decision making for business systems.

Major Topics to be Included

• Designate and Work with Ranges
• Specific Student Content Learning Outcomes for Topic/Unit. The student will be able to . . .
• Select cells, images, and charts.
• Perform move, copy, and paste operations.
• Perform spell check.
• Find and Replace content and formats.
• Insert special characters and symbols.
• Navigate through a data range.
• Print a data range.
• Create range names; create formulas using range names.
• Apply Functions and Formulas
• Specific Student Content Learning Outcomes for Topic/Unit. The student will be able to . . .
• Create formulas using the SUMIF, COUNTIF, MATCH and INDEX functions
• Move and copy functions and formulas.
• Using operator precedence in formulas.
• Demonstrate the differences of relative, absolute, and mixed cell references.
• Demonstrate the use of math and statistical functions.
• Demonstrate the use of logical and financial functions such as PMT, FV, and PV.
• Demonstrate the use of text functions.
• Demonstrate the use of nested functions such as IF.
• Validate data.
• Audit worksheet formulas.
• Format Spreadsheets, including Conditional Formatting
• Specific Student Content Learning Outcomes for Topic/Unit. The student will be able to . . .
• Change fonts and page setup.
• Demonstrate the use of AutoFill, AutoFormat and series.
• Format columns and rows.
• Merge cells and work with cell alignment.
• Apply borders and shading.
• Add headers and footers.
• Apply conditional formatting.
• Use Graphics to enhance the Visual Appeal of Spreadsheets
• Specific Student Content Learning Outcomes for Topic/Unit. The student will be able to . . .
• Insert and format Clip Art.
• Insert and format Pictures.
• Insert and format SmartArt.
• Insert and format WordArt.
• Insert and format Shapes.
• File Operations
• Specific Student Content Learning Outcomes for Topic/Unit. The student will be able to . . .
• Save a worksheet using the default type or different format.
• Demonstrate the use of page setup features to change settings.
• Create and delete manual and automatic page breaks.
• Preview and print or publish a worksheet.
• Charts
• Specific Student Content Learning Outcomes for Topic/Unit. The student will be able to . . .
• Analyze worksheet data to apply appropriate chart type.
• Create charts.
• Edit chart data and objects.
• Move and copy charts.
• Multiple Worksheets and Workbooks
• Specific Student Content Learning Outcomes for Topic/Unit. The student will be able to . . .
• Rename and rearrange worksheet tabs.
• Move and delete worksheets.
• Group and ungroup worksheets.
• Move and copy worksheet groups.
• Manage the workspace.
• Link multiple worksheets and workbooks.
• Create 2-D and 3-D references.
• Spreadsheets as a Database, Ranges, Lists, and Tables
• Specific Student Content Learning Outcomes for Topic/Unit. The student will be able to . . .
• Apply proper design of a spreadsheet database.
• Define data types.
• Manipulate columns of data.
• Apply data validation features within a spreadsheet database.
• Find and eliminate duplicate records.
• Sort a range/list/table.
• Apply Auto filter to a range/list/table.
• Apply an Advanced filter to a range/list/table.
• Use AutoFilter to select data based on content and format.
• Apply subtotals to a list of data.
• Create custom views.
• PivotTables and PivotCharts
• Specific Student Content Learning Outcomes for Topic/Unit. The student will be able to . . .
• Create and manipulate PivotTables.
• Create and manipulate ting PivotCharts.
• Apply Trendlines to a PivotChart.
• Insert Slicers.
• What-If Analysis
• Specific Student Content Learning Outcomes for Topic/Unit. The student will be able to . . .
• Perform a What-If Analysis using Goal Seek.
• Find the optimal solution for a complex problem using Solver.
• Analyze data involving multiple scenarios using the Scenario Manager.
• Create Summary Reports and Scenario PivotTable using the Scenario Manager.
• Create One Variable and Two Variable Data Tables.
• Forecast future trends.
• Analyze variances.
• Demonstrate data driven decisions based on a variety of frameworks.
• Collaboration
• Specific Student Content Learning Outcomes for Topic/Unit. The student will be able to . . .
• Protect worksheets and workbooks.
• Share workbooks.
• Demonstrate collaboration using tracking changes and adding comments.
• Create and use Templates.
• Upload a workbook to cloud storage.
• Macros and Visual Basic for Applications
• Specific Student Content Learning Outcomes for Topic/Unit. The student will be able to . . .
• Record and execute a macro.
• Identify and print the VBA code for a macro.
• Apply appropriate security levels within Excel to control macro execution.
• Customize the Quick Access Toolbar with a Macro button.
• Add Form Controls and ActiveX Controls.
• Edit properties of Form Controls and ActiveX Controls.
• Interchange Data with other Application Programs
• Specific Student Content Learning Outcomes for Topic/Unit. The student will be able to . . .
• Demonstrate object linking and embedding to share data between worksheets and files.
• Create and edit Hyperlinks.
• Merge data with other documents.