PAM 5679 - Desktop & Modeling Solutions

Fall, Spring. 3 credits. Student option grading.

Enrollment limited to: Sloan students.

C. Homrighouse.

This course presents an advanced approach to data-intensive problem-solving using Microsoft Excel. Advanced concepts such as external queries, data tables, arrays, iterative techniques and macros will be reviewed. These will then be incorporated into an integrated business model. Emphasis will be on clear, separated input and output, data integrity, user interface design, documentation, maintainability, robustness and user support.

Outcome 1: To master the vocabulary of personal computing.

Outcome 2: To understand the essentials of desktop and file management, especially with regard to security, safety, privacy and protection against data loss.

Outcome 3: To be able to discriminate between seemingly competing software applications (spreadsheet, database, etc…) and be able to select the best application, or combination of applications, suited to a particular task.

Outcome 4: To become highly proficient in the use of MS Office suite. The focus is on understanding the characteristics of each application and the tasks they are best suited to support.

Outcome 5: To become an effective technological problem-solver, capable of assessing an overall problem, and understanding what the best combination of software applications, tools and techniques are to address the problem.

Outcome 6: To expand students’ Excel function vocabulary into the more flexible function categories, such as text parsing, time and date manipulation, index, lookup and array functions.

Outcome 7: To expand students’ ability to work with compound and nested logic within Excel formulas.

Outcome 8: To learn how to implement data protection and validation strategy to maximize model robustness.

Outcome 9: To learn how to use macros to automate redundant data management tasks.

Outcome 10: To maximize understanding of Excel’s charting engine in order to exploit advanced charting and graphing features.

Outcome 11: To give students the experience and rigor of breaking a substantial problem down into its constituent pieces to allow for programmatic solution.