Desktop and Modeling Solutions

Topics

• To master the vocabulary of personal computing.
• To understand the essentials of desktop and file management, especially with regard to security, safety, privacy, and protection against data loss.
• 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.
• 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.
• 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.
• 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.
• To expand students' ability to work with compound and nested logic within Excel formulas.
• To learn how to implement data protection and validation strategy to maximize model robustness.
• To learn how to use macros to automate redundant data management tasks.
• 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.
• 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.

Official roster learning outcomes