Removing Columns from the Grade Administration Excel Export

Removing Columns from the Grade Administration Excel Export

Nosūtīja Daniel Newbury
Atbilžu skaits: 3

Hello. I would like to simplify the output of the Grader Report Excel Export to show only First and Last name, ID Number, and Grades. I don`t need Institution, Department, or Email Address. Until now, I have been simply going in and deleting these columns each time I download to Excel. However, new teachers are using the data and I would like to simplify their experience. Any help is appreciated.

Daniel Newbury

Atbildot uz Daniel Newbury

Re: Removing Columns from the Grade Administration Excel Export

Nosūtīja John Ryan

I get round this problem by having a second excel spreadsheet that I have created which links to the sheet downloaded from the gradebook.

This allows you to skip any unwanted columns and also allows you to add other features e.g. formatting.

Once created you can download an updated sheet and the links can be set to automatically update.

Atbildot uz John Ryan

Re: Removing Columns from the Grade Administration Excel Export

Nosūtīja Daniel Newbury

John,

  Thank you very much for your help to my problem. Can you send me a tutorial on excel spreadsheet linking or the google keywords to find out how to do this? I have not had any luck. I`d like to see this in action and set it up for the new teachers to the system. Again, I really appreciate your help.

Kindest Regards,

Dan