click here for the spreadsheet. Teacher begins by reading the following story.
Long ago in India, there lived a raja who believed he was wise and fair, as a raja should be. The people in his province were rice farmers. The raja decreed that everyone must give nearly all of their rice to him. "I will store the rice safely," the raja promised the people, "so that in time of famine, everyone will have rice to eat, and no one will go hungry." Each year, the raja's rice collectors gathered nearly all of the people's rice and carried it away to the royal storehouses.
For many years, the rice grew well. The people gave nearly all of their rice to the raja, and the storehouses were always full. But the people were left with only enough rice to get by. Then one year the rice grew badly and there was famine and hunger. The people had no rice to give to the raja, and they had no rice to eat. The raja's ministers implored him, "Your highness, let us open the royal storehouses and give the rice to the people, as you promised." "No!" cried the raja. How do I know how long the famine will last? I must have the rice for myself. Promis or no promise, a raja must not go hungry!"
Time went on, and the people grew more and more hungry. But the raja would not give out the rice. One day, the raja ordered a feast for himself and his court--as, it seemed to him, a raja should now and then, even when there is famine. A servant led an elephant from a royal storehouse to the palace, carrying two full baskets of rice. A village girl named Rani saw that a trickle of rice was falling from one of the baskets. Quickly she jumped up and walked along beside the elephant, catching the falling rice in her skirt. She was clever, and she began to make a plan.
At the palace, a guard cried, "Halt, theif! Where are you going with that rice?"
"I am not a thief," Rani replied. "This rice fell from one of the baskets, and I am returning it now to the raja."
When the raja heard about Rani's good deed, he asked his ministers to bring her before him.
"I wish to reward you for returning what belongs to me," the raja said to Rani. "Ask me for anything, and you shall have it."
"Your highness," said Rani, "I do not deserve any reward at all. But if you wish, you may give me one grain of rice."
"Only one grain of rice?" exclaimed the raja. "Surely you will allow me to reward you more plentifully, as a raja should."
"Very well," said Rani. "If it pleased Your Highness, you may reward me in this way. Today, you will give me a single grain of rice. Then, each day for thirty days you will give me double the rice you gave me the day before. Thus, tomorrow you will give me two grains of rice, the next day four grains of rice, and so on for thirty day."
"This seems to be a modest reward," said the raja. "But you shall have it."
And Rani was presented with a single grain of rice.
Now, it is the student's job to build a spreadsheet based upon this story to determine the amount of rice given to Rani on any given day. We start the spreadsheet by listing under the heading, "day," 1....30. Then we proceed with the following formula: 2*(previous cell address) and fill down. After each day, read the part of the story that corresponds to that day. (Read the number AFTER they find it using the spreadsheet)
The next day, Rani was presented with two grains of rice.
And the following day, Rani was presented with four grains of rice.
On the ninth day, Rani was presented with two hundred fifty-six grains of rice. She had received in all five hundred and eleven grains of rice, enough for only a small handful. "This girl is honest, but not very clever," thought the raja. "She would have gained more rice by keeping what fell into her skirt!"
On the twelfth day, Rani received two thousand and forty-eight grains of rice, about four handfuls.
On the thirteenth day, she received four thousand and ninety-six grains of rice, enough to fill a bowl.
On the sixteenth day, Rani was presented with a bag containing thirty-two thousand, seven hundred and sixty-eight grains of rice. All together she had enough rice for two bags. "This doubling up adds up to more rice than I expected" thought the raja. "But surely her reward won't amount to much more."
On the twentieth day, Rani was presented with sixteen more bags filled with rice.
On the twenty-first day, she received one million, forty-eight thousand, five hundred and seventy-six grains of rice, enough to fill a basket.
On the twenty-fourth day, Rani was presented with eight million, three hundred and eighty-eight thousand, six hundred and eight grains of rice--enough to fill eight baskets, which were carried to her by eight royal deer.
On the twenty-seventh day, thirty-two brahma bulls were needed to deliver sixty-four baskets of rice. The raja was deeply troubled. "One grain of rice has grown very great indeed," he thought. "But I shall fulfill the reward to the end, as a raja should."
On the twenty-ninth day, Rani was presented with the contents of two royal storehouses.
On the thirtieth and final day, two hundred and fifty-six elephants crossed the province, carrying the contents of the last four royal storehouses--Five hundred and thirty-six million, eight hundred and seventy thousand, nine hundred and twelve grains of rice.
All together, Rani had received more than one billion grains of rice. The raja had no more rice to give. "And what will you do with this rice," said the raja with a sigh, "now that I have none?"
"I shall give it to all the hungry people," said Rani, "and I shall leave a basket of rice for you, too, if you promise from now on to take only as much rice as you need."
"I promise," said the raja. And for the rest of his days, the raja was truly wise and fair, as a raja should be.
Now, have the students add the columns to see how many grains of rice Rani received in all. Have the students graph this relation with Excel. Days = x, grains of rice = y. Ask them if it is a function. Explain that it is an exponential function.
Extension for calculus students: what is the significance of the cumulative amount of rice Rani has received on any given day? Answer: area under the curve. Have them calculate the area over different intervals to check.