The evaluation of software process is considered an important tool and commonly used to point out the way, where the organization must apply its efforts to improve processes. In particular, the assessment process proposed by the MA-MPS requires the presentation of objective evidence showing satisfaction of the expected results of processes and results of process attributes of a certain level of maturity. The problem of presentation of objective evidence boils down in the difficulty of the managers responsible for processes in interpreting these results described in the Spreadsheet of Indicators. In addition, there are cases where the implementer of the MPS model not has enough time to monitor the entire fill or revision of the spreadsheet, before submitting it for evaluation of processes. Thus, the occurrence of errors in filling can occur and affect the outcome of the evaluation. In this context, is presented the intelligent assistant, Expert Mentoring, which is designed to support, through questions, the managers responsible for processes in the interpreting the expected results of processes and results of attributes of process described in the Spreadsheet of Indicators, where the final of these questions will suggest direct and indirect indicators, which are more suitable for proof of these results. In this sense, the main results of the evaluation of the Expert Mentoring were: decreasing the number of errors in completing the spreadsheet, and recall the name of the indicator, even before the suggestion of the intelligent assistant. / Fundação de Amparo a Pesquisa do Estado de Alagoas / A avaliação de processo de software é considerada uma ferramenta importante e, comumente, usada para apontar o caminho, onde a organização precisa aplicar seus esforços em prol da melhoria dos processos. Em particular, a avaliação de processos proposta pelo MA-MPS exige a apresentação de evidências objetivas que comprovem a satisfação dos resultados esperados de processos e resultados de atributos de processos de determinado nível de maturidade. O problema da apresentação de evidências objetivas se resume na dificuldade dos gerentes responsáveis pelos processos em interpretar esses resultados descritos na Planilha de Indicadores. Além disso, há casos em que o implementador do modelo MPS não dispõe de tempo suficiente para acompanhar todo o preenchimento ou revisão da planilha, antes de submetê-la à avaliação de processos. Assim, a ocorrência de erros de preenchimento pode acontecer e comprometer o resultado da avaliação. Neste contexto, é apresentado o assistente inteligente, Expert Mentoring, cujo objetivo é apoiar, através de perguntas, os gerentes responsáveis pelos processos na interpretação dos resultados esperados de processos e resultados de atributos de processos descritos na Planilha de Indicadores, onde ao final destas perguntas sugere indicadores diretos e indiretos, que sejam mais adequados para a comprovação destes resultados. Nesse sentido, os principais resultados obtidos com a avaliação do Expert Mentoring foram: a diminuição do número de erros de preenchimento da planilha, e a recordação do nome do indicador, antes mesmo da sugestão do assistente inteligente.

Different approaches for the estimation of the uncertainty related to measurement results are found in the literature and in published guidelines. In the present work three approaches were used to estimate the uncertainty of the determination of aflatoxins (AB1, AB2, AG1, AG2) and deoxynivalenol in maize by liquid chromatography coupled to mass spectrometry tandem (LC-MS/MS): the Bottom up approach, adapted from the Guide to the Expression of Uncertainty in Measurement (ISO GUM); the Monte Carlo Method (MCM), which propagates distributions assigned to the input quantities through a numerical simulation; and the Kragten approach wich calculates standard deviations and confidence intervals with a universally applicable spreadsheet technique. A measurement equation was developed for mycotoxins analysis and a cause-and-effect diagram was draft to assist in the identification of the sources of uncertainty associated with the method. Detailed analysis of contributions of the various uncertainty sources was carried out. Measurement uncertainty was determined by the addition of the variances of the individual steps of the test procedure, according to each approach employed. The Bottom up, MCM and Kragten approaches produced very similar estimates to the combined uncertainty and the coefficient of variation (CV) between them was smaller than 1.0%. The main contribution to overall uncertainty is the intermediate precision with contributions over 90,0% for each mycotoxin. The results obtained with this research conclude that the three approaches are adequate for estimating the uncertainty in mycotoxin assays with LC-MS/MS technique. Among them, Bottom up is the most appropriate approach, since it requires that the analyst performs a detailed investigation about dominant components of the measurement uncertainty, allowing for better understanding and improvement of the measurement process. The Monte Carlo and Kragten methods are indicated the data generated by the Bottom up approach. / A literatura cita diferentes abordagens para estimar a incerteza de medição em ensaios quantitativos. No presente trabalho três abordagens foram utilizadas para estimar a incerteza da determinação de aflatoxinas (AB1, AB2, AG1, AG2) e desoxinivalenol em milho por cromatografia líquida acoplada à espectrometria de massa tandem (LC-MS/MS): a abordagem Bottom up, adaptada do Guia para a Expressão da Incerteza de Medição (ISO GUM); o método de Monte Carlo (MMC), que propaga distribuições atribuídas às grandezas de entrada através de uma simulação numérica; e a abordagem de Kragten que calcula desvios padrão e intervalos de confiança com uma técnica planilha universalmente aplicável. Um modelo matemático foi desenvolvido para os ensaios de micotoxinas e um diagrama de causa-efeito foi proposto para auxiliar na identificação das fontes de incerteza associadas ao método. A análise detalhada das contribuições das várias fontes de incerteza foi realizada. A incerteza de medição foi determinada pela adição das variações dos passos individuais do procedimento de ensaio, de acordo com cada abordagem. Os métodos Bottom up, MMC e Kragten geraram estimativas similares para a incerteza combinada, com um coeficiente de variação (CV) menor que 1,0% entre elas. O principal componente de incerteza é a precisão intermediária, com contribuições acima de 90,0% para cada micotoxina. Como resultado da pesquisa, conclui-se que as três abordagens são adequadas para estimar a incerteza nos ensaios para quantificação de micotoxinas por LC-MS/MS. Dentre elas, a abordagem Bottom up é a mais apropriada, pois requer que o analista avalie o método detalhadamente para identificar os principais componentes de incerteza, possibilitando a implementação de melhorias no sistema de medição. Os métodos de Monte Carlo e Kragten são indicados como uma ferramenta de confirmação dos resultados obtidos pela abordagem Bottom up.

Submitted by Luciana Ferreira (lucgeral@gmail.com) on 2015-10-09T15:42:04Z No. of bitstreams: 2 Dissertação - Robinson Borges - 2015.pdf: 5327815 bytes, checksum: 26e74f7fe04f29332da9adb2d2476abc (MD5) license_rdf: 23148 bytes, checksum: 9da0b6dfac957114c6a7714714b86306 (MD5) / Approved for entry into archive by Luciana Ferreira (lucgeral@gmail.com) on 2015-10-09T15:44:21Z (GMT) No. of bitstreams: 2 Dissertação - Robinson Borges - 2015.pdf: 5327815 bytes, checksum: 26e74f7fe04f29332da9adb2d2476abc (MD5) license_rdf: 23148 bytes, checksum: 9da0b6dfac957114c6a7714714b86306 (MD5) / Made available in DSpace on 2015-10-09T15:44:21Z (GMT). No. of bitstreams: 2 Dissertação - Robinson Borges - 2015.pdf: 5327815 bytes, checksum: 26e74f7fe04f29332da9adb2d2476abc (MD5) license_rdf: 23148 bytes, checksum: 9da0b6dfac957114c6a7714714b86306 (MD5) Previous issue date: 2015-03-27 / Coordenação de Aperfeiçoamento de Pessoal de Nível Superior - CAPES / This work shows how an educational toy (game) can stimulate the teaching of mathematics. This game becomes a starting point for several discussions, is a pedagogical tool that relates to concrete, direct and simple way, various parts of mathematics. This is a game easy to use, easy to manufacture and which favors the systematization of logical reasoning. By using this teaching tool the student is required to take decisions and also notes that every decision has implications in the upcoming decisions. The desired solution is obtained with the aid of a spreadsheet. We work with a general case and for that we used twenty-four variables. To reach the desired solutions toy was converted into codes, axes were used as directions and guidelines senses them, counting rule, application of the fundamental theorem of arithmetic and foundations of probability. / Este trabalho mostra como um brinquedo pedagógico (jogo) pode estimular o ensino de matemática. Este jogo torna-se um ponto de partida para várias discussões e um instrumento pedagógico que relaciona de maneria concreta, direta e simples, várias partes da matemática. Trata se de um jogo de fácil utilização, de fácil confecção e que favorece a sistematização do raciocínio lógico. Com a utilização deste instrumento pedagógico o aluno é levado a tomar decisões e ainda verifica que cada decisão tomada tem implicações nas próximas decisões. A solução desejada será obtida com o auxílio de uma planilha eletrônica. Trabalhamos com um caso geral e para isso utilizamos vinte e quatro variáveis. Para chegar às soluções desejadas o brinquedo foi convertido em códigos, foram utilizados eixos como direções e neles sentidos de orientações, regra de contagem, aplicação do teorema fundamental da aritmética e fundamentos básicos de probabilidade.

The diploma thesis focuses on a proposal for a methodological framework of reporting management in the banking sector and identifying key weaknesses of the current state. Using the proposed methodology precedes weaknesses and proves it on practical example from the real environment. The main benefit of this work is design of a methodological framework that allows the organized management and control of the reporting. It also brings identification of main weaknesses of the current reporting and last but not least universal template for the report specification. The work consists of three parts. The first, theoretical, defines area of reporting in a banking institution. It includes all the terminology, characteristics and types of reports. The second part, analytical, examines the current weaknesses of reporting within the defined area. Provides an overview of three to six major weaknesses in a particular phase of a new report development based on the scientific literature and practical experience of the author of this work in the banking environment. The third and final section contains a draft concept of reporting management in the banking sector with avoidance of the identified weaknesses from the analytical part.

This thesis envisages the possibilities of data transport from portal applications into spreadsheets. The main goal is to find out a solution to export data in suitable form for MS Excel application.   The thesis also shows principles of the OLAP. It describes OLAP internal data model and shows the way, how data could be exported from a website into spreadsheets. It enlarges SYLK and XML file formats, which are suitable for data representation in MS Office Excel spreadsheet.

This paper presents DECO (Dresden Enron COrpus), a dataset of spreadsheet files, annotated on the basis of layout and contents. It comprises of 1,165 files, extracted from the Enron corpus. Three different annotators (judges) assigned layout roles (e.g., Header, Data, and Notes) to non-empty cells and marked the borders of tables. Files that do not contain tables were flagged using categories such as Template, Form, and Report. Subsequently, a thorough analysis is performed to uncover the characteristics of the overall dataset and specific annotations. The results are discussed in this paper, providing several takeaways for future works. Furthermore, this work describes in detail the annotation methodology, going through the individual steps. The dataset, methodology, and tools are made publicly available, so that they can be adopted for further studies. DECO is available at: https://wwwdb.inf.tu-dresden.de/research-projects/deexcelarator/.

Målet med detta examensarbete har varit att utvärdera ett simuleringsverktyg för toleranskedjeanalyser i 1D, följt av en jämförelse med dagens metod att beräkna toleranskedjor i 1D med kalkylark i Excel. Simuleringsverktyget heter EZtol och har funnits sedan ett och ett halvt år tillbaka. Examensarbetet utfördes på uppdrag från Scania CV AB, som ville undersöka om mjukvaran kan ersätta den nuvarande metoden. Examensarbetet utfördes under 10 veckor och delades upp i tre huvudområden: Upplärning i form av webkurs och internkurs på Scania, simulering av olika toleranskedjor i mjukvaran samtidigt som beräkningar i kalkylark gjordes och till sist rapportskrivning. Rapporten är uppdelad i sex kapitel. I det första kapitlet beskrivs bakgrunden till problemet, mål och syfte. Det andra kapitlet redogör för nuläget som påvisar att det finns ett visst behov av en mjukvara. Konstruktörer intervjuades för att få en bild över vilka behov som inte uppfylldes i kalkylarket. Dessa visade sig främst sig vara grafisk visualisering och bidragslista över toleranser (en lista som visar vilka toleranser som påverkar utfallet mest). I det tredje kapitlet beskrivs teorierna som använts som grund till arbetet. Teorierna är Användarguiden i EZtol, Grundläggande om toleranser, toleranskedjor, Simulering och CATIA V5. I kapitel fyra beskrivs genomförandet vilket till största del bestått av upplärning samt simulering i mjukvaran. Det femte kapitlet redogör resultatet vilket presenteras i form av för- och nackdelar. De främsta fördelarna har visat sig vara grafisk visualisering av toleranskedjor samt bidragslista över toleranser. Dock visade det sig att den främsta nackdelen var att mjukvaran inte klarar av att hantera långa och mer komplicerade toleranskedjor, vilket har lett till slutsatsen att mjukvaran inte rekommenderas till Scania i dagsläget. Scanias krav uppfylls inte då mjukvaran inte kan hantera företagets alla toleranskedjor. Men eftersom konceptet kring EZtol är intressant bedöms ändå mjukvaran ha potential att passa in på Scania om några år. En rekommendation är därför att simuleringsmjukvaran bör utvärderas om på nytt i framtiden. / The aim with this thesis work has been to evaluate a simulation tool for 1D-analysis of tolerancechains, followed by a comparison with the current method to calculate tolerance-chains in 1D with spreadsheets in Excel. The simulation tool is named EZtol and has existed for one and a half year. The thesis work has been carried out on assignment from Scania CV AB. The company wanted us to evaluate if the software could replace the current method. The thesis work has been carried out during 10 weeks and was divided in three main sections: Education in terms of a web-course and internal course, simulation of different tolerance-chains in the software as well as calculations in the spreadsheet and finally make a scientific report based on the thesis work. The essay is divided in six chapters. The first chapter describes the background, aim and purpose of the thesis work. The second chapter describes how the situation of tolerance-chain calculations looks today, which has shown that there is a certain need of a software. The designers were interviewed so that the thesis workers could establish what the spreadsheet could not fulfill, which was graphic visualization of tolerance-chains and also a list with the contributions of all tolerances. The third chapter describes the theories that have been used for this thesis work. The theories are Tutorial in EZtol, Fundamental facts about tolerances and tolerance‐chains and Simulation and CATIA V5. In the fifth chapter the results of this thesis work are featured, which are presented as advantages and disadvantages. The main advantages with the software are graphic visualization of the tolerance-chains as well as a list that shows the contributions of every tolerance. The primary disadvantage though is that the software cannot handle long and more complicated tolerance-chains. Which has led to the conclusion that the thesis workers do not recommend the software to Scania at present time. Scanias requirements cannot be fulfilled with the software because it has not been able to handle all of Scanias tolerance-chains. But since the EZtol concept is good the software is estimated to potentially fulfill Scanias needs in a few years. A recommendation is that the software ought to be reexamined in the future.

With rapid growth in technical and social sector, the amount of data produced and retrieved has grown exponentially. Hence, there is a dire need for a management information system (MIS) to manage and structure such data. This study was initiated to learn about the problems and needs of the employees of a truck manufacturer organisation while working for long duration projects. The information about processes and tasks is available but in an unstructured manner through excel spreadsheets which makes it difficult for users to retrieve required information during crucial times. An information system in the form of a dashboard was designed and proposed to overcome the problems faced by users. This study focuses on evaluating the user experience of employees while retrieving desired information about the procedures using both dashboard and excel spreadsheets. To investigate the work structure and problems of employees, interviews were conducted. The results were analysed and a dashboard solution was proposed and developed with real time data. With employees coordination, few usability tests were conducted and the feedback was recorded for future work. According to the study results, the efficiency of employees can be increased and the decision making can be improved using MIS. With better retrieval techniques user experience was also enhanced. The interactive visualisations of dashboard attracted users and was used efficiently for providing tons of information about procedures to be followed. / Med den snabba tillväxten inom teknisk och social sektor har mängden data som både produceras och hämtas ökat exponentiellt. Därför finns det ett brådskande behov av informationssystem för att hanterar och strukturera sådan data. Denna studie startade med att utforska de problem och behov som fanns hos anställda på ett företag som tillverkar lastbilar när de jobbar i långvariga projekt. Informationen om rutiner, processer och uppgifter är idag tillgänglig för de anställda i ostrukturerade Excel-kalkylblad, detta gör det svårt att hämta nödvändig information. Ett informationssystem i form av en instrumentpanel utformades och föreslogs för att lösa de problem som användarna möter. Denna studie fokuserade på att utvärdera användarupplevelsen hos de anställda medan de hämtade önskad information om rutinerna när de använde både instrumentpanelen och Excel-kalkylblad. För att undersöka arbetetsstrukturen och de problem som de anställda upplever så genomfördes intervjuer. Resultatet analyserades och ett resultat i forma av ett informationssystem (instrumentpanelen) föreslogs och utvecklades med realtidsdata. Med samordning av de anställda genomfördes användbarhetstester och deras återkoppling registrerades för framtida arbete. Enligt studieresultaten kan effektiviteten hos de anställda ökas och beslutsfattande kan förbättras med hjälp av ett informationssystem. Användarupplevelsen kan också förbättras genom bättre tekniker för hämtning av data. Den interaktiva visualiseringen av instrumentpanelen lockade användarna och användes effektivt för att ge information om rutiner som ska följas.

Os consórcios são conhecidos pelo aumento da capacidade de realização que confere aos participantes, e maior eficiência no uso dos recursos disponíveis, o que auxiliaria os pequenos governos locais para solucionar a escassez de recursos. Este trabalho apresenta o estudo do sistema consorciado intermunicipal para destinação dos resíduos sólidos urbanos, para auxiliar os municípios de pequeno porte na solução da inadequada destinação do lixo, responsáveis por constantes impactos ambientais. Os estudos foram realizados através de análises de custos com enfoque logístico, no nível estratégico de localização de facilidades e roteirização e programação da frota. Os estudos foram possíveis, com o auxílio do software TransCAD, uma ferramenta de Sistema de Informações Geográficas. Através do TransCAD, foi realizado a localização dos aterros sanitários, obedecendo-se as restrições impostas, e a roteirização da frota de veículos, que levassem ao menor custo logístico. Para se chegar à situação de menor custo, diversas configurações foram consideradas, nas quais foram variados o número de aterros que atendem os municípios, e a presença ou não de estações de transferência de resíduos. O método desenvolvido promoveu a análise de custos da implantação e operação do sistema consorciado, que consiste desde a coleta de resí-duos, até a disposição final em aterros sanitários. Os resultados deste trabalho comprovaram quantitativamente que o consórcio é mais eficiente do que a solução isolada para cada município. / The consortium are known by the growth of the accomplishment capacity that grants to the participants, and larger efficiency in the use of the available resources, what would aid the small local governments to solve the lack of resources. This work presents the study of the intermunicipal consortium system for the destination of the urban solid waste, to aid the small cities to solve the inadequate destination of the waste, responsible for constant environmental damages. The studies were developed through the costs analysis with logistics focus, on the strategic level of facilities location and the vehicle routing. The studies were possible with the aid of the software TransCAD, a tool of Geographical Information System. Through the TransCAD, being obeyed the imposed restrictions, the location of the sanitary landfill was made, and vehicles routing, to take to the lowest logistics cost. To reach the situation of lowest cost, several configurations were considered, in which the number of sanitary landfill for the cities were varied, and the inclusion or not the solid waste transfer stations. The developed method promoted the cost analysis of the implantation and operation of the consortium system, from the waste collection, until the final disposition in sanitary landfills. The results of this work proved quantitatively that the consortium is more efficient than the isolated solution for each city.

The work is concerned with preparing exercises for the teaching of bulk data processing in the environment of a spreadsheet program. The exercises can be used in the lessons of ICT in the upper stage of the elementary school and in secondary schools. Presently a lot of exercises exist. These exercises are based on obsolete or uninteresting data or directly on artificial data. On the contrary there are few exercises which are based on up to date data or on data which the students entered. In the work there is an emphasis on the importance of creating exercises which are based on up to date data which is freely accessible on the Internet. For example geographical, economic or meteorological data. A software application which can download this data and transfer it into a suited format for further use in a spreadsheet program is a part of the work. We can note the benefit of using exercises, where data has been entered by the students of the class. A part of the work is a software solution which makes a survey possible for the teacher. The students answer the questions in the survey via a form. These answers are worked up into a table for further use in the lessons. An important part of the work is a set of methodical sheets. These sheets contain topics for exercises, which are specialized in bulk data processing. They show acceptable elaboration of downloaded or measured data and possible interpretation of the results. The main objective of the work is to show how and where to get up to date and attractive data for the teaching of bulk data processing and how to use it. The software and the methodical sheets should contribute to this.