Assignment Objectives:  Describe how to ensure security to data in motion, data in use, and data at rest.

Assignment Directions: In a word document, discuss the assigned topic in approximately ten sentences.  

Exp19_Excel_Ch02_ML2_SmartPhone

Excel Chapter 2 Mid-Level 2 – SmartPhone 

Exp19 Excel Ch02 ML2 SmartPhone

Project Description:

You have just graduated from college and before beginning your first professional job, you would like to purchase a new smartphone. You have the option to purchase the new phone in one payment or make monthly payments by taking advantage of a 36 month flex payment plan. The payment plan charges an APR of 1.75% for the service. Prior to making your payment decision, you would like to make a worksheet to calculate the monthly payment for consumer reports top three smartphones for young professionals.

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

Rename Sheet 1 FlexPay.
  Hint: Double-click the sheet name tab to rename the worksheet.

Type Flex   Pay Calculator in cell A1, and then merge and center the title on the first row   in the range A1:C1. Apply bold, 20 pt font size, Blue, Accent 1, font color.

Merge and center the   range A2:C2, type Inputs, and apply Thick   Outside Borders. Note, Mac users, apply Thick Box Border.

Type APR and #   of payments   in the range A3:A4.

Type 1.75% in cell B3 and 36 in cell B4. Merge   and center the range A6:C6, type Outputs, and apply Thick Outside   Borders.

Type Model in cell A7, Price   in   cell B7, and Payment in cell C7. 

Type iphone   x in   cell A8, Samsung Galaxy in cell A9, and LG   V30   in cell A10. Enter the corresponding prices 949, 799, and 650 in the range B8:B10 and apply Currency Number   Format. Resize column A as needed to display all text.

In cell C8, enter a   PMT function to calculate the monthly flex payment for the first option. Be   sure to use the appropriate absolute, relative, or mixed cell references. Use   the fill handle to copy the function down through cell C10. Make sure each of   the monthly flex payments is a positive value.

Type Highest   payment,   Average payment, and Lowest payment in the range A12:A14.

In cell B12, use the   MAX function to calculate the highest flex payment, in cell B13, use the   AVERAGE function to calculate the average flex payment, and in cell B14, use   the MIN function to calculate the lowest flex payment. 

Insert a footer with   your name on the left side, the sheet name in the center, and the file name   code on the right side of the worksheet.

Save the workbook.   Close the workbook and then exit Excel. Submit the workbook as directed.

 Related Diversification. Related Diversification is the most popular distinction between the different types of diversification and is made with regard to how close the field of diversification is to the field of the existing business activities. Related Diversification occurs when a company adds to or expands its existing line of production or markets. For this assignment, consider your own company or one that you know well. Assume your company opted to pursue a strategy of related diversification and respond to the following questions. 

• What industries or product categories could it diversify into that would allow it to achieve economies of scale?
• Identify at least two or three such industries or product categories?
• Describe the specific kinds of cost savings that might accrue from entry into each?

please experts only

 COMPLETE THE FOLLOWING paper:

Compare and contrast software testing methods. How would these testing methods apply to an autonomous [self-driving] vehicle?

Upload by noon, Friday 6/18/21.

Follow the APA writing guide, limit your paper to five pages – not including cover, abstract, and bibliography. Please do not use any paraphrasing software, and be sure to include references. 

Do the following assignment. please check the attach document.

 Temperature-Conversion ProgramDevelop a Python program to

• Ask the user whether to convert from celsius to fahrenheit or from fahrenheit to  celsius 
• If the user enters  celsius to fahrenheit, then
  • Ask the user to enter a value for  celsius
  • Use the following formula to convert from  celsius to fahrenheit:
    • Fahrenheit = 9.0 / 5.0 x Celsius +  32
  • Display the entered value for  celsius and the calculated value for fahrenheit, along with appropriate messages
    • See the attached sample program run output to see how data is displayed
• If the user enters  fahrenheit  to celsius , then
  • Ask the user to enter a value for  fahrenheit
  • Use the following formula to convert from   fahrenheit  to celsius:
    • Celsius = (Fahrenheit − 32) x  5.0 / 9.0
  • Display the entered value for fahrenheit  and the calculated value for celsius, along with appropriate messages.
    • See the attached sample program run output to see how data is displayed.
• If neither fahrenheit to celsius  nor  celsius  to  fahrenheit  is entered, then
  • Display an error message, such as “Illegal input data was entered.”

 NOTE: When setting up the above formulas, ensure to use the right Python operators! 

 You need to set up a  Python solution that is  complete and  workable.  

For your solution to be  complete, you must

• Prompt the user for the specific input data asked for within the problem statement
• Set up a correct formula to process the input data, arriving at the output data
• Provide the output data asked for within the problem statement to the user

For your solution to be  workable,

• Your solution should be free of any type of errors (syntax, run-time, logic)
• You may want to develop an algorithm first, using pseudocode or flowchart
• You do NOT need to turn in any algorithm

================================================================================Grading rubric:

• You’ll receive full credit, if 
  • your program
    • compiles and runs with no problems 
    • produces the expected output
• You’ll receive partial credit, if 
  • your program
    • compiles and runs with no problems 
    • produces partial output (that is, incomplete output)
• You’ll receive 25% of the points, if your program will not compile
• You’ll receive 30% of the points, if your program compiles but has a run-time problem
• You’ll receive 40% of the points, if your program produces logic error(s)

Discussion:

Describe and discuss the use of at least five  applications of WEB-GL in the real-world.

• Describe how you would build a PC. Identify the parts used to build  the PC and their alignment to the PC’s primary use. Be specific with  details for each component. What component would you invest in the most?  Explain why.

CPU:

CPU is the brain of the computer. The CPU mainly processes the data  by the user’s input. Without the CPU, the computer will not be able to  “compute.”

Motherboard:

The motherboard is like a host for the computer component; it carries  all the different features and helps them communicate. The motherboard  is the component that puts everything together and cooperates.

RAM:

RAM, also as known as Random Access Memory, is like the scratch paper  for the CPU. The RAM store the temporary data that the CPU need for  processing.

Storage:

Storage can be removable or fixed storage devices—an example of the  removable optical disk USB drive. The fixed storage device will be HDD  or SDD. Regardless of which device, they all perform the same task; they  store information even when the power is off.

Graphing Card

The graphing card is sometimes also called a video card. This  component will significantly increase the computer’s graphing  calculation performance. In other words, installing an additional  graphing card will help the computer output better quality display and  more complex graphs calculation.

Power Supply:

The power supply provides the electricity the component needs to  function and converts the AC power to DC power for the most part  required. The power supply is also the most dangerous component in the  computer, and it can potentially hold an electrical charge and be  harmful. 

Computer Case:

The computer case is the house of the computer component. Besides  providing the fixture for the components, it also helps the airflow keep  the part cool.

Keyboard and Mouse:

The keyboard and mouse are the most critical input devices, allowing the user to input data into the computer. 

Monitor:

The monitor is the most crucial output device. A computer without a  monitor is very difficult to let the computer put out the processed data  to the user.

Operating System:

The operating system is like a platform to utilize all components and  make them work together to output data. The operating system is also a  bridge that connects the user and the computer, turning the 0 and 1 in  the data the user can understand. 

For my computer build, I will spend most of my budget on the CPU,  Mother Board, and Graphing Card, the three main components. My computer  mainly uses CAD and simulation, and the software requires much more  computing power than office software. I don’t need a huge storage room  because most time, I use the cloud to back up my data. 

Write a python or perl program that generates the inverted 

index of a set of already preprocessed files. The files are stored in a 

directory which is given as an input parameter to the program. Use the files

preprocessed in the previous assignment(s) as test data. Use raw term 

frequency (tf) in the document without normalizing it. Think about saving the generated index, including the document frequency (df), in a file so that you can retrieve it later.

 When investigating an alibi, the key things you need to focus on are the time and location of the user, based on the computing devices used in the commission of the crime.  Discuss how you can use the chain of custody to preserve evidence.