MOS19_XL_PROJ5 – Charts 1.3

In this project, you will manage charts to meet objectives 5.1 through 5.3 of the Excel MOS Associate exam. To complete the project, you will create charts 5.1, modify charts 5.2, and format charts 5.3. Note: This project was created for PC users since the MOS Exam is completed in the PC user environment.

Steps to Perform:

Step

Instructions

Points Possible

1

Start Excel. Download and open the file named Student_MOS19_XL_PROJ5_Charts.xlsx. Save   the file as Last_First_MOS19_XL_PROJ5_Charts.

0

2

Edit the chart to include the 4th Quarter data series.

8

3

Change the Rows/Columns so that the Departments are the Legend   entries.

8

4

Resize the chart to the range   B14:G30, ensuring that the chart is just inside the cells’ borders.

6

5

Insert a title for the chart and enter Government   Expenses.

6

6

Add Alt Text to the chart and   enter the description, Chart shows a comparison of government expenses for   the first through fourth quarters.

10

7

Insert a 3-D Pie Chart comparing the Department Totals   using Departments as the legend. The chart title will display as Department Total.

8

8

Move the Department Total chart   to a new sheet and rename the sheet Pie Chart.

6

9

Apply Chart Style 3, and then apply Colorful Palette 3.

8

10

On the Expenses worksheet use   Quick Analysis to apply Data Bars to the range F4:F11. Note, Mac users, apply   Solid Blue Data Bars to the range.

8

11

Ensure that the chart is not selected. Insert a Right   Block Arrow shape pointing to the Capital Projects data for the 4th Quarter   of the Government Expenses chart. Position the shape in row 18 and resize the   shape so that the Height is 0.20 and the Width is 1.07.
 

  Hint:

8

12

On the Pie Chart sheet, insert a   Text Box in the Department Total chart. Position the text box in the pie   shape to the right of the 29% data   label. In the text box, type Largest percent, apply Bold to the text, and   then resize the Text Box to Height 0.30 and Width 1.2.
 

12

13

Change the Chart Layout to 1. Use the snipping tool to   take a rectangular snip of the Pie Chart Area including the title. Copy and   then paste the snip in cell I2 of the Expenses worksheet. Resize the snip so   that the upper left corner sits just inside the cell borders of I2, Height 5.91   and Width 6.67.

12

Assignment Content

1.     Continue your work to support the development and implementation of the new Service Department for Appliance Warehouse.

   For this week’s assignment, be sure to refer to Appliance Warehouse Resources: Survey results, Pre-packaged software features, as well as, chapter 7 Development Strategies, and chapter 8 User Interface Design.

   Directions
   In MindTap, review the Appliance Warehouse Case, and do the following:

   • Read the Before You Begin Message and the Module 8-10 Appliance Warehouse Webmail Client Emails. Read the messages to help determine the tasks you must complete.
   • Review and analyze the weekly Appliance Warehouse case study content and resources.
   • Create an 8- to 10-slide presentation with speaker notes (to submit in Blackboard) for senior management with the following:
   • Service Department Software Design: To build a logical model for the new information system, a system analyst must decide on whether to use a SaaS or use an in-house customized software. For this section, ensure you:
   • Research service-based business applications that allow for appointment setting and service provider scheduling.
   • Prepare a list of 4 pros and 4 cons for each of the following:
   • SaaS
   • An in-house customized software
   • Recommend SaaS or in-house software and state your reasoning.
   • Software Requirements: Identify 7-10 requirements the software must do to support the Services Department.
   • Develop a Communication Plan: Explain how stakeholders and managers will be kept informed regarding project process. Your plan should include the form of communication (status reports,meetings, etc.), frequency, and specific project milestones that will aid in determining where the implementation stands.

Download The Attachment and Message Me Please for Detailed Instructions

Portfolio Project: This week discuss a current business process in a specific industry. 

Note the following:

-The current business process itself.
-The industry the business process is utilized in.
After explaining the current situation, take the current learning from the course and:
Explain a new technology that the business should deploy. 

Be specific, don’t only note the type of technology but the specific instance of technology.  (For example, a type of technology is smart automation a specific type of automation is automated light-dimming technology).

Note the pros and cons of the technology selected.

Note various factors the business should consider prior to deploying the new technology.

The above submission should be three pages in length.  Remember the total length does not include the APA approved cover page or the references.  There should be at least three APA approved references to support your work

Assignment Content

1. At this point, you have found a research article exploring your approved research question and you have learned how to find your 6 ‘ingredients’ during class .

   For this assignment:  You will use your research article from Week 4’s HW to write your first objective summary. 
   Requirements:

   • 15 pts, Cover/Title Page 
   • 70 pts, Objective Summary: W(5) H(1) — YOU MUST PUT THIS IN YOUR OWN WORDS 
   • 15 pts, References Page (you will only have one reference listed — the research article you are using.) 
   • Resources to help you:
   • Re-watch the class recording
   • See pp. 17-22 to read about objective summaries
   • See pp. 23-28 to read more about avoiding plagiarism

Assignment Details

In Unit 4, as we enter the systems integration selection phase, we must select the technical integration framework, and describe and illustrate our systems integration architecture.

For this Discussion Board assignment, share how you think integration frameworks typical to the systems integration selection phase are best used to represent an integration of your system components.

Responses to Peers:

Compare the integration frameworks identified by other students in the discussion, and share how it can be used to supplement integration patterns in your solution.

In your own words, please post a response to the Discussion Board and comment at least 75 words on other people post. You will be graded on the quality of your postings

It’s important to program your code efficiently. Efficient code manages errors and exceptions and cleans up memory after it ends. The try-except statements are helpful in handling errors that are detected during execution.

Respond to the following in a minimum of 175 words:

• What are the 2 categories of errors when debugging code? How can the try-except statements handle errors in Python? Provide a code example that supports your comments.

Create a policy that ensures all evidence is collected and handled in a secure and efficient manner. Remember, you are writing a policy, not procedures. Focus on the high-level tasks, not the individual steps.

• Description of information required for items of evidence
• Documentation required in addition to item details (personnel, description of circumstances, and so on)
• Description of measures required to preserve initial evidence integrity
• Description of measures required to preserve ongoing evidence integrity
• Controls necessary to maintain evidence integrity in storage
• Documentation required to demonstrate evidence integrity

For this assignment, I do not want any copy work from someone else,s paper. In a simple and clear term. All sources must be cited. Request for any additional material and I will provide them. I repeat I need original work, following assignment objectives

As the CISO, you are responsible for development and implementation of various security policies to ensure the protection of company sensitive information and systems. There are different levels of policy from executive level to issue specific and system level policies.Discuss how the program policy leads to the other types of policies. Provide at least two examples of issue specific policies and two system specific (codified) policies. Include at least one research reference and associated in-text citation using APA standards. In your replies to your peers discussing the examples given and how they can reduce risk to the corporate network.