Using Excel for Teachers
Learn how to use Excel, focusing on the most important features necessary for a teaching and educational environment
Ratings 0.00 / 5.00
What You Will Learn!
- Get to grips with using Microsoft Excel confidently
- Master the basics of Excel as well as some of the more advanced features
- Be able to use the most important functions of Excel that a teacher or other educator will need
- Complete several short projects relevant to teaching and education which focus on particular areas of use of Excel
Description
Are you a teacher or do you work in education? Do you wish to master the basics of Excel? Have you only found courses on Excel aimed at people in business rather than education? If so, this is the course for you. The course will enable you to develop the following spreadsheet skills:
Set up a page or spreadsheet, including adding a header, so that it is suitable for printing out.
Enter and format data, so the presentation is clear and looks professional.
Use functions in order to summarise data and make calculations.
Copy and paste or move around data and formulas in order to save duplicating work.
Use conditional formatting to highlight specific data.
Use lookup tables to assign grades to marks, for example.
Develop strategies to ensure that formulas are correct, by making changes and checking results, especially after copying formulas from one place to another within a spreadsheet.
The course is presented through a series of projects, progressing in complexity, to produce the kinds of spreadsheets that a teacher or other educator should find useful. The ideas can easily be adapted or individualised. The projects are the following:
Create a weekly planner.
Create a timetable.
Set up a register.
Use the names from the register to produce a tick list and a seating plan.
Use the names from the register to produce a mark book.
Who Should Attend!
- Any teacher who has little or no previous knowledge of using Excel
- Intermediate users who wish to refresh or build on their knowledge
- Anybody in the world of education who has only found Excel courses aimed at businesses