Software -9A

 

Please read chapter 24 and review PP slides and IGU online library and reputable resources and discuss:

What is software standards? Importance and problems with Standards. Are you in favor or against standards? 

Lab exercise

   

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

RStudio and Big Data Assignment

 

Project Description:

The goal of this project is to perform data analysis using R. The techniques and
skills we have introduced in class will help you along the way.  

Datasets: Dataframes flights, airlines in the nycflights13 package. Other
data can be integrated when needed. 

In this project, you will need to read in the given dataset in RStudio and then
perform the following data analysis using R.
Part I. Reading in the dataset and basic analysis
Pat II. Visualizing relationships between pairs of variables
Part III. Manipulating/ joining/ transforming Data
Part IV. Summarizing data 

For each of the above four topics, please design 5 interesting questions/tasks,
run R commands to get the answers or complete the tasks.  
Sample Questions: Q1. What are the subjects of this dataset? Q2. How
many subjects are there? Q3. What type of variable is origin?Q4. What is
the most common origin? Q5. What is the minimum distance?  

Sample Tasks: T1. Produce a table to summarize the origin variable. T2.
Produce a bar chart of the origin variable. T3. Calculate the mean and standard
deviation of the distance variable. T4. Produce a histogram of the distance
variable. T5. Visualize the relationship between arr_time and sched_arr_time
using scatterplot.

Project Report  
The report should include but not limited to the following components.
1. Title and author(s).  
2. Project Description:

        -Give a brief introduction of the project goal.
       -Describe the basic information of the dataset.
3. Data Analysis and Results:

        -In this section, please document all the data
         analysis in the following four parts. For each part, document the
          following: specific questions/tasks; R commands you used to solve the
          problems/tasks; answers/results to the questions/ Running results of the
          commands (tables, figures, or values).
o Part I. Reading in the dataset and basic analysis
             §   Question/Task…
             § Commands…
             § Results…
o Part II. Visualizing relationships between pairs of variables
            § Question/Task…
             § Commands…
             § Results…
o Part III. Manipulating/ joining/ transforming Data
            § Question/Task…
             § Commands…
             § Results…
o Part IV. Summarizing data
              § Question/Task…
             § Commands…
             § Results…
 

2 to 3 paragraphs

 

Some organizations prohibit workers from bringing certain kinds of devices into the workplace, such as cameras, cell phones, and USB drives. Some businesses require employees to use clear or see-through backpacks when carrying personal items. What other devices might not be allowed in certain facilities, and why would they be restricted? The video on Google’s Data Center may give you some ideas to write about for this assignment.

Your written assignment should consist of 2-3 paragraphs.

Science and Engineering in Technology

New technologies may lead to a series of unintended consequences. However, fear of those consequences may slow changes that can be beneficial. However, fear may slow beneficial change. Jasanoff asserted we should combine the “can do” of science and engineering with the “should do” of ethical and political analysis (Winston & Edelbach, 2014). Take a specific example of technology and explain how these two have been or might be combined. 

Reference:

Winston, M., & Edelbach, R. (2014). Society, ethics, & technology (5th ed.). Wadsworth Cengage Learning.

Risk mitigation

 

Discuss web applications and risk to an organization. Include at least three examples of where web applications were compromised (such as the SQL injection hack at Qatar National Bank), and how security teams can assess and mitigate the relative risk of insecure web applications.

Your assignment should meet the following requirements:

  • 5-6 pages long, not including the cover page and reference page.
  • Conform to APA Style.
  • Support your answers with at least two current scholarly journal articles (not more than five years old). The Rasmussen Library is a great place to find resources.
  • Clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing. If you need assistance with your writing style and APA format, start with the Writing and APA guides at the Rasmussen Library.

Survey Paper

 Web analytics survey paper –  This report should be at least 4 pages (no more than 8 pages) and use APA format.  The title and references page does not count towards the page limit.  

You will select a topic on web analytics and provide a survey report. Remember, a survey report does not present your own primary research results but synthesizes existing information for many sources and produces an extensive literature review in the field. Your survey report should provide a good beginning point for anyone interested in starting research in this area.

TOPIC: DIGITAL MARKETING