Advertisement

Modding in Serious Games: Teaching Structured Query Language (SQL) Using NeverWinter Nights

  • Mario SoflanoEmail author
Chapter

Abstract

In recent development of educational technology, Games-based learning (GBL) or Serious Games (SG) has shown its potential to support learning. Compared to eLearning, SG is considered more fun to use because of its interactivity. However, this advantage does not come without a cost that needs to be considered. It is considerably more complex to design an SG application than it is to design an eLearning tool. It involves not only the resources required to design an enjoyable game but also a pedagogical design which can be implemented through the game and is suitable for the efficient delivery of a given subject matter. In eLearning, learning materials constitute the required resources which are then managed and presented by web scripts. However, in SG, the resources include graphical and non-graphical assets of the game as well as the learning materials. The assets can include text, diagram and 2-dimensional (2D) and 3-dimensional (3D) objects. These resources are usually designed according to the story and environment design of the game. The learning content must fit the game story and the environment so the learning content falls within the context of the game. The game also requires an interactive system that allows the player to input, interact and manipulate objects within the game environment. This system usually involves scripting and programming. It is not an easy task to combine all these elements and consequently the development of an SG application requires more time and effort than does one for eLearning. Commercial games are usually developed using complex game engines and tools. Some of the game developer companies have released game engines and tools that allow modification of the original game. The variant of the original game is called a ‘mod’. The ‘mod’ is usually subject to commercial restrictions. However, modding is one of the potential solutions for the SG developers to create an SG application which looks like commercial games in considerably faster way. Since this facility was first introduced, there has been a growing interest in modifying or ‘modding’ commercial games and there are now numerous online communities dedicated to various types of ‘mods’. One of the best-known ‘mods’ tools is NeverWinter Nights 2 (NWN2). The tool has pre-defined graphical assets and basic functions which allow the developer to create a satisfactory 3D RPG game for educational purposes. The NWN2 engine and tool also allow scripting which makes it a flexible resource for the developer to create new functions when required. As an example, a SG application which is used to teach Structured Query Language (SQL) has been developed by the author. SQL is the standard database programming language and it is one of the essential skills required in information technology. In this chapter, the development life cycle of SG and commercial games ‘mod’ tools currently available will be discussed. The chapter will then examine the design and development of an SG application to teach SQL.

Keywords

Games-based learning serious games structured query language SQL neverwinter nights 2 mod development life cycle 

Resources

  1. http://www.getdota.com/: official website of DOTA
  2. http://www.playdota.com/: DOTA community website
  3. http://www.dota-utilities.com/: DOTA community website which provides some DOTA tools
  4. Counter Strike Google Scholar
  5. http://www.valvesoftware.com/: Valve’s official website, the developer of Counter Strike engine
  6. http://store.steampowered.com/app/240/: online gateway for online playing
  7. Neverwinter Nights 2 Google Scholar
  8. http://www.nwn2.com/: NeverWinter Nights 2 official website
  9. http://social.bioware.com/forum/1/subindex/156: new official forum of NeverWinter Nights 2 http://nwn2forums.bioware.com/forums/: discontinued official forum of NeverWinter Nights 2. Although it is no longer active, it is still accessible and it may contains useful information
  10. http://www.unrealengine.com/: official website of Unreal
  11. http://www.udk.com/: official website contains information about unreal development kit
  12. http://www.epicgames.com/: official website of Epic Games, the developer of Unreal engine
  13. http://www.moddb.com/: online portal for game modding. The portal contains showcaase of mods developed from various different games

References

  1. Bethke, E.: Game Development and Production. Wordware Publishing, Plano, TX (2003)Google Scholar
  2. Connolly, T.M., Begg, C.E.: Database Systems: A Practical Approach to Design, Implementation, and Management, 5th edn. Addison-Wesley, Boston, MA (2009)Google Scholar
  3. Connolly, T.M., Stansfield, M.H.: From eLearning to games-based eLearning: Using interactive technologies in teaching an information system course. Int. J. Inf. Technol. Manage. 6(2), 188–208 (2007)Google Scholar
  4. Connolly, T.M., Stansfield, M., Hainey, T.: An Application of Games-based Learning Within Software Engineering, vol. 38, pp. 416–428. Blackwell, Malden, MA (2007)Google Scholar
  5. Hughes, B., Cotterell, M.: Software Project Management, 4th edn. McGraw-Hill, London (2006)Google Scholar
  6. Whitten, N.: Managing Software Development Projects: Formula for Success, 2nd edn. Wiley, New York (1995)Google Scholar

Bibliography

  1. Meigs, T.: Ultimate Game Design: Building Game Worlds. McGraw-Hill, London (2003)Google Scholar
  2. Van Eck, R., Gikas, J.: Analyzing & Designing: Instructional Design Guide. Gaming Theory as a Teaching Tool at All Levels. The University of Memphis, Memphis, TN (2004)Google Scholar

Copyright information

© Springer-Verlag London Limited 2011

Authors and Affiliations

  1. 1.School of ComputingUniversity of the West of ScotlandPaisley, ScotlandUK

Personalised recommendations