Documentation
New Perspectives Excel 2019 | Module 7: SAM Project 1a | |
Valerian State College | |
SUMMARIZING YOUR DATA WITH PIVOTTABLES | |
Author: | student name |
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. |
Student Representatives
Student ID | Name | Age | Post-Secondary Years | Base Rate | Class | Finance Certified | Grad Student | Elected | Qualified Driver | Leadership Training | Mentor | Officer Qualified | Column1 | |||||||
G62918 | Kay Colbert | 24 | 6 | 2022 | Yes | Yes | No | Student ID | G62918 | |||||||||||
P49234 | Michael Crozier | 25 | 7 | 2023 | Yes | Yes | Yes | Student Name | Kay Colbert | |||||||||||
W99035 | Brandon Miles | 21 | 3 | 2022 | Yes | No | Yes | |||||||||||||
V42056 | Michael Alvarez | 22 | 4 | 2023 | Yes | No | No | |||||||||||||
T59828 | Ida Smith | 19 | 2 | 2024 | No | No | Yes | |||||||||||||
F72412 | Betty Garza | 24 | 6 | 2025 | Yes | Yes | No | Total Students | Average Post-Secondary Years | |||||||||||
W20999 | Leroy Pirkle | 28 | 10 | 2022 | Yes | Yes | No | Elected Students | ||||||||||||
Q18870 | Warren Stewart | 18 | 0 | 2026 | No | No | No | All Students | 30 | |||||||||||
W75774 | Stacy Wiggins | 24 | 6 | 2025 | Yes | Yes | Yes | |||||||||||||
N25220 | Billy Herald | 21 | 3 | 2022 | No | No | No | |||||||||||||
O94361 | Margaret Cruz | 23 | 5 | 2023 | Yes | No | No | |||||||||||||
G87578 | Chester Keese | 18 | 0 | 2024 | No | No | No | Postsecondary Years | 0 | 1 | 2 | 5 | 8 | |||||||
B68170 | Claudette Littell | 19 | 1 | 2026 | Yes | No | No | Base Rate | 15 | 15.25 | 15.75 | 16.5 | 17.5 | |||||||
M89375 | Florence Miller | 21 | 3 | 2023 | Yes | No | No | |||||||||||||
S63900 | Kimberly Gerace | 26 | 8 | 2023 | Yes | Yes | No | |||||||||||||
Y96036 | Roman Goble | 22 | 4 | 2025 | Yes | No | No | |||||||||||||
C82505 | Jocelyn Allen | 22 | 4 | 2022 | Yes | No | Yes | |||||||||||||
Y75358 | Ron Morse | 20 | 2 | 2022 | Yes | No | No | |||||||||||||
J60811 | Roberta Ervin | 21 | 3 | 2026 | No | No | No | |||||||||||||
Q56783 | James Rusnak | 19 | 1 | 2022 | Yes | No | Yes | |||||||||||||
Q75281 | Suzanne Lawrence | 24 | 2 | 2025 | Yes | No | Yes | |||||||||||||
V73596 | Shannon Garner | 18 | 0 | 2024 | No | No | No | |||||||||||||
L86947 | Emory Little | 25 | 5 | 2023 | Yes | Yes | Yes | |||||||||||||
W90960 | Laura L i | 24 | 6 | 2022 | Yes | Yes | Yes | |||||||||||||
P40886 | Floretta Cauthen | 18 | 0 | 2025 | No | No | No | |||||||||||||
U88627 | Beverly Berry | 23 | 5 | 2023 | Yes | No | No | |||||||||||||
Y88831 | Stephanie Papa | 19 | 1 | 2023 | Yes | No | Yes | |||||||||||||
P83373 | Wallace Rivera | 29 | 9 | 2023 | Yes | Yes | No | |||||||||||||
B53454 | Larry Russell | 19 | 1 | 2022 | No | No | No | |||||||||||||
A60088 | Aaron Sifford | 25 | 7 | 2023 | Yes | Yes | Yes |
Academic Groups
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: | ||||||
2023 membership in large groups: |
Academic PivotTable
All Groups
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 | 42 |
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 |
All Groups PivotTable
Row Labels | 2021 Membership | 2022 Membership | 2023 Membership |
Academic | 345 | 389 | 421 |
Accounting and Finance Forum | 5 | 6 | 5 |
Astronomy Society | 37 | 51 | 42 |
Communication Studies Club | 30 | 32 | 51 |
Computing Club | 54 | 81 | 93 |
Environmental Management Club | 45 | 44 | 52 |
History Club | 48 | 40 | 40 |
Humanities and English Club | 47 | 54 | 64 |
Investigative Forensics Club | 6 | 8 | 10 |
Nursing Club | 44 | 47 | 41 |
Psychology Association for Students | 29 | 26 | 23 |
Cultural | 244 | 279 | 299 |
Arab Students Association | 4 | 3 | 4 |
Black Students Association | 35 | 35 | 33 |
College Democrats | 7 | 10 | 10 |
College Republicans | 16 | 21 | 25 |
Democratic Socialists at Valerian | 53 | 74 | 61 |
Hillel | 28 | 24 | 27 |
International Students at Valerian | 10 | 13 | 16 |
Latinx Students at Valerian | 26 | 25 | 27 |
LGBTQI* Students Association | 26 | 22 | 23 |
Libertarian Valerians | 39 | 52 | 73 |
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 | 298 | 356 | 350 |
Badminton Club | 28 | 36 | 47 |
Broomstick Ball | 34 | 41 | 38 |
Camping and Excursion Club | 14 | 17 | 14 |
Frisbee Golf Association | 19 | 21 | 19 |
Pickup Field Hockey | 42 | 46 | 47 |
Recreational Rock Climbers | 37 | 49 | 42 |
Running Club | 46 | 44 | 38 |
Sailing Club | 7 | 10 | 13 |
Take A Hike | 33 | 46 | 37 |
Ultramarathoners Fellowship | 38 | 46 | 55 |
Grand Total | 1193 | 1357 | 1453 |
Activities PivotTable
Row Labels | 2021 Membership | 2022 Membership | 2023 Membership |
Academic | 97 | 140 | 145 |
Field | 97 | 140 | 145 |
Cultural | 129 | 122 | 130 |
Educational | 129 | 122 | 130 |
Greek | 306 | 333 | 383 |
Fraternal | 306 | 333 | 383 |
Recreational | 298 | 356 | 350 |
Field | 298 | 356 | 350 |
Grand Total | 830 | 951 | 1008 |