Navegando por Assunto "SQL"

Agora exibindo 1 - 2 de 2

Acesso aberto (Open Access)
IETS: Ferramenta interativa de ensino de SQL
(Universidade Federal do Pará, 2006-03-24) FREIRE, José Antônio Sarmanho dos Santos; FAVERO, Eloi Luiz; http://lattes.cnpq.br/1497269209026542
This work considers a tool in the Web for programming teaching. The work is based on a study of case for teaching of the programming language of data bases SQL and is inserted in the context of an interactive environment of learning. This experimental tool for teaching of programming languages, presents as objective: 1) complete integration between the teaching of concepts of programming with example of fragments of executable programs on line; 2) integration with a component of evaluation of programs verifying it the reply of the learner is the same one of the teacher; 3) complete control of the learner´s activities (how many examples had been executed; in each exercise, how many execution attempts had been made, etc). 4) to serve as a laboratory for experimentation of tow new techniques of evaluation and accompaniment, that are being searched in works in parallel: (a) automatic evaluation of metric programs with of software engineering , allowing informing how much the solution of the student if approaches to a “ideal solution”; e (b) automatic evaluation of discursive conceptual questions, besides allowing the traditional objective questions. This work is a first step in the direction of construction of an environment total attended (for example with automatic evaluation) for teaching of the programming language SQL, where the teacher will have a minimum load of work, more as supervisor.
Acesso aberto (Open Access)
LABSQL: laboratório de ensino de SQL
(Universidade Federal do Pará, 2007-12-19) LINO, Adriano Del Pino; FAVERO, Eloi Luiz; http://lattes.cnpq.br/1497269209026542
This work presents a new approach for automatic evaluation of SQL queries. This approach proposes a solution for a challenge to stimulate the student to improve his/her solution: searching, besides an answer that returns a correct result, a query with a complexity next to the optimum solution. This proposal can be used in e-learning environments or in presential education in laboratory activities, including the evaluations. The proposed solution has as advantages: (1) the student receives an instantaneous feedback during a practice programming activity, which allows the student to refactorize his/her solution in direction to a optimum solution; (2) complete integration between the programming concepts teaching with examples of fragments of on-line executable programs; (3) monitoring of students activities (how many examples were executed; in each exercise how many execution attempts were done, etc). This work is the first pass in direction to the construction of an environment, totally attended (for example with automatic evaluation) for teaching of SQL programming language, where the instructor is free of the hard work to correct SQL commands, being able to do more relevant pedagogic tasks. The method, based on statistics and Software Engineering metrics, can be adapted for other languages, such as Java and Pascal. In addition, the LabSQL serves as a laboratory for experimentation of two news techniques, one of evaluation and other of accompaniments that are being searched in several works at the same time: (a) automatic evaluation of discursive conceptual questions, besides to allow the traditional objective questions, (b) method of accompaniment through a montage of evaluation rubrics.