t20racerman
New Member
- Joined
- Oct 17, 2016
- Messages
- 4
Hi all
I really hope you can help. I'm a Physics teacher using an exam board generated spreadsheet in which I can keep track of all my student's practical work over a minimum of 12 assessed practicals - I have to keep these records as part of their assessment. You can download the spreadsheet I'm using here to see what I mean:
http://filestore.aqa.org.uk/resources/physics/AQA-7408-EET.XLSX
In the L6th form I had three of these sheets - one for each group, and all went well. However, in the U6th, some students dropped the subject and the groups were all swapped around so that the remaining students are in different groups.
I've tried deleting students who've dropped the subject - and cant. It just messes up the spreadsheet.
I need to move students and their data from one sheet to another - and can't see how to do so.
Alternatively, could I merge the three sheets somehow and have them all on the same sheet if that is easier?
The spreadsheet was put together by the AQA exam board. I phoned their advisors for help and was told "find someone who knows Excel"! They offer no support whatsoever.
I could set up new spreadsheets for my U6th groups, but would then need to cut and paste all the filled in data across from last year's work.
I would appreciate any help or guidance here.
Thanks
Adrian
I really hope you can help. I'm a Physics teacher using an exam board generated spreadsheet in which I can keep track of all my student's practical work over a minimum of 12 assessed practicals - I have to keep these records as part of their assessment. You can download the spreadsheet I'm using here to see what I mean:
http://filestore.aqa.org.uk/resources/physics/AQA-7408-EET.XLSX
In the L6th form I had three of these sheets - one for each group, and all went well. However, in the U6th, some students dropped the subject and the groups were all swapped around so that the remaining students are in different groups.
I've tried deleting students who've dropped the subject - and cant. It just messes up the spreadsheet.
I need to move students and their data from one sheet to another - and can't see how to do so.
Alternatively, could I merge the three sheets somehow and have them all on the same sheet if that is easier?
The spreadsheet was put together by the AQA exam board. I phoned their advisors for help and was told "find someone who knows Excel"! They offer no support whatsoever.
I could set up new spreadsheets for my U6th groups, but would then need to cut and paste all the filled in data across from last year's work.
I would appreciate any help or guidance here.
Thanks
Adrian