Tuesday, July 1, 2014

Pull Data from Spreadsheets

Marama from Clevedon School came up with a great idea of creating a spreadsheet where each sheet has individual student's assessment data. She then wanted to share each student's sheet to them. With normal sharing options you can not share just one sheet, sharing allows you to share the whole spreadsheet. This poses a problem, as she doesn't want the other students or parents to see each others results. There is a hide option in Google Spreadsheets where you can hide the sheets you don't want others to see, but anybody could un-hide them if they are spreadsheet savvy. After a little research  we found an old solution that didn't work but it gave us a basis to work from

You may need change permissions on your original class doc to 'Anyone with this link'.