CIST 2128 Syllabus

Subject Code

CIST

Course Number

2128

Course Title

Comprehensive Spreadsheet Techniques

Prerequisites

None

Corequisites

None

Terms Offered

Credit Hours

Course Description

This course provides students with knowledge in spreadsheet software. Topics include creating and manipulating data, formatting data and content, creating and modifying formulas, presenting data visually, and collaborating on and securing data.

A work ethic grade is assigned for this course. For more information see Work Ethics.

Course Outcomes

Format Data

• Explain the use of data integrity.
• Perform the steps to modify cell contents and formats.
• Demonstrate how to change worksheet views.
• Demonstrate managing and formatting worksheets.
• Demonstrate formatting cells and cell content.
• Convert data to a table.
• Create, edit, and delete defined names for cells and ranges.

Modify Formulas

• Demonstrate the ability to reference data in formulas.
• Summarize data using a formula and subtotals.
• Use formulas to conditionally summarize data.
• Demonstrate the ability to look up data using a formula.
• Use conditional logic in a formula.
• Show the ability to format or modify text using formulas.
• Demonstrate the ability of display and print formulas.

Present Data Visually

• Demonstrate creating, formatting, and modifying charts.
• Demonstrate how to apply conditional formatting.
• Demonstrate how to insert and modify illustrations.
• Describe the purpose for outlining, sorting, and filtering data.
• Create and modify PivotTables, PivotCharts, and Data Tables.

Troubleshoot and Support Application Software

• Demonstrate how to protect, share, and distribute workbooks.
• Utilize the print options for printing data, worksheets, and workbooks.
• Demonstrate the ability to control document access.
• Use the skills to attach digital signature.
• Demonstrate effective use of application Help System.
• Create, run, and edit macros.
• Integrate spreadsheets with word processing documents.