2007 Administration Higher – Paper 2 Finalised Marking Instructions
Scottish Qualifications Authority 2007 The information in this publication may be reproduced to support SQA qualifications only on a non-commercial basis. If it is to be used for any other purposes written permission must be obtained from the Assessment Materials Team, Dalkeith. Where the publication includes materials from sources other than SQA (secondary copyright), this material should only be reproduced for the purposes of examination or assessment. If it needs to be reproduced for any other purpose it is the centre's responsibility to obtain the necessary copyright clearance. SQA's Assessment Materials Team at Dalkeith may be able to direct you to the secondary sources. These Marking Instructions have been prepared by Examination Teams for use by SQA Appointed Markers when marking External Course Assessments. This publication must not be reproduced for commercial or trade purposes.
2007 Higher Administration – Paper 2 Solution and Marking guidelines
ANNOTATION Where you award a mark show it like this
1
At the top right hand corner of each printout put the total gained
6 6
On the candidate’s first page show the total for the paper within a square
40 60
Page 2
TASK 1A – CREATE AND DESIGN FORM EVIDENCE
MARK
Create form Logo Fields Order Font size Footer RHS Selected Print
1 1 1 1 1 1
TOTAL MARKS
6
COMMENTS Visible and legible No mark if additional fields UPJ − Information must be visible to award mark. Must be accurate. Accept page or form footer. If more than one/all records printed, no mark
Notes
Page 3
Page 4
TASK 1B − CREATE QUERY EVIDENCE
MARKS
Criteria Part-time (PT) Aerobics or Health & Fitness (AH) First aid (F) Disclosure (D) Print staff names only (P)
1 1 1 1 1
TOTAL MARKS
5
COMMENTS
With or without title – must be first and second name. Additional fields – no mark.
Notes: • • • • • • •
Surname followed by first name acceptable If names repeated, do not award mark for A and H Look to the report to evidence the search criteria If less than 4 marks awarded for search criteria please code the result If no query printout award marks appropriately on the report – max 4 If search included “Millrigg” do not award A/H mark If O’Donnell included then do not award A/H mark
Page 5
Task 1b Query TITLE FIRST NAME SURNAME Mr Kevin Daly Mrs Robyn Wilson Mr Ken Gibson Mrs Madeleine Joyce Mrs Sue McCann Ms Sharon Rai
See Appendix for lists of criteria searches
Page 6
TASK 1B − CREATE REPORT EVIDENCE
MARKS
COMMENTS Visible and legible anywhere Accurate, relevant and non repetitive Must be class name If code used, check for alpha order and award
Insert logo Appropriate heading Include Class Alpha order of Class
1 1 1 1
Alpha order of surname One field for full name
1 1
Must be consistent with other headings
Include telephone number Footer job reference Data/Layout (L)
1 1 1
Page or Report Footer Data truncated, no award
TOTAL MARKS
9
Notes: • • • • •
Accept both class name and class code If consequentially wrong – no further penalty If query wrong and report wrong but different, do not award (L) mark Accept printout on more than one page If additional fields included do not award data (L) mark
Page 7
DUNEDIN EDUCATION AND LEISURE SERVICES
PART-TIME STAFF WITH FULL DISCLOSURE CLASS NAME
STAFF NAME
TELEPHONE NO
Daly
Kevin
01382223366
McCann
Sue
01382237788
Bums and Tums
Rai
Sharon
01382453287
Over-50s Keep Fit
Joyce
Madeleine
01382767432
Step Aerobics
Gibson
Ken
01382878754
Yoga
Wilson
Robyn
01382073765
Body Pump
Dunedin/Council Meeting/May 2007
Page 8
TASK 1C - QUERY – CALCULATED FIELDS EVIDENCE
MARKS COMMMENTS
Appropriate field heading Calculation Class Name/Code Kirklee/Search criteria
1 2 1 1
TOTAL MARKS
5
Consistent with previous headings All or nothing Must be visible All records must be correct to award mark
Notes: • • • •
Field for Centre does not have to be visible If the candidate carries out the calculation in a spreadsheet award marks as above if all correct. First formulae (1) replication (1). If all records not used do not award for Class Name and Kirklee. Need to check all figures in the calculation. Class Max and Class Fee do not need to be visible.
Page 9
Task 1c Query – no sort
INCOME CALCULATION CENTRE NAME CLASS NAME CLASS MAX CLASS FEE INCOME Kirklee Leisure Centre Step Aerobics 15 £3.50 £52.50 Kirklee Leisure Centre Weights 10 £3.50 £35.00 Kirklee Leisure Centre Over-50s Keep Fit 15 £2.50 £37.50 Kirklee Leisure Centre Circuit 15 £4.00 £60.00 Kirklee Leisure Centre Body Zone 10 £5.00 £50.00 Kirklee Leisure Centre Yoga 15 £3.50 £52.50 Kirklee Leisure Centre Pilates 15 £3.50 £52.50 Kirklee Leisure Centre Dolphins Swimming 10 £5.00 £50.00 Kirklee Leisure Centre Sharks Swimming 10 £6.00 £60.00 Kirklee Leisure Centre Tadpoles Swimming 10 £4.00 £40.00 Kirklee Leisure Centre Bums and Tums 15 £3.50 £52.50
Sorted by Class Name: INCOME CALCULATION CENTRE NAME CLASS NAME CLASS MAX CLASS FEE INCOME Kirklee Leisure Centre Body Zone 10 £5.00 £50.00 Kirklee Leisure Centre Bums and Tums 15 £3.50 £52.50 Kirklee Leisure Centre Circuit 15 £4.00 £60.00 Kirklee Leisure Centre Dolphins Swimming 10 £5.00 £50.00 Kirklee Leisure Centre Over-50s Keep Fit 15 £2.50 £37.50 Kirklee Leisure Centre Pilates 15 £3.50 £52.50 Kirklee Leisure Centre Sharks Swimming 10 £6.00 £60.00 Kirklee Leisure Centre Step Aerobics 15 £3.50 £52.50 Kirklee Leisure Centre Tadpoles Swimming 10 £4.00 £40.00 Kirklee Leisure Centre Weights 10 £3.50 £35.00 Kirklee Leisure Centre Yoga 15 £3.50 £52.50
Page 10
TASK 2A – CALCULATION OF WAGES EVIDENCE
MARKS COMMENTS
Wages sheet Calculation of new hourly rate Replication/All other formulae correct
2 1
Calculation of weekly wage Replication
1 1
Printout in formulae view of: Glenburn only Sorted according to dept Sorted according to name On one page
1 1 1 1
TOTAL MARKS
9
Must refer to increase sheet within the columns given to gain both marks
Notes: • • •
If additional columns are used mark the formulae – max 1 mark If truncated formulae do not award formulae mark or replication mark If value view only max 3 marks (Glenburn only, sort on dept and sort on name)
Page 11
Centre
Dept
Job Level
First Name
Surname
Hours
Wage New Hourly Rate
Estimated Weekly Wage
Glenburn
Admin
Head Receptionist
Gemma
Cameron
40
7
=G5+(G5*INCREASE!$B$4)
=F5*H5
Glenburn
Admin
Assistant
Karen
Clark
20
5.5
=G6+(G6*INCREASE!$B$5)
=F6*H6
Glenburn
Admin
Assistant
Carla
de Marco
35
5.5
=G7+(G7*INCREASE!$B$5)
=F7*H7
Glenburn
Admin
Area Supervisor
Kate
Shaw
35
8.34
=G8+(G8*INCREASE!$B$3)
=F8*H8
Glenburn
Catering
Assistant
Frank
McCue
21
6.12
=G9+(G9*INCREASE!$B$5)
=F9*H9
Glenburn
Catering
Assistant
Lauren
Weldon
22
6.12
=G10+(G10*INCREASE!$B$5)
=F10*H10
Glenburn
Maintenance
Assistant
Lizzie
Doman
30
5.5
=G11+(G11*INCREASE!$B$5)
=F11*H11
Glenburn
Maintenance
Assistant
Nathan
Smith
36
5.5
=G12+(G12*INCREASE!$B$5)
=F12*H12
Glenburn
Maintenance
Assistant
Robyn
Wilson
20
5.5
=G13+(G13*INCREASE!$B$5)
=F13*H13
See Appendices for alternative formulae
Page 12
TASK 2B – BUDGET SUMMARY SHEET EVIDENCE
MARKS COMMENTS
Budget sheet Subtotal of weekly wages All other formulae correct
1 1
Be aware of consequentiality
Formulae to show over budgeted amount
2
Accept yes/no, under/over, or blank etc
Replication
1
Must have formulae in all 4 cells
TOTAL MARKS
5
Notes: •
No marks for showing values only
Page 13
Centre Glenburn Kirklee Millrigg The Hub
Budgeted Weekly Wages 2000 2500 1700 1900
Estimated Weekly Wages =SUM(WAGES!I5:I13) =SUM(WAGES!I14:I26) =SUM(WAGES!I27:I36) =SUM(WAGES!I37:I46)
Over Budget =IF(C4>B4,"Over Budget"," ") =IF(C5>B5,"Over Budget"," ") =IF(C6>B6,"Over Budget"," ") =IF(C7>B7,"Over Budget"," ")
Using Sum if Centre Glenburn Kirklee Millrigg The Hub
Budgeted Weekly Wages 2000 2500 1700 1900
Estimated Weekly Wages Over Budget =SUMIF(WAGES!A5:A46,"glenburn",WAGES!I5:I46) =IF(C4>B4,"yes","no") =SUMIF(WAGES!A6:A47,"kirklee",WAGES!I6:I47) =IF(C5>B5,"yes","no") =SUMIF(WAGES!A7:A48,"millrigg",WAGES!I7:I48) =IF(C6>B6,"yes","no") =SUMIF(WAGES!A8:A49,"the hub",WAGES!I8:I49) =IF(C7>B7,"yes","no")
Using subtotaled sheet reference
Centre Glenburn Kirklee Millrigg The Hub
Budgeted Weekly Wages 2000 2500 1700 1900
Estimated Weekly Wages =WAGES!I14 =WAGES!I28 =WAGES!I39 =WAGES!I50
Page 14
Over Budget =IF(C4>B4,"yes","no") =IF(C5>B5,"yes","no") =IF(C6>B6,"yes","no") =IF(C7>B7,"yes","no")
TASK 3 − MONTHLY REPORT EVIDENCE
MARKS COMMENTS
Front cover Logo Keying in Format/enhance
1 1 1
Must be above text
Page numbering – footer/header
1
Not on front page 1. Accept contents page numbered as page 1 or 2.
TOTAL MARKS
4
Notes: •
Accept: large size, centring, border, different font etc for enhancing
Page 15
DUNEDIN EDUCATION AND LEISURE SERVICES
DUNEDIN COUNCIL MEETING MAY 2007 – MONTHLY REPORT
Prepared by …..
Page 16
EVIDENCE
MARKS COMMENTS
Table of contents All headings Page of its own Double line spacing
2 1 1
TOTAL MARKS
4
Notes: • • • • • • •
Headings and page numbers must be accurate for both marks and aligned. If additional headings one mark only. If any headings missing, one mark each time. If styles different within the table of contents, deduct mark from headings mark. Accept with or without contents heading. No penalty for keying in. Do not need to have leader dots. If all headings are visible and accurate but no page numbers – max 1 mark. If page number comes first – no marks for headings. Of the 2 marks available for headings, deduct for each typo.
Page 17
CONTENTS
OVERVIEW ............................................................................................................................2 EXPECTED PAY INCREASES .............................................................................................2 BUDGET .................................................................................................................................2 ZONE CARDS ........................................................................................................................3 STAFFING VACANCY .........................................................................................................3
Prepared by …..
1
Page 18
EVIDENCE
MARKS COMMENTS
Inserts Insert estimated percentages Bulleted points
1 1
V and L and in correct place
Insert budget summary
1
Insert text
5
V and L and in correct place (with or without gridlines) 4 for keying in and L for correct place
Insert staff candidate names
1
Page breaks Font style consistency
1 1
Footer/Header – Prepared by Candidate’s Name
1
V and L and in correct place – names only. Be aware of consequentiality Appropriate pagination of text From contents page onwards, including inserts Must be on all pages
Presentation
1
Line spacing and imported data. UPJ
TOTAL MARKS
13
Notes: • • • •
Contents headings within the report may be a different font to allow for styles. Accept these headings being different as long as they are consistent. Ignore job reference in the report. Report headings should be consistent – if not do not award presentation mark. Bullet points − accept %ages aligned or not. Bullet points at the start only – no mark for bullets in the second column. Accept different styles of bullet points within the document.
Page 19
OVERVIEW The last month has continued the positive trend of the last 3 months. • • • • •
The number of people attending all 4 centres has increased by 20% Income from classes has increased substantially We intend to offer additional classes at all centres Catering sales and sales from vending machines have also increased 95% of classes are operating at full capacity
EXPECTED PAY INCREASES Trade unions representing support staff in our centres are expected to ask for pay rises for all grades of staff. These estimated percentage increases are • • •
Area Supervisor 3.0% Head Receptionist 2.5% Assistant 2.0%
BUDGET The Finance Department had previously set budgets for staff wages for each of the departments. The expected pay increases will take some departments beyond the budget set. This information is shown below.
Centre Glenburn Kirklee Millrigg The Hub
Budgeted Estimated Weekly Wages Weekly Wages £2,000.00 £1,647.09 £2,500.00 £2,660.38 £1,700.00 £1,807.09 £1,900.00 £1,821.47
Over Budget Over Budget Over Budget
The Finance Department will now need to review budgets in the light of the increased revenue and the expected pay increases.
ZONE CARDS The introduction of the Zone Card giving discounted access to all facilities and classes at the 4 centres has proved to be extremely popular. Junior Zone Cards have been the most popular of the 3 categories| and the extensive promotion carried out in our secondary schools has| obviously been a success. Coaching staff will visit primary schools in| June to encourage younger children to buy the Zone Card.| Prepared by …..
2 Page 20
STAFFING VACANCY Lucy McLean starts her maternity leave at the end of June. A temporary replacement coach will be required to cover for her. It has been decided to recruit internally. The following parttime staff have been identified as possible candidates. Madeleine Joyce Sharon Rai Robyn Wilson Kevin Daly Ken Gibson Sue McCann
Prepared by …..
3
Page 21
APPENDICES Task 1B Database Criteria If these people included then have not queried successfully on part-time STAFF ID TITLE FIRST NAME SURNAME EMPLOYMENT STATUS C13 Mr Stephen Mackie full-time C03 Mrs Lucy McLean full-time C05 Mrs Jennifer Inglis full-time C06 Mrs Chris Young full-time C08 Ms Helen McDermott full-time C10 Mr Harry Wallace full-time C21 Mr Raza Rehman full-time C14 Mr Jack Thomson full-time C27 Mr Martin Bienkowski full-time C26 Mrs Caitlin McFadyen full-time C19 Mr Sean Oswal full-time C24 Mrs Sheryl Hosie full-time C29 Ms Elaine McMaster full-time If these people included then have not queried successfully on disclosure STAFF ID TITLE FIRST NAME SURNAME DISCLOSURE C14 Mr Jack Thomson No C15 Mrs Shauna Dolan No C16 Mrs Lizzie Dornan No C28 Mrs Lauren Kerr No C01 Mr Raoul Naeem No C05 Mrs Jennifer Inglis No C21 Mr Raza Rehman No C10 Mr Harry Wallace No If these people included then have not queried successfully on first-aid dates STAFF ID TITLE FIRST NAME SURNAME FIRST AID UPDATE C29 Ms Elaine McMaster 18/07/2007 C27 Mr Martin Bienkowski 18/07/2007 C05 Mrs Jennifer Inglis 18/07/2007 C24 Mrs Sheryl Hosie 30/06/2007 C31 Mrs Tracey Sutherland 30/06/2007 C04 Ms Ashley Kerry 30/06/2007 C26 Mrs Caitlin McFadyen 30/06/2007
Page 22
Alternative formulae for Task 2A Estimated Weekly New Hourly Rate
Wage
=VLOOKUP(C5,INCREASE!$A$3:$B$5,2,FALSE)*G5+G5
=F5*H5
=VLOOKUP(C6,INCREASE!$A$3:$B$5,2,FALSE)*G6+G6
=F6*H6
=VLOOKUP(C7,INCREASE!$A$3:$B$5,2,FALSE)*G7+G7
=F7*H7
=VLOOKUP(C8,INCREASE!$A$3:$B$5,2,FALSE)*G8+G8
=F8*H8
=VLOOKUP(C9,INCREASE!$A$3:$B$5,2,FALSE)*G9+G9
=F9*H9
=VLOOKUP(C10,INCREASE!$A$3:$B$5,2,FALSE)*G10+G10 =F10*H10 =VLOOKUP(C11,INCREASE!$A$3:$B$5,2,FALSE)*G11+G11 =F11*H11 =VLOOKUP(C12,INCREASE!$A$3:$B$5,2,FALSE)*G12+G12 =F12*H12 =VLOOKUP(C13,INCREASE!$A$3:$B$5,2,FALSE)*G13+G13 =F13*H13
=IF(C5="Head Receptionist",HRinc,IF(C5="Assistant",Ainc,ASinc))*G5+G5
=F5*H5
=IF(C6="Head Receptionist",HRinc,IF(C6="Assistant",Ainc,ASinc))*G6+G6
=F6*H6
=IF(C7="Head Receptionist",HRinc,IF(C7="Assistant",Ainc,ASinc))*G7+G7
=F7*H7
=IF(C8="Head Receptionist",HRinc,IF(C8="Assistant",Ainc,ASinc))*G8+G8
=F8*H8
=IF(C9="Head Receptionist",HRinc,IF(C9="Assistant",Ainc,ASinc))*G9+G9
=F9*H9
=IF(C10="Head Receptionist",HRinc,IF(C10="Assistant",Ainc,ASinc))*G10+G10 =F10*H10 =IF(C11="Head Receptionist",HRinc,IF(C11="Assistant",Ainc,ASinc))*G11+G11 =F11*H11 =IF(C12="Head Receptionist",HRinc,IF(C12="Assistant",Ainc,ASinc))*G12+G12 =F12*H12 =IF(C13="Head Receptionist",HRinc,IF(C13="Assistant",Ainc,ASinc))*G13+G13 =F13*H13
[END OF MARKING INSTRUCTIONS]
Page 23