Taller de Microsoft Excel.

UANL

La inferencia estadística con Microsoft Excel

En este artículo se dan algunas ideas practicas para empezar a trabajar la inferencia estadística, por ejemplo, dentro del programa de segundo bachillerato de ciencias sociales. Lo esencial del artículo es el uso de una hoja de Excel de Microsoft Excel.

La inferencia estadística con Microsoft Excel.

Resumen basado en el del autor

Desarrollo de una hoja de cálculo del impedimento auditivo usando Microsoft EXCEL

Resumen en inglés

Book review : The active modeler : mathematical modeling with Microsoft® Excel by E. Neuwirth and D. Arganbright

A recently-published work in by two well-known authors in the field of spreadsheet modeling is reviewed.

Estimation of pharmacokinetic parameters from non-compartmental variables using Microsoft Excel((R))

This study was conducted to develop a method, termed 'back analysis (BA)', for converting non-compartmental variables to compartment model dependent pharmacokinetic parameters for both one- and two-compartment models. A Microsoft Excel((R)) spreadsheet was implemented with the use of Solver((R)) and visual basic functions. The performance of the BA method in estimating pharmacokinetic parameter values was evaluated by comparing the parameter values obtained to a standard modelling software program, NONMEM, using simulated data. The results show that the BA method was reasonably precise and provided low bias in estimating fixed and random effect parameters for both one- and two-compartment models. The pharmacokinetic parameters estimated from the BA method were similar to those of NONMEM estimation.

Conhecimento dos adolescentes sobre métodos contraceptivos: pesquisa-ação em uma unidade do programa saúde da família de Natal

It is a descriptive study with a qualitative approach, and an action-research type, which aimed to analyze the changes of knowledge about contraceptive methods invested to a teenager group attended in Igapó Family Healthcare Unit, in the city of Natal/RN, after consent and institutional assent of Ethics Committee of Rio Grande do Norte Federal University (Protocol No. 131/07). It were researched 16 teenagers of both sexes, with age ranging from 11 to 16 years. We used two structured questionnaires, one in the initial diagnosis and another during the seven meetings of the focus group, in addition to the field notes and the meetings discussions transcriptions. The data-collection was performed in the period of two months by a team composed by a nurse the research coordinator, a dentist, a nursing assistant, a community-based healthcare worker and a nursing academic. The quantitative and qualitative data were organized, tagged and categorized into spreadsheet in Microsoft Excel, being held a thematic analysis of speeches performed by the study participants. The results were presented as tables, graphics, photos, drawings and word clippings. The educational strategy developed in focus group allowed adolescents to discuss, exchange ideas and opinions on several contraceptive methods, providing expansion in knowledge of all contraceptives discussed, especially those natural and surgical, which were less mentioned at the beginning of the study. Among the advantages of the contraceptive methods listed by teenagers, was highlighted avoiding pregnancy and STDs in use of the barrier method of condom. As for the disadvantages more frequently noted by the survey with the misuse of barrier methods, was highlighted get pregnant, acquire STD's and do not prevent STD's in hormonal, natural and surgical methods. Adolescents showed consistency between the advantages and disadvantages and types of contraceptive methods, showing a widening in knowledge among them. It may be said that, in general, those surveyed had a good understanding about the use of the various contraceptive methods. Thus, the study participants had positively evaluated all the criteria used to qualify the meetings in the focus group. The action strategy of the focus group should be encouraged by professionals who work with teenagers, since they prefer to live in groups, one characteristic of adolescence.

Trânsito de saberes e campo representacional na visão dos profissionais da saúde da família e do programa de educação pelo trabalho e para a saúde

The Family Health Strategy (ESF) is emerging as a possible restructuring of services and new practices of intervention in health care; it requires skilled professionals to work with that framework. Within this purpose, we established the Education Programme for Work and Health (PET-Saúde), in order to integrate teaching and service activities, focusing on primary care. On this basis, the aim of this work is to apprehend the social representation of nurse, doctor and dentist (Project PET-Natal Health RN preceptors) on the ESF, while practice field of them. It is a descriptive and exploratory study, with a qualitative approach, carried out in 07 Family Health Units (USF) included in the PET-Saúde Natal (RN). The population was composed of 35 professional components of the primary care team with bachelor's degree of the USF linked to this project. The sample was composed of 05 nurses, 05 physicians and 05 dentists, for a total of 15 subjects. Data were collected through three instruments: the drawing-themed story, a semi-structured individual interviews and field diary. The data relating to the identification of the subjects were entered and tabulated by the Microsoft Excel software 2007 version. The drawing analysis and interpretation is given by the significance attributed to the resource chart from title and keywords assigned by the subjects, considering the ESF as an inductive term. The stories and interviews were transcribed and typed and then subjected to read/listen the material and a lexical analysis through Alceste. After this process, the discursive material was analyzed and discussed by theoretical and methodological feature of the Social Representations theory. The majority of health professionals were female, aged between 46 and 52 years old, married, income less than six minimum wage, time since graduation ranged from 22 to 29 years and working time in the ESF range from 02 to 11 years. From the classification system ALCESTE were selected categories identified by: Category 1 - ESF: relations and territory; Category 2 - Training and bond profile; Category 3 - Working process in the ESF; Category 4 - Articulation between teaching and service; Category 5 - Health care and disease prevention. The representational field construction, while a process, followed the logic of structural cores in existing categories. In this sense, it is clear that the ESF is an environment rich in diversity, experience and relationships with potential such as the relationship "very subject-subject" and the link established between professional-community, but also has some weaknesses such as poor working conditions, lack of popular participation and management support, thus difficulties in the achievement of teamwork. Being essential to that end, the teaching-service aimed at the formation of a new health professional able to work in the ESF. In this research, the training of the representational field encountered a diversity of structural cores, or thoughts on training, about the ESF because of the greater emphasis on the here and now of the interaction between health professionals, the ESF, the community, PET Health-UFRN and students, emphasizing that such proposals are still considered as concepts in the context of recent health and that, therefore, are not fully realized in the social imaginary

Desenvolvimento de uma ferramenta computacional em excel para automatizar o projeto estrutural de pórticos rolantes

Coordenação de Aperfeiçoamento de Pessoal de Nível Superior (CAPES)

Análise de estruturas reticuladas utilizando o software excel pelo método dos elementos finitos

Pós-graduação em Engenharia Mecânica - FEG

PCRELAP5 - Programa de cálculo para os dados de entrada do código RELAP5

Após os acidentes nucleares ocorridos no mundo, critérios e requisitos extremamente rígidos para a operação das instalações nucleares foram determinados pelos órgãos internacionais que regulam essas instalações. A partir da ocorrência destes eventos, as operadoras de plantas nucleares necessitam simular alguns acidentes e transientes, por meio de programas computacionais específicos, para obter a licença de operação de uma planta nuclear. Com base neste cenário, algumas ferramentas computacionais sofisticadas têm sido utilizadas como o Reactor Excursion and Leak Analysis Program (RELAP5), que é o código mais utilizado para a análise de acidentes e transientes termo-hidráulicos em reatores nucleares no Brasil e no mundo. Uma das maiores dificuldades na simulação usando o código RELAP5 é a quantidade de informações geométricas da planta necessárias para a análise de acidentes e transientes termo-hidráulicos. Para a preparação de seus dados de entrada é necessário um grande número de operações matemáticas para calcular a geometria dos componentes. Assim, a fim de realizar estes cálculos e preparar dados de entrada para o RELAP5, um pré-processador matemático amigável foi desenvolvido, neste trabalho. O Visual Basic for Applications (VBA), combinado com o Microsoft Excel, foi utilizado e demonstrou ser um instrumento eficiente para executar uma série de tarefas no desenvolvimento desse pré-processador. A fim de atender as necessidades dos usuários do RELAP5, foi desenvolvido o Programa de Cálculo do RELAP5 PCRELAP5 onde foram codificados todos os componentes que constituem o código, neste caso, todos os cartões de entrada inclusive os opcionais de cada um deles foram programados. Adicionalmente, uma versão em inglês foi criada para PCRELAP5. Também um design amigável do PCRELAP5 foi desenvolvido com a finalidade de minimizar o tempo de preparação dos dados de entrada e diminuir os erros cometidos pelos usuários do código RELAP5. Nesse trabalho, a versão final desse pré-processador foi aplicada com sucesso para o Sistema de Injeção de Emergência (SIE) da usina Angra 2.

Avaliação da efetividade do Programa de Alimentação do Trabalhador

This study analyzed the Worker’s Healthy Eating Program in Rio Grande do Norte state (RN) to assess its possible impact on the nutritional status of the workers benefitted. To that end, we conducted a cross-sectional observational prospective study based on a multistage stratified random sample comparing 26 small and medium-sized companies from the Manufacturing Sector (textiles, food and beverages, and nonmetallic minerals) of RN, divided into two equal groups (WFP and Non WFP). Interviews were conducted at each company by trained interviewers from Tuesday to Saturday between September and December 2014. Data were collected on the company (characterization and information regarding the program’s desired results) and workers (personal and professional information, anthropometrics, health, lifestyle and food consumed the previous day). Population estimates were calculated for RN on the characteristics of workers and the study variables. The main variable was BMI. The secondary variables were waist circumference (WC), nutritional diagnosis, calorie intake, blood pressure, metabolic variables and lifestyle indicators. The statistical method used was hierarchical mixed effects linear regression for interval variables and hierarchical mixed effects logistic regression for binary variables. The variables measured in ordinal scales were analyzed by ordinal logistic regression adjusted for correlated variables, adopting robust standard errors. The results for interval variables are presented as point estimates and their 95% confidence intervals; and as odds-ratios and their 95% confidence intervals for binary variables. The Fisher’s exact and Student’s t-tests were used for simple comparisons between proportions and means, respectively. Differences were considered statistically significant at p<0.05. A total of 1069 workers were interviewed, of which 541 were from the WFP group and 528 from the Non WFP group. Subjects were predominantly males and average age was 34.5 years. Significant intergroup differences were observed for schooling level, income above 1 MW (minimum wage) and specific training for their position at the company. The results indicated a significant difference between the BMI of workers benefitted, which was on average 0.989 kg/m2 higher than the BMI of workers from the Non WFP group (p=0.002); and between the WC, with the waist circumference of WFP group workers an average of 1.528 cm larger (p<0.05). Higher prevalence of overweight and obesity (p<0.001) and cardiovascular risk (p=0.038) were recorded in the WFP group. Tests on the possible effect of the WFP on health (blood pressure and metabolic indicators) and lifestyle indicators (smoking, alcohol consumption and exercise) were not significant. With respect to worker’s diets, differences were significant for consumption of saturated fat (lunch and daily intake), salt (lunch, other meals and daily intake) and proteins (other meals and daily intake), with higher consumption of these nutrients in the WFP group. The study showed a possible positive impact of the WFP on nutritional status (BMI and WC) among the workers benefitted. No possible effects of the program were observed for the lifestyle indicators studied. Workers benefitted consumed less salt, saturated fat and protein. The relevance of the WFP is recognized for this portion of society and it is understood that, if the program can reach and impact those involved, the development of educational initiatives aimed at nutritional and food safety may also exert a positive influence.

Eficacia del programa "Por mi salud bucal y la de mi futuro bebé" en la higiene oral de gestantes que acuden a un centro de salud materno infantil de la provincia de Chiclayo, 2015

Tesis de pregrado