Free Instructional Applications
Articles under category: Free Instructional Applications.
Part I of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This is the introduction part and also covers how to select cells to be formatted and how to open the Format Cells option window.
Date and time are information that can appear in word problems but are not readily convertible to numerical data that we can subject in mathematical computation. Of course, we know how to do it. It is one of the daily life tasks that the students need to learn. Constructing a spreadsheet problem generator with date and clock time as given values are a little more complicated than the usual numerical data but very much feasible.
In my previous post, I discussed how to make problem generators using spreadsheet software but did not discuss special formatting requirements such as percentage, currency and units, and other conventions that while easy to write in paper, can be difficult to format in a spreadsheet-based problem generator. While not all mathematical conventions can be readily implemented in a spreadsheet, I discuss in this post how to come close as possible.
Use spreadsheet software such as Open Office Calc or Microsoft Excel to create a word problem for science, mathematics, economics or any other subject that uses word problems in some of its lessons. Then, create similar problems by simply altering certain cells in the spreadsheet without solving the new similar problem from scratch.
GraphCalc is a free and open-source graphing calculator software (FOSS) that is very much useful in producing 2D and 3D function graphs. Even though it was last updated in 2003, it is still very much compatible with operating software as latest as Windows 7. In this article, I discussed the different tips in using it, its limitations and a link to its official website.