Exp19_Excel_Ch02_HOEAssessment_Gateway_Vacations

Excel Chapter 2 Hands-On Exercise Assessment – Gateway Vacations 

Exp19 Excel Ch02 HOEAssessment Gateway Vacations

Project Description:

You have been hired as a loan officer for Gateway Vacation properties, a timeshare company in Southern Florida. As part of your responsibilities, you calculate loan information for customers who purchase timeshares. You will use Excel to calculate down payment, interest rate, and total payment information.

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

Click cell B2, click   the Formulas tab, click Date & Time in the Functions Library group.   Select NOW, and then click OK to enter today’s date in the   cell.

Click cell D9. On the   Formulas tab, click Logical in the Function Library group, and select IF.   Type C9<$B$6 in the Logical_test box, type B9*$B$4   in   the Value_if_true box, and type B9*$B$5 in the Value_if_false box.   Click OK, and use the fill handle to copy the contents of cell D9 down the   column. Click Auto Fill Options, and click Fill Without Formatting.

Click cell E9, type =(B9-D9)/B9, and use the fill   handle to copy the contents of cell E9 down the column. Click Auto Fill   Options, and click Fill Without Formatting.

Click cell F9, type   =B9-D9,   and and press CTRL+ENTER. Use the fill handle to copy the contents of cell F9   down the column. Click Auto Fill Options, and click Fill Without Formatting.

Click cell G9, click   Lookup & Reference in the Function Library group and select VLOOKUP. Type   C9   in the Lookup_value box, type $D$4:$E$6 in the Table_array box, and   type 2 in the Col_index_num box. Click OK.

With cell G9   selected, use the fill handle to copy the contents of cell G9 down the   column, stopping at row 28. Click Auto Fill Options, and click Fill Without   Formatting. With the range G9:G28 selected, on the Home tab, in the Number   group, click Increase Decimal twice.

Click cell H9, type   =G9/12,   and press CTRL+ENTER Use the fill handle to copy the contents of cell H9 down   the column, stopping at row 28. Click Auto Fill Options, and click Fill   Without Formatting. With the range H9:H28 selected, on the Home tab, in the   Number group, click Increase Decimal twice.

Click cell J9, type   =I9*12,   and press CTRL+ENTER. Use the fill handle to copy the contents of cell J9   down the column. Click Auto Fill Options, and click Fill Without Formatting.

Click cell K9. Click   the Formulas tab, click Financial, and then click PMT. Type H9 in the rate box, J9 in the NPER box, and   type -F9 in the Pv box. Click OK. 

Use the fill handle   to copy the contents of cell K9 down the column. Click Auto Fill Options, and   click Fill Without Formatting.

Click cell K29, press   ALT+=, and press ENTER.

Click cell B32, type  =COUNT(A9:A28), and press CTRL+ENTER to   calculate the total # of loans.

Click cell B33, type   =MIN(K9:K28), and press CTRL+ENTER to calculate the lowest monthly payment.

Click cell B34, type   =MAX(K9:K28), and press CTRL+ENTER to calculate the highest monthly payment.

Click cell B35, type =AVERAGE(K9:K28), and press   CTRL+ENTER to calculate the average monthly payment.

Click cell B36, type =MEDIAN(K9:K28), and press   CTRL+ENTER to calculate the median monthly payment.

Create a footer with   your name on the left side, the sheet name code in the center, and the file   name on the right side.

Save and close Exp19_Excel_CH02_Assessment_Timeshare.xlsx.   Exit Excel and submit as directed.

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

Post between 200 and 300 words.

TRUE/FALSE

1. T F The functions fscanf and fgetc input data from files. 

2. T F Each data file must have an internal and an external name. 

3. T  F The file open mode “w” opens a file for writing. 

4. T  F We can use the fprintf function to write data into a text file. 

5. T F Assume that value is a variable of type int, the function call 

fscanf (stdin, “%d”, &value); is correct. 

6. T F  fscanf( ) and fprintf( ) are declared in the standard header file stdlib.h 

7. T F A text file is terminated by EOF. 

8. T F  The statement ifp = fopen(My_file”, “r”); opens a file for reading: 

9. T F The function sprintf( ) writes characters to a string. 

10. T F When a text file is opened, we have access to it at its beginning or 

end. 

11. T  F The main difference between scanf and sscanf is that sscanf gets its 

input from the string variable, which is its first parameter, whereas 

scanf gets its input from the standard input device. 

12. T  F The standard output function sprintf behaves like printf except it 

stores the output in its first parameter, which is a string variable. 

13. T F  The statement fprintf (test_scores, “%d”, score); writes a datum to a 

file named test_scores that has been opened in output mode. 

14. T  F It is possible to reopen in input mode a file that has been opened in 

output mode without closing it. 

15. T F If the file open mode for a data file is “w” an input statement 

referencing the file will read a datum from it.  

16. T F The output of a computer program can be directed to the standard 

output device, which is usually the monitor screen. 

17. T F  printf (“%d %d”, a; b); is syntactically legal. 

18. T F  scanf (“Enter a value for x: “, c1); is syntactically correct. 

Read and reflect on the article, “ Create Table, Select, Insert, Update, Delete Table In SQL (c-sharpcorner.com) 

Take notes on the main points, and consider the following questions:

When inserting data, what are the problems that can occur if you don’t enter the datadi in the same order as the columns? Why do you get an error if you don’t enter data for all the columns?

When you update a table what is best practice to do prior to updating the data? What business issues may occur if you don’t use a qualifier, for example, a WHERE keyword when updating data.

When you update a table, what is best practice to do prior to deleting the data? What are possible business concerns you might have if you don’t use the WHERE keyword when deleting data? What reasons are insert, update, and delete commands so vitality important from a business standpoint?

Go to the discussion board for this course on your university’s LMS (learning management system). Submit a brief reflection (approximately 100 words) on the video, and discuss the questions posed above. Then, respond to at least one additional post on the discussion board.

Briefly respond to all the following questions. Make sure to explain and backup your responses with facts and examples. This assignment should be include at least two references.APA formate 

As you consider the reputation service and the needs of customers or individual consumers, as well as, perhaps, large organizations that are security conscious like our fictitious enterprise, Digital Diskus, what will be the expectations and requirements of the customers? Will consumers’ needs be different from those of enterprises? Who owns the data that is being served from the reputation service? In addition, what kinds of protections might a customer expect from other customers when accessing reputations?

1. Museum Background and Visit Experience (25 points):

This portion should be comprised of information about the museum you selected to visit.  What was your personal experience of walking through the facility? How did you feel, particularly while taking this course?  What senses did this stimulate? What works caught your eye? Also include a light background on the museum and description of the space and format of the galleries as it pertains to viewing the artworks.    

* Length:  At least 500 words, no more than 750 words.

2. Artist (25 points): This portion should be comprised of information about the artist of your choice as well as why you selected them. Begin with: Who is the artist? Why did you choose the artist – what is generally interesting to you about it? Additional suggestions for material: date and place of birth and death, family information, lifetime accomplishments, famous art pieces, effects or impact on society, or historical significance. 

* Length:  At least 500 words, no more than 750 words.

3. Critical Analysis Artwork: Objective Response (25 points):  

This portion of the writing assignment should be your own objective critical response to a work of art by the same artist you chose.  You must base your opinion on formal elements of art (EOA) and the principles of design (POD) – using this specific vocabulary throughout. Describe the of the artwork = use descriptive adjectives = a description is what you see in the artwork, NOT an interpretation. provide appropriate background information about the artwork.  Your objective interpretation/POV should be supported through an explanation of HOW the FEA, POD & context support your interpretation. Which media that we have learned about is utilized to create this artwork?  How does the artist’s use of their selected media (material) emphasize and support their content – the meaning of the work? Does it align to your subjective response?

Things to consider: how does the artist’s use of the EOA and POD to emphasize and support their content – the meaning of the work?  Be sure to not simply describe the work, but rather, elaborate with specific details from the work that illustrate your analysis.  Answering the “HOW” part is crucial to your analysis. It is not enough to just identify the characteristics and list a few historical facts; you have to synthesize the information into a cohesive interpretation.

* Include the title of the work (in italics) and a picture of the artwork

* Length:  At least 500 words, no more than 750 words

4. Critical Analysis Artwork Subjective Response (25 points):  

This portion should be your own subjective response to a work of art (the same you selected above) by the same artist you selected.  Why did you choose the artwork – what is generally interesting to you about it? What was your initial, subjective interpretation of the artwork?  What is the artwork saying to its audience, to you? What does the artwork mean? Did it change as you found out more about the context of the artwork? What emotions, concepts, or ideas did it provoke in you?  Do not simply describe the work or state whether or not you “like” the work; but rather, elaborate with specific details from the work that illustrate your response. Are there broader thematic messages conveyed by the artwork? What are they?

* Length:  At least 500 words, no more than 750 words.

5. Bibliography (25 points):  You must provide a bibliography in one of the formal the correct citation styles that includes at least 5 sources.  Online sources are ok, but at least one source must be a book/journal/periodical/catalog and must be in addition to your textbook, and remember, Wikipedia doesn’t count. You are encouraged to research the artwork at your school’s library by searching through books and articles, written by scholars in the field of art and art history. Check out your campus’s library online and ask a librarian or tutor for help. 

– need one page

odule 11 question about Identify Threats

The increasing pace of digital transformation requires network administrators, technicians, engineers, architects, executives, and even users to consistently monitor shifting vulnerabilities and new threats. While you can never identify every threat to a network, it’s important to regularly identify the greatest threats and develop strategies to protect against them. After working through this module and building on all you’ve learned earlier in this course, you’re developing a solid understanding of the types of threats faced by today’s networks. Do some research online to find what today’s network admins are most concerned about. Then, respond to the following question:

• In your opinion at this point in your career, what do you believe is the greatest threat network admins should work to mitigate on their networks?

This week, you have read about entrepreneurship in a global economy. For your written assignment this week, complete a case study of the organization you work for (use a hypothetical or “other” organization if more applicable) that will address the following prompts:

• Describe the organization’s environment, and evaluate its preparedness to go global, if not already, and it’s strategy for staying global if it is.
• Research other company’s strategy for going global and explain if this will or will not work for your company. 
• Make a recommendation for a global strategy in the organization, including a justification for your recommendations.

Submit your midterm research paper as a single document. Your paper should meet the following requirements:

• Be approximately four to six pages in length, not including the required cover page and reference page.
• Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
• Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.
• Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

1. Upload your Industry Article assignment as a Word document by DAY TWO (2) to give your student reviewer ample time to complete their review. Include the following in the initial discussion post which will help to establish context for the reviewer and others in the course.
   1. the title of the article,
   2. the name and NAICS code for the selected industry, and
   3. the name and hyperlink for at least one industry journal editorial guidelines and submissions criteria.
   4. Write a paragraph for the initial post to include the title of the article and summarization of it to help establish context for the reviewer and other readers in the course.
   5. The instructor will assign each student to a specific student paper for conducting a peer review. Do not conduct a peer review until the instructor has assigned you an article.
2. Download the Article Peer-Review Template(Word document).
3. Download the Industry Article assigned for your peer review.
4. Complete the peer review using the template as the guide, following the prompts below:
   1. Insert your full name in the header or the footer of the blank template
   2. Complete the template in its entirety, assessing the other student’s article based on the critical thinking intellectual standards criteria, as adopted from The Miniature Guide to Critical Thinking, and the other comment sections in the template.
   3. Include appropriate, evidence-based, honest and respectful feedback using single-line spacing in the areas provided in the template.
   4. Once the review is completed, review and edit, then save each Word document template as a PDF file.

Use this below article to review 

a.  Did COVID-19 Derail the Patient Experience?

b.  NAICS code:  62 Healthcare and Social Assistance 

Instructions: 

You should compose your report in your own words – do not directly copy from the material I
give to you. In the case that you quote the words of the original authors, use quotation marks “”.
For example,
Albert Einstein said: “Life is like riding a bicycle. To keep your balance you must keep moving.”
If you cite any work other than the material I give you, you should use a standard citation format.
For example,
Drinking 4000 ml water a day does not have more health benefits than drinking 3000 ml water a
day [1].
[1] A.J. Meinders and A. E. Meinders. “How much water do we really need to drink?”
Nederlands tijdschrift voor geneeskunde 154 (2010): A1757-A1757.

The font size of your report should be 11, and the line spacing should be 1.5. You should use a
serif font (e.g. Times New Roman, Cambria). You must use the same font for the entire report.
Your text should have a 1-inch margin to all 4 edges. You can put figures in your report if
necessary.