Week 6 Class Discussion topic comes from —

Chapter Six “Targeting Attractive Market Segments”

Chapter Seven “Differentiation and Brand Positioning”

This class expects you to contribute two times:

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

When entrepreneurs and companies use tools to work on market segmentation and target marketing, they essentially seek answers to the following questions raised in Chapter Six:

• Why would market segmentation and target marketing make sense?
• Why not sell the same products or services to everyone?
• How can potentially attractive market segments be identified and defined?
• How can segments be prioritized so that the most attractive ones are pursued?

So is this class.

We will undertake a similar process through your contribution one — answer one question only out of six questions below —

Question #1 How to define market segmentations (what are three steps used in the market segmentation process)?

Question #2 What is the Five-Step Process technique used by marketers to choose attractive market segments?

Question #3 One of the three common targeting strategies is “niche-market strategy”.  Explain this strategy and provide at least two examples.

Question #4 One of the three common targeting strategies is “mass-market strategy”.  Explain this strategy and provide at least two examples.

Question #5 One of the three common targeting strategies is “growth-market strategy”.  Explain this strategy and provide at least examples.

Question #6 What is the relationship between market segmentation, target marketing, and product positioning? What damage will be done to a company’s target marketing and positioning efforts if markets are incorrectly or not effectively or insightfully segmented?

.

You do not need to answer all six (6) questions above:

Question 1 needs student X1 to answer it (Question 1 must be listed first)

Question 2 needs student X2 to answer it (Question 2 must be listed first)

Question 3 needs student X3 to answer it (Question 3 must be listed first)

Question 4 needs student X4 to answer it (Question 4 must be listed first)

Question 5 needs student X5 to answer it (Question 5 must be listed first)

Question 6 needs student X6 to answer it (Question 6 must be listed first)

You will earn maximum 2 points from your completed contribution one, if —

• your answer does not repeat to a same question that has already been answered by a classmate who did his/her work before you get here.
• if you do not totally agree with a classmate’s contribution one, or you think there are some aspects missed out by that classmate, you could explain why you disagree or why some other aspects should be included in your contribution two.  
• your answer is relevant to the question you selected to address.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Your contribution two — comment on one of your classmates’ posting about his/her contribution one.

You will earn maximum 2 points from your completed contribution two, if —

• your comment starts with a classmate’s name – making it clear that his/her contribution one that you would like to critique on or discuss with.
• your comment has minimum 100 words.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Please

→ study chapters 6 to 7 thoroughly before you write up your response either for contribution one or contribution two.

→ review chapter 6 to 7 PowerPoint slides thoroughly (you can find them in “Files” at Canvas).

→ Unicheck before posting your contribution one and contribution two.

• Identify job titles and responsibilities for various technology jobs

work should be citied

If you were asked by your employer to develop a new Information Security Policy, where would you turn to find resources to build this policy? List the two most important items you would include in this new policy and explain why you felt these were most important. (300 words + References please)

Q1. Excel is probably the most popular spreadsheet software for PCs. Why? What can we do with this package that makes it so attractive for modeling efforts?

Q2. What are the common business problems addressed by Big Data analytics?  In the era of Big Data, are we about to witness the end of data warehousing? Why?

Each response should be 300 words. There must be at least one APA formatted reference (and APA in-text citation) for each answer to support the thoughts in the post.  Do not use direct quotes.

Textbook: Business Intelligence and Analytics 

ISBN: 9780135192016

The purpose of this assignment is twofold: first, it is to ensure you’ve done the reading for the class ( Ch 1, 2, & 3 ). Second, it is to get you to take the time to actively think about the material and digest it instead of only being passively exposed to the ideas. A third, lesser emphasized goal, is to create a series of notes that may be helpful for you and your peers.

For this assignment, please:

Submit a summary of the three most important points from this week’s reading and lecture. Include a piece of code with at least one of the points that exemplifies the point.

here is the link to the book:  http://people.uncw.edu/tompkinsj/112/JavaScript/GettingStartedwithP5js.pdf 

Exp19_Excel_Ch07_HOEAssessment_Employees

Home>Computer Science homework help

Exp19_Excel_Ch07_HOEAssessment_Employees

Project Description:

You work for a clothing distributor that has locations in Iowa, Minnesota, and Wisconsin. You will use date and logical functions to complete the main employee data set, use database functions to calculate key summary statistics and create a map, and use financial functions to complete a loan amortization table.

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

The 1-Data worksheet contains   employee data. You will insert several functions to complete this worksheet.   Column C contains the actual hire dates for the employees. You want to   extract only the year in column G.
 

  In cell G9, insert the appropriate date function to extract the year from the   date in cell C9. Copy the function from cell G9 to the range G10:G33.

Next, you want to determine how   many years each employee has worked for the company.
 

  In cell H9, insert the YEARFRAC function to calculate the years between the   hire date and the last day of the year contained in cell G2. Use a mixed   reference to cell G2. Copy the function from cell H9 to the range H10:H33.

You want to determine what day   of the week each employee was hired.
 

  In cell I9, insert the WEEKDAY function to display the day of the week the   first employee was hired. Use 2 as the return_type. Copy the function from   cell I9 to the range I10:I33.

The value returned in cell I9 is   a whole number. You want to display the weekday equivalent.
 

  In cell J9, insert a VLOOKUP function to look up the value stored in cell I9,   compare it to the array in the range H2:I6, and return the day of the week.   Use mixed references to the table array. Copy the function from cell J9 to   the range J10:J33.

Column D contains the city each   employee works in. You want to display the state.
 

  In cell F9, insert the SWITCH function to switch the city stored in cell D9   with the respective state contained in the range C2:C4. Switch Des Moines for Iowa, St. Paul for Minnesota, and Milwaukee for Wisconsin. Use mixed   references to cells C2, C3, and C4. Copy the function from cell F9 to the   range F10:F33.

Your next task is to calculate   the bonus for the first employee. If the employee was hired before 1/1/2010,   the employee’s salary is multiplied by 3%. If the employee was hired before   1/1/2015, the employee’s salary is multiplied by 2%. If the employee was   hired before 1/1/2020, the employee’s salary is multiplied by 1%.
 

  In cell K9, insert the IFS function to create the three logical tests to   calculate the appropriate bonus. Use mixed references to cells within the   range K2:L4. Copy the function from cell K9 to the range K10:K33.

Top management decided to ensure   all representatives’ salaries are at least $62,000 (cell G2).
 

  In cell L9, nest an AND function within an IF function. If the job title is Representative   and the salary   is less than the minimum representative salary, calculate the difference   between the minimum representative salary and the actual salary. If not,   return zero. Use a mixed reference to cell G3. Copy the function from cell L9   to the range L10:L33.

The 2-Summary worksheet contains   data to insert conditional math and statistical functions to provide summary   data. First, you want to count the number of employees in each state.
 

  Click the 2-Summary worksheet. In cell J3, insert the COUNTIF function to   count the number of employees in Iowa, using the state abbreviation column   and the state abbreviation in cell I3. Use mixed references for the range and   cell to keep the row numbers the same. Copy the function from cell J3 to the   range J4:J5.

Next, you want to calculate the   total payroll for each state.
 

  In cell K3, insert the SUMIF function to total the salaries for employees who   work in Iowa, using the state abbreviation column and the state abbreviation   in cell I3. Use mixed references for the ranges and cell to keep the row   numbers the same. Copy the function from cell K3 to the range K4:K5.

Next, you want to calculate the   average salary for executives and the average salary for representatives.
 

  In cell J8, insert the AVERAGEIF function to calculate the average salary for   executives. Use mixed references to the range and for the cell containing   Executives. Copy the function to cell J9.

You want to identify the number   of representatives hired before 1/1/2015.
 

  In cell J12, insert the COUNTIFS function to count the number of   representatives who were hired before 1/1/2015. Use ranges for the criteria   ranges and the reference to cell H9 that contains Representatives. Enter the   date condition directly in the criteria box.

In cell J13, insert the SUMIFS   function to calculate the total salaries for representatives hired before   1/1/2015. Use ranges for the criteria ranges and the reference to cell H9   that contains Representatives. Enter the date condition directly in the   criteria box. Use mixed references to the ranges and cell reference so that   you can copy the function in the next step.

Copy the function from cell J13   to the range J14:J16. Edit the function in cell J14 to calculate averages.

Edit the function in cell J15 to   calculate the lowest salary.

Edit the function in cell J16 to   calculate the highest salary.

Insert a map to display total   salaries by states.
 

  Select the ranges I2:I5 and K2:K5 and insert a filled map. Change the chart   title to Payroll by State. Cut the chart and paste it in cell M1.

The 3-Finance worksheet contains   inputs for a loan.
 

  In cell F2, insert the PV function to calculate the loan. Use cell references   in the Input Area and Basic Output Area.

You are ready to insert formulas   and functions in the loan amortization table.
 

  In cell C7, enter a reference to the Payment that is stored in cell D2. Use   mixed reference so that the row number does not change. Copy the formula from   cell C7 to the range C8:C42.

The next column is designed to   display the interest portion of each payment.
 

  In cell D7, insert the IPMT function to calculate the interest for the first   payment. Use mixed references for cells in the Basic Output Area and make   sure the result is a positive value. Copy the function from cell D7 to the   range D8:D42.

Next, you are ready to calculate   the portion of the monthly payment that goes toward the principal.
 

  In cell E7, insert the PPMT function to calculate the principal portion of   the first payment. Use mixed references for cells in the Basic Output Area   and make sure the result is a positive value. Copy the function from cell E7   to the range E8:E42. 

Now you are ready to calculate   the balance of the loan after each payment.
 

  In cell F7, enter a formula to calculate the ending balance after subtracting   the Principal Repayment from the Beginning Balance. Copy the formula from   cell F7 to the range F8:F42.
 

  In cell B8, enter a formula that refers to the ending balance for the   previous month in cell F7. Copy the relative formula to the range B9:B42.

Now you want to calculate the   cumulative interest after each payment.
 

  In cell H7, insert the CUMIPMT function. Use mixed references for cells in   the Basic Output Area and the Start_period argument. Make sure the result is   a positive value. Copy the function from cell H7 to the range H8:H42. 

Finally, you want to calculate   the cumulative principal after each payment.
 

  In cell I7, insert the CUMPRINC function. Use mixed references for cells in   the Basic Output Area and the Start_period argument. Make sure the result is   a positive value. Copy the function from cell I7 to the range I8:I42.

Insert a footer on all three   sheets with your name on the left side, the sheet name code in the middle,   and the file name code on the right side.

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

Review Section 1.3 on effective versus ineffective security governance in Westby, J. R., and Allen, J. H. (2007), Governing for Enterprise Security (GES) Implementation Guide, which is located in your Module 3 readings (and available online from http://www.sei.cmu.edu/reports/07tn020.pdf (Links to an external site.)).   Compare and contrast the effectiveness criteria in Table 1 on pp. 8-9 of Westby and Allen (2007) with Table 25.3 on pp. 287-288 of Hopkin (2014).  Be sure to identify any effectiveness criteria from Westby and Allen (2007) that you believe should be added to the criteria outlined in Hopkin (2014). 

I need help with this spread sheet please 

Create a presentation (PowerPoint) on a specific application of binary search trees. That is, present a scenario where you would implement binary search trees. Make sure to give specific details about what the values being stored correspond to. Your presentation should be at least 10 minutes long.  

Executive Program Practical Connection Assignment – 100 points

At UC, it is a priority that students are provided with strong educational programs and courses that allow them to be servant-leaders in their disciplines and communities, linking research with practice and knowledge with ethical decision-making. This assignment is a written assignment where students will demonstrate how this course research has connected and put into practice within their own career.

Assignment: Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study.

Requirements:

Provide a 500 word (or 2 pages double spaced) minimum reflection.

Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited.

Share a personal connection that identifies specific knowledge and theories from this course.

As this is a personal reflection, no citation from any reference will be accepted (Turnit percentage will be reflected in your grade as no reference at all should be included

Include three main parts:

o In your own words, summarize the course content in the first third

o In your own words, summarize how is this relevant to your pass and current work/experience in the second third

o In the last third, summarize in your own words how will knowledge in this course, help you in enhancing your skills and profile.

Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment.

You should NOT, provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace. You cannot submit a previous assignment that was written for another class. This assignment will be checked by Safeassign for Plagiarism.