This program will give you practice with Java Swing and the Map ADT (specifically with HashMap data structure). You will write a small GUI program that shows the unemployment rate (as of January 2021) of each state in the United States. The rates have been provided in a .csv file. You will read the data in to custom class objects and then insert into a Map each state’s abbreviation and the state object itself. The user can then search for states by abbreviation to find that state’s unemployment rate. The search process must utilize a java.util.HashMap.

part1: issc366 forum:You are going to use your favorite browser to connect to a bank. It does not matter if you have an account at the bank or not. Try https: www.chase.com or https://www.google.com. Internet Explorer makes this exercise simpler but you are not limited to one browser. Now that you have connected to the site, do not enter your user name and password and answer the following questions:What is the name of the Certificate Authority for the site you connected to?What is the public key of the site you connected to? You can cut and paste.What hash algorithm is the site using?What Asymmetrical encryption algorithm is the site using?List 5 root Certificate authorities trusted by your browserpart2: issc431 forum: You are encouraged to conduct research and use other sources to support your answers. Be sure to list your references at the end of your post. References must be in APA citation format with minimum 250 words.For this assignment, answer the following:What is the purpose of an audit?What information is contained within an audit trail?What are the advantages and disadvantages of using an audit trail?

1. (Chapter 2: Question 6) The spreadsheet model for Sam’s Bookstore (see Example 2.4 in Section2.5 of the textbook) contains a two-way data table for profit versus order quantity anddemand. Experiment with Excel’s chart types to create a chart that shows this informationgraphically in an intuitive format. (Choose the format you would choose to give a presentationto your boss.)2. (Chapter 2: Question 36) The payback of a project is the number of years it takes before theproject?s total cash flow is positive. Payback ignores the time value of money. It is interesting,however, to see how differing assumptions on project growth impact payback. Suppose, forexample, that a project requires a $300 million investment at year 0 (right now). The projectyields cash flows for 10 years, and the year 1 cash flow will be between $30 million and $100million. The annual cash flow growth will be between 5% and 25% per year. (Assume that thisgrowth is the same each year.) Use a data table to see how the project payback depends on theyear 1 cash flow and the cash flow growth rate.3. (Data Manipulation/Reporting in Excel): Given the Publications Data spreadsheet, use Excel’sPivot function to produce the following reports: A list of all the unique main authors sorted alphabetically within the full-time (F-T) andpart-time (P-T) categories with a count of articles by each author.1 A list of the unique journal names. In one table: list the journals by rank with columns for journal, journal rank, journal titleand main author together with a count of the publications in each journal by each author.Filter out the journals that have no ranking (marked N/A or not applicable). Draw a line graph of total publications by year. Produce a table of total publications by year by F-T and P-T faculty categories (yearsshould be listed on the horizontal axis.) Depict the same data in a vertical bar graph.Important: The results of each exercise should be contained in ONE spreadsheet consistingof a number of worksheets, each worksheet should have an appropriate title and date at the topand each worksheet tab should be appropriately labeled.