Title: Preliminary Investigation and System Requirements (total of 4-8 pages)

A Preliminary Investigation and System Requirements for your proposal will be due at the end of Week 4. This is normally two different documents but due to the length of the course we will combine them.

Please use the template below as it lists the parts that are graded.

1. General Information 50

• Company profile
• Business situation
• Problem or Opportunity
• Project Scope and Constraints
• Perform Fact-Finding
• Copy of a survey or interview questions.
• Diagram current processes. –

1. Requirements 40

• List of Requirements

1. General Format and Grammar 10

***IMPORTANT NOTE***
For this requirement you needed to show
1) Current Processes
2) Requirements.
These are two different things. Note that in the PIR, both of these combined are worth more than 50% of the grade. So, it’s important that you get this down.

For the Current Processes, you needed to show the following details for each process:
a) Process name
b) Input
c) Process
d) Output

See below for an example.

For Requirements, you needed to show a bulleted list of what you want the system to have in the form of “The system mush have…”, or “The system shall have…”.

Example: You need to make sure each section has appropriate information.
+ It’s important to properly name a process. Use the Verb_Noun format where the Verb shows what happens to the Noun e.g. Print_PayrollChecks.
+ In the “Input” section you need to show what goes into the “Process” section. You don’t include any logic in here. Just show what goes in. Avoiding using “verbs” since these show “action” i.e. “process”.
+ The “Process” section shows what happens to the input sent through the “Input” section. Think of this section as the place where things happen. You need to show the steps that get carried out to show the process. If you think of a meat grinder as the process, the input=”meat”, the process=”employee place meat in a grinder. The grinder is a machine that has a cylinder which rotates in metal chamber and grinds product sent through. employee rotate handle. Ground meat comes out of grinder”, and output=”ground meat”
+ The output section is similar to Input, but here we show what comes out of the “Process”. No activity shown here i.e. do not use any verbs.

Format
All components of the double spaced paper must have one inch margins (left, right, top and bottom) and be written in 11 or 12 pitch, Arial or Times New Roman font. 4-7 pages in length.
Name your file LastnameFirstnameProposal (eg., MeyerGregProposal) and upload it to the Assignment section of the classroom. Be sure to check the “Submit for Grading” box when uploading and submitting your file 

Your father has a private retail pharmacy in a small rural town. He accepts credit cards and holds customer information on a small database server. He wants to know if he should be concerned about PCI compliance, as well as HIPAA, and has asked you for a summary so he can decide if he wants to hire an outside consultant to help him comply with government regulations.

Write a 3- to 4-page summary in Microsoft® Word of the important aspect of PCI and HIPAA regulations to help him make his decision. In your summary:

• Accurately describe what PCI is and why it is important to a small business.
• Explain why a small business needs to comply with PCI. Provide at least two reasons.
• Outline the ramifications of noncompliance to a small business. Provide two examples.
• Concisely describe who is covered under HIPAA.
• List the information protected under HIPAA.
• List the administrative requirements under HIPAA.

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

It is so important to have good communication with a project’s stakeholders.

• What happens if the project manager and team maintain clear current communication with the key stakeholders?
• What can happen if the project manager and team have poor and sparse communication with the key stakeholders?

Use project examples from personal experience or research to justify your responses. Cite all sources. Additionally, please respond to two other classmates’ posts. 

Instructions are attached to the document.

Write a python or perl program that generates the inverted 

index of a set of already preprocessed files. The files are stored in a 

directory which is given as an input parameter to the program. Use the files

preprocessed in the previous assignment(s) as test data. Use raw term 

frequency (tf) in the document without normalizing it. Think about saving the generated index, including the document frequency (df), in a file so that you can retrieve it later.

 Locate an article on a system breach (Target stores, Sony Pictures, US Government, and many more). briefly explain the situation and what kind of information was compromised. How large was the breach and how long did it take to find the problem. Include a link to any of your Internet resources. 

Part 1 – Paraphrasing

Paraphrase the two short paragraphs below using the techniques we learned in class (week 11 course pack / week 10 slides). DO NOT FORGET to cite the original author (Last name, Year) after your paraphrase from the reference information below.

Reference:

Wild, F. (2019, April 10). What Is Robonaut? NASA. https://www.nasa.gov/audience/forstudents/5-8/features/nasa-knows/what-is-robonaut-58.html

Paragraph 1 (2 points): Robonaut is a NASA robot. Engineers designed Robonaut to be humanoid, which means it is built to look like a person. This makes it easier for Robonaut to do the same jobs as a person. Robonaut could help with anything from working on the International Space Station to exploring other worlds.

Your paraphrase: 

Paragraph 2 (2 points): Robonaut can function in two ways. Software allows Robonaut to “think” for itself. The people who control R2 can give it a simple task to do and R2 can figure out how to do it. R2’s software can be updated to allow it to do new tasks. R2 can also be operated by remote control. An operator can use a headset to see what Robonaut sees through its cameras.

Your paraphrase:

Part 2 – Quoting (1 point)

Use the 5 parts of a quote (course pack week 11 pg. 59, and week 10 slides) to quote the underlined sentence from the paragraph below. (Use the same reference information from part 1, there is no page number)

Original Text: NASA is still deciding what the future holds for Robonaut. Robonaut will conduct more tests aboard the space station, and may even take its first steps. This testing would determine how well Robonaut could move around spacecraft environments to help astronauts. Robonaut’s designers even have ideas for sending a robot like Robonaut to future destinations like the Moon and Mars. If testing goes well, who knows where Robonaut—or a better robot based on Robonaut—could end up?

Your quote: 

Exp19_Excel_Ch10_HOEAssessment_Pledge_Drive

Exp19 Excel Ch10 HOEAssessment Pledge Drive

Excel Chapter 10 Hands-On Exercise Assessment – Pledge Drive

Project Description:

You are a volunteer for Health Right, a nonprofit company that provides free physical fitness classes to schools that do not have a physical education facility. As part of your duties, you generate weekly reports that detail donation pledge calls placed, as well as pledge dollars received. You also maintain pledge drive agent personal information and manage the thank-you gifts agents receive for volunteering their time. This week you have decided to overhaul your report by updating agent contact information, importing data previously stored outside your old report, implementing a PivotTable using Power Pivot, and utilize Power-Add-Ins to edit and visualize the week’s data.

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

Use Get & Transform (Power   Query) to load the file e10c2VolunteerInfo.csv   in the Power Query Editor. Use the Power Query Editor to split column D into   three separate columns for City, State, and Zip using comma as the delimiter.   Edit the city.state.zip1 column heading to City, city.state.zip2 to State, and city.state.zip3 to Zip then load the data to the   existing worksheet.

Rename the worksheet Volunteer   Information.

Set the External Data Range   Properties to Refresh data when opening the file.

Use Get & Transfrom (Power   Query) to load the Pledge table from xml file e10c2Rewards.xml into a new worksheet. Be sure to add the   information to the data model.

Rename the worksheet Rewards.

Apply Accounting Number Format   to the dollar amounts imported into column A.

Use Get & Transform (Power   Query) to load the Contacts table from the file e10c2Contacts.accdb in the Power Query Editor. Use the Power   Query Editor to remove the Income and Dependents fields then load the data in   a new worksheet. 

Rename the worksheet Pledge Leads.

Use Power Pivot to import the   Transactions table from the Access database e10c1PledgeDollars.accdb into a PivotTable. Place the PivotTable   on a new worksheet named Pledge Dollars. Add the Date field to the Filters area, add   Operator_ID to the Rows area, and add Pledge_Amount to the Values area. Save   the workbook.

Create a relationship between   the Operator_ID in the Transactions table and the Operator_ID in the   Volunteer Information worksheet.

Insert a 3D Map (Power Map)   using the Volunteer Information zip code (Zip) as the location dimension,   Pledge_Amount as the height dimension, and Operator_ID as the category   dimension. Zoom the plot area as needed to display results.

Save and close the file. Submit Exp19_Excel_Ch10_HOEAssessment – PledgeDrive.xlsx   as directed.

Assigned Readings:Chapter 5. Personality and ValuesInitial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.Also, provide a graduate-level response to each of the following questions:

1. Describe the Big Five personality dimension of emotional stability and discuss how it can predict behavior at work.

Title: Essentials of Organizational Behavior, Student Value Edition 

ISBN: ISBN-13: 9780135468890 

Authors: Stephen P. Robbins, Timothy A. Judge 

Publisher: Pearson 

Edition: 15TH