Please submit a resume for the FAKE JOB description below:

Resume Template. 2 docx.docx download

* The only real information is your name. However, use the template provided to apply for the job. It is fictional so you have already graduated and had the years experience for this position. So sell yourself. 

• Registered Nurse Pre-Op/PACU, Bethesda 
  • Outpatient Surgery Center at Bethesda West  
• FT, 7:00am – 3:30pm
• Baptist Outpatient Services (Links to an external site.)
• Requirements:
• The RN is a licensed professional who delivers patient-family-centered care in a culturally competent manner utilizing evidence-based standards of quality, safety, and service while ensuring the appropriate care for all age groups in the specific population of the unit. The RN demonstrates the following core competencies and behaviors: nursing process, technical skills, communication, critical thinking, interpersonal skills, flexibility, organizational skills, accountability and leadership.
• Qualifications: Degrees: Associates Licenses & Certifications: Registered Nurse Pediatric Advanced Life Support Neonatal Resuscitation Program Basic Life Support Advanced Cardiovascular Life Support Additional Qualifications: Associate degree in Nursing or Bachelors degree in Nursing. RNs hired prior to 2/2012 are not required to have a BSN to continue in their non-leadership role as an RN. RNs hired after 2/2012 with an Associate degree will have 5 years from their date of hire to complete the BSN degree. Life Support Certificate (BLS, NRP, PALS, ACLS) as per department standard. RN must complete a preceptor class within six months of hire. Minimum Required Experience: 2 years

#Exp19_Excel_Ch05_HOEAssessment_Fine_Art 

#Exp19 Excel Ch05 HOEAssessment Fine Art 

Project Description:

You are an analyst for a fine art dealer. Customers are especially fond of James C. Christensen’s art. You prepared a list of his artwork: Title (title of each piece of art), Type (the medium, such as Limited Edition Print or Anniversary Edition Canvas), Edition Size (how many copies were produced for purchase), Release date (the month and year the art was released), Issue Price (the original retail price when the art was released), and Est. Value (the estimated current market value). Studying the data will help you discuss value trends with art collectors

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

Before using the Subtotal   command, the data must be sorted by categories.
 

  On the Subtotals worksheet, perform a three-level sort by Status, then by   Type, and finally by Title, all in alphabetical order.

You want to subtotal data to   identify the highest issue prices, estimated values, and percentage change by   the Status category and the Type of art work.
 

  Use the Subtotals feature to insert subtotal rows by Status to identify the   highest (max) Issue Price, Est. Value,   and Change. Then add a second-level subtotal by Type using the same function   and columns.

You want to apply an outline so   that you can collapse values used for the formula in column F. Then you will   collapse the subtotaled rows.
 

  Apply an auto outline and click the collapse button above column F. Collapse   the data by displaying only the subtotals and grand total rows. Set a print   area for the range B1:F48.

A PivotTable can give additional   perspective to data. You will use the Art worksheet to create a recommended   PivotTable.
 

  Use the Art worksheet to create the recommended PivotTable called Sum of   Issue Price by Type on a new worksheet named Sold Out. Mac users create a PivotChart   that includes the Status field in the Filters area, the Est. Values field in   the Columns area, the Type field in the Rows area, and the Issue Price field   in the Values area.
 

  Name the PivotTable Art Type.

Currently, the PivotTable   contains the Issue Price field. You will add the Est. Value field to compare   the difference between total value of the art based on issue price and   estimated value today.
 

  Add the Est. Value field below the Sum of Issue Price in the Values area.

You want to display the average   values instead of the sum of the values in each category.
 

  Modify the two Values fields to determine the average Issue Price and average   Est. Value by type. Change the custom name to Average Issue Price and Average Est. Value, respectively.

Format the two Values fields   with Accounting number type with zero decimal places.

The Summary sheet is designed to   display two key averages from the PivotTable on the Summary sheet.
 

  Display the Summary sheet. In cell B2, insert the GETPIVOTDATA function that   references cell C4 on the PivotTable in the Sold Out sheet. In cell B3,   insert the GETPIVOTDATA function that references cell C9 on the PivotTable in   the Sold Out sheet.

Some art is still available, but   most art is sold out. You want to create a filter to focus on the sold-out   art.
 

  Display the Sold Out sheet. Add the Status field from the field list to the   Filters area. Set a filter to display only art that is Sold Out.

Insert a slicer for the Type   field, change the slicer height to 2 inches, change the button width to 2 inches, and apply the Light   Blue, Slicer Style Dark 5. Cut the slicer and paste it in cell A11.
 

  Note, depending upon the Office version used, the style name may be Slicer   Style Dark 1.

Display the Totals sheet. Insert   a calculated field named Field1 to determine difference between the two   values, Est. Value   and   Issue Price.   Change the custom name to Value Increase.

With the PivotTable on the Totals   sheet displayed, change the Sum of Issue Price and Sum of Est. Value fields   to show values as percentage of column totals.

With the PivotTable on the   Totals sheet displayed, select Light Blue, Pivot Style Medium 6 and display   banded rows.

Display the Porcelains sheet.   Create a relationship between the PORCELAINS table using the Code field and   the CODES table using the Code field.

Create a blank PivotTable from   inside the PORCELAINS table. Add this data to the Data Model. Name the worksheet   Porcelain   Pivot and name   the PivotTable Porcelain Values.

Display all tables in the   PivotTable Fields List task pane. Add the Description from the CODES table to   the Rows area and the Issue and Est. Value fields as Values from the   PORCELAIN table. Format the two value fields with Accounting number format   with zero decimal places.

Create a clustered column   PivotChart from the Porcelain Values PivotTable. Cut the PivotChart and paste   it in cell A7.

Add a chart title and type Porcelain   Values. Bold   the title. Change the value axis maximum bounds to $3,000.

Change the PivotChart height to 2.5 inches and the width to 3.7 inches.

Create a footer on all   worksheets (except Art) with your name in the left section, the sheet name   code in the center section, and the file name code in the right section.

Ensure that the worksheets are   correctly named and placed in the following order in the workbook: Subtotals,   Totals, Sold Out, Art, Summary, Porcelain Pivot, Porcelains.

Save and close Exp19_Excel_Ch05_HOEAssessment_FineArt.xlsx.   Exit Excel. Submit the file as directed

Analyze the success of a company/product that has either gone the full  protection path for its innovation, articulating how they used Patents, Copyright or  Trademarks to increase their market dominance. OR, articulate the success of a  company that has taken the complete opposite approach by succeeding down  the Open path. 

Position how the company has competed in their industry leveraging  their path on innovation protection or openness. Discuss what competitors have  done differently and why the company has been a standout.  

• APA Formatting  
• 4 pages  
• 2 external sources used  
• APA Style: include title page, reference page, in-text citations and no abstract  require

#Exp19_Excel_Ch05_ML2_Fiesta_Collection

#Exp19 Excel Ch05 ML2 Fiesta Collection

Project Description:

Your Aunt Laura has been collecting Fiesta dinnerware, a popular brand from the Homer Laughlin China Company, since 1986. You help her maintain an inventory. So far, you and Aunt Laura have created a table of color numbers, color names, year introduced, and year retired, if applicable. In a second table, you entered color numbers, item numbers, items, current value, and source. Previously, you helped her research current replacement costs; however, you believe the retired colors may be worth more now. Laura is especially interested in the values of retired colors so that she can provide this information for her insurance agent. You will build a PivotTable and add slicers to help her with the analysis 

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

The workbook contains two   related tables. You must create a relationship between these tables so that   you can create a PivotTable using data from both tables.
 

  Create a relationship between the Items table using the Color Number field   and the Colors table using the Color Number field.

Now that the relationship is   built, you are ready to create a PivotTable.
 

  Create a blank PivotTable from within the Items table on the Collection   worksheet to analyze multiple tables. Add the data to the data model. Place   the PivotTable on a new worksheet and name the worksheet Retired   Colors. Name   the PivotTable Retired.

Display the names of both tables   in the PivotTable Fields task pane. Display the Color field as rows and the   sum of the Replacement Value field as values.

Retired colors are often worth   more than currently available colors. Therefore, you want to filter the data   to show only retired colors.
 

  Add a filter to display aggregates for retired colors only using the Retired   field. Note that current colors do not have a retirement date, so you must   filter out the blanks.

Apply the Light Green, Pivot   Style Medium 7. Note, depending on the version of Office used, the style name   may be Pivot Style Medium 7.

In the Retired Colors sheet,   format the values with Accounting Number Format with two decimal places.

In cell B3, create a custom   heading named Replacement Values. Change Row   Labels in cell A3 to Retired Colors.

You want to add a second value   field to display values as percentages of the grant total.
 

  Add a second Replacement Value field below the current field in the Values   area. Select the option to display the values as percentages of the grand   total. Type the custom name Percent of Total.

Add a slicer for the Color   field. Select these colors to display: Apricot, Chartreuse, Lilac, Marigold,   Pearl Gray, and Sapphire.

You want to customize the   slicer.
 

  Apply the Light Green, Slicer Style Light 6 style. Note, depending on the   version of Office used, the style name may be Slicer Style Light 6. Display   three columns within the slicer window. Change the button width to 1.5 inches. Move the slicer so that   the top-left corner starts in cell E2.

A PivotChart will create a   visual illustration of the data in the PivotTable.
 

  Create a clustered column PivotChart and place it on a new chart sheet named Retired
PivotChart.

Now that the PivotChart is   created, you are ready to format it.
 

  Change the chart title to Replacement Value of Retired Items. Change the Lilac data point   fill color to Purple. Change the value axis font size to 11 and apply Black,   Text 1 font color.

Change the category axis font   size to 11 and apply Black, Text 1 font color. Hide the field buttons on the   PivotChart.

On all sheets, create a footer   with your name on the left side, the sheet name code in the center, and the   file name code on the right side.

Ensure the worksheets are in the   following order: Color List, Retired PivotChart, Retired Colors, Collection. 

Save and close Exp19_Excel_Ch05_ML2_Fiesta.xlsx. Exit   Excel. Submit the file as directed.

 The file you submit should be named “XYProjectTwo.java”, where “X” and “Y” 

Discussion Points: 

●    Explain how UX designers add value to a business.
●    Discuss why UX designers have to be fully aware of organization business goals.
●    What business/ professional skill do UX designers need to be able to create an added value to the organization?
●    Post a summary of your paper completed in Week 7 under this thread. 

● Discuss your next APUS Course enrolment.

● What do you recommend for students enrolling in this course?

● What improvement do you recommend for this course?

Student or Faculty Response: https://forms.office.com/Pages/ResponsePage.aspx?id=ze7fC9lqG0WN8AfkPVMdZytN6I6OnSpNg5Q3OcJi-klUQlJOUDlaM1RENU5EV0tXUE4zWjBZWks3U

CPTED best practices – 

Start by writing a brief description of your approach to completing the assignment. Note: Each Heading should have at least 2 properly formatted paragraphs and each paragraph should have at least 3 properly formatted sentences.

Checkpoints1) Include name, e-mail, and lab# as comment and print same to output2) Minimum of three (3) comments in each function (Purpose: Pre: Post:)3) use a globally defined constant for the rate of profit4) Input may not be case sensitive. That is, if user enters ‘r’ change it to ‘R’ immediately. To do this use if() and assign uppercase value or you may use toupper() function (see 10.2 on page 545 of text). Only an error message should be output and nothing more if data is erroneous. Use exit() function as explained in 6.15 (p. 360).5) A function must be used to calculate the number of books to be ordered. Round to the nearest whole number. Hint: static_cast (x + .5)6) A function must be used to calculate the profit given the number of books and unit price.
7) One function must be used for all the output8) Output must be formatted using dollar sign and 2 decimal place as shown on page 1.TEST DATA
(###) ###-####34.98,35,R,O
(###) ###-####34.98,34,R,O
(###) ###-####5.95,40,S,O
(###) ###-#### 65.99, 35, N, Y

cssssss and it _2

Exp19_Excel_Ch05_ML1_RealEstate

Project Description:

You are a real estate analyst who works for Mountain View Realty in the North Utah County area. You have consolidated a list of houses sold during the past few months and want to analyze the data. For a simple analysis, you will outline the data and use the Subtotal feature. You will then create two PivotTables and a PivotChart to perform more in-depth analysis.