Intro to Information Technology 2240 9H SP24

Intro to Information Technology 2240 9H SP24

START DATE

03/27/202412:00 AMUS/Eastern

DUE DATE

04/10/202411:59 PMUS/Eastern

END DATE

04/17/202411:59 PMUS/Eastern

1. Download

Click the Start File link, then complete the project using the instructions below.

Required:

• Start File

2. Upload

Save your in-progress and completed work by dragging your file onto this section or clicking below. NOTE: You must first download the start file.

Upload my file

3. Submit

Click the “Grade my file” button to submit and grade attempt 1 of 4.

NOTE: You must upload a file before you can submit it for grading.

Grade my file

PROJECT SUB-VIEW:

Instructions

Previous Attempts

Best Practices

Project Instructions

Guided Project 3-3

Windows   Mac

Blue Lake Sports has locations in several major cities and tracks sales by department in each store. For this project, you create a pie chart that shows each store’s share of golf-related sales for the first quarter. You also create a line chart to illustrate week-to-week sales for specific departments in one of the stores and insert sparklines in the data.

[Student Learning Outcomes 3.1, 3.2, 3.3, 3.4, 3.6, 3.8]

File Needed: BlueLakeSports-03.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-BlueLakeSports-03.xlsx

Skills Covered in This Project

• Create, size, and position a pie chart object.
• Apply a chart style.
• Change the chart type.
• Add and format chart elements.
• Create a line chart sheet.
• Apply a chart layout.
• Insert and format sparklines in a worksheet.

 This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.

Steps to complete This Project

Mark the steps as checked when you complete them.

1. Open the BlueLakeSports-03start 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.
   13. Select theRevenue by Department sheet, select cells A4:F4, press Ctrl, and select cells A13:F13.
   14. Click the Recommended Charts button [Inserttab, Charts group].
   15. Choose Pie and click OK.
3. Apply a chart style.
   1. Select the chart object.
   2. Click the Morebutton [Chart Design tab, Chart Styles group].
       Click the More button [Chart Tools Design tab, Chart Styles group].
   3. Select Style 12.
4. Size and position a chart object.
   1. Point to the chart object border to display the move pointer.
   2. Drag the chart object so its top-left corner is at cell A21.
   3. Point to the bottom right selection handle to display the resize arrow.
   4. Drag the pointer to cell G36.
5. Change the chart type.
   1. Select the pie chart object and click the Change Chart Typebutton [Chart Design tab, Type group].
       Select the pie chart object and click the Change Chart Type button [Chart Tools Design tab, Type group].
   2. Select the All Chartstab and choose Pie in the left pane.
   3. Choose 3-D Pieand click OK.
6. Format pie chart elements.
   1. Double-click the pie to open its Format Data Seriestask pane.
   2. Click the Atlantaslice to update the pane to the Format Data Point task pane. (Rest the pointer on a slice to see its identifying  )
   3. Click the Series Optionsbutton in the Format Data Series task pane.
   4. Set the pie explosion percentage at 10%.
   5. Close the task pane.
   6. Click the chart object border to deselect the Atlanta 
7. Add and format chart elements in a pie chart.
   1. Click the Chart Elementsbutton in the top-right corner of the chart.
   2. Select the Data Labels 
   3. Click the Data Labelsarrow to open its submenu and choose More Options.
   4. If necessary, click the Label Optionsbutton In the Format Data Labels 
   5. If necessary, click Label Optionsto expand the group.
   6. Select the Percentage 
   7. Deselect the Value box (Figure 3-66).

Figure 3-66 Format Data task pane for data labels

1. Press Ctrl+Bto apply bold.
2. Change the font size to 12 pt[Home tab, Font group].
3. Click the chart object border to select it.
4. Click theShape Outline button [Chart Format tab, Shape Styles group] and choose Purple, Accent 4, Darker 50% (eighth column).
    Click the Shape Outline button [Chart Tools Format tab, Shape Styles group] and choose Purple, Accent 4, Darker 50% (eighth column).
5. Click the Shape Outlinebutton and choose Weight and 1 pt.
6. Click a worksheet cell.

8. Create a line chart sheet.
   1. Select theAtlanta Revenue sheet tab.
   2. Select cells A4:E7.
   3. Click the Quick Analysis button and choose Charts.
   4. Select Line.
   5. Click the Move Chartbutton [Chart Design tab, Location group].
       Click the Move Chart button [Chart Tools Design tab, Location group].
   6. Click the New sheet 
   7. Type Promo Deptsand click OK.
9. Apply a chart layout.
   1. Click the Quick Layout button [Chart Design tab, Chart Layoutsgroup].
       Click the Quick Layout button [Chart Tools Design tab, Chart Layouts group].
   2. Select Layout 5to add a data table to the chart sheet (Figure 3-67).

Figure 3-67 Data table added by Quick Layout

10. Change the chart type.
    1. Click the Change Chart Typebutton [Chart Design tab, Type group].
        Click the Change Chart Type button [Chart Tools Design tab, Type group].
    2. Select the All Chartstab and choose Line with Markers in the Line 
    3. Click OK.
11. Edit chart elements in a line chart.
    1. Click the chart title placeholder.
    2. Type Special Promotion Departmentsin the Formula bar and press Enter.
    3. Click the vertical axis title placeholder.
    4. Type Dollar Salesin the Formula bar and press Enter.
    5. Click the Chart Elementsdrop-down arrow [Chart Format tab, Current Selection group].
        Click the Chart Elements drop-down arrow [Chart Tools Format tab, Current Selection group].
    6. Choose Series “Apparel”to select the line in the chart.
    7. Click the Format Selectionbutton [Chart Format tab, Current Selection group].
        Click the Format Selection button [Chart Tools Format tab, Current Selection group].
    8. Click the Fill & Linebutton in the Format Data Series task pane.
    9. Click Markerand then click Marker Options to expand the group (Figure 3-68).

Figure 3-68 Marker options for the data series

10. Choose Built-inand set the Size to 10.
11. Click the Series Optionstriangle at the top of the task pane and choose Series “Baseball” (Figure 3-69).

Figure 3-69 New data series selected

1. Apply the same marker changes for the baseball series.
2. Select the Basketballseries and apply the same marker changes.
3. Close the task pane and click outside the chart.

12. Insert sparklines in the worksheet.
    1. Click the Atlanta Revenue 
    2. Right-click the columnF heading and choose Insert.
    3. Select cells B5:E18as the data range.
    4. Click the Line Sparklinebutton [Insert tab, Sparklines group].
    5. Select cells F5:F18in the Location Range 
    6. Click OK.
13. Format sparklines in worksheet.
    24. Click the Formatbutton [Home tab, Cells group] and change the Row Height to 24.
    25. Click the Formatbutton [Home tab, Cells group] and set the Column Width to 35.
    26. Select the Markersbox in the Show group in the Sparkline 
         Select the Markers box in the Show group on the Sparkline Tools Design tab.
    27. Click the Sparkline Colorbutton [Sparkline tab, Style group].
         Click the Sparkline Color button [Sparkline Tools Design  tab, Style group].
    28. Choose Black, Text1 (second column) for the line color.
    29. Click cell A1.
14. Change the page orientation to landscape.
15. Save and close the workbook (Figure 3-70).

Figure 3-70 Excel 3-3 completed worksheet and charts

16. Upload and save your project file.
17. Submit project for grading.

Reset Progress Back to top

SUPPORT

• System Requirements
• Technical Support
• SIMnet Instant Help
• Platform Status

FOLLOW MCGRAW HILL

SIMnet Blog

© 2024 McGraw Hill. All rights reserved.

Terms | Priva

ADDITIONAL INSTRUCTIONS FOR THE CLASS

SCORE A+ WITH HELP FROM OUR PROFESSIONAL WRITERS – Intro to Information Technology 2240 9H SP24

We will process your orders through multiple stages and checks to ensure that what we are delivering to you, in the end, is something that is precise as you envisioned it. All of our essay writing service products are 100% original, ensuring that there is no plagiarism in them. The sources are well-researched and cited so it is interesting. Our goal is to help as many students as possible with their assignments, i.e. our prices are affordable and services premium.

• Discussion Questions (DQ)

Initial responses to the DQ should address all components of the questions asked, including a minimum of one scholarly source, and be at least 250 words. Successful responses are substantive (i.e., add something new to the discussion, engage others in the discussion, well-developed idea) and include at least one scholarly source. One or two-sentence responses, simple statements of agreement or “good post,” and responses that are off-topic will not count as substantive. Substantive responses should be at least 150 words. I encourage you to incorporate the readings from the week (as applicable) into your responses.

• Weekly Participation

Your initial responses to the mandatory DQ do not count toward participation and are graded separately. In addition to the DQ responses, you must post at least one reply to peers (or me) on three separate days, for a total of three replies. Participation posts do not require a scholarly source/citation (unless you cite someone else’s work). Part of your weekly participation includes viewing the weekly announcement and attesting to watching it in the comments. These announcements are made to ensure you understand everything that is due during the week. Intro to Information Technology 2240 9H SP24

• APA Format and Writing Quality

Familiarize yourself with the APA format and practice using it correctly. It is used for most writing assignments for your degree. Visit the Writing Center in the Student Success Center, under the Resources tab in Loud-cloud for APA paper templates, citation examples, tips, etc. Points will be deducted for poor use of APA format or absence of APA format (if required). Cite all sources of information! When in doubt, cite the source. Paraphrasing also requires a citation. I highly recommend using the APA Publication Manual, 6th edition.

• Use of Direct Quotes

I discourage over-utilization of direct quotes in DQs and assignments at the Master’s level and deduct points accordingly. As Masters’ level students, it is important that you be able to critically analyze and interpret information from journal articles and other resources. Simply restating someone else’s words does not demonstrate an understanding of the content or critical analysis of the content. It is best to paraphrase content and cite your source.

• LopesWrite Policy

For assignments that need to be submitted to Lopes Write, please be sure you have received your report and Similarity Index (SI) percentage BEFORE you do a “final submit” to me. Once you have received your report, please review it. This report will show you grammatical, punctuation, and spelling errors that can easily be fixed. Take the extra few minutes to review instead of getting counted off for these mistakes. Review your similarities. Did you forget to cite something? Did you not paraphrase well enough? Is your paper made up of someone else’s thoughts more than your own? Visit the Writing Center in the Student Success Center, under the Resources tab in Loud-cloud for tips on improving your paper and SI score.

• Late Policy

The university’s policy on late assignments is a 10% penalty PER DAY LATE. This also applies to late DQ replies. Please communicate with me if you anticipate having to submit an assignment late. I am happy to be flexible, with advance notice. We may be able to work out an extension based on extenuating circumstances. If you do not communicate with me before submitting an assignment late, the GCU late policy will be in effect. I do not accept assignments that are two or more weeks late unless we have worked out an extension. As per policy, no assignments are accepted after the last day of class. Any assignment submitted after midnight on the last day of class will not be accepted for grading. Intro to Information Technology 2240 9H SP24

• Communication

Communication is so very important. There are multiple ways to communicate with me: Questions to Instructor Forum: This is a great place to ask course content or assignment questions. If you have a question, there is a good chance one of your peers does as well. This is a public forum for the class. Individual Forum: This is a private forum to ask me questions or send me messages. This will be checked at least once every 24 hours. Intro to Information Technology 2240 9H SP24

• Guarantee

• Zero Plagiarism
• On-time delivery
• A-Grade Papers
• Free Revision
• 24/7 Support
• 100% Confidentiality
• Professional Writers

• Services Offered

• Custom paper writing
• Question and answers
• Essay paper writing
• Editing and proofreading
• Plagiarism removal services
• Multiple answer questions

We will process your orders through multiple stages and checks to ensure that what we are delivering to you, in the end, is something that is precise as you envisioned it. All of our essay writing service products are 100% original, ensuring that there is no plagiarism in them. The sources are well-researched and cited so it is interesting. Our goal is to help as many students as possible with their assignments, i.e. our prices are affordable and services premium. Intro to Information Technology 2240 9H SP24

Looking for a Similar Assignment? Order a custom-written, plagiarism-free paper