Installing and/or Upgrading to Performance At Work (PAW) 2.0 February 26, 2009 at 3:00pm ET

1. Installing and/or Upgrading to Performance At Work (PAW) 2.0 February 26, 2009 at 3:00pm ET

2. Attendee List Presentation Slide Area Presentation Slide Area Chat Room Status Options

3. Submitting Questions Arrow Button Text Box Chat Room • Enter questions into the Chat Room (located in lower left corner of the virtual classroom). • To submit a question or comment, type the question in the text box and click the arrow button. • Your name, the text “(Submitted Question)” and your question will appear in red on your screen, indicating successful submission. • Questions are directly transmitted to presenters – other participants will not see your questions.

4. Practice In the chat room, please type the name of your organization, your location, and how many people are attending with you today.

5. Webinar Resources: Recordings available within 2 business days after the event. All resources are posted under the…

6. Presenters Presenter: Justin Navarro, Technical Assistance and IT Support, OWI/BRG Moderator: Megan Baird, Program Officer, OWI/BRG

7. Polling Question #1 • Please share with us which type of grant you are affiliated with.

8. Polling Question #2 • Are you an existing PAW user or a new user?

9. Polling Question #3 • Have you previously used PAW as a tool in preparing your Quarterly Performance Report?

10. Background on PAW (5 minutes) Upgrade Session (30 minutes) General Overview for New Users Administrators (20 minutes) Core Users (30 minutes) Questions Agenda

11. Background on PAW Performance at Work Development Deployment of Version 1.0 New Development leading to 2.0 Limited Resources and the As Is Nature of PAW Recommendations for getting the most out of PAW Include your IT staff early PAW User Group

12. PAW Resources PAW Resources Include: PAW User Guides Administrator Guide Core User Guide PAW Database Files PAW 2.0 Upgrade files for existing PAW users Archived Webinar Training Installing and/or Upgrading to PAW 2.0 Client Import Files Other Important Notes Access PAW and additional materials atwww.doleta.gov/business/paw

13. Polling Question #4 Upgrading From PAW 1.0 to PAW 2.0

14. Upgrading from 1.0 to 2.0 Key Documents Go to www.doleta.gov/business/paw (case sensitive) Upgrade files consist of: Upgrade Installation Guide (PDF) Front End Database File (Access MDB file) Help File (Compiled HTML Help File)

15. Upgrading from 1.0 to 2.0 Preparation First, it is strongly recommended that you make a copy of your current database and ‘beta test’ the upgrade. Please note, if you have multiple locations all using a different database, you must upgrade ALL of them. Have an upgrade plan that you communicate with your users.

16. Upgrading from 1.0 to 2.0 Installation Download the necessary files Open the PAW_FE 2.0 file The same ‘re-linking tables’ process as when you first installed PAW will take place. There will be a short period while the upgrade occurs. “Re-register PAW” with a Grant Start Date

17. Upgrading from 1.0 to 2.0 New Features and Functionality Grant Start Date versus Program Start Date PAW 2.0 now has a method for calculating 9134 New Participant Counts so participants beginning in a quarter prior to the grant start quarter are counted in the grant start quarter. Race and Ethnicity 'Race’ and 'Ethnicity' are two separate headings. There is a new option: 'More Than One Race' Options under ‘Race’ are now mutually exclusive but one selection is required.

18. Upgrading from 1.0 to 2.0 New Features and Functionality Birth Date 1. Enter a Birth Date, or 2. Select one of the new options: 'Age at Participation less than 18', or 'Age at Participation 18 or older.‘ Capstones and Drop Outs You now have the option of checking 'Dropout' on the service selection form which will reset the End Date to today's date. Batch Import Function

19. Upgrading from 1.0 to 2.0 New Features and Functionality Help File This tool is available via the PAW menu bar; directly via the .chm file; and by pressing the F1 function key on the keyboard. The "Help tool" can also be used to get context-sensitive help for a particular form or report the user has open at that moment. Note: Some users may encounter a problem with accessing the .chm file. After download, right click on it and select ‘Properties,’ click the ‘Unblock’ button. Click the newly enabled ‘Apply’ button and then the ‘OK.’

20. Upgrading from 1.0 to 2.0 New Features and Functionality Help File

21. Upgrading from 1.0 to 2.0 Questions or Comments? PAW User Group: Email: businessrelations@dol.gov Subject line: PAW User Group Only one email is necessary per organization but provide contact information for everyone who is interested

22. PAW Overview For New Users: Administrators

23. Tour of PAW - Administrator Installing PAW Security and Relinking Registering PAW with Grantee Information Overriding Security Administrator and User Account Setup Batch Import Function Adding Services Exporting and Importing Field Offices Submitting Reports Backing Up and Restoring the Database

24. Installation – Security Warnings Access 2007

25. Installation – Security Warnings Access 2007

26. Installation – Relinking Access 2007

27. Installation – Relinking Access 2007

28. Installation – Relinking Access 2007

29. Overriding Security Warnings

30. Overriding Security Warnings Access 2007

31. Overriding Security Warnings Access 2007

32. Overriding Security Warnings Access 2003

33. Registering PAW Grantee Tip: The last two digits are created by each office, and do not correspond to the ETA issued grant number

34. Creating the First Account

35. Entering Users

36. Batch Client Import – New* Documents Needed: Client Import Specification Guide (PDF) Client Import Spec Template (Excel file) Process: Whether you use our template or some other process, data can only be imported into PAW from comma-delimited, text-qualified text files (.txt or .csv) with hard-returns between individual records. Example: "000000000","M","Frank","Alan","Smith",1,“01/14/1985”,2,"Y",2,3,3,12,4,"2345678909","3456789098","123 Elm Street","12345","Nicetown","VA","456 Grove Lane","23456","Goodville","TN"

37. Batch Client Import – New* Process: Once you have the text file, open PAW. From the Main Menu, select the Admin Menu and on the Admin Menu, you will select “Import Clients” Follow the steps indicated by PAW

38. Batch Client Import – New*

39. Batch Client Import – New*

40. Batch Client Import – New*

41. Batch Client Import – New*

42. Adding Services

43. Adding Services Grantee Tip: Only Training services may be added. Capacity Building activities are NOT included in PAW.

44. PAW Export/Import Logic MapReporting to DOL/ETA DOL/ETA Online Reporting System Grantee Tip: Any grantee office may be the “Main Office” for PAW REPORT Main Office IMPORT TRANSMIT SECURELY IMPORT IMPORT EXPORT EXPORT EXPORT GRANTEE OFFICES Sub Office A Sub Office B Sub Office C

45. PAW Export/Import Logic MapOPTIONAL: Sharing Aggregate Data STOP! Proceed with caution when performing this export STOP! This import will overwrite any modified data DOL/ETA Online Reporting System Main Office EXPORT TRANSMIT SECURELY IMPORT IMPORT IMPORT GRANTEE OFFICES Sub Office A Sub Office B Sub Office C

46. Submitting Reports to DOL Grantee Tip: If some participants do not provide a SSN, the “Common Measures” report should also be printed Grantee Tip: PAW output must be manually entered into ETA’s online reporting system 2 1 3

47. Submitting Reports to DOL 2

48. Submitting Reports to DOL 3

49. Backing Up and Restoring

50. Backing Up and Restoring