PBEM CPT Data Catalog: Difference between revisions
From Portland NET Wiki
| (One intermediate revision by the same user not shown) | |||
| Line 4: | Line 4: | ||
=== Count of Basic NET Classes === | === Count of Basic NET Classes === | ||
'''Type:''' Output, Measurement | '''Type:''' Output, Measurement | ||
'''Dashboard Locations:''' TBA | |||
'''Available date range:''' Q2 1994 - present | '''Available date range:''' Q2 1994 - present | ||
| Line 14: | Line 16: | ||
<pre> | <pre> | ||
=COUNTIFS({TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell)) | =COUNTIFS({TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell)) | ||
</pre> | </pre><hr> | ||
<hr> | |||
=== Count of Basic NET Graduates per Class === | === Count of Basic NET Graduates per Class === | ||
'''Type:''' Output, Measurement | '''Type:''' Output, Measurement | ||
'''Dashboard Locations:''' TBA | |||
'''Available date range:''' Q2 1994 - present | '''Available date range:''' Q2 1994 - present | ||
| Line 32: | Line 33: | ||
=SUMIFS({TRNTRCKRcompleted}, {TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell)) | =SUMIFS({TRNTRCKRcompleted}, {TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell)) | ||
</pre> | </pre> | ||
<hr> | <hr> | ||
=== Sum of Volunteer Hours Logged as Basic NET Training === | === Sum of Volunteer Hours Logged as Basic NET Training === | ||
'''Type:''' Output, Measurement | '''Type:''' Output, Measurement | ||
'''Dashboard Locations:''' TBA | |||
'''Available date range:''' Q1 2013 - present | '''Available date range:''' Q1 2013 - present | ||
| Line 55: | Line 58: | ||
'''Source:''' Volunteers initially logged BNT hours when the Volgistics system was available starting in 2013, and continued when PBEM switched over to MyImpact. BNT hours are often underreported (particularly in earlier years) because new recruits are getting acclimated to using software they haven't used before. | '''Source:''' Volunteers initially logged BNT hours when the Volgistics system was available starting in 2013, and continued when PBEM switched over to MyImpact. BNT hours are often underreported (particularly in earlier years) because new recruits are getting acclimated to using software they haven't used before. | ||
'''Update procedure:''' Added to datasheets manually from quarterly data pulls out of MIP: ''Hours by Activity''. | '''Update procedure:''' Added to datasheets manually from quarterly data pulls out of MIP: ''Hours by Activity''. <hr>Inputs: Spent, broken out by grant/general fund + equity spend | ||
Active Teams | |||
Unidos breakout | |||
Advanced NET/Exercises | |||
# ADV TR events | |||
# ADV TR Seats | |||
# ADV TR hours | |||
Deployment Hours/Service Hours (breakout?) | |||
# Deployment events, breakout by cause | |||
Community Engagement | |||
# Speakers Bureau volunteers | |||
# Speakers Bureau requests/fulfillment | |||
# Engagement hours | |||
# Community events by District | |||
== WHO are the PBEM volunteers? == | |||
Race/Ethnicity | |||
* % ID as person of color | |||
* Further breakdown into ethnicity | |||
* Gender (male/female/gender expansive) | |||
* Avg volunteer age | |||
* Disabilities | |||
== Hours Categories == | == Hours Categories == | ||
