Follow the instruction to change the excel file.

one of them have the instructions and the others have the excel file, then follow the instructions to change the excel file.

The programming assignment for the final week, due on the final day of the course, if not before, has been modified in an attempt to allow for more creativity in the coding process.  An outline of the new assignment will follow as I do not have the ability to modify the template of the course.  I’d begin looking at it now and ask questions as you move forward. 

Programming Assignment #3 (25 points) *modified at the end*

This assignment will give you practice with while loops and pseudorandom numbers. You are
going to write a program that allows the user to play a simple game in which your program thinks
up an integer and allows the user to try to determine the number with a minimum number of tries.
For each incorrect try you will tell the user whether the right answer is higher or lower. Your
program is required to exactly reproduce the format and behavior of the log of execution at the end
of this write-up, so you may want to look that over first.

At a minimum, your program should have the following static methods in addition to method
main:
a method to give instructions to the user

a method to report overall results to the user

You may define more methods than this if you find it helpful, although you will find that the
limitation that methods can return only one value will tend to limit how much you can
decompose this problem.

You are to define a class constant for the maximum number used in the game. The sample below
selects a number from 1 to 100, but the choice of 100 is arbitrary. By introducing a constant for
100, you should be able to change just the value of the constant to make the program play the
game with a range of 1 to 50 or a range of 1 to 250 or some other range starting with 1.

When you ask the user whether or not to play again, you should use the “next()” method of the
Scanner class to read a one-word answer from the user. You should continue playing if this
answer begins with the letter “y” or the letter “Y”. Notice that the user is allowed to type words
like “yes”. You are to look just at the first letter of the user’s response and see whether it begins
with a “y” or “n” (either capitalized or not) to determine whether to play again.

Assume that the user always types an integer when trying, that the integer is always in an
appropriate range and that the user gives you a one-word answer beginning with “y”, “Y”, “n” or
“N” when asked whether to play again.

You will notice at the end of the log that you are to report various statistics about the series of
games played by the user. You are to report the total number of games played, the total number of
tries made (all games included), the average number of tries per game and the maximum number
of tries used in any single game. You should also report the user’s best game(s) indicating which
game(s) had the minimum number of tries and what that minimum was.

Here are a few helpful hints to keep in mind:

this program needs to generate pseudorandom numbers

To deal with the yes/no response from the user, you might want to use some of the String class
methods. You will want to use the next() method of the Scanner class to read a word from the
console.

Because this program uses pseudorandom numbers you won’t be able to recreate this exact
log. The key requirement is that you reproduce the format of this log and that your calculations
for overall statistics are correct for your log.

It’s a good idea to change the value of your class constant and run the program to make sure
that everything works right with the new value of the constant. For example, turn it into a
game for numbers between 1 and 5.

This program is more difficult than most to decompose into methods, so you may end up having
methods that are longer than 15 lines. You are required to have a while loop in main that plays
multiple games and prompts the user for whether or not to play another game. You shouldn’t
have all the code in main because you are required to have the methods described at the
beginning of this write-up.

You are expected to make appropriate choices about when to store values as int versus double,
which if/else constructs to use, what parameters to pass, and so on.

Your program should be stored in a file called Guess.java.

Include a comment at the beginning of your program with basic information and a description of
the program. This includes having an adequate comment header, commenting every line, and the
integrity statement.   The integrity statement must be included or the max score will be cut in half.

Turn in your screenshot in Word of the output with filename
JonBrownCIS1501ScreenShotsProgrammingAssignment3Jan122017 (your name, the course
name, the content of the file, and the date), Guess.java and Guess.class (Please make sure to
name your files exactly, including identical capitalization.) Then put all three files in one zip file.
The zip file should be named: your name, the course name, the content of the file, and the date
and then submit to the Assignments link on the course web page.

Log of execution (user input underlined)

This program allows you to play a game.
I will think of a number between 1 and 100
and will allow you to try to determine it.

For each try, I will tell you whether the
right answer is higher or lower than your
try.
I’m thinking of a number…

Your try? 20
higher

Your try? 40
higher

Your try? 60
higher

Your try? 80
higher

Your try? 100
lower

Your try? 90
lower

Your try? 88
lower

Your try? 86

Game #1: You got it right in 8 tries

Do you want to play again? Yes
I’m thinking of a number…

Your try? 20
higher

Your try? 40
higher

Your try? 60
higher

Your try? 80
higher

Your try? 82
higher

Your try? 84
higher

Your try? 86
higher

Your try? 88
higher

Your try? 90
higher

Your try? 92
higher

Your try? 94
lower

Your try? 93

Game #2: You got it right in 12 tries
Do you want to play again? YES
I’m thinking of a number…

Your try? 20
higher

Your try? 40
higher

Your try? 60
lower

Your try? 58
lower

Your try? 56

Game #3: You got it right in 5 tries
Do you want to play again? No
Overall results:

total games = 3
total tries = 25

tries/game = 8.333333333333334
max tries = 12

Your best game was Game#3 in 5 tries

Here are the modifications for this term.

1. user must play at least 3 games and no more than 5
2. you must ask the user how many games they wish to play right from the start; if they say less than 3 or more than 5, you must prompt them again, this time with instructions on the limits
3. now you must capture the maximum value for each game offering a choice of 50, 100, 200 or 500 (other entries are not allowed)
4. you must keep track of the number of guesses AND accumulate how far off each guess was from the given number (25 is 10 off from 35 and so is 45 (no negative values))

Sample output:

Let’s play a number guessing game.

How many games do you want to play?

6

I’m sorry.  We must play between 3 and 5 games.

How many do you want to play?

3

For these 3 games, what is the range of numbers we are going to use?  1 to __?

75

Acceptable answers are 50, 100, 200 or 500.  Please respond:

100

Good luck!

Game 1:

This program allows you to play a game.
I will think of a number between 1 and 100 <- display the user’s entered range max
and will allow you to try to determine it.

For each try, I will tell you whether the
right answer is higher or lower than your
try.
I’m thinking of a number…

(back and forth until the user gets the correct answer)

Your try? 20
higher

Your try? 40
higher

Your try? 60
higher

Your try? 80
higher

Your try? 82
higher

Game 1:

You got it right 5 guesses.

You were off by an average of 25.6 per guess.

(note: the answer was 82 and the guesses were off by 62, 42, 22, 2 and 0 which total 128/5 guesses = 25.6) **don’t print this

Good luck!

Game 2 begins now:

repeat the process

reset (or renew?) the counter for the number of tries/guesses

reset (or renew?) the counter for tracking the average amount off

Game 2:

output for the # of guesses and the off by an average of

repeat the process for the 3rd game and possibly the 4th and the 5th

output as well

For the final output:

Your best game in terms of lowest guesses was Game # (insert the number of the game with the least number of guesses) when you solved the game in ___ guesses.

Your best game in terms of closest guesses was Game # (insert the number of the game with the lowest average “off guess”) when you were off by an average of ___.

IF the #s of the best games match, the user should receive some special message from you.  For example, if your best game in terms of lowest guesses and closest guesses was, let’s say game #2, the user should see some sort of special message noting how well game #2 was played.

 Select any example visualization or infographic and imagine the contextual factors have changed:

1. If the selected project was a static work, what ideas do you have for potentially making it usefully interactive? How might you approach the design if it had to work on both mobile/tablet and desktop?
2. If the selected project was an interactive work, what ideas do you have for potentially deploying the same project as a static work? What compromises might you have to make in terms of the interactive features that wouldn’t now be viable?
3. What about the various annotations that could be used? Thoroughly explain all of the annotations, color, composition, and other various components to the visualization.
4. What other data considerations should be considered and why? 
5. Update the graphic using updated data, in the tool of your choice (that we’ve used in the course), explain the differences.

Be sure to show the graphic (before and after updates) and then answer the questions fully above.  This assignment should take into consideration all the course concepts in the book.  Be very thorough in your response.  The paper should be at least three pages in length and contain at least two-peer reviewed sources. 

Please refer to the attachments. Also, the Question is in the attachment  under name question project is mainly focused on EBAY sell button as attached in Attachment and please go through paper provided research has to be a continuation of attached paper. I need 5 pages along with citations and references.Follow APA format.

 Exp19_Access_Ch03_ML1 – Small Business Loans 1.0

You are the manager of a regional  business loan department for the U.S. Small Business Administration  office. You have decided to evaluate whether Access could be used in  place of the Excel worksheet you are currently using. You will create a  table, add some sample customers, and import some recent data from an  Excel spreadsheet. You will calculate the payments for the loans that  are currently on the books by creating a query using the Pmt function.  You will also summarize each loan by the type of loan (M=Mortgage,  C=Car, and O=Other).

In   Design view, create a new table. Add the first field named CustomerID with   AutoNumber Data Type. Add Company as the second field name, and FirstName as   the third field name. Accept the default data types.
 

  Save the Table with name as Customers. Click Yes, when prompted for defining Primary   Key.

Add the following fields to the   Customers table (in this order), accepting the default data type of Short   Text:
 

LastName
   City
   State
   Zip
 

  Verify that CustomerID is the primary field.

Save the table and switch to   Datasheet view. Add the following records to the table:
 

Company FirstName LastName City State Zip
Jones   and Co Robert Paterson Greensboro NC 27401
   Elements, Inc. Merve Kana Paterson NJ 07505
   Godshall Meats, LLC Francisco De La Cruz Beverly Hills CA 90210

Import the spreadsheet using the   downloaded Excel file a03_h2_Loans.xlsx   into a new table. Choose LoanID as the primary key and accept all other   defaults in the Import Wizard.

Open the Loans table in Design   view. Change the InterestRate field format to
   Percent. Change the field size for the CustomerID field to Long  Integer. Save   and close the table. Click Yes when prompted that some  data may be lost. 

Create a relationship between   the CustomerID fields in the  Customers and Loans tables. Enforce referential   integrity. Save and  close the Relationships window.

Create a query using the two   tables that will calculate the payment  amount for each loan. Add the   following fields: Company, LoanID,  Amount, InterestRate, Term, and LoanClass,   in that order. Sort the  query by LoanID in ascending order. Save the query as   Loan   Payments.

Use the Expression Builder to   add a calculated field named Payment  in the first blank column to   calculate the loan payment for each loan  using the Pmt function. Insert the   appropriate field names in place  of the placeholder arguments. Assume the   loans have monthly payments  (12 payments per year). Ensure the payment   displays as a positive  number. Run the query.

Switch to Design view and change   the format for the Payment  calculated field to Currency. Run the query again   to verify your  change.

In Datasheet view, add a Totals   row. Use it to calculate the sum of  the Amount column, the average   InterestRate, and the average Term.  Save and close the query.

Create a copy of Loan Payments.   Save the new query as Loan Payments Summary. Open the Loan Payments Summary   query in Design view and rearrange the columns as follows:
   LoanClass, LoanID, Amount, and InterestRate. Delete columns Company, Term,   and Payment.

Group the Loan Payments Summary   query by the LoanClass field.  Display the number of loans in the LoanID   column, the sum in the  Amount column, and the average in the InterestRate   column. Run the  query.

Switch to Design view and   display the Property Sheet. For the LoanID field, change the caption to Loans. For the Amount field, change   the caption to Total Amount and change the format to   Currency. For the InterestRate field, change the caption to Avg Interest   Rate and change the format to Percent. Run the query.   Save and close the query.

Close all database objects.   Close the database and then exit Access. Submit the database as directed.

 1. What is Native mobile app development? 

Get help for free Chinatown clinic project

GO19_AC_CH02_GRADER_2G_HW – Student Scholarships 1.0

GO19_AC_CH02_GRADER_2G_HW – Student Scholarships 1.0

GO19ACCH02GRADER2GHWStudent Scholarships1.0

Project Description:

In this project, you will use a database to answer questions about  scholarships awarded to students at a college. You will create a  relationship between two tables, create a query from an existing query,  and create queries using text, numeric, compound, and wildcard criteria  based using the fields in one or both tables. You will create calculated  fields, group data when calculating statistics, create a crosstab  query, and create a parameter query.

Start Access. Open the file ‘Student_Access_2G_Student_Scholarships.accdb‘ downloaded with this project.

Using   Student ID as the common field, create a one-to-many  relationship between the   2G Students table and the 2G Scholarships  Awarded table. Enforce referential   integrity and enable both cascade  options.

Create   a relationship report with normal margins, and save it as 2G Relationships. Close all open objects.

In   the last record of the 2G Students table, change the Student ID from 9999999 to 2839403, and then close the table. (The   related records in the Scholarships Awarded table will automatically update.)

Create   a query in Query Design view based on the 2G Scholarships Awarded table to   answer the question:  What is the   scholarship name, amount, and major for scholarships  greater than or equal to   $500, sorted in ascending order by the  Scholarship Name field? Display   the fields in the order listed in the question. Run the query. Eight records   match the criteria. Save the query as 2G Amount $500 or   More Query.   Close the query.

Copy   the 2G Amount $500 or More Query to create a new query with the name 2G Awards 4th Qtr Query and then redesign the query to answer   the question: Which scholarships   (Scholarship Name) were awarded between 10/1/22 and 12/31/22, for what amount, and for which   student (Student ID), sorted in ascending order by the Award Date field?  Display only the fields necessary to answer   the question and in the  order listed in the question. Run the query (five   records display).  Save the query, and then close the query.

Create a query in Query Design view   based on the 2G Scholarships Awarded table to answer the question: Which scholarships (Scholarship Name) were   awarded for either Math or Business majors for amounts of more than $200,   sorted in descending order by the Amount field?  Display the fields in the order   listed in the question. Run the  query. Four records match the criteria.   (Hint: If six records display,  switch to Design view and combine the majors   on one criteria line  using OR.) Save the query as 2G Math OR Business Over $200 Query, and then close the query.

Create   a query in Query Design view based on the 2G Students table to answer the   question: What  is the city, student ID,   first name, and last name of students from  cities that begin with the letter   L, sorted in ascending order by the  City field and by the Last Name field? Run the query (five records display). Save   the query as 2G L Cities Query,   and then close the query.

Create   a query in Query Design view based on the 2G Students table and all of the   fields to answer the question: For   which students is the Postal Code missing? Three records match the   criteria. Run the query (three records display). Save the query as 2G Missing Postal Code Query, and then close the query.

Create a query in Query Design view   based on both tables to answer the question: In  ascending order by the Scholarship Name field, and including the    first name and last name of the scholarship recipient, what will be  the total   value of each scholarship if the Board of Trustees donates  an additional 50   percent of each award paid to students? (Hint: First calculate the amount   of the donation, naming the new field Board Donation,    and then run the query to be sure the correct results display (the  first   record—Scholarship Name that begins with   Amanda—has a Board  Donation of 125).

Display   the query in Design view. In the sixth column of the design grid, create a   new field named Total Donation   that will calculate and display the total donation when the amount is added   to the Board’s donation amount. Run the query.

Display   the query in Design view. Use the Property Sheet to format  the Board Donation   field as Currency with 0 decimal places and the  Total Donation field with 0   decimal places, and then close the  Property Sheet. Run the query (the first   record—Scholarship Name that  begins with   Amanda—has a Total Donation of $375.00), apply Best Fit to the   fields, save the query as 2G Board Donation Query,   and then close the query.

Create a query in Query Design view   based on the 2G Scholarships  Awarded table and the Sum aggregate function to   answer the question: For each major,   what is the total scholarship amount, sorted in descending order by the   Amount field?  Use the Property Sheet to format the Amount field with 0   decimal  places, and then close the Property Sheet. Run the query (for the    Major of History, the total scholarship amount is $1,850). Apply Best Fit to the fields, save the query as 2G Amount by Major   Query, and then close the query.

Use the Query Wizard to create a crosstab   query based on the 2G  Scholarships Awarded table with the Student ID field as   row headings  and the Major field as column headings. Sum the Amount field,   and name  the query 2G Student ID and Major Crosstab Query.  Display the query in Design view. Use   the Property Sheet to format the  last two columns with 0 decimal places, and   then close the Property  Sheet. Run the query, apply Best Fit to the fields,   save the query,  and then close the query.

Create a query in Query Design view   based on the 2G Scholarships Awarded table that prompts you to Enter the Major of the student, and then answers the   question: What is the scholarship name   and amount for a major, sorted in ascending order by the Scholarship Name   field? Run the query, and when   prompted, enter history    as the criteria (four records display). Display the query in Design  view and   hide the Major field from the results. Run the query again,  entering history when prompted. Save the query as 2G Major Parameter   Query, and then close the query.

Need to get two cyber assignments needing to get completed.

 Create an actionable plan including executive-level support and budget allocation to ensure security controls can be rapidly updated and expanded as the threat environment increases.

The actionable plan should include (but is not limited to):

Procedures to track performance
Procedures to monitor and measure performance for areas of improvement
Procedures to identify new threats, vulnerabilities, or any countermeasures
Procedures to obtain feedback on the effectiveness of policies
Procedures and technical tools to monitor the internal and external environment
Procedures for budget allocation
Procedures to catch any oversights