South Carolina Prevention Quarterly Ashley Memorial United - - PowerPoint PPT Presentation

south carolina
SMART_READER_LITE
LIVE PREVIEW

South Carolina Prevention Quarterly Ashley Memorial United - - PowerPoint PPT Presentation

South Carolina Prevention Quarterly Ashley Memorial United Methodist Church Thursday, May 3, 2018 What I will cover Two sections of the Online reporting system First section - Reporting forms Second section Data retrieval


slide-1
SLIDE 1

South Carolina Prevention Quarterly

Ashley Memorial United Methodist Church Thursday, May 3, 2018

slide-2
SLIDE 2

What I will cover

  • Two sections of the Online

reporting system

  • First section - Reporting

forms

  • Second section – Data

retrieval

  • Simple data analysis
  • Other data sources
slide-3
SLIDE 3

Two Components for Online Reporting System

Form entry side Data retrieval side

slide-4
SLIDE 4

Form Entry

  • 1. Enter password AET2016*
  • 2. Select form
slide-5
SLIDE 5

Online Compliance Check Form Paper Compliance Check Form

slide-6
SLIDE 6

Data retrieval side

slide-7
SLIDE 7

Compliance check data

slide-8
SLIDE 8

Filter for “tobacco”

slide-9
SLIDE 9
slide-10
SLIDE 10

What data points are needed for buy rate (non compliance rate)?

# of Buys

Total # of attempts

Buy rate (expressed as percent %)

slide-11
SLIDE 11

Count of total no.

  • f

attempts

Count of Attempts

slide-12
SLIDE 12

# of Buys (Sale completed?-Yes)

slide-13
SLIDE 13

Move SALE COMPLETED column next to DATE

slide-14
SLIDE 14
  • 1. Highlight Columns 2. Select INSERT 3. Select PIVOT Table
slide-15
SLIDE 15
slide-16
SLIDE 16
slide-17
SLIDE 17
slide-18
SLIDE 18

5

132

.038 or 3.8%

slide-19
SLIDE 19
slide-20
SLIDE 20

prevention

slide-21
SLIDE 21

Click Here

slide-22
SLIDE 22
slide-23
SLIDE 23

What I covered

  • Two sections of the Online reporting

system

  • First section - Reporting forms
  • Second section – Data retrieval
  • Simple data analysis
  • Other data sources
slide-24
SLIDE 24

2018 Out of f Their Hands

19 counties, 700 Compliance Checks, 73 buys, 10.4% 4 counties, 15 public safety checkpoints, 54 tickets/cases 3 counties, 12 bar/fake ID checks, 8 violations 4 counties, 5 party dispersals, 54 tickets/cases

slide-25
SLIDE 25

AET Training sessions

  • http://scoutoftheirhands.org/aet-training-events--registration.html
  • AET 101: Introduction to Underage Drinking Enforcement Training; 6/6/2018;

Rock Hill, SC

  • UDETC - Creating Environmental Change for Communities on Alcohol;

6/20/2018; SC LEO Hall of Fame

  • UDETC - Training of Trainers; 6/21-22/2018; Irmo Police Department
  • Counties where we have not conducted AET Training: Calhoun, Hampton, &

Oconee

slide-26
SLIDE 26

Upcoming Coordinators’ Meetings

two calls 10 am & 1:30 PM

  • (515)-604-9300 Access Code: 377154#
  • https://join.freeconferencecall.com/mic

haelgeorge113

  • Tue. May 15 2018

in-person meeting 10 am @ SC Law Enforcement Officers Hall of Fame, 5400 Broad River Rd., Columbia, SC

  • Thu. July 26 2018
slide-27
SLIDE 27

Questions?