• What are vulnerabilities associated with implementing virtualization?
• What is the likelihood for each vulnerability that it could be exploited?
• What strategies/methods can be used to mitigate the risks for virtualization?

  Capstone research paper with 8000 well-crafted words  including abstract, background, approach, literature review, project solution, discussion, recommendation and conclusion.

#Exp19_Excel_AppCapstone_IntroAssessment_Travel

#Exp19 Excel AppCapstone IntroAssessment Travel

# Excel Introductory Capstone Assessment – Travel 

Project Description:

You are considering several cities for a vacation. In particular, you are interested in Washington DC, Philadelphia, and Boston. You will format a list of memorials in DC, add Sparklines to compare the number of visitors over a 15-year period, and create a bar chart to illustrate annual visitors at each memorial. In addition, you will create a table of sightseeing locations, sort and filter the data, apply conditional formatting, and add a total row to display average time needed to spend at each memorial. Finally, you will complete a worksheet by adding formulas to compare estimated major expenses for each city.

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

On the DC sheet,   check the spelling and correct all misspelled words.

On the DC worksheet,   select the range A4:G4, wrap the text, apply Center alignment, and apply   Blue, Accent 5, Lighter 60% fill color.

On the DC worksheet,   merge and center the title in the range A1:G1. Apply Blue, Accent5 cell style   and bold to the title.

On the DC worksheet,   change the width of column A to 34.

On the DC worksheet,   select the range C5:F10 and insert Line Sparklines in the range G5:G10.

On the DC worksheet,   select the range G5:G10, display the high point sparkline marker, and change   the color of the high point markers to Dark Red.

On the DC worksheet,   select the range G5:G10, apply Same for All Sparklines for both the vertical   axis minimum and maximum values.

On the DC worksheet,   select the ranges A4:A10 and C4:F10 and create a clustered bar chart. Apply   the Monochromatic Palette 12 chart color. Apply the gradient fill to the   chart area. Do not change the default gradient options.

Cut the chart and   paste it in cell A13. Change the chart height to 6″ and the chart width   to 7″. Add Alt Text The bar chart shows the number of visitors   to each memorial for the years 2002, 2007, 2012, and 2017.

Change the chart   title to Annual Visitors. Apply Blue, Accent 5, Darker   25% font color to the chart title and category axis labels. Change the value   axis display units to Millions. Add Primary Minor Vertical gridlines to the   chart.

Apply data labels to   the outside end of the 2017 data series. Apply Number format with 1 decimal place to the   data labels.

On the Places sheet,   find all occurrences of BOS and replace them with Boston.

On the Places sheet   tab, convert the data to a table, assign the table name Tourist_Attractions, and apply Blue,   Table Style Medium 2.

On the Places sheet,   freeze the top row.

On the Places   worksheet, sort the data by City in alphabetical order and then within City,   sort by Sightseeing Locations in alphabetical order.

On the Places   worksheet, add a total row to display the average of the Time Needed column.   Apply Number format with zero decimal places to the total.

On the Places   worksheet, select the values in the Time Needed column and apply conditional   formatting to highlight cells containing values greater than 60 with Light Red Fill.

On the Places   worksheet, apply a filter to display only fees that are less than or equal to   $10.

On the Cities   worksheet, click cell F4 and enter a formula that will subtract the Departure   Date (B1) from the Return Date (B2) and then multiply the result by the   Rental Car per Day value (F3).

On the Cities   worksheet, click cell E13. Depending on the city, you will either take a   shuttle to/from the airport or rent a car. Insert an IF function that   compares to see if Yes or No is located in the Rental Car? Column for a city.   If the city contains No, display the value in cell F2. If the city contains   Yes, display the value in the Rental Car Total (F4). Copy the function from   cell E13 and use the Paste Formulas option to copy the function to the range   E14:E18 without removing the border in cell E18.

On the Cities   worksheet, click cell F13. The lodging is based on a multiplier by City Type.   Some cities are more expensive than others. Insert a VLOOKUP function that   looks up the City Type (B13), compares it to the City/COL range (A7:B10), and   returns the COL percentage. Then multiply the result of the lookup function   by the Total Base Lodging (B5) to get the estimated lodging for the first   city. Copy the function from cell F13 and use the Paste Formulas option to   copy the function to the range F14:F18 without removing the border in cell   F18.

On the Cities   worksheet, click cell H13 and enter the function that calculates the total   costs for the first city, including airfare, shuttle or rental, lodging, and   meals. Copy the function in cell H13 and use the Paste Formulas option to   copy the function to the range H14:H18 without removing the border in cell   H18.

On the Cities   worksheet, select the range E14:H18 and apply Comma Style with zero decimal   places. Select the range E13:H13 and apply Accounting Number format with zero   decimal places.

On the Cities   worksheet, in cell I2, enter a function that will calculate the average total   cost per city. In cell I3, enter a function that will identify the lowest   total cost. In cell I4 enter a function that will return the highest total   cost.

Group the three   worksheets and create a footer with Exploring Series on the left side,   the sheet tab code in the center, and the file name code on the right side.

On the Cities   worksheet, select Landscape orientation, set a 1″ top margin, and center   the worksheet data horizontally on the page.

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

Research a scholarly paper on “Databases, Warehouses and Advanced Data Management Systems” and reflect on one of the following topics:

• “DM Types”: What determines which type of Data Management System is being used? 
• “Importance”: How important is the Data Management system in conducting SAD? 
• “SA”: What is the role of the Systems Analyst to propose new Data Management solutions?

NOTE:
You must copy and paste the topic (“DM Types” or “Importance” or “SA”) at the start of your paper to provide a context for your answer.
This paper must be between at least one full page in length explaining what caught your eye and reflecting on what you read. 
Do not add extraneous text that does not address the question – do not add an introduction or conclusion.
Do not copy and paste text from the referenced resource.

You must provide at least one APA reference for your resource and corresponding in-text citations..
You must provide the referenced resource URL/DOI in the APA reference.
Do not use the Textbook as a referenced resource.

refer to the attached document

Excel_Ch11_CapAssessment_Deans | Excel Chapter 11 CapAssessment Deans

100% Marked on MYITLAB  

Project Description:

You work for the vice president’s office at a major university. Human Resources provided a list of deans and associate deans, the colleges or schools the represent, and other details. You will use text functions to manipulate text, apply an advanced filter to display selected records, insert database summary statistics, use lookup functions, and display formulas as text.

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

First, you want to combine the year and number to create a unique ID.
 

  In cell C8, enter 2006-435 and use Flash Fill to complete the IDs for all the deans and   associate deans.

Next, you want to create a three-character abbreviation for the   college names.
 

  In cell E8, use the text function to display the first three characters of   the college name stored in the previous column. Copy the function to the   range E9:E28.

The college names are hard to read in all capital letters.
 

  In cell F8, insert the correct text function to display the college name in   upper- and lowercase letters. Copy the function to the range F9:F28.

You want to display the names in this format Last, First.
 

  In cell J8, insert either the CONCAT or TEXTJOIN function to combine the last   name, comma and space, and the first name. Copy the function to the range   J9:J28.

Columns K and L combine the office building number and room with the   office phone extension. You want to separate the office extension.
 

  Select the range K8:K28 and convert the text to columns, separating the data   at commas.

You decide to create a criteria area to perform an advanced filter   soon.
 

  Copy the range A7:M7 and paste it starting in cell A30. Enter the criterion Associate Dean in   the appropriate cell on row 31.

Now you are ready to perform the advanced filter.
 

  Perform an advanced filter using the range A7:M28 as the data source, the   criteria range you just created, and copying the records to the output area   A34:M34.

The top-right section of the worksheet contains a summary area. You   will insert database functions to provide summary details about the Associate   Deans.
 

  In cell L2, insert the database function to calculate the average salary for   Associate Deans.

In cell L3, insert the database function to display the lowest salary   for Associate Deans.

In cell L4, insert the database function to display the highest   salary for Associate Deans.

Finally, you want to calculate the total salaries for Associate   Deans.
 

  In cell L5, insert the database function to calculate the total salary for   Associate Deans. 

Format the range L2:L5 with Accounting Number Format with zero   decimal places.

The range G1:H5 is designed to be able to enter an ID to look up that   person’s last name and salary.
 

  In cell H3, insert the MATCH function to look up the ID stored in cell H2,   compare it to the IDs in the range C8:C28, and return the position number.

Now that you have identified the location of the ID, you can identify   the person’s last name and salary.
 

  In cell H4, insert the INDEX function. Use the position number stored in cell   H3, the range C8:M28 for the array, and the correct column number within the   range. Use mixed references to keep the row numbers from changing. Copy the   function to cell H5 but preserve formatting. In cell H5, edit the column   number to display the salary.

In cell D2, insert the function to display the formula stored in cell   F8.
  In cell D3, insert the function to display the formula stored in cell H3.
  In cell D4, insert the function to display the formula stored in cell H4.
  In cell D5, insert the function to display the formula stored in cell L3.

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.

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

After your Wk 1 – Signature Assignment: Apply: SDLC Presentation, Pine Valley Furniture’s board of directors wants to continue consideration of a new WebStore for the company. They have asked you to assist them in selecting and initiating which project to do. They are considering a WebStore for 1 of their following 3 target markets:

• Corporate furniture
• Home office furniture
• Student furniture

Choose 1 of the following formats for this assignment:

• A 10- to 16-slide Microsoft® PowerPoint® presentation with speaker notes – see Note below
• An APA formatted 3- to 4-page Microsoft® Word® document. Please review the Center for Writing Excellence APA Templates and Samples and the University of Phoenix Writing & Style Guidelines. 

Address the following components in your presentation or Microsoft® Word® document:

• Considering the material in Ch. 4, “Pine Valley Furniture Company Background,” in Part One, “Foundations for Systems Development,” of Modern Systems Analysis and Design explain the 4 methods for identifying and selecting IS projects (i.e., Top Management, Steering Committee, Functional Area, and Development Group) as they would apply to the Pine Valley Furniture Project.
• Compare the characteristics of each method, and identify the strengths and weaknesses of each method as they would apply to the Pine Valley Furniture Project.
• Identify valuation criteria you would use when classifying and ranking the 3-target market projects (Corporate, Home office, and Student) as they would apply to the Pine Valley Furniture Project.
• Rank the 3-target market projects (Corporate, Home office, and Student) as you would evaluate them for Pine Valley Furniture, identifying which one you would recommend as the initial target for the WebStore, and explaining why you ranked them as you did.
• Summarize the project initiation and planning process for this Pine Valley Furniture project, and identify the next steps for Pine Valley Furniture’s board of directors.

Provide material from at least 2 references (only one of which is the class material) to support your assignment and provide proper references and citations in your assignment. Please review the Center for Writing Excellence material regarding references, citations, paraphrasing, plagiarism and the Student Code of Academic Integrity. There are Reference and Citation Examples in the Writing and Style Information section and also in the APA Sample Paper: Undergraduate and Master’s in the APA Templates and Samples section. And also in the Sample PowerPoint. The purpose of a reference and in-text citation is to show and identify where you specifically used material from the source either directly or as a paraphrase – even in PowerPoint® presentations. To sum this up, proper references and citations are needed for all of your work and should also be provided in your Microsoft® Word® document and on your Microsoft® PowerPoint® slides and speaker notes pages when needed – just having a Reference Slide at the end of a Microsoft® PowerPoint® presentation is not sufficient.

Please make sure your material is specific for the Pine Valley Furniture project and not just generic material. You should always consider that your audience may be more business-oriented than technical-oriented so you need to spell out what you mean.

1. Define the role of the Systems Analysts versus the Business Analyst.
2. Define the Systems Development Life Cycle.
3. Define the concept of Organizations as Systems.

-1page

-apa with references

Exp19_Access_Ch02_HOEAssessment – Drama Club 1.0 

Exp19 Access Ch02 HOEAssessment  Drama Club 1.0

Access Chapter 2 Hands-On Exercise Assessment – Drama Club

EX19_AC_CH02_GRADER_HOE_AS

Project Description:

You are the treasurer of the local drama club, and have begun to create a database of potential donors and volunteers for your organization. You discovered that some donations have already been made, but the records are stored in an Excel workbook. You use your newly gained knowledge of Access to create a relational database to track the donors and their donations. You will begin by importing the Excel workbook into the database. You will create a table from scratch to track the dates for which volunteers have signed up to help, create relationships between the tables, and then create some baseline queries 

Start Access. Open the downloaded Access file named Exp19_Access_Ch2_HOEAssessment_Drama. Grader has automatically added   your last name to the beginning of the filename. Save the file to the   location where you are storing your files.

You will examine the   data in the downloaded Excel worksheet to determine which field will become   the primary key in the table and which field will become the foreign key so   that you can join it to the existing table in the database.
 

  Open the Donations.xlsx Excel   workbook, examine the data, and close the workbook.
 

  You will import the Excel workbook that contains donation information into   the database.
 

  Click the External Data tab, click   New Data Source, point to From File in the Import & Link   group, and then select Excel.   Navigate to and select the Donations.xlsx   workbook to be imported as a new table in the current database. Ensure that First Row Contains Column Headings is   selected. Set the DonationID field Indexed option to Yes (No   Duplicates). Select DonationID as the   primary key when prompted and accept the table name Donations. Do not save the import steps.

Change the Data Type   of the DonationID field to   Short Text in Design view   of the Donations table. Set the Field Size of DonationID to 5. Set the Field Size   of DonorID to Long Integer. Save   the changes and open the table in Datasheet view. Close the table.

You will create a new   table that will enable the club to associate each donor who agrees to   volunteer with dates in the database.
 

  Create a new table in Design view. Add the following fields in Design view   and set the properties as specified:
 

  Add the primary key field as VolunteerID with the AutoNumber Data Type and Number assigned to a new   volunteer activity. (type the period) as the Description. Set the Caption property   to Volunteer ID.

   Add DonorID with the Number   Data Type and Donor Volunteer as the Description. Set the   Caption property to Donor ID and the Required property to Yes.

Add VolunteerDate with the Date/Time Data Type. Set the Caption   property to Volunteer Date. Switch to Datasheet view and   save the table as Volunteer Dates when prompted. You will enter   data into the table in a later step. Close the table.

You will create the   relationships between the tables using the Relationships window.
 

  Add all three tables to the Relationships window. Identify the primary key   field in the Donors table and join it with its foreign key counterparts in   the related Donations and Volunteer Dates tables. Select the Enforce Referential Integrity and Cascade Update Related Fields check boxes.   Save and close the Relationships window.

   You will add 8 records to the Volunteer Dates table so that you can test   referential integrity in the database.
 

  Add the following records to the Volunteer Dates table:

Donor ID

Volunteer Date

9

4/10/2021

9

4/24/2021

10

4/10/2021

10

4/24/2021

11

5/01/2021

11

5/08/2021

19

5/01/2021

20

5/08/2021

  Close the table.

Sort the records in   the Donations table by the DonationAmount field in descending order. Save and   close the table.

You will use the   Simple Query Wizard to create a query of all donors who indicate that they   are willing to volunteer.
 

  Add the Firstname, Lastname, Phone, and Volunteer   fields from Donors (in that order). Save the query as Donor   Volunteers.

Add a criterion in   Design view to select only donors with Yes in the Volunteer   field.

Sort the query   results in ascending order by Lastname. Run, save, and close the query.

You will copy the   Donor Volunteers query and modify it to add an additional table and field.
 

  Copy the Donor Volunteers query   and paste it using Donor Volunteers and Dates as the query name.

You decide to hide   the Volunteer column from the query results, as the value repeats in every   record of the datasheet.
 

  Open the Donor Volunteers and Dates   query in Design view and in the Volunteer column, click the Show check box to deselect it.

You will add a field   from a related table to display whom has volunteered for which dates.
 

  Add the Volunteer Dates table to   the top pane of the query design window. Add the VolunteerDate field to the last column of the design grid. Run,   save, and close the query.

You will create a   query that identifies donors and their associated donations. Because there is   a relationship between the two tables, you can now pull data from each of   them together as usable information.
 

  Create a query in Design view that includes the Donors and Donations   tables. The query should list the Firstname and Lastname (in that order),   then the DonationAmount and the DonationDate (in that order).

   Sort the query by the DonationAmount in ascending order. Run, close, and save   the query as Donors and Amounts.

You determine that   the data in the Donor Volunteers and Dates query could be summarized with a   Total row. You will group the records by donor name, and then count the   number of dates that each has volunteered.
 

  Copy the Donor Volunteers and Dates   query and paste it using Summary of Volunteer Dates as the query name.

Open the Summary of Volunteer Dates query in   Design view and delete the Firstname,   Phone, and Volunteer columns.

Click Totals in the Show/Hide group on the   Query Tools Design tab. Click in the Total   row of the VolunteerDate field, click the arrow, and then select Count.   The records will be grouped by the last name and the dates for each one will   be summarized.

Modify the field name   of the VolunteerDate column as Date Count: VolunteerDate to make the field   more identifiable. Click Run in   the Results group (5 records display in the Datasheet). The results display   the date count for each last name. Save and close the query.

Close all database   objects. Close the database and then exit Access. Submit the database as   directed.

1. Each student or student team of two will create a simple database from start to finish using the skills learned in the Database course. 
   Required Submissions: 
   Documentation (single document that includes: title page, table of contents, statement of work, ERD, business requirements and rules, a data dictionary, and any security rules that should be in effect for the database considering the database used to implement)
   Database (submit either access database or SQL script to create the database – must include sample data)