Spreadsheet Models for Managers

Problem Set 5Session Links
Course Project Proposals

Be sure to check the list of worksheet functions that are needed for the homework assignments, to see which new functions (if any) might help with this one.

Since macros are not permitted in this homework assignment, be certain that your workbook has no macros.

Remember that some problems are slight extensions of what we show you in demonstrations and the session notes, and some problems are somewhat ambiguous. This is intended to parallel what you'll frequently encounter at work. If you feel a bit confused, there are some things you can do to help clarify things.

Before attempting this homework, you might find it helpful to read about:

• Course Project
• Structuring Excel Models
• What's a Model? What's a Tool?

Your assignment is to write a project proposal for your course project, and collect the complete set of requirements for Word documents. You will submit these documents together, but they are two separate documents.

Requirements Checklist for Word documents

Read the page about the course project, and from that develop a checklist of all the requirements the must be met by the various Word documents. Some requirements, such as those applying to fonts, affect all Word documents. Other requirements, such as those that specify section titles, apply only to one of the Word documents. All told, there are quite a few requirements, and they aren't neatly listed in the course project page.

That's intentional. In typical work situations, when you receive a task to perform, the requirements for that task are not as neatly presented as are the homework problems you have seen so far in this course. So for this effort, you must not only produce a proposal, but you must also produce one that conforms to the detailed requirements listed on the course project page.

Proposal

Your proposal is a Word document that describes the project you intend to do. The format and content of the proposal are described on the course project page.

If your proposal is accepted, you may begin work on your project. Otherwise, you'll have to revise your proposal until it's accepted. Since any work you do to implement your project prior to acceptance of your proposal might turn out not to be useful, it's wise to limit your implementation effort until your project is approved.