All posts by : chebby

1Start Excel. Download and open the file named Exp19_Excel_Ch12_ML1_HW_MembershipDues.xlsx. Grader has automatically added your last name to the beginning of the filename.02Click cell A1, delete the template text, and type Membership Dues.23Delete Column L.04Select the range A1:L7 and clear all data validation that was included in the template.05Add a comment in cell A1 that says “Unprotect the worksheet before editing.“. Be sure to enter the comment as it appears, including the period and excluding the quotation marks.126Use the Macro Recorder to record a macro named Sort that sorts the records in ascending order based on selection (Hint: use relative references when recording the macro).27Ensure the Developer Tab is enabled, then create a Form Control Button named Sort spanning the cell range C1:D1 (ensure that the button is inside the cell borders), and assign the Sort macro. Be sure the label is displayed on the Form Control Button.98Use the VBA Editor to insert a new module named Unprotect. To complete the step, type the code as it appears below. Note there is one blank line after the opening declaration (sub Unprotect). The remaining code does not have space between lines.

Sub Unprotect()

‘Unprotect Sheet
Worksheets(“Member List”).Unprotect.Password = “eXploring”
09Insert a new module named Protect. To complete the step, type the code as it appears below. Note there is one blank line after the declaration (Sub Protect). The remaining code does not have space between lines. Type the following to complete the procedure.

Sub Protect()

‘Protect Sheet
Worksheets(“Member List”).protect.Password= “eXploring”
010Exit the VBA Editor and create a Form Control Button named Unprotect spanning the cell B1. Assign the UnprotectWorksheet macro. Be sure the label Unprotect appears on the Form control button. Then save the file as a macro enabled workbook.911Create a Form Control Button named Protect spanning the cell E1. Be sure to display the label Protect on the Form Control Button and then assign the Protect macro.912Use the Document Inspector to check the document for issues. Remove the Document Properties and Personal Information and the Headers and Footers information. Do not remove Comments and Macro information. Note: If using a Mac, please skip this step and proceed to step 13.213Check the document for Accessibility and compatibility with Excel 2010, 2013, and 2016.014Insert a new worksheet named Code.1015Open the VBA Editor, open module 1, and copy the code. Paste the code in the Code worksheet starting in cell A1. Then delete the rows that are blank (2,4,5, and 6).1516Open the VBA Editor, open the Protect module, and copy the code. Paste the code in the Code worksheet starting in cell A17. Delete any additional blank rows that appear in the code (row 18).1517Open the VBA Editor, open the Unprotect module, and copy the code. Paste the code in the Code worksheet starting in cell A22. Then delete any additional blank rows that appear in the code (row 23).1518Save and close Exp19_Excel_Ch12_ML1_HW_MembershipDues.xlsx. Be sure to save the workbook as a .xlsx file, not a macro enabled workbook. Exit Excel. Submit the file as directed.0
Close

Assignment:
Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course (InfoTech Import in Strat Plan) have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. 

Requirements:

• Provide a 500 word      (or 2 pages double spaced) minimum reflection.
• Use of proper APA      formatting and citations. If supporting evidence from      outside resources is used those must be properly cited.
• Share a personal      connection that identifies specific knowledge and theories from this      course(InfoTech Import in Strat Plan).
• Demonstrate a      connection to your current work environment. If you are not employed,      demonstrate a connection to your desired work environment. 
• You should not      provide an overview of the assignments assigned in the course. The      assignment asks that you reflect how the knowledge and skills      obtained through meeting course objectives were applied or could be      applied in the workplace.

My current occupation: software developer

Course_name :  InfoTech Import in Strat Plan

Course Description

This course focuses on the information technology leader’s collaborative roles working with an organization’s senior leadership, including aligning business strategy with IT strategy, acting as an equal contributor to the formation of organizational strategy, and integrating ethical policies and practices into an organization. Learners evaluate multidisciplinary research and practices related to leadership, organizational structures, and culture. Through the lens of complexity/chaos and change theories, learners analyze information technology’s role in contributing to organizational resiliency.

Prepare a letter to Professor Henderson which contains a simple outline for your upcoming speech. Your topic is”How the culture of the workplace is changing”. The audience is the Business Leaders of America who have asked you to be the Key Note Speaker for their annual meeting. A simple outline contained within the letter is all that is required.

Read the article in the link to provide insight on how to write a successful outline:

How to Craft a Masterful Outline of Speech

https://www.myspeechclass.com/outline.html#the_basics_of_writing_an_informative_outline

Exp22_Excel_Ch05_ML1_RealEstate

Exp22 Excel Ch05 ML1 RealEstate

Excel Chapter 5  Mid-Level 1 – Real Estate

Project Description:

You are a real estate analyst who works for Mountain View Realty in the North Utah County area. You have consolidated a list of houses sold during the past few months and want to analyze the data. For a simple analysis, you will outline the data and use the Subtotal feature. You will then create two PivotTables and a PivotChart to perform more in-depth analysis.

Start Excel. Download and open   the file named Exp22_Excel_Ch05_ML1_RealEstate.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

You are about ready to subtotal the data.   First, you will sort the data.
 

  Sort the list by City in alphabetical order, then by Selling Agent in   alphabetical order, and finally by Listing Date in chronological order   (oldest to newest).

You want to display subtotals   for three columns to analyze the averages.
 

  Use the Subtotal feature to calculate the average Selling Price, % of Asking   Price, and Days on Market by City. Ensure that Summary below data is   selected, and then click or select OK.

Next, you will apply an outline   so that you can collapse and expand columns.
 

  Group the data using the Auto Outline feature. Collapse the outline to hide   the Listing Date and Sales Date columns. Click or select the outline symbol to display the grand average and   city average rows only.

Now you are ready to format the   data and set a print area to print only a select portion of the worksheet.
 

  Format the average days on market as numbers with zero decimal places. Apply   wrap text in cells G1 and J1. Set a print area for the range C1:J88.
 

Select individually columns G   and J and change the column width to 10. Change the row height to 24 for the first row.

PivotTables help you analyze   different perspectives of data. You will create a PivotTable using the Sales   Data worksheet.
 

Click or display the Sales Data   worksheet and create a blank PivotTable on a new worksheet. Name the new   worksheet PivotTable. Name the PivotTable Average City Prices.

Part of the process is arranging   and rearranging fields to provide the perspective to represent the data best.   In addition, you want to display average values instead of total values.
 

  Place the City field in rows, the Selling Agent field in columns, and the   Asking Price and Selling Price fields as values. For the two value fields,   display averages rather than sums with Accounting Number Format with zero   decimal places. Pivot the data by placing the City field below the Values   field in the Columns area and moving the Selling Agent field to the Rows   area.

Now you want to focus on real   estate data for only two cities.
 

  Add a filter to cell B3 to display only Alpine   and Cedar Hills.

Go back to the Sales Data   worksheet. You realize that a selling price is incorrect.
 

  Change the selling price for Number 40 from $140,000 to $1,400,000. Refresh the PivotTable.

You want to format the   PivotTable.
 

  Change the widths of columns A, B, C, D, and E to 11. Change the width of column F to 14 and the width of column G to 13.14. Wrap text and center   horizontally data in cells B4, D4, F4, and G4. Apply the Bottom Border to the   range B4:E4. Change the label in cell A5 to Agent. Change the height of row 4 to 40.

You want to create another   PivotTable to look at the selling prices by city.
 

  Display the Sales Data worksheet. Create a Recommended PivotTable using the   Sum of Selling Price by City thumbnail.
  Note, Mac users, insert a PivotTable on a new worksheet. Add City to the Rows   area and Selling Price to the Values area.
 

  Change the name of the new PivotTable worksheet to Selling Price.

Change the value to display   averages not sums. Apply the Accounting Number Format with zero decimal   places to the values. Apply Light Blue, Pivot Style Medium 2 to the   PivotTable.

You want to display a key value   from the PivotTable on the Sales Data worksheet.
 

  Display the Sales Data worksheet. Insert the GETPIVOTDATA function in cell F1   to display the overall average selling price in cell B9 in the PivotTable on   the Selling Price worksheet.

You decide to create a   PivotChart to illustrate the PivotTable data visually.
 

  Create a clustered column PivotChart from the PivotTable on the Selling Price   worksheet. Move the chart to a chart sheet named Sales Chart.

The chart should have a   meaningful title. You will also modify some chart attributes.
 

  Change the chart title to Average Selling Price by City and apply Dark Blue font color.   Remove the legend. Apply Dark Blue fill color to the data series.

Save and close Exp22_Excel_Ch05_ML1_RealEstate.xlsx.   Exit Excel. Submit the file as directed.

Celebrating his life and his legacy: 

Read each quote below and complete the reflection activity in no more than 300 words: Word document, double-spaced. 

Dr. King quotations:

1. “If you can’t fly, run. If you can’t run, walk. If you can’t walk, crawl. But, by all means, keep moving.”
2. “There comes a time when one must take a position that is neither safe, nor politic, nor popular, but he must take it because conscience tells him it is right.”
3. “The ultimate measure of a man is not where he stands in moments of comfort and convenience, but where he stands at times of challenge and controversy.”
4. “I have decided to stick to love. . . . Hate is too great a burden to bear.”
5. “Let no man pull you so low as to hate him.”

Reflection activity:

Complete a written reflection (no more than 300 words) on your favorite quote above:

1. Identify which quote you are reflecting on.
2. Why is it your favorite one, and what does it mean to you?
3. Does the quote inspire you or remind you of something?

You are an IT system manager working for  the KION Group with the main headquarters in Frankfurt, Germany.  Forklift trucks and warehouse automation equipment are the company’s  main products. A disaster that destroys half or all of a  modern business’s data center is the worst-case scenario. This includes  all of the computers and discs inside it. While such a scenario is  uncommon, it is possible, and not just in the event of a major natural  disaster, such as an earthquake or electrical surges due to a storm.  These circumstances can permanently destroy data centers. The strength of the KION group is  determined by the quality of a business impact analysis (BIA). Because  this is the blueprint that will get you out of any situation, no matter  how big or small, you can navigate easily if the map is well-made.  However, if the information is out of date, incomplete, or otherwise  compromised, you will have difficulty getting back to business as usual. Ensuring you have offsite backups of  your data is the greatest approach to preparing your organization for a  disaster like this. If your production data is stored on-premises in one  of your data centers, you’ll need to make backups of it in a different  data center, or the cloud. If your data is stored in the cloud, you have  the option of backing it up to local storage, another cloud, or another  area of the same cloud. It is essential to restore backup data  on new infrastructure as quickly as possible. Moving significant volumes  of data via the Internet takes a long time, so it’s not a good idea in  the event of a crisis. Moving physical copies of discs from one location  to another could be faster in some situations. Alternatively, it may be  faster and easier to set up new servers in the data center where your  backup data is stored, link them to the backup data, and then use them  as production servers. Because your team is performing so well,  senior management at the KION group decided that your team must  establish a business continuity plan (BCP) and a disaster recovery plan  (DRP) to deal with difficulties that may arise now or in the future.  You’ve been tasked with creating these new plans. 

Instructions

Write a 3–4 page paper in which you:  

1. Summarize the primary purpose of a BIA, including why a BIA is often classified as confidential.
2. Explain how a BIA helps evaluate data and categorize risks with  respect to technology, individuals, and the organization in regard to  the above scenario.
3. Explain the purpose of a BCP, including how a BCP helps to  mitigate risks in regard to the above scenario, and recommend two best  practices to follow when creating a BCP.
4. Explain the purpose of a DRP, including how a DRP helps to  mitigate risks in regard to the above scenario and recommend one best  practice to follow when creating a DRP.
5. Use at least two quality resources in this assignment. Note: Wikipedia  and similar websites do not qualify as quality resources. The Strayer  University Library is a good source for resources.

Your assignment must follow these formatting requirements: 

• 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.

The specific course learning outcome associated with this assignment is: 

• Evaluate and categorize risk with respect to the technology, the  individuals, the enterprise, and the recommend appropriate responses.

For this assignment, you are asked to choose one (1) threat to security and safety as presented in this unit and create a blog (see instructions for the Unit 5 assessment) providing evidence of the threat chosen. Once again you will submit this assignment as a word document.

Your blog should address the following questions:

• What threat did you choose, and why?
• What technological advancement are you using to explore the threat?
• What are the advantages of your chosen technological advancement?
• What issues with personal privacy and/or safety at the individual and societal levels may occur due to the technical advancement?
• In your opinion, do the damages to individuals and society outweigh the benefits? Or do the benefits outweigh the damages?
• How might future technology increase the threat you described?
• How might future technology decrease the threat you described?

Your completed blog must include:

• A description of the threat you have chosen
• A discussion of why you chose it
• A description of the technological advancement you chose to explore
• First advantage of this new technology, include one (1) external reference
• Second advantage of this new technology, include one (1) external reference
• A discussion of how these advantages could lead to issues with personal privacy and/or safety at the individual level, include one (1) external reference
• Your opinion (analysis) based on what you have learned in your learning map and your external sources of the damages versus benefits of the technology at the individual level
• A discussion of how these advantages could lead to issues with personal privacy and/or safety at the societal level, include one (1) external reference
• Your opinion (analysis) based on what you have learned in your learning map and your external sources of the damages versus benefits of the technology at the societal level
• A description of one way that future technology could increase the threat you described, include one (1) external reference
• A description of one way that future technology could decrease the threat you described, include one (1) external reference

Be sure to use appropriate sources for the external references required for this assignment.

After completing Part A of the Lab, complete this graded written assignment for the lab:

Submit a word document containing an analysis and a summary of the completed lab (part A). The word document should contain the following elements:

• Summary of the lab
• Analysis of the activities performed in the lab and their importance to the course topics
• How the lab relates to the course and current module topics
• Related concepts from the module readings and lectures
• At least one external reference
• 1-3 pages in length
• Proper APA formatting and citations
• Minimum of 1-3 references are required
• Screens shots are encouraged but should be included as an appendix and not part of the total page count.

How do managers decide which alternative design strategy to develop?

refer to the attached document and create a response for it.