How is probability theory used in computer science?  Find at least one example and explain it.

Focus on clear thoughtful words

500 words

Assignment Content

1. At this point, you have found a research article exploring your approved research question and you have learned how to find your 6 ‘ingredients’ during class .

   For this assignment:  You will use your research article from Week 4’s HW to write your first objective summary. 
   Requirements:

   • 15 pts, Cover/Title Page 
   • 70 pts, Objective Summary: W(5) H(1) — YOU MUST PUT THIS IN YOUR OWN WORDS 
   • 15 pts, References Page (you will only have one reference listed — the research article you are using.) 
   • Resources to help you:
   • Re-watch the class recording
   • See pp. 17-22 to read about objective summaries
   • See pp. 23-28 to read more about avoiding plagiarism

refer to the attached document

#Exp19_Excel_Ch12_Cap_Bulldog_Collectibles

 #Exp19_Excel_Ch12_Cap_Inventory 

Project Description:

You are the operations manager for Bulldog collectables, a small  start-up company that deals with sports memorabilia. As you prepare to  document your inventory, you decide to utilize a template to save time.  To complete this task, you will create a worksheet based on an  Office.com template; you will also use the Macro Recorder and Visual  Basic for Application to automate sorting and calculations within the  workbook.

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

Delete the Inventory Pick List   and Bin Lookup worksheets.

Delete the INVENTORY PICK LIST   and BIN LOOKUP icons located  respectively in cells E2 and F2. Then Clear all   existing Data  Validation in the range A1:K15.

Delete the values in the range   B5:J15.

Record a macro named Sort, be sure to use relative    references. Ensure the macro sorts the data in the table in ascending  order   based on SKU (column A). Stop the Macro Recorder and Save the  workbook as a   Macro-Enabled Template.

Create a form control button   that spans the cell E2:E3. Assign the Sort macro and edit the button text to Sort.

Use the VBA Editor to create a   new module.
 

  Type the following VBA code to create a custom Inventory Value  function then   save and exit the VBA Editor (be sure to leave a blank  line between each line   and before End Function):
 

Function   InventoryValue (QTY, COST)
 

InventoryValue   = QTY * COST
 

Click cell J5 and use the newly   created InventoryValue function to  calculate the value of the inventory for   each item in column I.

Use the VBA Editor to create a   new module named ProtectWorkbook. Type the following VBA statements to create the   sub procedure (leave appropriate line spacing).
 

Sub   ProtectWorkbook()
 

‘Protect   workbook using the password eXploring
Worksheets(“Inventory   List”).Protect Password:=”eXploring”

Insert a new module named UnprotectWorkbook. Type  the following VBA   statements to create the sub procedure and then save  and exit the VBA Editor   (leave appropriate line spacing).
 

Sub   UnprotectWorkbook()
 

‘Unprotect   workbook using the password eXploring
Worksheets(“Inventory   List”).Unprotect Password:=”eXploring”

Insert a Form Control Button   spanning cells F2:F3 named Unprotect. Assign the UnprotectWorkbook macro to the newly   created Control Button.

Insert a Form Control Button   spanning the range G2:H3 named Protect. Assign the macro ProtectWorkbook.

Insert the comment Inventory   based on values in column J. in cell B3 (include the period).

Insert the comment Count of   items in column C.   in cell C3 (include the period).

Inspect the document for private   information and hidden properties.  Save the file when prompted then remove   Document Properties and  Personal Information, and Headers and Footers.
 

  Note: Mac users, from the Excel menu, open your preferences, click  Security,   and then click the check box to Remove personal information  from this file on   save. Delete any headers or footers in the workbook.

Check the document for   accessibility issues. Use the Accessibility  Checker pane to change the cell   styles to Normal in order to repair  the issue.

Check the document for   compatibility with Excel 2010, 2013, and 2016.
 

  Note: Mac users, skip this step.

Insert a new worksheet named Code.

Open the VBA Editor, open Module   1, and copy the code. Paste the code in the Code worksheet starting in cell   A1. 

In the VBA Editor, open Module   2, and copy the code. Paste the code in the Code worksheet starting in cell   A22. 

In the VBA Editor, open the   ProtectWorkbook, and copy the code. Paste the code in the Code worksheet   starting in cell A28. 

In the VBA Editor, open the   UnprotectWorkbook module, and copy the  code. Paste the code in the Code   worksheet starting in cell A35. 

Close the VBA Editor and save   the workbook as an xlsx file (not Macro-Enabled).

Close EXP19_Excel_Ch12_CAP_Inventory.xlsx. Exit Excel. Submit the file   as directed.

Excel_10G_Applewood_School

Project Description:

In the following Project, you will import data about school classroom suppliers. You will edit a worksheet detailing the current inventory of two supply types—K-12 classroom supplies and preschool classroom supplies. You will use the DAVERAGE, the DSUM, and the MAXIFS functions and add alt text to an image.

Open the file Excel_10G_Applewood_School.xlsx   downloaded with this project.

Be sure the Classroom Suppliers   Info worksheet is active. Click cell A2. From the Data tab, click Get Data,   and then locate and click the command to get data From Microsoft Access   Database. In the Import Data dialog box, navigate to the files downloaded   with this Project. Click the Access file e10G_Applewood_School_Suppliers.accdb,   and then click Import. Select the 10G School Suppliers table, and then use   the Load To command to import the data into the Existing worksheet. Close the   Queries & Connections pane.
 

  Mac users: Use the file e10G_Applewood_School_Suppliers_CSV_for_Mac_users.csv,   select the imported data, and on the Insert tab, click Table. Apply Table   Style, Medium 7.

Display the Teaching Staff   worksheet. In cell B18, insert a DAVERAGE function using the range A3:F16 as   the database, that calculates the average Hourly Wage for teachers and using the   criteria in the range C18:C19. Apply Accounting Number Format to your result   in cell B18.

In cell B21, insert a DSUM   function using the range A3:F16 as the database, that calculates the Wage per   Shift for   preschool assistants using the criteria in cells C21:D22. Apply Accounting   Number Format to your result in cell B21.

In cell E18 type Maximum   Teacher Hourly Wage   and then use Format Painter to copy the format from cell C18 to cell E18.   Widen column E to 75 pixels. Use AutoFit if necessary.

In cell E19, begin the MAXIFS   function by typing =maxifs( and then as the max range, select the range representing the Hourly Wage of the Teaching Staff.   Type a comma, and then as the criteria range, select the range representing   the Status of the Staff. Type a   comma, and then as the criteria, click cell C19. Press ENTER. Apply   Accounting Number Format to your result.

Display the Classroom Supplies   Inventory worksheet. Insert a table in the range A7:E19.

Display the Preschool worksheet   and copy the range A1:E11. Display the Classroom Supplies Inventory   worksheet, and then paste the data into cell F6.

Insert a table in the range   F7:J16 and apply Table Style Medium 7. Apply AutoFit to columns H:I.

Sort both tables by Supplier A   to Z and then by Purchase Price Largest to Smallest.

Apply conditional formatting to   the range E8:E19 using the 3 Traffic Lights (Rimmed) icon set.

Apply the same conditional   formatting to the range J8:J16.

In the range C8:C19 create a new   conditional formatting rule using the formula =c8=”Labels” and setting the format to Bold   Italic with the Red font color.

Delete the Preschool worksheet.

Check the workbook for   Accessibility. On the Early Learning worksheet, with the image selected, add   the following alt text: Early Learning website Close the Accessibility panes.

Group the four worksheets. From   Page Layout view, insert a header in the right section that displays the   Sheet Name. Go to the footer, and then insert the File Name in the left   section of the footer. Return to Normal view. Press CTRL+HOME to make cell A1   the active cell.

Center the sheets horizontally   on the page. Set the Orientation to Landscape. Set the Width to 1 page and   the Height to 1 page.

Display the document properties.   As the Tags/Keywords, type classroom supplies In the Subject box, type your course name and   section number.

On the left, click Print to   display the Print Preview. Scroll through the four worksheets. On the left,   click Save to save your workbook and return to the workbook window. 

Close the file and exit Excel.   Submit your file for grading.

Need help with my section of the paper. I attached the case study and copy of the paper. Please answer A and B with reference please. I need within 12 hours.

A. Different IT Solution:

• Describe the solution 
• Describe the major benefits and the extent to which it solves the problems identified in Section II 
• Identify the major cost elements and provide an estimated cost for the solution 
• Discuss the general feasibility of the solution – whether or not it is feasible and the reasoning behind the statements 
• Identify the top three risks (organizational, financial, IT, etc.) 
• Describe the major defining issues – things that would make it a less desirable solution than the proposed solution, or, in the case of the proposed solution, why it is the best alternative in general. 

B. Process Change 

• Describe the solution 
• Describe the major benefits and the extent to which it solves the problems identified in Section II 
• Identify the major cost elements and provide an estimated cost for the solution 
• Discuss the general feasibility of the solution – whether or not it is feasible and the reasoning behind the statements 
• Identify the top three risks (organizational, financial, IT, etc.) 
• Describe the major defining issues – things that would make it a less desirable solution than the proposed solution, or, in the case of the proposed solution, why it is the best alternative in general. 

cssssssssssss and IT

Look at the picture for guidelines, my topic is network security and VPN’s. Must be passable by TurnItIn.

download the attachment and contact user

In this week’s discussion, you were introduced to Wireshark and GlassWire, two free network monitor & security tools. Compare and contrast these two tools. explaining the benefits and features of each, then decide which of these two choices you would prefer to use if you were the Network Manager. Explain why you made your decision.

https://www.glasswire.com/

https://www.wireshark.org/