Sample 2: Accounting 12
Topic:
Payroll Accounting
Prescribed Learning Outcomes:
Financial Data
It is expected that students will:
- prepare basic payroll, remittances, and required payroll tax documents
Presentation
It is expected that students will:
- classify and record information into general, payroll, accounts receivable, and accounts payable ledgers using manual and computerized accounting procedures
- summarize information from ledgers into reports for analysis, both manually and electronically
- present payroll accounts, deductions, and income tax documents using manual and electronic methods
Overview
The teacher developed a unit to allow students to explore payroll accounting systems. Evaluation was based on:
- gathering of employment data
- preparation of payrolls
- written reports
Planning for Assessment and Evaluation
- The teacher asked each student to find a job advertisement from the classified section of a newspaper. If the salary information was not given, the student made appropriate inquiries to determine the amount and frequency of pay.
- Students determined and gathered the employment forms they would need once they were "hired." Then they completed the forms.
- Using information from the employment forms, each student then created a spreadsheet to handle the payroll for all students in the class. Students calculated gross and net pay for each person for one month, prepared payroll cheques, and prepared the remittance for Revenue Canada.
- Students prepared written reports for their supervisor. In the reports, they explained the aggregate gross pay, net pay, total cost to the employer, and the labour involved in preparing payroll with different schedules (e.g., biweekly, semimonthly, monthly, weekly).
Defining the Criteria
Gathering Employment Data
To what extent does the student:
- find an appropriate job advertisement, complete with information on salary and frequency of pay
- gather and complete employment forms
- provide the information for all members of the class
Preparing the Payroll
To what extent does the student:
- design a spreadsheet that accurately calculates the payroll for each of the employees by pay period
- deliver cheques on time and in the correct amount
- accurately calculate and prepare the remittance cheque for the Receiver General
Written Report
To what extent does the student:
- accurately use the data from the spreadsheet to draw conclusions
- explain conclusions clearly in written form
- make generalizations based on data and experience
Assessing and Evaluating Student Performance
Gathering Employment Data
Gathering employment data was a critical first step in the project; however, it was not the focus of the learning objectives. The teacher chose to assess students' achievements using a simple three-point scale.
Preparing the Payroll
Preparation of payroll involved two steps: designing the spreadsheet, and creating and delivering the cheques.
Designing the Spreadsheet
The teacher expected students to design their spreadsheets to calculate gross pay, net pay, and the monthly remittance to the Receiver General. In addition, employees needed to be grouped by pay period to facilitate preparation of payroll cheques. The teacher used a scale to evaluate the spreadsheet design.
Payroll Cheques
The teacher expected each student to distribute the payroll cheques to fellow students at the end of each payroll period. Students provided peer ratings using the following criteria:
- The cheque was received on time.
- The amount of the cheque was accurate.
- The payroll person could answer any questions regarding the cheque.
- Any previous errors or problems were not repeated.
Written Report
The teacher used a holistic marking scale for students' written reports.
Gathering Employment Data
| Rating | Criteria |
| Outstanding |
The student selected a job advertisement that was personally relevant, research all pertinent information, gathered a complete set of relevant employment forms, and determined what deductions would be made to his or her salary. |
| Competent |
The student selected a job advertisement and determined all relevant employment information. Some sample documents were obtained. |
| Unacceptable |
The student may have selected a job advertisement but did not obtain the relevant information or associated documents. |
Payroll Preparation: Designing the Spreadsheet
| Rating | Criteria |
| Outstanding |
The spreadsheet is designed to perform all calculations efficiently, based on formulae, and provides row and column totals. The design reflects the logic of the process so that anyone could enter data easily. Employees are grouped by pay period. Employee and employer deductions are calculated accurately. All data is accurate. |
| Competent |
The spreadsheet is designed to perform all calculations. The design reflects the logic of the process so that anyone could enter data easily. Employees are grouped by pay period. Employee and employer dedications are considered. Data may not all be accurate. |
| Acceptable |
The spreadsheet is designed to perform all calculations, although the logic used does not reflect all steps in the process. Employees are grouped by pay period. Employee and employer deductions have been considered. All data is entered; however, there may be errors. |
| Unacceptable |
The spreadsheet has been poorly designed, so calculations are awkward. The logic behind the design is not clear. It would be impossible for someone else to enter data. Employees may not have been grouped by pay period. Data has not been entered accurately. |
Written Report
| Rating | Criteria |
| Outstanding |
The report is clear and concise. All conclusions are supported by data from the spreadsheet. Issues are explored in a complex way in various areas (e.g., total cost to the employer, labour involved in preparing the payroll). |
| Acceptable |
The report is clear and concise. Generally, conclusions are supported by data from the spreadsheet. A simplistic perspective is taken when discussing issues (e.g., total cost to the employer, labour involved in preparing the payroll.) |
| Unacceptable |
The report is poorly written. Conclusions are rarely supported by data from the spreadsheet. Very simplistic explanations are provided for issues (e.g., total cost to the employer, labour involved in preparing the payroll). |
Previous Page
Next Page
© Copyright 1998 All Rights Reserved. Standards Department.
Maintained by: Business Education Coordinator
Revised: October 8, 1998
BC Ministry of Education Home Page