+ Reply to Thread
Results 1 to 14 of 14

Protection

  1. 10-26-2017, 02:54 AM #1
    jubru
    jubru is offline
    Registered User
    Join Date
    10-26-2017
    Location
    Australia
    MS-Off Ver
    Office for Mac v15
    Posts
    5

    Protection

    Hi,
    new to the forum and not particularly skilled with Excel...
    Usually, in the grade center on blackboard, my students only see their grades and don't have access to the ones of their fellows. However, I need to uploads marks that are on an excel spreadsheet. Ideally, I would like to keep a similar feature. I would love to have everything hidden and when the students type their ID (for example) it reveals only the row containing their marks.
    Is it possible (simply) in Excel?
    I know I can protect a row with a password, but I'm not sure whether you have to have the mouse hovering over a cell in that protected row to enter the password or if there is a stand alone window.
    thanks
    julien
    Reply With QuoteRegister To Reply
  2. 10-26-2017, 02:59 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Protection

    Welcome to the forum!

    You won't be able to get the control you require just with formulae. You would be better off exporting the grades to a platform that does what you require.

    Having said this, it's possible to create a dashboard in Excel, but you'd need to give each of your students a unique code to access their results, and it would be quite a faff when you can potentially get the results you need by exporting the Excel data to something else.
    Last edited by AliGW; 10-26-2017 at 03:05 AM.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 10-26-2017, 03:06 AM #3
    shivya
    shivya is offline
    Forum Contributor shivya's Avatar
    Join Date
    08-19-2017
    Location
    Delhi, India
    MS-Off Ver
    2013
    Posts
    240

    Re: Protection

    Hello,

    Try
    Maintain your records in 1 sheet,
    In other sheet, type the enrolement no. and get the marks through vlookup
    then hide 1 sheet.
    To attach worksheet Go advanced -> Manage attachments -> Choose file -> Upload
    Don't forget to Mention your desired result in the sheet..
    There should be sample data only, a lot of data creates confusion.

    Thanks & Regards

    Shivya
    http://excelvbatipsforbeginners.blogspot.in/
    Reply With QuoteRegister To Reply
  4. 10-26-2017, 03:08 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Protection

    It's a little bit more complicated than that if you really want to prevent students from seeing each others' grades!
    Reply With QuoteRegister To Reply
  5. 10-26-2017, 03:18 AM #5
    jubru
    jubru is offline
    Registered User
    Join Date
    10-26-2017
    Location
    Australia
    MS-Off Ver
    Office for Mac v15
    Posts
    5

    Re: Protection

    Of course, to keep the anonymity I can't use their name, but what if...
    Would it work if I were to actually have a column with their names so that they can locate themselves (out of 650+ rows!!) and then I password protect the remaining columns of their own row. I would use their student ID as the password. It's a fair bit of work to enter the password manually, but would that work?
    thanks
    Reply With QuoteRegister To Reply
  6. 10-26-2017, 03:22 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Protection

    You can't password protect columns and rows natively in Excel - you would need VBA for that. I don't know how easy it would be, but as a teacher myself who uses Excel all the time, I would not entertain it.
    Reply With QuoteRegister To Reply
  7. 10-26-2017, 03:25 AM #7
    jubru
    jubru is offline
    Registered User
    Join Date
    10-26-2017
    Location
    Australia
    MS-Off Ver
    Office for Mac v15
    Posts
    5

    Re: Protection

    bummer #2.
    I think I will revert back to the simple idea, which is no names and student ID. Not the ideal solution, but pretty much the only one I have available by the sound of it.
    thanks for your help and reactivity.
    Reply With QuoteRegister To Reply
  8. 10-26-2017, 03:26 AM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Protection

    Names wouldn't work, anyway, as they are not secure - they all know each others' names!!!

    Keep it simple.
    Reply With QuoteRegister To Reply
  9. 10-26-2017, 03:40 AM #9
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Protection

    Have you considered a mail merge?
    Reply With QuoteRegister To Reply
  10. 10-26-2017, 03:42 AM #10
    jubru
    jubru is offline
    Registered User
    Join Date
    10-26-2017
    Location
    Australia
    MS-Off Ver
    Office for Mac v15
    Posts
    5

    Re: Protection

    I dont even know what that is, so my answer would be no
    Reply With QuoteRegister To Reply
  11. 10-26-2017, 03:45 AM #11
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Protection

    Well, you can create a mail merge from an Excel spreadsheet to a Word document, so in theory you could send each student their own bespoke report.

    Have a look here: https://support.office.com/en-gb/art...b-0a948fa3d7d3
    Reply With QuoteRegister To Reply
  12. 10-26-2017, 03:50 AM #12
    jubru
    jubru is offline
    Registered User
    Join Date
    10-26-2017
    Location
    Australia
    MS-Off Ver
    Office for Mac v15
    Posts
    5

    Re: Protection

    thanks. Interesting feature, but I think I will keep it simple (as you recommended AliGW).
    Reply With QuoteRegister To Reply
  13. 10-26-2017, 03:56 AM #13
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Protection

    Mail merge is simple - it's a hell of a lot simpler than what you asked for here!!!
    Reply With QuoteRegister To Reply
  14. 10-26-2017, 11:48 PM #14
    scottiex
    scottiex is offline
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: Protection

    Be aware that excel is not a secure way of storing data. If you give the students access to the file someone with google skills, a minimal amount of know how and the desire/time will get all your grades despite any passwords you put on it as long as the data is stored in the sheet.

    I'd want to be pressing a button on my side.

    I'd offer a macro but mailmerge has been raised and it probably has you well covered if you give it a go.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Protection of Spreadsheet protection
    By Missions Conseils in forum Excel General
    Replies: 3
    Last Post: 11-22-2012, 12:03 PM
  2. Excel 2010 - Copying sheet with protection manually, protection stays... not with VBA
    By AdamParker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2012, 12:38 PM
  3. Protection
    By sooty86 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2010, 04:01 PM
  4. Semi-Protection Want Hidability AND Protection
    By mbf1999 in forum Excel General
    Replies: 1
    Last Post: 11-17-2007, 01:24 PM
  5. protection
    By fairway John in forum Excel General
    Replies: 1
    Last Post: 02-13-2007, 10:59 AM
  6. [SOLVED] Worksheet protection is gone and only wokbook protection can be se
    By Eric C. in forum Excel General
    Replies: 4
    Last Post: 05-02-2006, 11:55 AM
  7. Protection
    By oberon.black in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2005, 12:00 PM
  8. [SOLVED] Another Protection Q
    By JudithJubilee in forum Excel General
    Replies: 2
    Last Post: 03-04-2005, 02:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1