Student maths practice - check answers, count #correct and more

  • 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 ...?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • Re: Student maths practice - check answers, count #correct and more


    Quote from Carim;799096

    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 ...?


    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


    Hello again,


    TheGlovner ... Glad if you can find some interest in this thread ...


    AceCo,


    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



    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:


    • The default settings can be altered from the current ones
    • The default viewing size can be changed from current 158%
    • The quiz stops when number of questions selected has been reached.
    • Once the quiz ends - a summary is shown (Total questions / No. correct / No wrong)
    • I don't know how to make the ... ribbon/row nos/column letters ... visible on the Test sheet



    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



    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:

    • I'm getting an "Update Links?" dialogue box when I open the file
    • "my interpretation was that it would be good to get rid of all headings, rows, columns, ribbon, etc ... for the students' comfort"
      I agree with you - that is what I want too. But I obviously wasn't clear in my last feedback. I wanted a way for ME to turn the visibilty of these on and off for making adjustments. I was just asking how I could do that so that I (not the students) could see them or not. Sorry



    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




    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 ....

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • 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




    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" ...!!!)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)