文章基本信息

标题：Innovative Use of What if Analysis for Visualization
本地全文：下载
作者：Amitha P L ; Geethu Joy ; Geethu S Pillai 等
期刊名称：International Journal of Soft Computing & Engineering
电子版ISSN：2231-2307
出版年度：2013
卷号：2
期号：6
页码：252-256
出版社：International Journal of Soft Computing & Engineering
摘要：The novelty of this paper is aimed at simplifying the tasks in Spreadsheet using a feature called what if analysis, which fires up the performance of the task we are working on. The use of spreadsheet helped us save time, perform many operations such as sorting, searching, classifying and comparing easily and to solve a problem without any programming knowledge. What if or sensitivity analysis is one of the most powerful and valuable concepts in Spreadsheet, the potential of which is not well exploited. The advantage of what if analysis is that if we show one computation in excel, the remaining part of the process will be computed by its own for a given range of variable values. It can be used to solve many problems other than the conventional managerial applications. Two Dimensional function evaluation and graphing, creating Pascal triangles, enumerating Pythagorean triplets in a given range, error function evaluation are some of the real applications. These types of applications can be exploited to enhance computational thinking of children in high schools. Computational thinking brings about a neoteric approach in problem-solving and model simulation.
关键词：Computational Thinking; Excel Computation;What if Analysis.