Excel Challenge (prize - she keeps her job!)

H

Her Husband

I posted the message below on 31st July 2004. Many people from this
forum took the time to complete the task which on the surface looked
quite straight forward. It became obvious that the question was
ambiguous and required a degree of mathematical analytical skill that
was probably beyond the scope of the job in question. My wife used
the data from this exercise in her arguments and I'm pleased to say
that she was successful in her appeal and has retained her job with
the promise of extra training as required. We would just like to
thank everybody here for their time, effort and comments which proved
quite valuable. Keep up the good work.

---------------------------------------------------------------------------

From: Her Husband ([email protected])
Subject: Excel Challenge (prize - she keeps her job!)
Newsgroups: microsoft.public.excel.misc
Date: 2004-07-31 11:07:51 PST


This is an appeal to all Excel users out there. My wife has just lost
her job because she didn't satisfactorily complete an Excel task in
the allotted time. She is appealing against her dismissal and would
be grateful for any constructive comments anyone might have - they
just might help her win her job back.

If we can get about 100 people to do
this and send to our email address their Excel file to include also a
note of their years and level of experience and how long it took them
to do, then we might be able to present a statistical argument as to
the fairness of the test.

TEST
Present the following information in an accessible table format

The following training programmes are run in a college

Course A1, 10 groups (6 day and 4 evening)
Course A2, 5 groups (3 day and 2 evening)
Course A3, 3 groups (2 day and 1 evening)
Course B, 2 groups (1 day and 1 evening)
Course C1, 5 groups (3 day and 2 evening)
Course C2, 3 groups (2 day and 1 evening)
Course C3, 1 group (day)

15 enrol on each group in the A Courses and 17 in Course B. 12 enrol
in each group for the C courses.

All groups run for 18 weeks. Day-time groups are 10 hours a week (per
group) and the evening groups are for 5 hours a week (per group).
Courses C1 & C2 groups run for 4 hours a week each. Course C3 is 15
hours a week.

Calculate the total number of students enrolled and the total number
of learning hours for the 18-week programme.
 
A

AlfD

Hi!

Delighted to hear the outcome. Distressed to think any employer coul
operate like this. A contract of employment is two-way: there ar
obligations on both sides and it seems this commonsense has prevailed.

Al
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top