Intermediate and advanced spreadsheet modeling using current spreadsheet software. Students will develop spreadsheet models that aid research and provide decision support within an organization. Included are such topics as the design and management of worksheets and templates, statistical, financial, database, and spreadsheet manipulation functions, dynamic Web publishing, and basic spreadsheet programming. Prerequisite: CPS 100 or CPS 150 or CPS 201. This course replaces CPS 214. Students who have already taken CPS 214 are not eligible for this course.