Hello!
I use an excel sheet for interviewing candidates for my internship program, but lately the sheet has started to bug out and ends up taking me more time to fix than it should. I'm interested in turning the attached sheet into a PDF but I have a few questions:
- The first sheet is what the candidate sees and fills in
- The second sheet feeds from the first sheet, and that's what I use to grade their responses. I copy/paste values in the second sheet onto themselves and delete the first sheet. This sheet is also hidden from the candidate when they look at it - I just opened it so you could see it
- The third sheet is the code sheet that assigns a number value for a letter grade
I wanted to know if I turn this sheet into a pdf, can I make it so the candidate will only see and fill in the first page while not seeing any of my grading rubrics, and keep the grading formulas intact?
Thanks!
Bookmarks