For the macro case study, you need to do three things:
1. Describe the organization that you will be using for this project. It will be a hypothetical organization that is modeled after a business. Make it easy on yourselves and pick a business type with which someone in your group has some familiarity (family business, place you've worked, etc.). Tell me enough about it so I will be able to evaluate the appropriateness of the macros that you intend to create.
2. Describe three business problems that you want to address. Examples could be automating payroll, scheduling employees, inventory management, invoicing, etc.
3. Describe the macros that will address these problems. (Please do point 3 in an Excel file).