I need to write a term paper on the topic Siemens Simatic- PCS7/WINCC (SCADA) 

Exp19_Excel_AppCapstone_IntroAssessment_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.

Steps to Perform:

Step

Instructions

Points    Possible

1

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.

0

2

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

2

3

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

6

4

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

4

5

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

3

6

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

4

7

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.

4

8

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

2

9

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.

5

10

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.

6

11

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.

5

12

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

4

13

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

2

14

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

4

15

On the   Places sheet, freeze the top row.

2

16

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

3

17

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.

3

18

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.

3

19

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

3

20

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).

5

21

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.

6

22

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.

6

23

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.

3

24

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.

3

25

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.

6

26

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.

3

27

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

3

28

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

0

Total   Points

100

 Exp22_Excel_Ch04_CumulativeAssessment_AutoSales 

  Step by Step Video link is also available in the Answer Portion

Project Description:

You work for Rockville Auto Sales and have been asked to aid in the development of a spreadsheet to manage sales and inventory information. You will start the task with a prior worksheet that contains vehicle information and sales data for 2018. You need to convert the data to a table. You will manage the large worksheet, prepare the worksheet for printing, sort and filter the table, include calculations, and then format the table 

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

Freeze the first row on the   Fleet Information worksheet.

Convert the data to a table,   name the table Inventory, and apply the Gold, Table Style Medium 19.

Remove duplicate records.

Sort the table by Make in   alphabetical order, add a second level to sort by Year Smallest to Largest,   and a third level to sort by Sticker Price Smallest to Largest.

Repeat the field names on all   pages.

Change page breaks so each   vehicle make is printed on a separate page.

Add 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.

Click or navigate to the Sales   Information worksheet and convert the data to a table, name the table Sales, and apply the Green, Table   Style Dark 11.

Type % of sticker in cell E1.

Create a formula with structured   references to calculate the percentage of the Sticker Price in column E.

Format the range E2:E30 with   Percent Style Number Format.

Add a total row to display the   Average of % of sticker and Sum of Sticker Price and Sale Price.

AutoFit the width of columns B:E   to show the total values.

Select the range E2:E30. Apply   Solid Fill Blue Data Bars conditional formatting to the % of sticker data.

With the range E2:E30 selected,   create a new conditional formatting rule that uses a formula to apply yellow   fill and bold font to values that sold for less than or equal to 70% of the   sticker price.

On the First Quarter Sales   worksheet, rename the table FirstQuarter.

Filter the data to display January, February, and March sales.

Add 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.

Select Landscape orientation for   all sheets.

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

SIMnet for Word, Excel, Access, and PowerPoint 365/2019 Complete, Manning SIMbooks. Needs to be done with US ip address. Easy assignment but needs to be completed in 5 days.

 The project requires building of a NLP classifiers and sentiment analysis based on the below guidelines. I have attached the Rmarkdown file and required input files for the analysis. please use Python to do the below steps preferably. The ‘cleaned_subtitles’ will be the dataset used for the analysis and ‘movie reviews’ file is what you should use for sentiment analysis

Classifcation:

– Pick several nouns and/or verbs from your previous assignment. Create a column in the dataframe that indicates if that line from the movie/TV show includes that word or does not include that word. You can use 0 and 1 or any labels that make sense to you. Remember, we covered regular expression detection and deletion in the raw text assignments! – Once you have created this column, use string replacement to delete that word from your subtitles. We will take the word out to see if we can predict when it is used – if you leave it in, it’s a perfect predictor! – Use *two* feature extraction methods and *two* machine learning algorithms to determine if you can predict when your noun or verb will be used. You should include four different classification reports below. 

Sentiment:

– Use *one* of the unsupervised lexicon techniques to create sentiment scores for your movie/TV show. – What is the overall sentiment of your movie/TV show? How would you interpret the scores provided? – Using the movie reviews mini dataset provided online, create a sentiment tagging model (one feature extraction method + one algorithm). – With this new model, create sentiment scores for your movie/TV show. – What is the overall sentiment using the new model of sentiment tagging? How would you interpret the scores provided? 

 Consider these three discussion points

There are various languages, some are better for data visualization than others.  Please review the basics of Python, SAS, R, and SQL.  What are the qualities of each language regarding data visualization (select at least two to compare and contrast)?  What are the pros and cons of each regarding data visualization (select at least two to compare and contrast)?

I need the implementation of a paper done in which you need to encrypt a picture using AES with using key from some other system. I can share full details if someone is interested in doing that. It is an assignment and needs to be done in a week.This assignment is related to Encryption and python.

I am given with an assignment to implement a paper. Here is the link of the research paper: https://drive.google.com/file/d/1QYt4CB-wAOgHpU3SKYrT-NOfXS4zSUeL/view?usp=sharing There are certain things that needs to be changed. Key used must be different than used in this paper. Key must be from some other system like any other encryption algorithm. Encrypted and decrypted image must display as in paper. Source code must be well formatted and commented. Must be written in python. Can use libraries of python. I can provide more information or the code that i did. 

If someone can do. Deadline can be extended if i know that you can do. Can get another one week if find someone who can do it. 

Please read the document before bidding. Bid if you can do it.

Submit an answer so that I get the idea that you can do it. 

In 500 words, discuss the benefits of DNS failover as an adjunct to cloud failover. 

Do not use References from Google.

Course Reflection (Extra points)

Due 5/7/

Note: Write no shorter than half page of your reflection and feedback regarding this course. Feel free to write down your thoughts and suggestions. The purpose of this assignment is to help you summarize and reflect on what you have learned from this class during the semester.  Some things to think about:

1. What did you personally gain from this course? Was it a meaningful learning experience?  Do you view electronic documents and records management differently now?  What was harder/easier than expected?  What “gaps” did you feel there were in your knowledge which may have impacted your performance in this class? 
2. Feedback on the assignments and class exercises. Could you find the information you needed?  What have you learned from the assignments?  Any assignment or class exercise you found relevant and memorable?