Need to write about 2 pages (1.5 line spacing and 11 or 12 font size) of summary of chapter, so that it contains:

(part 1) important concepts of the chapter

(part 2) experience/application/opinions of the chapter.  

Write a program that uses while loops and performs the following

Prompts the user to input 2 integers firstNum and secondNum // Easy

Output all odd numbers between firstNum and secondNum // No idea how to start that.

Outputs the sum of all even numbers between firstNum and secondNum

Output the numbers and their squares between 1 and 10

Output the sum of the square of the Odd Numbers between firstNum and secondNum

Output ALL Uppercase letters

#Exp19_Excel_Ch05_ML1_RealEstate

#Exp19 Excel Ch05 ML1 RealEstate

Project Description:

You are a real estate analyst who works for Mountain View Realty in the North Utah County area. You have consolidated a list of houses sold during the past few months and want to analyze the data. For a simple analysis, you will outline the data and use the Subtotal feature. You will then create two PivotTables and a PivotChart to perform more in-depth analysis.

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

Before subtotaling the data, you   want to calculate the selling price as a percentage of the asking price.
 

  In cell G2 in the Sales Subtotals sheet, insert a formula to calculate the   selling price percentage of the asking price, format it with Percent Style   with one decimal place, and then copy the formula down the column.

Real estate agents often analyze   how long houses are on the market. You will calculate the number of days   between the listing date and the sale date.
 

  In cell J2, enter a formula to calculate the number of days between the   listing date and sale date. Copy the formula down the column.

You are about ready to subtotal   the data. First, you will sort the data.
 

  Sort the list by City in alphabetical order, then by Selling Agent in   alphabetical order, and finally by Listing Date in chronological order   (oldest to newest).

You want to display subtotals   for three columns to analyze the averages.
 

  Use the Subtotal feature to calculate the average selling price, percentage   of asking price, and days on market by city. Ensure that Summary below data   is selected, and then click OK. Group the data using the Auto Outline   feature. Collapse the outline to hide the listing and sale dates. Click the   outline symbol to display the grand average and city average rows only.

Now you are ready to format the   data and set a print area to print only a select portion of the worksheet.
 

  Format the average days on market as numbers with zero decimal places. Apply   wrap text in cells G1 and J1. Set a print area for the range C1:J88.

Select individually columns G   and J and change the column width to 10. Change the row height to 24 for the first row.

Go to cell C101, read the   questions, and type the correct answers in the respective highlighted cells   in the range G102:G106. Do not copy and paste results from the subtotal rows.   Type the numeric values rounded to the nearest whole number.
 

  Apply Accounting Number Format with zero decimal places to cell G102.

PivotTables help you analyze   different perspectives of data. You will create a PivotTable using the Sales   Data worksheet.
 

  Click the Sales Data worksheet and create a blank PivotTable on a new   worksheet. Name the new worksheet PivotTable. Name the PivotTable Average City Prices.

Part of the process is arranging   and rearranging fields to provide the perspective to represent the data best.   In addition, you want to display average values instead of total values.
 

  Place the City field in rows, the Selling Agent field in columns, and the   Asking Price and Selling Price fields as values. Display averages rather than   sums with Accounting Number Format with zero decimal places. Pivot the data   by placing the City field below the Values field in the Columns area and   moving the Selling Agent field to the Rows area.

Now you want to focus on real   estate data for only two cities.
 

  Add a filter to cell B3 to display only Alpine   and Cedar Hills.

Go back to the Sales Data   worksheet. You realize that a selling price is incorrect.
 

  Change the selling price for Number 40 from $140,000 to $1,400,000. Refresh the PivotTable.

You want to format the   PivotTable.
 

  Change the widths of columns A, B, C, D, and E to 11. Change the width of column F to 14 and the width of column G to 13.14. Wrap text and center   horizontally data in cells B4, D4, F4, and G4. Apply the Bottom Border to the   range B4:E4. Change the label in cell A5 to Agent. Change the height of row 4 to 40.

You want to create another   PivotTable to look at the selling prices by city.
 

  Display the Sales Data worksheet. Create a Recommended PivotTable using the   Sum of Selling Price by City thumbnail.
  Note, Mac users, insert a PivotTable on a new worksheet. Add City to the Rows   area and Selling Price to the Values area.
 

  Change the name of the new PivotTable worksheet to Selling Price.

Change the value to display   averages not sums. Apply the Accounting Number Format with zero decimal   places to the values. Apply Light Blue, Pivot Style Medium 2 to the   PivotTable.
 

  Note, depending upon the version of Office being used, the style name may be   Pivot Style Medium 2.

You decide to create a   PivotChart to illustrate the PivotTable data visually.
 

  Create a clustered column PivotChart from the PivotTable on the Selling Price   worksheet. Move the chart to a chart sheet named Sales Chart.

The chart should have a   meaningful title. You will also modify some chart attributes.
 

  Change the chart title to Average Selling Price by City and apply Dark Blue font color.   Remove the legend. Apply Dark Blue fill color to the data series.

Create a footer with your name   on the left side, the sheet name code in the center, and the file name code   on the right side of all worksheets. Adjust the Page Setup scaling, if   needed.

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

#Exp19_Excel_AppCapstone_IntroAssessment_Travel

#Exp19 Excel AppCapstone IntroAssessment Travel

# Excel Introductory Capstone Assessment – Travel 

Project Description:

You are considering several cities for a vacation. In particular, you are interested in Washington DC, Philadelphia, and Boston. You will format a list of memorials in DC, add Sparklines to compare the number of visitors over a 15-year period, and create a bar chart to illustrate annual visitors at each memorial. In addition, you will create a table of sightseeing locations, sort and filter the data, apply conditional formatting, and add a total row to display average time needed to spend at each memorial. Finally, you will complete a worksheet by adding formulas to compare estimated major expenses for each city.

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

On the DC sheet,   check the spelling and correct all misspelled words.

On the DC worksheet,   select the range A4:G4, wrap the text, apply Center alignment, and apply   Blue, Accent 5, Lighter 60% fill color.

On the DC worksheet,   merge and center the title in the range A1:G1. Apply Blue, Accent5 cell style   and bold to the title.

On the DC worksheet,   change the width of column A to 34.

On the DC worksheet,   select the range C5:F10 and insert Line Sparklines in the range G5:G10.

On the DC worksheet,   select the range G5:G10, display the high point sparkline marker, and change   the color of the high point markers to Dark Red.

On the DC worksheet,   select the range G5:G10, apply Same for All Sparklines for both the vertical   axis minimum and maximum values.

On the DC worksheet,   select the ranges A4:A10 and C4:F10 and create a clustered bar chart. Apply   the Monochromatic Palette 12 chart color. Apply the gradient fill to the   chart area. Do not change the default gradient options.

Cut the chart and   paste it in cell A13. Change the chart height to 6″ and the chart width   to 7″. Add Alt Text The bar chart shows the number of visitors   to each memorial for the years 2002, 2007, 2012, and 2017.

Change the chart   title to Annual Visitors. Apply Blue, Accent 5, Darker   25% font color to the chart title and category axis labels. Change the value   axis display units to Millions. Add Primary Minor Vertical gridlines to the   chart.

Apply data labels to   the outside end of the 2017 data series. Apply Number format with 1 decimal place to the   data labels.

On the Places sheet,   find all occurrences of BOS and replace them with Boston.

On the Places sheet   tab, convert the data to a table, assign the table name Tourist_Attractions, and apply Blue,   Table Style Medium 2.

On the Places sheet,   freeze the top row.

On the Places   worksheet, sort the data by City in alphabetical order and then within City,   sort by Sightseeing Locations in alphabetical order.

On the Places   worksheet, add a total row to display the average of the Time Needed column.   Apply Number format with zero decimal places to the total.

On the Places   worksheet, select the values in the Time Needed column and apply conditional   formatting to highlight cells containing values greater than 60 with Light Red Fill.

On the Places   worksheet, apply a filter to display only fees that are less than or equal to   $10.

On the Cities   worksheet, click cell F4 and enter a formula that will subtract the Departure   Date (B1) from the Return Date (B2) and then multiply the result by the   Rental Car per Day value (F3).

On the Cities   worksheet, click cell E13. Depending on the city, you will either take a   shuttle to/from the airport or rent a car. Insert an IF function that   compares to see if Yes or No is located in the Rental Car? Column for a city.   If the city contains No, display the value in cell F2. If the city contains   Yes, display the value in the Rental Car Total (F4). Copy the function from   cell E13 and use the Paste Formulas option to copy the function to the range   E14:E18 without removing the border in cell E18.

On the Cities   worksheet, click cell F13. The lodging is based on a multiplier by City Type.   Some cities are more expensive than others. Insert a VLOOKUP function that   looks up the City Type (B13), compares it to the City/COL range (A7:B10), and   returns the COL percentage. Then multiply the result of the lookup function   by the Total Base Lodging (B5) to get the estimated lodging for the first   city. Copy the function from cell F13 and use the Paste Formulas option to   copy the function to the range F14:F18 without removing the border in cell   F18.

On the Cities   worksheet, click cell H13 and enter the function that calculates the total   costs for the first city, including airfare, shuttle or rental, lodging, and   meals. Copy the function in cell H13 and use the Paste Formulas option to   copy the function to the range H14:H18 without removing the border in cell   H18.

On the Cities   worksheet, select the range E14:H18 and apply Comma Style with zero decimal   places. Select the range E13:H13 and apply Accounting Number format with zero   decimal places.

On the Cities   worksheet, in cell I2, enter a function that will calculate the average total   cost per city. In cell I3, enter a function that will identify the lowest   total cost. In cell I4 enter a function that will return the highest total   cost.

Group the three   worksheets and create a footer with Exploring Series on the left side,   the sheet tab code in the center, and the file name code on the right side.

On the Cities   worksheet, select Landscape orientation, set a 1″ top margin, and center   the worksheet data horizontally on the page.

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

  Exp19_Word_Ch01_Cap_Space

Project Description:

As an intern with NASA’s Space Camp program, you are involved with promoting related educational opportunities. You use Word to prepare a two-page flyer, ensuring a well-designed, error-free, and informative document.

Start   Word. Download and open the file named Exp19_Word_Ch01_Cap_Space.docx. Grader has automatically added   your last name to the beginning of the filename.

Inserting text from an existing   document can save time and ensure accuracy. For example, suppose you are   reusing text from an earlier memo, making a few additions or modifications.   Simply insert text from the earlier memo into the currently open document,   and then modify as necessary. In this case, you include text from a earlier   developed flyer that is appropriate for this one, saving time in retyping the   text.
 

  Display nonprinting characters. In the blank paragraph above Adult Space Academy on the second   page, insert text from Family.docx.

Hyphenated text that should not   be separated between lines can be forced to remain together by the insertion   of a Nonbreaking Hyphen between the words.
 

  Remove the two blank paragraphs after the Family Space Camp section. Replace   the hyphen following the word three in   the paragraph below the Adult Space   Academy heading with a Nonbreaking Hyphen.

By viewing a document as multiple   pages, you will often identify problems with layout or placement of objects.   When working on a page in Print Layout view, you are less likely to consider   its placement within the document as a whole, so it may be beneficial to view   a lengthy document in the multiple page arrangement occasionally.
 

  Preview the document in Multiple Pages. Note the poor placement of the text   box on the third page. Remove the five blank paragraphs before the text box   so that it moves up the page to a better position. Be sure that you do not   delete the end of paragraph marker after Perform   an extended-duration simulated mission! The document should display as   two pages. Return to 100% view.

Change margins to Narrow. Insert   a page break before the Family Space   Camp heading at the bottom of the   first page. Return to 100% view.

If major headings in a document   are formatted in hierarchical fashion, collapsing the display to Outline view   enables you to check the arrangement and even rearrange sections, if   necessary.
 

  Change the view to Outline. Click All Levels beside Show Level and select   Level 1 to show only major headings. Click + beside Space Camp and drag the heading to position it above Space Academy. Click Close Outline   View in the Close group.

Because nonprinting characters   are displayed, you can see the page break indicator, so it is easy to delete.
 

  Remove the page break on the first page along with the subsequent blank   paragraph mark that precedes Space   Academy. Insert a page break before the Family Space Camp heading.

Including a registered symbol   beside the camp name provides proper legal acknowledgment to a product or   entity.
 

  Insert a registered symbol after the words Space Camp in the first body paragraph under the Space Camp   heading. Ensure that the symbol is placed beside the camp name in the   paragraph and not beside the camp name in the heading.

Including selected document   properties as a header or footer helps to identify the document in printed   form at the top or bottom of every page.
 

  Insert an unformatted left-aligned footer with the Document Property,   Keywords, inserted as a field. You should select from Quick Parts on the   Header & Footer Tools Design tab when inserting the footer. Close the   footer.

A watermark is often used to   identify a document by its purpose or owner. In this case, it is identified   as a copy.
 

  Insert a horizontal blue watermark with the word Copy (type the text using the correct case). The Blue   color is the eighth color shown in Standard colors.

Although not shown when a   document is displayed or printed, document properties serve a purpose in   identifying a document’s origin, owner, or purpose, among other things. They   can also serve as search terms to help locate the file later.
 

  Open Document Properties and add Space Camp Flyer as the Subject.

A flyer is typically intended   for widespread distribution. By checking a document carefully for errors   before the document is distributed, you are viewed as well-prepared and   professional; your effort is more likely to be taken seriously.
 

  Check the document for spelling and grammatical errors. Correct any errors,   Use the thesaurus to identify a synonym for the word exciting in the first paragraph under the Adult Space Academy   heading. The synonym you select should begin with the letter t. Change the word an that precedes the newly inserted   synonym to the word a so that it is grammatically correct.

In the case of any document   intended for distribution, you should ensure that it is readable by as much   of your audience as possible. Checking for accessibility enables you to   identify and address any concerns that might limit accessibility by those   with various disabilities.
 

  Check for accessibility and correct any problems identified.

Save and close Exp19_Word_Ch01_Cap_Space.docx. Exit   Word. Submit the file as directed.

After this weeks readings and your own research, describe and discuss ways, if any, we can safely share security data.Are there precautions we can take, technical solutions we can use, e.g., like using the CIA triad, or should we just not share these kinds of data? Feel free to argue for and against, just make sure to back up your statements with scholarly support.

Please make your initial post and two response posts substantive. A substantive post will do at least TWO of the following:

• Ask an interesting, thoughtful question pertaining to the topic
• Answer a question (in detail) posted by another student or the instructor
• Provide extensive additional information on the topic
• Explain, define, or analyze the topic in detail
• Share an applicable personal experience
• Provide an outside source (for example, an article from the UC Library) that applies to the topic, along with additional information about the topic or the source (please cite properly in APA 7)
• Make an argument concerning the topic.

At least one scholarly source should be used in the initial discussion thread. Be sure to use information from your readings and other sources from the UC Library. Use proper citations and references in your post.

Answer the 6 questions who, when, where, why (all together in 1-2 sentences) then HOW and WHAT in 2-3 sentences EACH -we need detail), then write an objective summary using the sample in the resource manual as a template.

• Objective 1: Identify the elements of a scholarly research article: who conducted it (plus credentials or affiliation), when and where it was conducted, why the research was undertaken, how it was conducted (methodology), and what was found (results).

NOTES TO HELP YOU WITH YOUR HW 

Complete this note sheet for research article before you start the objective summaryW(5)H(1):1. Who conducted the research?2. Why was the study completed (purpose / what researchers hoped to learn)?3. When was data collected (not the publication year)?4. Where was data collected (physical location)examples:in hospitals in NY State,in rural China,in 3 countries in Africa: Burkina Faso, Cameroon, and Djibouti)?5. How was data collected (methodology)?6. What were the findings?

 You have been assigned to investigate whether or not an employee at a local hospital has been accessing patient records and selling information to online pharmacies. It is your first day of the investigation. Put together a list of data sources that must be examined during the investigation. 

Scenario

Due to the Always Fresh expansion, management wants additional network controls to protect their growing network.

Assignment: 

Consider the Windows servers and workstations in the domains of a typical IT infrastructure. Based on your understanding of network security controls, recommend at least four possible controls that will enhance the network’s security. Focus on ensuring that controls satisfy the defense in depth approach to security.

Summarize your network security controls in a summary report to management. You must provide rationale for your choices by explaining how each control makes the environment more secure.

Submission Requirements

Format: Microsoft Word (or compatible)

Font: Times New Roman, size 12, double-space

Citation Style: APA

Length: 2 to 4 pages

1. While blockchain is successful with cryptocurrencies, it is also beneficial for information governance in businesses. After reading this article (https://www.everteam.com/en/role-of-blockchain-in-information-governance/), discuss at least two ways you foresee blockchain transforming information governance in businesses. Be sure to utilize sources and provide at least one detailed example of your findings. At least one scholarly source should be used in the initial discussion thread.

2. We learned that e-mail is a major area of focus for information governance (IG) efforts, and has become the most common business software application and the backbone of business communications today. In addition, the authors provided details to support their position by providing 2013 survey results from 2,400 corporate e-mail users from a global perspective. The results indicated that two-thirds of the respondents stated that e-mail was their favorite form of business communication which surpassed not only social media but also telephone and in-person contact. With this detail in mind, briefly state why the e-Mail has become a critical component for IG implementation? At least one scholarly source should be used in the initial discussion thread