Monthly Archives: June 2023

Write a program that uses regular expressions to convert the first letter of every word to uppercase. Have it do this for an arbitrary string input by the user. 

Please use C# language and submit as a zip file.

 When thinking about data visualization, it is important to understand regular expressions in data analytics.  Therefore, note the importance of data visualizations and choose two types of expressions (* – wildcards for example) and discuss the difference between the two types of expressions. 

You are given examples of 3 industries

1. Online trading e.g. eBay, Amazon (pick this if your last name starts with A or B)
2. Grocery stores e.g. Safeway, Giant etc ( pick this if your last name starts with D, E, G and I)
   
3. Fast food restaurants e.g. Macdonalds, BurgerKing etc (Pick this if your last name starts with L,M and O)
4. Gasoline retailers e.g. Sunoco, Exxon etc (Pick this is your last name starts with S or T)

Pick one of the industries above (based on your last name initial) and determine if it falls under a perfectly competitive market.  If yes support your answer if no state why.

Use the internet to research and find one example of a data visualization each for categorical data, time-series data, and spatial data. Discuss the data set and the following topics.

How effective is the visualization? Why?

What elements would you modify?

Does the example reveal the tool used ( PowerBI, R, Tableau, Qlikview….?What problem is the visualization addressing? 

— 4 apa references

— 3 pages

Chapter 3:
1.Define and describe PaaS.
2.List the benefits of PaaS solutions.
Chapter 4:
3.Define and describe IaaS.
4.Define and describe system redundancy. Discuss how you might use IaaS to implement a redundancy plan.

 Use 50- 70 words max per topic to discuss and present the answer.   

 References:
Erl, T., Mahmood, Z., & Puttini, R. (2014). Cloud computing: concepts, technology, & architecture. Upper Saddle River, NJ: Prentice Hall.
Jamsa, K. A. (2013). Cloud computing: SaaS, PaaS, IaaS, virtualization, business models, mobile, security and more. Burlington, MA: Jones & Bartlett Learning. 

 200 words due 09/26 11:59 pm est

Beginning on  May 13, 2017 hackers successfully breached Equifax’s customer dispute portal. The hackers used an Apache Struts vulnerability, a months-old issue that Equifax knew about but failed to patch, and gained access to login credentials for three servers.  Those login credentials in turn allowed the hackers to access another 48 servers containing personal information. The hackers spent 76 days within the Equifax network before they were detected. Equifax didn’t discover the attack until July 29, and cut off the hackers’ access on July 30. The breach exposed the personally identifiable information of over 147 million Americans.  This information included social security  numbers, names, addresses,  birthdates, credit card numbers and driver’s license numbers. Personally identifiable information of British and Canadian citizens was also compromised.In your initial post, please answer both of the following questions:

1. Choose a federal law (Equifax is a credit reporting agency and subject to special laws) or a  US state data breach law or the EU GDPR (check our reading materials and PowerPoint slides, the links below, and ncsl.org for descriptions of applicable law) and explain how it applies or has already been applied to Equifax for its data security breach.  You use the FTC settlement page as a source for your discussion or include a discussion of any private litigation. Alternatively, since 4 members of the Chinese People’s Liberation Army have recently been indicted, you may choose to discuss whether this indictment represents an example of state-sponsored cyber warfare. Remember to distinguish in your own mind the difference between Equifax’s liability for the security/data breach and the hackers’ liability for carrying out the breach.
2. Using your best judgment, what would you recommend to create and maintain an infrastructure for Equifax that would most robustly and effectively protect against future breaches and the liabilities resulting from those breaches?  Include any specifics you may be familiar with such as hardware and software recommendations, compliance with specific US and  international laws, industry best practices, and any appropriate third-party vendor solutions.

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.

1. 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.
2. Create a pie chart object.
   1. Select the Revenue by Department sheet, select cells A4:F4, press Ctrl, and select cells A13:F13.
   2. Click the Recommended Charts button [Insert tab, Charts group].
   3. Choose Pie and click OK.
3. Apply a chart style.
   1. Select the chart object.
   2. Click the More button [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 Type button [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 Charts tab and choose Pie in the left pane.
   3. Choose 3-D Pie and click OK.
6. Format pie chart elements.
   1. Double-click the pie to open its Format Data Series task pane.
   2. 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. )
   3. Click the Series Options button 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 slice.
7. Add and format chart elements in a pie chart.
   1. Click the Chart Elements button in the top-right corner of the chart.
   2. Select the Data Labels box.
   3. Click the Data Labels arrow to open its submenu and choose More Options.
   4. If necessary, click the Label Options button In the Format Data Labels pane.
   5. If necessary, click Label Options to expand the group.
   6. Select the Percentage box.
   7. Deselect the Value box (Figure 3-66).Figure 3-66 Format Data task pane for data labels
   8. Press Ctrl+B to apply bold.
   9. Change the font size to 12 pt [Home tab, Font group].
   10. Click the chart object border to select it.
   11. Click the Shape 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).
   12. Click the Shape Outline button and choose Weight and 1 pt.
   13. Click a worksheet cell.
8. Create a line chart sheet.
   1. Select the Atlanta Revenue sheet tab.
   2. Select cells A4:E7.
   3. Click the Quick Analysis button and choose Charts.
   4. Select Line.
   5. Click the Move Chart button [Chart Design tab, Location group].
      Click the Move Chart button [Chart Tools Design tab, Location group].
   6. Click the New sheet button.
   7. Type Promo Depts and click OK.
9. Apply a chart layout.
   1. Click the Quick Layout button [Chart Design tab, Chart Layouts group].
      Click the Quick Layout button [Chart Tools Design tab, Chart Layouts group].
   2. Select Layout 5 to 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 Type button [Chart Design tab, Type group].
       Click the Change Chart Type button [Chart Tools Design tab, Type group].
    2. Select the All Charts tab and choose Line with Markers in the Line category.
    3. Click OK.
11. Edit chart elements in a line chart.
    1. Click the chart title placeholder.
    2. Type Special Promotion Departments in the Formula bar and press Enter.
    3. Click the vertical axis title placeholder.
    4. Type Dollar Sales in the Formula bar and press Enter.
    5. Click the Chart Elements drop-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 Selection button [Chart Format tab, Current Selection group].
       Click the Format Selection button [Chart Tools Format tab, Current Selection group].
    8. Click the Fill & Line button in the Format Data Series task pane.
    9. Click Marker and then click Marker Options to expand the group (Figure 3-68).Figure 3-68 Marker options for the data series
    10. Choose Built-in and set the Size to 10.
    11. Click the Series Options triangle at the top of the task pane and choose Series “Baseball” (Figure 3-69).Figure 3-69 New data series selected
    12. Apply the same marker changes for the baseball series.
    13. Select the Basketball series and apply the same marker changes.
    14. Close the task pane and click outside the chart.
12. Insert sparklines in the worksheet.
    1. Click the Atlanta Revenue tab.
    2. Right-click the column F heading and choose Insert.
    3. Select cells B5:E18 as the data range.
    4. Click the Line Sparkline button [Insert tab, Sparklines group].
    5. Select cells F5:F18 in the Location Range box.
    6. Click OK.
13. Format sparklines in worksheet.
    1. Click the Format button [Home tab, Cells group] and change the Row Height to 24.
    2. Click the Format button [Home tab, Cells group] and set the Column Width to 35.
    3. Select the Markers box in the Show group in the Sparkline tab.
       Select the Markers box in the Show group on the Sparkline Tools Design tab.
    4. Click the Sparkline Color button [Sparkline tab, Style group].
       Click the Sparkline Color button [Sparkline Tools Design  tab, Style group].
    5. Choose Black, Text 1 (second column) for the line color.
    6. 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.

Information Systems for Business and Beyond Questions

• Chapter 1 – study questions 1-5, Exercise 3
• Chapter 2 – study questions 1-10, Exercise 2     

Information Technology and Organizational Learning Questions

• Chapter 1 – Review the Key Lessons from Chapter 1 – Explain the five key lessons and note the importance of each key lesson from chapter 1.  Also, note why is it important to understand these basic concepts. 
• Chapter 2 – Note why the IT organizational structure is an important concept to understand.  Also, note the role of IT in the overall business strategy.

  SUBJECT     ITS530 – M50 Analyzing & Visualizing Data  

Provide a reflection of at least 500 words of how the knowledge, skills, or theories of this course 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.

Excel_Introductory_Capstone1_Year_End_Report

In this project, you will work with multiple worksheets and enter formulas and functions to calculate totals, averages, maximum values, and minimum values. Additionally, you will create a summary sheet, format cells, insert charts, insert sparklines, and create a table in a workbook.

1

Open the Excel file Student_Excel_Intro_Cap1_Year_End_Report.xlsx   downloaded with this project.

2

On the Net Sales worksheet,   calculate totals in the ranges F4:F8 and B9:F9. Apply the Total cell style to   the range B9:F9.

3

Using absolute cell references   as necessary, in cell G4, construct a formula to calculate the percent that   the Colorado Total is of Total Sales, and then apply Percent Style with zero   decimals. Fill the formula down through the range G5:G8.

4

In the range H4:H8, insert Line   sparklines to represent the trend of each state across the four quarters. Do   not include the totals. Display Markers.

5

Select the range A3:E8, and then   use the Recommended Charts command to suggest an appropriate chart. Click the   first Clustered Column chart that uses the state names as the category axis.   Align the upper left corner of the chart inside the upper left corner of cell   A11, and then size the chart so that its lower right corner is slightly   inside cell H24. Apply chart Style 7. As the chart title, type Quarterly Net   Sales by State.

6

To show the percent that each   state contributes to the total sales, select the nonadjacent ranges that   represent the state names and state totals. Insert a 3-D Pie chart, and then   move the chart to a New sheet. Name the sheet Net Sales by State.

7

Change the Chart Title to   and then   change the chart title Font Size to 36. Remove the Legend from the chart, and   then add Data Labels that display only the Category Name and Percentage   positioned in the Center. Change the data labels Font Size to 14 and apply   Bold and Italic. Change the Font color to White, Background 1.

8

Select the entire pie and   display the Format Data Series pane. From the 3-D Format gallery, modify the   3-D options by changing the Top bevel and Bottom bevel to first bevel in the   first row. Set all of the Width and Height boxes to 512 and then change the   Material to the third Standard type—Plastic.

9

Insert a Custom Footer with the   File name in the left section and then save your workbook.

10

On the Seattle Inventory   worksheet, in cell B5, enter a function that will display the average retail   price. In cell B6, enter a function that will display the median retail   price. In cell B7, enter a function that will calculate the lowest retail   price. In cell B8, enter a function that will calculate the highest retail   price. Format the range B5:B8 with Accounting Number Format.

11

In cell B10, insert a COUNTIF   function that counts the number of Skiing items in the Sport column.

12

On the Seattle Inventory   worksheet, in cell G14, enter an IF function to determine the items to be   ordered. If the Quantity in Stock is less than 50, then the cell should display Order. If not, then the cell should   display OK.   Copy the function down through cell G19.

13

Format the range A13:G19 as a   table with headers. Filter the table on the Sport column to display only the   Skiing types. Display a Total Row in the table, and then sum the Quantity in   Stock for Skiing items. Type the result in cell B11. Remove the total row   from the table and then clear the Sport filter.

14

Add Gradient Fill Blue Data Bars   to the range A14:A19. Add conditional formatting to the range G14:G19 so that   the cells with text that contain the word Order are formatted with Bold and Italic. Sort the table   by Item # from Smallest to Largest.

15

Display the Inventory Summary   sheet. In cell B4, enter a formula that references cell B4 in the Seattle   Inventory sheet so that the Seattle Total Items in Stock displays in cell B4.   In cell B5, enter a formula that references cell B5 in the Seattle Inventory   sheet so that the Seattle Average Price displays in cell B5. In cells B6, B7,   and B8, enter similar formulas to reference the Median Price, Lowest Price,   and Highest price in the Seattle Inventory sheet.

16

In cell C4, enter a formula that   references cell B4 in the Denver Inventory sheet so that the Denver Total   Items in Stock displays in cell C4. In cells C5, C6, C7, and C8, enter   similar formulas to reference the Average Price, Median Price, Lowest Price,   and Highest price in the Denver Inventory sheet. Apply Accounting Number   format to the range B5:C8.
 

17

On the Annual Expenses sheet,   construct formulas to calculate Totals by Quarter in the range B10:E10 and   the Annual Totals in the range F5:F10. Apply the Total cell style to the   Totals by Quarter (B10:F10), and then center the column headings (B4:G4) and   apply the Heading 4 cell style.

18

Using absolute cell references   as necessary, in cell G5, construct a formula to calculate the % of Total by   dividing the Sales Expense Annual Total by the Annual Totals by Quarter. Fill   the formula down through the range G6:G9.

19

Using the data in the   nonadjacent ranges B4:E4 and B10:E10, insert a Line with Markers chart.   Position the upper left corner of the chart slightly inside the upper left   corner of cell A12. Change the height of the chart to 1.75 inches and the width of the   chart to 8   inches.
 

  Note, Mac users, change the height of the chart to 1.5 inches.

20

Apply chart Style 7. Change the   chart title to Direct Expenses. Edit the Vertical (Value) Axis so that the   Minimum is 8000000 and the Major unit is 1000000.

21

Use Format Painter to copy the   formatting from cell A2 to A20. In cell B23, enter a formula that references   the value in cell F10.

22

Using absolute cell references   as necessary, in cell C23, construct a formula to calculate the projected   expenses for 2020 after the Forecasted increase in cell B21 is applied. Fill   the formula through cell F23.

23

Display the Sales Reps sheet. By   using Flash Fill and deleting columns as necessary, place the last names in   column A and the first names in column B. Widen both columns to 100 pixels,   and then merge and center the title Sales Reps across the two columns. Apply   the Heading 1 cell style to the title.
 

24

With any sheet except the chart   sheet active, group the worksheets. Change the Orientation to Landscape,   center the worksheets Horizontally, and insert a footer in the left section   with the file name. (Mac users, click the Net Sales sheet, hold down SHIFT,   and then click the Sales Reps sheet. Then apply the Page Layout options.)

25

Save and close the file and   submit for grading.