COMPUTER

 

Complete the assignment below using Microsoft Excel.

You have been hired by an engineering firm needing a senior level data analyst. Upon accepting this position, your supervisor has a variety of data analysis task for you to complete using PMT and What-IF-Analysis functions. In this process, your supervisor wants you to complete all steps below:

  1. Open a new Microsoft Excel workbook and rename any sheet tab of choice to “My Car” or “My Truck.”
  2. Use the illustration and further steps below to set up and format your worksheet.

  1. Merge and center cells A1 and I1 and then enter a title “My Car” or “My Truck.”
  2. Using a color of choice, fill in cells C3 through I10 and in this colored region, include any picture of choice to represent a car or truck of choice. Nicely format and place this picture within this area.
  3. Then from cell A4 through A10, enter the following labels:
    1. Purchase Price
    2. Down Payment
    3. Trade-in
    4. Amount Financed
    5. Term of loan (in years)
    6. Annual Interest Rate
    7. Monthly Payment
  4. Then from cell B4 through B6, enter a purchase price, down payment, and trade-in value of choice. Then create a formula to calculate amount financed in cell B7. For example, a formula to use in this case would be “=B4-(B5+B6)”.
  5. Then from cell B8 through B9, enter the term of loan in years and an interest rate of choice. Then use a PMT function to determine the monthly payment in cell B10. For example, a formula to use in this case for cell B10 would be “=-PMT(B9/12,B8*12,B7)”.
  6. The illustration below will offer more support on input of all required formulas along with sample data input:

  1. Once all data and calculations are working, do any other housekeeping to include professional format of choice to enhance presentation of data.
  2. Repeat steps 4 through 12 creating another similar model for a house of choice and place this loan analysis model in the same workbook but in a new worksheet naming the worksheet “My Home.”
  3. Once both PMT_Models are complete, go back to My Car or My Truck worksheet and use the illustration below and further enhance the loan analysis using What-IF-Analysis.

  1. In cell A12, type the label Annual Interest Rate. Then merge and center cells B12 through I12 and enter the label Term of Loan (in years).
  2. In cell A13, equal this to cell reference B10. Fill this cell with a color of choice and use the same color for the text color to hide this value.
  3. Starting with cell A14 and ending with A35, enter some interest rates. Make sure data is centered and formatted as a percentage.
  4. Starting with cell B13 through I13, enter some additional term of loan options in years and make sure data is centered.
  5. Using your mouse, select all cells in the range from A13 through I35. Then select the data tab and then the What-If-Analysis tool. From the What-If-Analysis options select Data Table. At this point, a small dialog window will appear asking for Row and Column input cells. For the Row Input, select the value associated with years in the loan which would be an absolute reference as $B$8. For the Column Input, select the value associated with interest rate which would be an absolute reference as $B$9. 
  6. To get a better understanding of the purpose and uses of the What-If-Analysis, be sure to explore www.youtube.com and the keywords “Microsoft Excel What-If-Analysis” to see additional demonstrations.
  7. Once all data and calculations are working, do any other housekeeping to include professional format of choice to enhance presentation of data. Below is an illustration of what your My Car or My Truck worksheet will look similar too:

  1. Repeat steps 11 through 18 creating another similar What-IF-Analysis model for the My House worksheet.
  2. Save and be sure the name of the Microsoft Excel Workbook is “M7_YourLastName”.

Assignment Expectations

Structure and Format: Follow all 20 steps using ideally Microsoft Excel.

File name: Name your saved file according to your first initial, last name, and the assignment number (for example, “RHall Assignment 1.xlsx”)

Block Chain Technologies and Business

The theme of this research paper is Block Chain technologies. For this assignment, you must

research the theme with a focus on potential business applications of it (including yet beyond

Fintech). You must research current trends and summarize your research as a report. The

general structure of the report is as follows:

1. An introductory section about the current hype surrounding block chain technologies,

providing context for your report;

2. A description of select applications of Blockchain to business (minimum 3). Choose 1

particularly business areas (of your interest) in mind (e.g., HR, Marketing and Sales,

or  Operations) and provide three applications of Block Chain int those business areas. You must also describe and analyze these technologies based on

their potential to be game changers;

3. The challenges for such applications to become widespread and beneficial to

companies;

4. A conclusion section (with your takeaway from the discussion).

requirements

Your report must adhere to APA formatting;

2. You must research at least 5 recent (i.e., less than 5 years) peer-reviewed articles.

Exceptionally, highly regarded industry sources (e.g., IBM, Oracle, SAP, McKinsey,

Accenture, Deloitte, Capgemini) will be accepted;

3. Other than APA formatting, the structure for the paper is not fixed, as long as there is

a logical flow of ideas. The length of the paper is 5-6 pages

Homework Discussion

If your boss asked you to create a database that integrated logical design best practices, what are the three most important features you would integrate in your end solution? Remember to not only just state them, but explain why and show examples. Don’t repeat the same examples of others. That constitutes cheating. 

Instructions

This is a required assignment, worth 15 points. The assignment must be submitted by the due date. Late assignment are not allowed. 

You are required to submit a minimum of two postings. Points will be deducted for not fulfilling this minimum requirement.

Apply and use the basic citation styles of APA is required. Points are deducted per the rubric for this behavior.

Do not claim credit for the words, ideas, and concepts of others. Use in-text citation and list the reference of your supporting source following APA’s style and formatting. Points are deducted per the rubric for this behavior.

Do not copy and paste information or concepts from the Internet and claim that is your work. It will be considered Plagiarism and you will receive zero for your work. A second offense results in a zero for the course. A third is termination from the university.

IT Management Executive Brief

 

Assignment Content

  1. Imagine you are an IT manager at small retail organization that has a new owner. The new owner is from another industry and has expressed a lack of understanding of some of the controls and processes important to IT management and governance. You must help the new owner with understanding these important concepts.

    Write a 2- to 4-page executive brief in which you:

    • Discuss how the 2002 Sarbanes-Oxley Act has affected IT governance, including the major provisions of the act and how this might affect IT, and how IT might assist in compliance.
    • Discuss how IT policies, standards, and procedures can be used to determine if the enterprise is in compliance and support the IT strategy.
    • Discuss how Quality Management Systems (QMS) are important to ensure quality processes are in place.
    • Discuss how IT management and monitoring of controls can be used to assess IT performance.
    • Format your assignment according to APA guidelines.

      Submit your assignment.

Critical thinking (Assignment 2 – Problem Solving )

 

Choose one (1) of the problem scenarios as a topic choice for your paper (Note: Your professor must approve your topic choice before you begin work on the assignment.)

Scenario 1: You have worked at your company for eleven (11) years. You have returned to college to earn a Bachelor’s degree in order to increase your chances for a promotion. You are nearly finished with your degree, when a supervisor’s position in a competing company becomes available in another state. The start date is in two (2) weeks, during your final exam period for your courses. The position offers a $15,000 per year salary increase, a car allowance, and relocation expenses. Your former supervisor works for the company and is recommending you for the position based on your outstanding job performance; if you want the job, it’s yours. All of the other supervisors at this level in the company have Master’s degrees, so you know that you would be expected to earn your Bachelor’s degree and continue on to a Master’s degree. Your present company offers tuition reimbursement, but the new company does not.

Scenario 2: Your child comes home from school with an assignment sheet for a school project. He / she is very excited about the project and begins work immediately, doing research on the Internet and gathering materials. You read over the assignment sheet and notice that your child is not including all of the required items in the project, and you have some ideas for how to improve the quality of the presentation. You recently read an article in a parenting magazine about the importance of a child developing responsibility for his/ her own learning. You recall the many ways in which your parents took over your school projects. You, on the other hand, want to encourage your child’s confidence in his / her ability to complete a project independently. The next day, you are at the grocery store when you see a parent of a student in your child’s class. That parent has spent over $30 in supplies for the science project and is taking a day off of work to put the pieces of the project together.

Scenario 3: You have two jobs, one during the week from 9:00 am to 6:00 pm, and one on Saturday from 3:00 pm to 11:00 pm. You are taking two classes, one that meets from 6:00 to 10:00 pm, and one class online. You have two kids, one who plays soccer, and one who is in band. You have two elderly parents who no longer drive. You have two siblings, one who lives two (2) miles away, and one who lives in another state. You have two (2) papers due in your classes the same week that one (1) of your children has a soccer tournament, and the other child has a band concert. You are coaching the soccer team, and you are in charge of fundraising for the band. You have a goal to complete your degree in two (2) years. Your doctor tells you that your blood pressure, your cholesterol, and your weight are too high and recommends several medications that cost you nearly $200 per month after your insurance co-pay.

Scenario 4: You are a sales representative for a company that encourages staff to log time in the field and away from the office. You are expected to begin and end your day at the office. You notice that each day when you arrive and return another co-worker is already there, and you wonder whether this person spends most of his / her time at the office. At your weekly sales meeting, you are informed of your co-workers’ outstanding sales performance. You suspect that this co-worker is spending more time flattering the boss instead of working leads in the field, and as a result is getting the best client referrals. Your own sales numbers have steadily decreased since this other sales representative was hired.

 

Write a four to five (4-5) page paper in which you:

  1. Define the problem in the scenario that you have chosen.
  2. Analyze the problem in the scenario.
  3. Generate options for solving the problem in the scenario.
  4. Evaluate the options for solving the problem.
  5. Decide on the best option for solving the problem.
  6. Explain how you will implement the decision made and reflect on whether this option was the most effective.

Web Development, PHP and ASP Data Collection and Retrieval one page paragraph

 

  1. Identify the topic for this week.
  2. Find three high-quality sources of related information on the Internet. 
  3. Read your chosen high-quality sources of related information.
  4. state your three sources of information.
  5. DESCRIBE each of the three sources of information within a few sentences providing EXAMPLES.
  6. SUMMARIZE with three things about the topic that you want to remember forever.

emeging-discussion

 

Many business environments have both visible and invisible physical security controls. You see them at the post office, at the corner store, and in certain areas of your own computing environment. They are so pervasive that some people choose where they live based on their presence, as in gated access communities or secure apartment complexes. Alison is a security analyst for a major technology corporation that specializes in data management. This company includes an in house security staff (guards, administrators, and so on) that is capable of handling physical security breaches. Brad experienced an intrusion—into his personal vehicle in the company parking lot. He asks Alison whether she observed or recorded anyone breaking into and entering his vehicle, but this is a personal item and not a company possession, and she has no control or regulation over damage to employee assets. This is understandably unnerving for Brad, but he understands that she’s protecting the business and not his belongings.

When or where would you think it would be necessary to implement security measures for both?

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.

security architecture 4

 

Faced with the need to deliver risk ratings for your organization, you will have to substitute the organization’s risk preferences for your own. For, indeed, it is the organization’s risk tolerance that the assessment is trying to achieve, not each assessor’s personal risk preferences.

 What is the risk posture for each particular system as it contributes to the overall risk posture of the organization?

How does each attack surface – its protections if any, in the presence (or absence) of active threat agents and their capabilities, methods, and goals through each situation—add up to a system’s particular risk posture?

In addition, how do all the systems’ risks sum up to an organization’s computer security risk posture?