Tools

Articles under category: Tools.

Formatting cell data in spreadsheet part III: decimal digits and thousand separators

Configure the decimal digit settings and thousand separator symbols in Calc, Excel, and Sheets using a combination of hash and zeroes in the custom number format.

[ No Comments ] Posted by Greten on 17 May 2020 under Tools

A very long number written along a spiral.

Formatting cell data in spreadsheet part II: number of digits

Part II of serial post about formatting cell data in spreadsheet programs Calc, Excel, and Sheets. This entry is about formatting numerical data to restrict the number of digits in both sides of the decimal separator leading to the occasional use of leading and trailing zeroes.

[ No Comments ] Posted by Greten on 25 Apr 2020 under Tools

an abacus, a useful representation of real numbers

Formatting cell data in spreadsheet software programs

Part I of serial post about formatting cell data in spreadsheet applications LibreOffice Calc, Microsoft Excel, and Google Sheets. This is the introduction part and also covers how to select cells to be formatted and how to open the Format Cells option window.

[ No Comments ] Posted by Greten on 29 Mar 2020 under Tools

Animation effects: how to animate objects in Adobe Captivate?

You can animate slide objects in Captivate. There are basic, emphasis, entrance, exit, and motion path animations. An object can also have two or more animations happening on different parts of the timeline or at the same time.

[ No Comments ] Posted by Greten on 07 Mar 2020 under Tools

Captivate logo inside a film.

How to insert audio in a Captivate lesson?

Adobe Captivate allows the inclusion of audio to elearning lessons. This entry covers how to add narration, sound effects, and background music to your learning modules using Captivate.

[ No Comments ] Posted by Greten on 07 Jan 2020 under Tools

Icon for Captivate audio, a yellow rectangle with CP in the middle, and audio waves below.

Quick image tricks and techniques in Captivate

A handful of random techniques on working on Captivate images that I took note as I work: pasting an image as a slide object from a selection in an image editor, replacing several instances of the same image at once, and pasting an image as a background.

[ No Comments ] Posted by Greten on 01 Dec 2019 under Tips, Tools

A close-up view of a keyboard, showing the green enter key replaced with a Captivate logo key. The other keys are white.

Grouping objects in Adobe Captivate

Grouping objects is one of the most useful features of Captivate. You can group so the collection of objects can behave and can be adjusted as one object. You can group and ungroup objects, apply effects on groups, and configure the timeline of a group.

[ No Comments ] Posted by Greten on 19 Oct 2019 under Tools

Spreadsheet problem generator part IV: formatting date and time

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.

[ 2 Comments ] Posted by Greten on 20 Sep 2019 under Tools

Spreadsheet problem generator part III: concatenate cells with special number format

When you concatenate text and cell references to construct a spreadsheet word problem, the cell format from the cell source does not carry over to the concatenated text. You need to format the data from the cell references using the TEXT function.

[ No Comments ] Posted by Greten on 11 Aug 2019 under Tools

Spreadsheet floating on abyss of 1s and 0s with golden 20% and 1,000,000 pesos on top.

Hide and lock: working on several slide objects in Captivate

Use the yellow dots on the left part of the timeline to make the objects locked or hidden. This will allow you to temporarily ignore the objects that are not your current concerns while you can focus on particular slide objects that you need to move or modify.

[ No Comments ] Posted by Greten on 28 Jul 2019 under Tools

Row of dots in timeline used to lock or hide objects.

« Previous Entries

Instructional design and educational technology for effective learning