Rubric - Mail Merge Creation
Note: This tool needs your expertise to be excellent. Be sure to closely review and edit this rubric
before assigning it to students!
Criterion Emerging Progressing Excelling
- A data source is
- A data source is
created with at least
created with at least
four relevant fields -
- A data source (like four relevant fields
Field names are
a table or (for example, name,
clearly labeled in the
spreadsheet) is address, city, and
Preparation of Data first row - Data
created with at least date) - Field names
Source entries are complete
two fields (for are clearly labeled in
for all records - Data
example, name and the first row - Data
is checked for
address) entries are complete
accuracy (no spelling
for at least 80% of
errors, consistent
the records
formatting)
- A main document is
created with a clear
structure (greeting,
- A main document is
body, closing) - At
created with a clear
least three merge
structure (greeting,
- A main document fields are inserted in
body, closing) - At
(like a letter or appropriate places -
Creation and least three merge
certificate) is created Consistent and
Formatting of Main fields are inserted in
- At least one merge appropriate
Document appropriate places -
field is inserted into formatting is applied
Basic formatting
the document throughout (font,
(font size, alignment)
spacing, alignment) -
is applied to the
Additional elements
document
such as a header,
footer, or logo are
included
Execution and - The mail merge - The mail merge - The mail merge
Output of Mail process is started process is process is
Merge and at least one completed, completed,
merged document is generating merged generating merged
generated documents for all documents for all
records in the data records in the data
source - The merged source - The merged
documents are documents are
previewed to check previewed to check
for correct field for correct field
placement placement - The final
merged documents
are saved or printed
as a new file - Errors
or formatting issues
are identified and
corrected before
submission