Pls see attached

 Do the following labs in testout

10.1.7

10.1.8

10.1.9

10.3.7

10.3.10

Technical Content Writing – How To Become A Technical Content Writer?

Introduction:

Surely, to be a successful technical content writer, first you have to master special technical content writing abilities; the only way to succeed in this industry is to be a technical writer with great skills. As we all know, writing is an art. Therefore, every Technical Content Writer should have skills in writing. How can you possibly become one? Keep reading to discover some of the most effective ways on how you can become a Technical Content Writer.

Writing is an art, therefore, technical writers should have a talent in writing. There are many technical writers that are not skilled when it comes to writing. This is why some companies even seek for people who have a technical writing skill so they will be able to hire them. On the other hand, there are also many businesses that prefer to hire non-technical writers as it is cost efficient especially with the tight economy.

Although there are a lot of technical writers nowadays, still the demand for such writers is increasing because there are still many companies that prefer for writing to be done by people who know what subject matter will be discussed in their written works. A technical writer is a writer whose writing has the ability to portray the message that the company wants its readers to have. They should know how to write about the things that they are writing about.

Importance:

You should not only focus in having a good writing skill, but at the same time you must hone your technical skills as well. You need to have a better command over the different terminologies used in writing. You should also be able to understand what your readers are looking for so you will be able to write according to what they are looking for. There are times that your readers are looking for information that has to do with the current topic you’re writing on.

To be able to excel in writing, it is important to have a good understanding of the technical aspects of your subject matter. To be able to enhance your technical writing skills, you can consider taking a course regarding the technical writing skills. There are various colleges that offer courses regarding this skill and you can take one of these if you want to improve your technical writing skills. The advantages of taking up a course is that you would learn to write rules and format, how to properly use keywords in a subject line, how to write paragraphs and using bulleted and divided lists in your works.

Another way in which a person can become a technical writer is to get a degree in this field. A degree in technical writing allows you to write technical contents in a better manner. It will teach you the right way of writing and help you when you are writing for a particular audience. In technical writing, you have to take the time to inform your reader. You should never assume that because a topic is technical that everyone would understand it.

There are many technical writers who fail to earn a decent amount from their works because they do not take the time to hone their writing skills. There are certain guidelines that must be followed by all technical content writers to improve their writing skills and earn a better living. First, you must have the right attitude and mindset to become a good writer. You should never assume that because you are specialized in writing about some technical subjects that everyone would easily understand it. It is important that you know your subject well and you should always write in a manner that makes you clear about what you are writing. Have a look at homeworkmarket blogs too.

Conclusion:

Another way in which you can become a good technical content writer is to expand your horizons. If you have worked in the tech world before, it is always great to network with other technical writers who have the same interests as you. This will help you learn more about the different topics that others are writing about and this will help you better write about these topics. One of the best ways to expand your knowledge on topics is through reading books and other related materials. Reading different books and articles can also give you ideas on different technical subjects that you would like to write about. Visit homeworkmarket for more.

Regards

Content Range

will you be able to do this today

Instructions

#Exp19_Excel_AppCapstone_IntroAssessment_Travel

Solution File + Step by Step Video Link is Available in Answer

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 Spark lines 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.

3 pages added to document 

Excel_2G_Inventory

Excel_2G_Inventory

Project Description:

In the following project, you will edit a worksheet that summarizes the inventory of bulbs and trees at the Pasadena facility.

Steps to Perform:

Step Instructions Points Possible

1 Open the Excel workbook Student_Excel_2G_Inventory.xlsx downloaded with this project. 0

2 Change the Theme to Slice. Rename Sheet1 as Bulbs and Sheet2 as Trees, and then make the Bulbs sheet the active sheet.

If the theme is not available, click Browse for Themes, navigate to your downloaded files, and select Slice.thmx. 3

3 To the right of column B, insert two new columns to create new blank columns C and D. By using Flash Fill in the two new columns, split the data in column B into a column for Item # in column C and Category in column D.

5

4 Type Item # as the column title in column C and Category as the column title in column D. Delete column B. By using the Cut and Paste commands, cut column C—Category—and paste it to column G, and then delete the empty column C. Apply AutoFit to columns A:F. 1

5 Display the Trees worksheet, and then repeat Steps 3 and 4 on this worksheet. 6

6 Make the following calculations in each of the two worksheets without grouping the sheets:

•In cell B4, enter a function to sum the Quantity in Stock data, and then apply Comma Style with zero decimal places to the result.

•In cells B5:B8, enter formulas to calculate the Average, Median, Lowest, and Highest retail prices, and then apply the Accounting Number Format. 14

7 In each of the two worksheets, make the following calculation without grouping the sheets:

•In cell B10, enter a COUNTIF function to determine how many different types of Tulips are in stock on the Bulbs sheet and how many different types of Evergreens are in stock on the Trees worksheet. 4

8 Without grouping the worksheets, complete the following in each worksheet:

•  In cell G14, type Stock Level

•  In cell G15, construct an IF function to determine the items that must be ordered. If the Quantity in Stock is less than 75 the Value_if_true is Order. Otherwise the Value_if_false is OK. Fill the formula down through all the rows. 8

9 Without grouping the worksheets, apply conditional formatting as follows to both worksheets:

•Apply Conditional Formatting to the Stock Level column so that cells that contain the text Order are formatted with Bold Italic, font color set to Automatic, and Fill color set to No Color.

•Apply Gradient Fill Blue Data Bars to the Quantity in Stock column. 4

10 In the Bulbs sheet, format the range A14:G42 as a table with headers and apply Light Orange, Table Style Light 20. If the style isn’t available, choose another style. Insert a Total Row, filter by Category for Tulips, and then Sum the Quantity in Stock column. Record the result in cell B11. 4

11 Select the table, clear the filter, Sort the table on the Item # column from Smallest to Largest (Ascending) and then remove the Total Row. On the Page Layout tab, set Print Titles so that row 14 repeats at the top of each page. 3

12 In the Trees sheet, format the range A14:G42 as a table with headers and apply Light Green, Table Style Light 19. If the style isn’t available, choose another style. Insert a Total Row, filter by Category for Evergreens, and then Sum the Quantity in Stock column. Record the result in cell B11. 4

13 Select the table, clear the filter, Sort the table on the Item # column from Smallest to Largest (Ascending), and then remove the Total Row. On the Page Layout tab, set Print Titles so that row 14 repeats at the top of each page, and then Save your workbook. 3

14 Group the two worksheets. Merge & Center the title in cell A1 across the range A1:G1 and apply the Title cell style. Merge & Center the subtitle in cell A2 across the range A2:G2 and apply the Heading 1 cell style. AutoFit Column A. 5

15 With the worksheets still grouped, center the worksheets Horizontally, change the Orientation to Landscape, and insert a footer in the left section with the file name. Display the Print Preview, and then change the Settings to Fit All Columns on One Page. 

(NOTE: On a Mac, on the Page Layout tab, change the Width to 1 page.)

5

16 Save your workbook and then ungroup the sheets. Make the Trees sheet the active sheet, and then insert a new worksheet. Change the new sheet name to Summary and then widen columns A:D to 170 pixels. Move the Summary sheet so that it is the first sheet in the workbook. 2

17 In cell A1, type Pasadena Inventory Summary. Merge & Center the title across the range A1:D1, and then apply the Title cell style. In cell A2, type As of December 31 and then Merge & Center the text across the range A2:D2. Apply the Heading 1 cell style. 4

18 On the Bulbs sheet, Copy the range A4:A8. Display the Summary sheet and Paste the selection to cell A5. Apply the Heading 4 cell style to the selection. 2

19 In the Summary sheet, in cell B4, type Bulbs. In cell C4 type Trees. In cell D4 type Bulbs/Trees. Center the column titles, and then apply the Heading 3 cell style. 3

20 In cell B5, enter a formula that references cell B4 in the Bulbs sheet so that the Bulbs Total Items in Stock displays in B5. Create similar formulas to enter the Average Price, Median Price, Lowest Price, and Highest Price from the Bulbs sheet into the Summary sheet in the range B6:B9. 5

21 Enter formulas in the range C5:C9 that reference the Total Items in stock and the Average Price, Median Price, Lowest Price, and Highest Price cells in the Trees worksheet. 5

22 In cells D5, D6, D7, D8, and D9, insert Column sparklines using the values in the Bulbs and Trees columns. Format each sparkline using the first five Sparkline styles in the first row. 5

23 To the range B5:C5, apply Comma Style with zero decimal places, and to the range B6:C9, apply Accounting Number Format. Center the Summary worksheet Horizontally and change the Orientation to Landscape. Insert a footer in the left section with the File Name. 5

24 Save and close the file, and then submit for grading. 0

Total Points 100

 After reading the required articles this week(see in the bottom), please write a research paper that answers the following questions: 

• What are mobile forensics and do you believe that they are different from computer forensics?
• What is the percentage of attacks on networks that come from mobile devices?
• What are challenges to mobile forensics?
• What are some mobile forensic tools?
• Should the analysis be different on iOS vs Android?

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 APA7 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. 
• 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.

Reading article:

 Nnoli, H. Lindskog, D, Zavarsky, P., Aghili, S., & Ruhl, R. (2012). The Governance of Corporate Forensics Using COBIT, NIST and Increased Automated Forensic Approaches,  2012 International Conference on Privacy, Security, Risk and Trust and 2012 International Conference on Social Computing, Amsterdam , 734-741. 

Find one article that discusses the globalization of IT and/or computing industry and one article that discuss some aspect of security issues in the IT and/or computing industry.