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

Relics, 2007, in touring exhibition, Selectively Revealed, 2012

“Selectively Revealed investigates the blurry line between the public and the private in artistic practice. The artist is presented as voyeur, muse, subject, performer and social commentator. Using a variety of screen based practices, each artist pushes and pulls at the notion of what is private and what is public, choosing precisely what, when, how or when not to reveal their subjects or themselves. Ultimately, everything is presented for scrutiny; an innermost feeling, a personal moment, a fear or failure, an everyday encounter, an experience of rapture, a banal endeavour. Much is revealed, celebrated and critiqued.” Sarah Bond (Asialink) and Clare Needham (Experimenta)

FarmKids 2007 – 2008

Farmkids (styled as FARMkids) is an Australian animated comedy series about a bunch of pampered zoo animals accidentally being shipped to a dude ranch. 13 episodes aired in Series 1 and another 13 in Series 2 (2007-2008)

Space Station Design Report 2007

Design Proposal for the Blue Lunar Support Hub The conceptual design of a space station is one of the most challenging tasks in aerospace engineering. The history of the space station Mir and the assembly of the International Space Station demonstrate that even within the assembly phase quick solutions have to be found to cope with budget and technical problems or changing objectives. This report is the outcome of the conceptual design of the Space Station Design Workshop (SSDW) 2007, which took place as an international design project from the 16th to the 21st of July 2007 at the Australian Centre for Field Robotics (ACFR), University of Sydney, Australia. The participants were tasked to design a human-tended space station in low lunar orbit (LLO) focusing on supporting future missions to the moon in a programmatic context of space exploration beyond low Earth orbit (LEO). The design included incorporating elements from systems engineering to interior architecture. The customised, intuitive, rapid-turnaround software tools enabled the team to successfully tackle the complex problem of conceptual design of crewed space systems. A strong emphasis was put on improving the integration of the human crew, as it is the major contributor to mission success, while always respecting the boundary conditions imposed by the challenging environment of space. This report documents the methodology, tools and outcomes of the Space Station Design Workshop during the SSDW 2007. The design results produced by Team Blue are presented.

Childhood sexual abuse and adult sexual dysfunction: Response to commentary by Rind and Tromovitch (2007)

Rind and Tromovitch (2007) raised four concerns relating to our article (Najman, Dunne, Purdie, Boyle, & Coxeter, 2005. Archives of Sexual Behavior, 34, 517-526.) which suggested a causal association between childhood sexual abuse (CSA) and adult sexual dysfunction. We consider each of these concerns: magnitude of effect, cause and effect, confounding, and measurement error. We suggest that, while the concerns they raise represent legitimate reservations about the validity of our findings, on balance the available evidence indicates an association between CSA and sexual dysfunction that is of "moderate" magnitude, probably causal, and unlikely to be a consequence of confounding or measurement error.

Book Review "Selling sex: a hidden history of prostitution", R. Frances, UNSW Press, Sydney, 2007

In the opening pages of Selling Sex we are introduced to 'Joy', a statue of a young female sex worker which stood in East Sydney for eighteen months during 1995- 1997. Following complaints by local residents, the statue was removed from public view and returned to its owner. Evidently, Joy was considered a reminder of the community's 'bad old days', when it was better known for prostitution than restaurants. In a nation in which almost every sizable community has proudly erected monuments to military men, the removal of Joy reveals much about labour and gender relations in Australia. For Frances, the removal of Joy is symbolic, our historical treatment of sex workers having parallels with our treatment of the convicts. This work sets out to give these women (male prostitutes do not figure in this history) a voice and break with the stereotypes of 'abandoned whores' or 'sad victims'. It also sets out to place the sex industry in the broader national and international context in which it has historically operated...