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

Lab and assignment help

Write a 750 word response  to the topic: “Suggest some of the advantages and disadvantages of building a system from the ground up. If given a choice between a packaged solution and building one from the ground up, which would you choose? Defend your choice.”

• Use APA style writing as well as examples in the book for your projects

Reading material and Textbook:

Essentials of Systems Analysis and Design – Valacich/George/Hoffer, 6th edition, Pearson.  

Chapter 2: The Sources of Software – Where does a professional unearth the software pieces needed for a business application system? Discover the six sources of software that are available and the criteria used to evaluate software.

Chapter 3: Managing the Information Systems Project – Explore project management skills needed to run all technical and managerial functions of a systems project. Discover how commercial software can help in the critical path scheduling process.

Class Project: Database management systems are key element of information technology systems that are used on a day-to-day basis by many organizations. The keys to using a database management system are to collect the necessary requirements for the database, translate these requirements into a database design, create the database from the design, load data into the database, and finally to perform manipulations of the database. The purpose of this final assignment is to ensure that you understand and can carry out the necessary tasks in order to manage a sample database.

From a high-level standpoint, this final project consists of the following steps:

1. Selection of a database.

2. Identifying the requirements for the database based on the purpose for the database and the data to fill the database.

3. Create a database design based on the requirements for the database, create the physical database, and load data into the database.

4. After loading the database, carry out sample queries that would be performed on the actual database. Show the results of the sample queries.

This project will consist of a series of steps defined in the prompts of the assignment. Some of the prompts are necessary to properly prepare for the manipulation of the database whereas others will be necessary for you to complete to demonstrate your competence with the concepts of this topic. The answers to these prompts will be examined against the actual expected answers to the prompt. All prompts that will be assessed against a answer key, meaning that you will get either full, partial, or no points per prompt.

   You will need to access it by going to Testout.com and look for the customized exercise.

This exercise is timed and it is open book exercise.

Exp19_Excel_Ch05_ML1_RealEstate

Project Description:

You are a real estate analyst who works for Mountain View Realty in the North Utah County area. You have consolidated a list of houses sold during the past few months and want to analyze the data. For a simple analysis, you will outline the data and use the Subtotal feature. You will then create two PivotTables and a PivotChart to perform more in-depth analysis.

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

Before subtotaling the data, you   want to calculate the selling price as a percentage of the asking price.
 

  In cell G2 in the Sales Subtotals sheet, insert a formula to calculate the   selling price percentage of the asking price, format it with Percent Style   with one decimal place, and then copy the formula down the column.

Real estate agents often analyze   how long houses are on the market. You will calculate the number of days   between the listing date and the sale date.
 

  In cell J2, enter a formula to calculate the number of days between the   listing date and sale date. Copy the formula down the column.

You are about ready to subtotal   the data. First, you will sort the data.
 

  Sort the list by City in alphabetical order, then by Selling Agent in   alphabetical order, and finally by Listing Date in chronological order   (oldest to newest).

You want to display subtotals   for three columns to analyze the averages.
 

  Use the Subtotal feature to calculate the average selling price, percentage   of asking price, and days on market by city. Ensure that Summary below data   is selected, and then click OK. Group the data using the Auto Outline   feature. Collapse the outline to hide the listing and sale dates. Click the   outline symbol to display the grand average and city average rows only.

Now you are ready to format the   data and set a print area to print only a select portion of the worksheet.
 

  Format the average days on market as numbers with zero decimal places. Apply   wrap text in cells G1 and J1. Set a print area for the range C1:J88.

Select individually columns G   and J and change the column width to 10. Change the row height to 24 for the first row.

Go to cell C101, read the   questions, and type the correct answers in the respective highlighted cells   in the range G102:G106. Do not copy and paste results from the subtotal rows.   Type the numeric values rounded to the nearest whole number.
 

  Apply Accounting Number Format with zero decimal places to cell G102.

PivotTables help you analyze   different perspectives of data. You will create a PivotTable using the Sales   Data worksheet.
 

  Click the Sales Data worksheet and create a blank PivotTable on a new   worksheet. Name the new worksheet PivotTable. Name the PivotTable Average City Prices.

Part of the process is arranging   and rearranging fields to provide the perspective to represent the data best.   In addition, you want to display average values instead of total values.
 

  Place the City field in rows, the Selling Agent field in columns, and the   Asking Price and Selling Price fields as values. Display averages rather than   sums with Accounting Number Format with zero decimal places. Pivot the data   by placing the City field below the Values field in the Columns area and   moving the Selling Agent field to the Rows area.

Now you want to focus on real   estate data for only two cities.
 

  Add a filter to cell B3 to display only Alpine   and Cedar Hills.

Go back to the Sales Data   worksheet. You realize that a selling price is incorrect.
 

  Change the selling price for Number 40 from $140,000 to $1,400,000. Refresh the PivotTable.

You want to format the   PivotTable.
 

  Change the widths of columns A, B, C, D, and E to 11. Change the width of column F to 14 and the width of column G to 13.14. Wrap text and center   horizontally data in cells B4, D4, F4, and G4. Apply the Bottom Border to the   range B4:E4. Change the label in cell A5 to Agent. Change the height of row 4 to 40.

You want to create another   PivotTable to look at the selling prices by city.
 

  Display the Sales Data worksheet. Create a Recommended PivotTable using the   Sum of Selling Price by City thumbnail.
  Note, Mac users, insert a PivotTable on a new worksheet. Add City to the Rows   area and Selling Price to the Values area.
 

  Change the name of the new PivotTable worksheet to Selling Price.

Change the value to display   averages not sums. Apply the Accounting Number Format with zero decimal   places to the values. Apply Light Blue, Pivot Style Medium 2 to the   PivotTable.
 

  Note, depending upon the version of Office being used, the style name may be   Pivot Style Medium 2.

You decide to create a   PivotChart to illustrate the PivotTable data visually.
 

  Create a clustered column PivotChart from the PivotTable on the Selling Price   worksheet. Move the chart to a chart sheet named Sales Chart.

The chart should have a   meaningful title. You will also modify some chart attributes.
 

  Change the chart title to Average Selling Price by City and apply Dark Blue font color.   Remove the legend. Apply Dark Blue fill color to the data series.

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 of all worksheets. Adjust the Page Setup scaling, if   needed.

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

 Page 1 of 4 Microsoft Word Project Purpose The purpose of this assignment is for students to use various sources (both print and online) to research a technology-related issue. Students will then write a paper in Microsoft Word that further describes the issue and communicates the student’s position. Content Requirements Search the Internet for a current technology-related issue/debate. An example of one, which you cannot use for the project, might be whether it’s right or wrong for potential employers to require applicants’ Facebook credentials so that they can peer into their personal lives. This paper should:  contain a title page including your full name, title of paper (which you can choose), course and lab section number, lab instructor’s name, and the date  include at least four pages of text-based content (this does not include any images, tables, or other visual (non-text) elements. This content should: o introduce the technology-related issue you are writing about, as well as the Web site address of the article you found introducing this issue o describe, in your own words, why the issue is important to you and how it might relate to your everyday life o Describe how you feel about the issue o include information from at least two additional sources (for a total of three) that provides additional information about the issue  include at least one image in your document (either a photo or clipart) that helps explain a point in your paper or clarify a difficult concept. Please note that the space this image occupies in your paper does not count toward your four-page text-based content requirement  include a table to help convey additional information about your chosen issue/topic (for example if there are arguments for and against your chosen issue, you might have one column containing arguments for the issue, and another column containing the arguments against the issue). Please note that the space this table occupies in your paper does not count toward your four-page text-based content requirement  include a SmartArt illustration of your choice that visually conveys information presented in your paper. Please note that the space this diagram occupies in your paper does not count toward your four-page text-based content requirement  include citations, where appropriate, for content you pull from other sources  include a Works Cited (or Bibliography) page that lists your minimum of 3 legitimate sources. If you use your textbook at all, include your textbook as one of your sources Page 2 of 4 Technical Requirements In addition to meeting the content requirements for this assignment, you also will need to demonstrate your proficiency of Microsoft Word by applying the following formatting. These instructions are designed to be completed in order; completing them out of order may make it more difficult to perform certain instructions.  Apply a page border of your choice to the title page  Center-align all text on the title page  Change the default font, font size, and font color for the text on the title page to make your paper appear inviting  The content of your paper should start on the page immediately following the title page. The title of your paper should appear again at the top of the first page of content (second page of your Word document), and formatted with the Title style.  Verify that the text in the content portion of your paper is formatted with the Times New Roman font, 11-point font size, and a black font color  Text should be double-spaced, and a 0.4” first line indent should be applied to all paragraphs  All pages in the document should have top and bottom margins of 1”, and the left and right margins each should be 0.90”  Each page (with the exception of the title page) should contain a right-aligned header containing your last name, followed by a space, and then the current page number  Each page (with the exception of the title page) should contain a center-aligned footer containing the title of your paper  Include a bulleted list and a numbered list, where appropriate (you should have two separate lists – one that is numbered and one that is bulleted)  Apply a picture style of your choice to each image in the document  Change the style (SmartArt Style) and color of the SmartArt diagram to something other than the default. The color of the SmartArt diagram should match the color(s) you used on the title page  Citations should be cited either using the latest version of MLA or the latest version of APA. Include a Works Cited (or Bibliography) page that lists your sources. Use the tools on the REFERENCES tab to create, manage, and list your sources. In addition, use the appropriate tool to automatically generate the Works Cited (or Bibliography) page. Do not manually type and format this page.  Run a Spelling & Grammar check to make sure your document is free of spelling and grammatical errors  In the Properties for this document, make sure your full name appears in the Author property (if it does not, change it), and that the title of this paper appears in the Title property Page 3 of 4 Submission Guidelines It is important for students to pay close attention to the submission guidelines in order to receive full credit for this assignment.  Save the file as WordProjectLastNameFirstName.docx (where LastNameFirstName should be replaced with your last and first name)  Close the file after saving it. Otherwise the file will not attach properly to the email message.  Submit the file to Blackboard. Important Notes  Start the assignment well in advance of the due date. Last minute problems on your end will not be an excuse for missing a deadline  Do not use anyone else’s work. After we receive all assignments, we will run them through an automated process to check for plagiarism. Any violations or any plagiarism will result in a zero on this assignment and possible further disciplinary action by the College. It is better to miss turning in an assignment (or to turn in an incomplete assignment) and receive a lower grade than to risk going through a Student Conduct review process  Using a Mac version of Microsoft Office is entirely at your own risk. If the Mac version does not allow you to perform certain steps outlined in this document, you will lose points for those steps  Please e-mail your instructors with any questions Rubric Criteria Available Points Title page includes a page border with the text center aligned 4 Contains the student’s name, title of paper, course, section #, lab instructor’s name, and date 6 The default font, font-size, and font-color have been modified for text appearing on the title page 6 Title appearing on page two should use the Title Style 4 Student’s last name and current page # appear in header: right-aligned 4 Title appears in footer: center-aligned and italicized 4 Textual content uses black, Times New Roman, 11 pt font 4 Text is double spaced with a 0.4″ first line indent 4 Top and bottom margins are 1″ and left and right margins are 0.90″ 4 Page 4 of 4 Includes a table presenting arguments relevant to the issue 10 Includes a bulleted list 4 Includes a numbered list 4 Contains a picture that has a picture style applied to it 4 Contains a SmartArt diagram where the style and color have been changed from the default (colors should match title page colors) 8 Contains a Works Cited page correctly formatted in MLA or APA 8 Paper is 4 pages long and addresses the technology related issue 12 Student relates the issue to their everyday life 10 Assignment not covering the instructed topic -100 Total Points 100 

 Write a Java program to perform that following tasks:

1. Create and populate a LinkedList using a one dimensional array.
2. Add 6 numbers to this LinkedList.
3. Search this LinkedList and find the smallest number.
4. Display the number you get from step 3.

After you are done, submit the source code with some screenshots. 

Assignment Expectations

You would need to demonstrate understanding of dynamic data structure in this program

Need help with the research paper.

5-6 pages

APA 

 Hi,

First Assignment
Mock Dissertation Chapter Three Methodology
Overview: In week 1, you selected a topic and developed a research question for that topic. Then, you developed a data gathering instrument to measure the question either quantitatively or qualitatively. Now that you have had the opportunity to read how scholarly methodologies are written, you will write a condensed 3-4 page methodology section for your research question using the required headings from the University of the Cumberlands Dissertation Handbook.  Like we discuss in class, each university has unique parameters for what they expect in chapter 3, so you may see papers from other universities that look slightly different. The importance here is to focus on the content, not necessarily the organization. This assignment will help determine your readiness to write a full-length chapter three.
Directions:
1. Review your notes from class on the different methodologies and instruments used to measure. Also, review the examples:
 Exceeds Expectations.docx
Finally, review the rubric:  Rubric for Methodology.docx
2. Develop a 3-4 page (more is fine) methodology section that includes the following:
Introduction
Research Paradigm (qualitative or quantitative) Notes: Choose Qualitative or Quantitative based on what methodology you plan to use for your actual dissertation. You may not choose to do both qualitative and quantitative (mixed-methods)  
Research- or project- Design
Sampling Procedures and
Data Collection Sources
Statistical Tests Summary (quantitative) OR Data Organization Plan (Qualitative). Notes:  If you chose a quantitative research paradigm, you must choose a quantitative statistical test summary option in this section. If you chose a qualitative research paradigm, you must choose the qualitative organization plan option in this section.  
3. Upload your methodology section to this assignment box. 

Second Assignment

Article review. Attached instructions for article review