Enabling students to make investigations through spreadsheets

Spreadsheets are widely used in education to save time and simulate many scenarios in many different disciplines. However, they are not usually employed to provide rich interactions in the class although they provide huge computational powers and relate data in different places. It is argued in this...

Full description

Bibliographic Details
Main Author: Erol Karakirik
Format: Article
Language:English
Published: McMaster University
Series:Spreadsheets in Education
Online Access:http://sie.scholasticahq.com/article/4639-enabling-students-to-make-investigations-through-spreadsheets.pdf
_version_ 1797967224486494208
author Erol Karakirik
author_facet Erol Karakirik
author_sort Erol Karakirik
collection DOAJ
description Spreadsheets are widely used in education to save time and simulate many scenarios in many different disciplines. However, they are not usually employed to provide rich interactions in the class although they provide huge computational powers and relate data in different places. It is argued in this paper that spreadsheets could also be used as an empowering tool for making inferences in the class by enabling students to investigate an open-ended problem, to make discussions about the problem and to share their results by turning a spreadsheet into an empowering tool. Constructivist approach requires students make conjectures and test them through cognitive tools provided such as Dynamic geometry environments. User could be required to investigate an open-ended problem by the help of available macros or templates provided by the instructor in a spreadsheet. It not only motivates the user to participate in the class but also make them think about the problem at hand. Our approach is exemplified through macros prepared for a math class and divisibility features of binomial coefficients were investigated through spreadsheets in this paper.
first_indexed 2024-04-11T02:27:52Z
format Article
id doaj.art-3e4edd57fc424576899018a54a4dcf20
institution Directory Open Access Journal
issn 1448-6156
language English
last_indexed 2024-04-11T02:27:52Z
publisher McMaster University
record_format Article
series Spreadsheets in Education
spelling doaj.art-3e4edd57fc424576899018a54a4dcf202023-01-02T22:17:07ZengMcMaster UniversitySpreadsheets in Education1448-6156Enabling students to make investigations through spreadsheetsErol KarakirikSpreadsheets are widely used in education to save time and simulate many scenarios in many different disciplines. However, they are not usually employed to provide rich interactions in the class although they provide huge computational powers and relate data in different places. It is argued in this paper that spreadsheets could also be used as an empowering tool for making inferences in the class by enabling students to investigate an open-ended problem, to make discussions about the problem and to share their results by turning a spreadsheet into an empowering tool. Constructivist approach requires students make conjectures and test them through cognitive tools provided such as Dynamic geometry environments. User could be required to investigate an open-ended problem by the help of available macros or templates provided by the instructor in a spreadsheet. It not only motivates the user to participate in the class but also make them think about the problem at hand. Our approach is exemplified through macros prepared for a math class and divisibility features of binomial coefficients were investigated through spreadsheets in this paper.http://sie.scholasticahq.com/article/4639-enabling-students-to-make-investigations-through-spreadsheets.pdf
spellingShingle Erol Karakirik
Enabling students to make investigations through spreadsheets
Spreadsheets in Education
title Enabling students to make investigations through spreadsheets
title_full Enabling students to make investigations through spreadsheets
title_fullStr Enabling students to make investigations through spreadsheets
title_full_unstemmed Enabling students to make investigations through spreadsheets
title_short Enabling students to make investigations through spreadsheets
title_sort enabling students to make investigations through spreadsheets
url http://sie.scholasticahq.com/article/4639-enabling-students-to-make-investigations-through-spreadsheets.pdf
work_keys_str_mv AT erolkarakirik enablingstudentstomakeinvestigationsthroughspreadsheets