Event: Microsoft Excel in Education Course

Venue: Indepth Research Services, Nairobi, Kenya.

Event Date: 04th-07th December 2017.

RECENT CLIENTS

NITA CERTIFIED

INTRODUCTION
Integrating technology in the classroom is becoming more and more prevalent in many schools across the world. Excel is used to get to grips with the performance of the learners, educators and the school. It helps automate manual activities hence being very efficient and consistent

DURATION:
4 days

WHO SHOULD ATTEND
Anyone who deals with educational focus i.e. Principals, Head of Departments, teachers, lecturers and school admin staff.

LEARNING OBJECTIVES
• Easily convert marks into levels or symbols.
• Have Excel automatically color cells depending on the mark received.
• Track the performance of students over time.
• Weight your marks or voting to get robust results.
• Using Excel to call the marks thus ensuring accuracy.
• Create histograms of results for comparison purposes.
• Extract random samples from a student population.
• Make sense of marks across a range of students

TOPICS TO BE COVERED
• Accessing Excel Functions so that you can find the functions that will help you in the shortest amount of time.
• Understanding Excel formulas to know when to use a VLOOKUP to mark levels and when to use an IF function.
• The uses of the IF function for determining pass versus fails.
• Tips and Tricks with Excel for Schools to save time and effort in your day to day excel work.
• How errors happen in spreadsheets in order to avoid them.
• Consolidating student marks over multiple years to save you time with repetitive copy and paste
• Comparing class performance with prior periods to spot trends and risks
• Add graphics to visualize what your monitoring.
• Cleaning up data received from school database software for analysis and comparison.

Visit our website for more details.

Tailor-Made Training
This training can also be customized for your institution upon request to a minimum of 4 participants. You can have it delivered in our training centre or at a convenient location.

How to participate
Tailors make your course.
Register individual.
Register as a group.
Become one of our partners.
Purchase software’s
Frequently asked Questions (FAQ’s)
Recent Clients

View related courses
Mobile Phone Based Data Collection Using ODK..
ICT for Disaster Response..
Microsoft Excel for Health Care Professionals..
M & E, Data Management & Analysis for Agriculture & Rural Development Programmes.
Microsoft Excel for Agriculture Professionals..

The most popular courses
Digital marketing (Email & Social Media) and Brand Online Visibility..
Establishing and strengthening farmer organizations..
Advanced Training on Fire Safety and Fighting Marshal..
How to Influence Decision Makers to Take up Research..
Proposal Preparation Using the Logical Framework Approach.

ACCOMMODATION
Accommodation is arranged upon request. For reservations contact the Training Officer.
Email: outreach@indepthresearch.org
Mob: +254 715 077 817
Tel: 020 211 3814

PAYMENT
Payment should be transferred to IRES account through bank on or before C.O.B. 27th November 2017
Send proof of payment to outreach@indepthresearch.org

View course catalogue on ICT4D and mobile technologies Institute.
For further inquiries, please contact us on Tel: +254 715 077 817, +254 (020) 211 3814, +254 731240802, +254 735331020.
Email outreach@indepthresearch.org