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.

Assignment – Week 6

Provide a historical overview of the Blackberry?

• Why was Blackberry invented?
• How successful has Blackberry been compared to other mobile devices?
• What are some of the advantages and disadvantages of the Blackberry?
• In your opinion, what is the future outlook of Blackberry?

Your assignment must follow these formatting requirements:

• The research paper should be between 3 in length, not including reference and title page.
• Please provide peer-review references to substantiate your viewpoint. Note: Wikipedia and similar Websites do not qualify as quality resources.
• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. 
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment.

Task 2: Text Counter (USING JAVAFX)

Develop a class TextCounter that extends javafx.scene.text.Text and implements Runnable. Your layout should appear similar to the image below.  Next, develop a class IntCounter that has an integer counter intialised to 0, and methods incrementCount, getCount and setCount. 

For this application, create Start, Pause and Resume buttons. When Start is pressed, the counter starts from zero. When Pause is pressed, the counter pauses and displays the current count. When Resume is pressed, the counter continues from a paused state (or does nothing if the counter is already running). You should use Platform.runLater to implement the counter to ensure it updates correctly on screen. 

1). Using the Web or other resources, write a brief paper about RSA, its history, its methodology, and where it is used.

2). Send a brief message (ten words minimum) using the Caesar Cypher.

1. For this assignment, I want you to create a single, APA 7-compliant, Word document. To earn full credit, you must do the following:
   • Page 1 = 20 pts: Proper APA 7 Title Page (watch the video and see p. 31 in the Foundations text to help you create a perfect title page)
   • Page 2 = 60 pts (breakdown below): Simply answer the following questions
   • (1) What is your approved research question from the Brainstorming Research Question HW assignment? (5 pts) 
   • (2) What is the title of the research article you found? (5 pts)
   • (3) Does the article contain the methodology the researchers used to conduct the study/research? To get full credit, you must (a) name the methodology, (b) cut and paste the paragraph from the article that details the methodology, AND (c) highlight indicator words. (30 pts)
   • (4) Does the article contain findings or results of the research? To get full credit, you must (a) cut and paste excerpts from the article that detail the findings (go to Discussion section or at times Conclusion), AND (b) highlight specific words that detail the findings. (20 pts)
   • Page 3 = 20 pts: Create a proper APA 7 References Page with your ONE research article (refer to the video and see pp. 33-34 for the FORMAT you must use to create your reference and p. 32 for a perfect sample of what a References Page looks like.)

Write briefly on File Inclusion Vulnerability. What is it? Why is is dangerous? What is the difference of local File Inclusion (LFI) Vulnerability and Remote file inclusion (RFI) vulnerability? What methods can me employed to prevent a security breach (both LFI and RFI)? What programming languages are vulnerable to this type of attack. Write in 300 words and it should include all the points mentioned above. 

 Exp19_Excel_Ch12_ML2_Travel_Expense 

 Exp19 Excel Ch12 ML2 Travel Expense 

 Excel Chapter 12 Mid-Level 2 – Travel Expense 

Project Description:

You are a financial analyst for VJD Financial, a wealth management company with 10 offices located across the United States. Currently your traveling account executives send receipts through inner office mail to document their travel expenses. You want to create a template to standardize the documentation process. To minimize the amount of development time required, you will download and edit an existing template from Office.com. You will customize the template by editing fields, adding comments, and creating a custom function using VBA.

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

Select the range A1:J16 and   clear all data validation that was included in the worksheet.

Click cell B7 and type Mileage Rate. 

Click cell C7, click Align Left   in the Alignment group, and type .25.

Insert a column after column D.   Name the column Miles.

Use the VBA Editor to create a   custom function named Mileage. Type the following code to create the custom function.
 

Function   Mileage (Miles,Rate)
 

‘Creates   custom Mileage function
 

Mileage   = Miles * Rate

Exit the VBA Editor and click   cell F11. Type =IFERROR(Mileage(, click cell E11, type , and then click cell C7. Press F4, and type ), 0). Press ENTER to complete the   function. 

Click cell E10 and add the   comment Enter miles driven. 

Insert a new worksheet named Code.

Open the VBA Editor, open module   1, and copy the code. Paste the code in the Code worksheet starting in cell   A1.

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

8 WEEK COURSE

YOU WILL BE LOGGING  IN FOR EACH  WEEK MODULE 

I HAVE COMPLETED THE FIRST WEEK 

You have to work on a final research proposal which should have min 20 to 25 pages and I will be attaching the files in which the details and requirements are there. taking those as the resources, please work on it. I have the format and an example which you need to work on it should be APA format.

I have uploaded enough information. There are some links in the Literature review. you can use some more references of your when search but paste them at last. 

One help from your side is that, please keep an example of a research proposal besides and work on it. 

GO19_AC_CH02_GRADER_2G_AS – Concerts And Sponsors 1.0

GO19_AC_CH02_GRADER_2G_AS – Concerts and Sponsors 1.0

Project Description:

In this project, you will use a database to answer questions about concerts in the local college area. You will create a relationship between two tables, create a query from an existing query, and create queries using text, numeric, compound, and wildcard criteria based using the fields in one or both tables. You will create calculated fields, group data when calculating statistics, create a crosstab query, and create a parameter query.

Steps to Perform:

Step

Instructions

Points    Possible

1

Start Access. Open the file Student_Access_2G_Concerts_Sponsors.accdb   downloaded with this project.

0

2

Using Sponsor ID   as the common field, create a one-to-many relationship between the Sponsors   table and the Concerts table. Enforce referential integrity and enable both   cascade options. Create a relationship report with normal margins, and save   it as a3 Relationships. Close all open objects.

20

3

In the last record of the Sponsors table,   change the Sponsor ID from SPONSOR-108   to SPONSOR-100, and then close the table. (The related records in the Concerts table   will automatically update.)

2

4

Copy the   Concerts $1000 or More Query to create a new query with the name Jan-Apr Concerts Query. Redesign the query to answer the question, What is the Date, Concert   Name, Concert Location, and Box Office Receipts for concerts between 1/1/22 and 4/30/22 sorted in ascending order only by the Date field? Run the query (five   records display). Close the query, saving the changes to the query.

20

5

Create a query in Query Design view based   on the Concerts table to answer the question, What is the Date, Concert Name,   Concert Location, and Box Office Receipts for a concert location of Georgetown Community Theater or Austin City Center and for box office receipts that have an amount that is greater than 1000 sorted in ascending order by   the Date field? Run the query (four records display). Save the query as GCT OR ACC Over $1000 Query, and then close the query.

20

6

Create a query   in Query Design view based on both tables to answer the question, What is   the Sponsor Name, Concert Name, and   Concert Location for a sponsor name that has radio anywhere in its name and for a concert name that ends in festival sorted in   ascending order by the Concert Location field? Run the query (two records   display). Save the query as Radio Festivals   Query, and then close the query.

20

7

Create a query in Query Design view based   on the Concerts table to answer the following question, What is the Concert   ID, Concert Name, Concert Location, Sponsor ID, and Date for records that are   missing the date? Run the query (two records display). Save the query as Missing Concert Date Query, and then close the query.

20

8

Create a query   in Query Design view based on both tables to answer the question, What is the   Concert ID, Sponsor Name, Box Office Receipts, and a new field named Sponsor Donation that will   calculate and display the donation amount when the Sponsor donates an amount   equal to 50 percent (0.5) of each box office receipts amount to the Music Department. Sort the   records in ascending order by the Concert ID field. a. Run the query (the   second record—EVENT-102—has a Sponsor Donation of 287.5).

20

9

Display the query in Design view. In the   fifth column of the design grid, create a new field named Total Donation that will   calculate and display the total donation when the box office receipts amount   is added to the sponsor’s donation amount. Run the query (the second   record—EVENT-102—has a Total Donation of $862.50).

6

10

Display the   query in Design view. Use the Property Sheet to format the Sponsor Donation   field as Currency with 2 decimal places, and then close the Property Sheet.   Run the query, apply Best Fit to the fields, save the query as Sponsor Donation Query, and then close the query.

12

11

Create a query in Query Design view based   on the Concerts table to answer the following question, What are the total   Box Office Receipts by Concert Location sorted by the Box Office Receipts   field in ascending order? Use the Property Sheet to format the Box Office   Receipts field with 0 decimal places, and then close the Property Sheet. Run   the query (for the Concert Location of Georgetown Community Theater, the sum   of the box office receipts is $7,850). Apply Best Fit to the fields, save the   query as Receipts by Location   Query, and then close the query.

20

12

Use the Query   Wizard to create a crosstab query based on the Concerts table with the   Sponsor ID field as row headings and the Concert Location field as column   headings. Sum the Box Office Receipts field, and name the query Sponsor and Location Crosstab Query. Display the query in Design view. Use the Property Sheet to format   the last two columns with 0 decimal places. Run the query, apply Best Fit to   the fields, save the query, and then close the query.

20

13

Create a query in Query Design view based   on the Concerts table to answer the following question, What is the Concert   Name, Concert Location, Box Office Receipts, and Sponsor ID. Sort the records   in ascending order by the Concert Name field? Set the criteria so that when   you run the query you are prompted to Enter   the Sponsor ID in the format SPONSOR-###. Run the query,   and when prompted, enter SPONSOR-101 as the criteria (six records display). Display the query in Design   view and hide the Sponsor ID field from the results. Run the query again,   entering SPONSOR-101 when prompted. Save the query as Sponsor   ID Parameter Query, and then close the query.

20

14

Save and close the database, and then submit for   grading.

0

Total   Points

200