OSD Assignment Spring 2024 - Winter 2024 (7041)

Unit:
Office Solutions Development

Assignment title:
Human Resources Office Systems
Spring 2024 – Winter 2024
Important notes
• Please refer to the Assignment Presentation Requirements for advice on how
to set out your assignment. These can be found on the NCC Education
website. Hover over ‘About Us’ on the main menu and then navigate to
‘Policies and Procedures’ then scroll to the ‘Student Support’ area.
• You must read the NCC Education document Academic Misconduct Policy
and ensure that you acknowledge all the sources that you use in your work.
These documents are available on the NCC Education website. Hover over
‘About Us’ on the main menu and then navigate to ‘Policies and Procedures’
then scroll to the ‘Student Support’ area.
• You must complete the Statement and Confirmation of Own Work. The form
is available on the NCC Education website. Hover over ‘About Us’ on the
main menu and then navigate to ‘Policies and Procedures’ then scroll to the
‘Student Support’ area.
• Please make a note of the recommended word count. You could lose marks
if you write 10% more or less than this.
• You must submit a paper copy and digital copy (on disk or similarly
acceptable medium). Media containing viruses, or media that cannot be run
directly, will result in a fail grade being awarded for this assessment.
• All electronic media will be checked for plagiarism.
Tasks
All your responses for Tasks 1 to 4 must be placed in a single well-formatted Microsoft
Word document which must include the use of the following:
• Styles
• An automatically generated table of contents
• Automatically generated index list
Task 1 – 25 Marks [1000 words]
Application software and business processes

Write a report of no more than 1000 words which contains the following:
• An outline of the key business processes and related information systems required to
manage an organisation of your choice. The business you select must have a
workforce of at least ONE HUNDRED (100) staff.
• A recommendation of application software including costs that could be used to support
each of the processes whilst providing an integrated organisation-wide approach.
Marks will also be awarded for structure, appropriate use of language and clarity of
arguments across the whole written submission.
End-user development
It has been proposed that a Microsoft Access database could be developed in-house for
the Human Resource Information System of the organisation of your choice to include staff
records: personal details; leave including holidays, sick leave, special concessionary
leave; staff rotas, timetables, or work assignments; annual appraisal records.
a) Produce a conceptual list of the different data tables you would create using Microsoft
Access to capture the data for the Human Resource Information system. Describe the
entity relationships between the different tables and the key fields. There is no need to
provide detailed field property descriptions at this stage.
[10 marks]
b) Explain some of the disadvantages of using Microsoft Access databases and how they
could be reduced. Explain the relative advantages and disadvantages of using a
spreadsheet package such as Microsoft Excel to develop the system instead of using
Microsoft Access.
[10 marks]
Page 2 of 4
Office Solutions Development © NCC Education Limited 2024
c) Make at least FIVE (5) recommendations as to how you would ensure the success of
this end-user development. Explain the support and measures required throughout the
different stages of the development life cycle.
[10 marks]
Advanced features and functions of Microsoft Word

a) Create a staff table using Microsoft Excel. Add a second sheet containing staff leave
data. Add TEN (10) test staff with a varying number of leave periods. When creating
the tables, include calculated fields where necessary and take care to ensure that the
data structure can be used to extract data for sending MailMerge letters to staff.
[10 marks]
b) Create a ONE (1) page MailMerge letter template that can be used to send annual
leave slips to staff showing all the leave they have taken during the year as
individualised items and showing total leave taken and the amount outstanding.
Produce a test plan with THREE (3) test cases for the MailMerge and use them to
document test results.
Provide instructions for automatically sending leave slips by email when requested by
individual staff members.
[15 marks]
Advanced features and functions of Microsoft Excel

a) Create a macro that opens a form for capturing staff details. The form must include a
button which when clicked will ask users to confirm whether they wish to add a new
staff member. When users confirm, the macro must insert the new staff details at the
top of the staff details table so that the most recent entries are at the top of the table.
Add data validation to fields that you deem appropriate including a check for the
presence of staff duplication.
[10 marks]
b) Briefly explain some of the basic design and usability principles you have considered
when designing the form.
Briefly explain the relative merits and demerits of using macros to make interactive
forms.
[10 marks]
Page 3 of 4
Guidance
Consult with your tutor if you are uncertain about any aspect of this assignment.
Submission requirements
You must submit an electronic word-processed report in Microsoft Word format plus a
MailMerge letter and spreadsheet.
Your report should answer Tasks 1 to 4 including all tables and diagrams and must allow
markers to see the use of advanced Microsoft Word features. The overall word count for
the written part of the assignment is 2500 words.
Candidate checklist
Please use the following checklist to ensure that your work is ready for submission.
Have you read the NCC Education document Academic Misconduct

Policy and ensured that you have acknowledged all the sources that ❑
you have used in your work?
Have you completed the Statement and Confirmation of Own Work
form and attached it to your assignment? You must do this. ❑
Have you ensured that your work has not gone over or under the
recommended word count by more than 10%? ❑
Have you ensured that your work does not contain viruses and can
be run directly? ❑
Page 4 of 4

OSD Assignment Spring 2024 - Winter 2024 (7041)

Uploaded by

Copyright:

Available Formats

OSD Assignment Spring 2024 - Winter 2024 (7041)

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

OSD Assignment Spring 2024 - Winter 2024 (7041)

Uploaded by

Copyright:

Available Formats

Unit:

Office Solutions Development

Task 1 – 25 Marks [1000 words]

Application software and business processes

Task 2 – 30 Marks [750 words]

Task 3 – 25 Marks [500 words]

Advanced features and functions of Microsoft Word

Task 4 – 20 Marks [250 words]

Advanced features and functions of Microsoft Excel

Have you read the NCC Education document Academic Misconduct

You might also like