2007 Administration. Higher Paper 2. Finalised Marking Instructions

2007 Administration Higher – Paper 2 Finalised Marking Instructions  Scottish Qualifications Authority 2007 The information in this publication may ...
Author: Damian Mason
3 downloads 1 Views 611KB Size
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

Suggest Documents