Revised 8/2023

ITE 140 - Spreadsheeting for Business (3 CR.)

Course Description

Provides a working knowledge of a commercial spreadsheet package to include design and development of a variety of worksheets, preparing graphs, working with database queries, macro writing, menu techniques, and decision analysis tools. Lecture 3 hours per week.

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 Prerequisites/Corequisites

Prerequisite: Students must be able to read and write at a college level

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.
  •