All posts by : chebby

Q1 Using the five paragraph format, discuss US life expectancy gap visualization.  This paper should be single spaced. It should have a meaningful title. It must include 3 quotes from the text or from expert sites found in the library’s research databases or from the text. They should be cited properly in APA format. 

Q2 According to Healy, ‘Putting categorical variables on the y-axis to compare their distributions is a very useful trick’. Using the five paragraph format, explain what he means. This paper should be single spaced. It should have a meaningful title. It must include 3 quotes from the text or from expert sites found in the library’s research databases or from the text. They should be cited properly in APA format.

Q3 https://www.youtube.com/watch?v=hVimVzgtD6w&t=522s View this video from Hans Rosling. Using the five paragraph format, discuss what you learned from the video. This paper should be single spaced. It should have a meaningful title. It must include 3 quotes from expert sites found in the library’s research databases or from the text. They should be cited properly in APA format.

Q4 Using the five paragraph format, write a proposal for a visualization project that you will submit for your master’s thesis. This paper should be single spaced. It should have a meaningful title. It must include 3 quotes from the text or from expert sites found in the library’s research databases or from the text. They should be cited properly in APA format. 

Please read chapter 3 of your  textbook and reputable resources and in your own word discuss what is Plan driven Software Development and What is Agile Development.

Discuss at least one application where you will use plan driven development and one application where you will prefer to use agile development.

Comments to 2 classmates must be of substance; not just “I agree” or “Good Post.” The purpose of the responses is to convert the discussion forum into a quality learning environment through which you improve your knowledge and understanding of the subject matter.

 Write an Assembly program that will have a data definition for all data type listed in Table 3.2
(No need to use these data in any calculations).
Initialize each variable to a value consistent with the data type.
Make sure you have the following at the top of your Assembly code file. Fill it up accordingly
such as the name of the asm file will be Assignment01.asm
; Program Template (Assignment01.asm)
; Program Description:
; Author:
; Creation Date:
; Revisions:  
; Date:Modified :
Also make sure to document your Assembly code.

What to submit?
TWO files.
1. Copy your program and paste it to a text editor such as Notepad and save file as .txt file
then submit this text file.
2. A pdf file that has your code (copied or screenshot)   

You’ve been invited to write a blog post for a prominent creativity and innovation publication (i.e. IDEO (Links to an external site.)Links to an external site.) about the three most important creativity mindsets and their practical application to daily life.

What insights/lessons will you share?

Are there any activities you would recommend to strengthen your argument?

Need a little inspiration? Check out: 3 Exercises to Make Change Stick in 2019 (Links to an external site.)Links to an external site.

(500 words or less!)

Creativity mindsets are Curiosity, Divergence, play, Ambiguity.

You pick three creativity mindsets to write.

See the attached file and message me for more information or instruction.

Portfolio Assignment

Background:  Assume that there has been a data breach at your organization.  The root cause was one of the following:  Insufficient or weak user authentication, deliberate actions of a disgruntled employee, a server that was missing a critical security patch for 90 days, or a misconfigured SaaS program that was unknown to the IT department.

Topic:  Select one of the possible root causes listed above and write a recommendation to senior management for addressing the problem.  Suggest an immediate action that would need to be taken, then attempt to persuade management to support a project to address the root cause.  Address at least one regulatory reason for action, one ethical reason, and one reason based on industry standards.  Knowing that this effort would be too early for accurate financial numbers for a project, include one paragraph that would address three key financial impacts a project would have on an already fully committed IT budget.

Mechanics:  This portfolio assignment has a target word length of 2,000-2,500 words.  It must be in APA format.  Due to the length, an Abstract is not required.  The word count excludes the Title Page, Reference Section, and any appendices you may desire to add.  A minimum of 3 scholarly resources must be used.  To qualify as a scholarly resource, the resource must be a peer-reviewed article published in a journal in the field related to Digital Forensics. 

 Exp19_Excel_Ch01_ML2_Sales

Project Description:

You own a small real estate company in Indianapolis. You track the real estate properties you list for clients. You want to analyze sales for selected properties. Yesterday, you prepared a workbook with a worksheet for recent sales data and another worksheet listing several properties you listed. You want to calculate the number of days that the houses were on the market and their sales percentage of the list price. In one situation, the house was involved in a bidding war between two families that really wanted the house. Therefore, the sale price exceeded the list price.

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

The owners of the house on 386   East Elm Street took their house off the market. You want to delete that row   since it did not sell.
 

  Delete row 8, which has incomplete sales data.

You want to assign a property ID   to each listing. The code will have the year 2021 with a sequential number.
 

  Type 2021-001 in cell A5 and use Auto Fill to   complete the series to assign a property ID to each property in the range   A6:A12.

Real estate agents study the   number of days houses are on the market. In some cases, the longer a house is   on the market, it might indicate the asking price is too high.
 

  Enter a formula in cell C5 that calculates the number of days the first house   was on the market by subtracting the date listed from the date sold. Copy the   formula to the range C6:C12.

Monetary values look better when   they are formatted to display the dollar signs. Because all monetary values   are whole numbers, you will decrease the decimal points to avoid columns   where all the data ends in .00.
 

  Format the list prices and sold prices in the range F5:G12 with Accounting   Number Format with zero decimal places.

To analyze the real estate   market, it is helpful to calculate the selling prices as a percentage of the   list price. For example, the second house was listed for $500,250, but it   sold for only $400,125. Therefore, the sale percentage of the list price is   .7999 or 79.99%.
 

  Enter a formula in cell H5 that calculates the sales price percentage of the   list price for the first house by dividing the sold price by the list price.   Copy the formula to the range H6:H12.

The calculated percentages need   to be formatted with the percent symbol rather than displaying the values as   raw numbers.
 

  Format the values in the range H5:H12 with Percent Style with two decimal   places.

Currently, the labels on row 4   are hard to read. You will wrap the headings within each cell to improve   readability.
 

  Wrap the headings in the range A4:H4.

For better sequencing of   columns, you want to display the Days on Market column after the two columns   containing the dates.
 

  Insert a new column between the Date   Sold and List Price columns.   Move the Days on Market data to the   new blank column F by moving the range C4:C12 to F4:F12. Delete column C.

You notice the list contains a   wrong date and wrong list price that need to be corrected.
 

  Edit the list date of the 41 Chestnut   Circle house to be 4/22/2021. Edit the list price of the house on Amsterdam Drive to be $355,000.

Increasing the height of the   rows of data and centering the data vertically between the top and bottom   cell margins will make it easier for the other agents to review the data.
 

  Select the property rows (rows 5:12), set a 25 row height, and apply Middle Align.

Displaying borders helps   separate the property listings.
 

  Apply the All Borders border style to the range A4:H12.

You want to improve the   alignment of number of days on market below the column label.
 

  Apply Align Right and increase the indent two times on the days on market   formula results in the range E5:E12.

The widths of the columns   containing the Days on Market, List Price, and Sold Price data need to be   adjusted for better appearance.
 

  Set the Days on Market column width to 9. Set the List Price and Sold Price column widths   to 11.86.

The property listings dataset is   small. To improve readability on the printed copy for the other real estate   agents, you will increase the scaling.
 

  Apply 120% scaling.

You don’t need the data on the   Properties sheet but you do want to insert another sheet for formulas.
 

  Delete the Properties sheet and insert a new sheet named Formulas.

You want to copy the original   data to the new sheet so that you can modify the duplicated data.
 

  Use the Select All feature to select all data on the Houses Sold worksheet   and copy it to the Formulas worksheet.

You do not want to display the   columns containing dates on the new worksheet.
 

  Hide the Date Listed and Date Sold columns in the Formulas worksheet.

You want to review the formulas within   the worksheet and prepare the Formulas sheet to be printed.
 

  Display cell formulas. Set options to print row and column headings. Set 6.86   column width for column E and 6 for column H.

You want to apply page setup   options to both sheets, so you need to group the sheets first.
 

  Group the two worksheets. Select Landscape orientation. Center the page   horizontally and vertically between the margins.

With both worksheets still   grouped, insert a footer with the text Exploring Series on the left side, the sheet   name code in the center, and the file name code on the right side.

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

Eller Software Services has received contract revenue information in a text file. You import, sort, and filter the data. You also create a PivotTable, prepare a worksheet with subtotals, and format related data as an Excel table.

[Student Learning Outcomes 4.1, 4.3, 4.4, 4.5, 4.6, 4.8]

Files Needed: EllerSoftware-04.xlsx (Available from the Start File link.) and EllerSoftwareText-04.txt (Available from the Resources link.)

Completed Project File Name: [your name]-EllerSoftware-04.xlsx

Skills Covered in This Project

• Import a text file.
• Use AutoFilters.
• Sort data by multiple columns.
• Create a PivotTable.
• Format fields in a PivotTable.
• Use the Subtotal command.
• Format data in an Excel table.
• Sort data in an Excel table.

This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.

1. Open the EllerSoftware-04.xlsx start file. Click the Enable Editing button. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
2. Import the EllerSoftwareText-04.txt file downloaded from the Resources link and load it to begin in cell A4. The text file is tab-delimited.
3. Format the values in column H as Currency with zero decimal places.
4. Click cell G4 and use the AutoFilter arrow to sort by date oldest to newest.
5. Click cell F4 and use the AutoFilter arrow to sort by product/service name in ascending order.
6. Filter the Date column to show only contracts for September using the All Dates in the Period option.
7. Edit the label in cell A2 to display Contract Amounts for September.
8. Select cells A1:H2 and press Ctrl+1 to open the Format Cells dialog box. On the Alignment tab, choose Center Across Selection.
9. Change the font size for cells A1:H2 to 20 pt (Figure 4-102) and close the Queries & Connections pane.Figure 4-102 Imported data sorted and filtered
10. Copy the Contracts sheet to the end and name the copy Data.
11. Clear the date filter.
12. Select cell A5 and click the PivotTable button [Insert tab, Tables group]. The range is identified as the EllerSoftwareText file.
13. Verify that New Worksheet is selected, deselect the Add this data to the Data Model button, and click OK.
14. Name the sheet PivotTable. Close the Queries & Connections pane.
15. Show the Product/Service and Contract fields in the PivotTable.
16. Drag the Contract field from the Choose fields to add to report area below the Sum of Contract field in the Values area so that it appears twice in the report layout and the pane (Figure 4-103).Figure 4-103 “Contract” field appears twice in the report
17. Select cell C4 and click the Field Settings button [PivotTable Analyze tab, Active Field group]. Type Average Contract as the Custom Name, choose Average as the calculation, and set the Number Format to Currency with zero decimal places.
    Select cell C4 and click the Field Settings button [PivotTable Tools Analyze tab, Active Field group]. Type Average Contract as the Custom Name, choose Average as the calculation, and set the Number Format to Currency with zero decimal places.
18. Select cell B4 and set its Custom Name to Total Contracts and the number format to Currency with zero decimal places.
19. Apply Brown, Pivot Style Dark 3.
20. Select the Data sheet tab and copy cells A1:A2. Paste them in cell A1 on the PivotTable sheet.
21. Select Align Left for cells A1:A2 and 16 pt. as the font size. Edit the label in cell A2 to display Contract Amounts, September through December (Figure 4-104).Figure 4-104 Completed PivotTable
22. Copy the Data sheet to the end and name the copy Subtotals.
23. Select cell D5 and sort by City in A to Z order.
24. Select cell A5 and convert the table to a range. Select cells A5:H31 and apply No Fill [Home tab, Font group].
25. Use the Subtotal command to show a SUM for the contract amounts for each city.
26. Edit the label in cell A2 to display Contract Amounts by City.
27. Format the sheet to Landscape orientation, center the page vertically, and scale it to fit one page.
28. Click the Billable Hours sheet tab and select cell A4.
29. Click the Format as Table button [Home tab, Styles group], use Orange, Table Style Medium 10, and remove the data connections.
30. Type 5% Add On in cell E4 and press Enter.
31. Build a formula in cell E5 to multiply cell D5 by 105% and press Enter to copy the formula.
32. Select cells A1:A2 and left align them. Then select cells A1:E2, click the Launcher for the Alignment group [Home tab], and select Center Across Selection from the Horizontal list.
33. Use the AutoFilter arrows to sort by date in oldest to newest order.
34. Save and close the workbook (Figure 4-105).Figure 4-105 Excel 4-4 completed
35. Upload and save your project file.
36. Submit project for grading.

Write your programs using Racket functional language.

Run each of the programs as many times as necessary to show that different situations are handled properly.

1. In the beginning of each part of this problem, introduce a named value pi, which is 3.1416. You will have to write a function my_calc that takes two numerical parameters. If the first parameter is 1, calculate the area of a circle, whose radius equals the second parameter of the function. If the first parameter is 2, calculate the volume of the sphere, whose radius equals the second parameter of the function. For other values of the first parameter and for a non-positive second parameter return a false Boolean value.

• (a) [10 points] Implement a function my_calc using a multiple-way selection structure when checking the value of the first parameter.
• (b)  [10 points] Implement a function my_calc using a two-way selection structure when checking the value of the first parameter.

  2. [12 points] Write a Racket function rem_second that takes a simple list as a parameter and returns a list identical to the parameter except with the second top-level element removed. If the given list does not  have two elements, the function should return an empty list.

3. [15 points] Write a Racket function my_union that returns a union of two simple list parameters that represent sets. Remember that duplicate elements are not allowed in a set. You are only allowed to use a program ‘membership.rkt’ from the folder ‘DrRacket’ under ‘Modules’; no other functions!

1.  [18 points] Write a function my_delete that takes two parameters: an atom and a list (which may be a nested list). This function will produce a list, identical to its parameter list, except with all occurrences of an atom parameter removed, no matter how deep they were. The produced list should not have anything in place of the deleted atoms.

—————————————————————————————————  

Standard Racket functions that were not discussed in video lectures are NOT allowed.

Submit a separate Word or pdf file for each part of the project, or combine all code and output into one file.

The code should be copied and pasted as a text; include output in the form of snippets (not screenshots; no typing).

Submissions without the output will NOT be graded.

 how business processes as services can improve efficiency. This discussion is about business process as a service and security.