Hi Ryan,
Re: "being able to goto some website pick a game and drop it into moodle. and have it interact with moodle."
-- Adding activities to Moodle and having Moodle record learners' interactions with them, e.g. duration, grades, and/or generated artifacts, requires some kind of wrapper module that can act as an interface, capturing the data output from the 3rd party activity and then translating it into something that Moodle can use. The usual sequence for activity modules is:
- Teacher creates an activity instance and configures it. I this case to deploy a 3rd party learning interaction.
- Instance creates a grade item in Moodle's grade book.
- The learner uses the activity instance, generating data.
- Moodle logs record that the learner has accessed the instance as well as other salient usage data (for tracking purposes). The activity module developer must explicitly write the code to inform Moodle about users' activities for the logs, so this can be as detailed or sparse as you like.
- The learner's activity may generate some learning outcomes/assessment data. This must be captured by the wrapper activity module and sent to Moodle's back end, where it can be "translated" into suitable data to put into Moodle's grade book and/or other database tables.
In order for 5. to work, you need to know exactly how the 3rd party activity works and what the output data from it is, what format it's in, and what it means. This is why many wrapper activity modules for 3rd party apps are for one particular app or set of apps only. The only general activity module that is standardised to accept a wide range of learning activities is the SCORM module. However, all 3rd party activities must be SCORM compliant and the output/generated content and artifacts must conform to the SCORM specification, which was designed many years ago in the "bad old days" of test-oriented elearning for the military.
The Moodle Scratch filter doesn't integrate the Scratch Java applets with Moodle's back end, as far as I know. It's also no longer supported past Moodle 2.2. Poodl (suite of modules), NanoGong, and SWF Activity Module are supported and do provide integration with Moodle.
I hope this helps!