2
To put your footer here go to View > Header and Footer 2 Objectives Students will get the opportunity to: Practice what they have learnt so far using excel for tables and graphs Apply the analytical skills they have been developing Use excel on they own data Practice working in a team, develop their soft skills Practice communication: –Both within your group and in the presentation

3
To put your footer here go to View > Header and Footer 3 Sessions 17&18 Form groups of 4-5 members Read and discuss the project overview –This outlines the scenario, briefly, the group wishes to create a product portfolio is to show prospective clients wishing to use their results or consultancy services. They must first prepare a pilot portfolio to illustrate what they intend to produce. –The pilot is what students are to produce. Look at the questionnaires from the household survey that you will be working on Then choose a topic to focus on e.g. health, education, water and sanitation or poverty

4
To put your footer here go to View > Header and Footer 4 The Group Decide how you will work within your group –to achieve the objectives you have set You should be using previous skills and knowledge acquired in this course –within the limited time available You will have to split the responsibilities among the team members –consider appropriate team composition (Chairperson, reporter, Presenter, etc.) For this you should think about each persons skills and strengths from previous experience or from within this course and position them appropriately

5
To put your footer here go to View > Header and Footer 5 The Project: Next determine : –The objectives of your study. These will lead you to the variables that need to be analysed. Which will lead you to the precise data that you need to request. –The analysis you will apply to your data You should plan the tables and graphs you will use to highlight the important points about your data Even sketch numberless versions by hand. Write a short justification for each one, stating what they will add to the presentation. (if this is difficult rethink your decision to include the figure)

6
To put your footer here go to View > Header and Footer 6 Data request: Complete the data request from and submit it. –To do this your project will need to be clearly defined. –You will need to justify why you need the data. –And what it will be used for. These forms are important as they provide the data provider with a record of when, which data has gone towards what. –Thus they know which data has been useful –Which data should be collected in more or less detail, more or less frequently –What is being achieved as a result of the surveys…

7
To put your footer here go to View > Header and Footer 7 Presentation Prepare a few slides to explain your work to the clients This must be prepared on time If necessary some tables or graphs may have to be omitted This is to take the form of the presentation from a pilot project It is also to justify further work that you specify briefly in the presentation giving terms of reference if possible The presentation is to the sector working group and to others who are interested

8
To put your footer here go to View > Header and Footer 8 Project work plan All of these timing are guidelines –if you feel you would like to plan more thoroughly so that you spend less time creating the presentation that is the choice of the group. One hour and a half –Discussing the project and completing the data request form Three hours (perhaps working in two smaller groups) –Analyzing (creating tables, graphs and explanatory text…) –Plans of future work proposals (if you are including this) One hour and a half –Creating the PowerPoint presentation

9
To put your footer here go to View > Header and Footer 9 Session 19: Presentations Each group will give their presentation in Session 19. Each presentation should be 5 to 10 slides long and last 5 to 10 minutes. Try not to exceed this time limit If you do you may be cut off before you finish It is useful to take notes during other groups presentations so as to be able to give useful feedback.

10
To put your footer here go to View > Header and Footer 10 Assessment At the end of Session 19 you will be asked to hand in 6 assessment forms. 3 Peer Assessment forms 1 for each member of your team. 1 Group Assessment form You will fill this in with details of the presentation of one other group of your choice. 1 Self Assessment form You will fill this in with details of your own performance

11
To put your footer here go to View > Header and Footer 11 Assessment Read the Notes of Assessment Handout Each form will have the same layout You will be asked to –Give a mark –Justify this mark by in two ways: Describing what you were impressed by Describing, constructively what could be improved –Finally there is an area for any further comments you may have

12
To put your footer here go to View > Header and Footer 12 Confidentiality Confidentiality is an important ethical issue –The pros and cons of it should always be considered Here confidentiality through anonymity will: –ensure honesty in marking and commenting –help to maintain group cohesion and –not detract from the usefulness of the exercise So confidentiality is a good idea here We will achieve it by –Summarising the marks and comments about given to each person and group. This will ensure confidentiality in that the source of the comments will not be divulged.

13
To put your footer here go to View > Header and Footer 13 Session 20: Class discussion This session will be used to discuss: The development of soft skills (communication, group work…). –The assessment forms both individual and group will be handed out in summarised form. –You will have an opportunity to discuss The importance of Soft Skills And how well they are being developed

14
To put your footer here go to View > Header and Footer 14 Discussion of Data accessibility In this project you went through a mock Data Request process. Are they a good idea? In reality –How available are data to you? Can you access them through a Data Request? Do you need to submit a Data Request? –Does your organisation require Data Request forms from outsiders asking for data? –When your organisation provides data are the finished reports (created from the data) made available to them? either in a library on the web

15
To put your footer here go to View > Header and Footer 15 Discussion of this course You have all evaluated each other, lets look at this course: Kirkpatric purports that to test the effectiveness of training, four levels of evaluation are involved: –1 Reaction: Comparable with customer satisfaction How well did you react to the course? –2 Learning: Was your knowledge increased? –3 Behaviour: Do you do anything differently in your job as a result of the course? –4 Organisational results: Have any of the changes in behaviour or learned knowledge had an impact at the organisational level? ( Kirkpatric & Kirkpatric (2006) Evaluating traning programs: The Four Levels (Third Edition) San Francisco: Berrett-Koehler Inc.

16
To put your footer here go to View > Header and Footer 16 Discussion of this course Think about this evaluation scheme –Do you agree with it? Discuss this course –Either just this module or the whole course