IS331 Assignment 2

This is a simple assignment, please read the instructions in the attached word document below.

The Stock Symbol you will use for this assignment is PYPL which is Paypal.

Aside from that some important reminders are that some common mistakes you should avoid making are: Forgetting PivotPoint Formula, wrong decimals, volume still has commas, wrong tab name, chart not moved to J1, saving with wrong filename, and less or more than 10 days.

I know the instructions say this but please remember to submit to separate files. The XLSX file which is the “full” Excel Version and the CSV file which is the “plain database” version.

The XLSX (Excel file) opened in Microsoft Excel should contain: formulas, formatting, decimal settings, pivot point calculations, the stock chart.

The CSV (Comma Delimited File) opened in Notepad or a text editor should contain: numbers and text. It should NOT contain formulas, formatting, and charts.

One quick way to know you did it right is to open the CSV files and if you still see the chart, something went wrong. CSV should look boring and plain.

So when you open the XLSX in microsoft excel make sure to check that charts exist, chart is around J1, PivotPoint column has numbers (not blank), prices show 2 decimals, volume has NO commas, exactly 10 days, and the tab name should equal full company name.

When you open the CSV in Notepad you should see rows of numbers, and commas between values. You should NOT see charts or fancy formatting. If it looks plain then that’s good.

Please remember to read the instructions in the word doc attached below, everything you need to know about this assignment is there.

The assignment doesn’t specify how many pages since it’s not a writing assignment, and instead the assignment is literally just creating two tables of datasets, so if you feel like this order costs more for the work that I am asking for you to get done please let me know and I will add funds that are sufficient to the work that I am asking you to do. But please make sure everything is good that all the requirements are met.