Computational science for undergraduate biologists via QUT.Bio.Excel

Molecular biology is a scientific discipline which has changed fundamentally in character over the past decade to rely on large scale datasets – public and locally generated - and their computational analysis and annotation. Undergraduate education of biologists must increasingly couple this domain context with a data-driven computational scientific method. Yet modern programming and scripting languages and rich computational environments such as R and MATLAB present significant barriers to those with limited exposure to computer science, and may require substantial tutorial assistance over an extended period if progress is to be made. In this paper we report our experience of undergraduate bioinformatics education using the familiar, ubiquitous spreadsheet environment of Microsoft Excel. We describe a configurable extension called QUT.Bio.Excel, a custom ribbon, supporting a rich set of data sources, external tools and interactive processing within the spreadsheet, and a range of problems to demonstrate its utility and success in addressing the needs of students over their studies.

Objectifying the Subjective : Assessment and Feedback in Creative Arts Studio Learning and Teaching

This paper examines the Assessment and Feedback aspects of Studio Teaching as Creative Arts pedagogy. Prompted by USQ’s newly offered Bachelor of Creative Arts (BCA), the author has developed an Assessment Matrix specifically designed to satisfy a number of imperatives, including: • ‘objectifying’ the subjective aspects of creative practice as assessable coursework/research • providing the means by which accurate, detailed, personalised and confidential feedback may be provided to students individually • providing consistent, accurate, meaningful assessment records for student, lecturer, and institution • ensuring consistency, continuity, and transparency of assessment processes and records to satisfy quality audits • minimising marking and assessment time, whilst maximising assessment integrity and depth • requiring only basic level skills and knowledge of a computer application already in common use (Microsoft Excel) • adaptability to a range of creative courses ‐ across disciplines This Assessment Matrix has been in development (and trialled) since January 2009.

Clinical perceptions of radiation therapy undergraduate competency standards

Introduction The multifactorial nature of clinical skills development makes assessment of undergraduate radiation therapist competence level by clinical mentors challenging. A recent overhaul of the clinical assessment strategy at Queensland University of Technology has moved away from the high-stakes Observed Structured Clinical Examination (OSCE) to encompass a more continuous measure of competence. This quantitative study aimed to gather stakeholder evidence to inform development of standards by which to measure student competence for a range of levels of progression. Methods A simple anonymous questionnaire was distributed to all Queensland radiation therapists. The tool asked respondents to assign different levels of competency with a range of clinical tasks to different levels of student. All data were anonymous and was combined for analysis using Microsoft Excel. Results Feedback indicated good agreement with tasks that specified amount of direction required and this has been incorporated into the new clinical achievements record that the students need to have signed off. Additional puzzling findings suggested higher expectations with planning tasks than with treatment-based tasks. Conclusion The findings suggest that the amount of direction required by students is a valid indicator of their level and has been adopted into the clinical assessment scheme. Further work will build on this to further define standards of competency for undergraduates.

Letters and numbers in Excel : fostering student engagement in fundamentals of maths & computing

The television quiz program Letters and Numbers, broadcast on the SBS network, has recently become quite popular in Australia. This paper considers an implementation in Excel 2010 and its potential as a vehicle to showcase a range of mathematical and computing concepts and principles.

Colour by numbers in Excel 2007 : solving algebraic equations without algebra

This is an update of an earlier paper, and is written for Excel 2007. A series of Excel 2007 models is described. The more advanced versions allow solution of f(x)=0 by examining change of sign of function values. The function is graphed and change of sign easily detected by a change of colour. Relevant features of Excel 2007 used are Names, Scatter Chart and Conditional Formatting. Several sample Excel 2007 models are available for download, and the paper is intended to be used as a lesson plan for students having some familiarity with derivatives. For comparison and reference purposes, the paper also presents a brief outline of several common equation-solving strategies as an Appendix.

Exploring the fundamental theorem of arithmetic in excel 2007

This paper discusses how fundamentals of number theory, such as unique prime factorization and greatest common divisor can be made accessible to secondary school students through spreadsheets. In addition, the three basic multiplicative functions of number theory are defined and illustrated through a spreadsheet environment. Primes are defined simply as those natural numbers with just two divisors. One focus of the paper is to show the ease with which spreadsheets can be used to introduce students to some basics of elementary number theory. Complete instructions are given to build a spreadsheet to enable the user to input a positive integer, either with a slider or manually, and see the prime decomposition. The spreadsheet environment allows students to observe patterns, gain structural insight, form and test conjectures, and solve problems in elementary number theory.

Basic finance made accessible in Excel 2007 : "the big 5, plus 2"

The basic principles and equations are developed for elementary finance, based on the concept of compound interest. The five quantities of interest in such problems are present value, future value, amount of periodic payment, number of periods and the rate of interest per period. We consider three distinct means of computing each of these five quantities in Excel 2007: (i) use of algebraic equations, (ii) by recursive schedule and the Goal Seek facility, and (iii) use of Excel's intrinsic financial functions. The paper is intended to be used as the basis for a lesson plan and contains many examples and solved problems. Comment is made regarding the relative difficulty of each approach, and a prominent theme is the systematic use of more than one method to increase student understanding and build confidence in the answer obtained. Full instructions to build each type of model are given and a complete set of examples and solutions may be downloaded (Examples.xlsx and Solutions.xlsx).

Teaching basic finance with Excel, and without pain

The five quantities of interest in elementary finance problems are present value, future value, amount of periodic payment, number of periods and the rate of compound interest per period. A recursive approach to computing each of these five quantities in a modern version of Excel, for the case of ordinary annuities, is described. The aim is to increase student understanding and build confidence in the answer obtained, and this may be achieved with only linear relationships and in cases where student knowledge of algebra is essentially zero. Annuity problems may be solved without use of logarithms and black-box intrinsic functions; these being used only as check mechanisms. The author has had success with the method at Bond University and surrounding high schools in Queensland, Australia.

Víctimas de un experimento: Conflicto multicultural en el programa de oportunidades

This article presents a reflection of the application of multiculturality principles into tertiary educational programs at the University of Los Andes, Bogota Colombia. The main focus of this paper is debating the concept of 'positive discrimination' as a challenge taken by educational centres in societies with cultural diversity populations.

Programa Piloto de Diseño Promoción y Desarrollo de Productos con Alto Valor Agregado en la Empresa Peruana

Este proyecto se desarrollo por iniciativa de las autoras y con el apoyo de un grupo interdisciplinario, con el interés común de desarrollar una investigación académica cuyo resultado sea de utilidad para el desarrollo del sector productivo artesanal Peruano. El proceso de investigación nace a partir de una observación de campo acerca de la problemática del producto artesanal Peruana y enfocada en los aspectos comerciales, de diseño y producción. Esta observación se centro en Cajamarca (por ser el departamento menos intervenido por otras investigaciones en este tema) en la zona de Aylambo y Cruz Blanca, en los talleres artesanales que desarrollan productos cerámicos. A partir de un análisis de tipo FODA de los productos y de su contexto de desarrollo, encontramos que los artesanos que trabajan con los empresarios exportadores, requieren un tipo de capacitación que les permita desarrollar su trabajo mediante un proceso orientado a cumplir con exigencias técnicas y de diseño para el desarrollo de productos validos como oferta exportable. Como punto de partida se recurrió a las instituciones no gubernamentales y del gobierno, que promueven el sector artesanal Peruano (Prompex, Adex, Proyecto PARA, IMPART) para conocer su opinión respecto a los mercados objetivos de este sector, y para adoptar como parte del proyecto, lo vigente respecto a las políticas y planes de comercialización. Para entender la contraparte comercial de este sector artesanal recurrimos a empresas privadas exportadoras con muchos años de experiencia, para ello contamos con la colaboración de empresas como Allpa, Manos Amigas, Novica. A partir de la observación de campo preliminar y de la información recogida de los expertos consultados, se realizo un diagnostico de la situación productiva en este sector. En base a la definición del problema, se establecieron las estrategias y metodologías para el diseño de la investigación, siendo parte de estas estrategias, la realización de un taller de desarrollo de productos en Cajamarca. Las estrategias tuvieron como enfoque principal la definición de metodologías de trabajo, cuya aplicación sea posible en el marco del contexto económico, político y cultural en el que se desarrolla este sector en la realidad inmediata del país. El proyecto culmina con la presentación de una propuesta que mas allá de abarcar únicamente lo metodológico en el área del diseño, presenta también ‘modelos’ de trabajo entre los diferentes actores que intervienen en el sector, de manera que a través de estrategias colaborativas se pueda potenciar el crecimiento del sector y beneficiar el desarrollo del artesano.

Clash of the titans: Apple, Adobe, and Microsoft under fire at IT pricing inquiry

Today, an Australian parliamentary committee grilled the IT titans - Apple, Adobe, and Microsoft - on price discrimination against Australian consumers. The IT companies were evasive under questioning.

Etapas del cambio en personas inactivas tras un programa de promoción de la actividad física en Atención Primaria

Objetivo El objetivo del estudio fue evaluar las Etapas del cambio en relación con la actividad física y el estado de salud general entre personas que participaron en un Programa de promoción de la actividad física (PPAF) de 12 semanas frente a un grupo control. Diseño Ensayo clínico aleatorizado. Participantes Noventa y ocho personas inactivas de ambos sexos con una edad media de 62,82 años procedentes de 2 centros de Atención Primaria del Distrito Sanitario Costa del Sol. Intervención Un PPAF organizado en grupos y siguiendo los criterios del Colegio Americano de Medicina del Deporte, 2 sesiones semanales de 60 min durante 12 semanas. Mediciones principales La variable principal de resultado fue resistencia al cambio en relación con la actividad física. La variable secundaria fue el estado de salud general (componentes físicos y mentales), determinado con el cuestionario de salud general SF12. Resultados Se encontraron diferencias significativas en las etapas del cambio a favor del grupo experimental (p < 0,05). No se encontraron diferencias estadísticamente significativas entre grupos después de la intervención en el estado general de salud. Conclusión Las etapas del cambio se modificaron en las personas inactivas que realizaron el PPAF en Atención Primaria. Futuros estudios son necesarios para identificar qué factores del entorno de los participantes influyen en la resistencia al cambio de la actividad física. Abstract Objective This study has aimed to evaluate the stages of change in relation to physical activity and overall health status among persons who participated in a 12-week Physical activity promotion program (PAPP) compared to a control group. Design Randomized clinical trial. Participants The study included 98 inactive persons of both sexes with a mean age of 62.82 years from 2 of Primary Care Centers of the Malaga Health Care District. Interventions A PAPP organized in groups according to the American College of Sports Medicine criteria including two weekly sessions of 60 minutes each for 3 months. Main measures The primary outcome was to assess resistance to change in relation to physical activity. The secondary variable was overall health (physical and mental components) determined with the SF12 general health questionnaire. Results Significant differences were found in the stages of change (P<.05). There were no significant differences found in general health status improvement in regards to the initial assessment. Conclusion The stages of change were modified in the inactive persons who carried out the PAPP in Primary Care. Future studies are needed to identify which environmental factors influence the resistance to change in physical activity of the participants.

Cambios hematológicos tras un programa de promoción de actividad física en sujetos inactivos. Ensayo aleatorizado controlado

Objetivo Comparar los cambios antropométricos y bioquímicos en personas inactivas, que realizan un programa de actividad física frente a los que no lo realizan desde los Centros de Atención Primaria. Métodos Cien personas inactivas de ambos sexos, mayores de 55 años fueron aleatorizadas a un grupo experimental (n = 50) y a un grupo control (n = 50). Se realizó un programa de promoción de actividad física siguiendo los criterios del Colegio Americano de Medicina del Deporte, de 60 min cada sesión, 2 sesiones por semana, durante 3 meses. Las medidas antropométricas incluyeron el índice de masa corporal y el porcentaje graso, y como variables bioquímicas el perfil lipídico, hematíes y la creatina kinasa. Resultados Completaron el estudio 75 personas. Esta investigación no presentó cambios significativos a nivel antropométrico, ni en las variables bioquímicas del perfil lipídico. Sí se observaron efectos clínicamente relevantes en la concentración de los hematíes de las mujeres que realizaron dicho programa. Conclusiones El efecto clínico global fue pequeño en las personas que realizaron el programa, pero relevante para la salud de la población. Esta intervención produce efectos a corto plazo en la bioquímica de las personas inactivas. Abstract in English Objective Compare anthropometry and biochemical changes in inactive people who participate in a physical activity program versus those who do not from the Primary Health Care Centers. Methods One hundred inactive subjects of both genders, 55 years and older, from Torremolinos, Spain were randomized into an experimental group (n = 50) and a control group (n = 50). A program promoting physical activity was carried out following the American Medical Society for Sport's Medicine criteria. The program included sessions a week for 3 months. Antropometric measurements included body mass index and fat percentage, and such as biochemical measures: the lipid profile, erythrocytes, and creatine kinase. Results Seventy-five persons completed the study. This research did not show significant changes to anthropometric or biochemical outcomes of the lipid profile. However, there were clinically relevant effects regarding red blood cells concentration in the women who participated in this program. Conclusions Overall clinical effect was small in those participating in the program, but relevant for the health of the population. This program has short-term effects on biochemistry results of inactive subjects.

Naming ranges in Excel

When working with functions in Excel you can reference a range of cells by simply selecting the cells. For instance if you wanted to sum all your first month sales located in the range B3:B16, the function would be =SUM(B3:B16).