Exploring the fundamental theorem of arithmetic in excel 2007

Sugden, Stephen & Miller, David (2010) Exploring the fundamental theorem of arithmetic in excel 2007. Spreadsheets in Education, 4(2), pp. 1-27.

View at publisher (open access)


This paper discusses how fundamentals of number theory, such as unique prime factorization and greatest common divisor can be made accessible to secondary school students through spreadsheets. In addition, the three basic multiplicative functions of number theory are defined and illustrated through a spreadsheet environment. Primes are defined simply as those natural numbers with just two divisors. One focus of the paper is to show the ease with which spreadsheets can be used to introduce students to some basics of elementary number theory. Complete instructions are given to build a spreadsheet to enable the user to input a positive integer, either with a slider or manually, and see the prime decomposition. The spreadsheet environment allows students to observe patterns, gain structural insight, form and test conjectures, and solve problems in elementary number theory.

Impact and interest:

Citation counts are sourced monthly from Scopus and Web of Science® citation databases.

These databases contain citations from different subsets of available publications and different time periods and thus the citation count from each is usually different. Some works are not in either database and no count is displayed. Scopus includes citations from articles published in 1996 onwards, and Web of Science® generally from 1980 onwards.

Citations counts from the Google Scholar™ indexing service can be viewed at the linked Google Scholar™ search.

ID Code: 73177
Item Type: Journal Article
Refereed: Yes
Keywords: Prime Numbers, Factorization, Spreadsheet
ISSN: 1448-6156
Divisions: Current > Schools > School of Mathematical Sciences
Current > QUT Faculties and Divisions > Science & Engineering Faculty
Deposited On: 01 Jul 2014 05:49
Last Modified: 02 Jul 2014 00:21

Export: EndNote | Dublin Core | BibTeX

Repository Staff Only: item control page