Modding in serious games: teaching structured query language (SQL) using neverwinter nights

Mario Soflano

Research output: Chapter in Book/Report/Conference proceedingChapter

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.
Original languageEnglish
Title of host publicationSerious Games and Edutainment Applications
EditorsMinhua Ma, Andreas Oikonomou, Lakhmi C. Jain
Place of PublicationLondon
PublisherSpringer London
Chapter18
Pages347-368
Number of pages22
ISBN (Electronic)9781447121619
ISBN (Print)9781447121602
DOIs
Publication statusPublished - 2011

Fingerprint

Query languages
Teaching
Engines
Serious games
Educational technology
Computer programming languages
Information technology
Life cycle

Keywords

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

Cite this

Soflano, M. (2011). Modding in serious games: teaching structured query language (SQL) using neverwinter nights. In M. Ma, A. Oikonomou, & L. C. Jain (Eds.), Serious Games and Edutainment Applications (pp. 347-368). London: Springer London. https://doi.org/10.1007/978-1-4471-2161-9_18
Soflano, Mario. / Modding in serious games : teaching structured query language (SQL) using neverwinter nights. Serious Games and Edutainment Applications. editor / Minhua Ma ; Andreas Oikonomou ; Lakhmi C. Jain. London : Springer London, 2011. pp. 347-368
@inbook{e61ba720297b4659ba64fe327d9a1d09,
title = "Modding in serious games: teaching structured query language (SQL) using neverwinter nights",
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, development life cycle",
author = "Mario Soflano",
year = "2011",
doi = "10.1007/978-1-4471-2161-9_18",
language = "English",
isbn = "9781447121602",
pages = "347--368",
editor = "Minhua Ma and Andreas Oikonomou and Jain, {Lakhmi C.}",
booktitle = "Serious Games and Edutainment Applications",
publisher = "Springer London",
address = "United Kingdom",

}

Soflano, M 2011, Modding in serious games: teaching structured query language (SQL) using neverwinter nights. in M Ma, A Oikonomou & LC Jain (eds), Serious Games and Edutainment Applications. Springer London, London, pp. 347-368. https://doi.org/10.1007/978-1-4471-2161-9_18

Modding in serious games : teaching structured query language (SQL) using neverwinter nights. / Soflano, Mario.

Serious Games and Edutainment Applications. ed. / Minhua Ma; Andreas Oikonomou; Lakhmi C. Jain. London : Springer London, 2011. p. 347-368.

Research output: Chapter in Book/Report/Conference proceedingChapter

TY - CHAP

T1 - Modding in serious games

T2 - teaching structured query language (SQL) using neverwinter nights

AU - Soflano, Mario

PY - 2011

Y1 - 2011

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

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

KW - Games-based learning

KW - serious games

KW - structured query language

KW - SQL

KW - neverwinter nights 2

KW - development life cycle

UR - https://link.springer.com/content/pdf/bfm%3A978-1-4471-2161-9%2F1.pdf

U2 - 10.1007/978-1-4471-2161-9_18

DO - 10.1007/978-1-4471-2161-9_18

M3 - Chapter

SN - 9781447121602

SP - 347

EP - 368

BT - Serious Games and Edutainment Applications

A2 - Ma, Minhua

A2 - Oikonomou, Andreas

A2 - Jain, Lakhmi C.

PB - Springer London

CY - London

ER -

Soflano M. Modding in serious games: teaching structured query language (SQL) using neverwinter nights. In Ma M, Oikonomou A, Jain LC, editors, Serious Games and Edutainment Applications. London: Springer London. 2011. p. 347-368 https://doi.org/10.1007/978-1-4471-2161-9_18