Game Logic in Moodle Skill Tree research

Skill tree in games vs in moodle and learning / teaching.

when you go and sign up for collage class. you might have some sort of prerequisites / requirements before able to join a give course/class example needing to take history 101, English 102, math 103, before getting into history 203 in a sense the collage has a "course tree" were different things are required / suggested to have before you can get into a given course. some times have worked in X field / job for so long counts as a fulfillment of getting into a course.

so how should a skill tree in moodle work?

tree

should there be a strict tree base with leaf-lets. main branch -> then each sub branch -> and another sub branch -> eventally getting to a leaf much like a bullet list

main branch
1. sub branch
  1. yet another sub branch
    1. yet another sub branch
      1. yet another sub branch
        yet another sub branch
        evetntally getting to a leaf
2. yet another sub branch
  1. yet another sub branch
    1. evetntally getting to a leaf

OR

one to many and many to one

((see below picture)) CLICK HERE to edit flow chart

in above flow chart. it would seem you would need to learn reading, print, cursive, typing, oral, of letters A and D, and build yourself up to the word ADD, before you begin to learn how to actual learn MATH -> ADD (skill)

one to many and many to one, taking things further

the skill tree is getting rather complex rather fast.

Database

database -> table (skills) -> fields....

id
name = human understandable name
description = short description
from = what links to it (arrows pointing to it in flow chart)
to = what links go from it (arrows coming from it and pointing to something else)

errr ya.. be careful last 2 notations above with to/from in describing the field (doh!) i would imagine "from" and "to" fields being a comma delineated array?

Database 2 idea

get a list of words, say open source dictionary. it should have A-Z letters, a-z letters, 0-9 numbers, a list of symbols ( !@#$%^&*() etc..), and then a full list of words.
if the word has multi spellings, say plural form of the word. example: home and homes, then multi spellings need to be listed individually. and then reconnected with "plural" skill, or car's vs car connected via "language -> english -> *grammar rules ->Possessive" skill
possibly linking "name" field in database with word in dictionarary, and "description" field in database with definition in dictionarary, taking it step further, linking to how to pronounce the word, with "language -> english -> oral" skill.
- i do not know about this idea.linking extra things into skill database. i guess it will already be there for "oral" skill. *shakes head back and forth* ya, lets keep it.

if i know words, and grammar rules student knows. then i could search across a "book" for all words in it. and see if it is within students reading level.

education AI & suggesting books based on reading level

upload book to moodle. say pdf, html, txt file. what ever it maybe.
once upload, run a cron job on it. to search entire book for all words in it, and make a list of those words within the book.
that should make it "quicker" for taking a person reading level (words known, grammar rules) and the list made above. and see how many words student does or does not know in book. more words student does not know = higher difficulty for student.

programming & multiskill database table = no

already see were this is going. "machine learning" or rather artificial learning, or rather robot learning to talk. in order to gain various programming scripts. that reduce overall database size, and increases performance. though i am having hard time crunching stuff down. due to Kindergarten through say 6th grade. were i would assume this database would be better more bloated. and server as a better performance. the issue will be getting into highschool and collage. and needing to reduce things. i guess i could do a... database -> table (multiskill) -> fields...

id
name = human readable name
description = short description
from = what links to it (arrows pointing to it in flow chart)
to = what links go from it (arrows coming from it and pointing to something else)
multi = collection of skills

education AI looks at "multiskill" table first, and then looks at "skills" table second. that does not really work either...

programming & database = lots of individual tables

i need to tag... MAIN skills in the flow chart "language, english, dutch, spanish, writing, oral, print, cursive, math, add, subtract, divide" and then divide them up i guess based on "elementry school, miiddle school, highschool, collage" and assign say grade 1, grade 2, etc... and then go into individual linking to letters, words, numbers, etc..

scratch out above paragraph... each core subject (math, science, history, etc..) has it's own individual database table. languages (enlgish, dutch, spanish, etc..) has there own individual database tables. a multiskill database table. the is more of a central database table linking all the other database tables together. i am saying database tables. due to i honesty do know core subjects. it may be possible to write a smaller set of "programming scripts" that could take place of a database table. in certain areas, to gain a performance boost.

ending here for now.. i tempted to leave above database / programming information vs moving it to another page. to give idea of how interwoven skill tree / paths are with rest of overall system.

Documentation