BMGT 311(Saturday): Assignment #1 Point Park Student Population

Students:

Welcome to the Fall Semester.  Marketing Research is an exciting subject and one that I am very passionate about.  In today’s marketing environment and job market, analytical skills are in the highest demand, as marketing shifts from being an “art” to a “science”

Marketing Research is a key component of this shift.  Understanding secondary data and consumer behavior helps marketers connect with their customers on a 1:1 level, and focuses their marketing dollars on activity that provides the biggest return on their investment.

A key skill is learning how to read data that is presented to you, use the data to develop visualization that impact decision makers, and finally allow you to have a point of view (POV) on the data that is presented to you.  Data comes in all shapes and forms, and is often hard to understand or develop a POV in its raw format.

So for assignment #1 – I would like you to take the following data below, and use excel to develop charts and visualizations that help answer the questions below.  Here is the raw data sets around the Fall 2013 Point Park Student population.

Screen Shot 2014-08-19 at 10.00.21 PM

 

Student Enrollment
3,841 for fall 2013.  Overall, enrollment has grown by nearly 19 percent within the past decade.

Student Demographics

Age
74 percent of our undergraduate students are traditional age (18-24-year-olds)
25 percent of our undergraduates are non-traditional (25 years old or older)
28 percent of our graduate students are traditional age (18-24-year-olds)
71 percent of our graduate students are non-traditional age (25 years old or older)

Race/ethnicity
Undergraduates:

72 percent of our undergraduates are White
16 percent of undergraduates are Black or African-American
3 percent are Hispanic of any race
4 percent are Two or more races
1 percent are Asian
3 percent are international

Graduate students:

73 percent of our graduate students are White
15 percent are Black or African-American
1 percent are Asian
2 percent are Hispanic of any race
2 percent are Two or more races
6 percent are international

Faculty/Staff

1,420

Here are the questions that I would like you to answer for next week.  I would prefer you upload your presentation to slideshare and leave a link to it in the comments below.  We can discuss in class on how to do this.  The charts can be developed in excel, and then copied to PowerPoint where they can be uploaded (PDF’s preferred).

Screen Shot 2014-08-19 at 10.02.52 PM

 

1. Can you show visually, the demographic breakdown of Point Park University undergrad and graduate students?

2. How does that breakdown compare with the population of the City of Pittsburgh?  (hint: use the census links on this web page)

3. Can you find another schools demographic profile online?  How does it compare with Point Park’s? (hint: use google)

4. What is the Student/Faculty ration at Point Park University using the information above?

5. Do the demographics of Point Park University reflect the demographics of the US as a whole?

I look forward to seeing your visualizations and presentations.

Chris Lovett

Advertisements

4 thoughts on “BMGT 311(Saturday): Assignment #1 Point Park Student Population”

    1. I do not think my answers were on that file so here they are:
      1.Yes
      2.The city of Pittsburgh has a much more diverse population.
      3.Yes, University of Pittsburgh has 78% white (greater than Point Park) undergraduates and only 6% African American undergraduate students.
      4.The demographics of Point Park are not a representation of the US as a whole because only 3,841 people are at Point Park while the US has about 313.9 million people living in it.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s