Tag: OpenOffice Calc
Articles tagged as: OpenOffice Calc.
LibreOffice and OpenOffice looks and functions almost similar. They even have the same set of names for their programs: Writer, Calc, Impress, Base, Draw and Math. Allow me to clarify what’s the difference and what’s the connection between these two free and open source office suites.
Part V of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This post is about formatting date and time as seen in the cells. Format codes that are used in date and time is discussed extensively in this entry.
Part IV of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This entry is about formatting currency or money. The red and other color(s) formatting for negative numbers is also discussed in this post.
Part III of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This entry is about formatting cell data as fractions, percentages and scientific notations.
Part II of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This entry is about formatting numbers in general and the meaning of Format code made of zeroes and hashes. Also discussed are the different formats of thousands separator and decimal marker.
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.