BSBADM506 - Assessment 3: Business Document Design and Development

This assignment is a comprehensive project focused on BSBADM506, which involves managing business document design and development. The student's work includes creating explanatory notes on using letter templates, which incorporates organizational guidelines, mail merge operations, and macro functionalities. A detailed session plan for training a staff member, Pat, is presented, outlining the topic, duration, and competency achieved. An evaluation report analyzes the skill gaps within the team and proposes an implementation plan, including training on creating and using templates, macros, mail merge, form fields, drop-down lists, and formulae. The plan details specific tasks, resources, responsible persons, and a timeframe for each training module, along with a budget for implementation. The goal is to upgrade the team's skills to the operator level, addressing identified deficiencies and promoting efficient document creation and management. The project also includes assessment documentation in agreed format and within the agreed timeframe for the unit BSBADM506.

BSBADM506
ASSESSMENT 3
Student Name: Student ID No:
Trainer/Assessor Name: Term and Year:
Course:
Unit Code and Name: BSBADM506 Manage business document design and development
BSBADM506

The member of staff to train was PAT
Explanatory notes on the use of the Letter Templates
The letter template has been prepared to follow the guidelines of the organization. As it is, you only
need to fill in the sections that are indicated by brackets. For the recipients, a mail merge operation is
required; the details of the recipients are held in an excel sheet, so only one copy of the letter is
developed, but while printing out, the mail merge will take care of copies of the letter for all the
selected recipients.
The template contains a macro that automatically places current date. You will only replace the
sections indicated and sign off the letter. The mail merge function will fill in details relating to;
 Customer details and address
 Order details
 Original delivery date
 Expected delivery date
While using the template, apply the style guide formatting guidelines on fonts, color, log and language.
The letter should always be formal written in an apologetic tone. The resulting document should be
given an appropriate name to make it easy to trace and find a document.
Session plan for a 10–20 minute session
Name: Pat
Training date: 27 06 2019
Topic Duration Competency
Introduction and
explanation of the
template’s compliance with
organizational goals
3 min Competent
Demonstration of mail
merge and macros
12 Competent
Practice and questions and
feedback
5min Competent
Evaluation and notes:
Training

Arrange with your assessor to demonstrate or role-play training.
Evaluation report
The overall goal of the organization is to upgrade the skills of every team member to a level of an
operator. From the initial assessment of the members, major skills gaps existed for all members;
requiring each to undergo training on almost all the categories outlined. Sam and Kim were
particularly affected since they had some skills where they had not even begun leaning. For that
reason, the organization’s ability to modify and produce quality documents is greatly hampered.
Work task
Team member and current
capability
You
(team
leader)
Pat Sam Kim Skill gap
Creating and using
templates in Word and
Excel. Sam and kim
Creating and using
macros in Word and
Excel. Pat and Sam
Creating and using
mail merge features in
Word.
Pat and Kim
Creating and using
form fields in Word.
Pat and Sam
Creating and using
drop down lists in
Excel.
Pat and Kim
Creating and using
formulae in Excel.
Pat and Kim
Untrained – Team member has no training.
Learner – Team member cannot perform task independently.
Practitioner – Team member can perform task independently with
supervision.

Operator – Team member can perform task independently.
Coach – Team member can train others to perform task.

Implementation/action plan
Action/task Resources/cost Responsible
person/role
Timeframe
Training Sam and Kim on
creating and using templates
in Word and Excel
Computer, Microsoft Office,
Cost $150
Team leader Quarter 1 of the year,
20hrs per person per quarter
Training Pat and Sam on
creating and using macros in
Word and Excel
Computer, Microsoft Office,
Cost $150
Team leader Quarter 1 of the year,
20hrs per person per quarter
Pat and Kim creating and
using mail merge features in
Word.
Computer, Microsoft Office,
Cost $150
Team leader Quarter 2 of the year,
20hrs per person per quarter
Pat and Sam on creating and
using form fields in Word
Computer, Microsoft Office,
Cost $150
Team leader Quarter 2 of the year,
20hrs per person per quarter
Training Pat and Kim on
creating and using drop down
lists in Excel
Computer, Microsoft Office,
Cost $150
Team leader Quarter 3 of the year,
20hrs per person per quarter
Training Pat and Kim on
creating and using formulae
in Excel
Computer, Microsoft Office,
Cost $150
Team leader Quarter 3 of the year,
20hrs per person per quarter

Action/task Resources/cost Responsible
person/role
Timeframe
Refresher On advance
concepts in a yearly seminar
on best practices and
emerging technologies
External Trainer to facilitate a
seminar on emerging
technologies $ 500
Team leader Quarter 4 of the year,
Courses Materials, premises, snacks.
$150
Administrator