ITM 360 Spreadsheet Development and Management Fall 2007 Schedule

Date	Spreadsheet Management	Exercise	Dodge and Stinson Prereading	Chapter	Page
Aug 20	Spreadsheet Risks and Management	Microslo Task	What's New in Microsoft Excel 2007?	1	3
Aug 27	Human Error and Spreadsheet Error	Wall, Mortgage Tasks	Exploring Excel Fundamentals Custom-Tailoring the Excel Workspace Security and Privacy Planning Your Worksheet Design	2 3 4 5	21 83 103 117
Sep 3	Labor Day Holiday	None	None
Sep 10	Before Development	Bubble Charts	How to Work a Worksheet How to Work a Workbook	6 7	125 165
Sep 17	Spreadsheet Development I	Panko Inspection Task	Worksheet Editing Techniques Worksheet Formula Techniques Building Formulas	8 9 12	181 265 247
Sep 24	Midterm I Book through Ch. 12 Lectures through Sept 17	Galletta Tasks Howe & Simkin Task	None
Oct 1	Spreadsheet Development II	Static Testing 1	Recording Macros Creating Custom Functions Debugging Macros and Custom Functions	26 27 28	847 847 859
Oct 8	Spreadsheet Testing	Static Testing 2	Using Functions Everyday Functions Formatting and Calculating Date and Time Functions for Financial Analysis Functions for Analyzing Statistics	13 14 15 16 17	487 497 521 535 553
Oct 15	Spreadsheet Code Inspection	Static Testing 3	Performing What-If Analysis Managing Information in Tables Analyzing Data with Pivot Table Reports	18 21 22	583 667 711
Oct 22	Presentations for Project 1	None	None
Oct 29	Spreadsheet Documentation	None	Creating Graphics Printing and Presenting	10 11	345 403
Nov 5	Midterm II	2 New Tasks	None
Nov 12	Veterans’ Day		None
Nov 19	Business Process Controls	Grading Experiment	Basic Charting Techniques Charting Beyond the Ribbon Working with External Data	19 20 23	615 633 745
Nov 26	Corporate Spreadsheet Management	Grading Experiment	Using Hyperlinks Linking and Embedding	29 30	873 881
Dec 3	Presentations for Project 2	None	None	NA	NA
Dec 10	Final Exam	None	None