Spreadsheets Exercises

Click on the links below and follow the given instructions to design the required spreadsheets. All work must be save for assessment.

Task1
http://www.abacustraining.biz/Exercises/Excel/BasicSS/BasicSS_EX001.htm

Task2
 http://www.abacustraining.biz/Exercises/Excel/BasicSS/BasicSS_EX004.htm

Task3
http://www.abacustraining.biz/Exercises/Excel/BasicSS/BasicSS_EX007.htm

Task4
http://www.abacustraining.biz/Exercises/Excel/IntermediateSS/InterSS_EX002.htm

Task5
http://www.abacustraining.biz/Exercises/Excel/IntermediateSS/InterSS_EX004.htm

Paper 2 Class Activity

Read the news article below.
http://www.digitalspy.co.uk/tech/news/a432446/apples-siri-breaking-chinese-law-by-listing-escorts.html

What is the main issue or concern raised?

Who are the main stakeholders?

Describe how the technology works.

Give two examples of  how the technology causes the issue identified to exist

State two advantages of the using the technology

State two problems resulting form using the technology

Describe one solution to the one problem stated above.

Project Management Issues

To be able to manage a system development to completion, different project development methodologies and project management methodologies are used.

Make detailed notes on the following;

a) What are the reasons for having  project management programme /schedule?

b) Below are two project development methodologies. Distinguish between them in detailed 
    using relevant diagrams and showing the strengths and weakness of each.
        i) Agile development method

        ii) Waterfall development method

c) There are different methodologies used in project management. Obtain useful notes on the  following;
         i)   PRINCE2 (projects in controlled environments 2)
         ii)  SSADM (structured systems analysis and design method)
         iii) PMBoK (project management body of knowledge), 
         iv) CMMI (capability maturity model integration)

Use
http://kisi.deu.edu.tr//guzin.kavrukkoca/BISMaster/software_project_mang.pdf and any other sources

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

Spreadsheet Activities

Excel Practical activities
 http://www.teach-ict.com/key_skills/spreadsheets/book3/Modelling3.pdf
 
Use the following tutorial to learn about the Excel spreadsheet software.
http://www.gcflearnfree.org/excel2003

Modelling with spreadsheets;
http://www.bbc.co.uk/schools/gcsebitesize/ict/modelling/0spreadsheets_act.shtml  

Practical Exercises
Open the spreadsheet below;
 http://isc-itgs.wikispaces.com/file/view/Student+Excel+Activity+Sheet.xls

Answer the questions in the worksheet provided.