Subject: ITS-836 – Data Science & Big Data Analytics

Reading Resources: 

Cappa, Oriani, R., Peruffo, E., & McCarthy, I. (2021). Big Data for Creating and Capturing Value in the Digitalized Environment: Unpacking the Effects of Volume, Variety, and Veracity on Firm Performance. The Journal of Product Innovation Management, 38(1), 49–67.

Maqueira-Marín, Bruque-Cámara, S., & Minguela-Rata, B. (2017). Environment determinants in business adoption of Cloud Computing. Industrial Management + Data Systems, 117(1), 228–246.
 

Psomakelis, Aisopos, F., Litke, A., Tserpes, K., Kardara, M., & Campo, P. M. (2016). Big IoT and social networking data for smart cities: Algorithmic improvements on Big Data Analysis in the context of RADICAL city applications.
 

Chan, Cheung, C. M. K., & Wong, R. Y. M. (2019).
Cyberbullying on Social Networking Sites: The Crime Opportunity and Affordance Perspectives. Journal of Management Information Systems, 36(2), 574–609.

Word count: 300+ words 

Discussion: Data analytics offers many benefits and challenges to organizations locally and globally. Find an organization with a data analytics use case.

– Please cite properly in APA 7· 

– At least one scholarly source should be used. · 

– Use proper citations and references in your post.

– Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.  

Note: plagiarism check required, APA7 format, include References, within 8hrs

You are required to write a 4,000 word (with 10% over/under) research paper based on your practical project for this module. The paper should contain rigorous evidence and references from the primary (your own effort of social data harvesting) and/ or secondary data collection (third-party available dataset or current literatures) you undertook.   Research Rationale and MotivationAs part of practical research in this module and learnt from the weekly studios, you will be harvesting a suitable dataset using the relevant tools, i.e. Tableau, Python, Facebook or Twitter API or third party Tool(s) and extracting relevant information from the results.  Therefore, you should start your paper with the motivation or rationale of your research, especially the business aim of your project. The design and approach of your project such as the reasons for the choice of social web harvesting, scope for strategic or tactical decision making, business values, public interest, marketing campaign, product reviews, branding and marketing, customers’ preferences or other etc. Research Tools and MethodsYou need to discuss your research into suitable tools and/ or APIs and the justification for your choice. Based on this, you should then document the design of your project and show clearly how your research project communicates with any third-party service or API. Results and VisualisationsYou should discuss the results with necessary business or social implications and relate that back to the motivation or rationale of your social media project. Visualisation is very important, so the report should also contain suitable visualisations for your business storytelling out of the social data you collected. Limitations and ImplicationsIn addition, project limitations and recommendations are desirable. Conclusion and AppendicesFinally, draw a conclusion with key results to nicely conclude your web harvesting research. You are encouraged to compare various technical tools and techniques to demonstrate the social media analytics skills you have learnt. You can implement your social web harvesting research project using any suitable language / technology / third-party tools you see fit. You can hard-code queries or you can provide a suitable front-end where users can enter search keywords. In addition, you can show the results in any suitable form, e.g. tables, various forms of innovative graphs or information overlaid on a map. The final visualisation needs to be published on Tableau Public and include the link and evidences in the paper as Appendixes. 

Additional Information 

Referencing Requirements (Harvard)

The Harvard (or author-date) format should be strictly used for all references (including images). Further information on Referencing can be found at Cardiff Met’s Academic Skills website. 

Edit question’s 

 Topic: Heart Disease among older adults

Using the topic and research question you developed in week 1, you will design a quantitative instrument that could potentially answer your topic/research question if it were to be applied to a quantitative study. Keep in mind, this may take some stretching if you wrote your question leaning quantitatively. The purpose here is not to box you in but to ensure that you have a solid understanding of both methodologies. This assignment functions similar to 3.1 but in a quantitative format. Finally, view the rubric and examples to make sure you understand the expectations of this assignment.

Directions:

You will develop a word document to include:

1. Your research question in the form of a quantitative question (if it was not already).
2. An instrument or protocol (survey, questionaire, archival data, etc) that could be used to answer the quantitative version of your research question. 

*Special note for those using archival data, you will describe the process of data retrieval for your archival data. See examples to help.

1. A one paragraph description/justification of how your chosen instrument/protocol is the best choice for answering the quantitative version of your research question.

See examples to help guide your writing:  Quantitative Instrument Samples.pdf

View the rubric: Rubric for Data Instrument.docx

 Future, International Perspective and Impacts of Net Neutrality in 250 words. 

The Wear-Ever Shoes company maintains inventory data and customer survey results in your workbook. You use Lookup & Reference, Database, and Logical functions to complete the data. You also use a Financial function to calculate depreciation and a Text function to enter email addresses.

[Student Learning Outcomes 6.1, 6.2, 6.3, 6.5, 6.6, 6.7]

File Needed: WearEverShoes-06.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-WearEverShoes-06.xlsx

Skills Covered in This Project

• Nest INDEX and MATCH functions.
• Use SUMIFS from the Math & Trig category.
• Use DAVERAGE.
• Create an IFS formula.
• Use a Text function to concatenate text strings.
• Calculate depreciation with the DB function.

1. Open the WearEverShoes-06 start file. 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. Click the Inventory sheet tab.
3. Select cells A3:I39, click the Name box, type Inventory as the range name, and press Enter.
4. Select cell L5 and type WE006.
5. Create a nested function with INDEX and MATCH to display inventory for a product.
   1. Select cell L6.
   2. Click the Lookup & Reference button [Formulas tab, Function Library group] and choose INDEX. Select the first argument list array, row_num, column_num and click OK.
   3. For the Array argument, press F3 (FN+F3) and select Inventory.
   4. Click the Row_num box and click the Name box arrow. Choose MATCH in the list or choose More Functions to find and select MATCH. The INDEX function uses this MATCH statement to find the row.
   5. Click cell L5 for the Lookup_value argument.
   6. Click the Lookup_array box and select cells A3:A39. This MATCH function finds the row that matches cell L5 in column A.
   7. Click the Match_type argument and type 0.
   8. Click INDEX in the Formula bar. (Click OK if the argument list opens.)
   9. Click the Column_num argument, click the Name box arrow, and choose MATCH (Figure 6-92).Figure 6-92 MATCH is nested twice
   10. Type quantity in the Lookup_value box.
   11. Click the Lookup_array box and select cells A3:I3. This MATCH function finds the cell in the “Quantity” column after the row is located by the first MATCH function.
   12. Click the Match_type box and type 0. The formula is =INDEX(Inventory,MATCH(L5,A3:A39,0),MATCH(“quantity”,A3:I3,0)).
   13. Click OK. The result is 2.
   14. Click cell L5, type WE015, and press Enter. The quantity is updated.
6. Use SUMIFS to calculate total pairs in stock by specific criteria.
   1. Select cell M13.
   2. Click the Math & Trig button [Formulas tab, Function Library group] and choose SUMIFS.
   3. Select cells E4:E39 for the Sum_range argument and press F4 (FN+F4) to make the references absolute.
   4. Click the Criteria_range1 box, select cells C4:C39, the “Color” field, and press F4 (FN+F4).
   5. Click the Criteria1 box and select cell K13. Leave this as a relative reference.
   6. Click the Criteria_range2 box, select cells D4:D39, and make the references absolute.
   7. Click the Criteria2 box and select cell L13. The criteria specifies the number of black pairs, size 8 (Figure 6-93).Figure 6-93 SUMIFS to calculate number by color and size
   8. Click OK. The result is 7.
   9. Copy the formula in cell M13 to cells M14:M21.
7. Click the Satisfaction Survey worksheet tab and review the data.
8. Select cells A4:H40 and name the range as Survey. Note that the “Comfort” field is the fifth column and that the other attributes follow in the sixth, seventh, and eighth columns.
9. Use DAVERAGE to summarize customer survey data.
   1. Click the Criteria sheet tab.
   2. Select cell B2 and type rug*, criteria for the Rugged Hiking Boots.
   3. Click the Average Ratings worksheet tab and select cell C5.
   4. Click the Insert Function button [Formulas tab, Function Library group].
   5. Choose Database in the Or select a category list.
   6. Select DAVERAGE and click OK to calculate an average comfort rating for the boots.
   7. Press F3 (FN+F3), choose Survey for the Database argument, and click OK.
   8. Click the Field box and select cell C4.
   9. Click the Criteria box, select the Criteria sheet tab, select cells B1:B2, and make the references absolute (Figure 6-94).Figure 6-94 DAVERAGE for comfort rating
   10. Click OK. The result is 7.75.
   11. Copy the formula in cell C5 to cells D5:F5.
10. Use DAVERAGE to summarize survey data.
    1. Select the Criteria sheet tab and select cell B5. Type the criteria as shown here for the shoe styles.The table lists the criteria to be entered on the Criteria sheet.CellCriteriaB5com*B8laz*B11ser*B14gli*
    2. Click the Average Ratings sheet tab and select cell C6.
    3. Click the Recently Used button [Formulas tab, Function Library group] and select DAVERAGE.
    4. Press F3 (FN+F3) and choose Survey for the Database argument.
    5. Click the Field argument box and select cell C4.
    6. Click the Criteria box, select cells B4:B5 on the Criteria sheet, and press F4 (FN+F4).
    7. Click OK. The result is 7.5.
    8. Copy the formula in cell C6 to cells D6:F6.
11. Build DAVERAGE functions for the remaining shoe styles on the Average Ratings sheet.
12. Select cells G5:G9 on the Average Ratings sheet, click the AutoSum arrow [Home tab, Editing group], and choose Average.
13. Create an IFS function.Note: If your version of Excel does not include the IFS function, build the following nested IF function =IF(G5>=9,$J$5,IF(G5>=8,$J$6,IF(G5>=5,$J$7,$J$8))) to show the ratings.
    1. Select cell H5, click the Logical button [Formulas tab, Function Library group], and choose IFS.
    2. Click the Logical_test1 argument, select cell G5, and type >=9.
    3. Click the Value_if_true1 box, click cell J5, and press F4 (FN+F4) to make the reference absolute.
    4. Click the Logical_test2 box, click cell G5, and type >=8.
    5. Click the Value_if_true2 box, click cell J6, and press F4 (FN+F4).
    6. Click the Logical_test3 box, click cell G5, and type >=5.
    7. Click the down scroll arrow to reveal the Value_if_true3 box, click cell J7, and press F4 (FN+F4).
    8. Click the down scroll arrow to reveal the Logical_test4 box, click cell G5, and type <5.
    9. Click the down scroll arrow to reveal the Value_if_true4 box, click cell J8, and press F4 (FN+F4) (Figure 6-95). The complete formula is:=IFS(G5>=9,$J$5,G5>=8,$J$6,G5>=5,$J$7,G5<5,$J$8)Figure 6-95 IFS function with multiple logical tests
    10. Click OK and copy the formula to cells H6:H9.
    11. Format column H to be 13.57 (100 pixels) wide.
14. Calculate depreciation for an asset using a Financial function.
    1. Click the Depreciation sheet tab and select cell C11. Depreciation is the decrease in the value of an asset as it ages. The DB function calculates the loss in value over a specified period of time at a fixed rate.
    2. Click the Financial button [Formulas tab, Function Library group] and choose DB.
    3. Select cell C6 for the Cost argument, and press F4 (FN+F4) to make the reference absolute. This is the initial cost of the equipment.
    4. Click the Salvage box, select cell C7, and press F4 (FN+F4). This is the expected value of the equipment at the end of its life.
    5. Click the Life box, select cell C8, and press F4 (FN+F4). This is how long the equipment is expected to last.
    6. Click the Period box and select cell B11. The first formula calculates depreciation for the first year (Figure 6-96).Figure 6-96 DB function to calculate asset depreciation
    7. Click OK. The first year depreciation is $39,900.00.
    8. Copy the formula in cell C11 to cells C12:C18. Each year’s depreciation is less than the previous year’s.
    9. Select cell C19 and use AutoSum. The total depreciation plus the salvage value is approximately equal to the original cost. It is not exact due to rounding.
15. Use CONCAT to build an email address. (If your version of Excel does not include CONCAT, use CONCATENATE.)
    1. Right-click any worksheet tab, choose Unhide, select E-Mail, and click OK.
    2. Select cell C5, type =con, and press Tab. The text1 argument is first.
    3. Select cell A5 and type a comma (,) to move to the text2 argument.
    4. Select cell B5 and type a comma (,) to move to the text3 argument.
    5. Type “@weshoes.org” including the quotation marks (Figure 6-97).Figure 6-97 CONCAT references and typed data
    6. Type the closing parenthesis ()) and press Enter.
    7. Copy the formula in cell C5 to cells C6:C8.
16. Save and close the workbook (Figure 6-98).

1. Why are large-scale disasters of particular concern when choosing off-site storage locations for data backups and equipment?

2. What are the primary goals associated with the recovery phase? restoration phase?

I have the introduction part of the Mobile Spyware essay, and I want to write the 3-page literature study section of the essay (where it shows the impact of the Mobile Spyware technology on the security of organizations and society) as it must include:

I. Positive impact (technology readiness and technology development)

II. Negative impact (risks, attacks, and vulnerabilities)

It also needs to have 4 APA citations/resources (in the last 3 years only)

Over the past decades, advances in technology for data storage has rapidly evolved from paper tape to magnetic storage to optical discs and beyond. Identify and research a recent advancement in temporary or permanent data storage. Identify the need that this device is designed to address and explain how integration of this innovation might affect the operating system’s hardware or software. Cite your academic sources.

Excel Chapter 3 Mid-Level 1 – Airports 

Exp19_Excel_Ch03_ML1_Airports

Exp19 Excel Ch03 ML1 Airports

Project Description:

As an analyst for the airline industry, you track the number of passengers at the top six major U.S. airports: Atlanta (ATL), Chicago (ORD), Los Angeles (LAX), Dallas/Fort Worth (DFW), Denver (DEN), and New York (JFK). You researched passenger data and created a worksheet that lists the number of total yearly passengers at the top six airports. To prepare for an upcoming meeting, you will create a clustered column chart to compare the number of passengers at each airport. Then, you will create a line chart that compares trends over time. Next, you will create a bar chart to compare the passenger count for the latest year of data available and then emphasize the airport with the largest number of passenger traffic. Finally, you want to insert sparklines to visually represent trends in passengers at each airport over the 10-year period.

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

You want to create a   clustered column chart to depict the passenger counts at the six airports   over several years.
  Use Quick Analysis to create a clustered column chart for the range A4:L10.   Cut the chart and paste it in cell A15.

You want to customize   the column chart with a chart title, display the years as a data series,   enlarge the chart to be easier to read, and apply a chart style.
  •Type Passengers by Top U.S. Airports as the chart title.
  •Swap the data on the category axis and in the legend.
  •Set a 3.5″ height and 11.4″ width.
  •Apply the Style 7 chart style.

The value axis takes   up a lot of space for the numbers. You will adjust the value axis to simplify   it.
  •Change the display units to Millions for the value axis.
  •Edit the axis title to display Millions of Passengers.

You want to focus on   the 2016 data series by adding data labels.
  Display data labels above the columns for the 2016 data series only.

Applying a fill color   to the chart area will make the chart visually appealing.
  Apply the Light Gradient – Accent 2 preset gradient fill to the chart area.

A best practice is to   add Alt Text to a chart for accessibility compliance.
  Add Alt Text: The chart displays the number of passengers in millions   for the top six airports from 2006 to 2016. (including the period).

When you change the   workbook theme, Excel applies that theme to the chart styles.
  Change the workbook theme to Slice.

You want to create a   bar chart to display passenger counts for only one year.
  Create a recommended clustered bar chart for the range A5:A10 and L5:L10 and move   the chart to a chart sheet named Bar Chart.

You want to customize   the bar chart.
  •Change the chart color to Colorful Palette 3.
  •Enter Passengers at Top 6 U.S. Airports in 2016 as the chart title.
  •Apply the Style 5 chart style.
  •Add Alt Text: The bar chart shows passengers at Top 6 U.S.   Airports in 2016. Atlanta had the most passengers. (including the   period).

Modifying the axes   will improve readability of the bar chart.
  •Change the font size to 10 for the category axis and value axis.
  •Change the value axis Maximum Bound to 1.1E8.

You will format a   data point so that it stands out and then add gridlines to enhance   readability in the bar chart.
  •Format the Atlanta data point with Dark Blue, Text 2 fill color.
  •Add Primary Minor Vertical gridlines.

A line chart   effectively shows trends over time for the passenger counts at the different   airports.
  Create a line chart using the range A4:L10 in the Passenger worksheet and   move the chart to a chart sheet named Line Chart. Add a chart title   Passengers at U.S. Airports 2006-2016 and bold the title.

You want to customize   the line chart.
  •Set the Minimum Bound at 4.0E7 for the value axis. The Maximum   Bound should change to 1.1E8 automatically.
  •Set the Vertical (Value) Axis Display units to Millions. Delete the Vertical   (Value) Axis Display Units Label from the upper-left corner of the chart. Add   a value axis title In Millions.
  •Change the font size to 10 for the value axis and category axis.
  •Move the legend to the top.
  •Filter the chart by deselecting the odd-numbered years.
  •Add Alt Text: The line chart displays trends for top six   U.S. airports from 2006 to 2016 at two-year intervals. (including the   period).

Sparklines provide a   simple visualization to represent data in a worksheet.
  Display the Passenger worksheet and insert Line sparklines in the range   M5:M10 to illustrate the data in the range B5:L10.

You want to customize   the sparklines to point out high and low points.
  •Show the high and low points in each sparkline.
  •Apply Black, Text 1 color to the high point marker in each sparkline
 

On the Questions   worksheet, type the answer to the first question in cell A2. Enter only the   airport code.
  Answer the other questions by typing in the answers in cells A3, A4, A5, and   A6.

Group the Bar Chart   and Line Chart sheets and insert a footer with Exploring Series on the left side, the   sheet name code in the center, and the file name code on the right on all   worksheets. Group the Passenger and Questions sheets and insert a footer with   the same data. Change to Normal view.

Set page formats for   the Passenger worksheet.
  Select Legal paper size, select Landscape orientation, set 0.3″ left and right   margins, and scale to fit 1 page.

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

1. What is Big Data? Why is it important? Where does Big Data come from?

2. What do you think the future of Big Data will be? Will it lose its popularity to something else? If so, what will it be?

3. What is Big Data analytics? How does it differ from regular analytics?

4. What are the critical success factors for Big Data analytics?

5. What are the big challenges that one should be mindful of when considering implementation of Big Data analytics?

6. At teradatauniversitynetwork.com, go to the Sports Analytics page. Find applications of Big Data in sports. Summarize your findings