CIS 1222 - Advanced Spreadsheets

 

INSTRUCTOR INFORMATION

ORIENTATION AND DEADLINE DATES

 

This is an information sheet only, not the course syllabus.

 

COURSE DESCRIPTION

Advanced features and analytical concepts for an electronic spreadsheet program.  Customization, automation features, advanced data analysis, and summarization tools will be explored. 

Prerequisite: CIS 1221 or equivalent, or consent of instructor.

2 Credit Hours 

 

COURSE MATERIALS

Required Textbook:                  Advanced Concepts in Excel 2003 Volume II with CD, 5th Edition, by Karen Jolly.  Scott/Jones.   ISBN 1-57676-148-7

                                                               

VIDEOTAPES/AUDIOTAPES
None

 

OTHER MEDIA
3.5” high-density floppy disks and/or zip disk

Student Course Materials (mailed to you)

Answers CD (mailed to you)

 

ORIENTATION/ATTENDANCE
Orientation not required.

 

EVALUATION/GRADING
Ten assignments, three exams.

Unit 1 must be completed by mid-term (mid-semester) or you will receive zero point for all Unit 1 assignments, including the Exam 1.

 

COURSE OUTLINE

 

Unit

Required Text

Activity

Exam Number

1

Ch 14: Outline, Consolidate, Audit, Protect,

     Share, and Merge Excel Documents

Ch 15: Creating and Enhancing Charts

Ch 16: Working with Advanced Functions

Business Solutions (BS) 14-1 (no oral presentation)

On The Job (OTJ) 15-4

(no printout)

BS 16-2

(no oral presentation)

Exam 1

2

Ch 17: Using Named Cells

Ch 18: Nesting Functions and Advanced Lookup Tables

Ch 19: Advanced Features of List Management

BS 17-2

 

OTJ 18-4

 

BS 19-2

Exam 2

3

Ch 20: using SubTotal and Conditional Formatting Features, Customize a Menu

Ch 21: Creating PivotTables and PivotCharts

Ch 22: Using Data Analysis Tools of Data Tables, Goal Seek, Solver, and Scenarios

Ch 23: Working with Forms and Validation

BS 20-1

BS 21-1

(no oral presentation)

BS 22-3

(no oral presentation)

BS 23-2

(no printout)

Exam 3