Author Archives: Adam

  • 0
groupsheet

How To Use GroupSheet

Written By: 

The following instruction will walk you through how to use GroupSheet. The first section of the instruction walks you though data population and group organization. The second section walks you through how to read the dashboard. If you have any questions, feel free to reach out via my Contact Page.

Populating Student Data

In this section, you’ll learn how to populate GroupSheet with your students’ data. Before beginning the data entry, you’ll need the following assessment results: MBTI & StrengthsFinders2.0. Additionally, if applicable, you’ll need to know program concentration. The more data you have, the better your student groupings will be.

Step 1: If you haven’t already, download GroupSheet and open in Excel

Step 2: You may see a message at the top of the spreadsheet that reads, “Security Warning Macros have been disabled.” If so, click the “Enable Content” button.

Enable Macros

Step 3: Enter Last Name, starting in cell B8

Step 4: Enter First Name, starting in cell C8

Step 5: Notice that cell D8 populates the full student name

GroupSheet Name Example

Step 6: If applicable, enter MBA concentration in cell G8

Step 7: Enter MBTI type in cell H8

Step 8: Enter Strengths 1-5 in cells J8:N8

Step 9: If you need to add more students than the table provides, unhide rows up to 200 and copy formulas down.

Unhide, GroupSheet

Create New Sheet For Grouping Activity

Creating a new tab for the grouping exercise allows future professors to see what groups students have been in before and avoid duplication.

Step 1: In cell G3, select which strength you’d like to utilize for grouping (recommended “Dominant”). If prior groupings exist from other professors, check which strengths were used and select a new one.

GroupSheet Strength Selector

Step 2: Click blue “Click Here” button in cell D6 and you’ll notice that a new tab has been created called, “Blank Data Table (2)”

GroupSheet Create Sheet

Step 3: Rename the tab whatever works well for you. For this instruction, I labeled the tab after Mary Henderson’s MBA 6100 class

Blank Data TableMBA 6100

Grouping Students

Step 1: In the newly created tab, sort column F (Combination) in ascending order

Step 2: In column E (Group), manually group students. For example, if you have 4 groups, please see the image below.

Grouping

Step 3: Sort column E (Group), sort ascending

Groups

Step 4: Groups are now created

Understanding The GroupSheet Summary Dashboard

If you’ve entered all of the data correctly in the “Blank Data Table” tab, your GroupSheet Summary Dashboard should be populated. The Dashboard is intended to help you understand the personality types and strengths composition of your class.

Step 1: Navigate to the “Summary Dashboard” tab

Step 2: The first chart you’ll see is “Strengths Categories 1-5”. This chart shows you class strength distribution based on the strengths data entered in the “Blank Data Table” tab. In the example below, you’ll notice that “Relationships” is the most dominant strength in “Strength 1”.

Step 3: To learn more about each strength, type in the strength name in cell H26, and the detail will display in the area below.

First Chart, GroupSheet

Step 4: The next chart covers your class’s overall “Dominant Strength” across all 5 strengths added in the “Blank Data Table” tab. In order for this chart to populate, you must set cell G3 in the “Blank Data Table” tab to “Dominant”.

Step 5: To learn more about each strength, type in the strength name in cell H26, and the detail will display in the area below.

Dominant Strength

Step 6: The next chart covers your class’s overall MBTI distribution as entered in the “Blank Data Table” tab. This chart will help you understand the variety of personality types in your class.

Step 7. To learn more about each personality type, visit: http://www.myersbriggs.org/my-mbti-personality-type/mbti-basics/ 

MBTI Distribution, GroupSheet

Step 8: The final chart covers your class’s MBTI Preference Dimension distribution. Here’s an easy to understand explanation of what preference dimensions are:

“These are; how we are energised, the type of information we prefer to pay attention to, how we make decisions and the type of lifestyle we prefer to lead. The Team Management Profile explores these as work-based preferences rather than ‘whole life’.” – Source

Step 9: To learn about specific dimensions, type in cell I118, the dimension you wish to learn about and the description will appear in the box below. For the purposes of this instruction, “Judging vs. Perceiving” is being used.

mbti-preference-dimensions

And that’s about it, folks. Again, please reach out if you have any questions.


  • 0
Candidates

Which 2016 Presidential Candidate Has The Most Authentic Twitter Followers?

Written By: 

In November of 2016, we will elect the next President of the United States. I tend to not write or post political musings, but I couldn’t resist this one. 

Read More

  • 0
FTC

A Letter To The FTC About Deceptive Search Results

Written By: 

Dear FTC,

As someone who deeply cares about the authenticity and reputability of search engine results, I’m writing this letter to you with great concern.

Read More

  • 0
WWE Cover

WWE’s Social Media Sentiment Problem

Introduction:

Since social media became a “thing”, I’ve been a fan of social business, the practice of using social data to make business decisions. This January, as part of my MBA coursework at Saint Catherine University, I enrolled in MBA 7120, Social Business.

Read More

  • 0
Search Engine Robot

Google Is Helping SEO Professionals Get The Respect We Deserve

Written By: 

Every time Google updates its ranking algorithm or language processing methodology, we hear the marketing echo chamber respond with, “SEO is changing again.” Or, “SEO is finally dead.” Or, the one I like the most, “SEO is no longer SEO, it’s sound marketing.” 

Read More

  • 0
Facebook Lead Ads

Are you using #Facebook Lead Ad Forms? You Better Be!

Written By: 

It’s common knowledge that when people are on Facebook, they prefer not clicking on third-party links that take them off network. If you’re running a lead generation campaign on Facebook, it probably looks a little something like this: 

Read More

  • 0
Facebook Page Header

The One Facebook Business Page Setting You’re Not Using, But Should Be

Written By: 

We all know that getting our Facebook business pages in front of our target audience(s) can be a difficult task. Additionally, over the past few years, Facebook has required many of us to pay to get the same reach that we used to achieve organically.

Read More

  • 0
Twitter Collections Header

Twitter Gets Social Selling Right With Its Product Collections

Written By: 

A few days ago, one of my rock star team members, Derick Hildebrandt, introduced me to Twitter Product Collections (Yes, I know I’m late to the game). If you haven’t caught wind of Twitter’s new ultra-cool social selling experience, allow me to share. 

Read More

  • 0
Robert-Herjavec

Three Things I Learned From Meeting Robert Herjavec

Written By: 

You know the question, “If you could have coffee with one person, dead or alive, who would it be?” Wednesday night, at the #SmallBusinessRevolution documentary premier, I had the pleasure of meeting someone whom is often my answer–Robert Herjavec.

Read More

  • 0
Facebook Ad Targeting Masthead

Supercharge Your Facebook Ads Targeting Through Google Analytics

Written By: 

Advertisers who use Facebook Ads as a medium to reach prospective customers know how important accurate demographic and psychographic targeting is. Without the appropriate targeting, advertisers will run through media budgets without much to show for it. 

Read More

The Current

Subscribe to our mailing list

* indicates required

Paid Search Certifications

Google AdWords Certified Professional
Bing Ads Accredited

Analytics Certifications

Google Analytics Individual Qualification

Find An Article

Search The Site

Twitter