Spreadsheet Conditional Formatting Illuminates Investigations into Modular Arithmetic

Miller, David & Sugden, Stephen (2011) Spreadsheet Conditional Formatting Illuminates Investigations into Modular Arithmetic. In Lau, Mark & Sugden, Stephen (Eds.) Applications of Spreadsheets in Education The Amazing Power of a Simple Tool. Bentham Science Publishers, pp. 64-83.

View at publisher


Modular arithmetic has often been regarded as something of a mathematical curiosity, at least by those unfamiliar with its importance to both abstract algebra and number theory, and with its numerous applications. However, with the ubiquity of fast digital computers, and the need for reliable digital security systems such as RSA, this important branch of mathematics is now considered essential knowledge for many professionals. Indeed, computer arithmetic itself is, ipso facto, modular. This chapter describes how the modern graphical spreadsheet may be used to clearly illustrate the basics of modular arithmetic, and to solve certain classes of problems. Students may then gain structural insight and the foundations laid for applications to such areas as hashing, random number generation, and public-key cryptography.

Impact and interest:

0 citations in Scopus
Search Google Scholar™

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: 73246
Item Type: Book Chapter
Keywords: Modular Arithmetic, Conditional Formatting, HERN
DOI: 10.2174/978160805276911101010064
ISBN: 9781608052769
Divisions: Current > Schools > School of Mathematical Sciences
Current > QUT Faculties and Divisions > Science & Engineering Faculty
Deposited On: 08 Jul 2014 22:32
Last Modified: 27 Oct 2015 16:06

Export: EndNote | Dublin Core | BibTeX

Repository Staff Only: item control page