Google Slides™ relief for award decks and staff directories

A calm guide to Google Slides™ for award decks and staff directories

Slides are how schools and offices celebrate, introduce and announce: the honor roll assembly, the new-staff welcome, the board presentation, the lobby display. The work is rarely difficult. It is repetitive. Forty award slides are one slide made forty times, and the temptation is to duplicate, retype, duplicate, retype until the bell rings. This guide shows a calmer way to think about decks, and the small habits that keep them consistent.

One template, one roster

Any repeated slide has two ingredients. The template is the design: where the name sits, how large it is, which corner holds the grade. The roster is the list of people, usually a spreadsheet with a column for each detail. If you keep those two things separate, building the deck becomes a matter of matching each spot on the template to a column in the roster and letting every row produce a slide.

That is what the previewer above demonstrates. Choose which column fills the large line, the award line and the two corners, then build every slide at once. Change one choice and build again, and the whole deck follows. When the roster changes the night before the assembly — and it always does — you correct the row and rebuild instead of hunting through slides.

Preparing a roster that produces clean slides

• One row per slide. A student with two awards needs either two rows or one row with both awards written the way you want them to appear.
• Names exactly as they should be read aloud. Check spelling and preferred names with homeroom teachers before the deck is built, not after.
• Short, consistent award titles. “Perfect Attendance” on every row, not a mixture of “Perfect attendance”, “Attendance Award” and “No absences”.
• A sort order that matches the ceremony. Sort the roster by grade, then by last name, and the slides come out in the order they will be announced.

If the names arrived from a form and are full of stray spaces or capitals, the Sheets relief lab shows how to tidy an entire column with one formula before you build anything.

Let the theme do the formatting

Every deck has a theme behind it: a set of master layouts that control fonts, colors and positions. Most people never open it and format each slide by hand, which is why slide twelve ends up with a slightly different title size from slide eleven. Open Slide, then Edit theme, and make your change once on the layout. Every slide built on that layout updates together. Place logos and decorative borders on the layout as well, so they cannot be nudged out of place on individual slides.

Readable from the back of the room

A slide that looks fine on a laptop can be unreadable in a gymnasium. A few rules of thumb help:

• Use large type. Names should be the biggest thing on the slide; supporting details can be much smaller.
• Keep strong contrast between text and background. Dark text on a light background survives a washed-out projector best.
• Avoid text placed over photographs unless there is a solid band behind it.
• Leave generous margins. Projectors and televisions often crop the edges.
• Choose widescreen 16:9 under File, then Page setup, to match most classroom displays.

These choices are also accessibility choices. High contrast and large type help everyone in the room, including people with low vision, and they are part of the accessibility standards that apply to materials a public school publishes.

Photos without the stretch

Staff directory slides usually include a photograph, and stretched photographs are the most common flaw in an otherwise tidy deck. Always resize a picture by dragging a corner handle, never a side handle. To make every photo the same shape, use the crop tool and choose a fixed shape such as a circle or square. If a picture has already been distorted, click it and choose “Reset image” to return it to its true proportions.

Sharing and presenting

For a ceremony, present from the Slideshow button and use the arrow keys; nothing else is needed. For a lobby screen, use File, then Share, then Publish to web, to produce a version that advances by itself and loops. Before publishing anything publicly, read through every slide for information that should stay inside the building. A staff directory with personal mobile numbers, or an awards deck that includes a student whose family has asked for no public photographs, should be shared with named people only.

When you need printed certificates rather than projected slides, open File, then Print preview, and choose one slide per page. A deck built from a roster doubles as a stack of certificates with no extra work.

Keeping a deck reusable

The honor roll happens every marking period and the directory is rebuilt every August. Save yourself the repeat effort. Keep a clean copy of the template deck with no names in it, labeled clearly as the template. Keep the roster as its own spreadsheet with the same column headings each time. Next term you only replace the rows. If you find yourself doing this for several events a year, an add-on can perform the build step directly from the sheet, which turns an afternoon of duplicating into a few seconds.

A short checklist before the assembly

1. Confirm every name against the homeroom list, including pronunciation notes for the announcer.
2. Click through the entire deck once at full screen.
3. Check the first and last slides for leftover placeholder text.
4. Test on the actual projector or television if you can, and look from the back of the room.
5. Download a copy as a PDF in case the wireless network is unavailable on the day.

Common questions

Can Google Slides™ create a slide for every row of a spreadsheet by itself?

Not directly. Slides can link to a chart or table from Sheets, but producing one slide per row requires either manual duplication or an add-on. The previewer on this page shows how the matching works so any tool will make sense.

How do I change the font on every slide at once?

Open Slide, then Edit theme, select the layout your slides use, and change the font there. Every slide based on that layout updates together.

Can I print the slides as certificates?

Yes. Choose File, then Print preview, set one slide per page, and print on certificate paper or card stock.

Are the students in the previewer real?

No. Every name, grade and award on this page is invented practice data that stays in your browser.

What slide size should I use for a classroom projector?

Widescreen 16:9 suits most modern projectors and televisions. You can change it under File, then Page setup.