•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Copy Sheet to New Workbook, Rename, and Transfer print area
Our take
As a high school teacher, enhancing your grading efficiency with Excel can streamline your workflow. To effectively store and reference common comments and point values for your rubrics, consider using drop-down menus for quick access. Creating a new workbook with individual sheets for each student allows for personalized feedback, and you can automate the process of naming these sheets according to student names. Additionally, establishing a print area in the original workbook ensures consistency across all copies.
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!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#financial modeling with spreadsheets#rows.com#big data management in spreadsheets#AI-native spreadsheets#google sheets#predictive analytics in spreadsheets#cloud-native spreadsheets#grading#rubrics#excel#print area#workbook#spreadsheets#comments#point values