Start Word. Download and open the file named go16_wd_ch02_grader_2g_hw.docx.02Add the file name field to the footer. On Page 1, click in the blank paragraph below the letterhead, and then press ENTER three times. Use the Date & Time command to insert the current date using the third format. Press ENTER four times, and then type the following:Ms. Mary Walker-Huelsman, DirectorFlorida Port Community College Career Center2745 Oakland AvenueSt. Petersburg, FL 3371383Press ENTER two times, and then type Dear Ms. Walker-Huelsman: and then press ENTER two times. Insert the text from the downloaded file go_w02_grader_h3_text.docx.74Press CTRL+HOME to move to the top of the document. By using either the Spelling & Grammar command on the Review tab or by right-clicking words that display blue or red wavy underlines, correct or ignore words flagged as spelling, grammar, or word usage errors. Ignore any suggestions to remove commas, if necessary.45Replace all instances of posting with listing.56On Page 1, in the paragraph that begins The job description, use the Thesaurus to replace the word specific with explicit. In the same paragraph, replace the word credentials with its synonym qualifications.67On Page 1, in the paragraph that begins I currently, move the first sentence to the end of the paragraph.58On Page 1, in the second blank line below the paragraph that begins The job description, insert a two-column, three-row table. Add the following text to the table you just inserted:Left column:EducationExperienceRequired CertificationsRight Column:Bachelor of Science, Business ManagementTwo years computer support experience at a major universityMCITP, MCDST119On Page 1, AutoFit the contents of the table. To the table on Page 1, apply the Table Grid Light table style (under Plain Tables, in the first row, first style). Center the table on Page 1 between the left and right margins.1110On Page 2, insert a row above the second row in the table. Add the following text to the row you just inserted:Left column:OBJECTIVE Right column:To obtain a Business Programmer Analyst position that will use my technical and communications skills and computer support experience.Apply bold to the text OBJECTVE. In the right column, add 12 pt Spacing After the paragraph you entered.1311On Page 2, select the entire table and AutoFit Contents. Remove all borders from the resume table, and then apply a custom single solid line 1 1/2 pt top border to only the first row.512On Page 2, merge the cells in the first row of the table. Center the contents of the merged cell, and apply Bold. In the first row, select William Franklin, change the Font Size to 20 pt, and then add 24 pt Spacing Before. In the email address at the bottom of the first row, change the Spacing After to 24 pt.1813On Page 2, in the cell to the right of RELEVANT EXPERIENCE, below the line that begins January 2014, apply bullets to the six lines that comprise job duties. Create a similar bulleted list for duties as a Computer Technician. Select the text in the cell to the right of CERTIFICATIONS. Format the text in the cell as a bulleted list with solid round bullets.614Click the File tab, and then click Show All Properties. As the Tags, cover letter, resume As the Subject, type your course name and section number. Be sure your name is indicated as the Author.115Save and close the document. Exit Word. Submit the document as directed.

The worldcup dataset in the faraway package contains player level data from the 2010 world cup. It containsthe variables Team: Country Position: a factor with levels Defender Forward Goalkeeper Midfielder Time: Time played in minutes Shots: Number of shots attempted Passes: Number of passes made Tackles: Number of tackles made Saves: Number of saves madeWe are interested in modeling the number of shots taken by each player. Because goalkeepers typically donot have any shots, we can filter them out and remove the Saves variable.data(worldcup,package = "faraway")library(dplyr)worldcup <- worldcup %>%filter(Position != "Goalkeeper") %>%dplyr::select(-"Saves")a. Because some players play more than others, and some teams may get eliminated earlier, the timeplayed for each player is therefore highly variable. Create new variables which represent the number oftackles and passes per 90 minute game.

you do NOT have to include the youtube video CITIZEN DATA SCIENCE Assignment for MAR 3613Use the database provided in canvas.Here are the list of requirements:A Tableau dashboard of at least 3 visualizations.The dashboard should be interactive: clicking on the filters and the visualizations themselves should change the data in the dashboard.The video should be at least 3 minutes.The video should include:a brief introduction (name, U#, please show your face),an explanation of the dataset and the assignment (less than a minute),and the rest should be an explanation of multiple insights found while navigating the dashboard.The link should be uploaded to the Tableau assignment in canvas.Please review the grading rubric to be sure you have met all required criteria.To qualify for the Citizen Data Certificate, you must take the Certificate quiz located at the bottom of this module.RubricTableau RubricTableau RubricCriteriaRatingsPtsThis criterion is linked to a Learning OutcomeAssignment submitted on timeMinus one point per day for late submissions5.0 ptsFull Marks0.0 ptsNo Marks5.0 ptsThis criterion is linked to a Learning OutcomeSubmission of unlisted YouTube URL and USF Email address via Canvas20.0 ptsFull Marks0.0 ptsNo Marks20.0 ptsThis criterion is linked to a Learning OutcomeVisualization 1Age by Gender (provide average age)10.0 ptsFull Marks0.0 ptsNo Marks10.0 ptsThis criterion is linked to a Learning OutcomeVisualization 2 - Map10.0 ptsFull Marks0.0 ptsNo Marks10.0 ptsThis criterion is linked to a Learning OutcomeVisualization 3Two other variables of your choice (i.e. age and marital status)10.0 ptsFull Marks0.0 ptsNo Marks10.0 ptsThis criterion is linked to a Learning OutcomeMake sure you label the "sheets" in your Tableau workbook with meaningful titles that explains your charts.5.0 ptsFull Marks0.0 ptsNo Marks5.0 ptsTotal Points: 60.0