The Massachusetts School to Career Connecting Activities Initiative

 


8c - Connecting Activities Qualifying Wages Report

The Qualifying Wages Report shows approximate total employer-paid wages for students in Connecting Acivities placements.  The report lists student and employer names, start and end dates, wage per hour, approximate hours per week and total earnings. It is based on employer-paid Connecting Activities placements with a start date in the fiscal year, from July 1st to June 30th.

This report must be submitted with the annual Connecting Activities proposal, which is due in the spring. It is a long report, so only one copy is required with your submission. The report is required because the state budget line item that authorizes Connecting Activities funding requires that the public money provided for Connecting Activities programs be matched at a 2-to-1 or more ratio by employer wages.

The report is run from the Reports/Admin menu, and should be printed and included with the region's RFP response each year.

Running the Qualifying Wages Report:

1. Before printing the report, use the "Placement List" or "Custom Editing" screens, available from the Reports/Admin menu, to check your data for accuracy. On the edit screens, you can sort by any field, and therefore missing or out-of-range data will usually show up at the beginning or end of the list. Accuracy checks should include:

  • Make sure that all the data in the wages field and the hours per week field are in a reasonable range without typos.
  • Make sure that start and end dates are filled in and are reasonable.
  • Make sure that the type of pay field (Employer Paid; Sponsored/Subsidized; Unpaid) is accurate.
  • Make sure that the Connecting Activities program is checked (x) for all placements that should be included in Connecting Activities reporting.

2. From the Reports menu, go to the Qualifying Wages report. Select the date range that covers the full year, from July 1 to June 30. The report is based on placements with a start date in the fiscal year. Then click the button to view the Qualifying Wages report.

3. After you run the report, be sure to compare the total with last year's total for the region to see if it is realistic. You can also divide the total qualifying wages by the number of students to see if the earnings per student seem realistic.

Data entry tips:

When entering data during the year, remember that hours and wages must be numbers. If hours vary, enter an approximate average. Don't enter a range like 10-15 because the computer will misinterpret that. Also be sure to fill in both the start date and end date field on the placement screen.

If a participant will continue in a placement beyond the end of the fiscal year, please enter a June 30th end date, and then create a new record to continue the placement (with a July 1 start date) into the next fiscal year.

For co-operative education placement or other jobs that take place every other week, enter average hours per week.  For example, if students work 30 hours on alternating weeks, enter 15 hours per week.

 

1 - INTRODUCTION TO THE DATABASE - VIDEO
1a - Key Points About the Database
1b - REGISTERING AND SIGNING IN - VIDEO
1c - Navigating the Database Screens
2 - USING THE PLACEMENT SCREEN - VIDEO
2a -Classifying Placements - Activity Name, Program Checkboxes, Job Title, etc.
2b. Classifying and Defining STEM Placements
2c - Placement and WBLP Screen - Sharing via Email/Username
2d - Participants with more than one work experience
2d - Worksites with multiple participants - Using the COPY WBLP button
2e - Placement Screen - Required and Optional Fields
2g - Work and Learning Program Elements (Preview of FY19 elements)
2h - Career Areas
2z - Deleting Placement Screen Records
3 - USING THE JOB DESCRIPTION AND SKILLS/TASKS SCREENS - VIDEO
4 - USING THE PERFORMANCE REVIEW SCREEN - VIDEO
5 - ACTIVITY SCREEN - VIDEO
6 - Reflection Screen
7 - Importing
8 - REPORTS MENU AND EMPLOYER SCREENS - POWERPOINT PRESENTATION
8a - About the Reports/Admin Menu
8b - Connecting Activities Quarterly Report
8c - Connecting Activities Qualifying Wages Report
8d - Custom Reports
8e - Employer Screens
9 - Sharing, Collaboration and Privacy
9a - UPDATING MY ACCOUNT SETTINGS - VIDEO
9b - Add | Invite New Usernames
9c - Using the "One-Step WBLP Review Screen" for Supervisors
9d: Instructions for students to create their WBLPs online
DATABASE FIELD LIST
What's New in the Database
Winter/Spring 2019 Webinar Series