New Perspectives Excel 2019 | Module 7: SAM Project 1a

Valerian State College

SUMMARIZING YOUR DATA WITH PIVOTTABLES

Author: Jacob Sheridan

Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM
website.
e from the SAM
Student ID Name Age Post-Secondary Years Base Rate Class
G62918 Kay Colbert 24 6 16.50 2022
P49234 Michael Crozier 25 7 16.50 2023
W99035 Brandon Miles 21 3 15.75 2022
V42056 Michael Alvarez 22 4 15.75 2023
T59828 Ida Smith 19 2 15.75 2024
F72412 Betty Garza 24 6 16.50 2025
W20999 Leroy Pirkle 28 10 17.50 2022
Q18870 Warren Stewart 18 0 15.00 2026
W75774 Stacy Wiggins 24 6 16.50 2025
N25220 Billy Herald 21 3 15.75 2022
O94361 Margaret Cruz 23 5 16.50 2023
G87578 Chester Keese 18 0 15.00 2024
B68170 Claudette Littell 19 1 15.25 2026
M89375 Florence Miller 21 3 15.75 2023
S63900 Kimberly Gerace 26 8 17.50 2023
Y96036 Roman Goble 22 4 15.75 2025
C82505 Jocelyn Allen 22 4 15.75 2022
Y75358 Ron Morse 20 2 15.75 2022
J60811 Roberta Ervin 21 3 15.75 2026
Q56783 James Rusnak 19 1 15.25 2022
Q75281 Suzanne Lawrence 24 2 15.75 2025
V73596 ShannonGarner 18 0 15.00 2024
L86947 Emory Little 25 5 16.50 2023
W90960 Laura Li 24 6 16.50 2022
P40886 Floretta Cauthen 18 0 15.00 2025
U88627 Beverly Berry 23 5 16.50 2023
Y88831 Stephanie Papa 19 1 15.25 2023
P83373 Wallace Rivera 29 9 17.50 2023
B53454 Larry Russell 19 1 15.25 2022
A60088 Aaron Sifford 25 7 16.50 2023
Finance Certified Grad Student Elected Qualified Driver Leadership Training Mentor
Yes Yes No Yes Yes Yes
Yes Yes Yes Yes Yes Yes
Yes No Yes No Yes Yes
Yes No No No Yes Yes
No No Yes No Yes No
Yes Yes No Yes Yes Yes
Yes Yes No Yes Yes Yes
No No No No No No
Yes Yes Yes Yes Yes Yes
No No No No Yes Yes
Yes No No No Yes Yes
No No No No No No
Yes No No No Yes No
Yes No No No Yes Yes
Yes Yes No Yes Yes Yes
Yes No No No Yes Yes
Yes No Yes No Yes Yes
Yes No No No Yes No
No No No No Yes Yes
Yes No Yes No Yes No
Yes No Yes Yes Yes No
No No No No No No
Yes Yes Yes Yes Yes Yes
Yes Yes Yes Yes Yes Yes
No No No No No No
Yes No No No Yes Yes
Yes No Yes No Yes No
Yes Yes No Yes Yes Yes
No No No No No No
Yes Yes Yes Yes Yes Yes
Officer Qualified Tier
Yes 2 Student ID G62918
Elected 2 Student Name Kay Colbert
Elected 1
Yes 2
Elected 1
Yes 2 Total Students
Yes 2 Elected Students 11
No 1 All Students 30
Elected 2
No 1
Yes 2
No 1 Postsecondary Years 0
Yes 1 Base Rate 15
Yes 1
Yes 2
Yes 2
Elected 2
Yes 1
No 1
Elected 1
Elected 1
No 1
Elected 2
Elected 2
No 1
Yes 2
Elected 1
Yes 2
No 1
Elected 2
Average Post-Secondary Years
4
3.8

1 2 5 8
15.25 15.75 16.5 17.5
Group Name Type Activities Office 2021 2022 2023
Computing Club Academic Field Public 54 81 93
Astronomy Society Academic Field Private 37 51 76
Humanities and English Club Academic Professional None 47 54 64
Environmental Management Club Academic Service Private 45 44 52
Communication Studies Club Academic Professional Public 30 32 51
Nursing Club Academic Service Private 44 47 41
History Club Academic Professional None 48 40 40
Psychology Association for Students Academic Professional Private 29 26 23
Investigative Forensics Club Academic Field Public 6 8 10
Accounting and Finance Forum Academic Professional None 5 6 5

Largest Academic Club, 2023:

Computing Club

2023 membership in large groups:

417
 Data
Activities Group Name Sum - 2021
Field 97
Astronomy Society 37
Computing Club 54
Investigative Forensics Club 6
Professional 159
Accounting and Finance Forum 5
Communication Studies Club 30
History Club 48
Humanities and English Club 47
Psychology Association for Students 29
Service 89
Environmental Management Club 45
Nursing Club 44
Total Result 345
Sum - 2022 Sum - 2023
140 179
51 76
81 93
8 10
158 183
6 5
32 51
40 40
54 64
26 23
91 93
44 52
47 41
389 455
Group Name Type Activities Office 2021 2022 2023
Accounting and Finance Forum Academic Professional None 5 6 5
Alpha Chi Omega Greek Fraternal Private 13 12 13
Alpha Phi Greek Fraternal Private 54 49 61
Alpha Phi Alpha Greek Fraternal Private 6 6 6
Arab Students Association Cultural Educational Private 4 3 4
Astronomy Society Academic Field Private 37 51 76
Badminton Club Recreational Field None 28 36 47
Black Students Association Cultural Educational Private 35 35 33
Broomstick Ball Recreational Field None 34 41 38
Camping and Excursion Club Recreational Field Public 14 17 14
Chi Omega Greek Fraternal Private 27 30 36
College Democrats Cultural Political Private 7 10 10
College Republicans Cultural Political Private 16 21 25
Communication Studies Club Academic Professional Public 30 32 51
Computing Club Academic Field Public 54 81 93
Delta Delta Delta Greek Fraternal Private 37 46 62
Democratic Socialists at Valerian Cultural Political None 53 74 61
Environmental Management Club Academic Service Private 45 44 52
Frisbee Golf Association Recreational Field None 19 21 19
Hillel Cultural Educational Public 28 24 27
History Club Academic Professional None 48 40 40
Humanities and English Club Academic Professional None 47 54 64
International Students at Valerian Cultural Educational Public 10 13 16
Investigative Forensics Club Academic Field Public 6 8 10
Kappa Delta Greek Fraternal Private 52 67 62
Latinx Students at Valerian Cultural Educational Private 26 25 27
LGBTQI* Students Association Cultural Educational Private 26 22 23
Libertarian Valerians Cultural Political None 39 52 73
Nursing Club Academic Service Private 44 47 41
Pi Beta Phi Greek Fraternal Private 26 33 46
Pickup Field Hockey Recreational Field Private 42 46 47
Psychology Association for Students Academic Professional Private 29 26 23
Recreational Rock Climbers Recreational Field None 37 49 42
Running Club Recreational Field None 46 44 38
Sailing Club Recreational Field Private 7 10 13
Sigma Nu Greek Fraternal Private 15 12 14
Sigma Sigma Sigma Greek Fraternal Private 51 54 64
Take A Hike Recreational Field None 33 46 37
Tau Kappa Epsilon Greek Fraternal Private 25 24 19
Ultramarathoners Fellowship Recreational Field None 38 46 55
Office Private

Data
Type Group Name Sum - 2021 Sum - 2022 Sum - 2023 This shape represents a
Academic 155 168 192 supported in Excel 201
Astronomy Society 37 51 76 If the shape was modifi
Environmental Mana 45 44 52 Excel, or if the workbo
Nursing Club 44 47 41 2003 or earlier, the slic
Psychology Associati 29 26 23
Cultural 114 116 122
Arab Students Associ 4 3 4
Black Students Assoc 35 35 33
College Democrats 7 10 10
College Republicans 16 21 25
Latinx Students at Va 26 25 27
LGBTQI* Students Ass 26 22 23
Greek 306 333 383
Alpha Chi Omega 13 12 13
Alpha Phi 54 49 61
Alpha Phi Alpha 6 6 6
Chi Omega 27 30 36
Delta Delta Delta 37 46 62
Kappa Delta 52 67 62
Pi Beta Phi 26 33 46
Sigma Nu 15 12 14
Sigma Sigma Sigma 51 54 64
Tau Kappa Epsilon 25 24 19
Recreational 49 56 60
Pickup Field Hockey 42 46 47
Sailing Club 7 10 13
Total Result 624 673 757
This shape represents a slicer. Slicers are
supported in Excel 2010 or later.

If the shape was modified in an earlier version of

Excel, or if the workbook was saved in Excel
2003 or earlier, the slicer cannot be used.
 Data
Type Activities Sum - 2021 Sum - 2022 Sum - 2023
Academic 97 140 179
Field 97 140 179
Cultural 129 122 130 400
Educational 129 122 130
Greek 306 333 383 350
Fraternal 306 333 383
300
Recreational 298 356 350
Field 298 356 350 250
Total Result 830 951 1042
200

150

100

50

0
Type Academic
 Membership by Type

Column B
Data
Column D

ype Academic Cultural Greek Recreational