Appears in:
Pages: 7270-7279
Publication year: 2012
ISBN: 978-84-695-3491-5
ISSN: 2340-1117

Conference name: 4th International Conference on Education and New Learning Technologies
Dates: 2-4 July, 2012
Location: Barcelona, Spain

# INTRODUCING CONDITIONAL ARRAY FORMULAS IN SPREADSHEET CLASSES

M. Csernoch

University of Debrecen (HUNGARY)
Array formulas, especially conditional array formulas seem to be the stepchild of spreadsheet studies; they are not taught by most of teachers of Informatics. Statistics show that a high number of teachers are not familiar with this feature, while others know about it but never realized its importance in the classes of spreadsheets. Consequently, most of the teachers belonging to the latter group just ignore the conditional array formulas and do not introduce them to their students. They do not do, in spite that teaching conditional array formulas to normal classes of Informatics has several advantages.

The advantages of conditional array formulas

Introducing conditional array formulas
All these advantages of conditional array formulas in mind teachers have to find suitable spreadsheet tables to introduce this concept to their students and provide examples and opportunities to practice these formulas. Tables of different content downloadable from the Internet or provided by other subjects of the students will serve well in spreadsheet environment.
In my presentation I would like to give a detailed description of the method of introducing conditional array formulas, how to build them, how to expand them to the different requirements of the user. Beyond that I would like to present tables of different content yield to the very same array formulas, so both teachers and students have the opportunity to select tables to their interest and find solutions to problems using conditional array formulas. Testing studentsâ€™ results using conditional formulas it was found that they are more convinced and build algorithms with more confidence using array formulas than using the traditional built-in conditional functions. These tests seem to prove that teaching the concept of array formulas from the very beginning of spreadsheet studies would result in better understanding of spreadsheet applications, especially conditional functions, than exclusively using the built-in functions.
@InProceedings{CSERNOCH2012INT,
author = {Csernoch, M.},
title = {INTRODUCING CONDITIONAL ARRAY FORMULAS IN SPREADSHEET CLASSES},
series = {4th International Conference on Education and New Learning Technologies},
booktitle = {EDULEARN12 Proceedings},
isbn = {978-84-695-3491-5},
issn = {2340-1117},
publisher = {IATED},
location = {Barcelona, Spain},
month = {2-4 July, 2012},
year = {2012},
pages = {7270-7279}}
TY - CONF
AU - M. Csernoch
TI - INTRODUCING CONDITIONAL ARRAY FORMULAS IN SPREADSHEET CLASSES
SN - 978-84-695-3491-5/2340-1117
PY - 2012
Y1 - 2-4 July, 2012
CI - Barcelona, Spain
JO - 4th International Conference on Education and New Learning Technologies
JA - EDULEARN12 Proceedings
SP - 7270
EP - 7279
ER -
M. Csernoch (2012) INTRODUCING CONDITIONAL ARRAY FORMULAS IN SPREADSHEET CLASSES, EDULEARN12 Proceedings, pp. 7270-7279.
User:
Pass: