Project Description:

You work as a data analyst for Camino Marketing, a U.S.-based web marketing company. You have been asked to conduct an employee satisfaction survey. As part of the survey, you will collect sample data to help provide insight into employee salaries, productivity within the three national offices, and to predict the growth of the New York office’s client base by 2025.

2

Ensure the Employee Satisfaction   worksheet is active, then use the FREQUENCY function to calculate the   frequency distribution of job satisfaction in column D. Place your results in   the range G5:G9.

3

Enter a function in cell G12 to   calculate the standard deviation of column c.

4

Enter a function in cell G13 to   calculate the variance between salaries. 

5

Enter a function in cell G14 to   calculate the Covariance of the salaries and job satisfaction in the data   set. Note this is a sample of data not a population.

6

Enter a function in cell F17 to   calculate the correlation coefficient between employee salary and job   satisfaction.

7

Ensure the Data Analysis ToolPak   add-in is active. Use the Data Analysis ToolPak to create a histogram based   on the salaries in column C. Use the range I4:I9 as the Bin Range. Ensure   that Cumulative percentage, column labels, and chart output are included in   the results. Place the results in cell K4. Edit the result text in cell K4 to   display   Salary, if   necessary.

8

Ensure the Office_Data worksheet   is active. Use the Data Analysis ToolPak to perform a single factor ANOVA on   the range C3:E35. Place the results starting in cell G3. Be sure to include   column labels. Resize columns G:M as needed.

9

Create a Forecast Sheet that   depicts year over year growth in customer growth. Set the Forecast end year   as 2025 and place the results on a new worksheet named 2025Forecast.

10

Ensure the Customers worksheet   is active then create a scatter plot chart that places the Years on the X   axis and the Clients on the Y axis. Add a linear trendline to the chart that   also shows the Equation and the R-square. Add the title Customer   Growth.

11

Enter a function in cell E4 to   calculate the intercept of the linear trendline created in the prior step.

12

Enter a function in cell F4 to   calculate the Slope of the linear trendline.

13

Enter a function in cell G4 to   calculate the R-square of the linear trendline.

14

Enter a function in cell H4 to   calculate the Standard Error. 

15

Use the FORECAST.LINEAR function   in cell E7 to the total number of customers by the end of 2021. 

16

Complete your analysis by added   formulas in the range F7:G7 to calculate the high and low thresholds of the   forecast.

Google Analytics Report Of Google Merchandise Store (Demo Account) 2020

 It was a task to create a Google Analytics Report of Google Merchandise report for a demo account in 2020 

Write one page at “IOT”

what you’ve learned in the course and how you will apply it to your work life.  Also, note anything else of importance regarding the course overall.

Summary:To apply all acquired knowledge in the last Project Assignments to create a Database Scheme. For this project, the ERD is provided to you.Deliverables:

• SQL Script with your name as follows: YourLastName_Project_Ph3.sql.
• MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc.
• ZIP file to include the two files mentioned above.

Required Software:

• MySQL DBMS by Oracle. MySQL Community Server and MySQL Workbench.
• Follow Step 1-3 for your Course Project Phase phase 1, to install the required software components.

Lab Steps:Step 1: Analyze the ERD for a student information system provided below. Be alert for the specifications provided for: 1) Entities, 2) Attributes, 3) Primary Key, and 4) Relationships.  You will need to have a clear understanding for these components to create your database using MySQL. Step 2: Create a New Database in MySQL, Produce SQL File, Drop Table

• Create a new Database, as you did in your Course Project Phase 1 deliverable and you already created a database using the MySQL DBMS.  Reference the attached video (Course Project Ph1 Video.mp4), for a demonstration to create a new Database using MySQL. This video was initially presented to you for phase 2 of your project.  Also, reference the supplemental text: Available for Free download as part of our UC Library.  MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill. ISBN: 978-0-07-160550-2.  Link to UC Library: http://search.ebscohost.com/login.aspx?direct=true&AuthType=shib&db=nlebk&AN=291311&site=eds-live&ebv=EB&ppid=pp_ii
• Utilize the SQL dialect you learned so far in this course for MySQL.  Use the file supplemental textbook:  MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill, as supplement your knowledge of the MySQL dialect. 
• Create your SCRIPT file to be named: YourLastName_Project_Ph3.sql.

Step 3: Include the following commands at the tops of your scripts:

• SET FOREIGN_KEY_CHECKS=0;
• DROP TABLE IF EXISTS STUDENT;
• DROP TABLE IF EXISTS CAMPUS;
• DROP TABLE IF EXISTS ROOM;
• DROP TABLE IF EXISTS COURSE;
• DROP TABLE IF EXISTS INSTRUCTOR;
• DROP TABLE IF EXISTS APPROVED_INSTRUCTOR;
• DROP TABLE IF EXISTS CLASS;
• DROP TABLE IF EXISTS STUDENT_GRADE;
• SET FOREIGN_KEY_CHECKS=1;

Step 4: Create Tables in your database

• Create a new Table for each of the entities provided to you in the ERD diagram in Step 1.
• Add a column to represent each attribute addressed in the ERD diagram in Step 1.
• Designate Primary Key, as noted in the ERD diagram in Step 1.
• Designate a Foreign Key relationship between the tables, as noted in the ERD diagram in Step 1.
• Enable referential integrity on the relationships, as needed.
• Enable cascade updates as needed on the relationships.

Step 5: Designate Data Types. Update the data type as needed to enforce the domain constrain of the data. This needs to be completed for every column for all tables.

• Dates: they should have a date data designation type.
• Surrogate keys: shall be auto-numbered
• Character type: shall have a character data designation type.

Step 6: Column Constraints Designation.

• Grade designation must be of one of these values as follows: A, B, C, D, E, F, W, E (E=enrolled, and W = withdrawn).
• Student’s first and last names are not to be designated as NULL.
• Course Credit hours shall be BETWEEN one and four.
• The instructor first and last name must NOT be NULL
• Course name designation has to be UNIQUE and must not be NULL type.

Step 7: Data Table Addition

• Use the INSERT operator to add minimum 2-3 rows of data per each database.
• You are free to use any values you might like for each of the columns.
• NOTE/ Reminder: you are required to add data to the parent table prior to adding any data to child tables, as referential integrity is enabled.

Step 8: Executing your SCRIPT

• Must incorporate the COMMIT command at the end of your Script
• Must incorporate the SHOW TABLES command, to display the table you created. At the end of the script created.
• Must incorporate the SELECT statement to show data allocated for each table. This would be added at the end of the script.
• EXECUTE your SCRIPT.
• Copy and paste your OUTPUT into your MS Word file as follows: YourLastName_Project_Ph3_Output.doc

Step 9: Upload your work

• Upload ZIP file to include the two files as follows: 1) SQL Script with your name as follows: YourLastName_Project_Ph3.sql, and 2) MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc.

Rubric:

• Tables Created: create a table for each entity as noted in the ERD diagram in Step 1. 5 points
• Columns Created: create a column for each attribute as noted the ERD diagram in Step 1. 5 points
• Primary Key designation: primary key addressed for all tables with unique constraints specified as column properties. 5 points
• Data Types: Addressed for each attribute. Should include: 1) Date data type incorporated, 2) Surrogate Key Automated, 3) Numeric data shall be numeric type, 4) Character data shall have a character type. 5 points
• Relationships Created, as noted in the ERD diagram in STEP 1. Relationships shall be enabled for referential integrity and cascade updates. 10 points.
• Data Added per row: 5 rows of data for each table. 10 points
• Column Constraints Added: As noted in the description for the project. Checked by adding rows with invalid values. Should take into consideration constraints as follows: 1) student name cannot be NULL, 2) course credit hours are restricted to allocations between 1-4, 3) course name is unique and NOT NULL, 4) instructor last name and first name can NOT be NULL, and 5) grade restrictions to the following values: A,B,C,D,F,I,W, E. 10 points

In this work, you are going to use the program openssl to encrypt, decrypt, and hash some values. We are going to use real algorithms that are used in modern communications.

At a command prompt, type “openssl ciphers” to see the ciphers that are available with this installation of openssl.

First, we will attempt to encrypt and then decrypt a string. After the first command, you’ll need to enter a password that will derive your encryption key.

• echo “CIS3100” | openssl enc -aes-256-cbc -a 
• echo | openssl enc -aes-256-cbc -a -d 

You should have returned “CIS3100” (our original plaintext) at this point. To break down further what’s happening, the echo command is used to provide text input to openssl. Then, we call the program openssl; “enc” says we are using the encryption/decryption module; “-a” is encoding the data in base64; and “-d” is specifying that this will be a decryption operation.  

Now, let’s try hashing a password: 

• openssl passwd -salt “salt” “password” 

In this example, the returned result will be your hash of a password. The hash will be the same for each time you run this with the same parameters. However, it is not easily reversible. To break down further what’s happening, “-salt” is specifying a value to be a salt, an additional piece of data to add complexity to your hash and make it harder for someone to brute force your list of hashes; “password” (in this case) is your secret password value.  

Now, for your submission, you’ll be encrypting, decrypting, or hashing the following values and submitting those based on the parameters given. Remember that capitalization matters, and be careful to remove any line breaks in the output when you copy and paste.  

1. Encrypt “CIS3100” using the password “password” and the algorithm “aes-128-cbc”.
2. Decrypt “U2FsdGVkX18O3AUltiVEAyBDcfesmyojn8pU6zXWUu8x4LHsrV3Q+BWRR2wjC3Xl” using the password “password” and the algorithm “aes-128-cbc”.
3. Hash the password “MySecret” using the salt “pepper”.
4. Decrypt “U2FsdGVkX18idu4Cp/KbOanB726etAlbcmI/yeihAoh01Md5EOkb8Ld/
   Dk88CDManZKZ4FH8ruo7THx5boOOXz9LkMiqh47Dc2kA8omOcGwjJo
   tuHyq54rlq17bV9srO025vbZ+jRRHrwbd+iNQaMQ==” using the
   password “password1” and algorithm “aes-256-cbc” and then decrypt
   that result using the password “password2” and algorithm “aes-256-cbc”.

Parameters

• The work should be double-spaced, 12-point Times New Roman font, with one-inch margins
• Use APA for citing references and quotations 

i need help in programming task…Any one who can help please contact me 

regarding cs

Please read Assignment.docx

attached are all the files in a zip and a makefile 

Files to Submit:

• Armour.java     -your version of the Armour ADT.
• Consumable.java  – your version of the Consumable ADT.

Exp19_Excel_Ch08_HOEAssessment_Robert’s_Flooring 

Exp19 Excel Ch08 HOEAssessment Robert’s Flooring

 Excel Chapter 8 Hands-On Exercise Assessment – Robert’s Flooring 

Project Description:

You are a business analyst for Robert’s flooring, a local home renovation shop that specializes in hardwood floors. You have been given an Excel workbook that contains the last 10 flooring installations completed. You would like to explore this information using the Analysis ToolPak. You would also like to visualize the data by adding a trendline to a scatter plot. Lastly you would like to use the FORECAST.LINEAR function to create a fair market price quote for a 1500 sqft flooring installation 

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

You would like to use   the Data Analysis ToolPak to create a histogram to visualize the data. To   complete this task, first ensure the Data Analysis ToolPak is active. Next,   use the histogram feature in the Data Analysis ToolPak to place a histogram   in the worksheet. Use the range C3:C13 as the Input Range. Use the range   F3:F10 as the Bin range. Place the output in cell F13. Be sure to check   Labels, Cumulative Percentage, and Chart Output. Position the Chart Output so   that the upper left corner starts just inside the borders of cell F23.

You would like to add   a linear trendline to a scatter plot to help better forecast pricing based on   square footage of the installation space. You will position the chart to   start in cell K3, place the sqft data in the X axis, the Cost data in the Y   axis, and add a trendline with equation and R-square. Be sure to add a   descriptive chart title (Price Forecast).

You would like to use   the FORECAST.LINEAR function to calculate a cost estimate to install 1500   sqft of flooring. Be sure to use the cost data as the known_ys and the Sqft   data as the known_xs. Place the formula in cell I4.

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.

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