H3

  Please answer all the questions on the attached H3W doc, and please review the APA doc.  

TCO

  

1. (TCO 3) Show the source code for a C# console application called “Area” to display the area of a parking lot with length 203.5 ft. and width 30.5 ft. (Note that area is length times width.)

· Declare and initialize appropriate variables for length and width.

· Include at least three descriptive comments.

· State what your program displays when it runs.

· State how you would use the debugger to check the values of your variables as your program runs.

  

2. (TCO 5) Describe two types of loops that can be used to write the C# code required to print every fifth integer from 0 to 500 (i.e., 0, 5, 10, 15, etc.), each on its own line. Which would be a better choice and why? Write the code using that type of loop. 

3. (TCO 8) Briefly describe how parameter passing by-value and by-reference are accomplished in memory. Write statement 1 to call method A below. Write statement 2 to call method B. Which method uses pass by-value? Which method uses pass by-reference?

How could each of the three errors be corrected to improve the user experience?

5. (TCO 2) Although the following code compiles and runs, the programmer made some major readability errors. Describe at least three changes that would make it easier for other programmers to read and understand the code.

6. (TCO 11) Write a C# program to store an array of integers 10 through 19. Use an appropriate loop to add all of the values in the list. Print out the sum. 

Exp22_Excel_Ch02_ML2 – Vacation Property 1.1

Exp22_Excel_Ch02_ML2 – Vacation Property 1.1

Exp22 Excel Ch02 ML2 – Vacation Property 1.1

Excel Chapter 2 Mid-Level 2 – Vacation Property 

  

Project Description:

You have been hired as a finance manager at Granger vacation homes, a regional construction company that finances and builds vacation properties. As part of your responsibilities you manage mortgage applications. Your predecessor left a partially created document you will use to calculate various details about each property being financed. You will use the VLOOKUP function to help determine mortgage interest rates, IF statements to calculate down payment, various statistical calculations, and XLOOKUP to create a quick search within the document.

     

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

 

Write an IF function in cell D9   that calculates the down payment for the mortgage. The down payment is 15% of   the purchase price if the customer is considered high risk or 5% of the   purchase price if considered low risk. The criteria to assess the risk of the   loan is based on the credit score value in cell B6. Be sure to use the appropriate   absolute or mixed cell references when referencing the input values in the   range B4:B6. Then use the fill handle to copy the formula down, stopping in   cell D28.

 

Enter a formula to calculate the   percent financed in cell E9. The percent financed is the amount   financed/purchase price. Next use the fill handle to copy the formula down,   stopping cell E28.

 

Enter a formula in cell F9 to   calculate the amount financed. The amount financed is the purchase price-down   payment. After entering the formula, use the fill handle to copy the formula   down, stopping in cell F28.

 

Use the VLOOKUP function in cell   G9 to lookup the mortgage rate based on the customer credit score and the   data in the range D4:E6. Be sure to use the appropriate absolute or mixed   cell references. Use the fill handle to copy the formula down, stopping in   cell G28.

 

Calculate the rate per period in   cell H9. All mortgages being financed will be paid monthly. After completing   the formula, use the fill handle to copy the formula down, stopping in cell   H28.

 

Calculate the total number of   payment periods in cell J9 based on the years financed in cell I9. After   completing the formula, use the fill handle to copy the formula down,   stopping in cell J28.

 

Use the PMT function to   calculate the total monthly payment in cell K10 based on the periodic   interest rate, number of periods, and amount financed. Ensure the results are   a positive value then use the fill handle to copy the function, down stopping   in cell K28.

 

Use Quick Analysis to calculate   the total of all payments in cell K29. (Quick Analysis is not available for   Mac. If using a Mac, use AutoSum to calculate the SUM of the range K9:K28).

 

Use the appropriate statistical   functions in the range B32:B36 to calculate descriptive statistics based on   the row headings in the range A32:B36. In cell B32, calculate the total count   of loans based on column A, lowest payment in cell B33 based on the data in   column K, highest payment in B34, average payment in B35, and median payment   in B36. 

 

Use the XLOOKUP function in cell   E32 to lookup the employee number in cell D32 and return the corresponding   down payment, % finances, and amount financed. 

 

Use the appropriate function to   insert the current date and time in cell B2.

 

Save and close the workbook.   Submit the file as directed.

Assignment

 

The website  playground.tensorflow.org  gives you a place to build and play around with simple neural networks. You can build networks with different types of data sets (see the pictures on the left under “DATA”) and then design different kinds of neural networks.

For what’s coming, I find it easier to check the “Discretize output” button over on the right under “OUTPUT.”

Action Items

  1. For each of the 4 sets of test data, build a network with just two inputs (x1  and x2) and no hidden layers.  About how many epochs does it take for the solution to converge (i.e., getting to a point where the solution isn’t changing anymore)? Which data sets can it get right with no hidden layers?
  2. Recall that a network with no hidden layers is basically a perceptron, and a perceptron could only discover classifications that are linearly separable. How can you see that happening with these examples?
  3. For each of the data sets that was not correctly classified with no hidden layers, add hidden layers and other input parameters until you can get the input classified as best as you can. Specify what parameters you used. You might not be able to get them all perfect, but tell me what you did to get close. All things being equal, I’m looking for the simplest model that makes a correct classification.
  4. By the due date indicated, put your answers and testing results into a Word file and submit it.