Terms of Reference
STATA Training
ONLINE
10th to 14st December 2023
1. Purpose
This Terms of Reference aims to provide a framework for planning and conducting the STATA training for World Vision Somalia-based Staff.
2. Background
This training seeks to empower its staff with requisite skills that can help them to connect and integrate data from multiple sources, shape it, and visualize it in a timely manner. These skills will go a long way in ensuring easy report visualization and collaboration.
3. Training Goal
This course aims to equip WV Somalia staff to understand the basics and intermediate aspects of STATA, enabling them to perform analytical and reporting functions using both tools. In addition, the trained staff will eventually train other WV Somalia staff on the same. Below is a list of training areas of interest to World Vision Somalia:
• Stata interface and files
• Using do-files
• Variables, locals and globals
• Changing directory
• Opening, browsing, saving, sorting, importing and exporting datasets
• Stata Help • Saving results output in a log file
• Renaming, labelling, ordering, creating and replacing variables
• Merging and appending datasets
• Manipulating datasets (reshape; collapse)
• Using loops (foreach; forvalues)
• Summary statistics (sum; _pctile; by(varlist))
• Useful functions for creating summary variables (egen)
• Creating graphs (line plots; scatter plots)
4. Deliverables:
This course will be delivered online to the appropriate World Vision Somalia staff. The following shall be required.
5. Duration
The training is expected to take 3 days starting from 10th -14th December 2023. The trainer should commit to delivering the entire content within the stipulated time, even though completion highly depends on the participants' pace. For maximum gains, understanding of concepts therefore takes precedence over completion.
6. Training methodologies
The program is taught using practical and interactive case studies and numerous exercises to
re-enforce the concepts covered in each teaching session, experiential learning approach using World Vision data sets, and interactive, hands-on working sessions throughout the training.
7. Consultant’s responsibilities
The consultant will be required to:
8. Payment schedule
WV Somalia will offer payments based on specific outputs as described below:-
Deliverables
Duration
(Estimated # of days)
Timeline
(at the end of)
Schedule
of payment
Draft Trainer's manuals and Participants' Workbook (learning activities, a training agenda, and learning assessment tools)
1 week
Before the beginning of training
Payment No. 1
(50%)
Delivery of the training
3days
Final report
1 week
After the training
Payment No. 2 (50%)
The following shall be required before processing the final payment.
8. WV Somalia Responsibilities
WV Somalia will;
9. Logistics
The Trainer should have the following logistics considerations
The Lead Trainer should have the following qualifications and experiences:
Proposal Evaluation Criteria
11. Mandatory Requirements
12. Technical Evaluation
The consultant must have proven expertise and experience in providing customized data analysis training Computer Sciences. Proof of these is to be provided by submitting, together with the application:
1. Preliminary evaluation to determine eligibility (as described above) and administrative compliance of this Invitation to Bid.
2. Evidence of experience in this field (number of years in service and clients served)
3. Organizational governance and management structure, staff members and staff to be assigned to this project with their qualification and experience.
5. Proposed budget, applicable taxes and any reimbursable costs to carry out the exercise. 6. Applicable commercial terms to the proposal submitted.
Proposals that do not meet the eligibility criteria (1) above shall be eliminated and shall not be considered for subsequent stages of the evaluation
2.3 Proposal Contents
Proposals from Consultants should include the following information (at a minimum)
Financial Evaluation
13. Submission Guideline
Each application should include, at a minimum:
Please note that proposals should be submitted by email to somo_supplychain@wvi.org on or before 13th December 2023 in three distinct/separate attachments, namely Mandatory Requirements, Technical Proposal and Financial Proposal (Bidders who will combine both technical and financial proposals shall be disqualified
Email title should be; - STATA TRAINING
Bids received after deadline shall not be considered,only the final selected candidate will be contacted.