u/Fearless_Spirit7198

I am a high school teacher and I am considering changes that could make grading more efficient for me. I have rubrics made that I am recreating as excel spreadsheets. There is a core portion of the sheet that will be printed off and given to students for their reference.

What I’m unsure of is how to efficiently do is the following:

• Store and quickly reference common comments and point values for each part of the rubric. (e.g. 1 out of 2 - incomplete calculations). Drop downs or a sheet with common comments come to mind, but I’m not sure about the logistical benefits and downsides of each option within excel specifically
• Make a separate workbook from the original rubric workbook with copies of the rubric sheet that are named for each student in one or more classes. In addition to the name of the sheets being unique, I would also need the name to appear in a cell on that sheet.
• The print area would ideally be established in the original document and transferred to all copies

I do not have anything already created so I am very open to suggestions for formatting and how student names should be stored in order to execute this process. I know this will require coding, which I have not done in excel, so your patience is appreciated. Thanks!