What resources can you find to help with the project’s task of using PHP and inserting data into MySQL? Please use this area to share at least 2 resources with a quick summary of each.In addition, as you work through the assignment, what issues have you run into? What are you stuck on? What questions do you have to move you forward? 

Payroll Lab

You will be taking in a file (payroll.txt) which details a number of departments (at least 1) and in each department are a set of employees (each department will have at least 1 employee or it would not appear on the payroll sheet). Your job is to read the file in separate out each employee and calculate the total values (hours, salary, number of employees) for each department and in each category (F1, F2, F3, F4). In your final submission please include the .cpp file which should work for any kind of payroll file I supply (which will naturally match the format of the examples below). Be sure to indicate in your submission text if you have attempted any of the bonus points .

An example file:

The IT Department
Bill 8 7 8 9 7 F1
Bob 205103 0.08 F3
Betty 8 8 7 8 8 F2
Brandon 10 10 9 6 9 F2
Brad 9 8 10 9 9 4 1 F4

The Sales Department
Kyle 88840 0.105 F3
Tyler 105203 0.085 F3
Konner 8 6 7 6 9 F2
Sam 309011 0.045 F3
Kent 9 8 9 9 9 0 0 F4
EOF

An additional example file:

The Sales Department
Mike 5 6 1 3 5 F1
Mark 98103 0.115 F3
Jill 8 8 8 8 8 F2

Frank 106101 0.095 F3

Mark 76881 0.091 F3

Department of Records
Konner 8 6 7 6 9 F2
Tammy 7 3 7 2 8 F1

Anika 8 8 8 8 8 F2

Marta 1 0 0 5 2 F1
Kent 9 8 9 9 9 0 0 F4
EOF

Last in the row after the hours comes the pay grade (F1, F2, F3, F4). The number of hours recorded is based on the pay grade of the employee. F1 and F2s will have 5 numbers for their hours. F3s are commission based where a sales amount and a commission percentage is given. F3s are also assumed to work 30 hours if their commission is 10% or below and 40 hours if their commission is above 10%. F4s will have 7 numbers (as they are on-call during the weekend). Each of the pay grades will also have different pay calculations which are as follows:

F1 = The total number of hours * 11.25
F2 = (The total number of hours – 35) * 18.95 + 400
F3 = The total sales amount * the commission rate
F4 = The first 5 hourly totals * 22.55 + Any weekend hourly totals (the last 2) * 48.75

Your output to the screen should start with the department name, followed by the total pay for all of the employees, then the total number of hours, and the total number of employees. After that you should have a breakdown of each category of employee: F1 total pay and total hours, F2 total pay and total hours…

Each department will have at least 1 employee and each department will contain the word “Department.”

The IT Department
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##
Roster: Bill, Bob, Betty, Brandon, Brad 

F1:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F2:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F3:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F4:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

The Sales Department
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##
Roster: Kyle, Tyler, Konner, Sam, Kent

F1:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F2:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F3:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F4:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

Before coding your solution, take the time to design the program. What are the possible things that the file can have that you need to anticipate? What are the actions that you need to take (read the file, add up hours…)? Are those actions things that could be placed in separate functions? What about the function – can you guess some of the things that will happen? Such as, using substring to pull out part of a line in the file maybe using stoi to convert a string to an integer to add it to the total or creating variables to hold the employee type you find before passing it to another function. Finally, how are these functions called, what is the order and what information is passed to and from? 

Scoring Breakdown

25% program compiles and runs
30% program reads in and calculates the figures for output
10% the program is appropriately commented
35% outputs the correct information in a clear format 

5% bonus to those who can output the F# responses in a columned output like that shown above.

5% order the employees in the roster according to their F status, F1’s first, then F2’s and so on.
5% bonus to those who do a chart comparing the data at the end to show the relation between the pay grades and the amount of salary spent in each (they style of chart is up to you and more points may be given for more difficult charts (like a line chart):

B Department
F1 – 00000000
F2 – 000000
F3 – 00000
F4 – 000000000000 

K Department
F1 – 0
F2 – 0000
F3 – 0000000000
F4 – 0000000 

Or event something like this instead:

0
0 0
0 0 0
0 0 0 0
0 0 0 0
F1 F2 F3 F4

Given the following code:

05 IMPATIENS-COLOR PIC 9.

88 RED VALUE 1.

88 PINK VALUE 2.

88 ORANGE VALUE 3.

Write the EVALUATE statement to validate this input.

Write the code to count the number of occurrences of the digit 6 until the first space is encountered in ITEM. Use A-COUNT as the storage parameter.

Write the PROCEDURE DIVISION code segment to sum all the numbers from 1 through 100. Use an in-line PERFORM UNTIL.

Write the PROCEDURE DIVISION code segment to sum all the numbers from 1 through 100. Use a PERFORM paragraph-name ..TIMES.

Given the following code:

MOVE 10 TO NUM

MOVE 1 TO TOTAL

PERFORM 200-TOTAL-RTN 5 TIMES

…

200-TOTAL-RTN.

MULTIPLY TOTAL BY NUM

DISPLAY TOTAL..

a) Recode this using an in-line PERFORM N TIMES.

b) What is output?

How do you create an object of a class, in COBOL?

Write the code to test if ITEM contains both letters and numbers.

Assignment 1: 

Biometric System Evaluation

Learning Objectives and Outcomes

Ø Identify the correct advantages of each biometric method

Ø Identify the correct disadvantages of each biometric method

Assignment Requirements

Read the attached worksheet named “Biometric System Evaluation” and address the following:

Using what you have learned about the biometric method, identify the correct advantages and disadvantages of each listed biometric type.

Requirement: 

· ****Separate word document for each assignment****

· Minimum 300-350 words. Cover sheet, abstract, graphs, and references do not count.

· Add reference separately for each assignment question.

· Strictly follow APA style. Length – 2 to 3 paragraphs. 

· Sources: 2 References to Support your answer

· No plagiarized content please! Attach a plagiarized report.

· Check for spelling and grammar mistakes!

· $5 max. Please bid if you agree.

Assignment 2: 

How data mining is useful in Financial Industry. What are its benefits and how data mining can help Financial Industry in future?

Requirement: 

· ****Separate word document for each assignment****

· Minimum 350-400 words. Cover sheet, abstract, graphs, and references do not count.

· Add reference separately for each assignment question.

· Strictly follow APA style. Length – 2 to 3 paragraphs. 

· Sources: 2 References to Support your answer

· No plagiarized content please! Attach a plagiarized report.

· Check for spelling and grammar mistakes!

· $5 max. Please bid if you agree.

Assignment 3: 

Select any one data analytics tool from the below list. Provide the benefits and limitations of the tool.

Ø SAS FORECASTING

Ø Power BI

Ø Tableau

Ø TALEND

Ø PYTHON

Ø R PROGRAMMING / R-STUDIO

Ø DATAPINE 

Please include the Data Analytic Vendor Name and URL. It will also be helpful to list the pricing and trial options.

Requirements:

· ****Separate word document for each assignment****

· Minimum 300-350 words. Cover sheet, abstract, graphs, and references do not count.

· Add reference separately for each assignment question.

· Strictly follow APA style. Length – 2 to 3 paragraphs. 

· Sources: 2 References to Support your answer

· No plagiarized content please! Attach a plagiarized report.

· Check for spelling and grammar mistakes!

· $5 max. Please bid if you agree.

 Describe the plain view doctrine, and why  it has such a significant impact on digital forensics? What are three approaches to determining whether the doctrine applies to a specific case. 

Chapter 5, Exercise #6  with Visual Logic.

The Jumpin’ Jive coffee shop charges $2.00 for a cup of coffee and offers the add-ins shown in Table 5-3. 

Product                                              Price ($) 

Whipped cream                                0.89

Cinnamon                                         0.25

Chocolate sauce                              0.59 

Amaretto                                         1.50

Irish whiskey                                   1.75

Table 5-3 

Add-in list for Jumpin’ Jive coffee shop Design the logic for an application that allows a user to enter ordered add-ins continuously until a sentinel value is entered. After each item, display its price or the message: “Sorry, we do not carry that as output” when an invalid item is entered. After all items have been entered, output the total price for the order. 

https://owl.purdue.edu/owl/general_writing/visual_rhetoric/data_visualization/index.html

and

https://owl.purdue.edu/owl/general_writing/visual_rhetoric/data_visualization/activity.html

Review the 2 links above.

Respond with an example of your choice that illustrates the 3Es of visualization (effective, ethical, and efficient) as outlined in the materials. Include the graphic in your response.

Explain the reasons for your choice. Also discuss other options you discarded. Your original analysis must be substantive and represent at least 50% of your response.

Note:  Please perform your own research and refrain from copying visualizations from sites where the author has already chosen a visualization and discussed it from this perspective. 

Assignment Content

1.  Measuring progress and requirements in a project can be completed through performance testing. As you review the results, it leads to ways to maintain the project progress. In this week’s assignment you will develop requirements that need measurable results through performance testing. Review the scenario and complete the activity below.

   The Recreation and Wellness Intranet Project team is working hard to ensure that the new system they develop meets expectations. The team has a detailed scope statement, but the project manager, Tony Prince, wants to make sure they’re not forgetting requirements that might affect how people view the quality of the project. He knows that the project’s sponsor and other senior managers are most concerned with getting people to use the system, improve their health, and reduce healthcare costs. Users want the system to be user-friendly, informative, fun to use, and fast.

   Complete the following in a Microsoft Word document.

   Develop a list of 6 quality standards or requirements related to meeting the stakeholder expectations described in the Running Case. Organize your paper so I can clearly see each standard and its description. Use a list format or a table. Avoid cramming your entire list into one long paragraph (bad idea!)

   Write a brief description of at least 45 words for each requirement. For example, a requirement might be that 90 percent of employees have logged into the system within two weeks after the system rolls out. Think of these requirements as the traits you would expect from a quality system. If this were a food ordering app, for instance, you would want it to have a useful interface, a long list of restaurants to choose from, different payment options, and so on. You can think of these as “requirements” in this case.

   Write an explanation of at least 175 words based on the list of standards and requirements on how you will measure progress on meeting the requirements. This explanation should come after the list above. Avoid trying to incorporate the explanation into the list. For example, you might have employees log into the system as part of the training program and track who attends the training. You could also build a feature into the system to track usage by username, department, and other criteria. Support your answer with at least one credible source outside of the course materials. The more sources (References), the better.

   Submit your assignment. 

 Convert User Input to an Array of KivaCommands

The  RemoteControl class currently takes in a String of commands from the  user that looks like “FFFTRF”. However, our Kiva robots cannot  understand instructions in that form. They can simply make one move at a  time, accepting a single KivaCommand. So, we’ll need to take the user  inputted commands and convert them into a more Kiva friendly format, a  list of KivaCommands that we can send to the robot’s move method one at a  time. 

Write the Convert Method Using continue and/or break

Create  a helper method in the RemoteControl class called  convertToKivaCommands(). This method should take a String as a  parameter, which will be the commands that the user types into the  console (for example “FFFTRF”). It should return an array of  KivaCommands (in this case FORWARD, FORWARD, FORWARD, TAKE, TURN_RIGHT,  FORWARD). We recommend doing this by using the values() method of the  KivaCommand enum to get an array of all of the KivaCommands. You can  then use the getDirectionKey() method to determine which KivaCommand  each char in the String should be converted to. If the user enters a  character that does not correspond to a command throw an  IllegalArgumentException with a useful error message.

Note: When  you want to print out the contents of a KivaCommand[] array variable  called commands, for example, you would call Arrays.toString(commands)  to turn the array into a single String. You’ll need to import  java.util.Arrays to use this method. Here is some sample code that you  can play with in BlueJ to demonstrate this, then use the approach for  your needs:

 2. How digital or social media has transformed the communication of an idea, information, and arguments in society.
3. Access, analyze, interpret, and evaluate digital media to foster learning and to guide decision-making.
4. Make responsible choices in the creation and consumption of digital media based on awareness of global, social,