Create a GUI window that will always open up on top of any other windows you have open. The window panel should have a title indicating a guessing game.

/in /by

CIS 221 PA5 – GUI Guessing Game

This is an individual assignment. Your program code must be your own work.

Objectives:
Create a GUI user interface
Call functions based on user events

Read through all of the instructions before beginning your work.
Using the methods we learned in class, write a program that creates a GUI interface for the Guessing Game that we’ve used in previous modules.

You may design your layout any way you want to. You will use the TKinter and random libraries. For this assignment, you may not:

  • use any other libraries or templates
  • turn in Object–oriented code
  • use messageboxes or simpledialog boxes

1. Create a GUI window that will always open up on top of any other windows you have open. The window panel should have a title indicating a guessing game.
2. The program must generate a random integer between 1 and 10, and prompt the user to input their guess.
3. Based on the user’s guess, the program must display appropriate feedback to the user, indicating whether the guess is too high or too low.
4. The program must allow the user to make multiple guesses until they correctly guess the random number or run out of guesses. You will set a max of 3 guesses.
5. The program must include “Submit” and “Quit” buttons, with the “Submit” button submitting the user’s guess and updating the feedback labels, and the “Quit” button closing the application.

6. The program must allow the user to make multiple guesses and provide appropriate feedback.
7. The code must be well–organized with appropriate use of whitespace, comments, and naming conventions.
8. The GUI layout must be clean and well–organized, with appropriate use of widgets to present the necessary information and gather user input.

Write up a brief conclusion on your scenario analysis result in the sheet of Scenario Analysis, below the summary report. Which scenario will bring the company the optimum outcome of 2017 sales?

/in /by

MIS 303 Spring 2023

Excel Assignment – Instructions

In this assignment, you are to follow the instructions to complete and submit the assignment as individuals. Please make sure you follow the instructions closely and complete all tasks on multiple worksheets.

  1. Download the file Excel Assignment.xlsx from to your computer.
  2. Rename the file as YourFirstName–YourLastName.xlsx. You should fill your own first and last names to replace the parts of YourFirstName and YourLastName in the file name. E.g., John-Smith.xlsx
  3. Open the file using Excel 2016. Rename the worksheets as suggested below. In the following instructions, each worksheet will be referred with the new name only.
Sheet1    à 2016 Orders
Sheet2    à Income Statements
Sheet3    à Pivot Tables
Sheet4    à Business Charts
Sheet5    à Goal Seek
Sheet6    à Solver Analysis
  1. On the sheet of 2016 Orders, complete the following tasks.
    1. Make of list on the entire dataset.
    2. Sort the dataset by Product first and then by Region. (Other idea: By Salesperson first and then by Month)
    3. Add a column at the right of Product. Name it Price. Use vLookup function to pull product prices from the sheet Income Statements (D4:D7) and show prices for all orders.
    4. Add a column at the right of Unit. Name it Total. The order totals = Price * Unit.
    5. At the right of Total, add a column called Discount. Use a nested If function to decide the discounts. The company gives 10% discount to all orders from the West region, and the other regions only enjoy 10% discount in December.
    6. At the right of Discount, add a column called Totalw/Dis. It is the order totals – discounts.
    7. In cell L2, use the AVERAGE function to calculate the average number of units sold from the column Unit. Next, use conditional formatting tool and highlight the orders with unit sold greater than average unit sold. Select the green fill and dark green text color option if the cells meet this rule.
  2. On the sheet of Income Statements, complete all the green-colored cells using Excel functions or formulae.
  • Revenueis Units Sold * Unit Price and COGS is Units Sold * Unit Cost.
  • Total Revenueis the sum of the revenues for all products.
  • Total COGSis the sum of the COGS for all products.
  • Gross Profit= Total Revenue – Total COGS
  • Salariesis 12% of Total Revenue
  • Advertisingis 4% of Total Revenue
  • Miscellaneous expenses are 1% of Total Revenue
  • Total Operating Expense= Salaries + Advertising + Miscellaneous
  • Earning Before Taxes= Gross Profit – Total Operating Expense
  • Calculate Taxesbased on tax rate of 25% of Earning Before Taxes
  • Net Profit= Earnings Before Taxes – Taxes
  1. On the sheet of Pivot Tables, create a pivot table. You should start with the sheet of 2016 Orders as it contains all your raw data. But when you choose the location to place your pivot table, make sure you choose an existing sheet – the sheet of Pivot Tables, and click on the cell A1 to place the pivot table separately. Here are some suggested ideas for pivot tables.
  • Product sales by Salespersons
  • Seasonal sales by Regions

Requirements

– Add meaningful title for your pivot table

– Use proper grouping fields and summary fields.

– Use proper structure of the pivot table to ensure readability

– Use proper type and format for summarized values

– Add a short paragraph below or on the side of the pivot table and describe 3 major findings from this table.

  1. On the sheet of Business Charts, create two charts using the summary data provided. Suggested ideas are:

– Salesperson performance

– Monthly sales

– Regional sales, etc.

Requirements

– Use proper chart type based on your data and purposes.

– Add meaningful chart title

– Use proper labels and/or legend to ensure readability

– Add a short paragraph below the charts and describe your major findings from each chart.

 

  1. On the sheet of Goal Seek, find the way to achieve your 2017 profit goals.
    1. Go back to Income Statement It must be completed by now. Copy the gray area (A3:G23). Go to the sheet of Goal Seek, and paste it at the cell A3.
    2. At the blank Rows 1 & 2, merge some cells and add a title 2017 Sales Estimates.
    3. The cell J3 should show a label Price Increasing Rate:, and J4 should show 5%. If they are not there because of your copying and pasting, please add them to your sheet at proper locations.
    4. Edit your data sheet and include 5% increase on Unit Price of all products. Make sure you use formula with reference to J4, where it shows the increasing rate of prices.
    5. Use the Goal Seek tool and see if we want to achieve a $125,000 net profit, what is the increasing rate of price we should apply in 2017?
  2. Scenario Analysis: Go back to the sheet of Income Statement. Use the scenario manager to create three scenarios stated below and create a scenario summary, which will be a separate worksheet.
    1. You will create 3 different scenarios by changing the product pricing mix in order to determine their impacts to Net Profit.
  • The First Scenario is to raise the price of Product B by $5.00. However, this would cause sales of Product B to fall by 800 units and sales of Product C to increase by 700 units. Title the scenario name as Product B Price Change
  • The Second Scenario is to raise the price of Product C by $4.00. However, this would cause sales of Product C to fall by 550 units and sales of Product B to increase by 400 units. Title the scenario name as Product C Price Change
  • The Third Scenario is to raise the price of both Product B and Product C by $6.00. This would cause sales for Products B and C to both decrease by 350 units each. Title the scenario name as Product B and C Price Changes
    1. Create a Scenario summary report, which will become a new and separate worksheet. Make sure the Results Cells include Earnings Before Taxes and Net Profit. Rename this worksheet as Scenario Analysis, and move the sheet to the right of the sheet of Goal Seek.
    2. Write up a brief conclusion on your scenario analysis result in the sheet of Scenario Analysis, below the summary report. Which scenario will bring the company the optimum outcome of 2017 sales?

 

  1. Solver:
    1. Go back to Income Statement It must be completed by now. Copy the gray area (A3:G23). Go to the sheet of Solver Analysis, and paste it at the cell A3.
    2. At the blank Rows 1 & 2, merge some cells and add a title 2017 Income Statement Projections
    3. Change the label Unit Sold (at the cell C3) to Units to Sell.
    4. Within the Solver Analysis worksheet, input the following Solver Parameters:
  • Objective cell: Net Profit (C22) to the value of $80,000.
  • Constraint 1: Product A must sell at least 6000 units
  • Constraint 2: Total Operating Expenses is less than or equal $215,000.
  • Constraint 3: All unit sold quantities (C4:C7) are integers.
    1. Write up a brief conclusion on the major findings from the solver analysis.

What data valuable to an investigation is created by each device? Other than the device itself, where might data from the IoT device be stored and how can it be acquired? How are drones being used by criminals and terrorists and what can law enforcement do to combat the use of drones in illegal activities?

/in /by

Assignment 3 – CCJS 321 7380 Digital Forensics in the Criminal Justice System

 

Assignment 3

  • Describe two ethical dilemmas that may be encountered by a digital forensic practitioner and what steps they should take to ensure their integrity isn’t called into question.
  • Research and describe three IoT devices. What are their functions and what problems are they designed to solve for the user?
  • What data valuable to an investigation is created by each device?
  • Other than the device itself, where might data from the IoT device be stored and how can it be acquired?
  • How are drones being used by criminals and terrorists and what can law enforcement do to combat the use of drones in illegal activities?
  • Where do drones store their data and what types of valuable information can be found?
  • Research new and developing technologies to determine what devices, software, or capabilities are emerging. Select two. Describe this new technology, how it can be used by criminal or terrorist networks, and how authorities can combat the threat.

Identify the main classes and represent these in a UML class diagram. Identify methods and attributes for each class in the class diagram. Identify relationships between classes.

/in /by

Business analysis and design

The Tasks

Write a report, with complete details, of the proposed logical analysis for the Global Logistic Company L.LC

The following must be included in the report:

                                    

  1. Introduction
  2. Review of Software Methodology (10 marks)
  3. A Process Model comprising of                                              (20 marks)
  • A Context Diagram
  • A set of Dataflow diagrams of Level-1 and Level-2 depicting the current system including
  • External entity definitions
  • Dataflow descriptions
  • Datastore contents
  • Process descriptions

 

  1. A Data Model detailing the data structure required to support the current information and process requirements comprising of: (20 marks)
  • An Entity Relationship Diagram.
  • Entity Descriptions.
  • Appropriate attributes for each entity indicating primary and foreign keys.
  • Specify the optionality, cardinality, and nature of the relationships between entities.

 

  1. 5. Construct a High – Level Use Case Diagram (20 marks)
  • Identify the main actors.
  • Identify main functions.
  1. 6. Class Diagram (20 marks)
  • Identify the main classes and represent these in a UML class diagram.
  • Identify methods and attributes for each class in the class diagram.
  • Identify relationships between classes.

 

  1. 7. Additional marks will be awarded for the professionalism of the report, format, references, citations, and adherence to reporting standards. (10 marks)

 

Additional instructions:

 

  1. Upload your draft assignment into MS Teams for formative feedback.
  2. Upload the final report to Turnitin on or before the final submission date.

In words, state what the monotonicity assumption means in the context of randomizing the location of VCT centers where the experimental participants could get their HIV test results? What do you think about the plausibility of this assumption?

/in /by

Designing Experiments Homework #4

Individual Questions

Thornton estimates the CACE (LATE) using two-stage least squares regression, which allows her to take advantage of the fact that she randomized (i) whether people received an incentive, (ii) the incentive amount, and (iii) the distance to the voluntary counseling and testing (VCT) centers where they could obtain their test results. These randomized variables are forms of encouragement (instrumental variables) that affect exposure to the treatment, i.e., individual obtaining a test result. So, in effect, when Thornton says she’s estimating a CACE (LATE), she is correct, but what she
is not making clear is that her CACE is a weighted mix of different complier groups. For example, the people who are Compliers at high incentive values may be Never Takers at low incentive values. Or, even more complicated, Compliers at high incentive values and close clinic distances may be Never Takers at high incentive values and far clinic distances. The advantages of randomizing multiple forms of encouragement are (1) you can estimate the ATEs of each form of encouragement (often, getting people to take–up the treatment is an important objective in itself; we want to learn, for example, if paying people to get their test results is more cost–effective than bringing the VCT center closer to them); (2) you make it more likely that you will generate an increase in the probability of exposure (i.e., avoid a “weak” instrumental variable problem that we talked about in class, which can lead to bias in your CACE estimator); and related to (2), (3) you make it more likely that your Complier subgroup will be a larger fraction of your overall approach is that it’s harder to interpret the causal effect: we know it’s an ATE for “the Complier” subgroup, but it’s hard to communicate who comprises this subgroup (i.e., how are they different from the rest of the population in the experiment).
In this homework, we’ll just use the binary versions of the incentives (any = 1 if the individual received any positive incentive) and the distance of the VCT (under = 1 if distance of the VCT is under 1.5 km).

1. a. Estimate the CACE of getting the HIV test result (D=got) on condom purchases (Y=numcond) using the randomization of incentives (Z=any). Just estimate the CACE; you do not have to estimate its standard error. [Hints: Section 6.2 of your book explains how to estimate CACE, as did lecture. You do not need regression analysis to answer this question. You need to calculate 4 numbers from the data and use those numbers to calculate the ratio that yields the CACE estimate]

[Note: If you are using Excel to do your calculations, I recommend you Save the file with a new name and drop all the individuals who are missing numcond data (missing values in that cell). Just sort the data by numcond and delete all rows that have missing numcond values.]

1. b. Describe in words what this CACE represents. Pretend you are explaining it to your boss, who knows nothing about two–sided noncompliance, what the number means, and for what population it’s relevant.

2.a. Estimate the CACE of getting the HIV test result (D=got) on condom purchases (Y=numcond) using the randomization of VCT center distance (Z=under). Just estimate the CACE; you do not have to estimate its standard error. [Hint: Read the hint for Q1]

2.b. Describe in words what this CACE represents. Pretend you are explaining it to your boss, who knows nothing about two–sided noncompliance, what the number means, and for what population it’s relevant.

2.c. The CACE estimated using under as Z is different from the CACE estimated using any as Z. What are potential reasons for this difference?

3. a. (i) In words, state what the monotonicity assumption means in the context of randomizing the location of VCT centers where the experimental participants could get their HIV test results? (ii) What do you think about the plausibility of this assumption? There is no single correct answer. Good answers show some thought and an understanding of monotonicity.

3.b. (i) In words, state what the exclusion restriction (the assumption of excludability) means in the context of randomizing the location of VCT centers in order to estimate the effect of getting test results on risky behaviors? (ii) What do you think about the plausibility of this assumption. There is no single correct answer. Good answers show some thought and an understanding of excludability.

4. Make sure you’ve read Section 7.4 in your textbook, which discusses bounding average treatment effects when we have attrition (the topic of the chapter assigned for this week). In Thornton’s study, only 1524 of the 2812 individuals were located at follow–up and asked how many condoms they wished to purchase. Thus, we have attrition in this experiment. Thornton argues that the attrition is random (or random conditional on covariates) and thus is not a threat to the internal validity of the experimental design (i.e., not a source of bias in her estimator of the CACE). Let’s imagine we don’t believe her argument and want to put bounds on the estimated CACE in Q1a. Using the minimum number of condoms purchased (0) and the maximum (18) as the extreme values for the range of plausible potential outcome values, calculate lower and upper bounds on the CACE. To make this question easier to answer, you should make the assumption your textbook makes and assume everyone responds the same to the treatment (homogenous treatment effects). In other words, Compliers, Never Takers and Always Takers all respond the same to the treatment (get). With that assumption, we can then assign best and worst– case scenarios for those people with missing Y values (“attriters”).*

Hint: First, assume the “best case” scenario for the attriters in terms of the largest possible positive treatment effect. In other words, using the max (18) and min (0) numcond values, fill in the missing condnum values for treated (get=1) and untreated (get=0) attriters such that you will get the largest positive CACE possible. Then assume the “worst–case” scenario for the attriters in terms of the largest negative CACE.

* Why are we making this assumption? Remember, we cannot identify the Never Takers in the no–incentive group: they are mixed in with Compliers to form the group of people who do not obtain their test results. And we cannot identify the Always Takers in the incentive group: they are mixed in with Compliers to form the group of people who obtain their test results. So, to do the bounding analysis, we must assume all participants respond the same to the treatment.

What was unique about the leader? How did they rate overall on an empirical scale? How does biology impact their personality traits? How does their personality trait impact their leadership development and engagement?

/in /by

Trait Theory

Select and research 2 athletic leaders of your choice. One leader should be someone that you like and the second leader should be someone that you dislike. Apply the Five-Factor Trait Theory to analyze both leaders on each of the 5 parameters.

Write a 1-page blog post that examines the personality traits of both leaders. Address the following:

  • What was unique about the leader?
  • How did they rate overall on an empirical scale?
  • How does biology impact their personality traits?
  • How does their personality trait impact their leadership development and engagement?
  • Compare and contrast the personality traits of both leaders.
  • Does this analysis give you any insight into why you like one and are against the other?
  • What are some strengths and weaknesses of the Five-Factor of Trait theory?

Modify the regular expression in problem 1 to use a group, so that we can print all the digits that occur in a string that contains multiple occurrences of the pattern. Write all the code required to accomplish this (create a pattern and matcher etc.).

/in /by

JAVA Advanced System Development.

1. Write a regular expression that will match a string that starts with a series of letters. The letters must be followed by a period. After the period, there must be a series of digits. The string “kjisl.22” would match. The string “f4.12b” would not. Use the following string to test your regular expression:

  • String problem1 = “abcd.135”;

 

2. Modify the regular expression in problem 1 to use a group, so that we can print all the digits that occur in a string that contains multiple occurrences of the pattern. Write all the code required to accomplish this (create a pattern and matcher etc.). Use the following string to test your code:

  • String problem2 = “abcd.135uvqz.7tzik.888”;

There are three occurrences of the pattern we looked for in problem 2. When you run your code, you should see 135, 7, and 888 printed to the console.

 

3. Let’s suppose we are reading strings that match the patterns we used in problem 1 and 2 from a file. Tabs are used to separate the matches, with one exception. The last match is followed by a newline. Our revised problem 2 string would look like this:

  • String problem3 = “abcd.135\tuvqz.7\ttzik.888\n”;

Revise the regular expression accordingly and extract all the numbers, as you did in problem 2.

 

4. Instead of printing out the numbers themselves, print out their start and end indices. Use the same string you used for problem 3. Make those indices inclusive. For example, the start index printed for 135 should be 5, and the end index should be 7. Hint: You will need to look at the documentation for the

  • Matcher.start() and Matcher.end() methods. There is more than one version of these methods. The documentation is here: https://docs.oracle.com/javase/8/docs/api/java/util/regex/Matcher.html

 

5. Suppose we have the following string containing points on a graph within curly braces. Extract what is in the curly braces.

  • String problem4 = “{0, 2}, {0, 7}, {1, 3}, {2, 4}”;

 

6. Write a Java program to remove the specific letters from a string and return the new string. Specific letters: “p”, “q”, or “r”.

  • If the given string does not contain “p”, “q”, or “r”, return “Not found.”

7. Write a Java program to check whether a string contains only a certain set of characters (in this case a-z, A-Z and 0-9).

Using the data provided, compute the location quotient for each industry in King County, Washington.What industries are the most important for this local economy? Calculate the employment multiplier for this local economy.

/in /by

HW:4 FIN437 REAL ESTATE DEVELOPMENT

King County, WA United States
  2016 2016
Agriculture, forestry, fishing and hunting 3,055 916,300
Mining, quarrying, and oil and gas extraction 2,476 1,416,500
Utilities 1,557 605,300
Construction 84,999 10,096,300
Manufacturing 111,454 13,103,700
Wholesale trade 72,408 6,935,800
Retail trade 161,916 19,390,100
Transportation and warehousing 70,436 7,169,400
Information 102,763 3,357,900
Finance and insurance 70,930 9,871,600
Real estate and rental and leasing 86,959 8,983,500
Professional, scientific, and technical services 180,099 13,712,200
Management of companies and enterprises 33,309 2,499,300
Administrative and support and waste management and remediation services 86,565 11,877,800
Educational services 40,044 4,716,600
Health care and social assistance 168,317 21,944,300
Arts, entertainment, and recreation 46,878 4,323,300
Accommodation and food services 117,856 14,415,800
Other services (except public administration) 81,422 11,388,700
Federal government civilian 20,340 2,852,000
Military 7,345 1,927,000
State and local government 157,642 19,521,000

A. Using the data provided, compute the location quotient for each industry in King County, Washington.

B. Compute the basic employment for each industry as follows:

  • If LQ < 1 then the basic employment is 0
  • If LQ >1 then the basic employment = [(LQ-1)/LQ] x Industry Employment in 2016

C. What industries are the most important for this local economy?

D. Calculate the employment multiplier for this local economy.View keyboard shortcuts

Create a database named Supermarket. Create a table named grocery in the supermarket database. Grocery table should have the following information : itemname, itemtype(i.e fruit or vegetable), item description, price per unit, quantity available. Use appropriate data type for each of the columns. Item name should be the primary key.

/in /by

PHP Question

Items marked in orange are the new tasks.

1. Using MySQL client

  • A. Create a database named Supermarket. Change the password.
  • B. Create a table named grocery in the supermarket database. Grocery table should have the following information : itemname, itemtype(i.e fruit or vegetable), item description, price per unit, quantity available. Use appropriate data type for each of the columns. Item name should be the primary key.

2.Create a php page through which you can connect to the grocery database and you can insert information into the grocery table.

  • The php page displays an interface , texboxes for itemname , textfield for item description, radio button for item type, text box for unit price , text box for quantity available and a submit button. Both the inteface page and the page handling should be in the same php script.
  • Once you click the submit button the php file should first validate the data types inserted. After successfully adding a row of information the same php page should show a confirmation message about successful information in the table.
  • Make all the texboxes, texfields and the radio buttons used for item-type sticky.

3.Create a page in your website that will show the items in the grocery table.

  • The grocery items should be displayed in multiple pages. Each page will show 5 items. There should be links to previous page , next page ….
  • Sort the grocery items by name, price, type and amount by clicking the column headings
  • Add options on the page to delete records from the grocery table. Also add option to edit records in the grocery table.

4.Create a table named users in the supermarket database. It will have username , email address, password field. Registration date will be added to the table automatically.

  • Create a page to register new users. Validate the fields before inserting new data into user table.
  • Create another page to change password. Validate against the old password to change to new password.

5.Make a login and logout page use cookies or session to

 

Conduct a survey and collect the data. Analyze the data using MS Excel using different techniques. Visualize and interpret the analyzed data. Test assumptions/claims and make recommendations.

/in /by

Survey and Data collection

Assignment brief and template are uploaded in the files. Do the following:

  • Conduct a survey and collect the data.
  • Analyze the data using MS Excel using different techniques.
  • Visualize and interpret the analyzed data.
  • Test assumptions/claims and make recommendations.