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.

•  

 Please respond to the discussion posted below with a minimum of 150 words and use references. 

   There are several different types of lists that are commonly used in  Java. Amongst these are Arraylists, LinkedLists, and Vectors. Unlike  arrays, these list methods are dynamically sizable which makes them  extremely convenient to use. Also, only one data type can be stored per  array and lists can store multiple data in one list. Arraylists and  Vectors are not suitable for storing primitive data types and instead  must store all data as an object (TUI, n.d.).  The biggest differences  between these three methods are how they store and access elements.  These differences make them better and less suited for storing data in  specific scenarios. For instance, if you will be adding a lot of  elements but not doing a lot of searching then a LinkedList may be your  best bet. If you can predict scalability of data but still need a  dynamically sizable array that is searchable, then a Vector might be the  most useful. If memory usage is not paramount but you want a high  amount of search speed, then an ArrayList is an easy choice. To provide a  clearer picture of the differences, here are some examples of the code  of each method.

A  linked list is a type of list which in the context of programming means  that it is linear collection of elements whose order is determined by  the elements around it (Linked List, 2021). In linked lists, these  elements are known as “nodes” which each node pointing to the next  element in the set with a “head” node at the start of the list and a  “tail” or null node to end the list.  Vectors are synchronized, can increment 100% of its size is adding an  element exceeds capacity and can use both enumerator and an iterator  (Parahar, 2019). Like ArrayLists, they also keep insertion order.  Because memory increase is done in increment, this means that they are  more resource friendly than ArrayLists. Because they are synchronized,  only one thread can access a Vector at one time. Ultimately, these make  Vectors more memory friendly but slower than ArrayLists, but still  capable of better search functions than a LinkedLists. 

Identify and explain the core modules of Hadoop.

Install MongoDB database on your local PC. Create a table with five columns and add ten rows. Write the SQL queries to provide create, read, update, and delete (CRUD) records to this table. Feel free to use any MongoDB database management IDE open source.

Requirements:

• Maximum four to five pages in length is required.
• You must include program code and results.
• You must include an explanation about how the program works.
• You must show your work for full credit.
• You must include a minimum of three credible sources. Use the Saudi Electronic Digital Library to find your resources.
• Your paper must follow Saudi Electronic University academic writing standards and APA style guidelines, as appropriate.

 

Submit a word document containing an analysis and a summary of the completed lab (part A). The word document should contain the following elements:

• Summary of the lab
• Analysis of the activities performed in the lab and their importance to the course topics
• How the lab relates to the course and current module topics
• Related concepts from the module readings and lectures
• At least one external reference
• 1-3 pages in length
• Proper APA formatting and citations
• Minimum of 1-3 references are required
• Screens shots are encouraged but should be included as an appendix and not part of the total page count.

  The Metropolitan Zoo tracks its animal data in Excel. The organization decides to use a database to organize the data about the animals, their trainers, and the animal exhibits. In this project, you will open an existing database and create a new table. You will import an Excel file containing information about the animals, and query the database to determine which animals need a checkup. You will also create a query to obtain a listing of the animals in each exhibit.

Exp19_Excel_Ch11_ML2_Game_Studio 

Exp19 Excel Ch11 ML2 Game Studio

Excel Chapter 11 Mid-level 2 – Game Studio

  

Project Description:

Innovations Game Studio has locations in Portland, Seattle, and Salt Lake City. Each location has game-development teams to produce video games for various consoles. You will use text functions to format the list and copy records of programmers in one location. In addition, you will insert database functions to calculate summary statistics and create a lookup area to look up an employee’s ID to retrieve that person’s name, job title, and salary.

     

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

 

You want to combine the first,   middle, and last names into one cell for each person.
 

  Display the Salary Data worksheet. In cell E2, insert the TEXTJOIN function   to join the range
  B2:D2, using a space delimiter and ignoring blank cells. Copy the function to   the range E3:E49.

 

Column F contains job titles and   departments. You want to separate the data into two columns.
 

  Select the range F2:F49 and convert text to columns using the comma delimiter   to separate
  the department names from the job titles. Click OK when prompted with There’s already data
here. Do you want to replace it?

 

You want to display just the   city names in column I by nesting a LEN function within a LEFT function.
 

  In cell I2, insert a LEN function that identifies the number of characters in   cell H2. Edit the function by subtracting 4 after the closing parenthesis. The   result subtracts the two-letter state abbreviation, space, and comma, leaving   the number of characters in the city. Edit the cell contents to nest the LEN   function as the num_chars argument for a LEFT function. Use cell H2 as the   text argument. The nested function result should display the city name only.   Copy the function to the range I3:I49.

 

The state abbreviations should   be formatted in uppercase letters.
 

  In cell J2, insert an UPPER function that nests the RIGHT function with cell   H2 as the text function and the correct number of characters to extract just   the state abbreviation. Copy the function to the range J3:J49.

 

You want to create a criteria   range to enter data to filter the dataset based on conditions.
 

  Create a criteria range by copying the range A1:K1 and pasting it in cell   A51. Create conditions
  using Programming   as the   department and Salt Lake City as the city in the respective cells on row 52.

 

You are ready to create the   output range and perform the advanced filter.
 

  Create an output range by copying the range A51:K51 to cell A54. Perform the   advanced filter by copying data to the output range. Use the appropriate   ranges for list range, criteria range, and output range.

 

Hide columns B, C, D, and H in   the Salary Data worksheet. 

 

Change the width of column F to 21.

 

You are now ready to insert   database functions on the Information sheet.
 

  In cell B2, insert the appropriate database function to calculate the total   salary for programmers in Salt Lake City. Use the range A$1:K$49 in the   Salary Data worksheet for the database, Salary for the field, and the criteria range.

 

In cell B3, insert the   appropriate database function to calculate the average salary for programmers   in
  Salt Lake City.

 

In cell B4, insert the   appropriate database function to identify the highest salary for programmers   in Salt
  Lake City.

 

In cell B5, insert the   appropriate database function to identify the lowest salary for programmers   in Salt Lake
  City.

 

In cell B6, insert the   appropriate database function to count the number of programmers in Salt Lake   City.

 

You are ready to format the   values.
 

  Format the range B2:B5 with Accounting Number Format with zero decimal   places.

 

Format cell B6 with Comma Style   with zero decimal places.

 

You want to combine text using   the CONCAT function.
 

  In cell B1, insert a CONCAT function that concatenates the text in ‘Salary   Data’!F52 and ‘Salary Data’!I52 separated by a space, the word in, and another space. The result   should look like this: Programming in Salt Lake City.

 

Before using an INDEX function,   you want to use the MATCH function to identify the position of an ID.
 

  In cell E3, insert the MATCH function to identify the position of the ID   stored in cell E2. Use the range A2:A49 in the Salary Data worksheet for the   lookup_array argument and look for exact matches only.

 

In cell E4, insert the INDEX   function with Salary Data!A$2:K$49 as   the array, E$3 that contains the MATCH function as the row number, and 4 as the column number to   retrieve the last name corresponding to the ID in cell E3.

 

Copy the INDEX function to the   range E5:E6. Edit the function in cell E5 by changing 4 to 7. Edit the function in cell E6 by changing 4 to 11. Format cell E6 with Accounting Number Format with zero decimal   places. Change the ID in cell E2 to 17604 to test the results of the MATCH and INDEX   functions.

 

In cell H2, insert the function   to display the formula that is stored in cell B2.

 

In cell H3, insert the function   to display the formula that is stored in cell E3. Copy the function to cell   H4.

 

In cell H5, insert the function   to display the formula that is stored in cell B5. Copy the function to cell   H6.

 

Use the Home tab to change the   width for column H to 57.

 

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 on all sheets.

 

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

 As a developer, it is important that you find the right language to master. Python is still one of the most used languages, but you want to make sure that you are current with others as well. It is important to note that there are wrong languages to choose that will put you behind the curve, as the landscape is ever-changing. Do some research on the Internet and describe one language other than Python that you feel would be beneficial to your career and one that would not. Be sure to include your reasoning. If you are not a developer, how does learning Python or other languages benefit you? 

Chapter 14. Project Closeout and Termination Initial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.Also, provide a graduate-level response to each of the following questions:

1. Why do so many projects end up terminated as a result of termination through starvation?  Discuss the role that ego, power, and politics in this form of termination.

[Your post must be substantive and demonstrate insight gained from the course material. Postings must be in the student’s own words – do not provide quotes!]  [Your initial post should be at least 450+ words and in APA format (including Times New Roman with font size 12 and double spaced). Post the actual body of your paper in the discussion thread then attach a Word version of the paper for APA review]

Text-

Title: Project Management ISBN: 9780134730332 Authors: Pinto Publisher: Pearson Edition: 5TH 19 

need in 5 days 

please see document below

 

Question #1. View the Interactive titled “Lift and Drag” located at http://www.pbs.org/wgbh/nova/space/lift-drag.html (Links to an external site.) Links to an external site.. assess each of the four main types of airfoils for function and purpose. Note: Be sure to include how each impact lift and drag, as well as what type of aircraft is best suited for each. Provide two other practical uses for airfoils.

Question #2. Read the question and answer titled “Why don’t I fall out when a roller coaster goes upside down?” located at http://2008.myvote.org/www.loc.gov/rr/scitech/mysteries/rollercoaster.html (Links to an external site.) Links to an external site.. Imagine that you are trying to convince your apprehensive friend John to take his first roller-coaster ride. Explain to John how the roller-coaster engineers use physics to create a safe, yet thrilling ride. Note: In your explanation, be sure to include a discussion of potential energy, kinetic energy, angular momentum, frictional forces, and inertia when analyzing all aspects of the roller-coaster ride.