Author: admin

Name: (Insert Name Here) Excel Assignment (Percentage-of-completion) Required: 1- Using the data provided below you are to input formulas in the area designated below to calculate: % complete, revenue to be recognized in each year, and gross profit to be recognized in each year. (10 points) Hint: I suggest you use formulas with an IF function regarding the gross profit section of your speadsheet because your spreadsheet should be able to calculate correct answers whether a contract generates a profit or loss. 2- Using the data given and the solutions in your spreadsheet generated, prepare all journal entries for year 2023. Whenever possible, the amounts for your journal entries should be formulas that reference the appropriate cells in the calcuations below. (10 points) 3-Once you have completed the spreadsheet save your file with your last name(s) and first name(s) and upload it under Assignments by the assignment due date. Data: Contract price 1,200,000 2022 2023 2024 Costs incurred to date** $280,000 $600,000 $785,000 Estimated costs yet to be incurred 520,000 200,000 0 Customer billings to date** 250,000 500,000 1,200,000 Collections of billings to date** 120,000 320,000 1,040,000 **Hint: You have to figure out the actual cost, billings, and collections for each respective year. The information presented is “to date” not “Costs expended this year” as in the handouts and some of your assigned exercises/problems. Use the format provided below to input formulas for each respective year. 2022 2023 2024 Costs expended to date Estimated total costs % complete Contract price % complete Revenue recognized to date Revenue recognized prior Revenue recognized current Estimated total gross profit % complete Gross profit recognized to date Gross profit recognized prior Gross profit recognized current

Scenario You are a visual designer working at a national magazine publisher. Recently, your department received reports pertaining to mobile technology and social media use. You are to select one topic to focus on and create a tabloid-size, static infographic that will be included in the “Technology and Culture” section of Tech Crowd magazine. You can select from the following topics: Social Media Use CHOSEN TOPIC: Which Social Media Channels are Most Commonly Used Mobile Technology The reports included data sets for each topic that highlight relevant data. You also have access to a Brand Style Guide for the magazine. The Brand Style Guide will ensure that your infographic design will be branded appropriately by providing approved typography, colors, logos, and other design specifications. Both the data set and the Brand Style Guide will support your work on the project deliverables and are linked in Supporting Materials. Directions For your chosen topic, you are required to create two deliverables: a project proposal and a static infographic. You should revise and resubmit the project proposal you created for the milestone assignment in Module Five based on any instructor feedback you may have received. Part 1: Project Proposal(COMPLETED – see attached) Use the Project Proposal Template linked in the What to Submit section. Specifically, you must address the following rubric criteria: Describe the intent of the infographic for your chosen topic. Include the following: Which aspects of the given data will you focus on? Why? Who is the intended audience for your infographic? Explain. Explain the relationships between the variables based on the given data set. Explain the intended story from the data set. Include the following: What does the data set tell you about your chosen topic? Explain. What are the big ideas represented by the data set? Explain. Choose three visualizations that you will use to best represent the story. Include the following details for each visualization: Visualization type Scale and size of data Colors Font types Explain how the chosen visualizations convey the relationships between the variables. Explain how each visualization represents the story. Identify at least one existing visual element from the Brand Style Guide that will help you tell your story. This could be an icon, illustration, or image. Explain how the visual element enhances the story. Part 2: Static Infographic(NEEDS TO BE COMPLETED) Create an infographic using Adobe Illustrator. It should have a page size of 11” x 17”, portrait or landscape. Your infographic should include a headline, an introduction, and at least three data visualizations that show your findings and represent your story. The data visualizations should be accompanied by written explanations of your findings. Refer to the Brand Style Guide, linked in the Supporting Materials section, to inform your design. The approved company logos are available in the Tech Crowd Logos folder linked in the Supporting Materials section. Note: As a best practice, designers should embed all fonts used when working in Adobe Illustrator. Since not all computers and printers have the same fonts, this ensures that the design looks exactly as intended. Specifically, you must address the following rubric criteria: Write an introduction that explains the story expressed in the data. Create three data visualizations that represent the story. Export the data from your Excel data set into Adobe Illustrator to complete this step. Apply elements and principles of design to the visualizations. Include the following: Color: Use two of the four colors provided in the Brand Style Guide. Choose at least one primary color. Shades: Use varying shades, levels of transparency, or levels of opacity of your selected colors for the visualizations. Balance Proportion Emphasis Space Apply typography to the infographic. Use two of the three fonts provided in the Brand Style Guide. Apply these to your headline, introduction, and explanations for each visualization. Apply appropriate visual hierarchy to the infographic. Include the following: Positioning Size Alignment Apply at least one supporting visual element to the infographic. This could be an icon, illustration, or image. Explain the story represented in the infographic by providing an explanation of your findings for each visualization. Note: You will need to provide attribution for any icons, illustrations, or images you use in this assignment. Refer to the Openly Licensed Images area of your course for more information on how to provide attribution. What to Submit To complete this project, you must submit the following: Project Proposal Template Submit the completed Project Proposal Template for grading. Sources should be cited according to MLA style. Static Infographic This is an Adobe Illustrator file (.AI). Your completed infographic should be exported as a PDF file for submission. Sources should be cited according to MLA style. Supporting Materials The following resources will support your work on the project: Document: Brand Style Guide Use this document to complete the project. Folder: Tech Crowd Logos You can choose a logo from this ZIP folder to include in your infographic.