Exp19_Excel_Ch11_ML1_Internships

 Exp19_Excel_Ch11_ML1_Internships

Project Description:

As the Internship Director for a regional university, you created a  list of students who are currently in this semester’s internship  program. You have some final touches to complete the worksheet,  particularly in formatting text. In addition, you want to create an  advanced filter to copy a list of senior accounting students. Finally,  you want to insert summary statistics and create an input area to look  up a student by ID to display his or her name and major.

You want to extract the last four digits of the student’s ID.
 

  #In cell B2 on the Students sheet, extract the last four digits of  the first student’s ID using the RIGHT function. Copy the function from  cell B2 to the range B3:B42.
   Hint: Formula is =RIGHT(Student ID, 4)

#After extracting the last four digits of the ID, you want to align the data.
 

  #Apply center horizontal alignment to the range B2:B42.
   Hint: The Home tab contains alignment options.

#The first and last names are combined in column C. You want to separate the names into two columns.
 

  Convert the text in the range C2:C42 into two columns using a space as the delimiter.
   Hint: Text to Columns is located on the Data tab.

#You want to convert the text in column F to upper and lowercase letters.
 

  #Use a text function in cell G2 to convert the text in cell F2 into  upper and lowercase letters. Copy the function to the range G3:G42.
   Hint: Formula is =PROPER(Major)

#Now that you have converted text from uppercase to upper and  lowercase, you will hide the column containing the majors in all capital  letters.
 

  Hide column F.
 

  Hint: The Home tab contains an option to hide a column.

You want to create a criteria range for the dataset.
 

  #Create a criteria range by copying the range A1:I1 and pasting it in cell   A44. Create conditions
   for   Senior Accounting   majors on row 45 and an OR condition for Junior Accounting majors in the respective cells   on row 46

You are ready to perform the advanced filter.
 

  #Create an output range by copying the range A44:I44 to cell A48.  Perform the   advanced filter by copying data to the output range. Use  the appropriate   ranges for list range, criteria range, and output  range
   Hint: The Data tab contains the option to perform an advanced filter.

On the Info worksheet, you want   to insert a database function based on conditions.
 

  #Display the Info worksheet and insert the DSUM function in cell B2  to   calculate the total tuition for junior and senior accounting  students. Use   the range A1:I42 for the database, Tuition for the field, and the criteria range.
 

You want to insert database   functions to perform calculations.
 

  In cell B3, insert the DAVERAGE function to calculate the average GPA for junior and senior   accounting students on the Students worksheet. Use mixed references in the   ranges.

You want to identify the highest   GPAs for junior and senior accounting majors.
 

  In cell B4, insert the DMAX function to identify the highest GPA for junior and senior   accounting students on the Students worksheet. Use mixed references in the   ranges.
 

In cell B5, insert the DMIN function   to identify the lowest GPA for junior and senior accounting students on the Students   worksheet. Use mixed references in the ranges.
 

In cell B6, insert the DCOUNT   function to count the number of junior and senior accounting
   students on the Students worksheet. Use mixed references in the ranges.
 

In cell B9, insert the DGET   function to retrieve the last name of  the student who has the ID listed in   cell A9. Use the column number  representing the Last Name column for the   field argument and use the  criteria range A8:A9. Edit the function to make the column letters  absolute. Copy the DGET function from cell B9 to cell C9.   Edit the  field number to represent the GPA column.
 

You want to format the results of the database functions.
 

  Format the range B3:B6 with Comma Style. Decrease the number of decimal   places to zero
   for cell B6.

You want to identify the location of a particular ID.
 

  Insert the MATCH function in cell B13 to identify the position of the ID   stored in cell B12. Use
   the range A2:A42 in the Student’s worksheet as the lookup_array argument and   look for exact
   matches only.
 

Insert the INDEX function in cell B14 with Students!A$2:I$42 as the  array, B$13 that contains the MATCH function as the row number, and 4 as the column number. Copy the function from cell   B14 to cell B15. Edit the function to change the column number to 7.

Change the ID in cell B12 to 11282378. The results of the MATCH and   INDEX functions
   should change.

You want to insert a function to display other functions as text.
 

  Insert the FORMULATEXT function in cell D2 to display the formula that is   stored in cell B2.
   Copy the function to the range D3:D6 and to the range D13:D15. In cell D8,   insert the
   FORMULATEXT function to display the function that is stored in cell B9, and   in cell D9, insert
   the FORMULATEXT function to display the function that is stored in cell C9.

Increase the width of column D   to 50.

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.

access control W4 assignment

In approximately 300 words, discuss security and technical drivers for having an access control policy and the key tenets of that policy.  Follow APA standard.  

Instructions:

Please follow the APA Format

Please cite the reference properly in text

No plagrism

Require 300 words

Write a method

  

Write a method with the signature “public static int findMax(int[][] data)” which finds the maximum value in the given array and returns it. Is there a limit to the number of dimensions can an array have? Why might you use a two-dimensional array? 

Presentation

 Information related with the Survey paper and Presentations is given here. Survey This is an individual research. Each student will prepare a survey on the topic of their interest by reading at least 3 – 5 scientific papers and writing a short report (maximum of 5 pages including citations). Survey details In your report, give the problem/topic definition, discuss the motivation behind the studies working on this problem/topic (just try to answer the question of “why have all these studies worked on this problem? is it really important?”), and then explain the studies. While explaining the studies, do NOT list the studies and do NOT explain them one by one. Instead, understand the contribution and methodology of each study, try to group the studies according to their contributions and methodologies, and then explain/discuss the studies as groups.
In your discussion, do not forget to give the give the advantages and disadvantages of each group’s approach, and discuss the similarities and differences in between the approaches followed by different groups. The format, plagiarism, structure, and writing style of your report (including writing the citations properly) will be a part of your grade.

Discussion 3

Q1) Given the growth in telecommuting and other mobile work arrangements,  how might offices physically change in the coming years? Will offices  as we think of them today exist in the next ten years? Why or why not?  

Min 250 words

Two references

Q2) If you have you been involved with a  company doing a redesign of business processes, discuss what went right  during the redesign and what went wrong from your perspective.  Additionally, provide a discussion on what could have been done better  to minimize the risk of failure. If you have not yet been involved with a  business process redesign, research a company that has recently  completed one and discuss what went wrong, what went right, and how the  company could have done a better job minimizing the risk of failure.

Your paper should meet the following requirements: Be approximately 4 pages in length, not including the required cover page and reference page.

Follow APA7 guidelines. Paper should include an introduction, a body with fully developed content, and a conclusion.

At least two scholarly journal articles to support  the positions, claims, and observations.

Attach them as two sep documents along with plagiarism report

Weekly Activity 8

Complete the attached

This exercise is more suited for in person instruction, obviously, so let’s do it this way.  Try to execute the exercise with another person, spouse, friend, etc.  Explain in a half page or more what the exercise was meant to accomplish.  No references required.  If you can’t perform the exercise with another person, simulate the exercise by yourself and reflect on what you were supposed to learn.

Java

I need a test case for the following programming code 

* Click nofs://nbhost/SystemFileSystem/Templates/

Licenses/license-default.txt to change this license

* Click nofs://nbhost/SystemFileSystem/Templates/

Classes/Class.java to edit this template

package poker;

import java.util.ArrayList;

import java.util.*.

* Click nbfs://nbhost/SystemFileSystem/Templates/

Licenses/license-default.txt to change this license

* Click nofs://nbhost/SystemFileSystem/Templates/

Classes/Class.java to edit this template

/**

* @author adamt

public class Deck {

private ArrayList deck = new ArrayListO);

public Deck(){

ArrayList deck = new ArrayList();

for(int i=0;i<=3;i++){

for(int j=0;j<13:j++){

cdeck.add(new Card (ij));

3

deck=cdeck:

public void printAllCards){

for(int i=0;i

System.out.println(deck.get(i).toString());

}
public Card getCard(int i){

return deck.get(i);

}

public Card deal0f

return deck.remove(0):

public int countCards ()f

return deck.size();

public void shuffle )f

Collections.shuffle(deck,new Random());

?