Question: I need help with my excel project below is the instructions and the cars I have to compare 2018 Honda Accord vs 2018 Honda Camry.
CMP 117-Excel Project Date assigned: September 29, 2018 LATE PENALTY-20 pts off if handed 1 day late After I day late, 100 pts of)) Date due October 0, 2018,29 Choose a first choice and a second choice from the topics below: Passenger Cars Sport Utility Vans Pickup Trucks Compact Cars Hybrid Electric 1. Convertibles Luxury Cars MiniVans Sports Cars Crossover Commercial Trucks Wagons E-mail me ASAP your project topic choices (first and second choice with 2 different NEW vehicles for each choice) WITH relevant web reference links. I will assign the topic choice based on the date/time order I receive your project e-mail choice. If your topic is already taken, I will go with your second choice. If that choice is already taken, then I will assign you a new topic choice. For ex. Topic #1-Crossover (Honda CRV vs Toyota RAV) with web site references 2. Topic -Compact Cars (Honda Civic vs Toyota Corolla) with web site references. 3. 4. Create an Excel spreadsheet comparing 2 vehicles in the same topic class. The spreadsheet should contain detailed vehicle specifications (for example, weight, engine siza, horsepower, cargo space, braking distance, acceleration time, and more). The spreadsheet should have the basic features with the basic price The spreadsheet should also have the optional features listed with their respective prices. Make sure the spreadsheet has a total price with the ability to adjust to automatic changes. For example if I delete an option the total should reflect this change automatically (as discussed in class) 5. 6. 7. VERAGE functions in working with the total prices for each vehicle. 9. 10. 11. Create 2 relevant charts based on your vehicle data. Save the Excel spreadsheet. Create name, date, and Project Topic Choice. Write an introduction about your Project Topic Choice. Bring in all the spreadsheet data and charts into Word. Determine and list at least 5 relationships based on the vehicle data. List and explain the relationships of the data in this Word project. Write the PROS and CONS for each vehicle. Write a summary analysis and in your opinion which is the BEST vehicle (insurance costs, safety features, overall features, etc.) in that class. Justify your answer a Word document. This document should include a cover page listing the Class name, your 12. 13. 14. 15. 16. 17. Include boldfacing, italics, underlining, font size, etc. in the Word document 18. Bring in at least 3 project related pictures into this Word document. 20. 21. E-mail me your Word project document and Excel project spreadsheet in 1 e-mail. Do NOT give me just the web address as your reference! Hand everything in a binder. Points will be taken off if the above specifications are not met. Use appropriate Subject line in your e-mail as discussed in class. Notes: Points will be taken off if the above specifications are not met. Grading will be based on content, packaging, and quality of work CMP 117-Excel Project Date assigned: September 29, 2018 LATE PENALTY-20 pts off if handed 1 day late After I day late, 100 pts of)) Date due October 0, 2018,29 Choose a first choice and a second choice from the topics below: Passenger Cars Sport Utility Vans Pickup Trucks Compact Cars Hybrid Electric 1. Convertibles Luxury Cars MiniVans Sports Cars Crossover Commercial Trucks Wagons E-mail me ASAP your project topic choices (first and second choice with 2 different NEW vehicles for each choice) WITH relevant web reference links. I will assign the topic choice based on the date/time order I receive your project e-mail choice. If your topic is already taken, I will go with your second choice. If that choice is already taken, then I will assign you a new topic choice. For ex. Topic #1-Crossover (Honda CRV vs Toyota RAV) with web site references 2. Topic -Compact Cars (Honda Civic vs Toyota Corolla) with web site references. 3. 4. Create an Excel spreadsheet comparing 2 vehicles in the same topic class. The spreadsheet should contain detailed vehicle specifications (for example, weight, engine siza, horsepower, cargo space, braking distance, acceleration time, and more). The spreadsheet should have the basic features with the basic price The spreadsheet should also have the optional features listed with their respective prices. Make sure the spreadsheet has a total price with the ability to adjust to automatic changes. For example if I delete an option the total should reflect this change automatically (as discussed in class) 5. 6. 7. VERAGE functions in working with the total prices for each vehicle. 9. 10. 11. Create 2 relevant charts based on your vehicle data. Save the Excel spreadsheet. Create name, date, and Project Topic Choice. Write an introduction about your Project Topic Choice. Bring in all the spreadsheet data and charts into Word. Determine and list at least 5 relationships based on the vehicle data. List and explain the relationships of the data in this Word project. Write the PROS and CONS for each vehicle. Write a summary analysis and in your opinion which is the BEST vehicle (insurance costs, safety features, overall features, etc.) in that class. Justify your answer a Word document. This document should include a cover page listing the Class name, your 12. 13. 14. 15. 16. 17. Include boldfacing, italics, underlining, font size, etc. in the Word document 18. Bring in at least 3 project related pictures into this Word document. 20. 21. E-mail me your Word project document and Excel project spreadsheet in 1 e-mail. Do NOT give me just the web address as your reference! Hand everything in a binder. Points will be taken off if the above specifications are not met. Use appropriate Subject line in your e-mail as discussed in class. Notes: Points will be taken off if the above specifications are not met. Grading will be based on content, packaging, and quality of work
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
