Computer Applications Graded Project Instructions You will need to download these files to use as you create your project: Practice Files Zip Folder Each element of your project must be submitted in the correct file format. The Microsoft Word portion must be uploaded as a .docx or .doc; the Microsoft Excel portion must be uploaded as a .xlsx or .xls; and, the Microsoft PowerPoint portion must be uploaded as a .pptx or .ppt file. Your project will be individually graded by your instructor and therefore may take up to seven days to grade. Be sure that each of your files contains the following information: Windows: Select the files you want to compress, right-click and select Send to and then Compressed (zipped) folder. Mac: Select the files you want to compress, control-click and select Compress. To submit your graded project, proceed to the Graded Assignment page in this lesson. Follow the instructions provided to upload the file and submit it for grading. Be sure to keep a backup copy of any files you submit to the school! After your assignment has been graded, feedback will be available on the Lesson Assignment page within the course. It will have an option to download the feedback from the instructor. Instructions Memo Start Word and create a new blank document. Create a memo for the sales meeting with the following text: Clever Acme Corp. TO: All Employees FROM: Your Name, Director of Sales DATE: September 17, 20xx SUBJECT: Fall Sales Meeting The Fall Sales Meeting will take place on September 28 at 2:00 pm in the conference room. We will review summer sales and discuss our upcoming product launches. Following the meeting will be a barbeque at Yama Park. Feel free to invite your family to the event, which is expected to begin at 4:00 pm. Apply the following formats: The company name should be in Arial 20-point, bold, purple font. The memo headings and text should be in Times New Roman, 12-point font, with left-aligned tab stops set to 1 inch. Replace Your Name with your name. The body text should be in Times New Roman, 12-point font, with the dates and times in bold text. The memo should look like the figure below. An image of a memo for a sales meeting. Save the document as Meeting Memo. Spreadsheet and Chart Start Excel and create a new blank workbook. Enter data as shown in the table. Calculate the totals with formulas that use functions. Clever Acme Corp. Summer Sales Gadget June July August Total Doodads $12,675 $8,020 $8,600 $29,295 Gizmos $22,975 $18,975 $23,500 $65,450 Widgets $45,890 $50,375 $49,890 $146,155 Total Apply the following formats: The company name should be in Arial, 20-point, bold, purple font. The Summer Sales title should be in 16-point font. The company name and Summer Sales titles should be merged and centered. Column headings should be bold, and month headings right-aligned. The sales figures should be in Currency cell style with no decimal places. Formulas that use functions should be used for the calculated totals. Cells B8 through E8 should be formatted in the Total cell style. The spreadsheet should look like the figure below. An image of the formatted summer sales worksheet. Save the worksheet as Summer Sales. Create a column chart based on cells A4 through D7: Select the 2-D Column Stacked Column style. After the chart is created, add data labels for the company’s products. Edit the chart title to say “Summer Sales.” The chart should look like the figure below. An image of column chart based on cells A4 through D7 of the summer sales worksheet. Save the modified workbook. Your final spreadsheet should look similar to the figure below. An image of the modified summer sales workbook. Presentation You will need to use the image files that you downloaded from the link at the beginning of the instructions for this project. Start PowerPoint and create a new blank presentation. Change the theme of the presentation to Crop or another appropriate style if you don’t have Crop. Verify that slide 1 uses Title Slide layout and then enter the following text so that your slide looks similar to the figure below. Clever Acme Corp. Fall Sales Meeting An image of the title slide layout. Add a new slide 2 with a blank layout, and then add the sales data from the Summer Sales workbook as a linked Excel Worksheet. Size the table so it takes up the full slide and looks similar to the figure below. An image of a new PowerPoint slide with a table containing the sales data from the summer sales workbook. Add a new slide 3 with a blank layout and then insert the Summer Sales chart from the Excel workbook. Size the chart so it takes up the full slide and looks similar to the figure below. An image of a new PowerPoint slide with a stacked column chart containing the sales data from the summer sales workbook. Add a new slide 4 using Picture with Caption layout and add the following text: Glow in the Dark Widget Launch Date: 11/1/20 Insert the Glow in the Dark Widget.jpg, a data file for this graded project. The slide should look similar to the figure below. An image of a PowerPoint slide using picture with caption layout with the Glow in the Dark Widget image. Add three more Picture with Caption layout slides to introduce the Lime Doodad, Buttercup Gizmo, and Black Widget products. Their corresponding image files are data files for this graded project. The slides should include the following text: Lime Doodad Launch Date: 11/15/20 Buttercup Gizmo Launch Date: 12/2/20 Black Widget Launch Date: 12/10/20 Your slides should look similar to the following figures. An image of a picture with caption layout PowerPoint slide with the Lime Doodad image. An image of a picture with caption layout PowerPoint slide with the Buttercup Gizmo image. An image of a picture with caption layout PowerPoint slide with the Black Widget image. Add a new slide with a Title and Content layout and add the following text: Title: Discussion Regional sales reports Questions Comments The slide should look similar to the figure below. An image of a title and content layout PowerPoint slide with discussion text. Add a new slide with a Title Only layout. Insert text “Enjoy the Barbeque” and a clip art picture that thanks employees for their hard work (use “thank you” as the search text when searching for the image). The slide should look similar to the figure below. An image of a title only layout slide with inserted text and clip art. Apply the Page Curl transition to all the slides. Apply the Grow & Turn animation to each of the bullet items on slide 8. Save the presentation as Fall Meeting, and then play the slide show from the beginning to check your presentation. Create a memo A memo with accurate text and all appropriate formatting, including tab stops, has been created. A memo with most of the correct content and formatting has been created. A memo with most of the correct content and some of the correct formatting has been created. A memo with inaccurate content and little or no formatting has been created. No attempt has been made to create a memo. Create a spreadsheet All cell data is correctly formatted and the calculations use formulas with functions. Cell data is correctly formatted and some calculations use formulas with functions. Some cell data is correctly formatted and some calculations use formulas with functions. Some cell data is present with little or no formatting or use of formulas for calculation. No attempt to create a spreadsheet has been made. Create a chart A column chart based on the correct data, with the specified style and the correct labels, has been created. A column chart based on the correct data, with the specified style but without the correct labels, has been created. A column chart based on the correct data, with an unspecified style and the correct labels, has been created. A chart has been created without the correct data, specified style, or labels. No attempt to create a chart has been made. Create a presentation A presentation in the specified theme, with 9 slides in the correct layouts, has been created. A presentation in the specified theme with most of the slides in the correct layouts, has been created. A presentation in the specified theme, with some of the slides in the correct layouts, has been created. A presentation with fewer than 9 slides, in varying layouts, has been created. No attempt has been made to create a presentation, or fewer than 9 slides without some required content have been created. Insert Excel data as a linked object into slide 2 The specified cell data has been pasted as a linked Excel Worksheet object into slide 2 and appropriately sized. The specified cell data has been pasted as an Excel Worksheet object without linking. The specified cell data has been copied and pasted as a PowerPoint table or embedded. An attempt has been made to paste some cell data into the presentation. No attempt has been made to add Excel spreadsheet data to the presentation. Paste an Excel chart into slide 3 The specified Excel chart has been pasted into slide 3 and appropriately sized and positioned. The specified Excel chart has been pasted into slide 3 but not sized or positioned. The specified Excel chart has been recreated in the presentation by using the Insert Chart command. The chart has been inserted as an Excel Worksheet Object and displays the entire worksheet. No attempt has been made to add a chart to the presentation. Insert data file images Images have been inserted as specified. Most of the specified images have been inserted. Some of the specified images have been inserted. Few of the specified
