Hello. I appreciate any help on this.
I would like to set up a "teaching" database that will display a set of related images together in random order, and require the user to put the images in correct order. I was able to accomplish this (strenuously - what a mess all the hidden columns and rows are... and the macro - ugh!) with sentence text in Excel, where the user was shown a list of words in random order and had to put the sentence together correctly. For example, they might be given "going we the like zoo to" and they have to rebuild "we like going to the zoo". But, I'd like to do the same with images, so that the user would have to recreate a story from the images, to show their understanding. The only (fallback position) option I've been able to come up with is in Excel, where on each tab I'd have the (numbered) images in the wrong order on the screen and the user has to enter the the numeric values in a string into a certain cell which has conditional formatting attached for right and wrong based on the correct string.
For the images version of this idea, I see a number of challenges. First, how do I store images in such a way that the database knows they are related? Second, how do I retrieve them then display them in a form in random order? Third, how do I verify that the user gets the answer correct?
I don't know if this is even possible, so any direction is appreciated. THANKS!
I would like to set up a "teaching" database that will display a set of related images together in random order, and require the user to put the images in correct order. I was able to accomplish this (strenuously - what a mess all the hidden columns and rows are... and the macro - ugh!) with sentence text in Excel, where the user was shown a list of words in random order and had to put the sentence together correctly. For example, they might be given "going we the like zoo to" and they have to rebuild "we like going to the zoo". But, I'd like to do the same with images, so that the user would have to recreate a story from the images, to show their understanding. The only (fallback position) option I've been able to come up with is in Excel, where on each tab I'd have the (numbered) images in the wrong order on the screen and the user has to enter the the numeric values in a string into a certain cell which has conditional formatting attached for right and wrong based on the correct string.
For the images version of this idea, I see a number of challenges. First, how do I store images in such a way that the database knows they are related? Second, how do I retrieve them then display them in a form in random order? Third, how do I verify that the user gets the answer correct?
I don't know if this is even possible, so any direction is appreciated. THANKS!
