PBEM CPT Data Catalog: Difference between revisions

From Portland NET Wiki
← Older edit
VisualWikitext
 
(6 intermediate revisions by the same user not shown)
Line 2: Line 2:
== WHAT do PBEM Volunteers Do? ==
== WHAT do PBEM Volunteers Do? ==


=== Number 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 11: Line 13:
'''Source:''' The records for this measurement go back to the first class in 1994, via hard copy attendance sheets (and later, MS Excel-based tracking sheets and scans of dated sign in sheets). The information is currently tracked and stored on [https://app.smartsheet.com/sheets/VW4vWF7WrGmgMfFh6fCcX346qm4GxhPVgCM8MQ21?view=grid PBEM CPT Activities/B.) Training TRACKER] and viewable as a filter.
'''Source:''' The records for this measurement go back to the first class in 1994, via hard copy attendance sheets (and later, MS Excel-based tracking sheets and scans of dated sign in sheets). The information is currently tracked and stored on [https://app.smartsheet.com/sheets/VW4vWF7WrGmgMfFh6fCcX346qm4GxhPVgCM8MQ21?view=grid PBEM CPT Activities/B.) Training TRACKER] and viewable as a filter.


'''Update Procedure:''' Every time a Basic NET class is completed, it should be inputted to [https://app.smartsheet.com/sheets/VW4vWF7WrGmgMfFh6fCcX346qm4GxhPVgCM8MQ21?view=grid PBEM CPT Activities/B.) Training TRACKER]. That should prompt datasheets and dashboards to update automatically.
'''Update procedure:''' Every time a Basic NET class is completed, it should be inputted to [https://app.smartsheet.com/sheets/VW4vWF7WrGmgMfFh6fCcX346qm4GxhPVgCM8MQ21?view=grid PBEM CPT Activities/B.) Training TRACKER]. That should prompt datasheets and dashboards to update automatically. The SmartSheet formula governing data retrieval on the datasheets is:
<pre>
=COUNTIFS({TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell))
</pre><hr>
 
=== Count of Basic NET Graduates per Class ===
'''Type:''' Output, Measurement
 
'''Dashboard Locations:''' TBA
 
'''Available date range:''' Q2 1994 - present
 
'''Description:''' This is a count of the number of volunteers who graduate from each Basic NET class; it does not include the volunteers in the class who did not graduate.
 
'''Source:''' The records for this measurement go back to the first class in 1994, via hard copy attendance sheets (and later, MS Excel-based tracking sheets and scans of dated sign in sheets). The information is currently tracked and stored on [https://app.smartsheet.com/sheets/VW4vWF7WrGmgMfFh6fCcX346qm4GxhPVgCM8MQ21?view=grid PBEM CPT Activities/B.) Training TRACKER] and viewable as a filter.
 
'''Update procedure:''' Every time a Basic NET class is completed, it should be inputted to [https://app.smartsheet.com/sheets/VW4vWF7WrGmgMfFh6fCcX346qm4GxhPVgCM8MQ21?view=grid PBEM CPT Activities/B.) Training TRACKER]. That should prompt datasheets and dashboards to update automatically. The SmartSheet formula governing data retrieval on the datasheets is:
<pre>
=SUMIFS({TRNTRCKRcompleted}, {TRNTRACKeventtype}, "Basic NET Training", {TRNTCKRquarter}, CONTAINS(Year@row, @cell))
</pre>
 
<hr>
 
=== Sum of Volunteer Hours Logged as Basic NET Training ===
'''Type:''' Output, Measurement


'''Dashboard Locations:''' TBA
'''Dashboard Locations:''' TBA
'''Available date range:''' Q1 2013 - present
'''Description:''' This is the sum of all hours logged by volunteers in Basic NET Training activities. In quarterly data pulls, Basic NET Training activities may be labeled as:
{| class="wikitable mw-collapsible mw-collapsed"
|+
|Refresher training
|-
|Mandatory reporter for child and elder abuse
|-
|Independent study (associated with Basic NET Training)
|-
|Unit 8
|-
|Unit 9
|}
'''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''. <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 ==
These are hours reports that come from MIP. The reports are taken quarterly and reflect when a volunteer ''reports'', not necessarily when the activity took place (which is why, for example, you might see BNT hours logged in a quarter where there was no Basic NET class).
These are hours reports that come from MIP. The reports are taken quarterly and reflect when a volunteer ''reports'', not necessarily when the activity took place (which is why, for example, you might see BNT hours logged in a quarter where there was no Basic NET class).
=== Basic NET Training ===
* Refresher training
* Mandatory Reporter for Child and Elder Abuse
* Independent Study
* Unit 9
* Unit 8


=== Advanced NET Training/Exercises ===
=== Advanced NET Training/Exercises ===
Retrieved from "https://volunteerpdx.net/index.php/PBEM_CPT_Data_Catalog"