Circuit City was an American consumer electronics company founded by Samuel Wurtzel in 1949. By 1990s, Circuit City became the second largest consumer electronics store in the United States with annual sales of $12 billion. On March 8 2009, Circuit City shutdown all its stores. On January 8th at the 2018 Consumer Electronics Show in Las Vegas, Circuit City CEO announced a comeback and relaunch of Circuit City into “a dynamic, a social-focused ecommerce site” and a new business strategy for its retail stores12 . 

In this case study, assume that Circuit City hired you as the new chief information officer (CIO) to help relaunch the company into a global e-commerce multinational company. 

Assignment should be of 11 pages. APA Format. 4 -5 Professional References. Attached the project rubrics for reference. Make sure to check the rubrics for good score.

Create an Assignment & PowerPoint presentation containing the IT strategic plan that will address Circuit City ecommerce initiatives. 

The following information should be covered in the Assignment / presentation. 

Abstract

1. Introduction / History of Circuit City 

2. What were the issues and challenges that caused the collapse of Circuit City in 2009? 

3. What are the issues and challenges with Circuit City 2018 latest e-commerce initiative?  

4. Discuss the major competitors in global e-commerce. 

5. How would IT deliver value to the business? 

6. Proposed the IT infrastructure required to support global e-commerce 

7. Proposed the IT budget/cost analysis for the e-commerce initiative 

8. Discuss the IT based risks associated with global e-commerce 

9. Discuss how IT can leverage innovative technologies such as social media, big data and business intelligence to provide value to the business 

10. Discuss the future or emerging technologies that would be leveraged to give Circuit City a competitive advantage.

11. Conclusion

Links: 

1 http://circuitcitycorporation.com/circuit-city-to-announce-official-company-relaunch-at-the-2018-consumerelectronics-show-on-january-8th/ 

2 http://fortune.com/2018/01/09/circuit-city-relaunch-website/

Given the following, describe how you would improve security for this system.

There is a system containing unencrypted sensitive information (Social Security numbers, driver’s license numbers, first names, last names, and credit card numbers). The system, running a Windows 2008 server, is used only by employees but is on the public Internet, as employees need to access the system from home. Authentication is provided by NTLM, using username and password. The machine is currently directly plugged into its own dedicated cable modem.

Can you recommend five ways we can improve the security of this system, given a $10,000 budget? We should make sure to recommend solutions for software, hardware, and network security improvements. The data is used by 15 users and is secured using a powerful system with decent authentication.

Make sure to provide costs for all features.

Parameters:

• 12-point font
• Double-spaced
• 2 pages

Criteria

Discuss how the software can be improved.

Discuss how the hardware can be improved.

Discuss how the network can be improved.

This week you will visit a Best Buy store or a similar computer supply store to compare and price check three different types of routers that would best fit the needs of the each of the following:

• A home network of a family of 5 with 10 computers/devices that will be connected to the network.
• A small coffee shop that seats up to 20 customers at a time. The network will need to have capabilities of having two registers, the main office computer and up to 50 guest computers/devices connected all at one time.
• Use the article, “Getting Faster Wi-Fi” to help you.

Need it by Friday 4pm eastern time

 concepts of Physical Security as they relate to Access Control and Lighting  

Attached attached for instruction

 This coursework is worth 20% of the total module mark. Submission details: 1. Compile your answers to Problem 1, Problem 2 in a report, and submit it as a softcopy to the module’s Moodle website. Your report must be typed and the font size used must be 11 or greater. 2. Submit the SIMUL8 file from Problem 2, part b) in *.S8 format on the module‘s Moodle website. Please use your student ID number as your report and *.S8 file name (e.g. 351363.S8). Do not mention your name anywhere in your submissions. This is an individual assignment. Plagiarism or copying is not permitted and any offence will be dealt with under the University procedures. Throughout this assignment please use the following constants: u = The first two digits of your student ID number v = The third and fourth digits of your student ID number w = The final two digits of your student ID number (e.g. A student ID number 351363 gives u = 35, v = 13, w = 6 

Complete a Physical Security Assessment (internal and external) of your place of work or living area.  If you use your work area make sure you inform the Security Manager to get permission as to what you are doing. If you live in a gated community inform the security guard of your activities. Refer to your text on the importance of Lighting and Access Control and be sure to cover the salient issues discussed in the text.

Chapter 8: Project Risk Analysis and Identification  Initial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.Also, provide a graduate-level response to each of the following questions:

• Please research and provide a two page, referenced discussion on the logic of identifying and eliminating risk for a project and be sure to include an explanation on how an organization comes to conclusions as to how much revenue and time to commit to this process.

Text

Title: Managing Project Risks 

ISBN: 9781119489733 

Authors: Peter J. Edwards, Paulo Vaz Serra, Michael Edwards 

Publisher: John Wiley & Sons 

Publication Date: 2019-08-13

 Question #1. Watch the video titled “Video Tour of the Electromagnetic Spectrum” (5 min 03 s). Be prepared to discuss.
Video Source: NASA. (2012, June 20). Video Tour of the Electromagnetic Spectrum [Video file]. Retrieved from . 

SK16_XL_VOL1_GRADER_CAP_HW – Revenue 1.5

Project Description:

In this project, you will unhide a worksheet, work with grouped worksheets, insert and rename worksheets, insert summary, logical, date, and statistical functions, and refer to cells in other worksheets. Additionally, you will apply conditional formatting, create and modify charts, and create, sort, and filter Excel tables.

Start   Excel 2016. Download and open the file sk16_xl_ch1-4_grader_cap_hw.xlsx. Save the file as Last_First_sk16_xl_ch1-4_grader_cap_hw.xlsx.

Group the worksheets and change   the width of B:E to 13.00. Change the height of row 4 to 15.00.

With the worksheets grouped,   insert a function in E5:E14 to sum the Quarter Total. Insert a function in   B15:E15 to total the Budget for each location. Apply the Total cell style to   the Total Budget results. In E6:E14 apply Comma [0] cell style.

With the worksheets grouped,   insert a function in B17 to calculate the Average North budget item. In cell   B18, insert a function to calculate the highest North budget item. In cell   B19, insert a function to calculate the lowest North budget item. AutoFill the   range B17:B19 through column D.

Ungroup and insert a new   worksheet. Rename the worksheet Summary, and then change the tab color to Gold, Accent 6. Move the   worksheet to the first position in the workbook.

Copy the range A1:E4 from any of   the quarter worksheets. Paste the range to the Summary worksheet in A1:E4   using paste option Keep Source Column Widths.

On the Summary worksheet, change   the subtitle of cell A2 to Annual Budget. Change the label in cell A4 to Quarter. In cell A5, type 1st Quarter and the AutoFill down through   cell A8. Type Annual Total in cell A9.

On the Summary worksheet, enter   a formula in cell B5 setting the cell equal to cell B15 in the First Quarter   worksheet. Enter formulas in B6:B8 setting the cells equal to the North   totals from the Second, Third, and Fourth Quarter worksheets. AutoFill the   range B5:B8 through column E.

On the Summary worksheet, insert   a function in the range B9:E9 to calculate the column totals. Apply the Comma   [0] cell style to B6:E8, and then apply the Total cell style to the range   B9:E9.

On the Summary worksheet, in   cell A11, type Bonus if less than In cell A12, type 1100000 and then apply the Accounting number format   with 0 decimal places. Select the range A11:A12, and then apply Outside   Borders.

On the Summary worksheet, in   cell B11, insert the IF function. For the logical test, check whether the   North total is less than the value in cell A12. If the logical test is true, 500 should display, and if the   logical test is false, 50 should display. In the function, use an absolute cell reference   when referring to cell A12.

On the Summary worksheet, in   cell B11, apply the Currency [0] cell style, and then AutoFill cell B11   through D11.

On the summary worksheet, select   the range B5:D8, and then insert the default Data Bars conditional format.

On the Summary worksheet, in   cell A16, insert the TODAY function. Format the date with the March 14, 2012   date format.

On the Summary worksheet in the   range F5:F9, insert column Sparklines for the range B5:D9. Show the Low Point   and apply Sparkline Style Colorful #2.

Unhide the Last Year worksheet.   Copy the Annual Budget shape, and then paste the shape in the Summary   worksheet. Move and resize the shape to approximately the range A19:E23.

On the Last Year worksheet,   format the range A4:E14 as a table with headers using the Table Style Light   2. Add a Total row, and then apply Sum to B15:D15. Sort the Budget item   column in ascending order. Apply the Currency [0] cell style to the Total   row.

Hide the Last Year worksheet.

On the First Quarter Worksheet,   click cell A1. Find and replace the four occurrences of Qtr with Quarter in the worksheet headings (Hint: on the Replace tab of the Find   and Replace dialog box, select Within: Workbook, if necessary).

On the Fourth Quarter worksheet,   show the formulas in the worksheet. Set the width of the worksheet to print   on 1 page. Set rows 1:4 to repeat as titles when printing. Group the   worksheets.

With the worksheets grouped,   check and correct any spelling errors. Add the filename to the left footer   and the sheet name to the right footer. Return to Normal view, and select   cell A1. Ungroup the worksheets.

On the Summary worksheet, insert   a 3-D Pie chart using the non-adjacent ranges A4:A8 and E4:E8. Move the pie   chart to a new sheet and rename as Budget Chart.

Format the chart using Layout 1,   and Chart Style 8. Revise the title to Aspen Falls Annual Budget. Apply font size 14 to the data   labels.

Verify the worksheets are in   this order Budget Chart, Summary, First Quarter, Second Quarter, Third   Quarter, and Fourth Quarter. Save the file, and Close Excel. Submit the file   as directed.