Create a program that will compute:
We have viewed how Blockchain has made a significant impact on businesses and industries. Select one industry and highlight the advancements Blockchain has had on that single industry.Your paper should meet these requirements:
1 page apa format
Retailers are known for collecting huge amounts of customer data. Considering the three characteristics of big data (volume, velocity, and variety), what do you think are some of the challenges that apply to the process?
In response to your peers, offer and support a different position. Make sure you articulate sufficiently and possibly support your arguments with some research.
There are several security frameworks and architectures available to use as templates for creating a secure environment. These include ISO, NIST, COBIT, ETSI, RFC, and ISA/IEC. Select three security frameworks/architectures and use the Internet to research each of them. How are they predominately used? What are their strengths? What are their weaknesses? Are they general or specific? What is a setting (small business, school, home office, etc.) that you would recommend for each of these?
Lastly, use the Internet to identify three network firewalls, and create a chart that compares their features. Note if they are rule-based or application-aware, perform stateless or stateful packet filtering, what additional features they include (IDS, content filtering, etc.), their costs, etc. Which would you recommend? Why? Write a one-page paper on your comparison and analysis.
You are an analyst for a fine art dealer. Customers are especially fond of James C. Christensen’s art. You prepared a list of his artwork: Title (title of each piece of art), Type (the medium, such as Limited Edition Print or Anniversary Edition Canvas), Edition Size (how many copies were produced for purchase), Release date (the month and year the art was released), Issue Price (the original retail price when the art was released), and Est. Value (the estimated current market value). Studying the data will help you discuss value trends with art collectors
Start Excel. Download and open the file named Exp19_Excel_Ch05_HOEAssessment_FineArt.xlsx. Grader has automatically added your last name to the beginning of the filename.
Before using the Subtotal command, the data must be sorted by categories.
On the Subtotals worksheet, perform a three-level sort by Status, then by Type, and finally by Title, all in alphabetical order.
You want to subtotal data to identify the highest issue prices, estimated values, and percentage change by the Status category and the Type of art work.
Use the Subtotals feature to insert subtotal rows by Status to identify the highest (max) Issue Price, Est. Value, and Change. Then add a second-level subtotal by Type using the same function and columns.
You want to apply an outline so that you can collapse values used for the formula in column F. Then you will collapse the subtotaled rows.
Apply an auto outline and click the collapse button above column F. Collapse the data by displaying only the subtotals and grand total rows. Set a print area for the range B1:F48.
A PivotTable can give additional perspective to data. You will use the Art worksheet to create a recommended PivotTable.
Use the Art worksheet to create the recommended PivotTable called Sum of Issue Price by Type on a new worksheet named Sold Out. Mac users create a PivotChart that includes the Status field in the Filters area, the Est. Values field in the Columns area, the Type field in the Rows area, and the Issue Price field in the Values area.
Name the PivotTable Art Type.
Currently, the PivotTable contains the Issue Price field. You will add the Est. Value field to compare the difference between total value of the art based on issue price and estimated value today.
Add the Est. Value field below the Sum of Issue Price in the Values area.
You want to display the average values instead of the sum of the values in each category.
Modify the two Values fields to determine the average Issue Price and average Est. Value by type. Change the custom name to Average Issue Price and Average Est. Value, respectively.
Format the two Values fields with Accounting number type with zero decimal places.
The Summary sheet is designed to display two key averages from the PivotTable on the Summary sheet.
Display the Summary sheet. In cell B2, insert the GETPIVOTDATA function that references cell C4 on the PivotTable in the Sold Out sheet. In cell B3, insert the GETPIVOTDATA function that references cell C9 on the PivotTable in the Sold Out sheet.
Some art is still available, but most art is sold out. You want to create a filter to focus on the sold-out art.
Display the Sold Out sheet. Add the Status field from the field list to the Filters area. Set a filter to display only art that is Sold Out.
Insert a slicer for the Type field, change the slicer height to 2 inches, change the button width to 2 inches, and apply the Light Blue, Slicer Style Dark 5. Cut the slicer and paste it in cell A11.
Note, depending upon the Office version used, the style name may be Slicer Style Dark 1.
Display the Totals sheet. Insert a calculated field named Field1 to determine difference between the two values, Est. Value and Issue Price. Change the custom name to Value Increase.
With the PivotTable on the Totals sheet displayed, change the Sum of Issue Price and Sum of Est. Value fields to show values as percentage of column totals.
With the PivotTable on the Totals sheet displayed, select Light Blue, Pivot Style Medium 6 and display banded rows.
Display the Porcelains sheet. Create a relationship between the PORCELAINS table using the Code field and the CODES table using the Code field.
Create a blank PivotTable from inside the PORCELAINS table. Add this data to the Data Model. Name the worksheet Porcelain Pivot and name the PivotTable Porcelain Values.
Display all tables in the PivotTable Fields List task pane. Add the Description from the CODES table to the Rows area and the Issue and Est. Value fields as Values from the PORCELAIN table. Format the two value fields with Accounting number format with zero decimal places.
Create a clustered column PivotChart from the Porcelain Values PivotTable. Cut the PivotChart and paste it in cell A7.
Add a chart title and type Porcelain Values. Bold the title. Change the value axis maximum bounds to $3,000.
Change the PivotChart height to 2.5 inches and the width to 3.7 inches.
Create a footer on all worksheets (except Art) with your name in the left section, the sheet name code in the center section, and the file name code in the right section.
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Subtotals, Totals, Sold Out, Art, Summary, Porcelain Pivot, Porcelains.
Save and close Exp19_Excel_Ch05_HOEAssessment_FineArt.xlsx. Exit Excel. Submit the file as directed
Give examples of systems in which it may make sense to use traditional file processing instead of a database approach.
– There must be at least one APA formatted reference (and APA in-text citation)
– 2 pages
An instructor has 30 students in her class. Each student is identified by a number from 1 to 30. Grades are stored in a one-dimensional array. The instructor would like to enter a student number and have the student’s test score printed on the monitor. Develop a solution to output the needed information. Also provide the IPO Chart, Data Dictionary, Flow Chart and the Pseudo Code
We all had the unfortunate experience of seeing how computers can, at times, make life’s journey about more difficult. This is especially true in knowledge-centric workplaces. Describe an example of a very poorly implemented database that you’ve encountered (or read about) that illustrates the potential for really messing things up. Include, in your description, an analysis of what might have caused the problems and potential solutions to them
As IT manager, you must review the gathered evidence before presenting it to the external auditor.
Read the Gail Industries Case Study. Refer to the “Partially Collected Audit Evidence” section for this assignment.
Complete the Audit Evidence Worksheet. Follow the prompts in the document.
Submit the Audit Evidence Worksheet.
Note: You will use these findings in the assignment for Week 5.
Resources
Write a paper discussing the following:
