final project deliverables - emp.byui.edu class - final project... · final presentation. final...
TRANSCRIPT
Final Project Deliverables
Final Project Deliverables: Excel Application
• Essentially a compilation of the Project Prep assignments with:• A Theme & Target Audience
• Professional, Easy-to-Navigate User Interface
• Demonstrate multiple Project Elements in a cohesive way
Final Project Deliverables: Excel Application
• Fundamentally Excel with VBA as needed
• Ideally, Single File with Multiple Tabs as needed
• Include Many Project Elements• More Project Elements = More Points Earned on Final Project
• More Advanced Project Elements = More Points Earned on Final Project
• Major Project Elements Include:• Table Calculations
• Trajectory Plot
• VBA/Custom Dialog Boxes
• Animation
• Multi-Color Trajectory/Multiple Multi-Color Trajectories
Final Project Deliverables: Excel Application
• Theme of your own choosing• Snowboarding, Basketball, Soccer, Baseball, Civil War Cannon, etc…• Note that long distance artillery do NOT work very well
• Audience of your own choosing• Middle school, College physics student, etc…
• Professional Appearance• Minimize scrolling• Appropriate color scheme
• Appropriate Documentation
• Your finished application should look substantially different from others in the class
Final Project Deliverables: Presentation
• Explanation and demonstration of your finished application
• Clearly show/discuss project elements used in your application
• Discuss any major hurdles in completing the project
• Professional, effective, well-paced delivery of presentation
• Entire team present and professional in appearance
• Single or multiple presenters
• Recommend using single laptop for presentation
• 4:30-5:30 minute time limit window; penalty for too long/short
Final Project Deliverables: Poster
• Color 11” x 17” Poster
• Tell the story of your project with graphs, tables, and text• No text smaller than 10 point font
• Include name of each team member on poster
If your grade was based entirely on this Poster, does it reflect your teams effort on this application
Final Project Deliverables: Project Log
• Excel document for each individual:
• Include: Class time, Prep assignments, Project work
• Exclude: time spent on Units 1-8
• Expectation: 40 hours• Approximately 20 hours on class time/prep assignments
• Approximately 20 hours on actual final project
• Include this information on Excel document
Final Project Deliverables: Evaluations
• Each team will complete a 1 page form detailing the contribution of each team member.• Who on the team was responsible for what section of the
project/presentation
• Each individual will complete a peer evaluation on their team to ensure that each team member completed their fair share of the project
• Each individual will judge the presentations of the other teams
Forms for each of these evaluations will be provided to you at the final presentation
Final Project Deliverables: Miscellaneous
• Each team will complete a 1 page form summarizing the a self-assessment of the project elements used in the final project. This form will be provided to you at the final presentation.
• Each team will submit an electronic copy of their final project (Excel file)
Grading of Final Project
• Number of Project Elements
• Quality/Difficulty of Project Elements
• Theme
• Professionalism
• Presentation
• Poster
• Evaluations
• Project Log
Table Calculations
• Calculations w/o Air Resistance
• Calculations w/ Air Resistance
• Calculations for Color Trajectory
• Calculations for Multi-Color Trajectory
• Facilitates Updates
• Well organized, Headings, Use of Color, etc.
Trajectory Plot
• Plot w/o Air Resistance
• Plot w/ Air Resistance
• Facilitates Updates
• Well organized, Headings, Use of Color, etc.
VBA/Custom Dialog Boxes
• VBA Usage/Complexity
• Custom Dialog Box Usage/Complexity• Usage of default values
• Code Structure/Comments
• Incorporation of controls not covered in class
Animation
• Animation w/ Air Resistance
• Animation w/o Air Resistance
• Color Trajectory Animation
• Checkbox to toggle Path/Projectile
• Facilitates Updates
Multi-Color Trajectory
• Multi-Color Trajectory w/ Air Resistance
• Multi-Color Trajectory w/o Air Resistance
• Multiple Multi-Color Trajectory w/ Air Resistance
• Multiple Multi-Color Trajectory w/o Air Resistance
• Well organized, Headings, Use of Color, etc.
Presentation
• Well organized & delivered
• Addresses key points
• Adherence to Time Limits
Overall Level of Complexity
• Barebones (what’s the least amount of work I can do to pass this class)
• Solid, well organized and executed
• Advanced/innovative features
Originality
• What stands out as unique/creative/original as compared to others
Documentation/Instructions
• Headers/Comments in Code
• Sufficient Instructions/Help
Theme
• Is the theme clearly defined
Audience
• Is the audience clearly defined
Design
• Overall design• Well thought out
• Cohesive
• Intuitive
• Professional Appearance• Color scheme
• Minimize scrolling
•
Important Dates
• Fri 7/12, 11:59 pm – FP7 Assignment (Color Trajectories Plot)
• Sat 7/13 11:59 pm – Unit 4-8 TA-graded submissions deadline
• Mon 7/15 (12:45-1:45, during class time) – Makeup Exam (optional) – SIGN UP Today
• Project Work Day (attendance optional, assistance available)Mon 7/15 Wed 7/17 Fri 7/19
• Final Project Presentations & All Deliverables• Mon 7/22 2:00-3:30 pm
• Tue 7/23 11:59 pm – Unit 1-8 auto-graded submissions deadline
• Tue 7/23 11:59 PM – End of Semester surveys