As a security specialist, you must choose the best form of encryption to protect the spreadsheet. Which form of encryption would ensure the spreadsheet is always stored on the disk in encrypted format? More than one form may be correct. Your choices are:

• BitLocker
• BitLocker To Go
• File encryption via Encrypting File System (EFS)
• Folder encryption via EFS

  Develop an Apache Spark application per provided specifications and Crunchbase Open Data Map organizations dataset download, using PySpark in Google Colab.

Details

Use the Week 11 Class Exercise downloads a reference:

• Create a new notebook in Google Colab
• Download Crunchbase ODM Orgs CSV download file and upload it to the “Files” section in your Colab notebook (may take a few minutes to upload)
• Read the Crunchbase Orgs dataset into Spark DataFrame

Implement PySpark code using DataFrames, RDDs or Spark UDF functions:

1. Find all entities with the name that starts with a letter “F” (e.g. Facebook, etc.):
   • print the count and show() the resulting Spark DataFrame
2. Find all entities located in New York City:
   • print the count and show() the resulting Spark DataFrame
3. Add a “Blog” column to the DataFrame with the row entries set to 1 if the “domain” field contains “blogspot.com”, and 0 otherwise.
   • show() only the records with the “Blog” field marked as 1
4. Find all entities with names that are palindromes (name reads the same way forward and reverse, e.g. madam):
   • print the count and show() the resulting Spark DataFrame 

 YO19_IntegratedProject_1_LaundryProposal 1.1

YO19_IntegratedProject_1_LaundryProposal 1.1

Project Description:

As a student at the university, you have an entrepreneurial spirit and have dreamed of starting your own business. You have noticed that the coin laundry in your dorm is always full and crowded. You saw an opportunity to start a business that picks up laundry at the dorms, launders the clothes, folds the clothes, and returns the laundry in a single day. The first step to starting this business is to create a proposal for the university to approve the service to have some operations within the dorms. You started by conducting a survey of your fellow students. The next step is to process the survey results and create a proposal for the university.

Steps to Perform:

Step

Instructions

Points    Possible

1

Start   Word. Download and open the file named IntegratedProject_1   – LaundryUProposal.docx. Grader has automatically added your last name to   the beginning of the filename. Click Enable Editing, if necessary.

0

2

Branding is always important both internally and   externally. Images and logos can help you brand.
 

  Press CTRL+HOME to place the cursor at the beginning of the document. insert   the image LaundryULogo.jpg. Change   the width of the image to 1.5 inches. Change the layout to In Front of Text   and then align the image Right relative to the margin.
  Hint: On the Picture Format tab, use the tools in the Arrange group and the   Size group to format the picture.

4

3

Change   the document theme to Feathered and the theme colors to Blue Warm. Change the   margins to Narrow.
 

  If the theme is not available, click Browse for Themes, and then select the   downloaded theme file Feathered.thmx.

2.4

4

Spelling mistakes are unprofessional as they make   the author appear to be unable to spell properly.
 

  Check the spelling to correct all spelling errors. LaundryU is the name of the business and is spelled correctly.

2

5

Styles   help you format even if you are not very good with design.
 

  Set the style for the first three lines in the document to Heading 1.
  On the sixth line down change the salutation of Dear Director, to a style of Heading 2. Change the line that   reads We did a survey of 100 students   in the dorm and found: style to be Heading 2.

4

6

A name should look like a signature.
 

  On the next to last line, change the font of Matthew Thomas to Lucida Handwriting.

0.8

7

Open   the downloaded LaundryUSurvey.xlsx   file. On the Q1 worksheet, in cell E2, enter a function that calculates how   many students answered yes to the survey using the data in cell B2:B101.
  Hint: You will be using the COUNTIF Function. See Excel Chapter 2: Activity   2.08

2

8

On the Q1 worksheet, in cell E3, enter a function   that calculates how many students answered no to the survey using the data in   cell B2:B101.

2

9

Using   the data in cells D2:E3, insert a 3-D Pie Chart. Change the chart title to Interested in   LaundryU Service?   Change the chart style to Style 3.

4

10

Select the chart and copy it. Display the IntegratedProject_1 –   LaundryUProposal.docx file, and be sure your insertion point is   positioned on the line underneath Would   you be interested in a laundry service that picks up and delivers to your   dorm? On the Home tab, in the Clipboard group, click the Paste arrow, and   then under Paste Options, click Use Destination Theme & Link Data.

4

11

In the IntegratedProject_1 –   LaundryUProposal.docx file, center the chart. Set the width of the chart   to 4 inches and the height to 2 inches. Change the font size of the chart   title to 12.

2.4

12

When looking at results of this survey, it is   important to look at more than just the average price the students are   willing to pay to get an idea of distribution of the results. Considering   just an average in a decision could lead to erroneous or poor decisions.
 

  Display LaundryUSurvey.xlsx. On the   Q2 worksheet using the data in cells B2:B40, calculate the following:
  In cell F2 calculate the average price students were willing to pay.
  In cell F3 calculate the standard deviation of the sample.
  In cell F4 calculate the sample size.
  In cell H3 calculate the minimum price students were willing to pay.
  In cell H4 calculate the maximum price students were willing to pay.
  Hint:
  For Standard Deviation, use the STDEV.S Function
  For the Sample Size, use the COUNTA Function

6

13

On the   Q2 worksheet, format cells F2, F3, H3, and H4 to Accounting. Format cell F2   to bold. Set the fill color for cells F2:H4 to White, Background 1.

2.4

14

Select cells   E2:H4 and copy the range. Display the IntegratedProject_1   – LaundryUProposal.docx file, and be sure your insertion point is   positioned on the line underneath If   yes, how much would you be willing to pay per bag (approximately 1 load of   laundry)? On the Home tab, in the Clipboard group, click the Paste arrow,   and then click Paste Special. In the Paste Special dialog box under As, click   Microsoft Excel Worksheet Object. Then, click OK. Center the embedded Excel   Worksheet Object.

4

15

Save   and Exit Excel. Save and close IntegratedProject_1   – LaundryUProposal.docx. Exit Word. Submit your Word file as directed.

0

Total   Points

40

refer to the attached document for details

The readings this week expand on investigation and of digital forensic analysis and investigations. Organizations, especially those in the public, health and educational areas are bound by legal and statutory requirements to protect data and private information, therefore digital forensics analysis will be very beneficial when security breaches do occur. Using this weeks readings and your own research, discuss digital forensics and how it could be used in a risk management program.

Please make your initial post and two response posts substantive. A substantive post will do at least TWO of the following:

• Ask an interesting, thoughtful question pertaining to the topic
• Answer a question (in detail) posted by another student or the instructor
• Provide extensive additional information on the topic
• Explain, define, or analyze the topic in detail
• Share an applicable personal experience
• Provide an outside source (for example, an article from the UC Library) that applies to the topic, along with additional information about the topic or the source (please cite properly in APA 7)
• Make an argument concerning the topic.

At least one scholarly source should be used in the initial discussion thread. Be sure to use information from your readings and other sources from the UC Library. Use proper citations and references in your post.

 This project is divided into several parts, each with a deliverable. The first four parts are drafts. These documents should resemble business reports in that they are organized by headings, include source citations (if any), be readable, and be free from typos and grammatical errors. However, they are not final, polished reports.Please see attached.

Project Part 2: Risk Assessment Plan

After creating an initial draft of the risk management plan, the next step is to create a draft of the risk assessment plan.For this part of the project:

1. Research risk assessment approaches.
2. Create an outline for a basic qualitative risk assessment plan.
3. Write an introduction to the plan explaining its purpose and importance.
4. Define the scope and boundaries for the risk assessment.
5. Identify data center assets and activities to be assessed.
6. Identify relevant threats and vulnerabilities. Include those listed in the scenario and add to the list if needed.
7. Identify relevant types of controls to be assessed.
8. Identify the key roles and responsibilities of individuals and departments within the organization as they pertain to risk assessments.
9. Develop a proposed schedule for the risk assessment process.
10. Complete the draft risk assessment plan detailing the information above. Risk assessment plans often include tables, but you choose the best format to present the material. Format the bulk of the plan similar to a professional business report and cite any sources you used.

Submission Requirements

• Format: Microsoft Word (or compatible)
• Font: Arial, size 12, double-space
• Citation style: Your school’s preferred style guide
• Estimated length: 4–6 pages

Homework Content

So far, we have been looking at Computer Architecture from a very high level…and hopefully, you are starting to look at your laptops and cell phones in terms that you were not before this class… We also discussed that every computer design is optimized with performance in mind so the question now is…just how good (or bad) is MY laptop compared against some performance benchmarks…

See the website below:
https://www.passmark.com/products/pt.htm

This site has free benchmarking software that you can download and run against your computer…download the software and let it run against your system…run both the Standard AND the Advanced Test…
NOTE: THE ABOVE LINK IS FOR WINDOWS TESTING…PLEASE SEE THE FOLLOWING WEBSITES FOR SOME PERFORMANCE TESTING SOFTWARE FOR THE MAC…IF YOU ARE A MAC USER AND ALREADY HAVE A PERFORMANCE MEASURE SOFTWARE, YOU MAY USE IT…
https://browser.geekbench.com/mac-benchmarks
https://www.macworld.co.uk/how-to/mac/test-mac-speed-3654776/

So how did your system do?…what was your overall score and percentile?…what are the scores telling you?…were you surprised by the results?…do the benchmarks provided sync up with how you feel your system is performing?…provide some screen shots of the results…what takeaways do you have from this test?…any follow-ups?…how can you improve the performance of your laptop?…do you use any other performance testing software?…if so, which ones?…how do the results compare?…provide screen shots of the other performance monitoring software…

Keep your results handy…we will refer to them throughout the semester…

As I mentioned, I am more concerned with QUALITY than I am with QUANTITY…but just as a guideline, you should submit at least ONE FULL PAGES OF WRITTEN CONTENT…meaning that screen shots (and this assignment has many), title page, source listing, etc. do NOT count as part of the one page…

Plagiarism is not allowed and I will give you an automatic zero if I discover that any part of your work was plagiarized either from the internet or another student’s paper.

From the humdrum of the mid-2000s web apps, Apple radically changed the mobile world with the iPhone, offering well-designed apps of their own and curating apps that were accepted into the App Store.  That influence has been far reaching, prompting Google to push their boundaries and develop material design, a design language that has become the distinctive hallmark of Android apps.  When compared to the web world where some popular apps could get away with mediocre design, why do mobile apps face a higher design bar? 

• When compared to the web world where some popular apps could get away with mediocre design, why do mobile apps face a higher design bar?
• Compare and contrast native mobile app design versus standard desktop app design.  Discuss considerations for choosing one over the other.  Elaborate on main advantages vs disadvantages.

Question 2 : Creating an Example Web Service. Page 42 Chapter 3.
Chapter 3
For submission : Read carefully “Using the Microsoft Stack” and “Using the Linux Apache MySQL PHP (LAMP) Stack” or 2 different approaches for creating a web service. Then
(a) compare the two approaches and
(b) explain 2 advantages of each approach relative to the other.

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.

Conduct an Internet search on Internet marketing. Identify major types of Internet marketing strategies that are widely used and their relative effectiveness. Also, identify the major trends that may be observed for Internet marketing. Which trend, in your opinion, is likely to be most effective today?