Creating Certificates Using Slides, Sheets & AutoCrat

Autocrat is a great Google Sheets add-on that you can use to create form letters in 

Docs. They recently announced that it can now be used in Slides too. This allows you to
design a variety of form templates such as certificates. See below for overview of steps
for using AutoCrat to create certificates. Watch these tutorials for complete details:
1.  Slides (certificates)

2.  Docs (form letters)

Step 1: Design Slide Template with Form Fields markedThe form fields are marked with <<  >> 

Thanks to Sarah Montplaisir for sharing her certificate design! 

Step 2: Install AutoCrat 

Once installed, it will be available for all your Sheets. It is a one time install.
Step 3: Collect data into Google SheetThe column headers must match the form fields used in the Slides.
Tip: You can use Google Forms to collect this data.

Step 4: Launch AutoCrat and Complete the Steps

Step 5: View and Print Finished Certificates

Creating Diagrams, Flowcharts & Mind Maps

Creating diagrams, flowcharts and mind maps are a great way for you and your
students to organize and illustrate complex ideas. Having students design these
illustrations supports their creativity, critical thinking, communication as well as 

collaboration skills if done with partners. All the options below have free versions with 

Google Sign-in or no registration required, so they can be used at all levels.

Creately

Video Tutorial (2 min)

​

Bubbl.us Video Tutorial (2 min)

​

Google Draw

Video Tutorial (2 min)

Draw.io

​Video Tutorial (1.5 min)

​

Canva

Video Tutorial (3 min)

​

MindMeister

Video Tutorial (3 min)

MindMup

Video Tutorial (1 min)

​

Coggle

Video Tutorial (1.5 min)

​

Sketchboard
Video Tutorial (4 min)

​

Mindomo
Video Tutorial (2.5 min)