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.

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.

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.

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).

Herramientas de excel para el análisis y valoración de proyectos de inversión

El presente artículo trata de explicar las herramientas que ofrece Excel para facilitar el cálculo de los métodos del VAN y TIR, tanto en condiciones de certeza como de riesgo, y realizar el análisis de sensibilidad de los resultados obtenidos.

Herramientas de excel para el análisis y valoración de proyectos de inversión (y II)

El presente artículo, continuación de otro publicado en el número anterior de esta revista, no tiene por objeto explicar el manejo de la hoja de cálculo Excel, ni presentar hojas de cálculo que incluyan modelos para solucionar problemas relacionados con la valoración de las decisiones de financiación e inversión. Se trata de explicar la utilidad de un paquete informático "The Decision Tolls Suite" que consta de cinco programas, cada uno de los cuales trata un aspecto distinto del análisis de las decisiones en condiciones de riesgo, que se aplica a una hoja de cálculo Excel.

Diseño de líneas mixtas en un entorno Lean. Aplicación a un caso mediante Excel

[ES]Este trabajo tiene como objetivo analizar las soluciones existentes para el diseño de las líneas mixtas. Se trata de un tipo de líneas bastante complejas de diseñar y que por lo general han sido poco estudiadas por la sociedad académica, a pesar de las numerosas ventajas que ofrece en comparación a las líneas simples, mucho más investigadas. Para facilitar la comprensión de su diseño, y antes de su estudio, se realiza un análisis de las características de las líneas mixtas. Posteriormente se introduce una metodología desarrollada por Lluis Cuatrecasas (Presidente del Instituto Lean Management de España), que permite salvar la brecha que existe a su juicio entre los estudios sobre los diseños de este tipo de líneas y su aplicación a la empresa. Finalmente, se ilustra dicha metodología mediante un caso práctico y se evalúan sus fortalezas y debilidades.

Optimizar una producción II. Estudio y Comparación de un Problema de Programación lineal y su Dual. Resolución y Valoración de un caso práctico y su programación usando Excel y Win QSB.

En este trabajo se va a explicar la relación que existe entre la optimización de un problema lineal y el problema dual correspondiente. Se usara la herramienta Solver del Microsoft Excel para resolver los el problema de programación lineal planteado. Se analizaran los resultados obtenidos tanto del problema primal como del problema dual y se explicara el significado de los resultados obtenidos. Se finalizara con unas conclusiones donde se expondría lo aprendido durante este trabajo y el significado económico de este tipo de problemas.

Optimizar el personal. Estudio y Comparación de un Problema de Programación lineal y su Dual. Resolución y Valoración de un caso práctico y su programación usando Excel y Win QSB

OPTIMIZAR EL PERSONAL. Estudio y comparación de un problema de programación lineal y su dual. Resolución y valoración de un caso práctico y su programación usando Excel o Win QSB. (ESPAÑOL)

Distribution of Healthcare resources II.Study and Comparison of a Linear Programming Problem and its Dual. Resolution and Evaluation of a Practical Case and its Programming using Excel and Win QSB.

[EN]This research had as primary objective to model different types of problems using linear programming and apply different methods so as to find an adequate solution to them. To achieve this objective, a linear programming problem and its dual were studied and compared. For that, linear programming techniques were provided and an introduction of the duality theory was given, analyzing the dual problem and the duality theorems. Then, a general economic interpretation was given and different optimal dual variables like shadow prices were studied through the next practical case: An aesthetic surgery hospital wanted to organize its monthly waiting list of four types of surgeries to maximize its daily income. To solve this practical case, we modelled the linear programming problem following the relationships between the primal problem and its dual. Additionally, we solved the dual problem graphically, and then we found the optimal solution of the practical case posed through its dual, following the different theorems of the duality theory. Moreover, how Complementary Slackness can help to solve linear programming problems was studied. To facilitate the solution Solver application of Excel and Win QSB programme were used.