Description UNFORMATTED ATTACHMENT PREVIEW 6/18/23, 3:44 AM Excel 2021 In Practice - Ch 3 Guided Pr ...
Description UNFORMATTED ATTACHMENT PREVIEW 6/18/23, 3:44 AM Excel 2021 In Practice - Ch 3 Guided Project 3-3 - SIMnet Print Info Student Name: Alnaqib, Muhammed Student ID: muhammed.alnaqib@und.edu Username: muhammed.alnaqib@und.edu Excel 2021 In Practice - Ch 3 Guided Project 3-3 COURSE NAME ISBA 217 Fundamentals of CIS Summer 2023 Start Date:05/30/2312:00 AMUS/Central Due Date:06/18/2311:59 PMUS/Central End Date:08/11/2311:59 PMUS/Central SIMNET® PROJECT BEST PRACTICES Always use the project instructions provided online and follow them in order. Always begin a project with the Start file; do not start using a file that you created yourself. Always use a single space after punctuation at the end of sentences; do not use two spaces. Do not open your start file with Office Online unless it is specifically required in the instructions. Do not copy and paste any part of the project unless specified in the instructions. Do not switch between Windows and Mac computers while completing your project. Determine Your Version of Microsoft Office Different versions of Microsoft Office have different features, menu options, themes and styles. Use the correct version of the MS Office software to complete your project. Microsoft Office 365/2019 projects must be completed using Microsoft Office 365 or Microsoft Office 2019. To complete a project: STEP 1: DOWNLOAD THE PROJECT FILES AND FOLLOW THE INSTRUCTIONS Download the files needed to complete your project assignment. Method One Download the REQUIRED project files using the links in the 1. Download section. Click the Start File link to download the additional files you will need to complete your project. If the Resources link does not appear, your project does not require additional resources. Method Two To download the REQUIRED project files using the Download Wizard, click the File Download Wizard link in the 1. Download section. When the Download Wizard opens, the project start file will download automatically to the downloads folder on your computer. Click the Download Resource Bundle button for resources. When done, click the CLOSE button to close the Download Wizard. Your start file will be automatically renamed to include your name. Do all your work in this file and only this file! Open your downloaded start file. After opening your start file, view the project instructions on screen by selecting the View: Instructions button. Figure 1: View instructions button Project instructions may differ between Office for Windows and Office for Mac. In this case you will see Windows/Mac switch in the instructions. By default, the selection matches your type of computer. Many projects don't have instruction differences between Office for Windows and Office for Mac. In this case your will see the message "These instructions are compatible with both Microsoft Windows and Mac operating systems." Figure 2: Windows/Mac Switch Follow each instruction using the instructions online. Use any Resources as instructed to complete the project. After you complete each step, click the check box next to it to track your progress. The next unfinished step in the project wil lbe highlighted yellow. If you would like to clear all of the check marks to start again, click the Reset Progress button. Figure 3: Reset Progress button The instructions may be printed by clicking on the printer icon. You may print to PDF by selecting the print to PDF option in the print dialog. The method and availability of the print to PDF option differs based on the operating system version. https://und.simnetonline.com/sp/assignments/projects/details/8059395 1/3 6/18/23, 3:44 AM Excel 2021 In Practice - Ch 3 Guided Project 3-3 - SIMnet Figure 4: Print button Review your previous submissions by clicking the View: Previous attempts button. Depending on what your instructor has made available to you, you can view your previous attempts to see where you lost any points to improve your score on the next submission. STEP 2: UPLOAD & SAVE THE PROJECT Figure 5: View previous attempts button Once you have finished your project file, you need to upload & save it to SIMnet. Method One Click the Upload my file button under 2. Upload section. Select your file in the File Explorer and click Open to upload it. Method Two Click and drag your file to the 2. Upload section. Release the file in the yellow area. In the Submit Uploaded file? dialog, click No, I'm not ready, to save your file to SIMnet. If you have uploaded a file previously, this new file will replace it. Once you've uploaded your file, you can download it again from the SAVED FILE link in the 3. Submit section, by clicking the file name link. STEP 3: SUBMIT YOUR PROJECT FOR GRADING Once you have uploaded your project file, the Submit Uploaded File wizard will also let you grade your file immediately by clicking Yes, submit the file. If you select No, I'm not ready. in step 3, click the Grade my file button to submit your project for grading. Once the project is graded a Project Results page will open. You can filter the results by Correct, Partial or Incorrect answers. Downloading Files To Download files from the project assignment page, click the links in the REQUIRED section under 1. Download. Then follow the instructions for the browser that you are using. If you're using Chrome browser 1. The file will be downloaded to your downloads folder automatically. 2. To open your file, you can click the file name that appears at the bottom of the browser window or click Show all button and select the file you want to open. If you're using Firefox browser 1. Select Save File in the What should Firefox do with this file? section of the download window and click OK. The file will be saved to the Downloads folder on your computer. 2. In the Downloads window, double-click the file name to open it. Or click the Display the progress of ongoing downloads icon at the top-right of the browser window and click the file name to open it. NOTE: If you select Open with, in the What should Firefox do with this file? section of the download window, the file will open in Read-only mode. Click the Save As… button in the warning bar and save the file to your computer. If you're using Safari browser 1. The file will be downloaded to your downloads folder automatically. 2. Click the Show Downloads icon at the top right of the browser window and double-click the file name to open it. If you're using Edge browser 1. Click the Save button in the What do you want to do with bar. The file will be saved to the Downloads folder on your computer. 2. Click View downloads button to open the downloads window. 3. In the View downloads window, click the file name to open it. NOTE: If you select Open in the What do you want to do with bar, the file will open in Read-only mode. Click the Save As… button in the warning bar and save the file to your computer. Extracting Resources.zip Folders 1. From the project page, click the Resources link. 2. Save the zipped folder file by following the instructions for your browser as listed above. 3. For Mac users, double click the zipped folder to extract it, then double click the extracted folder to open it. 4. For PC users, right-click the zipped folder file you just saved and choose Extract All… from the menu. 5. In the Extract Compressed (Zipped) Folders window, click the Browse button and navigate to a new folder, if you want to save your extracted folder in a different place than suggested. 6. Click the Extract button to extract the folder. 7. Double click the extracted folder to open it. Canadian Users SIMnet Projects allow users to enter dates in Canadian style. To function correctly, users must have both their browser and Microsoft Office set to use the English (Canada) language option. Canadian users may use either English (United States) or English (Canada) for their browser and Office language. However, both browser and Office must be the same to work properly. https://und.simnetonline.com/sp/assignments/projects/details/8059395 2/3 6/18/23, 3:44 AM Excel 2021 In Practice - Ch 3 Guided Project 3-3 - SIMnet Setting your Browser Language Option View the Settings menu on your browser of choice. View the Language Settings. These are typically under the Advanced options. If you do not see your language option of choice selected, click Add Language and select English (Canada). Ensure that the language preference is listed first by using the three dot menu to change the order so that English (Canada) is first. Setting your Office Language Option Microsoft Office uses the Language option set in your OS. In Windows, go to the Settings menu and select Time & Language. Select Language and ensure that the desired language is displayed, English (Canada). In Mac OS, go to the System Preferences menu, click Language & Region. Select the desired region, Canada. For additional information click the in the upper right corner of the SIMnet window to open the HELP-Projects menu. https://und.simnetonline.com/sp/assignments/projects/details/8059395 3/3 6/18/23, 3:43 AM Excel 2021 In Practice - Ch 3 Guided Project 3-3 - SIMnet Print Info Student Name: Alnaqib, Muhammed Student ID: muhammed.alnaqib@und.edu Username: muhammed.alnaqib@und.edu Excel 2021 In Practice - Ch 3 Guided Project 3-3 COURSE NAME ISBA 217 Fundamentals of CIS Summer 2023 Start Date:05/30/2312:00 AMUS/Central Due Date:06/18/2311:59 PMUS/Central End Date:08/11/2311:59 PMUS/Central Guided Project 3-3 Blue Lake Sporting Goods has locations in major cities. For this project, you create a pie chart and a bar chart to display each store’s contribution to golf-related sales and how total sales evolved for the period. You create a line chart to illustrate the break-even sales needed for a new item. [Student Learning Outcomes 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8] File Needed: BlueLake-03.xlsx (Available from the Start File link.) Completed Project File Name: [your name]-BlueLake-03.xlsx Skills Covered in This Project Create, size, and position a pie chart object. Apply a chart style. Explode a pie slice. Delete the legend from a chart. Reposition data labels in a chart. Create a clustered bar chart object. Format data labels and data series. Add Alt Text to a chart. Insert and format sparklines in a worksheet. Steps to complete This Project 1. Open the BlueLake-03 start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. Create a pie chart object. a. Select the Revenue by Department sheet, select cells A4:F4, press Ctrl, and select cells A13:F13. b. Click the Insert Pie or Doughnut Chart button [Insert tab, Charts group] and choose 3-D Pie. 3. Apply a chart style. a. Select the chart object if necessary. b. Click the More button [Chart Design tab, Chart Styles group]. c. Select Style 3. 4. Size and position a chart object. a. Point to the chart object border to display the move pointer. b. Drag the chart object so its top-left corner is at cell H4. https://und.simnetonline.com/sp/assignments/projects/details/8059395 1/4 6/18/23, 3:43 AM Excel 2021 In Practice - Ch 3 Guided Project 3-3 - SIMnet c. Point to the bottom right selection handle to display the resize arrow. d. Drag the pointer to reach cell Q19. 5. Explode a pie slice. a. Double-click the pie to open its Format Data Series task pane. b. Click the San Diego slice to update the pane to the Format Data Point task pane. (Rest the pointer on a slice to see its identifying ScreenTip or refer to the legend.) c. Click the Series Options button in the Format Data Point task pane. d. Set the pie explosion percentage at 10%. e. Close the task pane and click the chart object border to deselect the San Diego slice. 6. Display and format data labels. a. Click the Chart Elements quick button, click the Data Labels arrow to open its submenu, and choose More Options. b. Verify that the Label Options group is selected in the Format Data Labels pane. c. Click Label Options to expand the group if it is collapsed. d. Select the Category Name box. e. Confirm that the Percentage and the Show Leader Lines boxes are selected (Figure 3-80). f. Click the Separator drop-down list and choose (space). g. Click the Fill & Line button, expand the Fill group, and select No Fill. This removes the black background box for each label. h. Close the task pane. 7. Delete the legend and recolor and position data labels. a. Select the legend. b. Confirm your selection in the Chart Elements drop-down list [Format tab, Current Selection group]. c. Press Delete to remove the legend. d. Click the Chart Elements dropdown list [Format tab, Current Figure 3-80 Format Data Labels task pane Selection group] and select Series “Golf” Data Labels. All of the city names and percentages are selected. e. Click the Text Fill button [Format tab, WordArt Styles group] and choose Black, Text 1 (second column). f. Click as many times as needed to select only the San Diego data label. g. Point to display a move pointer and drag the label as shown in Figure 3-81. Figure 3-81 Data labels positioned by dragging each one h. Select each data label and position it as shown in the figure. If you accidentally move another element, press Ctrl+Z to undo the error. i. Click a worksheet cell. https://und.simnetonline.com/sp/assignments/projects/details/8059395 2/4 6/18/23, 3:43 AM Excel 2021 In Practice - Ch 3 Guided Project 3-3 - SIMnet 8. Create a clustered bar chart object to simulate a funnel chart. a. Select cells A22:B26. b. Click the Quick Analysis button and choose Charts. c. Click Clustered bar in the list (Figure 3-82). 9. Size and position a clustered bar chart object. a. Point to the chart object border to display the move pointer. b. Drag the bar chart object so its top-left corner is at cell C21. c. Point to the bottom right selection handle to display the resize arrow. d. Drag the pointer to reach cell L40 (Figure 3-82). 10. Apply a chart style. a. Figure 3-82 Clustered bar chart suggested based on the data Confirm that the bar chart object is selected. b. Click the More button [Chart Design tab, Chart Styles group]. c. Select Style 3. 11. Format data labels and edit the chart title. a. Select one of the data labels in any bar (the dollar amount) and change the font size to 16. b. Select the Chart Title box. c. Triple-click to select all the placeholder text. You can also click and drag, or click once and press Ctrl+A. d. Type Total Sales by City. 12. Remove the horizontal axis, reverse the category order, and apply a special effect. a. Click the Chart Elements drop-down list [Format tab, Current Selection group] and select Horizontal (Value) Axis to select the values along the bottom of the plot area. b. Press Delete to remove the values. c. Click the Chart Elements drop-down list [Format tab, Current Selection group] and select Series 1. d. Click the Shape Effects button [Format tab, Shape Styles group]. e. Point to Shadow and choose Offset: Bottom Right in the Outer group. f. Click the Chart Elements drop-down list [Format tab, Current Selection group] and select Vertical (Category) Axis to select the city names. g. Click the Format Selection button [Format tab, Current Selection group] to open the Format Axis pane. h. Click the Axis Options button in the Axis Options group. i. Select the Categories in reverse order box and close the task pane. 13. Add Alt Text to a chart for increased accessibility. a. Right-click the border of the bar chart and select Edit Alt Text. b. Click the entry box to place the insertion point. c. Type This is a bar chart which displays totals in descending order. You can select an individual data point to apply a fill color. including the period. d. Close the Alt Text pane. e. Select cell A1. 14. Insert sparklines in a worksheet. a. Click the First Period worksheet tab. b. Select cells B19:E19 as the data range. c. Click the Line Sparkline button [Insert tab, Sparklines group]. d. Select cell $I$19 in the Location Range box and click OK. This places a single sparkline for the totals. 15. Format sparklines in worksheet. a. Click the Format button [Home tab, Cells group] and change the Row Height to 35. b. Click the Format button [Home tab, Cells group] and set the Column Width to 40. c. Select the Markers box in the Show group in the Sparkline tab. d. Click the More button [Sparkline tab, Style group]. e. Choose Brown, Sparkline Style Accent 6, Darker 50% (first row, last column). https://und.simnetonline.com/sp/assignments/projects/details/8059395 3/4 6/18/23, 3:43 AM Excel 2021 In Practice - Ch 3 Guided Project 3-3 - SIMnet 16. f. Apply Outside Borders to cell I19. g. Click the row 4 heading and set the row height to 35. h. Click cell A1. i. Set the page orientation to landscape. Save and close the workbook (Figure 3-83). Figure 3-83 Excel 3-3 completed 17. Upload and save your project file. 18. Submit file for grading. https://und.simnetonline.com/sp/assignments/projects/details/8059395 4/4 Blue Lake Sporting Goods First Period Sales by Department Department Apparel Baseball Basketball Bike & Skate Fishing Fitness Footwear Game Room Golf Hockey Hunting Lacrosse Running Winter Sports January February March April Total $ 2,600 $ 3,200 $ 3,800 $ 3,700 $ 13,300 $ 3,500 1,200 1,950 2,100 8,750 1,800 1,800 2,250 1,400 7,250 1,500 1,325 1,225 2,450 6,500 2,350 1,035 1,250 2,750 7,385 2,650 2,875 3,250 3,775 12,550 1,875 2,675 3,575 3,250 11,375 1,300 1,500 1,900 1,050 5,750 4,750 875 925 5,400 11,950 850 1,875 1,950 750 5,425 2,000 1,000 650 725 4,375 1,750 1,800 1,750 1,375 6,675 1,925 2,400 2,800 2,650 9,775 1,250 34,350 2,750 550 38,900 Best Worst 3,800 $ 2,600 3,500 1,200 2,250 1,400 2,450 1,225 2,750 1,035 3,775 2,650 3,575 1,875 1,900 1,050 5,400 875 1,950 750 2,000 650 1,800 1,375 2,800 1,925 34,350 550 Total $ 30,100 $ 57,910 $ 30,025 $ 31,925 $ 149,960 First Period 3acb7961e86499a4037128c6bc88998c Blue Lake Sporting Goods First Quarter Sales by City and Department Department Apparel Baseball Basketball Bike & Skate Exercise Fishing Footwear Game Room Golf Hockey Hunting Lacrosse Running Winter Sports City Totals Boston San Diego Atlanta Chicago St. Louis Atlanta $ 2,600 $ 3,500 $ 1,800 $ 1,500 $ 2,650 $ 2,350 $ 1,875 $ 1,300 $ 4,750 $ 850 $ 2,000 $ 1,750 $ 1,925 $ 1,250 Total $ 30,100 $ $ $ $ $ 57,910 31,925 30,100 29,425 26,250 Boston $ 3,200 $ 1,200 $ 1,800 $ 1,325 $ 2,875 $ 1,035 $ 2,675 $ 1,500 $ 875 $ 1,875 $ 1,000 $ 1,800 $ 2,400 $ 34,350 $ 57,910 Chicago $ 3,800 $ 1,350 $ 2,250 $ 1,225 $ 3,250 $ 1,250 $ 3,575 $ 1,900 $ 925 $ 1,950 $ 650 $ 1,750 $ 2,800 $ 2,750 $ 29,425 San Diego $ 3,700 $ 2,100 $ 1,400 $ 2,450 $ 3,775 $ 2,750 $ 3,250 $ 1,050 $ 5,400 $ 750 $ 725 $ 1,375 $ 2,650 $ 550 $ 31,925 St. Louis $ 3,200 $ 2,475 $ 1,750 $ 1,650 $ 2,950 $ 1,450 $ 2,950 $ 1,275 $ 1,250 $ 1,650 $ 950 $ 1,150 $ 2,000 $ 1,550 $ 26,250 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total 16,500 10,625 9,000 8,150 15,500 8,835 14,325 7,025 13,200 7,075 5,325 7,825 11,775 40,450 175,610 Purchase answer to see full attachment Explanation & Answer: 15 Steps User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
