Exp22_Excel_Ch04_Cumulative – Insurance Claims 1.1

Project Description:

You have been hired as a business analyst at SKV Insurance claims department. As part of your responsibilities, you have been asked to enhance the Excel workbook used to analyze the department’s performance. The workbook contains records of all claims resolved over the past year. You will convert the data to a table, format the table, sort and filter the table, insert calculations to evaluate key performance indicators, and then prepare the worksheet for printing. 

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

Freeze the panes so the first   row containing column headings (Row 6) and first two columns (Columns A:B) on   the InsuranceClaims worksheet will remain static when scrolling.

Convert the data to a table,   name the table InsuranceClaims, and then apply the Light Green, Table Style Light   21.

Remove duplicate records.

Add a new column to the table   named Duration.

Create a formula using   unqualified structured references to calculate the days required to resolve   the incident (Date Resolved – Date Created) and apply General Number Format.

Add a total row to display the   Average days required to complete a claim.

Sort the table by insurance   agent in alphabetic order, add a second level to sort by description, and   then create a custom sort order as follows: Natural Disaster, Flood, Fire, Theft, Accident. Add a third level to sort by duration smallest to largest.

Filter the table to only display   closed claims as indicated in the status column.

Use Quick Analysis to apply Blue   Data Bars conditional formatting to the column that contains duration. (On a   Mac use Conditional Formatting.)

Create a conditional format that   applies Red fill and White Background 1 font color to the incidents (column   B) that required 30 or more days to resolve.

Select Landscape orientation and   set appropriate margins so that the data will print on one page. Set the   print scale to 70%.

Change page breaks so each   agent’s information prints on its own page.

Set row 6 to repeat on each page   that is printed.

Save and close EXP22_Excel_CH04_Cumulative_Insurance.xlsx.   Exit Excel.

Need it in 4 hrs.

The key to this paper is to demonstrate your understanding of the topics, not to re-word the text or reference material. Paper must be 100% original and not plagiarized.

QUESTION: Research via the internet and find an article in the news regarding wireless hacking, hardware hacking, or other security breach.

As security and IT change so rapidly, your article should be no older than 2007 (i.e. Less than 5 years old).

Summarize the article using at least 2 page double space APA format.

Chapter 10 introduced ten blockchain implementation obstacles. Create a new thread, choose two obstacles from those discussed in chapter 10, then describe them and how they could disrupt blockchain acceptance. Also, describe how you would overcome each of these obstacles. Then think of three questions you’d like to ask other students and add these to the end of your thread. The questions should be taken from material you read in Chapter 10 or 11. You’re not trying to test each other, but you are trying to start a discussion.

You must do the following:

1) Create a new thread. As indicated above, choose two obstacles from those discussed in chapter 10, then describe them and how they could disrupt blockchain acceptance. Also, describe how you would overcome each of these obstacles. Then think of three questions you’d like to ask other students and add these to the end of your thread. The questions should be taken from material you read in Chapter 10 or 11. You’re not trying to test each other, but you are trying to start a discussion.

2) Select AT LEAST 3 other students’ threads and post substantive comments on those threads. Your comments should answer AT LEAST one of the questions posed in the thread and extend the conversation started with that thread. Make sure that you include the question in your comment so I can see what question you’re answering.

ALL original posts and comments must be substantive. (I’m looking for about a paragraph – not just a short answer.)

 Complete the following assignment in one MS word document: 

1. Understand the basic concepts and processes of group work, communication, and collaboration
2. Describe how computer systems facilitate team communication and collaboration in an enterprise
3. Explain the concepts and importance of the time/ place framework

 When submitting work, be sure to include an APA cover page and include at least two APA formatted references (and APA in-text citations) to support the work this week.
All work must be original (not copied from any source). 

 1.A cover letter is really your first introduction to a prospective employer.  You are trying to convince them that your the right fit for them to consider further – you want them to give strong consideration to your resume (generally enclosed) or to your job application.  The cover letter is not just a rehash of your resume, it should be in a tone and form to convince a hiring manager to read all of the detail that your resume provides. 

Please submit a cover letter here!  This is a formal letter – it should be addressed TO A PERSON, not just “To Whom It May Concern”.  Ideally, it’s a real person for a real job that you’ve found posted, but even if it is not, you should address it to a fictitious person with a full-blown name, inside address, etc. just for the practice.  This is a letter, not a memo.  

2. 

A resume – in paper form as you create here, or in digital form on a site such as LinkedIn – is a vital tool for summarizing your skills and showing your professionalism.  This is true for first-time job seekers and for experienced pros.  Often, you’ll find that you’ll customize (a little or a lot) each resume you send out – to make it more focused on the job you are seeking.  A resume is a living, dynamic document – you’ll need to/want to update yours regularly, even if you’re not actively looking for a job.

Your resume may be in a functional layout, a chronological layout, or a combination of both!  Be sure to utilize resources such as your campus career services expert, your advisor or faculty advisor, and others, to help to determine the best resume layout and content for you.

GO16_WD_CH02_GRADER_2G_HW – Letter And Resume 1.5

Assignment 3 B: Machine Learning Model Training 2 

• Two multi-part, multiple-choice questions. with short answer questions

•  AI in Healthcare with Phase 3 data set from (HTML file)

• Details of the Q1 & Q2 m/c questions and short answer questions are shown in the attached question sheet

• Lecture notes on Machine Learning in Healthcare for your reference

What’s the major difference between Scanner/PrintWriter based I/O and Streaming I/O?

Select all that are true

Streams come from java.util and Scanner comes form java.io

Scanner and Stream I/O are mutually exclusive and cannot be used together

Streaming I/O focuses on byte data rather than typed data

OutputStreams unlike PrintWriter output data in human-readable forms

Streaming I/O can be specialized to a task such as Object Serialization

For HW last week, you were to watch a movie and take some notes. This discussion assignment is designed to be used with the Week 2 video and has TWO parts. Please watch the video and pause while you write each of your responses below — refer to the movie in your responses; be as specific as possible:

https://drive.google.com/file/d/1OtDBVTHRxuLecqPXXrhjUMZ1AoaeUMnd/view?usp=sharing 

Part ONE: Your Responses (from HW — you may cut and paste excerpts from your Homework)

1. What are THREE words you would use to describe your feelings about Nelson Mandela?
2. What important problem did Mandela face coming into office? 
3. We judge that a problem is important by its IMPACT: who was impacted by this problem?
4. What may have caused the problem?
5. What did he try in order to solve or mitigate it?
6. Ultimately, what solution worked best?
7. How did he implement it?
8. We can not always solve a problem; sometimes, however, we can mitigate it: how do you know if he succeeded in either solving or mitigating it?