Microsoft Office is one of the most powerful tools available to UK teachers — and one of the most underused. Beyond basic word processing, Office gives educators everything they need to design professional worksheets, maintain accurate gradebooks, build engaging lesson plans, and create interactive presentations. This guide is a practical walkthrough of the specific Office features that save teachers the most time.
Word: Creating Professional Worksheets
A well-designed worksheet is readable, clearly structured, and visually appropriate for the age group. Word gives you precise control over all of these elements.
Setting Up Your Worksheet Template
Start by creating a base template that you reuse across all worksheets for a class or subject. Set the page margins under Layout > Margins — Narrow margins (1.27 cm all round) give you more usable space for content. Set your default font to something clean and readable, such as Calibri 12pt for secondary pupils or a larger size for primary.
Create a header with your school name and class details (Insert > Header), and a footer with the pupil’s name line and page number. Save this as a template (File > Save As > Word Template .dotx) so you can start from the same foundation every time.
Useful Word Features for Worksheets
- Tables — Use tables for matching activities, data recording grids, and structured response sections. Insert > Table gives you a flexible grid that’s easy to format.
- Text boxes — For “write your answer here” boxes, insert a text box with a visible border (Insert > Text Box > Draw Text Box). Set a fixed size with a light grey fill to make the response area obvious.
- Lines for written response — Use the bottom border of a table cell to create writing lines. Set the table to have no border except the bottom of each cell.
- SmartArt — For diagrams, concept maps, and labelling activities, SmartArt (Insert > SmartArt) offers a range of pre-built diagram layouts that you can customise quickly.
- Word’s equation editor — For maths worksheets, the built-in equation editor (Insert > Equation) handles everything from basic fractions to complex algebra, formatting it correctly without manual fussing.
Fill-in-the-Blank and Form-Style Worksheets
For worksheets intended to be completed digitally, Word’s Form Fields (accessible via the Developer tab) allow you to insert text fields, drop-down menus, and checkboxes that pupils can fill in directly. Enable the Developer tab via File > Options > Customise Ribbon > Developer.
Excel: Building a Useful Gradebook
A well-structured Excel gradebook saves hours of manual calculation and makes it easy to identify pupils who need additional support.
Basic Gradebook Structure
Set up your spreadsheet with pupil names in column A, assessment tasks in subsequent columns (one per column), and summary columns at the right. The basic columns to include:
- Pupil name
- Individual assessment scores (one column each)
- Average score (using the AVERAGE function)
- Percentage (score / total × 100)
- Grade band (using IF or IFS functions)
- Target grade for comparison
Key Formulas for Gradebooks
AVERAGE: Calculate a pupil’s average across multiple assessments.
=AVERAGE(C2:G2)
Percentage: Convert a raw score to a percentage.
=H2/100*100 (where H2 is the score and the test was out of 100)
Grade Band with IFS (available in Office 2019+):
=IFS(I2>=70,"A",I2>=60,"B",I2>=50,"C",I2>=40,"D",I2<40,"E")
RANK: Show each pupil's rank in the class.
=RANK(H2,$H$2:$H$35,0)
Conditional Formatting for Instant Insight
Select the grade column, go to Home > Conditional Formatting > Colour Scales, and apply a green-yellow-red scale. Pupils performing strongly appear green; those who may need support appear red. You can see the whole class picture at a glance.
Progress Tracking Over Time
Extend your gradebook across multiple sheets (one per term) and use a summary sheet with references to pull the key metrics together. This builds a clear record of each pupil's trajectory — valuable for parent consultations and progress reviews.
PowerPoint: Building Lesson Presentations
Structuring a Lesson Deck
A well-structured lesson PowerPoint follows the learning sequence: objective, retrieval activity, new content, guided practice, independent work, summary. Each phase gets its own section, making it easy to navigate during delivery.
Use View > Slide Sorter to see the whole lesson at a glance and reorganise the flow as needed. The Section feature (Home > Section > Add Section) lets you group slides by lesson phase.
Slide Master for Consistency
Rather than formatting each slide individually, use the Slide Master (View > Slide Master) to set up your standard slide layouts — title slides, content slides, image-with-caption slides. Changes made in the Slide Master apply to all slides using that layout, keeping your presentation visually consistent with minimal effort.
Useful PowerPoint Features for Teaching
- Presenter Notes — Add teaching notes, discussion prompts, or subject knowledge reminders in the Notes panel below each slide. Visible in Presenter View during delivery.
- Zoom (Summary Zoom) — Insert > Zoom > Summary Zoom creates an interactive overview slide that lets you jump to any section non-linearly during a lesson — useful for responding to pupil questions.
- Timer slides — For timed activities, a simple timer animation (a line that shrinks to zero using a motion path over a set duration) gives pupils a clear visual countdown.
- Annotation tools — During a lesson, right-click and select Pointer Options > Pen to annotate live on slides — underlining key terms, working through problems, circling important details.
OneNote: The Teacher's Notebook
OneNote, included with Office 2024 Professional Plus, is often overlooked but exceptionally useful for teachers. It works as a digital planning notebook where you can store lesson plans, resource links, pupil notes, and meeting records — all searchable and accessible from any device. The Class Notebook feature, available through Microsoft 365, extends this into a shared space with pupils.
Getting Set Up
All the tools covered in this guide — Word, Excel, PowerPoint, and OneNote — are included in Office 2024 Professional Plus at £29.99 from GetRenewedTech. For Mac users, Office 2024 for Mac at £49.99 includes Word, Excel, PowerPoint, Outlook, and OneNote in their macOS-native versions.
For teachers working with personal devices rather than school-supplied machines, this is one of the most cost-effective ways to ensure you have professional-grade tools at home for planning and resource creation.
