Excel and MS Word as Learning Aids NK
   

Excell-At Overview

I will describe Excell-At using Microsoft Excel as an example, but the method can be used with other spreadsheets.

Excell-At uses two tricks:

  1. When a Font Colour and the cell Highlight colour are the same colour, the data in the cell becomes invisible.  In Excel, when you click in such a cell the cell contents appear in the formula bar.

  2.  The formula =Rand() generates random numbers.
    If you have a column of random numbers in a table, then sorting the table on that column shuffles all the rows.

A minimum Excell-At application therefore consists of a table with a header row, and 3 columns:

the random numbers, the questions, and the answers.

This example has 2 answers for each question so there is an extra column.

 

 

To use it

 

  1. Select the answers and change their font color to white.


     

  2. Type =Rand() in cell A2 and drag it to the bottom row of the table.
  3. Look at a question, think about the answer, then click in the answer cell and check the answer in the formula bar.
  4. Repeat (3) with the other rows.
  5. To shuffle the rows
    Click in a cell in column A, then click on one of the sort buttons on the standard toolbar.

 

A useful Excell-At application will contain master-sheets, and quiz sheets and will probably also have many more columns.

 

Excell-At in Real Life discusses practical ways of using the technique.

 

Excell-At Examples contains applications which you can download and store on your own computer.

 

Excell-At for Beginners give detailed instructions for those people who donít understand these instructions or who are not experienced at sorting in Excel.

 

Home
Excell-At-Overview
Which-Word-Overview
Odds-And-Ends
 
Excell-At Overview
Setting up Excell-At
Excell-At in Real Life
Excell-At Examples
Excell-At For-Beginners
 
Which-Word Overview
Which-Word - Details
Which-Word Summary
Word Techniques
Which-Word Resources
 
 

Hit Counter      Home Excell-At Which-Word Odds-And-Ends Contact