Personal Access Tutor - helping students to learn MS Access

The paper describes Personal Access Tutor (PAT),an Intelligent Tutoring System which helps students to learn how to create forms and reports in MS Access. We present the architecture and components of PAT and also the services that PAT provides to the students. Results for an external (system) evaluation of PAT (both qualitative and quantitative data) are presented and discussed.

Base de dades MS Access 2000. 'Base de datos MS Access 2000'.

Resumen tomado de la publicación. Incluye imágenes de capturas de pantalla del programa y archivos complementarios para la realización de las prácticas

WEPA: Wind energy potential assessment-spatial decision support system

Spatial Decision Support System (SDSS) assist in strategic decision-making activities considering spatial and temporal variables, which help in Regional planning. WEPA is a SDSS designed for assessment of wind potential spatially. A wind energy system transforms the kinetic energy of the wind into mechanical or electrical energy that can be harnessed for practical use. Wind energy can diversify the economies of rural communities, adding to the tax base and providing new types of income. Wind turbines can add a new source of property value in rural areas that have a hard time attracting new industry. Wind speed is extremely important parameter for assessing the amount of energy a wind turbine can convert to electricity: The energy content of the wind varies with the cube (the third power) of the average wind speed. Estimation of the wind power potential for a site is the most important requirement for selecting a site for the installation of a wind electric generator and evaluating projects in economic terms. It is based on data of the wind frequency distribution at the site, which are collected from a meteorological mast consisting of wind anemometer and a wind vane and spatial parameters (like area available for setting up wind farm, landscape, etc.). The wind resource is governed by the climatology of the region concerned and has large variability with reference to space (spatial expanse) and time (season) at any fixed location. Hence the need to conduct wind resource surveys and spatial analysis constitute vital components in programs for exploiting wind energy. SDSS for assessing wind potential of a region / location is designed with user friendly GUI’s (Graphic User Interface) using VB as front end with MS Access database (backend). Validation and pilot testing of WEPA SDSS has been done with the data collected for 45 locations in Karnataka based on primary data at selected locations and data collected from the meteorological observatories of the India Meteorological Department (IMD). Wind energy and its characteristics have been analysed for these locations to generate user-friendly reports and spatial maps. Energy Pattern Factor (EPF) and Power Densities are computed for sites with hourly wind data. With the knowledge of EPF and mean wind speed, mean power density is computed for the locations with only monthly data. Wind energy conversion systems would be most effective in these locations during May to August. The analyses show that coastal and dry arid zones in Karnataka have good wind potential, which if exploited would help local industries, coconut and areca plantations, and agriculture. Pre-monsoon availability of wind energy would help in irrigating these orchards, making wind energy a desirable alternative.

A database for the industrial trawl fishery of Cote d'Ivoire

Fishery statistics for the industrial trawl fishery of Cote d'Ivoire have been well documented since 1968. However, data processing has changed significantly with time and some of the data files have been lost. In 1997, the Centre de Recherches Oceanologiques d'Abidjan decided to retrieve and process all trawl data available from different sources. This paper gives an overview of the database covering the period 1968 to 1997 and describes its coverage, format, structure and use. The database was developed using MS ACCESS and is a powerful tool for storing information about this fishery, and for analysis of its dynamics over a period of 30 years.

Handheld-assisted field data collection for occupational risk assessment.

A computerized handheld procedure is presented in this paper. It is intended as a database complementary tool, to enhance prospective risk analysis in the field of occupational health. The Pendragon forms software (version 3.2) has been used to implement acquisition procedures on Personal Digital Assistants (PDAs) and to transfer data to a computer in an MS-Access format. The data acquisition strategy proposed relies on the risk assessment method practiced at the Institute of Occupational Health Sciences (IST). It involves the use of a systematic hazard list and semi-quantitative risk assessment scales. A set of 7 modular forms has been developed to cover the basic need of field audits. Despite the minor drawbacks observed, the results obtained so far show that handhelds are adequate to support field risk assessment and follow-up activities. Further improvements must still be made in order to increase the tool effectiveness and field adequacy.

Sistema de Información Geográfica de las Áreas Industriales de Tenerife (SIGAIT)

El Servicio Técnico de Innovación y Desarrollo de Proyectos del Cabildo Insular de Tenerife divulga periódicamente la información de las zonas industriales mediante el Catálogo de Áreas industriales de Tenerife. Hasta el año 2008, este Catálogo, con la información de cada una de las 94 zonas industriales y compuesto de más de 100 atributos temáticos y un total de más de 3000 registros, se gestionaba mediante una base de datos MS Access y archivos shp con información espacial exhaustiva (parcelas, equipamientos, infraestructuras, etc.). Los usuarios accedían a la información espacial mediante un SIG que permitía relacionar la información espacial con la temática. El empleo continuo del sistema ha creado nuevas necesidades como multiusuario, seguridad de datos, GUI más sencillo y amigable, integración en la IDE, etc. En consecuencia, el Cabildo ha puesto en marcha un proyecto para la modernización del sistema que pretende aumentar la cantidad y calidad de la información y optimizar los flujos de trabajo relacionados. Se orienta inicialmente al público en general, pero, por su contenido más especializado y técnico, hace que el enfoque de la información vaya dirigido además hacia los técnicos de las administraciones locales así como hacia los promotores industriales privados. Herramientas como la consulta de empresas que desarrollan sus actividades en esos ámbitos, su tipología y la impresión de informes hacen accesible la información industrial a una amplia gama de usuarios. Desde el punto de vista técnico, el sistema se compone del SGBD espacial PostGIS. Los servicios web abiertos OGC (WMS, WFS) se implementan con Mapserver. El Geoportal basa en openlayers, extjs y hslayers. La arquitectura está orientada a servicios y los componentes del sistema son conforme con los principios de INSPIRE. La integración en la IDE se realiza mediante el registro de los metadatos de los servicios y datos en el catálogo la IDE del Cabildo (TeIDE)

Steel Sheet Applications and Integrated Heat Management

Increasing energy use has caused many environmental problems including global warming. Energy use is growing rapidly in developing countries and surprisingly a remarkable portion of it is associated with consumed energy to keep the temperature comfortable inside the buildings. Therefore, identifying renewable technologies for cooling and heating is essential. This study introduced applications of steel sheets integrated into the buildings to save energy based on existing technologies. In addition, the proposed application was found to have a considerable chance of market success. Also, satisfying energy needs for space heating and cooling in a single room by using one of the selected applications in different Köppen climate classes was investigated to estimate which climates have a proper potential for benefiting from the application. This study included three independent parts and the results related to each part have been used in the next part. The first part recognizes six different technologies through literature review including Cool Roof, Solar Chimney, Steel Cladding of Building, Night Radiative Cooling, Elastomer Metal Absorber, and Solar Distillation. The second part evaluated the application of different technologies by gathering the experts’ ideas via performing a Delphi method. The results showed that the Solar Chimney has a proper chance for the market. The third part simulated both a solar chimney and a solar chimney with evaporation which were connected to a single well insulated room with a considerable thermal mass. The combination was simulated as a system to estimate the possibility of satisfying cooling needs and heating needs in different climate classes. A Trombe-wall was selected as a sample design for the Solar Chimney and was simulated in different climates. The results implied that the solar chimney had the capability of reducing the cooling needs more than 25% in all of the studied locations and 100% in some locations with dry or temperate climate such as Mashhad, Madrid, and Istanbul. It was also observed that the heating needs were satisfied more than 50% in all of the studied locations, even for the continental climate such as Stockholm and 100% in most locations with a dry climate. Therefore, the Solar Chimney reduces energy use, saves environment resources, and it is a cost effective application. Furthermore, it saves the equipment costs in many locations. All the results mentioned above make the solar chimney a very practical and attractive tool for a wide range of climates.

Vantagem competitiva: análise teórica e metodologia

Este relatório faz uma análise teórica das diversas correntes em estratégia empresarial sobre a questão da vantagem competitiva. A análise aqui apresentada se fundamenta em um modelo bidimensional que classifica as teorias de estratégia em quatro grupos: (1) Análise de Indústria, (2) Processo de Mercado, (3) Teoria dos Recursos e (4) Competências Dinâmicas. As noções de vantagem competitiva inerentes a cada visão são descritas e comparadas. Uma segunda secção apresenta os resultados de uma análise visando selecionar um conjunto de empresas brasileiras de alto desempenho, e um grupo de controle a partir do cálculo do retorno médio sobre o patrimônio líquido. Uma base dados em MS Access é parte integrante deste relatório.

Proposta de um dicionário eletrônico terminológico onomasiológico bilíngue inglês-português no domínio das redes neurais artificiais

Pós-graduação em Estudos Linguísticos - IBILCE

Elaboração de um dicionário terminológico onomasiológico dos neônimos da biotecnologia: tratamento dos dados em português e busca de equivalentes em inglês

Pós-graduação em Estudos Linguísticos - IBILCE

Aprendizaje integrado de software para producción de buques

Una alta productividad en Ingeniería está asociada entre otras cosas a una gestión eficiente del flujo de las enormes cantidades de información y correspondientes tomas de decisiones consubstanciales a los entornos de diseño y producción. Ello exige que nuestros titulados estén formados para ser capaces de manejar esa información de modo integrado, a través de los diferentes estadios en que se genera y procesa. En el contexto de la enseñanza de la Ingeniería existen un buen número de cursos designados a desarrollar competencias específicas, como las requeridas en los currículos académicos, pero muy pocos en los cuales las competencias de integración sean el objetivo principal. En este artículo se documenta una asignatura que tiene esa orientación, con la intención de alimentar el debate sobre la formación, tan necesario en tiempos de fuerte contracción de la actividad económica como el que vivimos en la actualidad y que está promoviendo el COIN. La asignatura se denomina “Tecnologías de la Información Aplicadas a la Construcción Naval” y es impartida en la titulación de Ingeniero Naval y Oceánico, plan 2002, de la Universidad Politécnica de Madrid (UPM). La primera parte de la asignatura está dedicada a la planificación y gestión de proyectos; los estudiantes adquieren competencias en la definición, usando Ms-PROJECT, de la estructura de descomposición de tareas y la asignación de recursos así como en el seguimiento de proyectos, a través de una serie de ejemplos de complejidad creciente, finalizando con la construcción de un buque. La segunda parte está dedicada al uso de un gestor de bases de datos, Ms-ACCESS, y orientada a la gestión de la información relativa a Producción. Otra vez la estrategia pasa por trabajar sobre una serie de ejemplos de complejidad creciente y se finaliza con la administración de una base de datos de tuberías de un buque, para las cuales se establecen hitos de producción, recepción y montaje, lo que conecta está parte con la primera. Finalmente, la tercera parte de la asignatura está dedicada al trabajo con FORAN, con el cual se definen con detalle los elementos estructurales de todo el buque sobre el que se ha elaborado la planificación. En esta parte, el trabajo es cooperativo, dado que los estudiantes operan simultáneamente en el mismo modelo 3D. Las clases se realizan en un aula multimedia en la cual cada estudiante puede utilizar todas las aplicaciones de software tratadas. Se han realizado encuestas a los estudiantes para obtener una retroalimentación desde su experiencia así como para hacer una valoración de su satisfacción con el proceso de aprendizaje. Los resultados de esas encuestas son discutidos en el artículo.

Integrated learning of computer applications for production engineering

A high productivity rate in Engineering is related to an efficient management of the flow of the large quantities of information and associated decision making activities that are consubstantial to the Engineering processes both in design and production contexts. Dealing with such problems from an integrated point of view and mimicking real scenarios is not given much attention in Engineering degrees. In the context of Engineering Education, there are a number of courses designed for developing specific competencies, as required by the academic curricula, but not that many in which integration competencies are the main target. In this paper, a course devoted to that aim is discussed. The course is taught in a Marine Engineering degree but the philosophy could be used in any Engineering field. All the lessons are given in a computer room in which every student can use each all the treated software applications. The first part of the course is dedicated to Project Management: the students acquire skills in defining, using Ms-PROJECT, the work breakdown structure (WBS), and the organization breakdown structure (OBS) in Engineering projects, through a series of examples of increasing complexity, ending up with the case of vessel construction. The second part of the course is dedicated to the use of a database manager, Ms-ACCESS, for managing production related information. A series of increasing complexity examples is treated ending up with the management of the pipe database of a real vessel. This database consists of a few thousand of pipes, for which a production timing frame is defined, which connects this part of the course with the first one. Finally, the third part of the course is devoted to the work with FORAN, an Engineering Production package of widespread use in the shipbuilding industry. With this package, the frames and plates where all the outfitting will be carried out are defined through cooperative work by the studens, working simultaneously in the same 3D model. In the paper, specific details about the learning process are given. Surveys have been posed to the students in order to get feed-back from their experience as well as to assess their satisfaction with the learning process. Results from these surveys are discussed in the paper

Integrated learning of production engineering software applications in a shipbuilding context

Acourse focused on the acquisition of integration competencies in ship production engineering, organized in collaboration with selected industry partners, is presented in this paper. The first part of the course is dedicated to Project Management: the students acquire skills in defining, using MS-PROJECT, the work breakdown structure (WBS), and the organization breakdown structure (OBS) in Engineering projects, through a series of examples of increasing complexity with the final one being the construction planning of a vessel. The second part of the course is dedicated to the use of a database manager, MS-ACCESS, in managing production related information.Aseries of increasing complexity examples is treated, the final one being the management of the piping database of a real vessel. This database consists of several thousand pipes, for which a production timing frame is defined connecting this part of the course with the first one. Finally, the third part of the course is devoted to working withFORAN,an Engineering Production application developed bySENERand widely used in the shipbuilding industry. With this application, the structural elements where all the outfittings will be located are defined through cooperative work by the students, working simultaneously in the same 3D model. In this paper, specific details about the learning process are given. Surveys have been posed to the students in order to get feedback from their experience as well as to assess their satisfaction with the learning process, compared to more traditional ones. Results from these surveys are discussed in the paper.

ISRIC-WISE - Global Soil Profile Data (ver. 3.1)

Version 3.1 of the ISRIC-WISE database holds selected site and horizon data for some 10 250 soil profiles from 149 countries. Profile data were extracted from a wide range of sources and harmonized with respect to the original (1974) and revised (1988) Legend of the FAO-Unesco Soil Map of the World. Profiles have been described, sampled, and analysed according to methods and standards in use in the originating countries; analytical results for the same property cannot always be compared directly; as a result the amount of measured data available for modelling is sometimes much less than expected. WISE was specifically developed for land-related applications at continental and global scales.

Dynamic job quoting system for printed circuit board fabrication

This research deals with the development of a dynamic job quotation system for printed circuit board (PCB) fabrication, which can estimate the price and completion time of a job based on customer preference and current capacity of the shop floor. The primary purpose of building a dynamic quotation system is to maximize the company's profit by quoting optimum lead-time and competitive price for the day-to-day orders received from different customers and original equipment manufacturers. The system was developed using MS-Access relational database. Evaluating the output of the system it was observed that the dynamic system provided more reliable estimation of the lead-time needed for fabricating new jobs. The overall price quoted by the system was competitive with higher profit margin when compared to traditional static systems. This system would therefore provide a vital link between the job quoting and scheduling system of the firm enabling better utilization of the available resources.