Description
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
Really helpful material, saved me a great deal of time.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
SNHU Pirate Intelligent Agent Project
You will need to be able to access and use my virtual lab. In this assignment, you will apply the concepts you learned abo ...
SNHU Pirate Intelligent Agent Project
You will need to be able to access and use my virtual lab. In this assignment, you will apply the concepts you learned about in the previous few modules – neural networks, reinforcement learning, and Q-algorithms – to design the code for a pathfinding intelligent agent. Specifically, you will be designing code for a pirate non-player character (NPC) that is part of a larger treasure hunt video game. The pirate will need to navigate the game world, which consists of different pathways and obstacles, in order to find the treasure. The pirate agent’s goal is to find the treasure before the human player.
You have been provided with some starter code and a sample environment where your pirate agent will be placed. You will need to create a deep Q-learning algorithm to train your pirate agent. In this milestone, you will be turning in the code for your pirate intelligent agent so that you can receive feedback from your instructor before turning in your final code (along with your design defense) when submitting Project Two.
Prompt
Before creating your pirate intelligent agent, be sure to review the Pirate Intelligent Agent Specifications document. This document provides details about the code that you have been given and what aspects you will need to create.
Download the zipped folder containing your starter code and Project Two Jupyter Notebook. Upload the zipped folder into the Virtual Lab (Apporto), unzip the folder, and upload the files into Jupyter Notebook. Use the Virtual Lab Student Guide and Jupyter Notebook in Apporto (Virtual Lab) Tutorial to help you with these tasks.
Be sure to review the starter code that you have been given. Watch the Project Two Walkthrough video to help you understand this code in more detail. A video transcript is available: Transcript for Project Two Walkthrough video.
IMPORTANT: Do not modify any of the PY files that you have been given.
Complete the code for the Q-Training Algorithm section in your Jupyter Notebook. In order to successfully complete the code, you must do the following:
Develop code that meets the given specifications:
Complete the program for the intelligent agent so that it achieves its goal: The pirate should get the treasure.
Apply a deep Q-learning algorithm to solve a pathfinding problem.
Create functional code that runs without error.
Use industry-standard best practices such as in-line comments to enhance readability and maintainability.
After you have finished creating the code for your notebook, save your work. Make sure that your notebook contains your name in the filename (such as, “Doe_Jane_ProjectTwoMilestone.ipynb”). This will help your instructor access and grade your work easily. Be sure to download a copy of your notebook (IPYNB file) for your submission.
IMPORTANT: Submit the code that you have completed, even if you were not able to completely finish all of the elements. If you have questions, be sure to email your instructor. Be as specific as possible about the issue you are encountering.
Campbellsville University Wk 6 Mobile Computing Discussion
Mobile Computing
Discussion Week 6 - Mobile Computing
We learn from our readings that the use of mobile devices in our soc ...
Campbellsville University Wk 6 Mobile Computing Discussion
Mobile Computing
Discussion Week 6 - Mobile Computing
We learn from our readings that the use of mobile devices in our society today has indeed become ubiquitous. In addition, CTIA asserted that over 326 million mobile devices were in use within The United States as of December 2012 – an estimated growth of more than 100 percent penetration rate with users carrying more than one device with notable continues growth. From this research, it’s evident that mobile computing has vastly accelerated in popularity over the last decade due to several factors noted by the authors in our chapter reading. In consideration with this revelation, identify and name these factors, and provide a brief discussion about them.
Golden Gate University Week 5 Benefits of ISO 27001 Response & Discussion
From your research, discuss whether or not your organization has ISO 27001 certification. Outside of overall protection fr ...
Golden Gate University Week 5 Benefits of ISO 27001 Response & Discussion
From your research, discuss whether or not your organization has ISO 27001 certification. Outside of overall protection from cyber-attacks, describe, in detail, some other benefits your organization will achieve in obtaining this certification. If your company does not have this certification, how can they go about obtaining it?Present your discussion post as if you were presenting to senior leaders of your company.Please make your initial post 600 WORDS and two response posts 150 words each substantive. A substantive post will do at least TWO of the following:Ask an interesting, thoughtful question pertaining to the topicAnswer a question (in detail) posted by another student or the instructorProvide extensive additional information on the topicExplain, define, or analyze the topic in detailShare an applicable personal experienceProvide an outside source (for example, an article from the UC Library) that applies to the topic, along with additional information about the topic or the source (please cite properly in APA)Make an argument concerning the topic.At least one scholarly source should be used in the initial discussion thread. Be sure to use information from your readings and other sources from the UC Library. Use proper citations and references in your post.Reading AssignmentsLopes, M., Guarda, T. & Oliveira, P. (2019). How ISO 27001 Can Help Achieve GDPR Compliance. 2019 14th Iberian Conference on Information Systems and Technologies (CISTI), pp. 1-6. https://ieeexplore.ieee.org/document/8760937?arnumber=8760937
Strayer University Computer Science Paper
Week 1 Activity - Introduction to Project Management Tools Overview The purpose of this activity is to
expose you to the ...
Strayer University Computer Science Paper
Week 1 Activity - Introduction to Project Management Tools Overview The purpose of this activity is to
expose you to the Microsoft Project tool for the purpose of developing a
project plan and Gantt chart for a hypothetical 30-day hobby project of
your choice. Examples include building a deck, painting the garage, or
planting a vegetable garden. Completing this activity will help to
jump-start your successful completion of the project deliverables
throughout the course.This activity consists of two parts:Part 1: Project Introduction or Project Plan
You will outline the project specifics, such as its key objectives,
scope, functional requirements, technical requirements, and key
components.Part 2: Gantt Chart
You will use Microsoft Project to create a Gantt chart for your hobby
project. Download Microsoft Project to your computer if you don't
already have it installed and familiarize yourself with its features.
Note: Microsoft Project is available at no cost
to Strayer University students. For more information, refer to the
left-hand menu option titled “Microsoft Azure for Education.” This
information is also available via iCampus.
You are to create or assume all necessary assumptions to successfully complete this activity.
You must submit both parts as separate files to the assignment area. Label each file name according to the appropriate part.
Instructions Part 1: Project Introduction or Project PlanWrite a 3–5 page document in which you:
Document the hobby project's key objectives and scope.
Develop the hobby project's functional and technical requirements.
Design the hobby project's components, including size, shape, and quality.
Implement the project according to the chosen design and components.
Part 2: Gantt ChartUse Microsoft Project to create a Gantt chart in which you:
Identify the major and minor tasks, illustrating dependency relationships between activities.
Formatting This course requires the use of Strayer
Writing Standards. For assistance and information, please refer to the
Strayer Writing Standards link in the left-hand menu of your course.
Check with your professor for any additional instructions. Note the
following:
The preferred method is for the project plan portion of your
activity to be typed, double-spaced, using Times New Roman font (size
12), with one-inch margins on all sides.
Include a cover page containing the assignment title, your name,
your professor's name, the course title, and the date. The cover page is
not included in the required page length.
You are not required to include a source list page for
this introductory activity. You will, however, be responsible for
citing sources and including a source list page for all of the assigned
course project deliverables.
San Diego State University January Sales in Atlanta For Blue Lake Sports Excel Task
Blue Lake Sports has locations in several major cities and tracks sales by department in each store. For this project, you ...
San Diego State University January Sales in Atlanta For Blue Lake Sports Excel Task
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.
Open the BlueLakeSports-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.
NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.
Create a pie chart object.
Select the Revenue by Department sheet, select cells A4:F4, press command, and select cells A13:F13.
Click the Recommended Charts button [Insert tab, Charts group].
Choose Pie.
Apply a chart style.
Select the chart object.
Click the More button [Chart Design tab, Chart Styles group].
Select Style 12.
Size and position a chart object.
Point to the chart object border to display the move pointer.
Drag the chart object so its top-left corner is at cell A21.
Point to the bottom right selection handle to display the resize arrow.
Drag the pointer to cell G36.
Change the chart type.
Select the pie chart object and click the Change Chart Type button [Chart Design tab, Type group].
In the drop-down list point to Pie.
Choose 3-D Pie.
Format pie chart elements.
Double-click the pie to open its Format Data Series task pane.
Click the Atlanta slice to update the pane to the Format Data Point task pane. (Rest the pointer on a slice to see its identifying ScreenTip.)
Click the Series Options button in the Format Data Series task pane.
Set the pie explosion percentage at 10%.
Close the task pane.
Click the chart object border to deselect the Atlanta slice.
Add and format chart elements in a pie chart.
Click the Add Chart Element button [Chart Design tab, Chart Layouts group].
Point to Data Labels.
Choose More Data Label Options...
If necessary, click the Label Options button In the Format Data Labels pane.
If necessary, click Label Options to expand the group.
Select the Percentage box.
Deselect the Value box (Figure 3-66).Figure 3-66 Format Data task pane for data labels
Press command+B to apply bold.
Change the font size to 12 pt [Home tab, Font group].
Click the chart object border to select it.
Click the Shape Outline button [Format tab, Shape Styles group] and choose Purple, Accent 4, Darker 50% (eighth column).
Click the Shape Outline button and choose Weight and 1 pt.
Click a worksheet cell.
Create a line chart sheet.
Select the Atlanta Revenue sheet tab.
Select cells A4:E7.
Click the Recommended Charts button [Insert tab, Charts group].
Select Line.
Click the Move Chart button [Chart Design tab, Location group].
Click the New sheet button.
Type Promo Depts and click OK.
Apply a chart layout.
Click the Quick Layout button [Chart Design tab, Chart Layouts group].
Select Layout 5 to add a data table to the chart sheet (Figure 3-67).Figure 3-67 Data table added by Quick Layout
Change the chart type.
Click the Change Chart Type button [Chart Design tab, Type group].
Point to Line and choose Line with Markers.
The chart now displays point markers.
Edit chart elements in a line chart.
Click the chart title placeholder.
Type Special Promotion Departments in the Formula bar and press Enter.
Click the vertical axis title placeholder.
Type Dollar Sales in the Formula bar and press Enter.
Click the Chart Elements drop-down arrow [Chart Format tab, Current Selection group].
Choose Series "Apparel" to select the line in the chart.
Click the Format Pane button [Chart Format tab, Format group].
Click the Fill & Line button in the Format Data Series task pane.
Click Marker and then click Marker Options to expand the group (Figure 3-68).Figure 3-68 Marker options for the data series
Choose Built-in and set the Size to 10.
Choose Series "Baseball" to select the line in the chart. (Figure 3-69).Figure 3-69 New data series selected
Apply the same marker changes for the baseball series.
Select the Basketball series and apply the same marker changes.
Close the task pane and click outside the chart.
Insert sparklines in the worksheet.
Click the Atlanta Revenue tab.
Right-click the column F heading and choose Insert.
Select cells B5:E18 as the data range.
Click the Sparklines button and select Line [Insert tab, Sparklines group].
Select cells F5:F18 in the Select where to place sparklines: box.
Click OK.
Format sparklines in worksheet.
Click the Format button [Home tab, Cells group] and change the Row Height to 24.
Click the Format button [Home tab, Cells group] and set the Column Width to 35.
Select the Markers box in the Show group on Sparkline tab.
Click the Sparkline Color button [Sparkline tab, Style group].
Choose Black, Text 1 (second column) for the line color.
Click cell A1.
Change the page orientation to landscape.
Save and close the workbook (Figure 3-70).Figure 3-70 Excel 3-3 completed worksheet and charts
Upload and save your project file.
Submit project for grading.
4 pages
Ms Isac Partnership
MS-ISAC is an abbreviation for the Multi-State Information Sharing and Analysis Center. The center is a subsidiary of the ...
Ms Isac Partnership
MS-ISAC is an abbreviation for the Multi-State Information Sharing and Analysis Center. The center is a subsidiary of the Center for Internet ...
Similar Content
IS 320 University of Maryland Baltimore Advanced Business Applications Worksheet
The exam will start at 2:00 pm new york time. You will have only 90 minutes. Good luck!...
CS 101 Los Angeles City College VB Windows Application Project
Write a VB Windows application to implement each of the following problems. For each
problem, upload a Zip file that conta...
University of North Carolina Different Levels of Analysis of Data Mining Discussion
Below are the different level of analysis of data mining. Provide a brief description of each:
1) Artificial Neural Networ...
AMDE Organ Leader and Decision Making Discussion
After completing the reading this week, we reflect on a few key concepts this week:Discuss what power in the context of le...
4.1t Create Data Models from Questions
Assume the following problem is for a model for a university environment.
How many faculty members are assigned to the mat...
UD Cybersecurity Team and Business Environment Essay
The organization name is TUI and it is an investment company which I have choosen....
Utility Computing
Companies are using the model of availing computing resources and management of related infrastructure to other businesses...
Information Cap And Trade 444
Information Cap and trade can be described as a market approach designed for controlling environmental destructions by pro...
Img 20220513 Wa0002 Converted
...
Related Tags
Book Guides
Extreme Ownership - How US Navy SEALs Lead and Win
by Jocko Willink and Leif Babin
The Sixth Extinction An Unnatural History
by Elizabeth Kolbert
The Hunger Games
by Suzanne Collins
Siddhartha
by Hermann Hesse
Othello
by Wiliam Shakespeare
To the Lighthouse
by Virginia Woolf
Team of Vipers
by Cliff Sims
Too Much and Never Enough
by Mary L. Trump
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
SNHU Pirate Intelligent Agent Project
You will need to be able to access and use my virtual lab. In this assignment, you will apply the concepts you learned abo ...
SNHU Pirate Intelligent Agent Project
You will need to be able to access and use my virtual lab. In this assignment, you will apply the concepts you learned about in the previous few modules – neural networks, reinforcement learning, and Q-algorithms – to design the code for a pathfinding intelligent agent. Specifically, you will be designing code for a pirate non-player character (NPC) that is part of a larger treasure hunt video game. The pirate will need to navigate the game world, which consists of different pathways and obstacles, in order to find the treasure. The pirate agent’s goal is to find the treasure before the human player.
You have been provided with some starter code and a sample environment where your pirate agent will be placed. You will need to create a deep Q-learning algorithm to train your pirate agent. In this milestone, you will be turning in the code for your pirate intelligent agent so that you can receive feedback from your instructor before turning in your final code (along with your design defense) when submitting Project Two.
Prompt
Before creating your pirate intelligent agent, be sure to review the Pirate Intelligent Agent Specifications document. This document provides details about the code that you have been given and what aspects you will need to create.
Download the zipped folder containing your starter code and Project Two Jupyter Notebook. Upload the zipped folder into the Virtual Lab (Apporto), unzip the folder, and upload the files into Jupyter Notebook. Use the Virtual Lab Student Guide and Jupyter Notebook in Apporto (Virtual Lab) Tutorial to help you with these tasks.
Be sure to review the starter code that you have been given. Watch the Project Two Walkthrough video to help you understand this code in more detail. A video transcript is available: Transcript for Project Two Walkthrough video.
IMPORTANT: Do not modify any of the PY files that you have been given.
Complete the code for the Q-Training Algorithm section in your Jupyter Notebook. In order to successfully complete the code, you must do the following:
Develop code that meets the given specifications:
Complete the program for the intelligent agent so that it achieves its goal: The pirate should get the treasure.
Apply a deep Q-learning algorithm to solve a pathfinding problem.
Create functional code that runs without error.
Use industry-standard best practices such as in-line comments to enhance readability and maintainability.
After you have finished creating the code for your notebook, save your work. Make sure that your notebook contains your name in the filename (such as, “Doe_Jane_ProjectTwoMilestone.ipynb”). This will help your instructor access and grade your work easily. Be sure to download a copy of your notebook (IPYNB file) for your submission.
IMPORTANT: Submit the code that you have completed, even if you were not able to completely finish all of the elements. If you have questions, be sure to email your instructor. Be as specific as possible about the issue you are encountering.
Campbellsville University Wk 6 Mobile Computing Discussion
Mobile Computing
Discussion Week 6 - Mobile Computing
We learn from our readings that the use of mobile devices in our soc ...
Campbellsville University Wk 6 Mobile Computing Discussion
Mobile Computing
Discussion Week 6 - Mobile Computing
We learn from our readings that the use of mobile devices in our society today has indeed become ubiquitous. In addition, CTIA asserted that over 326 million mobile devices were in use within The United States as of December 2012 – an estimated growth of more than 100 percent penetration rate with users carrying more than one device with notable continues growth. From this research, it’s evident that mobile computing has vastly accelerated in popularity over the last decade due to several factors noted by the authors in our chapter reading. In consideration with this revelation, identify and name these factors, and provide a brief discussion about them.
Golden Gate University Week 5 Benefits of ISO 27001 Response & Discussion
From your research, discuss whether or not your organization has ISO 27001 certification. Outside of overall protection fr ...
Golden Gate University Week 5 Benefits of ISO 27001 Response & Discussion
From your research, discuss whether or not your organization has ISO 27001 certification. Outside of overall protection from cyber-attacks, describe, in detail, some other benefits your organization will achieve in obtaining this certification. If your company does not have this certification, how can they go about obtaining it?Present your discussion post as if you were presenting to senior leaders of your company.Please make your initial post 600 WORDS and two response posts 150 words each substantive. A substantive post will do at least TWO of the following:Ask an interesting, thoughtful question pertaining to the topicAnswer a question (in detail) posted by another student or the instructorProvide extensive additional information on the topicExplain, define, or analyze the topic in detailShare an applicable personal experienceProvide an outside source (for example, an article from the UC Library) that applies to the topic, along with additional information about the topic or the source (please cite properly in APA)Make an argument concerning the topic.At least one scholarly source should be used in the initial discussion thread. Be sure to use information from your readings and other sources from the UC Library. Use proper citations and references in your post.Reading AssignmentsLopes, M., Guarda, T. & Oliveira, P. (2019). How ISO 27001 Can Help Achieve GDPR Compliance. 2019 14th Iberian Conference on Information Systems and Technologies (CISTI), pp. 1-6. https://ieeexplore.ieee.org/document/8760937?arnumber=8760937
Strayer University Computer Science Paper
Week 1 Activity - Introduction to Project Management Tools Overview The purpose of this activity is to
expose you to the ...
Strayer University Computer Science Paper
Week 1 Activity - Introduction to Project Management Tools Overview The purpose of this activity is to
expose you to the Microsoft Project tool for the purpose of developing a
project plan and Gantt chart for a hypothetical 30-day hobby project of
your choice. Examples include building a deck, painting the garage, or
planting a vegetable garden. Completing this activity will help to
jump-start your successful completion of the project deliverables
throughout the course.This activity consists of two parts:Part 1: Project Introduction or Project Plan
You will outline the project specifics, such as its key objectives,
scope, functional requirements, technical requirements, and key
components.Part 2: Gantt Chart
You will use Microsoft Project to create a Gantt chart for your hobby
project. Download Microsoft Project to your computer if you don't
already have it installed and familiarize yourself with its features.
Note: Microsoft Project is available at no cost
to Strayer University students. For more information, refer to the
left-hand menu option titled “Microsoft Azure for Education.” This
information is also available via iCampus.
You are to create or assume all necessary assumptions to successfully complete this activity.
You must submit both parts as separate files to the assignment area. Label each file name according to the appropriate part.
Instructions Part 1: Project Introduction or Project PlanWrite a 3–5 page document in which you:
Document the hobby project's key objectives and scope.
Develop the hobby project's functional and technical requirements.
Design the hobby project's components, including size, shape, and quality.
Implement the project according to the chosen design and components.
Part 2: Gantt ChartUse Microsoft Project to create a Gantt chart in which you:
Identify the major and minor tasks, illustrating dependency relationships between activities.
Formatting This course requires the use of Strayer
Writing Standards. For assistance and information, please refer to the
Strayer Writing Standards link in the left-hand menu of your course.
Check with your professor for any additional instructions. Note the
following:
The preferred method is for the project plan portion of your
activity to be typed, double-spaced, using Times New Roman font (size
12), with one-inch margins on all sides.
Include a cover page containing the assignment title, your name,
your professor's name, the course title, and the date. The cover page is
not included in the required page length.
You are not required to include a source list page for
this introductory activity. You will, however, be responsible for
citing sources and including a source list page for all of the assigned
course project deliverables.
San Diego State University January Sales in Atlanta For Blue Lake Sports Excel Task
Blue Lake Sports has locations in several major cities and tracks sales by department in each store. For this project, you ...
San Diego State University January Sales in Atlanta For Blue Lake Sports Excel Task
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.
Open the BlueLakeSports-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.
NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.
Create a pie chart object.
Select the Revenue by Department sheet, select cells A4:F4, press command, and select cells A13:F13.
Click the Recommended Charts button [Insert tab, Charts group].
Choose Pie.
Apply a chart style.
Select the chart object.
Click the More button [Chart Design tab, Chart Styles group].
Select Style 12.
Size and position a chart object.
Point to the chart object border to display the move pointer.
Drag the chart object so its top-left corner is at cell A21.
Point to the bottom right selection handle to display the resize arrow.
Drag the pointer to cell G36.
Change the chart type.
Select the pie chart object and click the Change Chart Type button [Chart Design tab, Type group].
In the drop-down list point to Pie.
Choose 3-D Pie.
Format pie chart elements.
Double-click the pie to open its Format Data Series task pane.
Click the Atlanta slice to update the pane to the Format Data Point task pane. (Rest the pointer on a slice to see its identifying ScreenTip.)
Click the Series Options button in the Format Data Series task pane.
Set the pie explosion percentage at 10%.
Close the task pane.
Click the chart object border to deselect the Atlanta slice.
Add and format chart elements in a pie chart.
Click the Add Chart Element button [Chart Design tab, Chart Layouts group].
Point to Data Labels.
Choose More Data Label Options...
If necessary, click the Label Options button In the Format Data Labels pane.
If necessary, click Label Options to expand the group.
Select the Percentage box.
Deselect the Value box (Figure 3-66).Figure 3-66 Format Data task pane for data labels
Press command+B to apply bold.
Change the font size to 12 pt [Home tab, Font group].
Click the chart object border to select it.
Click the Shape Outline button [Format tab, Shape Styles group] and choose Purple, Accent 4, Darker 50% (eighth column).
Click the Shape Outline button and choose Weight and 1 pt.
Click a worksheet cell.
Create a line chart sheet.
Select the Atlanta Revenue sheet tab.
Select cells A4:E7.
Click the Recommended Charts button [Insert tab, Charts group].
Select Line.
Click the Move Chart button [Chart Design tab, Location group].
Click the New sheet button.
Type Promo Depts and click OK.
Apply a chart layout.
Click the Quick Layout button [Chart Design tab, Chart Layouts group].
Select Layout 5 to add a data table to the chart sheet (Figure 3-67).Figure 3-67 Data table added by Quick Layout
Change the chart type.
Click the Change Chart Type button [Chart Design tab, Type group].
Point to Line and choose Line with Markers.
The chart now displays point markers.
Edit chart elements in a line chart.
Click the chart title placeholder.
Type Special Promotion Departments in the Formula bar and press Enter.
Click the vertical axis title placeholder.
Type Dollar Sales in the Formula bar and press Enter.
Click the Chart Elements drop-down arrow [Chart Format tab, Current Selection group].
Choose Series "Apparel" to select the line in the chart.
Click the Format Pane button [Chart Format tab, Format group].
Click the Fill & Line button in the Format Data Series task pane.
Click Marker and then click Marker Options to expand the group (Figure 3-68).Figure 3-68 Marker options for the data series
Choose Built-in and set the Size to 10.
Choose Series "Baseball" to select the line in the chart. (Figure 3-69).Figure 3-69 New data series selected
Apply the same marker changes for the baseball series.
Select the Basketball series and apply the same marker changes.
Close the task pane and click outside the chart.
Insert sparklines in the worksheet.
Click the Atlanta Revenue tab.
Right-click the column F heading and choose Insert.
Select cells B5:E18 as the data range.
Click the Sparklines button and select Line [Insert tab, Sparklines group].
Select cells F5:F18 in the Select where to place sparklines: box.
Click OK.
Format sparklines in worksheet.
Click the Format button [Home tab, Cells group] and change the Row Height to 24.
Click the Format button [Home tab, Cells group] and set the Column Width to 35.
Select the Markers box in the Show group on Sparkline tab.
Click the Sparkline Color button [Sparkline tab, Style group].
Choose Black, Text 1 (second column) for the line color.
Click cell A1.
Change the page orientation to landscape.
Save and close the workbook (Figure 3-70).Figure 3-70 Excel 3-3 completed worksheet and charts
Upload and save your project file.
Submit project for grading.
4 pages
Ms Isac Partnership
MS-ISAC is an abbreviation for the Multi-State Information Sharing and Analysis Center. The center is a subsidiary of the ...
Ms Isac Partnership
MS-ISAC is an abbreviation for the Multi-State Information Sharing and Analysis Center. The center is a subsidiary of the Center for Internet ...
Earn money selling
your Study Documents