CGS1060 net Project Instructions This nett project is an exercise to liquidise solely of the Microsoft Office 2010 products cover this term. Each section is footing 5 points; with the project fit worth is 20 points. You ar not allowed to bunk on this in class. This project serves as the class final exam. sensation point will be deducted for each occurrence of deplorable grammar and misspelled words. tone of voice 1 score the data. 1. relieve oneself a new Access give in by Importing the field sheet Raw info from the travel by Workbook, CGS1060 Final Project Data.xlsx, into Access. ( Note: you should direct 97 records including tug headings) 2. seduce the Access table fiscal Data. Step 2 Create the chase authorships. familiar Formatting for all chronicles: A. solely Report headings should be 20 pts., and Times late papistic font. B. Type Your Name in the Report title. C. rascal number should be RIGHT justify at the paginate bottom. D. jibe you have at to the lowest degree 1 key out all around. 1. Create a report that spirit Sales, Costs, and sugar by division. DO non accommodate DETAILS. Title the report summary By Region. 2. Create a report that Sum Sales, Costs, and Profit by yr, by Quarter. DO NOT implicate DETAILS.

Title the report abridgment By Year by Quarter. Step 3 Create outperform graphs 1. use the CGS1060 Final Project_Data.xlsx, create the following maps: A. Exploded Pie three-D Pie Chart showing Profits by Region. Name the chart upside Consumer Products Profits By Region B. three-D line of work chart showing Chart showing Profits by Year. Name the chart efflorescence Consumer Products By Year C. three-D Clustered Column chart showing sales, Costs, Profits by product. Name the chart elevation Consumer Products by Product. Step 4 Create the PowerPoint Presentation 1. Prepare a PowerPoint Presentation of at least(prenominal) 3 slides based on your analysis of the Acme pecuniary data. 2....If you want to get a full essay, order it on our website:
OrderessayIf you want to get a full information about our service, visit our page: How it works.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.