Expert Answers

Description Unit 2 - Individual Project Task Type: Individual Project Deliverable Length: One Python Program (100-200 lines) and a CSV that contains a generated column Points Possible: 100 Description: During your second Individual Project (IP), you will utilize your Python environment to derive structure from unstructured data. You will utilize the data set "Airline Sentiment" from Kaggle open data sets located at https://www.kaggle.com/welkin10/airline-sentiment. Using this data set, you will create a text analytics Python application that extracts themes from each comment using term frequency-inverse document frequency (TF-IDF) or simple word counts. For the deliverable, provide your Python file and a .csv with your results added as a column to the original data set. Please submit your assignment. For assistance with your assignment, please use your text, Web resources, and all course materials. Reference Akash. (2017). Airline sentiment. Retrieved from https://www.kaggle.com/welkin10/airline-sentiment Course Objectives: · Discuss the main functions of each component of the Hadoop framework Model Answer: Students should utilize Python to create a Python Application that processes each record to generate a list of key terms within the corpus. Then, this could be matched back to the comment to see if the key term exists in each comment.

Description I need help with the 9 errors. I have attempted to get it to work. I have attached a zipped file of what I have including a copy of the instructions.

Description – Java Programming, Data Structures, and Data Design ABOUT: CSC 220 is among CSC 340’s course prerequisites. CSC 210 and CSC 220 learn Java. Java is used in CSC 413 and other upper division courses. A good foundation in Java usually helps us pick up C++ faster. For these reasons, we were supposed to have a prerequisite exam to demonstrate our knowledge in Java programming. We are hired to implement an interactive dictionary. Our dictionary takes input from users and uses the input as search key to look up values associated with the key. Requirements: - Coding: No hard coding, https://en.wikipedia.org/wiki/Hard_coding . - Data Source: Store the original data in a set of enum objects. Each keyword, each part of speech, and each definition must be stored in a separate data field. Do not combine them such as storing three parts in one String. - Data Structure: Use existing data structure(s) or creating new data structure(s) to store our dictionary’s data. - Data Loading: When our program starts, it loads all the original data from the Data Source into our dictionary’s data structure. Data Loading must finish before our program starts interacting with users. - User Interface: A program interface allows users to input search keys. This interface then displays returned results. Our program searches the dictionary’s data (not the Data Source) for values associated with the search keys. - Identical Output: Our program’s output must be identical to the complete sample run’s output. The complete output is at: http://csc340.ducta.net/Assignments/Assignment-01-... . 1. Program Analysis to Program Design, 10 points. Please think Interviews. In 1 full page, please explain the following in detail: ? Your analysis of the provided information and the provided sample output. Please think Clients and think Sales. ? What problem you are solving. Please explain it clearly then define it concisely. Please think Problem Solving. ? How you store data in enum objects. And why. Please think Data Structures and think Data Design. ? Which data structure(s) you use/create for your dictionary. And why. Think Data Structures and think Data Design. 2. Program Implementation, 35 points. Please think Interviews. ? Does your program work properly? ? How will you improve your program? ? A short sample run is on the next page. Please remember to use the complete output.

Description Deliverables: You will inform LPG as to the database and software language chosen by IBN to create their new application, in written form. You must detail the reasons that this particular database and language were chosen, without being overly technical to the LPG Technology Committee that you will be interfacing with. A single Word document detailing these requirements is sufficient. You must develop the database for the first phase of the project, providing the data structure for Basic Patient Data and Profile, and the Wellness Checkup Profile. Tables should follow standard entity-relationship industry practices. Submit an entity-relationship diagram detailing data structure Provide a backup file of the database with your implemented data structure You must develop and deliver the operational front-end that allows for the entry of the data into the first phase screens, in the language that you choose. It must be operational and connect to the database that you created in Deliverable #2. Provide all code and files in zip archive, required to run the project You must provide the above documentation from Deliverable #1, with installation instructions for implementing your First Phase deliverables for items #2 and #3. Provide installation instructions to implement the system. This can be a single Word document

Description he purpose of this assignment is to filter and sort data, identify patterns and relationships within data, and use those findings to address business needs. For this assignment, you will use the "Adult Incomes" data set from the Topic Materials. Most data categories are self-explanatory. Clarifying notes are as follows. Sex: Gender Relationship: Relationship status Education: Highest level of education completed Hours _Per _Week: Number of weekly hours that the individual works Capital _Gain: Amount of capital gains from tax records Income: Income of the individual – either ">50K" or "<=50K" The marketing department in your organization believes that customers with more education have higher incomes than those with less education, and the department director wants to formulate an ad campaign targeting customers with a specific income level. While the assumption stands to reason, having data to support this hypothesis is necessary in order for the department to justify the new advertising campaign strategy. The department director has asked you to determine several specific numbers and percentages along with calculating to what degree educational level is correlated with income. Based upon your finding, the marketing department will determine whether or not its idea for marketing specifically to those customers is likely to create a positive return on investment. Question 1: Use Excel and various pivot tables and charts to calculate the following information. When summarizing categorical data, sometimes it is easier to create a new indicator (0/1) variable to obtain a percentage (the average of an indicator is a percent). Create a new indicator variable "Income_GT50" where the variable is equal to 1 when the income is greater than $50,000; otherwise use 0. Using this indicator variable, calculate the overall percent of individuals who earn more than $50,000 annually. Question 2: You are interested in understanding the demographics of a particular cohort in your data set: those who have at least a "Bachelors," "Masters," or "Doctorate" degree whose occupation is also "Exec-managerial." Filter the data to include only these individuals, and report the count of individuals who meet the criteria along with their average age and the percentage who earn more than $50,000 annually. Question 3: Many times age does not have a purely linear relationship with the dependent variable, so it is separated into age brackets. Create a new variable categorizing age into brackets as follows. Include the pivot table output when submitting the answer. "<25": If age less than 25 "25-34": If age between 25 and 34 inclusive "35-44": If age between 35 and 44 inclusive "45-54": If age between 45 and 54 inclusive "55-64": If age between 55 and 64 inclusive "65+": If age is 65 or more Question 4: Calculate the percentage of customers who earn more than $50,000 annually for each age bracket. Create a pivot chart showing the results and include the chart when submitting the answer. Is the effect of age on income a linear or quadratic relationship? Question 5: Using a pivot table, calculate the percent of customers earning more than $50,000 annually by education level? Include the pivot table and pivot chart outputs and refer to them as you address whether or not the marketing department's belief that customers with more education have higher incomes than those with less education. Present your findings in the form of a 250-word executive summary that includes relevant data, charts, and tables. General Requirements: Submit the answers to Questions 1-4 and the executive summary as Word documents. APA format is not required, but solid academic writing is expected. This assignment uses a grading rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

Description The popular social network Facebook TM was founded by Mark Zuckerberg and his classmates at Harvard University in 2004. At the time, he was a sophomore studying computer science. Design and implement an application that maintains the data for a simple social network. Each person in the network should have a profile that contains the person’s name, optional image, current status, and a list of friends. Your application should allow a user to join the network, leave the network, create a profile, modify the profile, search for other profiles, and add friends. Repeat Project above to create a simple social network. Use a graph to track the friend relationships among members of the network. Add a feature to enable people to see a list of their friends’ friends.

Description Team Management Part Three Until now, you have had to leave your team management program running on your computer indefinitely since you did not want to lose the list of players. Finally, you are ready to add the components to your team management program that will allow you to store the player’s information on your computer’s hard drive, thus, allow you to shut down your program without losing your data. You will need to modify your program to: include a Save option in the main menu which will prompt the program to write the player’s data to a text file. modify the startup code so that the program calls a function that reads the player’s data from the text file into the list of member objects. For this project: You will submit your python code in either the original .py file, or copied into a .txt file. A screenshot of your code having been executed (run). How to Take a Screenshot Tips: Think about how you are going to write the data to the text file when you create the load function. Your write function needs to read in the data in the same pattern as the load function, otherwise the data will get jumbled. Sample output: C:\>python week6.py Welcome to the Team Manager ===========Main Menu=========== 1. Display Team Roster. 2. Add Member. 3. Remove Member. 4. Edit Member. 5. Save Data. 6. Load Data. 9. Exit Program. Selection> 2 Enter new member's name: Nathan Contact phone number: 505-908-0670 Jersey number: 21 ===========Main Menu=========== 1. Display Team Roster. 2. Add Member. 3. Remove Member. 4. Edit Member. 5. Save Data. 6. Load Data. 9. Exit Program. Selection> 2 Enter new member's name: Bobby Contact phone number: 541-241-0670 Jersey number: 44 ===========Main Menu=========== 1. Display Team Roster. 2. Add Member. 3. Remove Member. 4. Edit Member. 5. Save Data. 6. Load Data. 9. Exit Program. Selection> 5 Filename to save: members.txt Saving data... Data saved. ===========Main Menu=========== 1. Display Team Roster. 2. Add Member. 3. Remove Member. 4. Edit Member. 5. Save Data. 6. Load Data. 9. Exit Program. Selection> 9 Exiting Program... C:\>python week6.py Welcome to the Team Manager ===========Main Menu=========== 1. Display Team Roster. 2. Add Member. 3. Remove Member. 4. Edit Member. 5. Save Data. 6. Load Data. 9. Exit Program. Selection> 1 No current members in memory. ===========Main Menu=========== 1. Display Team Roster. 2. Add Member. 3. Remove Member. 4. Edit Member. 5. Save Data. 6. Load Data. 9. Exit Program. Selection> 6 Filename to load: members.txt Loading data... Data Loaded Successfully. ===========Main Menu=========== 1. Display Team Roster. 2. Add Member. 3. Remove Member. 4. Edit Member. 5. Save Data. 6. Load Data. 9. Exit Program. Selection> 1 Name: Bobby Phone: 541-241-0670 Jersey Number: 44 Name: Nathan Phone: 505-908-0670 Jersey Number: 21 ===========Main Menu=========== 1. Display Team Roster. 2. Add Member. 3. Remove Member. 4. Edit Member. 5. Save Data. 6. Load Data. 9. Exit Program. Selection>9 Exiting Program...

Description AssignmentDetails_7_5_2015.pdf Continue to build on the skills of providing Web page content and structure with HTML and Web page style and layout using CSS. Demonstrate the skill of creating a dynamic Web page that includes JavaScript client-side programming. Demonstrate the skill of creating a Web page that delivers audio and/or video content. Design and develop a Web site that includes at least two Web pages that meet the following requirements. The design of all Web pages in the site must include:  a header at the top of the page,  a horizontal navigation bar below the header,  required content below the navigation bar. One Web page must include dynamic content created by client-side programming using JavaScript.  JavaScript programming code can be either  embedded in the head element or  included in an external JavaScript file that is linked to the Web page. You may  write your own JavaScript code or  obtain the JavaScript code from a provider of free code. Ensure the JavaScript programming code is free of errors that cause it to fail to execute.  Ensure the JavaScript code is called to execute.  Ensure the JavaScript programming code is included in the Web site.  Validate the HTML in the Web page. One Web page must deliver audio and/or video content.  Deliver the content to older browsers  using the embed element  that falls back to Flash. Deliver the content to modern browsers  using the video and/or audio elements.  Ensure the content plays in all modern browsers. Ensure the media files are included in the Web site.  Validate the HTML in the Web page. Use at least one external CSS file to  provide style, presentation, and layout to the Web pages in the Web site.  Validate the CSS style rules. Zip (compress) the Visual Studio Web site folder into a .zip file format to submit. Please submit your assignment. Grading You will be graded on the design and functionality of the Web site. You will be graded on the ability to include the required Web pages and the required HTML elements in the Web site. You will be graded on the ability to provide dynamic content in a Web page with client-side scripting using JavaScript. You will be graded on the use of CSS to format and layout Web pages. Points will be deducted for a Web site that does not include the design requirements. Points will be deducted for missing required Web pages. Points will be deducted for any missing required elements and/or attributes. Points will be deducted for any JavaScript programming code that fails to execute because it is not correctly called to execute or because it contains syntax errors that prevent it from executing. Points will be deducted for any HTML or CSS validation errors including any missing accessibility requirements. Points will be deducted for any JavaScript and/or media files that are not submitted with the Web site. For assistance with your assignment, please use your text, Web resources, and all course materials. Grading Rubric   Project Criteria Exceeds: 90%–100% Very Good: 80%–89% Meets: 70%–79% Needs Improvement: Below 70% Content (75%) Response covers all topics indicated in the assignment and adds additional content. Response covers most topics indicated in the assignment. Response covers many of the topics indicated in the assignment. Response covers none to some of the topics indicated in the assignment. Effective Communication (10%) Demonstrates outstanding or exemplary application of written, visual, or oral skills. Demonstrates outstanding expression of topic, main idea, and purpose. Audience is addressed appropriately. Language clearly and effectively communicates ideas and content relevant to the assignment. Errors in grammar, spelling, and sentence structure are minimal. Organization is clear. Format is consistently appropriate to assignment. Presentation and delivery are confident and persuasive (where applicable). The writing was of collegiate level with no errors in spelling or grammar. Demonstrates very good written, visual, or oral skills. Demonstrates sound expression of topic, main idea, and purpose. Audience is usually addressed appropriately. Language does not interfere with the communication of ideas and content relevant to the assignment. Errors in grammar, spelling, and sentence structure are present, but do not distract from the message. Organization is apparent and mostly clear. Format is appropriate to assignment, but not entirely consistent. The writing was of collegiate level with two or less errors in spelling or grammar. Demonstrates acceptable written, visual, or oral skills. Demonstrates reasonable expression of topic, main idea, and purpose. Sometimes, audience is addressed appropriately. Language does not interfere with the communication of ideas and content relevant to the assignment. Errors in grammar, spelling, and sentence structure are present and may distract from the message. Organization is a bit unclear. Format is inconsistent. The writing was of collegiate level with several errors in spelling or grammar. Demonstrates inadequate or partially proficient application of written, visual, or oral skills. Demonstrates inadequate or partial expression of topic, main idea, and purpose. Audience is often not addressed appropriately. Language often impedes the communication of ideas and content relevant to the assignment. Errors in grammar, spelling, and sentence structure are frequent and often distract from meaning or presentation. Organization is inadequate, confusing, and distracting. The format is inadequate and obscures meaning. The writing was less than collegiate level with numerous errors in spelling or grammar. Supporting Analysis (15%) Analysis exceeds minimum requirements. Sources are used to support analysis, are appropriate, and are properly referenced. Basic analysis provided to support assertions. Sources are cited, appropriate, and properly referenced. Limited analysis provided to support assertions. Some sources are cited, appropriate, and properly referenced. No or inaccurate analysis, no sources are cited when needed, analysis and/or sources are not appropriate. When sources are used, they are not properly referenced.  

Description Assignment Instructions: Part 1) 55% Complete Review Question 17.5 on page 509 in the Connolly text; explain each constraint (40%) and provide an example of each constraint other than the one in the text (15%). The response should be in the order of 500+ words 17.5 Describe the purpose of integrity constraints and identify the main types of integrity constraints on a logical data model. Part 2) 20% HINT: Review the Normalization Process: Parts and Suppliers One-to-Many Example in the Terms and Concepts forum. Background We want to keep track of the price we charge for each type of part, the supplier for each type of part, and the amount we pay the supplier for each type of part (the cost). Each supplier can provide us with many different types of parts, but each part can be provided to us by only one supplier. This requires a one-to-many relationship. Functional analysis: Part ---- > Price, Cost, Supplier, Street, City, State, Zip, Telephone Supplier ---- > Street, City, State, Zip, Telephone Part ---- > Price, Cost, Supplier Table: Parts (Part, Price, Cost, Supplier, Street, City, State, Zip, Telephone) Compete the following: 1. Copy and paste the 2NF definition from the Connolly text (see page 422) 4% Second Normal Form (2NF) A relation that is in first normal form and every non-primary-key attribute is fully functionally dependent on the primary key. 2. Is the above table in 2NF? 6% 3. Using the table and field names in the above table explain your answer in plain English. 10% Your submission must be original, include supporting sentences using the terms, concepts, and theories with the page number or website from the required readings or other material. Your submission should paraphrase material you reference, restrict your use of direct quotes (copy and paste) to less than 15% of the submission (the required copy and paste content will not be considered part of the 15% guideline).

Description CSS styles can be inline, internal, or external, and can contain numerous forms such as class and ID styles. Explain which styles take precedence and how the precedence is established. Provide an example where multiple levels of styles would be used and why.  Describe at least three special features that can be added using Cascading Style Sheets. Explain why you picked these three and include an example of how each is beneficial.