Aplicación web para Ayuntamiento de Las Palmas de Gran Canaria : [Parte A]

[ES] Este Trabajo de Fin de Grado es un servicio basado en tecnologías web (PHP, HTML5, CSS, JQUERY y AJAX). El objetivo principal es ofrecer un servicio de creación y gestión de actas para el Ayuntamiento de Las Palmas de Gran Canaria. Para ello, consta de dos módulos principales, uno para “crear actas” y otro para “editar actas”. La aplicación consta de dos partes. Una primera parte desarrollada por mí, que consiste en primer lugar en todas las reuniones que fueron necesarias con el personal del Ayuntamiento de Las Palmas de Gran Canaria para entender sus necesidades y cómo poder afrontarlas como desarrollador. Y en segundo lugar, me he encargado de la elaboración y la estructura de la página web, mediante la generación de los distintos ficheros con contenido  HTML, en la interconexión de estos ficheros y en el paso de parámetros entre dichos ficheros mediante las distintas herramientas (JQUERY, AJAX), así como también he dotado a la web de todo el contenido JavaScript necesario. En este apartado también se encuentra la tarea de realizar un módulo de búsqueda y un módulo para mostrar las actas ya acabadas. El de búsqueda contiene un formulario con un campo de búsqueda y busca las coincidencias dentro de todos los ficheros que se han generado con la aplicación. También muestra un link para abrir ese fichero desde el navegador. Como aportación adicional también me he encargado de la configuración y generación de las tablas necesarias de la base de datos para el funcionamiento de la aplicación.

Un applicativo Web con tecnologia single-page AJAX, servizi REST e grafica X3D, per la configurazione di modelli CAD tridimensionali

In questa tesi è stato realizzato un sistema web-based, per la configurazione di modelli meccanici tridimensionali. L’intero software è basato su architettura multi-tier. Il back-end espone servizi RESTful che permettono l’interrogazione di una base di dati contenente l’anagrafica dei modelli e l’interazione con il CAD 3D SolidWorks. Il front-end è rappresentato da due pagine HTML ideate come SPA (Single Page Application), una per l’amministratore e l’altra per l’utente finale; esse sono responsabili delle chiamate asincrone verso i servizi, dell’aggiornamento automatico dell’interfaccia e dell’interazione con immagini tridimensionali.

Progettazione di un'applicazione web-oriented per la gestione di un sistema informativo aziendale

L’azienda committente vuole ampliare la possibilità di accedere al suo database, sia dall’esterno che dall’interno, non solamente da parte di un unico utente amministratore, ma anche da tutti gli agenti distribuiti sul territorio nazionale e tutti gli impiegati degli uffici. Si vuole inoltre creare un sistema di notifiche via email che permetta a tutti gli utenti (agenti) registrati di avere in tempo reale informazioni sempre aggiornate riguardo i propri clienti. La ditta si chiama Tropical Lane S.p.A. e vuole realizzare questo progetto per rendere maggiormente accessibili le informazioni per i propri agenti, distribuiti nelle varie regioni italiane, direttamente tramite un loro dispositivo mobile, come smartphone o tablet, senza dover necessariamente telefonare continuamente in ditta dove è presente una segretaria che svolge solamente questa mansione. In questo modo si cerca di velocizzare la procedura di accesso ai dati così da liberare una risorsa utile per lo svolgimento di altre funzioni interne. Si è deciso quindi di creare un sito web, basato su tecnologia Active Server Pages e interfacciato al database aziendale, che sia fruibile dall’esterno della rete aziendale e sul quale vengono mostrati i dati, organizzati in modo da essere facilmente comprensibili e visualizzabili da tutti. La realizzazione del sito è stata effettuata utilizzando notepad++ sia per le pagine ASP che per le poche pagine di HTML statico presenti. Gli script sono stati realizzati in linguaggio Javascript, compatibile con le specifiche dei browser più diffusi. Il sito è supportato da un unico database realizzato in precedenza con Microsoft SQL ed integrato.

Progettazione, implementazione e valutazione di un simulatore basato su web real time communication (WebRTC).

Questa tesi tratta della realizzazione e valutazione di un simulatore Web-Based i cui nodi sono connessi tramite Web Real Time Communication (WebRTC) e si testa la sua efficienza mediante la simulazione di un semplice modello di mobilità. Si espongono i principali concetti di simulazione e di WebRTC, fornendo le basi per una maggior comprensione del testo e delle scelte progettuali ed implementative. Si conclude con serie di test comparativi dell’applicativo mettendo in luce pregi e difetti di questo approccio alternativo alla simulazione.

Una applicazione web per l'analisi e la presentazione di dati relativi al mercato immobiliare italiano

Questa tesi è il risultato dell’attività di sviluppo di una applicazione Web per l’analisi e la presentazione di dati relativi al mercato immobiliare italiano, svolta presso l’azienda responsabile del portale immobiliare all’indirizzo www.affitto.it. L'azienda commissiona lo sviluppo di un sistema software che generi uno storico e descriva l'andamento del mercato immobiliare nazionale. In questa tesi verrà presentato il processo di sviluppo software che ha portato alla realizzazione del prodotto, che è costituito da un applicativo Web-based implementato col supporto di tecnologie quali PHP,HTML,MySQL,CSS.

Population based screening - the difficulty of how to do more good than harm and how to achieve it

Screening people without symptoms of disease is an attractive idea. Screening allows early detection of disease or elevated risk of disease, and has the potential for improved treatment and reduction of mortality. The list of future screening opportunities is set to grow because of the refinement of screening techniques, the increasing frequency of degenerative and chronic diseases, and the steadily growing body of evidence on genetic predispositions for various diseases. But how should we decide on the diseases for which screening should be done and on recommendations for how it should be implemented? We use the examples of prostate cancer and genetic screening to show the importance of considering screening as an ongoing population-based intervention with beneficial and harmful effects, and not simply the use of a test. Assessing whether screening should be recommended and implemented for any named disease is therefore a multi-dimensional task in health technology assessment. There are several countries that already use established processes and criteria to assess the appropriateness of screening. We argue that the Swiss healthcare system needs a nationwide screening commission mandated to conduct appropriate evidence-based evaluation of the impact of proposed screening interventions, to issue evidence-based recommendations, and to monitor the performance of screening programmes introduced. Without explicit processes there is a danger that beneficial screening programmes could be neglected and that ineffective, and potentially harmful, screening procedures could be introduced.

Development, implementation, and evaluation of a structured reporting web tool for abdominal aortic aneurysms

BACKGROUND The majority of radiological reports are lacking a standard structure. Even within a specialized area of radiology, each report has its individual structure with regards to details and order, often containing too much of non-relevant information the referring physician is not interested in. For gathering relevant clinical key parameters in an efficient way or to support long-term therapy monitoring, structured reporting might be advantageous. OBJECTIVE Despite of new technologies in medical information systems, medical reporting is still not dynamic. To improve the quality of communication in radiology reports, a new structured reporting system was developed for abdominal aortic aneurysms (AAA), intended to enhance professional communication by providing the pertinent clinical information in a predefined standard. METHODS Actual state analysis was performed within the departments of radiology and vascular surgery by developing a Technology Acceptance Model. The SWOT (strengths, weaknesses, opportunities, and threats) analysis focused on optimization of the radiology reporting of patients with AAA. Definition of clinical parameters was achieved by interviewing experienced clinicians in radiology and vascular surgery. For evaluation, a focus group (4 radiologists) looked at the reports of 16 patients. The usability and reliability of the method was validated in a real-world test environment in the field of radiology. RESULTS A Web-based application for radiological "structured reporting" (SR) was successfully standardized for AAA. Its organization comprises three main categories: characteristics of pathology and adjacent anatomy, measurements, and additional findings. Using different graphical widgets (eg, drop-down menus) in each category facilitate predefined data entries. Measurement parameters shown in a diagram can be defined for clinical monitoring and be adducted for quick adjudications. Figures for optional use to guide and standardize the reporting are embedded. Analysis of variance shows decreased average time required with SR to obtain a radiological report compared to free-text reporting (P=.0001). Questionnaire responses confirm a high acceptance rate by the user. CONCLUSIONS The new SR system may support efficient radiological reporting for initial diagnosis and follow-up for AAA. Perceived advantages of our SR platform are ease of use, which may lead to more accurate decision support. The new system is open to communicate not only with clinical partners but also with Radiology Information and Hospital Information Systems.

Ultrathin strut biodegradable polymer sirolimus-eluting stent versus durable polymer everolimus-eluting stent for percutaneous coronary revascularisation (BIOSCIENCE): a randomised, single-blind, non-inferiority trial

BACKGROUND Refinements in stent design affecting strut thickness, surface polymer, and drug release have improved clinical outcomes of drug-eluting stents. We aimed to compare the safety and efficacy of a novel, ultrathin strut cobalt-chromium stent releasing sirolimus from a biodegradable polymer with a thin strut durable polymer everolimus-eluting stent. METHODS We did a randomised, single-blind, non-inferiority trial with minimum exclusion criteria at nine hospitals in Switzerland. We randomly assigned (1:1) patients aged 18 years or older with chronic stable coronary artery disease or acute coronary syndromes undergoing percutaneous coronary intervention to treatment with biodegradable polymer sirolimus-eluting stents or durable polymer everolimus-eluting stents. Randomisation was via a central web-based system and stratified by centre and presence of ST segment elevation myocardial infarction. Patients and outcome assessors were masked to treatment allocation, but treating physicians were not. The primary endpoint, target lesion failure, was a composite of cardiac death, target vessel myocardial infarction, and clinically-indicated target lesion revascularisation at 12 months. A margin of 3·5% was defined for non-inferiority of the biodegradable polymer sirolimus-eluting stent compared with the durable polymer everolimus-eluting stent. Analysis was by intention to treat. The trial is registered with ClinicalTrials.gov, number NCT01443104. FINDINGS Between Feb 24, 2012, and May 22, 2013, we randomly assigned 2119 patients with 3139 lesions to treatment with sirolimus-eluting stents (1063 patients, 1594 lesions) or everolimus-eluting stents (1056 patients, 1545 lesions). 407 (19%) patients presented with ST-segment elevation myocardial infarction. Target lesion failure with biodegradable polymer sirolimus-eluting stents (69 cases; 6·5%) was non-inferior to durable polymer everolimus-eluting stents (70 cases; 6·6%) at 12 months (absolute risk difference -0·14%, upper limit of one-sided 95% CI 1·97%, p for non-inferiority <0·0004). No significant differences were noted in rates of definite stent thrombosis (9 [0·9%] vs 4 [0·4%], rate ratio [RR] 2·26, 95% CI 0·70-7·33, p=0·16). In pre-specified stratified analyses of the primary endpoint, biodegradable polymer sirolimus-eluting stents were associated with improved outcome compared with durable polymer everolimus-eluting stents in the subgroup of patients with ST-segment elevation myocardial infarction (7 [3·3%] vs 17 [8·7%], RR 0·38, 95% CI 0·16-0·91, p=0·024, p for interaction=0·014). INTERPRETATION In a patient population with minimum exclusion criteria and high adherence to dual antiplatelet therapy, biodegradable polymer sirolimus-eluting stents were non-inferior to durable polymer everolimus-eluting stents for the combined safety and efficacy outcome target lesion failure at 12 months. The noted benefit in the subgroup of patients with ST-segment elevation myocardial infarction needs further study. FUNDING Clinical Trials Unit, University of Bern, and Biotronik, Bülach, Switzerland.

Does the Use of Mobile Devices (Tablets and Smartphones) Affect Stated Choice Behavior in Web Surveys? An Application to Environmental Valuation

Web surveys are becoming increasingly popular in survey research. Compared with face-to-face, telephone and mail surveys, web surveys may contain a different and new source of measurement error and bias: the type of device that respondents use to answer the survey questions. To the best of our knowledge, this is the first study that tests whether the use of mobile devices affects survey characteristics and stated preferences in a web-based choice experiment. The web survey was carried out in Germany with 3,400 respondents, of which 12 per cent used a mobile device (i.e. tablet or smartphone), and comprised a stated choice experiment on externalities of renewable energy production using wind, solar and biomass. Our main finding is that survey characteristics such as interview length and acquiescence tendency are affected by the device used. In contrast to what might be expected, we find that, compared with respondents using desktop computers and laptops, mobile device users spent more time to answer the survey and are less likely to be prone to acquiescence bias. In the choice experiment, mobile device users tended to be more consistent in their stated choices, and there are differences in willingness to pay between both subsamples.

Radial versus femoral access in patients with acute coronary syndromes undergoing invasive management: a randomised multicentre trial.

BACKGROUND It is unclear whether radial compared with femoral access improves outcomes in unselected patients with acute coronary syndromes undergoing invasive management. METHODS We did a randomised, multicentre, superiority trial comparing transradial against transfemoral access in patients with acute coronary syndrome with or without ST-segment elevation myocardial infarction who were about to undergo coronary angiography and percutaneous coronary intervention. Patients were randomly allocated (1:1) to radial or femoral access with a web-based system. The randomisation sequence was computer generated, blocked, and stratified by use of ticagrelor or prasugrel, type of acute coronary syndrome (ST-segment elevation myocardial infarction, troponin positive or negative, non-ST-segment elevation acute coronary syndrome), and anticipated use of immediate percutaneous coronary intervention. Outcome assessors were masked to treatment allocation. The 30-day coprimary outcomes were major adverse cardiovascular events, defined as death, myocardial infarction, or stroke, and net adverse clinical events, defined as major adverse cardiovascular events or Bleeding Academic Research Consortium (BARC) major bleeding unrelated to coronary artery bypass graft surgery. The analysis was by intention to treat. The two-sided α was prespecified at 0·025. The trial is registered at ClinicalTrials.gov, number NCT01433627. FINDINGS We randomly assigned 8404 patients with acute coronary syndrome, with or without ST-segment elevation, to radial (4197) or femoral (4207) access for coronary angiography and percutaneous coronary intervention. 369 (8·8%) patients with radial access had major adverse cardiovascular events, compared with 429 (10·3%) patients with femoral access (rate ratio [RR] 0·85, 95% CI 0·74-0·99; p=0·0307), non-significant at α of 0·025. 410 (9·8%) patients with radial access had net adverse clinical events compared with 486 (11·7%) patients with femoral access (0·83, 95% CI 0·73-0·96; p=0·0092). The difference was driven by BARC major bleeding unrelated to coronary artery bypass graft surgery (1·6% vs 2·3%, RR 0·67, 95% CI 0·49-0·92; p=0·013) and all-cause mortality (1·6% vs 2·2%, RR 0·72, 95% CI 0·53-0·99; p=0·045). INTERPRETATION In patients with acute coronary syndrome undergoing invasive management, radial as compared with femoral access reduces net adverse clinical events, through a reduction in major bleeding and all-cause mortality. FUNDING The Medicines Company and Terumo.

Medical educators: How they define themselves - Results of an international web survey.

BACKGROUND Little is known about medical educators' self-definition. AIMS The aim of this study is to survey an international community of medical educators focusing on the medical educators' self-definition. METHODS Within a comprehensive, web-based survey, an open question on the participants' views of how they would define a "medical educator" was sent to 2200 persons on the mailing list of the Association for Medical Education in Europe. The free text definitions were analysed using qualitative thematic analysis. RESULTS Of the, 200 medical educators invited to participate, 685 (31.1%) provided a definition of a "medical educator". The qualitative analysis of the free text definitions revealed that medical educators defined themselves in 13 roles, primarily as "Professional Expert", "Facilitator", "Information Provider", "Enthusiast", "Faculty Developer", "Mentor", "Undergraduate and Postgraduate Trainer", "Curriculum Developer", "Assessor and Assessment Creator", and "Researcher". CONCLUSIONS Our survey revealed that medical educators predominantly define themselves as "Professional Experts" and identified 12 further self-defined roles of a medical educator, several of which not to have been reported previously. The results can be used to further the understanding of our professional identity.

Does the use of mobile devices (tablets and smartphones) affect survey quality and choice behaviour in web surveys?

Web surveys are becoming increasingly popular in survey research including stated preference surveys. Compared with face-to-face, telephone and mail surveys, web surveys may contain a different and new source of measurement error and bias: the type of device that respondents use to answer the survey questions. This is the first study that tests whether the use of mobile devices, tablets or smartphones, affects survey characteristics and stated preferences in a web-based choice experiment. The web survey on expanding renewable energy production in Germany was carried out with 3182 respondents, of which 12% used a mobile device. Propensity score matching is used to account for selection bias in the use of mobile devices for survey completion. We find that mobile device users spent more time than desktop/laptop users to answer the survey. Yet, desktop/laptop users and mobile device users do not differ in acquiescence tendency as an indicator of extreme response patterns. For mobile device users only, we find a negative correlation between screen size and interview length and a positive correlation between screen size and acquiescence tendency. In the choice experiment data, we do not find significant differences in the tendency to choose the status quo option and scale between both subsamples. However, some of the estimates of implicit prices differ, albeit not in a unidirectional fashion. Model results for mobile device users indicate a U-shaped relationship between error variance and screen size. Together, the results suggest that using mobile devices is not detrimental to survey quality.

INFLUENCE OF A CLINIC BASED IMMUNIZATION INFORMATION SYSTEM ON INFANT IMMUNIZATIONS

This study focuses on the impact of a clinic-based intervention program on the immunization status of limited-income urban children. The intervention program consisted of an information session for clinic health care providers and the placement of individualized immunization information labels on clinic notes at the time of each visit. The degree of impact of the intervention on immunization administration was ascertained through a comparison of two similar groups of infants born in the same months of the year immediately before (N = 201) and after (N = 203) the information session and initiation of the labeling system. The timeliness of administration of each diphtheria, pertussis, tetanus and trivalent oral polio vaccine (DPT/TOPV) in the first year series of three was compared pre- to postintervention. Significantly more third immunizations were given the postintervention subjects within ten days of the recommended time of application ( p = .0361). Life table analysis indicated that the probability of an infant's passing one year of age without the administration of the third immunization decreased for postintervention infants (p = .0515). The intervention was most successful in assuring administration of the series of immunizations in those infants who were seen by the health care provider for at least 50% of their first year visits. Results indicate that minor changes in the format of information given a relatively continuous provider can increase completion of immunization series in infants. ^

An intervention mapping approach: Identification of human trafficking victims by health professionals

Background. Today modern day slavery is known as human trafficking and is a growing pandemic that is a grave human rights violation. Estimates suggest that 12.3 million people are working under conditions of force, fraud or coercion. Working toward eradication is a worthy effort; it would free millions of humans from slavery, mostly women and children, as well as uphold basic human rights. One tactic to eradicating human trafficking is to increase identification of victims among those likely to encounter victims of human trafficking.^ Purpose. This study aims to develop an intervention that improves certain stakeholders' ability, in the health clinic setting, to appropriately identify and report victims of human trafficking to the National Human Trafficking Resource Center.^ Methods. The Intervention Mapping (IM) process was used by program planners to develop an intervention for health professionals. This methodology is a six step process that guides program planners to develop an intervention. Each step builds on the others through the execution of a needs assessment, and the development of matrices based on performance objectives and determinants of the targeted health behavior. The end product results in an ecological, theoretical, and evidence based intervention.^ Discussion. The IM process served as a useful protocol for program planners to take an ecological approach as well as incorporate theory and evidence into the intervention. Consultation with key informants, the planning group, adopters, implementers, and individuals responsible for institutionalization also contributed to the practicality and feasibility of the intervention. Program planners believe that this intervention fully meets recommendations set forth in the literature.^ Conclusions. The intervention mapping methodology enabled program planners to develop an intervention that is appropriate and acceptable to the implementer and the recipients.^

Using intervention mapping to develop a community garden program at the women's home

This culminating experience was a practice based intervention conducted by an organization, utilizing an intervention mapping approach for the program planning. It took place summer 2010 through spring 2011 and included incorporating a community garden into the Gusto wellness program at The Women's Home. This organization offers long-term residential care, and therapeutic services. Literature relating to community gardens and nutrition behavior change was reviewed. Short-term objectives included: 1) Conducting a needs assessment using focus groups, 2) Designing gardening program components based on intervention mapping guidelines, 3) Constructing a garden bed at Midtown Community Garden for use of The Women's Home, 4) Planning and implementing gardening education, and 5) Assessing feasibility of the garden program. The target population included 24 residents living at the residential dormitory of The Women's Home at the time of this project. The major variables are intervention mapping constructs including: 1) Needs assessment, 2) Preparing matrices of change objectives, 3) Selecting theory-informed intervention methods and practical strategies, 4) Producing program components and materials, 5) Planning program adoption, implementation, and sustainability, and 6) Planning for evaluation. The specific focus was lack of access to fresh fruits and vegetables (FV) for this population. Focus group responses revealed interest in community garden participation. Matrices of change were developed for lack of FV access based on performance objectives for behavioral and environmental factors and related determinants and theory. Methods and strategies were developed to implement a community garden and encourage participation. Program components included initiating a garden club, networking activities, creating gardening curriculum, and participating at Midtown Community Garden. Adoption and implementation performance objectives were outlined, and many were carried out. Evaluation questions were designed and outcomes of the garden project were discussed. ^ Outcomes of the project included exposure of garden topics and activities for The Women's Home residents, focus group responses revealing an interest in gardening among this population, gardening program components designed based on intervention mapping steps, and a constructed garden bed that was used for planting vegetables and flowers through fall 2010. Limited resources and budget along with a lack of a residential coordinator at The Women's Home were the main limiting factors for this project. Future garden projects can be developed using the intervention mapping process.^