Monthly Archives: June 2023

Please refer to the word doc for question

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.

An independent real estate firm that specializes in home sales needs to create a database in which to store its records. In the following project, you will open a database containing information about the properties the real estate firm has listed. You will work with a table in which to store agent information, and then sort the table. You create a relationship between two tables and enforce referential integrity. You also apply filters, sort a table, and save the results.

Start   Access. Open the downloaded Access file named   Exp19_Access_Ch01_ML1_Home_Loans.accdb. Grader has automatically added your last name to   the beginning of the filename.

Open the Agents table in   Datasheet view, and add the following records letting Access assign the   AgentID number:

FirstName   LastName Title
Guillaume    Picard    Broker
  Keith    Martin     Agent
  Usa-chan    Yang     Agent
  Steven    Dougherty     Agent   in Training
  Rajesh    Khanna    Agent in Training
  Juan    Rosario  President

Sort the Age nts table by the LastName field in   ascending order.

Apply a selection filter so that   everyone with a title other than Agent   in Training displays. Save the changes to the table design and close the   Agents table.

Open the Properties table in   Design View. Change the data type for the specified fields as follows:

Field Name    Data   Type
  DateListed   Date/Time
  ListPrice   Currency
  SqFeet Number
  Beds Number
  Baths Number
  AgentID Number

Save the changes to the design   of the table. Access will alert you that some of the data in the table may be   lost due to changing the data type of the fields listed above. Click Yes then view the table in Datasheet   View.

Sort the records in the   Properties table by the ListPrice field from largest to smallest.

Use Filter by Form to create a   filter that will identify all properties with a list price less than $300,000 and with 2 beds. Apply the filter and   preview the filtered table. Close the table and save the changes.

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

 1 page 

After having the opportunity to complete the course, what would you change and why? What topic particularly caught your interest and what do you want to know more about?  Last, but not least, if you could share with the next class one piece of advice about this class, what would it be? Please note that this pertains to the class, the materials, flow/organization, etc.

Your comments may be shared with incoming students with no identifying information. Thank you and good luck on your educational journey!
(No participation replies required but encouraged!)

The chief technology officer (CTO) has indicated that your organization has been requested by the National Security Council (NSC) to comment on the upcoming National Cybersecurity Strategy. The NSC has asked for specific recommendations as it relates to the next cybersecurity strategy, private/public partnerships, and comments on how specific technologies should be incorporated into the assessment.

The CTO has asked you to collaborate with your team to provide the organizational input.

Use the Cybersecurity Strategy, Law, and Policy Team Assignment Template to write your paper, which should cover the following topics:  

Part 5: Cybersecurity Technologies

• The authors of the National Security Strategy (NSS) are looking to address particular technologies that have the opportunity to revolutionize cybersecurity. They believe that blockchain technology is a revolutionary technology that has the ability to significantly improve cybersecurity.
  • What would be your recommendation for how the NSS should incorporate this technology to the public?
  • Propose exactly what you believe should be written in the NSS. Specifically, explain the blockchain technology in layman’s terms to nontechnical people that may be reading the NSS, give examples of how it could be used to provide revolutionary cybersecurity, include examples of how it is being used to provide cybersecurity solutions, and discuss what, if any policies or laws should be established to mandate its use in specific industries.

 I only need part 5 done.

 Statistics for Data Science. 

1. Current occupation and employer (if applicable)
2. Experience and/or background with statistics 

Why study statistics?  

Modern computing power is causing a revolution in data analysis. Key drivers have been the rapid development of new technology, access to more and bigger data, and the greater use of quantitative analysis in a variety of disciplines: 

1. Why is computing power so influential in data analysis?
2. Why is almost any sort of data so valuable to the companies and the governments? 

• Complete the discussion by the assigned due date.  
• Do not claim credit for the words, ideas, and concepts of others. 
• Do not copy and paste information or concepts from the Internet and claim that it is your work. It will be considered Plagiarism and you will receive a zero for your work.

What changes are necessary to support the current times and future times of the uses of operating systems to allow a more consistent model across many different hardware platforms? 

how Alexa interact with home devices

Week 2 Assignment

Chapter 3 –discussion question #1-4 & exercise 12 

Chapter 4 – discussion question #1-5 & Case pg. 243 

The Target story answer the two case questions on page 244 integrating concepts and examples from that case. 

The above assignments should be submitted in one-word document.Include an APA cover page and a reference page. 

Create a project that calculates the total of fat, carbohydrate, and protein calories. Allow the user to enter (in text boxes) the grams of fat, carbohydrates ,and protein. Each gram of fat is nine calories. Each gram of carbohydrates and protein are 4 calories.
Display the total calories for the current food in a text box. Use two other text boxes to display an accumulated sum of calories and a count of items entered.
Include buttons to CALCULATE to CLEAR the text boxes and PRINT and EXIT buttons.