This week’s journal articles focus on empowering leadership and effective collaboration in geographically dispersed teams, please answer the following questions:

1. How do geographically dispersed teams collaborate effectively?
2. Please find at least three tools on the market that teams can use to collaborate on a geographically dispersed team.  Please note the pros and cons of each tool. 
3. Based on the research above, note which tool you would select if you were managing the geographically dispersed team and why.

Be sure to use the UC Library for scholarly research. Google Scholar is also a great source for research.  Please be sure that journal articles are peer-reviewed and are published within the last five years.The paper should meet the following requirements:

• 3 pages in length (not including title page or references)
• APA guidelines must be followed.  The paper must include a cover page, an introduction, a body with fully developed content, and a conclusion.
• A minimum of five peer-reviewed journal articles.

Exp19_Excel_Ch12_HOEAssessment_To_Do_List

Exp19 Excel Ch12 HOEAssessment To Do List

Excel Chapter 12 Hands-On Exercise Assessment – ToDoList 

Project Description:

You have been named the new social director of your schools student government association. As part of your position, you organize, meetings, study sessions, and social gatherings. To help manage planning, you have decided to create an Excel template that can be reused each month. To complete this task you will download and edit a template from the template gallery. Automate the portions of the worksheet using the macro recorder and VBA, as well as inspect the document for compatibility and accessibility issues.

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

Select the range B2:I7. Click   the Data tab, click Data Validation, and click the Input Message tab. Click   Clear All to remove all data validation comments added by the template   creator. Click OK.

Delete column C.

Click cell B3, click the Review   tab, and click New Comment. Type the comment Enter Task. Using the previous method, add   the following comments to the corresponding cells.
 

  C3 – Enter   Status
  D3 – Enter   Start Date
  E3 – Enter   Due Date
  F3 – Enter   % Complete

Ensure the Developer tab is   enabled. Click cell B4. Click the Developer tab and click Use Relative   References in the Code group. Use the macro recorder to record a macro named DateStamp that inserts the current date   in the active cell. (Note, Mac users, Use Relative References is not   available on Mac).
  Hint: to insert the current date, press CTRL + :

Open the VBA Editor and insert a   new module. Enter the following code to create the reset procedure. Once the   code is entered, run the macro, and exit the VBA Editor.
  Note: To exit the VBA Editor, click File and select Save and return to Excel.   Alternatively on PC, press ALT+F11 or ALT+Q.
 

Sub   Reset()
‘Resets   To Do List
Range(“B4:H7”)   = “”
End   Sub

Insert a Form control button   with the caption Date Stamp spanning the cell C9 and assign the DateStamp   macro. Ensure that the button remains within the borders of cells C9.

Insert a Form control button   with the caption Reset spanning the Cell D9 and assign the Reset macro. Click cell B4   and press the Date Stamp button to insert the current date. Then click the   Reset button to test the functionality of the newly created form control   button. 

Use the Accessibility Checker to   check and identify accessibility issues. Use the Accessibility checker pane   to unmerge the range B2:H2 and change the Table style to White Table Style   Medium 1.

Select the range B2:H2, and   remove all borders. Select the range C2:H2, and apply the cell style Heading   1.

Select cell B2 and apply the   cell style Heading 2.

Insert a new worksheet named Code.

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

Open the VBA Editor, open   Module2, and copy the code. Paste the code in the Code worksheet starting in   cell A10.

Save and close Exp19_Excel_CH12_HOEAssessment_ToDoList.xlsx   as a macro-free workbook (.xlsx).   Exit Excel. Submit the file as directed.

Question 1: Non-recursive In-order traverse of a binary tree

Using Stack is the obvious way to traverse tree without recursion. Below is an algorithm for traversing binary tree using stack. See this for step wise step execution of the algorithm.

1) Create an empty stack S.

2) Initialize current node as root

3) Push the current node to S and set current = current->left until current is NULL

4) If current is NULL and stack is not empty then 

     a) Pop the top item from stack.

     b) Print the popped item, set current = popped_item->right 

     c) Go to step 3.

5) If current is NULL and stack is empty then we are done.

Let us consider the below tree for example

           1

          /   

        2      3

      /  

    4     5



Step 1 Creates an empty stack: S = NULL



Step 2 sets current as address of root: current -> 1



Step 3 Pushes the current node and set current = current->left until current is NULL

     current -> 1

     push 1: Stack S -> 1

     current -> 2

     push 2: Stack S -> 2, 1

     current -> 4

     push 4: Stack S -> 4, 2, 1

     current = NULL



Step 4 pops from S

     a) Pop 4: Stack S -> 2, 1

     b) print "4"

     c) current = NULL /*right of 4 */ and go to step 3

Since current is NULL step 3 doesn't do anything. 



Step 4 pops again.

     a) Pop 2: Stack S -> 1

     b) print "2"

     c) current -> 5/*right of 2 */ and go to step 3



Step 3 pushes 5 to stack and makes current NULL

     Stack S -> 5, 1

     current = NULL



Step 4 pops from S

     a) Pop 5: Stack S -> 1

     b) print "5"

     c) current = NULL /*right of 5 */ and go to step 3

Since current is NULL step 3 doesn't do anything



Step 4 pops again.

     a) Pop 1: Stack S -> NULL

     b) print "1"

     c) current -> 3 /*right of 5 */  



Step 3 pushes 3 to stack and makes current NULL

     Stack S -> 3

     current = NULL



Step 4 pops from S

     a) Pop 3: Stack S -> NULL

     b) print "3"

     c) current = NULL /*right of 3 */  



Traversal is done now as stack S is empty and current is NULL. 

Write a non-recursive application for the in-order traverse for a binary tree.

Question 2: Level order traverse of a binary tree (breadth first traversal)

Level order traversal of the above tree is 1 2 3 4 5.

We can use a FIFO queue to implement the level order tranversal of a binary tree.

For each node, first the node is visited and then it’s child nodes are put in a FIFO queue.

Step 1:  Create an empty queue

Step 2:  Start from the root, enqueue the root

Step 3：  Loop whenever the queue is not empty

    a) dequeue a node from the front of the queue and print the data

    b) Enqueue the node's children (first left then right children) to the queue

    

Write a method to implement the level order traversal of a binary tree.

Notes: For both question, you can use the Binary Tree class and the Node class defined in the book, you can also define your own Node class and Binary Tree class.

Requirements: Submit the repl.it links of the two programs

Please note that you need to submit two repl.it links. You can copy and paste the two links in a .txt/.docx file and upload the file. You can also submit the second link as comments in the assignment submission.

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

Overview:

For this assignment, write a two-page paper covering a plan to implement the Sporting Goods project. For example, if you chose “a website for a sporting goods retail company,” then you can include the details of a marketing and advertising campaign.

Instructions:

Create an implementation plan that will meet the needs and requirements of the Sporting Goods project. This might include last-minute testing to eliminate any bugs, as well as to monitor user reactions to the new site. The ranking of the site on popular search engines should be checked and, if not satisfactory, steps should be taken to make changes and corrections. Newspaper and television ads might announce the new website, and celebrity sports figures might be hired to do videos for the site. After implementation, the website should be monitored for possible problems. Each of the tasks involved in implementation should have an estimated duration. Make sure to include the major tasks that are necessary to perform during an implementation. Information on this can be found in the Project Implementation article.

Requirements:

• The implementation plan paper should be 2 pages in length, with additional cover and reference pages.

• The summary should be double-spaced, written in 12-point Times New Roman font, and use a 1-inch margin.

• Use at least two (2) scholarly sources in the Sporting Goods assignment and include all references and citations properly formatted in APA.

• Use complete sentences and appropriate grammar and spelling.

Part 3: Analyzing Malicious Windows Programs (Lab 7.1 from PMA)

Complete all the steps mentioned in the below attached document for part 3 of this project:

Project part 3_ Analyzing Malicious Windows Programs.pdf

Part 4: Analyzing Code Constructs in Malware (Lab 6.1 from PMA)

Part 4 of this project is based on Lab 6-1 in “Practical Malware Analysis” textbook chapter 6.

Based on the knowledge gained in all previous lab assignments, you will have to complete lab 6-1

individually (with minimal or no supervision) by following the instructions given in Lab 6-1 in the

textbook. There are more detailed solutions in the back of the book.

1. Open and analyze the malware found in the file Lab06-01.exe using IDA Pro.

2. Answer all the questions (Q1 to Q3) found in Lab 6-1 in your own words.

3. List all the steps you followed in setting up the software environment and the screenshots captured

while analyzing the malware in IDA Pro (Hint: The steps that you list for Lab 6-1 should be something

similar to the steps that were given to you in all previous lab assignment instructions).

Submission Requirements for all four parts of the project:

Format: Microsoft Word

Font: Arial, 12-Point, Double-Space

Citation Style: APA

Length: Each part should have a minimum of 3 pages. So overall report size should be a minimum

of 6 pages (excluding title page and bibliography).

*******************************************Please read first to see if you can do the job.*********************

you will write a program of your choosing. The program has to have the following:

Requirements for the project

• At least three classes.
• At least one class inherits/extends another class.
• All three classes have attributes and constructors.
• There should be at least 400 lines of code.
• The user show be prompted for values
• For the input, try to use a graphical user interface.
• If you can’t get that to work, use System.out and Scanner.
• Name class with a starting capital letter.
• Name variables with a starting small letter.
• Name methods with a starting small letter.

DQ7: 

• Describe systems design and contrast it with systems analysis
• List documents and models used as inputs to or output from systems design

#Exp22_Excel_Ch10_HOE – Commodities 1.1 

#Exp22 Excel Ch10 HOE Commodities 1.1 

#Excel Chapter 10 Hands-On Exercise – Commodities

#Exp22_Excel_Ch10_HOE_Commodities

Project Description:

You are a financial analyst for a brokerage firm. Your manager wants you to analyze commodity sales patterns of the top five brokers for the first quarter. Unfortunately, the data required to complete the analysis are distributed among several key data sources. You received basic broker information through an email and transaction information from an Access database, and you will need to retrieve real-time NASDAQ trading information from the Web. You do not want to simply copy and paste the data into the worksheet; you want to connect and transform data in Excel so that the constantly changing values are always up to date. You also want to create data visualizations to provide geospatial information and a business dashboard.

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

You have a list of client   information stored as a CSV file. You want to use Get & Transform Data   (Power Query) to import the file, so the information will update as new clients   are added.
 

  Use Get & Transform (Power Query) to import the e10h1Client_Info.csv. Load the data. Rename the newly created   worksheet Clients.

All commodity transactions are   stored in an Access database. You will use the Get & Transform tools to   import this data while maintaining a connection to the database. You want to   use the Power Query Editor to shape the data.
 

  Use Get & Transform (Power Query) to import the transactions table from   the e10h1Transactions.accdb   database. Load the data to a new worksheet.

The database table you imported   contains data that was incorrectly formatted. You will use the Power Query   Editor to reformat the data. In addition, a coworker created a list of broker   contact information as a tab-delimited file in Notepad. You will use the   Power Query Editor to shape the data by splitting the columns and providing   unique data labels before importing it to Excel.
 

  Use the Power Query Editor to change the data type of the date field in the   Transaction query from Date/Time to Date format and the Purchase_Price and   Selling_Price fields to Currency.
 

  Use Get & Transform (Power Query) to load the e10h1Broker_Info.txt file in the Power Query Editor. Use Tab as   the delimiter. Split the Name column using Space as the delimiter splitting   the column at the Left-most occurrence. Rename the newly split columns Name.1   and Name.2 First and Last respectively. 

Split the City, State column   using Comma as the delimiter. Use Power Query to Trim the excess space off   the newly created City, State.2 column. Split the City, State.2 column using   Space as the delimiter. Then click or press the X located to the left of the   step Changed Type3 in the Applied   Steps box located in the Query Settings pane.
 

  Rename the City, State.1 column City, the City, State.2.1 column State, and the City, State.2.2 column Zip Code. Close & Load the   transformed data and then rename the worksheet Brokers. 

Transactional information for   Quarter 4 sales are stored in a separate Access database. You will use Power   Query to import the Quarter 4 data as a query and then append the   information, from the existing Transactions table.
 

  Use Get & Transform to load the 2024_Q4_Transactions table from the e10h1Q4_Append.accdb database in the   Power Query Editor. Then append the existing Transactions query with the data   from the 2024_Q4_Transactions query.
 

  Use the Power Query Editor to change the data type of the Date field to Date.   Close and load the appended query.

You want to finalize the data in   your report so it will not update if the external source is modified. You   will ensure the external connection properties are set to not refresh the   data when the file is opened. This change will ensure that when your report   is distributed there will be consistent data with no external connection   errors.
 

  Edit the connection properties for each of the external connections so   background refresh and refresh the connection on refresh all are disabled. 

You have decided to enhance your   report by using Power Pivot to create a PivotTable and PivotChart. You will   first enable the Power Pivot add-in, add the existing data to a data model,   and then create relationships. You want to use Power Pivot to analyze the   data that was imported using Get & Transform. Because the data has   already been imported, you will add the existing data to a data model.
 

  Add the transaction information located in the range A1:I76 on the   Transactions worksheet to the data model.
 

  Add the broker information located in the range A1:G6 on the Brokers   worksheet to the data model.
 

  Add the client information located in the range A1:F19 on the Clients   worksheet to the data model.

After adding all imported data   to the data model, you will define the relationships between the transactions   database table, the broker information, and client information.
 

  Create a relationship between the Transactions table Account field and   e10h1Client_Info Account field.
 

  Create a relationship between the Transactions table Broker_ID field and   e10h1Broker_Info Broker_ID.

You want to summarize the sales   of each agent in a PivotTable based on commodity. As your last step, you will   use the relational data in the data model to create a PivotTable and   PivotChart.
 

  Create a PivotTable starting in cell A1 based on the existing data model in   Power Pivot. Add the Last field to the Rows box, Date field to the Filter   box, and Commodity to the Columns box.
 

  Add the Selling_Price field to the Values box and apply Accounting Number   format to the range B5:E10.
 

  Add a Clustered Column PivotChart based on the PivotTable. Position the chart   so the upper right corner is in cell F3. Add the chart title Sales Data. Ensure the chart title appears   at the top of the chart.
 

  Rename the worksheet Sales_Analysis.

You want to create a 3D Map tour   that displays your current client locations. You want to visualize locations   and client salaries.
 

  Create a 3D map using the City field from the e10h1Client_Info file as the location. Add Earnings as the Height   dimension and the Account field as the Category dimension.
 

  Remove the legend and save the 3D map.

After adding the dimensional   visualizations to the 3D Map, you want to create a tour to better view the   data from different angles.
 

  Center the map so the United States is in the center of the map area for   scene 1. Add a new scene that repositions the map to show the Eastern   seaboard. Edit scene 1 to use the Fly Over effect for a duration of 4   seconds. Edit scene 2 to use the Push In effect. 

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

Do a bit of research on-line. Find a criminal case that involved Digital Forensics.