Spreadsheeting for Business - ITE 140 at Tidewater Community College
https://courses.vccs.edu/colleges/tcc/courses/ITE140-SpreadsheetingforBusiness
Effective: 2023-05-01
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. Total 3 hours per week.
3 credits
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.