BE Icon

Sample 2: Accounting 12

Topic:

Payroll Accounting

Prescribed Learning Outcomes:

Financial Data

It is expected that students will:

Presentation

It is expected that students will:

Overview

The teacher developed a unit to allow students to explore payroll accounting systems. Evaluation was based on:

Planning for Assessment and Evaluation

Defining the Criteria

Gathering Employment Data

To what extent does the student:

Preparing the Payroll

To what extent does the student:

Written Report

To what extent does the student:

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:

Written Report

The teacher used a holistic marking scale for students' written reports.

Gathering Employment Data

RatingCriteria
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

RatingCriteria
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

RatingCriteria
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| Prev | TOC | Next |Next Page

© Copyright 1998 All Rights Reserved. Standards Department.
Maintained by: Business Education Coordinator

Revised: October 8, 1998

  BC Ministry of Education Home Page