GC SAVVY DATA & RATING TABLES  --  SIMPLE EXAMPLE

Following are simple examples of what a student’s
 data & ratings tables( with captions) might look like.

 

TABLE 1:  SUMMARY OF DATA COLLECTED

 

The following information was collected for five different types of lip balm products:  UV Protection, SPF, Price, Fragrance (or Odor), Ease of Use, and Texture.

 

 

TABLE 1  DATA COLLECTED FOR FIVE DIFFERENT LIPBALMS

PRODUCT NAME

UV Spectrum Protection

SPF

Price

Odor

Ease of use

Texture

UVA

UVB

"Le Lousy Lipbalm "

NO

NO

3

$1.50

stinky

Tube with cap

Liquid/drippy

"Luscious Lips"

NO

YES

6

$2.50

fruity

Jar of ointment

gel

"Lip Guard"

YES

YES

15

$2.49

chemical

smell

Roll-up stick

smooth

"Safe Smacker"

YES

YES

15

$3.00

no fragrance

Roll-up

stick

smooth

"Mighty Man Lipbalm"

NO

YES

10

$5.00

no

fragrance

Roll-up stick

waxy

 

 

Explanation of Criteria and Rating System:  

After collecting my data I decided what criteria (factors) were the most important to me, based on my preferences for this type of product.  I decided that Texture didn’t make much difference to me, so I dropped that factor and decided to focus on:  UV Protection (combination of spectrum info  & SPF), Price, Odor, and Ease of Use.  The next step was devising a way to rank these factors quantitatively for each lip balm.   To do this I devised the following rating scale to quantify my preferences and established a value of 1-4  for each factor: 4 = best,  1 = worst . 

When the ratings for factor are totaled, the product having the highest rating number will be the overall best.    My RATING SYSTEM is summarized below:

 

 


FACTOR

RATING SCALE CRITERIA FOR EACH FACTOR ( 1 = worst   4 = best)

1
 

2
 

3
 

4
 

UV protection

 

NO protection

UVB only + SPF > 5

both UVA & UVB (full spectrum) protection
+ SPF > 5

both UVA & UVB (full spectrum) protection
 + SPF > 10

Price

 


> $3.99


< $3.99  but > $2.99


<$2.99  but  > $1.99


< $1.99

Odor

 

stinky

chemical smell

fruity smell

No fragrance

Ease of use

 

--

Jar of ointment

Tube with cap

Roll-up stick

 

 

TABLE 2 - SUMMARY OF PRODUCT RATINGS

 

THE BOTTOM LINE:   For full spectrum UV protection, fragrance and ease of use, Safe Smaker is my top rated lip balm.  It may cost a little more, but the extra cost is worth it to get full spectrum UV protection.  If you don’t mind a chemical smell, Lip Guard also gives full spectrum protection and came in second.  Both products are recommended.

 

TABLE 2  LIPBALM RATING RESULTS     top rated product __

PRODUCT NAME

UV PROTECTION

PRICE

ODOR

EASE

Total
Score

"Le Lousy Lipbalm "

 

1

4

1

3

9

"Luscious Lips"

 

2

3

3

4

12

"Lip Guard"

 

4

3

2

4

13

"Safe Smacker"

 

4

2

4

4

14

"Mighty Man Lipbalm"

 

3

1

4

4

12