Applications of Spreadsheets in Education : The Amazing Power of a Simple Tool

This e-book is devoted to the use of spreadsheets in the service of education in a broad spectrum of disciplines: science, mathematics, engineering, business, and general education. The effort is aimed at collecting the works of prominent researchers and educators that make use of spreadsheets as a means to communicate concepts with high educational value. The e-book brings some of the most recent applications of spreadsheets in education and research to the fore. To offer the reader a broad overview of the diversity of applications, carefully chosen articles from engineering (power systems and control), mathematics (calculus, differential equations, and probability), science (physics and chemistry), and education are provided. Some of these applications make use of Visual Basic for Applications (VBA), a versatile computer language that further expands the functionality of spreadsheets. The material included in this e-book should inspire readers to devise their own applications and enhance their teaching and/or learning experience.

Spreadsheet Conditional Formatting Illuminates Investigations into Modular Arithmetic

Modular arithmetic has often been regarded as something of a mathematical curiosity, at least by those unfamiliar with its importance to both abstract algebra and number theory, and with its numerous applications. However, with the ubiquity of fast digital computers, and the need for reliable digital security systems such as RSA, this important branch of mathematics is now considered essential knowledge for many professionals. Indeed, computer arithmetic itself is, ipso facto, modular. This chapter describes how the modern graphical spreadsheet may be used to clearly illustrate the basics of modular arithmetic, and to solve certain classes of problems. Students may then gain structural insight and the foundations laid for applications to such areas as hashing, random number generation, and public-key cryptography.

The alcohol culture of mature-aged women : similarities and differences across borders

Introduction: Relatively few attempts have been made to describe and understand women’s alcohol consumption beyond adolescence and young adulthood. In particular, there has been a lack of studies focusing on the alcohol culture that surrounds and guides mature-aged women’s drinking. As part of a larger cross-national comparison, the present study sought to address this gap by identifying the shared beliefs and values that impact on drinking outcomes among mature-aged women in Sweden and Australia. Method: The study was guided by an ethnographic methodology. To generate data, a series of semi-structured interview were conducted with 17 Australian (age = 45-57 years; M = 52.1, SD = 3.9) and 19 Swedish (age = 45-58 years; M = 52.2, SD = 4.8) women. All interviews were transcribed verbatim and thematically analysed. Results: With age, the focus of alcohol as a single purpose vehicle for intoxication had given way to a focus on the enjoyment and ritual of drinking itself; taste had become increasingly important and alcohol was strongly associated with pleasurable environments and experiences. The view of alcohol as a taste experience was particularly pronounced among the Swedish women, with alcohol (most commonly wine) often seen as inseparable from food. Among the Swedish women, this view of alcohol was also associated with a strong de-emphasis of the pharmacological effects of alcohol. In contrast, several Australian women understood and used alcohol as relief for anxiety and stress. Moderate drinking was linked to the social construction of both age and gender in the two samples, while heavy or abusive alcohol consumption was associated with strong proscriptive norms and stigma. Conclusions: Australian and Swedish women share a number of beliefs and values around alcohol, however, these findings also show unique country-level differences. Implications for drinking outcomes are discussed.

Mathematical modeling of the cancer cell’s control circuitry : paving the way to individualized therapeutic strategies

Cancer is a disease of signal transduction in which the dysregulation of the network of intracellular and extracellular signaling cascades is sufficient to thwart the cells finely-tuned biochemical control mechanisms. A keen interest in the mathematical modeling of cell signaling networks and the regulation of signal transduction has emerged in recent years, and has produced a glimmer of insight into the sophisticated feedback control and network regulation operating within cells. In this review, we present an overview of published theoretical studies on the control aspects of signal transduction, emphasizing the role and importance of mechanisms such as ‘ultrasensitivity’ and feedback loops. We emphasize that these exquisite and often subtle control strategies represent the key to orchestrating ‘simple’ signaling behaviors within the complex intracellular network, while regulating the trade-off between sensitivity and robustness to internal and external perturbations. Through a consideration of these apparent paradoxes, we explore how the basic homeostasis of the intracellular signaling network, in the face of carcinogenesis, can lead to neoplastic progression rather than cell death. A simple mathematical model is presented, furnishing a vivid illustration of how ‘control-oriented’ models of the deranged signaling networks in cancer cells may enucleate improved treatment strategies, including patient-tailored combination therapies, with the potential for reduced toxicity and more robust and potent antitumor activity.

BRAF inhibitor therapy for melanoma, thyroid and colorectal cancers : development of resistance and future prospects

BRAF is a major oncoprotein and oncogenic mutations in BRAF are found in a significant number of cancers, including melanoma, thyroid cancer, colorectal cancer and others. Consequently, BRAF inhibitors have been developed as treatment options for cancers with BRAF mutations which have shown some success in improving patient outcomes in clinical trials. Development of resistance to BRAF kinase inhibitors is common, however, and overcoming this resistance is an area of significant concern for clinicians, patients and researchers alike. In this review, we identify the mechanisms of BRAF kinase inhibitor resistance and discuss the implications for strategies to overcome this resistance in the context of new approaches such as multi-kinase targeted therapies and emerging RNA interference based technologies.

An application of the Driver Behaviour Questionnaire in a large Australian organisational fleeting setting : can it predict crashes and demerit point loss?

This study reports on the utilisation of the Manchester Driver Behaviour Questionnaire (DBQ) to examine the self-reported driving behaviours of a large sample of Australian fleet drivers (N = 3414). Surveys were completed by employees before they commenced a one day safety workshop intervention. Factor analysis techniques identified a three factor solution similar to previous research, which was comprised of: (a) errors, (b) highway-code violations and (c) aggressive driving violations. Two items traditionally related with highway-code violations were found to be associated with aggressive driving behaviours among the current sample. Multivariate analyses revealed that exposure to the road, errors and self-reported offences predicted crashes at work in the last 12 months, while gender, highway violations and crashes predicted offences incurred while at work. Importantly, those who received more fines at work were at an increased risk of crashing the work vehicle. However, overall, the DBQ demonstrated limited efficacy at predicting these two outcomes. This paper outlines the major findings of the study in regards to identifying and predicting aberrant driving behaviours and also highlights implications regarding the future utilisation of the DBQ within fleet settings.

Factors contributing to crashes among young drivers

Young drivers are the group of drivers most likely to crash. There are a number of factors that contribute to the high crash risk experienced by these drivers. While some of these factors are intrinsic to the young driver, such as their age, gender or driving skill, others relate to social factors and when and how often they drive. This article reviews the factors that affect the risk of young drivers crashing to enable a fuller understanding of why this risk is so high in order to assist in developing effective countermeasures.

Optimizing I/O cost and managing memory for composition vector method based on correlation matrix calculation in bioinformatics

The generation of a correlation matrix for set of genomic sequences is a common requirement in many bioinformatics problems such as phylogenetic analysis. Each sequence may be millions of bases long and there may be thousands of such sequences which we wish to compare, so not all sequences may fit into main memory at the same time. Each sequence needs to be compared with every other sequence, so we will generally need to page some sequences in and out more than once. In order to minimize execution time we need to minimize this I/O. This paper develops an approach for faster and scalable computing of large-size correlation matrices through the maximal exploitation of available memory and reducing the number of I/O operations. The approach is scalable in the sense that the same algorithms can be executed on different computing platforms with different amounts of memory and can be applied to different bioinformatics problems with different correlation matrix sizes. The significant performance improvement of the approach over previous work is demonstrated through benchmark examples.

Recent progress in fluorescent blue light-emitting materials

Organic light emitting diodes (OLEDs), as an emerging technology for display and solid state lighting application, have many advantages including self-emission, lightweight, flexibility, low driving voltage, low power consumption, and low production cost. With the advancement of light emitting materials development and device architecture optimization, mobile phones and televisions based on OLED technology are already in the market. However, to obtain efficient, stable and pure blue emission than producing lower-energy colors is still one of the important subjects of these challenges. Full color and pure white light can be achieved only having stable blue emitting materials. To address this issue, significant effort has been devoted to develop novel blue light emitting materials in the past decade aiming at further improving device efficiency, color quality of emission light, and device lifetime. This review focuses on recent efforts of synthesis and device performance of small molecules, oligomers and polymers for blue emission of organic electroluminescent devices.

Real or imagined? A study exploring the existence of common method variance effects in road safety research

Common method variance (CMV) has received little attention within the field of road safety research despite a heavy reliance on self-report data. Two surveys were completed by 214 motorists over a two-month period, allowing associations between social desirability and key road safety variables and relationships between scales across the two survey waves to be examined. Social desirability was found to have a strong negative correlation with the Driver Behaviour Questionnaire (DBQ) sub-scales as well as age, but not with crashes and offences. Drivers who scored higher on the social desirability scale were also less likely to report aberrant driving behaviours as measured by the DBQ. Controlling for social desirability did not substantially alter the predictive relationship between the DBQ and the crash and offences variables. The strength of the correlations within and between the two waves were also compared with the results strongly suggesting that effects associated with CMV were present. Identification of CMV would be enhanced by the replication of this study with a larger sample size and comparing self-report data with official sources.

Synthesizing form and data : developing practices for student engagement and learning

We explore the relationship between form and data as a design agenda and learning strategy for novice visual information designers. Our students are university seniors in digital, visual design but novices to information design, manipulation and interpretation. We describe design strategies developed to scaffold sophisticated aesthetic and conceptual engagement despite limited understanding of the domain of designing with information. These revolve around an open-ended design project where students created a physical design from data of their choosing and research. The accompanying learning strategies concern this relationship between data and form to investigate it materially, formally and through ideation. Exemplifying student works that cross media and design domains are described.

Molecular phylogeny, biogeography, and habitat preference evolution of marsupials

Marsupials exhibit great diversity in ecology and morphology. However, compared to their sister group, the placental mammals, our understanding of many aspects of marsupial evolution remains limited. We use 101 mitochondrial genomes and data from 26 nuclear loci to reconstruct a dated phylogeny including 97% of extant genera and 58% of modern marsupial species. This tree allows us to analyze the evolution of habitat preference and geographic distributions of marsupial species through time. We found a pattern of mesic-adapted lineages evolving to use more arid and open habitats, which is broadly consistent with regional climate and environmental change. However, contrary to the general trend, several lineages subsequently appear to have reverted from drier to more mesic habitats. Biogeographic reconstructions suggest that current views on the connectivity between Australia and New Guinea/Wallacea during the Miocene and Pliocene need to be revised. The antiquity of several endemic New Guinean clades strongly suggests a substantially older period of connection stretching back to the Middle Miocene, and implies that New Guinea was colonized by multiple clades almost immediately after its principal formation.

Profiling contextual factors which influence safety in heavy vehicle industries

A significant proportion of worker fatalities within Australia result from truck-related incidents. Truck drivers face a number of health and safety concerns. Safety culture, viewed here as the beliefs, attitudes and values shared by an organisation’s workers, which interact with their surrounding context to influence behaviour, may provide a valuable lens for exploring safety-related behaviours in heavy vehicle operations. To date no major research has examined safety culture within heavy vehicle industries. As safety culture provides a means to interpret experiences and generate behaviour, safety culture research should be conducted with an awareness of the context surrounding safety. The current research sought to examine previous health and safety research regarding heavy vehicle operations to profile contextual factors which influence health and safety. A review of 104 peer-reviewed papers was conducted. Findings of these papers were then thematically analysed. A number of behaviours and scenarios linked with crashes and non-crash injuries were identified, along with a selection of health outcomes. Contextual factors which were found to influence these outcomes were explored. These factors were found to originate from government departments, transport organisations, customers and the road and work environment. The identified factors may provide points of interaction, whereby culture may influence health and safety outcomes.