# Tag: spreadsheet software

Articles tagged as: spreadsheet software.

### Formatting cell data in Calc part V: date and time

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.

Posted by Greten on 13 Apr 2013 under Tools

### Formatting cell data in Calc part IV: currency or money

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.

Posted by Greten on 13 Apr 2013 under Tools

### Formatting cell data in Calc part III: percentage, fraction and scientific notation

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.

Posted by Greten on 13 Apr 2013 under Tools

### Formatting cell data in Calc part II: numbers

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.

Posted by Greten on 13 Apr 2013 under Tools

### Formatting cell data in Calc spreadsheet

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.

Posted by Greten on 13 Apr 2013 under Tools

### Date and time in spreadsheet problem generator

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.

Posted by Greten on 10 Apr 2013 under Tools

### Formatting the spreadsheet problem generator

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.

Posted by Greten on 17 Mar 2012 under Tools

### Creating your word problem generator using Calc spreadsheet

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.

Posted by Greten on 25 Feb 2012 under Tips

Instructional design and educational technology for effective learning