Re: Student maths practice - check answers, count #correct and more
Guess should have asked you in the first place ...
Would you rather get step-by-step updates, along the way ...
or wait until all the various issues are fixed ...?
Re: Student maths practice - check answers, count #correct and more
Guess should have asked you in the first place ...
Would you rather get step-by-step updates, along the way ...
or wait until all the various issues are fixed ...?
Re: Student maths practice - check answers, count #correct and more
Quote from Carim;799096Guess should have asked you in the first place ...
Would you rather get step-by-step updates, along the way ...
or wait until all the various issues are fixed ...?
I don't mind either way - whatever works best for you.
Thanks - I REALLY do appreciate your generosity.
Re: Student maths practice - check answers, count #correct and more
Looking forward to it, I've been following this thread with interest.
Re: Student maths practice - check answers, count #correct and more
Hello again,
TheGlovner ... Glad if you can find some interest in this thread ...
If you feel like testing ... , and more importantly, commenting on the latest available update ....
You can 'play' with the attached version V2-5 .... you might even find some more improvements to include ... :wink:
Cheers
Re: Student maths practice - check answers, count #correct and more
Quote from Carim;799122Display MoreHello again,
TheGlovner ... Glad if you can find some interest in this thread ...
If you feel like testing ... , and more importantly, commenting on the latest available update ....
You can 'play' with the attached version V2-5 .... you might even find some more improvements to include ... :wink:
Cheers
Wow! Looking and working well. VERY close now (says the man who has no idea of how much coding is required to finish off four wish list items!)
I have added comments to the file and called it Ver2-5.1
Briefly - hoping:
Thank you again for the work you have done.
I would be grateful if you have the time and inclination to fix those ----- when you have the time and energy and interest.
Re: Student maths practice - check answers, count #correct and more
Hello,
Thanks for the 'new' comments ... :smile:
Regarding the 14 inch screen size you mentioned earlier, my interpretation was that it would be good to get rid of all headings, rows, columns, ribbon, etc ... for the students' comfort
But, since you do want it, have just removed it ...
Slowly but surely ... :smash:
Attached is the latest Version V2-6 ...
Hopefully, it should include all the fixes to all the questions you have already raised ...
However ... in terms of 'still pending issues', there is the tricky '5 second limit' which still needs to be coded ...
Feel free to comment on this Version 2-6 ... :wink:
Cheers
Re: Student maths practice - check answers, count #correct and more
Quote from Carim;799199Display MoreHello,
Thanks for the 'new' comments ... :smile:
Regarding the 14 inch screen size you mentioned earlier, my interpretation was that it would be good to get rid of all headings, rows, columns, ribbon, etc ... for the students' comfort
But, since you do want it, have just removed it ...Slowly but surely ... :smash:
Attached is the latest Version V2-6 ...
Hopefully, it should include all the fixes to all the questions you have already raised ...
However ... in terms of 'still pending issues', there is the tricky '5 second limit' which still needs to be coded ...
Feel free to comment on this Version 2-6 ... :wink:
Cheers
NAILED IT!!!!!!!!!!!!!
Love the zoom size option!!!!
Love the summary dialogue box at the end of the test!!!
I just have two comments (have added them to the file Ver2-6.1)
Essentially:
You have accomplished everything I had on my wish list - and there was NO WAY I could have ever done this.
THANK YOU ... THANK YOU!
I don't care about the 5 second time limit - it was a suggestion by a colleague. If it was straight-forward to do then great ... but I'm delighted with its functionality now so don't bother with that. I can't tell you how much this will make a difference to so many of my students!
I will be able to lock cells and hide sheets now so that it is student ready.
I was hoping you would agree to putting a note on the first sheet to show you did the coding.
eg "Thank you to xxxxxxxx from http://www.ozgrid.com forums without whom this
Re: Student maths practice - check answers, count #correct and more
Great ... :smile:
Very pleased ... to hear that YOU are pleased ... :wink:
Attached is the Version V2-7 ... with the last couple of required fixes ...
Regarding what you are planning to do next :
Yes, you can hide sheets ... but beware of the fact that locking cells might totally disrupt some of the automated processes ...
Besides, you should not worry too much about protection against wrong handlings ... since, as soon as you click Start, ... all formulas are reinstated ... (and you will
retain an original copy ...)
Hope you and your students will enjoy this tiny program ...!!! :smile:
P.S. Obviously, you should not hesitate to come back to the Forum ... in case of need ...
It has been a real pleasure for me to help out a truly Unique Teacher who sincerely cares about his Students ...!!! :yourock:
Re: Student maths practice - check answers, count #correct and more
Quote from Carim;799233Display MoreGreat ... :smile:
Very pleased ... to hear that YOU are pleased ... :wink:
Attached is the Version V2-7 ... with the last couple of required fixes ...
Regarding what you are planning to do next :
Yes, you can hide sheets ... but beware of the fact that locking cells might totally disrupt some of the automated processes ...
Besides, you should not worry too much about protection against wrong handlings ... since, as soon as you click Start, ... all formulas are reinstated ... (and you will
retain an original copy ...)Hope you and your students will enjoy this tiny program ...!!! :smile:
P.S. Obviously, you should not hesitate to come back to the Forum ... in case of need ...
It has been a real pleasure for me to help out a truly Unique Teacher who sincerely cares about his Students ...!!! :yourock:
I don't really now how to thank you enough!!!! :rock::rock::rock::rock:
This is even better than I had imagined in my head as I began this!
Yes I will hide the other sheets and forget about locking cells.
Because of you and your generosity/skill, there will be a whole bunch of students who will enthusiastically engage with their maths basic facts learning again.
This will give them more confidence to tackle other topics in maths as they won't be struggling as much with the minor computations.
I can see the students setting targets and goals as they work their way through the different operations and complexity.
I can't wait to show the students and get them to "play"!
May good karma follow you and pay you back for the wonderful thing you have done for me and my students.
If you ever come to South Australia - get in touch - I owe you plenty!!!!:thanx:
Food, local wines (or the beverage of your choice), a bed and a tour!!
ABSOLUTELY BRILLIANT - I am over the moon about this!!!
:ole:
Re: Student maths practice - check answers, count #correct and more
MANY MANY THANKS for all your VERY KIND WORDS .... :flower:
For sure ... Australia ... One of my biggest dreams ... !!! :dolphin:
People are SOOOOO Friendly down under ... :smile: :smile: :smile:
Meanwhile, let me congratulate you for taking with as much Passion the future of your Students ....
Hopefully, some day, they will realize the chance they had to have a Teacher like You ...!!!
All th Best ....
Re: Student maths practice - check answers, count #correct and more
Oh Carim - I'm so sorry to bother you again
It looks as though Ver2-7 has a bug.
Every problem is an addition problem - no matter what the operation in B3 is selected.
Everything was fine up and including Ver2-6.
I have attached both files just in case you deleted them.
Wondering if you might find the time and energy to have a look sometime.
Many thanks
Ace
Re: Student maths practice - check answers, count #correct and more
Hello Ace, :smile:
Attached is the version V2.8 .... with a fix related to selecting the correct operation sign ...
Should you need a little bit of background ...
By inserting a couple of new columns in the 'drop_down_lists' worksheet, to account for the 'Number of Questions' validation list ...the cell K11 in the worksheet 'Test' was impacted ... and stopped producing the correct operation sign ...
In this latest version V2-8, the formula in cell K11 has been corrected ... and you can obviously review it ...
As a consequence, to make your review easier, and in order to avoid future similar problems ... have quickly added a new choice for your 'Random Data Columns' to be displayed or not.
Hope this explanation is clear enough ...
Keep on testing ...you might find new bugs .... :wink:
Cheers
:smile:
Re: Student maths practice - check answers, count #correct and more
Quote from Carim;799306Display MoreHello Ace, :smile:
Attached is the version V2.8 .... with a fix related to selecting the correct operation sign ...
Should you need a little bit of background ...
By inserting a couple of new columns in the 'drop_down_lists' worksheet, to account for the 'Number of Questions' validation list ...the cell K11 in the worksheet 'Test' was impacted ... and stopped producing the correct operation sign ...
In this latest version V2-8, the formula in cell K11 has been corrected ... and you can obviously review it ...
As a consequence, to make your review easier, and in order to avoid future similar problems ... have quickly added a new choice for your 'Random Data Columns' to be displayed or not.
Hope this explanation is clear enough ...
Keep on testing ...you might find new bugs .... :wink:
Cheers
:smile:
PERFECT! Looks like everything is as expected.
Much appreciated.
Thank you for tracking down the problem so quickly ... and adding the new choice.
I showed my Principal what you were able to achieve and she was excited!
Whoo hoo!!!
:congrats:
I have added a little footer that includes your Forum name and "ozgrid.com"
Hope you have a wonderful weekend and you get a chance to relax!
Re: Student maths practice - check answers, count #correct and more
Glad this problem is now over ...:wink:
Do not worry about adding any sort of 'credit' to your spreadsheet ... since YOU are the true architect of the Quiz ....!!!
You just needed some assistance in the 'macro translation' ...
Have a Very Nice Week-End too ...!!! :smile:
( I should also say : "Good Night" ...!!!)
Don’t have an account yet? Register yourself now and be a part of our community!