HW

 

Select one of the topics below:

  • Autonomic computing
  • Cloud computing
  • Grid computing
  • Nanotechnology
  • N-tier client/server architectures
  • On-demand computing
  • Service-oriented architecture (SOA)
  • Storage area networks (SANs)
  • Virtualization

Write a research paper on the real-world application of the chosen technology. Your paper should include the type of organization(s) that benefits most from this technology. Elaborate on what business problem the technology solves. Also, how does it help the organization achieve one or more of the following:

  • Achieve operational excellence through higher levels of efficiency and productivity
  • Create new products, services, and business models
  • Raise revenue and profits while lowering costs by increasing customer and supplier intimacy
  • Improve decision making for managers and employees
  • Increase competitive advantages
  • Ensure survival caused by business environment changes

Note:

  1. Follow assignment instructions.
  2. Follow proper APA format guidelines.
  3. Write a minimum of five full pages.

Exp22_Excel_Ch02_Cumulative – Garten Furniture

 Exp22_Excel_Ch02_Cumulative – Garten Furniture 

     

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

 

Insert a function in cell C3 to   display the current date and ensure that the format is set as a Long Date.

 

Set column C’s width to Autofit.

 

Insert a function in cell D11 to   display the item name based on the provided inventory lookup information in   the range B24:D29. Be sure to use the appropriate absolute cell referencing   and the function returns an exact match. Copy the function from cell D11 down   through D19 to complete column D.

 

Insert a function in cell F11 to   display the item price based on the provided inventory lookup information. Be   sure to use appropriate absolute cell referencing and the function returns an   exact match. Copy the function from cell F11 down through F19 to complete   column F.

 

Apply Currency Format to column   F.

 

Insert an IF function in cell   G11 to calculate the total due. If the customer has chosen delivery (column E   = Yes), there is an additional   delivery charge located in cell L11. If the item is not delivered, the total   due is price. Be sure to use appropriate relative and absolute cell   references. Copy the function from cell G11 down through G19 to complete   column G.

 

Apply Currency format to column   G.

 

Insert the function in cell I11   to calculate the first customer’s monthly payment, using appropriate relative   and absolute cell references. Place a minus sign to the left of the present   value argument so that the function returns a positive result. Copy the   formula down the column.

 

Use Quick Analysis to insert a   function in cell I20 that calculates the total of all monthly payments in   column I.

 

Apply Currency Format to column   I.

 

Type the customer name McGowan in cell B6. 

 

Use the XLOOKUP function in cell   C6 to lookup the customer name in the worksheet and return the corresponding   SKU, item name, delivery option, price, total due, years financed, and   monthly payment.

 

Use Format Painter to copy the   format from the range C11:I11 to C6:I6.

 

Insert a function in cell H24 to   calculate the total number of orders in the SKU column.

 

Insert a function in cell H25 to   calculate the lowest monthly payment in column I.

 

Insert a function in cell H26 to   calculate the average monthly payment in column I.

 

Insert a function in cell H27 to   calculate the highest monthly payment in column I.

 

Insert a function in cell H28 to   calculate the median monthly payment in column I.

 

Apply Currency format to the   range H25:H28.

 

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

Exp19_PowerPoint_Ch02_CapAssessment_Food

  

#Exp19_PowerPoint_Ch02_CapAssessment_Food  

#Exp19 PowerPoint Ch02 CapAssessment Food

  

Project Description:

Your school’s Culinary Club is raising money for the local food bank. You volunteer to create a slide show that will be shown at a potluck fundraiser put on by the club. In this activity, you will create a presentation that meets slide show design principles, and has shapes, animation, video, and audio.

  

#Start PowerPoint. Download and open the file named Exp19_PPT_Ch02_CapAssessment_Food.pptx. Grader has automatically added your last name to the beginning of the filename

#Replace Student Name in the subtitle placeholder on Slide 1 with Carl Patterson Change the title font size to 54.

#Click Slide 2. Change the title font size to 48. Change the subtitle font size to 32.

#Click Slide 3. Change the title to sentence case. Change the title font size to 54. Change the bulleted text to 32

#Click Slide 4. Change the title font size to 48. Change the bulleted text to 32.

#Click Slide 5. Change the title font size to 48. Change the subtitle font to 27.

#Click Slide 4 and insert a heart shape. Size it to a height of 2.5” and a width of 2.75” . Apply Colored Fill – Red, Accent 1, Darker 25%. Apply a shape outline in Black, Text 1. Apply Preset 2 as a shape effect. Position the shape horizontally at 10.35” from the Top Left Corner. Position the shape vertically at 4.9” from the Top Left Corner.

#Click Slide 2. Select the subtitle text and add the Zoom Entrance animation. Click After Previous in the Start box. Adjust the Duration to 01.75 and the Delay to 00.50.

#Click Slide 3. Select the first text bullet and apply the Fade Entrance effect. Set the animation to start After Previous with a Duration of 02.00 and a Delay of 01.75. Click the Animation Pane, and then click the arrow for the first bullet. Select Effect Options to access the Fade dialog box. Set the After Animation to Orange (sixth from the left) on the Effect tab.

#Select the second text bullet and apply the Fade Entrance effect. Set the animation to start After Previous with a Duration of 02.00 and a Delay of 01.75. Click the arrow for the second bullet in the Animation Pane. Select Effect Options to access the Fade dialog box. Set the After Animation to Orange (sixth from the left) on the Effect tab.

  

#Select the third text bullet and apply the Fade Entrance effect. Set the animation to start After Previous with a Duration of 02.00 and a Delay of 01.75. Click the arrow for the last bullet in the Animation Pane. Select Effect Options to access the Fade dialog box. Set the After Animation to Orange (sixth from the left) on the Effect tab.

#Click Slide 4 and select the heart shape. On the Animations tab, in the Animations group, click More and add the Pulse Emphasis effect. Set the animation to start After Previous with a Duration of 02.00 and a Delay of 0.25. Click the arrow for the shape in the Animation Pane. Select Timing and set Repeat to Until End of Slide and click OK.

#Click Slide 1 and add the Fade transition. Set the Duration at 01.00. Set the slides to advance automatically after 00:07.00. Set it to apply to all.

#Click Slide 5. Insert the downloaded video file Veggies.mp4. 

#Apply the Rounded Diagonal Corner, White moderate video style.

#Set the video to start Automatically. Change the Video Options to Hide While Not Playing and to Rewind after Playing. Compress the media in the presentation using the Standard setting. Mac users, compress all pictures in the presentation using the On-screen setting.

#Save and close Exp19_PPT_Ch02_CapAssessment_Food.pptx. Exit PowerPoint. Submit the file as directed.

Microsoft Access

I need help to add some  queries to finish my project 

 

Part 2

Create a query that shows the following information: you should have 8 queries and 2 tables in your access database. 

8 queries needed

  1. How many and which boats can seat more than 9 people
    1. Identify boat id, boat type
  2. How many and which boats can sleep more than 5 people
    1. Identify boat id boat type and ……..
  3. Which boats are older than 15 years
    1. Identify fields to display
  4. How many provide the cheapest boat to rent per day
    1. Identify boat id boat type and cost
  5. how many provide the most expense boats to rent per day
    1. Identify boat id boat type and cost
  6. Which is the biggest boat?
  7. Which is the smallest boat?
  8. Which is the oldest boat?

Week 2 Written Assignment

 

Week 2 Written Assignment

This week’s journal article was focused on how information and communication innovation drives change in educational settings. The key focus of the article was how technology-based leadership has driven the digital age.  Also, that the role of technology leadership incorporates with the Technology Acceptance Model (TAM).In this paper, address the following key concepts:

  1. Define TAM and the components.
  2. Note how TAM is impacting educational settings.
  3. Give an overview of the case study presented and the findings.

Be sure to use the UC Library for scholarly research. Google Scholar is also a great source for research.  Please be sure that journal articles are peer-reviewed and are published within the last five years.The paper should meet the following requirements:

  • 3-5 pages in length (not including title page or references)
  • APA guidelines must be followed.  The paper must include a cover page, an introduction, a body with fully developed content, and a conclusion.
  • A minimum of five peer-reviewed journal articles.

The writing should be clear and concise.  Headings should be used to transition thoughts.  Don’t forget that the grade also includes the quality of writing.