PLEASE RE-READ AND FOLLOW THE BELOW INSTRUCTIONS! DON’T LOSE POINTS CARELESSLY
This project will assess your skills in Microsoft Office Excel 2013+/365 and Google Docs Sheets based on Chapters 14-16 in the textbook. Some parts of this assignment will use your Morgan State version of Google Docs which can be accessed at https://docs.google.com (login using your Morgan State account!). Remember that Microsoft Word is provided for free to Morgan State students at https://portal.office.com as well.
Detailed instructions are found in the textbook. Export your spreadsheets and Submit as PDF here in Canvas. You can attach all files in a single submission.
Work independently!! Evidence of collaborating with other students or copying work will result in a zero grade and may be reported as academic dishonesty. Use the forums or contact the instructor if help is needed. DO NOT PROCRASTINATE.
This project is work 100 points.
There are two individual parts you must complete.
For FOURTH EDITION textbook users:
Project 14B – Plyo Products Inventory (can do Word or Google Docs version) – (50 points) – optional file e14B_Web is available below.
Project 15B-Web – Google Docs version – Calculate Weekly Sales – (50 points) – required file is available below.
Grading Rubric
For each part you will be assessed on the following:
Ability to properly style and format cells and data (highlighting, number/date format, etc) (5 points)
Ability to use Excel/Google Sheet formulas to automatically calculate results and sort (5 points)
Ability to add charts and sparklines to convey analysis about data. (10 points)
Submission in proper formatting, file type, and name at bottom of each Excel/PDF page (10 points)
Save your completed work as a PDF document. Go to File -> Download -> PDF or print to PDF. Upload the final PDFs here in Canvas for credit. Do NOT share your work with me via email.
Over all 10 points for properly submitted as PDF with footers as dictated in textbook instructions. Be sure to name each pdf file in the following format YourLastname_YourFirstname_ProjectID_ProjectName.pdf. For example, if I was a student one of my file submissions would be thus: Theodore_Jamal_15E_Gym_Sales.pdf
Due 11:59pm day of the due date. If you are having trouble contact me ahead of time. If you need help, you can email me your progress by Wednesday before due date and I will give you feedback. Or meet with me during Office Hours via Google Hangouts video chat. It allows us to share screens so I can see your desktop and work.
Google Spreadsheets will not work for this assignments. Must be Excel. If you’re using a Mac, you may have to do things slightly differently to complete the steps, but I won’t be able to assist. Just get a close as you can.
SAVE EACH ONE AS : Green_ Alexandria_14B_Plyo_Products
The second chart should be saved as Green_Alexandria_15B_Weekly_Sales
Follow directions specifically use files and use them in order & use excel. If you have any questions, ask.