CASE STUDY 2013 ACTIVITIES

Respond to the following individually;

1. "The taxi requests are recorded in a shared spreadsheet on the office network with one worksheet for each driver which is cumbersome to use. At the end of the day each driver returns to the depot to reconcile the jobs and money taken, and this data is entered into the spreadsheet as well."
   a) The above is an extract from the case study material 2013. Design a spreadsheet to show how the main details must have been represented for each driver in the worksheet by the Company?
   b) Use the data entries examples from the spreadsheet designed to explain why this was cumbersome to use.
2. Describe TWO main social and ethical issues that can arise from using behavioral marketing software by the Red Dragon Taxi Company. 
3. Explain TWO situations where Business intelligence software can be used by the Taxi Company.
4. Surveillance
   "The management of Red Dragon Taxi Company has announced that CCTV equipment will be installed to monitor the activities in the taxi in the interests of driver and customer safety. GPS and GPRS will also provide the location of the vehicles. However, this raises concerns from the drivers about employee monitoring. Different monitoring systems are being investigated. "

         The extract above is from line 116
          a) Red Dragon company may be considering to move to 4G technology instead of
               GPRS. What is the impact of this move to the Company?
          b) "Different monitoring systems are being investigated".  Give evidence from 
                research of measures that can be put in place to address the concerns of drivers in 
                having monitoring technologies in the taxis.

Also visit the following link and read the case study articles posted.
http://www.itgsnews.com/2012/06/case-study-2013-red-dragon-taxi-company.html