Spreadsheets: A Tool for e-Learning — A Case of Matrices in Microsoft Excel

Chaamwe, Nchimunya; Shumba, Langstone

doi:10.7763/ijiet.2016.v6.753

Cited by 4 publications

(3 citation statements)

References 6 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Let us note that Drier (2001) already points out that MS Excel can be used successfully while solving the so-called open-ended problems. Chaamwe and Shumba (2016) The following conclusions based on experiments are presented about the strategy systematic experimentation by Doorman et al (2013).…”

Section: Problem Solving Heuristic Strategies and Technological Devicesmentioning

confidence: 97%

Technological devices in the development of pupils’ expertise in the use of selected heuristic strategies

Eisenmann,

Novotná,

Přibyl

2022

AUPC

View full text Add to dashboard Cite

This paper shows how technological devices can be integrated into the pupils’ use of four selected heuristic strategies in mathematical problem solving: Systematic experimentation, Introduction of an auxiliary element, Analogy, Solution drawing. Our research examined change in the pupils’ success rate and their attitude to problem solving as a consequence of being taught the four selected heuristic strategies while using technological devices actively. A statistically increased success rate of problem solving and a statistically significant decline in the frequency of the number of ‘no response’ cases (the solver does not start to solve the problem) were expected. The study was carried out about by 342 pupils from the 13-17 age group in the Czech Republic. The results of the study show the pupils’ success rate in the solution of problems effectively solvable using the strategies systematic experimentation and solution drawing improved significantly if the use of these strategies went hand in hand with the active use of technological devices. The number of ‘no response’ decreased significantly.

show abstract

Section: Problem Solving Heuristic Strategies and Technological Devicesmentioning

confidence: 97%

Technological devices in the development of pupils’ expertise in the use of selected heuristic strategies

Eisenmann,

Novotná,

Přibyl

2022

AUPC

View full text Add to dashboard Cite

show abstract

“…On the other hand, there are some teachers who realize that the use of Kahoot as a learning medium can provide experiences for the students with diverse interesting animations. Even so, the students deal with problems with regard to accessibility to ICT resources and lack of service-training opportunities (Chaamwe & Shumba, 2016).…”

Section: Teachers' Perceptions Of the Use Of Edutainment Teaching Med...mentioning

confidence: 99%

Kahoot: Is It Efective for Online Learning in Indonesia?

Pratama¹,

Faizah²,

Ramadhan

2022

Supermat

View full text Add to dashboard Cite

Kahoot, as technology integration in education, is quite populer presently in instructional Media. However, not many studies have used it to facilitate online learning. This work attempt to describe a Platform Kahoot yang to be able to facilitate an online learning. Two hundred and fourty two students (M = 12.8; SD = 0,4 year) and 32 mathematics teachers (M = 34; SD = 0,4) from Indonesian school were randomly allocated to participated in this action research. A total of 2 types of questionnaires were used in this study, namely teacher questionnaires and student questionnaires. The results of the study show that the majority of students and teachers have a positive perception of using Kahoot media (in the questionnaire phase). In addition, through the Kahoot media in online learning, the achievement of students' cognitive aspects (in the test phase) also obtained positive results. So the overall results show that the Kahoot media is effective in accompanying students to learn online.

show abstract

“…Di antara penelitian dan artikel-artikel yang membahas tentang pemanfaatan excel dalam kegiatan pembelajaran adalah Visual Basic Application pada excel untuk mengembangkan kemampuan siswa (Bernard & Senjayawati, 2019), pembelajaran terkait matriks (Chaamwe & Shumba, 2016), perkuliahan optimisasi (Chaerani et al, 2015), pembelajaran sains (Ibrahim, 2009), pembelajaran matematika bisnis berbasis kalkulus (Liang & Haven, 2008) dan pembelajaran aljabar (Neurath & Stephens, 2006). Penelitian-penelitian tersebut menunjukkan bahwa excel dapat mempermudah pemahaman mahasiswa dan efektif dalam menyelesaikan persoalan matematika.…”

Section: Pendahuluanunclassified

Template Metode Numerik Pada Excel Untuk Menemukan Solusi Dari Persamaan Nonlinier

Rozi

Rarasati

2022

AXIOM

View full text Add to dashboard Cite

Menemukan solusi dari persamaan nonlinier bukanlah hal yang selalu mudah dilakukan secara analitik. Oleh karena itu topik ini dibahas dalam Metode Numerik, dan menyelesaikan masalah matematika dengan metode numerik membutuhkan bantuan komputer. Selama masa pandemi Covid-19, kegiatan pembelajaran Metode Numerik dilakukan secara online di tempat tinggal masing-masing dan tidak bisa memanfaatkan fasilitas kampus seperti laboratorium komputer yang sudah menyediakan software dengan biaya tinggi. Oleh karena itu, penelitian ini bertujuan untuk membuat template untuk mengeksekusi algoritma metode numerik pada excel untuk menemukan solusi dari persamaan nonlinier. Hal ini dikarenakan excel adalah suatu aplikasi yang sangat mudah diakses di masa ini, bahkan melalui smartphone. Melalui template ini pula, mahasiswa menjadi lebih paham tentang penggunaan formula di excel dan lebih menguasai algortima metode numerik. Penelitian ini menerapkan model penelitian pengembangan. Hasil dari penelitian ini adalah adanya template untuk mengeksekusi algoritma metode numerik pada excel, khususnya untuk menemukan solusi dari persamaan dengan satu variabel. Selain itu mahasiswa memperoleh pemahaman yang sangat baik terkait algoritma metode numerik serta keahlian dalam pemanfaatan excel. Sehingga dapat disimpulkan bahwa metode numerik juga dapat dieksekusi pada aplikasi yang sangat mudah diakses oleh civitas akademika, yaitu pada excel. Seluruh mahasiswa mengaku bahwa penerapan algoritma metode numerik di excel dirasa perlu.AbstractSolving non-linear equations is not always an easy thing to do. Mathematical problems related to non-linear equations can be solved by using numerical methods, and this involves the use of computers. During the Covid-19 pandemic, the numerical method was carried out online without using campus facilities such as computer laboratories equipped with tools and software. Therefore, this study aims to create a template for executing numerical methods with algorithms in Microsoft Excel to find solutions to nonlinear equations. This is because Excel is an application that is user-friendly and accessible nowadays, even on smartphones. Through this template, students become more aware of the use of formulas in excel and better master the algorithms of numerical methods. This study applies a development research model. The result of this study is a template for executing numerical method algorithms in Ms. Excel, especially for finding solutions to equations with one variable. In addition, students gain a very good understanding of numerical method algorithms as well as expertise in using Microsoft Excel. Thus, numerical methods can also be executed on applications that are very easily accessible to the academic community, namely Microsoft Excel. All students admitted that the application of numerical methods with algorithms in Microsoft Excel is necessary.

show abstract

Spreadsheets: A Tool for e-Learning — A Case of Matrices in Microsoft Excel

Cited by 4 publications

References 6 publications

Technological devices in the development of pupils’ expertise in the use of selected heuristic strategies

Technological devices in the development of pupils’ expertise in the use of selected heuristic strategies

Kahoot: Is It Efective for Online Learning in Indonesia?

Template Metode Numerik Pada Excel Untuk Menemukan Solusi Dari Persamaan Nonlinier

Contact Info

Product

Resources

About