All posts by : chebby

Need to build a Tableau dashboard with the given datasets. Attached are sample datasets, I’ll give the full data once its accepted.

Question 1
Design a Visual Logic program that accepts a guest last name and first name, month and day the guest’s stay will start, and the number of nights for the stay.  The fee is $100 a night plus 4% for Service fee, and 6% for taxes. Display the full name of the guest, the service fee dollar amount, the total tax paid, the total fee, and the number of nights. 

Question 2
Write a Java program that accepts a guest last name and first name, month and day the guest’s stay will start, and the number of nights for the stay.  The fee is $100 a night plus 4% for Service fee, and 6% for taxes. Display the full name of the guest, the service fee dollar amount, the total tax paid, the total fee, and the number of nights. If you didn’t learn how to use Java, use a flow chart to answer this question.

Question 3

A) 

Design a Visual Logic program that accepts a guest last name, month and day the guest’s stay will start, and the number of nights for the stay.  If the month is not 5 through 9 inclusive, then display a message that indicates the cottages are not available. 

B) 

Otherwise, if the number of nights is more than 14, display a message that indicates reservations are not accepted for more than 14 nights.

C) 

Otherwise display the total fee for the guest, which is $600 total for any number of days through 7, and then $75 per day for any additional days through 14.

Discussion Week 02

Write a short survey on computer graphics.

The question is: How has computer graphics influenced the gaming industry?

This assignment is not a group paper. Follow the APA Publications Manual sixth Ed. Limit your first post to a minimum of 300 words. You must include five verifiable references.

The responses should 150 words each and must focus on the discussion topic above. Examine related issues, ask questions, provide hypothesis and/or situation(s). A peer response may not be to a peer already responded to more than twice. 

I have mentioned several times that you will be doing a team project this semester…lots to do in the project and lots to manage…

You have all worked on team projects in the past…and some of you (okay, most of you…okay, all of you) have expressed concerns over doing a team projects…and you have talked about the many issues and problems that go along with a team project…

But we won’t let that happen this semester!…because this semester, we have the choice of managing the project as with waterfall or agile…

For this assignment, given what we have discussed about waterfall and agile development, tell me which process do you think would work better in school projects – agile or waterfall?…explain why you think one will work better, and why you think the other will not work as well…be VERY SPECIFIC regarding SPECIFIC class projects and SPECIFIC class project tasks, and how they line up to either agile or waterfall processes…use your past experience with group projects as a reference…

DO NOT GIVE ME DEFINITIONS…

Again, when you have completed this, you should have 1 to 2 pages…if you have any questions about anything, just let me know…

Topic: Enhancing Cyber Security In Healthcare -With The Help Of Machine Learning

Each abstract must therefore consist of the following in this order:

Bibliographic Citation – use the correctly formatted APA style citation for the work as the title of your abstract, displaying the full citation in bold font.

Author Qualifications – name and qualification of each author conducting the research

Research Concern – one paragraph summary of the reason for the overall research topic

Research Purpose Statement AND Research Questions or Hypotheses – specific focus of the research

Precedent Literature – key literature used in proposing the needed research (not the full bibliography or reference list)

Research Methodology – description of the population, sample, and data gathering techniques used in the research

Instrumentation – description of the tools used to gather data (surveys, tests, interviews, etc.)

Findings – summation of what the research discovered and the types of analysis that were used to describe the findings (tables, figures, and statistical measures)

500 words.

 With the current day trend where customers’ product expectations are rapidly changing and everyone needs products that are really rich, fast and intuitive to use, the kinds of testing that are imperative are very different than a few years ago. With excellent internet bandwidth that is now available, products and applications are all scaling very well in their performance and this is something the customers are also expecting from the products they use. That said, such a fast and flawless implementation of products is not as easy as it sounds. There are a lot of challenges associated with meeting the product’s performance goals which include:
 

1. Increasing complexity of product architecture
2. Several interfaces that the product has with external systems and dependencies
3. Increased user base, leading to heavy load on the system
4. Performance goals undergoing a lot of change owing to competition in the market and demanding customers
5. Faster time to market for product release, which shrinks available time for performance testing
6. Shortage in availability of specialized testers for performance testing
7. Investment in performance testing infrastructure and tools, which are often very expensive and may become obsolete soon

If you see the above list, some of them are product and user specific challenges while some are test process challenges. The key to solving the product and user specific challenges is really around developing a robust performance test strategy and adequately testing the product for its performance before release. So, what we really need to be looking at is how to address the performance testing challenges; this forms the core of our discussion below.
 

Performance testing has long been in existence, however it has rightfully been given a lot of thought around specialization, domain centric testing, using the right infrastructure which mimics end user environment etc. only in the recent years. As product development technology advances with use of secured protocols, rich internet applications, service oriented architecture, web services etc. developing performance testing scripts has also become more complex. No longer will a regular “record and play” tool work across a major set of products by business it support services. There are a lot of very advanced performance testing tools that are entering the market from commercial players like HP, Microsoft, IBM which are constantly being enhanced to keep pace with the changing product technology. However, taking advantage of such tools does not come for free. These are all very expensive Commercial of the Shelf (COTS) tools, which you need to very carefully evaluate before investing. These might especially make sense for a product company to invest in, but not so much for a testing services company, because the services company is often required to use a tool that its clients have aligned their product with. On the other end of the spectrum, we have some excellent open source testing tools available for performance testing lately, which give the COTS a run for their money. A lot of companies, including product companies have started looking at such tools as good alternatives from a cost and feature standpoint, to use in their performance testing efforts. Jmeter is one such tool which a lot of companies are leveraging in the recent years. Again talking of trade-offs here, Jmeter is an open source tool available free of cost, easy for a tester to ramp up on, but is not comprehensive in its feature set, unlike the COTS. It has quite a few limitations around its reporting capabilities, which is a very important feature in performance testing, especially when the tester is handling large volumes of data. Also, this is data that the management and business teams are going to be interested in viewing, so a performance testing tool has to certainly offer very rich reporting functions.
 

This is where a company can draw its balance and decide to go with using an open source tool to take advantage of what it has to offer, but also invest in building reusable intellectual property (IP) on top of it, to address the tool’s limitations. Doing so, is beneficial for all entities involved as seen below:

1. Clients (Product companies) are able to get performance testing done at a cheaper cost without compromising on quality
2. Vendors (Test Service companies) are able to offer good value add services to their clients, differentiate themselves in the services market amongst their competition and also offer interesting out-of-project opportunities for their employees to work on building such core IP
3. 3.     Very challenging and interesting opportunities and thus good career path progression avenues are available for the employees of test services companies

Such reusable IP and frameworks often also serve as productivity enhancers – e.g. data generation, especially user data creation is quite an overhead in a performance testing effort compared to regular functional testing. If the performance testing tool that you choose does not offer good user data generation features out of the box, this is an area worth investing some time on upfront as it will save time both in the current test cycle as well as future cycles. Automating such time consuming and monotonous jobs, also frees up time for the tester to focus on more important areas such as performance benchmarking, system analysis, competitive data analysis etc. Also, to maximize the performance testing efforts, the product company should involve the performance testing team right in the early stages of product design. This will help the performance test team work in unison with the business team to understand end user’s performance expectations from the product under development; Understanding this will help the team chalk out “measurable” performance goals for the product and help the entire product development team understand these goals on the same page. Another benefit to such early involvement is the suggestions that the performance test team can provide on the product architecture from a performance angle (e.g. it could be the number of interfaces the product has, how certain web service calls are made, threshold values that are being set, production system configuration parameters etc.) which will help reduce the number of performance bugs in the test cycle. Such interactions between the developer and tester truly help build a quality product in the limited available release time.

Use the crowdfunding data

(1) Select columns: Goal, students_reached, and funding_status and create a new data-frame. (1 point)

(2) Create random train and test data-frames in 75:25 ratio. (1 point)

(3) Using K-means, cluster the train data-frame into two clusters. Use Goal and students_reached columns (only independent variables) for clustering (4 points)

(4) Plot the scatter plots before and after clustering. (2 points)

(5) Use predict() function and predict cluster labels for test data-frame. (2 points)

Upload the screenshot Jupyter Notebook file for assignment submission.

Exp22_Excel_Ch11_CumulatveAssessment_Variation – Accountants

Exp22 Excel Ch11 CumulatveAssessment Variation Accountants

Excel Chapter 11 Cumulatve Assessment – Variation Accountants

Project Description:

You work for a tax accounting firm that has offices in Albany, Columbus, Dallas, and Miami. Previously, you downloaded data from the employee database. Now you will use text, database, array, and lookup functions to obtain the results you want.

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

You will use the Data worksheet   through Step 14. Your first step is to create a unique ID for each accountant   using the year hired, date hired, and number.
 

  In cell D2, enter 2007-1018-10 and use Flash Fill to complete the pattern to   create the remaining IDs in the range D3:D26. 

The accountants’ full names are   located in column E. You want to separate the first and last names.
 

  Select the range E2:E26 and convert text to columns using the space as the   delimiter.

Next, you want to display the   accountants’ names with the last name and first name, separated by a comma.
 

  In cell G2, insert the TEXTJOIN function to join the last name and first name   for the first accountant, using a comma and space as the delimiter. The name   should display as Adams, Camille.   Copy the function to the range G3:G26. 

Column J contains the phone   numbers. You want to extract the area codes.
 

  In cell K2, use the MID function to extract the area code for the phone   number for the first employee. The Start_num argument should be the position   of the first digit in the area code to avoid including the opening   parenthesis. Make sure the function extracts the three-digit area code. Copy   the function to the range K3:K26. 

The Location column displays the   city names in all capital letters. Because this is hard to read, you will use   a text function to display the cities in upper and lowercase.
 

  In cell M2, use the PROPER function to display the first city name in upper   and lowercase. Copy the function to the range M3:M26. 

You want to create a criteria   range to perform an advanced filter. The criteria are (1) Tax Accountants in   Miami and (2) Tax Accountants in Columbus.
 

  Copy the range A1:M1 and paste it in the range A28:M28. Enter Tax Accountant and Miami in the respective cells on row 29. Enter Tax   Accountant and Columbus in the respective cells on row   30. Use column M for the city names.

Now you are ready to perform the   advanced filter by copying the data below the criteria range.
 

  Click or select a cell within the dataset. Select A1:M26 as the list, enter   the criteria range you defined in the previous step, and type A32:M32 for the location for the copied   records.

You want to identify the highest   salary for Tax Accountants in Miami and Columbus.
 

In cell P2, insert the   DMAX function. 

Next, you want to identify the   lowest salary of Tax Accountants in Miami and Columbus.
 

  In cell P3, insert the DMIN function.

The range O5:P6 contains a new   set of criteria to identify the one Senior Accountant in Columbus. You want   to obtain that person’s salary.
 

  In cell P8, insert the DGET function to extract the correct salary.

The range O10:P13 is designed to   look up a person’s name to return the salary for that person and the cell   containing that salary. First, you will look up the person’s salary within   the dataset.
 

  In cell P12, insert an INDEX function with nested XMATCH functions. Type F2:I26 as the array. The first nested   XMATCH function looks up the name entered in cell P11 and compares it to the   range containing the last names in the dataset. The second XMATCH function   looks up the text “Salary” in cell O12 and compares it to the range   F1:I1. In cell P11, type Unice to test that the function returns the correct salary.

Now that you have retrieved the   salary for the accountant, you are ready to identify the cell that contains   that salary.
 

  In cell P13, insert the ADDRESS function with nested XMATCH functions. The   first XMATCH function looks up the name entered in cell P11 and compares it   to the range F1:F26. The second XMATCH function looks up the text   “Salary” in cell O12 and compares it to the range A1:M1. Enter the   argument value to display the result as a relative cell address.

You want to document three   formulas on the Data worksheet.
 

  In cell P16, insert the FORMULATEXT function to display the formula that is   stored in cell P8.
  In cell P17, insert the FORMULATEXT function to display the formula that is   stored in cell P12.
  In cell P18, insert the FORMULATEXT function to display the formula that is   stored in cell P13.

The Summary worksheet is   designed to look up the average salary for a specific city. Each city has its   own worksheet. On each city worksheet, cell F15 contains the average salary   for the accountants in that city.
 

  Display the Summary worksheet. In cell B3, insert the INDIRECT function that   uses the city in cell B2 (which matches a sheet tab). Insert the symbols to   point to cell F15. The function should retrieve the value in cell F15. In   cell B2, type Columbus to test that the function result is correct.

You will use the Accountants   worksheet for the remaining tasks. That worksheet contains a similar version   of the dataset used on the Data worksheet. Your first task is to create a   filtered list.
 

  In cell H2, insert the FILTER function to filter the data in the dataset   range A2:F26. The filter should evaluate if the data below the Title column   heading equals Tax Accountant.

Next, you want to create an   alphabetical list of the cities contained in the dataset.
 

  In cell O2, insert a SORT function with a nested UNIQUE function for the   range of cities contained in the dataset.

Finally, you want to list the   top five salaries for tax accountants.
 

  In cell O14, insert a LARGE function with a nested SEQUENCE function. Use the   range of salaries from the filtered list and create a sequence of the top   five salaries.

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

Write a program to generate a truth table for a given Boolean statement. For example, A + B * C produces the following table:

A B C | B * C | A + B * C

===============================

0 0 0 | 0 | 0

0 0 1 | 0 | 0

0 1 0 | 0 | 0

0 1 1 | 1 | 1

1 0 0 | 0 | 1

1 0 1 | 0 | 1

1 1 0 | 0 | 1

1 1 1 | 1 | 1

Input from the keyboard a string representing a Boolean expression where the operators are the following: ! (NOT), * (AND), + (OR), ^ (XOR). Single sets of parentheses can be used if needed. Covert all letters to uppercase and have one space between each operator. The truth table must be able to handle up to four variables and be in binary order. For example, in the first test case, if the Boolean values of A, B, and C were replaced with 1’s for true and 0’s for false, the Boolean combination with the smallest binary representation would come first.

Output to the screen a truth table for the given Boolean expression. The first column of the truth table should represent A, the second B, the third C, and so on. Each binary operation must have its own column and all columns must be labeled. The entries in each column should be aligned and formatted with capital letters like the examples below. Except for the final column, columns do not have to be in any order except the order of operations must be followed to get the correct final answer. Finally, the program should ask if the user wants to run the program again (Check case). Refer to the sample output below.

Sample Run:

Enter the Boolean expression: A + B * C

A B C | B * C | A + B * C

===============================

0 0 0 | 0 | 0

0 0 1 | 0 | 0

0 1 0 | 0 | 0

0 1 1 | 1 | 1

1 0 0 | 0 | 1

1 0 1 | 0 | 1

1 1 0 | 0 | 1

1 1 1 | 1 | 1

Run again (Y/N)? y

Enter the Boolean expression: (!A * B) ^ (B + C)

A B C | !A * B | B + C | (!A * B) ^ (B + C)

=================================================

0 0 0 | 0 | 0 | 0

0 0 1 | 0 | 1 | 1

0 1 0 | 1 | 1 | 0

0 1 1 | 1 | 1 | 0

1 0 0 | 0 | 0 | 0

1 0 1 | 0 | 1 | 1

1 1 0 | 0 | 1 | 1

1 1 1 | 0 | 1 | 1

Run again (Y/N)? N

 Define several forms of metadata that can be useful to an investigation. How is it valuable to an investigator?