Microsoft Excel in Education Course

Event: Microsoft Excel in Education Course

Venue: Indepth Research Services, Nairobi, Kenya.

Event Date: 13th -17th November, 2017.

NITA CERTIFIED

INTRODUCTION

Integrating technology in the classroom is becoming more and more prevalent in many schools across the world. Hence through use of Excel it turns your school staff into Excel Professionals. 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

5 days.

WHO SHOULD ATTEND

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

COURSE OBJECTIVES

• Easily convert marks into levels or symbols
• Have Excel automatically colour cells depending on the mark received
• Track the performance of students over time
• Weight your marks or voting to get robust results
• Let Excel call the marks to you to ensure 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.

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)

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..
• Mainstreaming Disaster Risk Reduction into National Development Process..
• GIS Analysis for WASH Programmes..
• Strategic Financial Management..

For further inquiries, please contact us on Tel: +254 715 077 817, +254 (020) 211 3814, +254 731240802, +254 735331020.

Others Details

Accommodation is arranged upon request. For reservations contact the Training Officer.