Standard

Posted: 09/10/07

R State Standard

£ Institutionally Developed

College: n/a

CIS 2228 – Comprehensive Spreadsheets Techniques

Course Description:

Provides a study of spreadsheets. Topics include: advanced spreadsheet concepts, development of macros, data integration concepts, troubleshooting spreadsheets.

Competency Areas:	Hours
Advanced Spreadsheet Concepts	Class	4
Development of Macros	D. Lab	4
Data Integration Concepts	P. Lab/O.B.I.	0
Troubleshooting Spreadsheets	Credit	6

Prerequisite: SCT 100

Corequisite:

Course Guide

Competency	After completing this section, the student will:	Hours
		Class	D. Lab	P. Lab/ O.B.I.
ADVANCED SPREADSHEET CONCEPTS		28	28	0
Worksheet appearance	Use various formatting techniques to improve the appearance of a worksheet.
Worksheet organization	Rename a worksheet.
	Insert, move, copy, and delete worksheets.
	Insert and delete cells, rows, and columns.
	Create and use named ranges.
Printing	Preview and modify page setup options.
	Insert and remove page breaks.
	Print all or portion of a spreadsheet.
Formulas	Create appropriate formulas using operators and order of precedence.
	Copy formulas using relative and absolute references.
Charts	Create various charts.
	Format and modify charts.
	Preview and print charts
	Work with embedded charts and chart sheets.
Worksheet enhancements	Use clip art and autoshapes.
	Add and modify text and line objects.
	Add shadow and 3-D effects to objects.
	Modify stack order and grouping objects.
Functions	Use worksheet functions.
	Create natural language formulas.
	Use date and time function.
	Use financial functions.
	Use logical functions.
	Use statistical functions.
	Use lookup and reference functions.
	Use text functions.
Styles and custom formats	Create custom number formats
	Use conditional formatting.
	Define, apply, and remove styles
PivotTables and PivotCharts	Use data analysis.
	Create, modify, and format pivot table reports.
	Create pivot chart reports.
Multiple worksheets and workbooks	Group worksheets to share data, formatting, and formulas.
	Link worksheets and use 3-D references.
	Print multiple worksheets.
	Link workbooks.
	Insert hyperlinks.
Share workbooks	Protect worksheets and workbooks.
	Use passwords.
	Share workbooks.
	Track changes.
	Change workbook properties.
	Create, edit and remove comments.
Using lists	Identify components of a list.
	Use data validation.
	Use data forms.
	Apply data filters.
Audit worksheets	Identify relationships between precedent and dependent cells.
	Trace errors.
	Identify invalid data.
DEVELOPMENT OF MACROS		4	4	0
Spreadsheet macros	Record a macro.
	Run a macro.
	Edit a macro.
	Use workbooks containing macros.
DATA INTEGRATION CONCEPTS		4	4	0
Data integration	Integrate spreadsheet with word processing document and business presentation.
	Integrate spreadsheet with database.
	Import data from other applications.
	Export data to other applications.
	Integrating with the Internet.
TROUBLESHOOTING SPREADSHEETS		4	4	0
	Using the application’s help system.
	Using Internet Help.
	Using technical support.

Suggested Resources

Books:

New Perspectives on Microsoft Office Excel 2003, Comprehensive, 2nd Edition, ISBN: 0-619-26815-8, Parsons, Course Technology

Microsoft Office Excel 2003: Comprehensive Course, ISBN: 1-59136-029-3, Mardar, Course Technology

Microsoft Office Excel 2003: Comprehensive Concepts and Techniques, CourseCard Edition, ISBN: 1-4188-4360-1, Shelly, Cashman, Quasney, Course Technology

SAM 2003 Assessment and Training 3.1, ISBN: 1-4239-1261-6, Course Technology