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.

A pilot study on affective classification of facial images for emerging news topics

The proliferation of news reports published in online websites and news information sharing among social media users necessitates effective techniques for analysing the image, text and video data related to news topics. This paper presents the first study to classify affective facial images on emerging news topics. The proposed system dynamically monitors and selects the current hot (of great interest) news topics with strong affective interestingness using textual keywords in news articles and social media discussions. Images from the selected hot topics are extracted and classified into three categorized emotions, positive, neutral and negative, based on facial expressions of subjects in the images. Performance evaluations on two facial image datasets collected from real-world resources demonstrate the applicability and effectiveness of the proposed system in affective classification of facial images in news reports. Facial expression shows high consistency with the affective textual content in news reports for positive emotion, while only low correlation has been observed for neutral and negative. The system can be directly used for applications, such as assisting editors in choosing photos with a proper affective semantic for a certain topic during news report preparation.

Encapsulation of Hydrocortisone and Mesalazine in Zein Microparticles

Zein was investigated for use as an oral-drug delivery system by loading prednisolone into zein microparticles using coacervation. To investigate the adaptability of this method to other drugs, zein microparticles were loaded with hydrocortisone, which is structurally related to prednisolone; or mesalazine, which is structurally different having a smaller LogP and ionizable functional groups. Investigations into the in vitro digestibility, and the electrophoretic profile of zein, and zein microparticles were conducted to shed further insight on using this protein as a drug delivery system. Hydrocortisone loading into zein microparticles was comparable with that reported for prednisolone, but mesalazine loading was highly variable. Depending on the starting quantities of hydrocortisone and zein, the average amount of microparticles equivalent to 4 mg hydrocortisone, (a clinically used dose), ranged from 60-115 mg, which is realistic and practical for oral dosing. Comparatively, an average of 2.5 g of microparticles was required to deliver 250 mg of mesalazine (a clinically used dose), so alternate encapsulation methods that can produce higher and more precise mesalazine loading are required. In vitro protein digestibility revealed that zein microparticles were more resistant to digestion compared to the zein raw material, and that individual zein peptides are not preferentially coacervated into the microparticles. In combination, these results suggest that there is potential to formulate a delivery system based on zein microparticles made using specific subunits of zein that is more resistant to digestion as starting material, to deliver drugs to the lower gastrointestinal tract.

Preparation and in vitro release of zein microparticles loaded with prednisolone for oral delivery

Zein has been proposed as a polymer for targeted-drug delivery via the oral route. Zein microparticles were loaded with prednisolone and evaluated as an oral delivery system. Microparticles were formulated using phase separation. Starting quantities of zein and prednisolone, along with the agitation method and temperature were found to significantly impact drug loading and loading efficiency. Vortex mixing produced the highest drug loading and loading efficiency. Drug release was measured in simulated conditions of the stomach and small intestine using the microparticles made with the method that best improved drug loading. In simulated stomach and small intestine conditions, prednisolone release reached almost 70 over 3 and 4h, respectively. While a clinically relevant dose may be delivered using c. 100mg of zein microparticles, prednisolone release from the microparticles indicates that they may not be suited as a controlled-or targeted-delivery system.

Australia’s first Pharmacist Immunisation Pilot - who did pharmacists inject?

The Queensland Pharmacist Immunisation Pilot is Australia’s first to allow pharmacists vaccination. The pilot ran between April 1st 2014 and August 31st 2014, with pharmacists administering influenza vaccination during the flu season. METHODS Participant demographics and previous influenza vaccination experiences were recorded using GuildCare software. Participants also completed a ‘post-vaccination satisfaction survey’ following their influenza vaccination. RESULTS A total of 11,475 participant records were analysed. Females accounted for 63% of participants, with the majority of participants aged between 45 – 64 years (53%). Overall, 49% of participants had been vaccinated before, the majority at a GP clinic (60%). Most participants reported receiving their previous influenza vaccination from a nurse (61%). Interestingly, 1% thought a pharmacist had administered their previous vaccination, while 7% were unsure which health professional had administer it. It was also of note that approximately 10% of all participants were eligible to receive a free vaccination from the National Immunisation Program, but still opted to receive their vaccine in a pharmacy. Over 8,000 participants took part in the post-vaccination survey, 93% were happy to receive their vaccination from a pharmacy in the future while 94% would recommend this service to other people. The remaining 7% and 6% respectively had omitted to fill in those questions. DISCUSSION Participants were overwhelmingly positive in their response to the pharmacist vaccination pilot. These findings have helped pave the way for expanding the scope of practice for pharmacists with the aim to increase vaccination rates across the state.

'Bacon - hold the eggs' for uncontrollable nose bleeds

Almost everyone experiences a nosebleed at some time during their lives. In many cases, these nosebleeds are self-limiting, resolve without medical attention, and tend to be nothing more than a minor nuisance. However, in some instances they can be life threatening and urgent medical attention is required. One of these instances is when people who have Glanzmann's thrombasthenia (GT) experience a nosebleed...

A puff of fluticasone for eosinophilic oesophagitis

Eosinophilic oesophagitis (EEl is most commonly observed in children and young males, and is estimated to affect one per 10,000 children, and lo/o of adults in Australia. EE causes inflammation of the oesophagus; and an endoscopy, and biopsy showing an increase in eosinophils through the oesophagus is used for diagnosis. People with EE often present with non-specific symptoms to varying degrees of severity that could also suggest swallowing difficulties, or acid reflux; the feeling of food sticking to the throat on the way down (sometimes completely), choking on food, regurgitation of food, and severe acid reflux that does not respond to stomach acid suppression treatment...

Simvastatin - from cholesterol to venous ulcers?

It is estimated that up to three per 1,000 of the Australian adult population are affected by leg ulcers. Venous ulcers are the most common cause of ulceration in the lower extremities, accounting for approximately 80-85% of leg ulcers. These debilitating, and often painful ulcers recur frequently and can affect people of all ages, though the risk increases dramatically with age (approximately 99% of those with venous ulcers in Australia are over 65 years of age). Other risk factors include a family history of leg ulceration, varicose veins, venous disease, phlebitis, deep vein thrombosis, congestive heart failure, obesity, immobility, and previous leg injury. The chronic and recurring nature of venous ulcers, in addition to reduced quality of life for the patient, and ongoing costs of care place a significant burden of disease on the patient, and health system...

Smoothing out the breathlessness

An estimated one in 10 Australians has asthma. In 2010, the burden of disease for asthma was ranked 7th highest for the overall population in Australasia. A less well-known condition that also affects breathing, is vocal cord dysfunction (VCD). People with asthma and VCD can both present with similar symptoms such as coughing, difficulty breathing, wheezing and throat tightness. Asthma and VCD attacks also share similar triggers such as breathing in lung irritants, exercising or having an upper respiratory infection. Asthma and VCD frequently coexist. They affect different parts of the respiratory system and appear to have separate aetiologies. Asthma is essentially a condition of airway inflammation, even though the most prominent clinical presentation is bronchoconstriction. which is responsible for symptoms such as wheezing and shortness of breath. The cause of VCD is not well understood, though the abnormal closing of the vocal cords during breathing does not appear to involve an immune reaction, or the lower airways...

Ramipril - improving exercise tolerance in intermittent claudication?

Peripheral artery disease (PAD) is one of the most common manifestations of systemic atherosclerosis. It is estimated that 10-15% of the general population is affected by PAD, whereby the narrowed arteries lead to reduced blood flow to the extremeties - particularly the legs. While many people have mild or no systems with PAD, approximately one-third of people experience intermittent claudication (IC).