We Helped With This Accounting Economics Homework: Have A Similar One?

Excel and LinkedIn

Brief and Marking Scheme

Requirements

This is a two part assignment, it consists of:

1.    A group spreadsheet task, and

2.    An individual LinkedIn profile

Submission

Only one submission is required per group, the submission must be one single Excel spreadsheet that contains both of the above tasks.  The Spreadsheet will need multiple sheets, the majority of which will be for the group spreadsheet task, however and very importantly there must be one extra sheet, which details the students P numbers and the four web addresses to the four students’ LinkedIn profiles.

Group Spreadsheet Assignment

Anonymous Charity

A large national charity that is best described as a learned society and professional body, has a need for an advanced spreadsheet to assist the organisation in budgeting.  The charity is undertaking a costing review of the prices of its qualifications and requires a spreadsheet that is simple to use. 

The requirements are:

1.    A single file spreadsheet, with a “Calculator Sheet”, bringing together all of the various costs,

2.    The ability to quickly and easily choose which method of allocation the cost should be shared on, the two options are:

o    By total student numbers (all students pay the same), and

o    By qualification (the qualification is charged the same percentage, but this standardised cost is shared amongst the students on that qualification).

Data

The charity offers six qualifications, with different numbers of enrolled students:

The charity has the following annual costs:

Each qualification has a different number of assessments and meetings with varying number of delegates, thus unlike the above, each qualification (cost centre) has different costs (for the avoidance of doubt, both allocation options need to be available in the spreadsheet, even though each qualification carries a different cost):

The costs of holding a meeting, regardless of qualification:

External delegates are entitled to claim travel and accommodation.  Staff members can only claim travel.  The budget must account for refreshments and stationery for both external delegates and staff members.

The charity currently pays approximately 38% of the maximum claimable expenses; however this has grown 5 percentage points in both of the last two years.

The charity requires the ability to adjust the percentage above quickly and easily.

The Charity wishes to charge the students a single fixed fee factoring in the different average study lengths.

No support will be provided as to the technical excel nature of this assignment, however clarification on the requirements of the charity can be sought in person only during the following times:

§  Wednesday 7^th February,            during your lecture slot

§  Monday 5^th March,                       HU2.02 between 2pm and 2:50pm

§  Wednesday 7^th March,                during your lecture slot

§  Thursday 8^th March,                      HU2.02 between 2pm and 2:50pm

§  Monday 12^th March,                     HU2.02 between 2pm and 2:50pm

§  Wednesday 14^th March,              during your lecture slot.

§  Thursday 15^th March,                    HU2.02 between 2pm and 2:50pm

Individual LinkedIn Profile

Each member of the four person team needs to complete their own LinkedIn profile in line with the style, techniques and knowledge that was shared during the lecture.

Assignment Submission and Format

The assignment must be submitted via Blackboard no later than 11:59pm on the hand-in date and No paper copy is required

Only one submission is required per group, the submission must be one single Excel spreadsheet that contains both of the above tasks.  The Spreadsheet will need multiple sheets, the majority of which will be for the group spreadsheet task, however and very importantly there must be one extra sheet, which details the students P numbers and the four web addresses to the four students’ LinkedIn profiles.

Please refer to the Handbook and Regulations for Undergraduate Awards (p.13) regarding late submission and reassessment.

Marking Scheme

Marks will be awarded as follows:

Spreadsheet 60% – Group Score

§  Ease of Use

§  Ability to share costs as per the two methods

§  Calculator arrives at the correct total cost for all expenses

§  Future proofing, from the ‘calculator’ sheet

§  Visual presentation

§  Effectiveness

LinkedIn Profile 40% – Individual Score

§  Quality of Introduction

§  Experience and Education

§  Featured Skills and Endorsements

§  Picture and Cover image

§  Effectiveness

Example Score

For the benefit of doubt, your overall grade will be made up of two scores, for example:

*55% x 60% weighting + 40% x 40% weighting = 49%

It is therefore very possible that each of you will receive different scores overall.

Penalties

§  Where the group size is not 4, a 10-mark deduction will be applied to the final grade.

§  Support will be provided to help students form groups, to take advantage of this support you must attend your lecture were at the end of the session time will be made available for students to make their groups.  There will be one opportunity:

o   Wednesday 7^th March at 1pm