Exp19_Excel_Ch04_CapAssessment_Rockville_Auto_Sales

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.

Discussion – Intro to Data Mining (1 Page)

Assignment – Intro to Data Mining (2-3 Pages)

Discussion – Cloud Computing ( 350 Words)

Assignment – Cloud Computing (4 Pages)

 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? 

 This week our focus is on data mining. In the article this week, we focus on deciding whether the results of two different data mining algorithms provides significantly different information.  Therefore, answer the following questions:

1. When using different data algorithms, why is it fundamentally important to understand why they are being used?
2. If there are significant differences in the data output, how can this happen and why is it important to note the differences?
3. Who should determine which algorithm is “right” and the one to keep?  Why?

Need 350 words with minimum 3 APA formatted references

Design and Create a Presentation about Business Programs

Part 1: Your school is expanding the courses offered in the School of Business, and the department chair has asked you to help promote the program. She informs you that the classes emphasize creative and critical-thinking skills by combining material from the modern business world, liberal arts and sciences, environmental design, and engineering. Graduates possess technical skills that prepare them for success in their careers. Internships at local businesses provide real-work experience. 

Use the concepts and techniques presented in this module to prepare a presentation with a minimum of four slides that showcase the School of Business program. Research business programs at local schools for additional information about specific classes, tuition costs, admission requirements, and graduation rates. Select a suitable theme, and include a title slide and bulleted lists. 

Review and revise your presentation as needed. 

Add your name to the first slide

Note: You need to make several decisions while creating the presentation in this assignment: 

• what theme to use
• where to place text
• how to format the text (font, font size, paragraph alignment, bulleted paragraphs, italics, bold, underline, color). 
• What was the rationale behind each of these decisions? 
• When you reviewed the slides, what further revisions did you make and why? 
• Where would you recommend showing this slide show?

When finished submit the presentation in PowerPoint format (not pdf) using the file name

5-PP-1-2-YourName.pptx

ASSIGNMENT 1 At less 3000 words

1. (a) What are functional and non-functional requirements? (10mks)

(b) Explain the steps involved in the prototyping (10mks)

(c) Enumerate the reasons for the failure of Waterfall Model. (5mks)

2. (a) Define Software Reliability (5mks)

(b) What is Modularity? (10mks)

(c) Explain why professional software is not just the programs that are developed for a

customer. (10mks)

3. (a) What is the most important difference between generic software product development and

custom software development? What might this mean in practice for users of generic

software products? (10mks)

(b) What are the four important attributes that all professional software should have? Suggest

four other attributes that may sometimes be significant. (8mks)

(c) Apart from the challenges of heterogeneity, business and social change, and trust and

security, identify other problems and challenges that software engineering is likely to face in

the 21st century (Hint: think about the environment). (7mks)

4. (a) Based on your own knowledge of some of the application types, explain, with examples,

why different application types require specialized software engineering techniques to

support their design and development. (15mks)

(b) Explain why there are fundamental ideas of software engineering that apply to all types of

software systems. (10mks)

LR and R code

After reviewing this week’s video choose one of the Major New Themes in Marketing outlined by Professor Kotler and discuss it in detail. 

In 300 words.  Provide a current day example and how this will withstand environmental impacts of the seven Major Wicked Problems Facing Humankind as presented by Professor Kotler. 

https://www.youtube.com/watch?v=lDrja9d0SU4&t=1700s 

The Father of Modern Marketing” and “The World’s Foremost Expert On The Strategic Practice Of Marketing” – PROF. PHILIP KOTLER –

1. Read the Case “Introducing Scrum at P2P – PART A & PART B” at the end of the chapter 16 and response to the following questions:

   Kendra Hua had worked for six years as a software engineer in the IT department at Point 2 Point (P2P), a large freight moving company. She liked her job and the people she worked with. While she did some maintenance work, she worked primarily on projects, usually full time. Her work covered a wide range of projects including system upgrades, inventory control, GPS tracking, billing, and customer databases. These projects were typically able to meet project requirements but were consistently late. Within the IT department it was common practice for a betting pool to emerge regarding completion dates. The rule of thumb was to take the original schedule and multiply it by 1.5 and start guessing from then on.
   (Rest of case not shown due to length.)
   PART A

   1. How well is Scrum working?
   2. What are the issues confronting the Big Foot project?
   3. Assume you are Kendra. What would you want to say at the retrospective? How would you say it?
   4. What improvements or changes need to be made?
   5. PART B
   6. How would you assess P2P’s effort at introducing Scrum
   7. What challenges does an organization face when adopting an Agile approach like Scrum?
   8. What could P2P have done to enhance success?

Text

Title: Project Management: The Managerial Process 

ISBN: 9781260238860 

Authors: Clifford F. Gray, Erik W. Larson 

Publisher: McGraw-Hill Education 

Publication Date: 2020-01-09

Assigned Readings:Chapter 17. Governance and Structure: Forms of Doing Business.Chapter 18. Governance and Regulation: Securities Law.Initial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.Also, provide a graduate-level response to each of the following questions:

1. Summarize the required elements for the various business entities described in Chapter 17, providing examples of each and specifically describing the similarities and differences in each.
2. What factors would be considered when a director of a company makes a large trade of the company’s stock? 

Text-

Title: Business 

ISBN: 9780357447642 

Authors: Marianne M. Jennings 

Publication Date: 2021-01-01 

Edition: 12th Edition