An “Instrumental Approach” to Study the Integration of a Computer Tool Into Mathematics Teaching: the Case of Spreadsheets

This article reports on research focused on the integration of a specific computer tool, the spreadsheet, into mathematics teaching. After presenting some important results obtained by research in this area, we revisit these in the light of an instrumental approach, which we perceive as essential to analyse the construction of mathematical meanings in spreadsheet environments and to understand better the questions of technological integration. Then, these theoretical elements are used in order to design an exploratory experiment with grade 7 pupils and analyse its results.     

Curriculum, Classroom Practices, and Tool Design in the Learning of Functions Through Technology-Aided Experimental Approaches

The paper starts from classroom situations about the study of a functional relationship with help of technological tools as a ‘transposition’ of experimental approaches from research mathematical practices. It considers the limitation of this transposition in existing curricula and practices based on the use of non-symbolic software like dynamic geometry and spreadsheets. The paper focuses then on the potentialities of classroom use of computer algebra packages that could help to go beyond this shortcoming. It looks at a contradiction: while symbolic calculation is a basic tool for mathematicians, curricula and teachers are very cautious regarding their use by students. The rest of the paper considers the design and experiment of a computer environment Casyopée as means to contribute to an evolution of curricula and classroom practices to achieve the transposition in the domain of algebraic activities linked to functions.     

Thermal imager primary design and analysis using PC based scientific spreadsheet

Effective primary design can avoid over-specification that will cause waste on cost. In this work, we propose a relatively simple procedure to rapid and reasonably write specifications, design systems and analyze requirements. The IR imager primary system design and analysis concepts adopt here are described. By using the primary design and analysis concept to cope with system performance models and PC based scientific spreadsheet to construct a mathematical software package which provides a costefficient, compliant solution to a design problem and predict thermal imager performance to an analysis problem. An illustrative example is presented to express more detail specifically due to the uncooled IR imager.     

ExcelAutomat 1.3: Fragment analysis based on the distortion/interaction-activation strain model

The distortion/interaction-activation strain model (D/I-ASM), a fragment analysis method, is applied to study the structure–reactivity relationship in reactions. The application of D/I-ASM involves the generation of input files for points along a reaction profile, submission of input files to a quantum software package, processing of parameters from the resulting output files and generation of graphical plots. The ExcelAutomat tool (Laloo et al., J. Comput. Aided Mol. Des. 2017, 31, 667) provides a framework and library in Visual Basic for Application programming language to process such files. New routines were written in ExcelAutomat 1.3 to facilitate processing of files for D/I-ASM. The worksheet “ASM” was included where initial parameters needed can be defined. The routines for D/I-ASM were tested successfully on bimolecular nucleophilic substitution, cycloaddition, and barrierless reactions. The automation of fragment analysis by ExcelAutomat 1.3 is compatible with Microsoft Excel and LibreOffice Calc. The extensible tool processes files from Gaussian and GAMESS-US packages. © 2018 Wiley Periodicals, Inc.     

Solution to projectile motion with quadratic drag and graphing the trajectory in spreadsheets

This note gives the analytical solution to projectile motion with quadratic drag by decomposing the velocity vector to x, y coordinate directions. The solution is given by definite integrals. First, the impact angle is estimated from above, then the projectile coordinates are computed, and the trajectory is graphed at various launch angles and speed using an interactive Excel application.     

A truncated Cauchy distribution

A truncated version of the Cauchy distribution is introduced. Unlike the Cauchy distribution, this possesses finite moments of all orders and could therefore be a better model for certain practical situations. One such situation in finance is discussed. Explicit expressions for the moments of the truncated distribution are also derived.     

多元回归分析的软件求解和案例解读

多元回归与相关分析是重要的统计分析方法 ,但复杂的计算给分析方法的推广应用带来了困难。以前介绍的一些计算机软件也可以解决回归分析的求解 ,但是数据的输入和软件操作运用要经过专门训练。目前广泛应用的 Excel软件为回归分析的求解给出了非常方便的操作过程 ,本文以案例的形式介绍了多元回归与相关分析的 Excel软件求解 ,并解读了统计分析结果     

放射性核衰变统计规律实验的计算机模拟

本文从原理上分析了采用舍选法进行随机抽样,得到符合放射性衰变统计规律的模拟计数值,并用TC进行了编程实现;然后介绍了利用办公自动化软件中的电子表格EXCEL处理数据的方法;最后根据程序生成的模拟计数进行了处理,获得了理论频数和实验频数的对照图;进一步可以进行x2检验。