You should form your own team of 2-3 members by the deadline specified in the syllabus. If you prefer to work alone, that is fine too.
Topic
Each team will design and create an Excel VBA project of their own choice. The project should be something useful and/or fun that your entire team would enjoy building together. It can be something that automates calculations for another course you're taking, a manual process that you can improve at work, or a simulation of a process that interests you. It can also be for a hobby, a crisis (how about simulating the COVID-19 pandemic?) or a personal need (e.g. how to organize home schooling my children during a pandemic...)
Requirements
The project should meet the following guidelines:
The project should meet the following guidelines:
1. The goals, objectives and functionalities of the project should be clearly defined on a worksheet labeled "ReadMe" - Documentation should be clearly written, and the workflow should be clearly illustrated in a flowchart.
2. At least 100 lines of code in total, and the code should be properly documented/commented
3. At least two subroutines (subs) and at least two functions with input parameters and return values
4. The program should read data from a worksheet using Range or Cells objects
5. The program should write data to a worksheet using Range or Cells objects
6. There should be at least one For Loop, at least one Do While Loop, and at least one Do Until Loop.
7. The program should use at least one 1-D array, and at least one 2-D array.
8. The program should read data from a file or write data to a file on the local computer.
9. The program should utilize a User Form with at least four different types of controls.
10. The program should be easy to understand, intuitive to the user with clear instructions, and execute properly without errors.
Deliverables
1. The team should give a 15-minute presentation in class. The presentation should be a walkthrough of key features and code of the program.
2. The team should submit the complete Excel VBA file through Blackboard.
3. Each team member will complete a peer evaluation form to provide feedback on the contribution of individual team members
Final Presentation Instructions
- Each team should prepare for the allotted time with 1-2 minutes of Q&A
- Presentation should begin with a high-level walk through of the program's functionalities, followed by more detailed walk-throughs of selected code segments that are noteworthy. Point out important or clever designs. Explain these select areas in depth.
- If your assigned time slot does not work, please propose a different time on the same day or 1-2 days prior. Send the proposed time/date to the instructor for approval
- You are required to attend presentations by your peers.
- Presentation highlights key requirements of the final project
- Technical demo highlights key functionalities of the program without error
- Presentation is clear, concise, focused, with good design, time management, and transition
- Presenters address instructor questions thoroughly and thoughtfully