IM Alg1.1.7 Lesson: Spreadsheet Computations

A person walks 4 miles per hour for 2.5 hours. How far do they walk?
A rectangle has an area of 24 square centimeters. What could be its length and width?
What is the area of this triangle?[br][img]data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAIgAAABwCAYAAADFezgmAAAJ+UlEQVR4Ae2cechNTxjH7fte9n1fQ5F9jxARiWyRJbKERMhSZEuWZC1rIaQIxR+2/MEfiiIhRAklWSP78+s7P/N23ffcOefcOdt9n2fqdO89c+bMPN/53Jln5sycQiRBFDAoUMgQJ1GiAAkgAoFRAQHEKI9ECiDCgFEBAcQoj0QKIMKAUQEBxCiPRAogwoBRAQHEKI9ECiDCgFEBAcQoj0QKIMKAUQEBxCiPRAogwoBRAQHEKI9ECiDCgFEBAcQoj0QKIMKAUQEBxCiPRAogwoBRAQHEKI9Esgbk/fv31L59eypUKL8Mq1atUucR53RcvXqVBT35lWFhNhEquFKlSlSxYkVHQJ49e6auwXWphwYH8RwCS0BQuWgVDh48SLrCvVZ27969adKkSV4vz/nrWAKCWkP3guAHkDt37iiw8MklsAVEV7AfQNByoAXhFASQv86oW6XrbomLc6r1EEA8AoLWo379+lo3Np8CiAdA4K9op5YNGX8NFUA8AAI/BcNhjkEAcQEErQfmSwAJxyCAuACiWw89LOYGCXtAMFlmGrrCOeXaeuDPwB4Qbi2CX3sFEL+KMbteAGFW4X7NDRyQbdu2UZ8+fWjIkCF0/Phxv+WR6y0UuHHjBo0fP546d+5MS5YsoR8/fljc7f+kgQKydOlSNaGUun7i6NGj1oWUG7gr8ODBAypWrNg/+g8ePNg9ocsVgQJSuXLlfwoIUBo1aqRGARgJyBGeBhiJpf4x9fe7d++6IGCODgyQP3/+UOHChfMVskKFCmoYCQPkCEeDnj175tNdA3Lz5k0zAS6xgQGCfND/6YLpz40bN7oUQaKzVeDbt2+0a9cuaty4cT7doX/Lli2zvXVeukAB+fLlC02YMIGKFi2qjipVqhBaFgnBKvDhwwdas2YNVatWjYoUKUIjR46k27dv0+7du/Ng6devnzpnm3OggKQW5siRI4rq06dPp56W7xYKvHz5kubPn09ly5alEiVK0LRp0+jp06f57oiWJagQGiC/f/+mBg0aUMeOHYMqK9v73L9/nyZOnKhGKfDpFi1aRK9fv45Ej9AAQel37typWpFr165FYkxBywS6YagKf6JGjRq0fv16+vjxY6RmhgrI9+/fqWrVqjRo0KBIjcrlzOCznTp1ijp16qTAaNKkCe3du5egZRwhVEBg0Nq1a5Wh9+7di8O+nMkTAACEpk2bKr06dOhAJ0+ejN3JDx2QT58+Ufny5Wns2LE5U1lRFhRdxrp166h69eoKjAEDBtClS5eiLIIxr9ABQe6LFy9WwzEuu9GMiv+NxIhk4cKF6s+DaYHRo0eT7aynl3z9XhMJIG/evFHDslmzZvktX4G7/uHDh2pnXvHixalUqVI0c+ZMev78eWLtjAQQWD9jxgwFCWDhGK5fv05Dhw5VjyOwxnXZsmX09u3bxEsRGSDoXjDrt3z58sSLElQBMSLBRGHXrl2Vf1G7dm3atGkTff78OagsQr9PZIDAkjFjxhCe+H79+jV0w+LMAOsw9u3bR82bN1dgtGjRgvbv3x/I+oyo7bICBJuYsThIP5jDuzZMU+sY6uLazZs3R21nJPlhRLJhwwaqWbOmsrNLly5Kj1x+HpU1IOgy0Jdi1Te+48B6DwBg2r+KSbNatWrRz58/I6m0KDLBtDemvzENDvsx+1lQZo+zBmTr1q2Ou83atWtn3CYA4SDigQMHoqi7UPN4/PgxTZkyRTnfWM2F5Q54blKQQtaAoCtBRadvKMIGZ8BjCniA16xZs9hnCU1lNMXdunWLhg8frkYkZcqUoTlz5tCLFy9MSXI2LmtAYDFaC/gg6F4AyuTJk9W5dGjS1Tlz5oyCy+SvpKeJ+zf8iLNnz1L37t1V2bHWZeXKlfTu3bu4ixZq/laAAAS9FhL+CP5VbnDAGoiNFiQXlgJgRILusFWrVgqMevXqEVbuY3EUh2AFyLx585QfAucUziq6HCxo8RIOHz6srk+qM4e5CsxZYO4CdrVu3ZpQ5oLkXHupp6wB0U5q6vu68B2vSQAwbgFCYzSTtKUAmOnFnhL99sMePXrQuXPn3MwpsPFZA4KuBS1IegAcWEnmJWzfvl39O5OwFABL96ZPn04lS5ZUzuewYcMIzij3EAogcF69BMyoYmZ13LhxXi4P5RpAMGLECPUYAA/Q0FXigZqE/xXIGhC8NgF986FDh/K0xASZ35etrF69OpalAOfPn6devXopG8qVK0cLFiwgPIIPOsBph5/l5LzrOMSnHqnddtDl8Xu/rAFBRuhOdF8NWLz6H6mFxDCxdOnSNHv27NTT/3wHeBhC2woHvweOZps2bRQYWA4JQLGNIIyA8upXfTvNLuMcdEvfUObUdYdRPi/3tALESwZersHCGSzjT59TwDxJ6rMer75Nep4Ykm7ZsoXq1q2rKqRhw4a0Y8cOCnJ7QHqeaGF1awoInADBNUl/c2IiAEHTjqlqvRQAwgEGCAsB8RtHJqHTK0f/xnoLrLvQe4bhGx07dox+/fqlLwntE76MngjMVG60wGg9khwSAQgEmjp1qtoQBCAgKITTAmsBEYcWxS1gRIIFSlixhXshzYULF9yShRYvgAQg7aNHj9TwEv6BU3OMLNxaEWw/HDVqlHJ6U7ckBlA8q1tkAgStDFpKAIwDflaq02+VaUCJE9OCwB5UrttSAKdWBK1D3759VWth2pIYkGa+b5MJEPwR0M3gwMSjnpkGKEkJiQJELygyLQWAkBD8yZMnhP2/bdu2Vb+j3pLopwIzAeJ0Dz2yydSKOqUJ81yiAIGh/fv3Ny4FePXqlfItMHcB4ePakuinUvwAgvtmM13gpzx+rk0cIJcvX1YVP3fuXMLrq/RTU4xIVqxYQXjMDsHx5qI9e/bEtiXRl8gZhrmZ7gH74G8lISQOkIsXLyonEyLhwI4zLHbGZBp+J2VLop/KQ7mdugyso0kP+iGoU1z6tVH8Thwg3bp1UyBoQPTnwIEDCa1LLoZMgOA8Ri9YIoEDs67oXpLSekDrxAGCbYgaCv1Zp06dXOQir8wYpTi1CDiHFiN1JOP0zCbvRjF8SRwgTi9kw2JgCfEokDhArly5kjc1jhYEL2jDO0AlxKNA4gCBDNiAdOLEiZzfdBRPlQabayIBCdZEuZuNAgKIjXoM0gogDCrZxkQBxEY9BmkFEAaVbGOiAGKjHoO0AgiDSrYxUQCxUY9BWgGEQSXbmCiA2KjHIK0AwqCSbUwUQGzUY5BWAGFQyTYmCiA26jFIK4AwqGQbEwUQG/UYpBVAGFSyjYkCiI16DNIKIAwq2cZEAcRGPQZpBRAGlWxjogBiox6DtAIIg0q2MVEAsVGPQVoBhEEl25gogNioxyCtAMKgkm1MFEBs1GOQVgBhUMk2JgogNuoxSCuAMKhkGxMFEBv1GKT9DydrB73oi64dAAAAAElFTkSuQmCC[/img][br]
Use a spreadsheet (below) to compute each of the following. Type each computation in a new cell, instead of erasing a previous computation.
[table][tr][td][math]\bullet[/math] [math]2+7[/math][br][/td][td][math]\bullet[/math] [math]\frac{1}{7}\text{ of }91[/math][/td][/tr][tr][td][math]\bullet[/math] [math]2-7[/math][/td][td][math]\bullet[/math] [math]0.1\cdot2+3[/math][/td][/tr][tr][td][math]\bullet[/math] [math]7\cdot2[/math][/td][td][math]\bullet[/math] [math]0.1(2+3)[/math][/td][/tr][tr][td][math]\bullet[/math] [math]7^2[/math][/td][td][math]\bullet[/math] [math]13\div\frac{1}{7}[/math][/td][/tr][tr][td][math]\bullet[/math] [math]7\div2[/math][/td][td][math]\bullet[/math] The avarage of [math]2,7,8,[/math] and [math]11[/math][/td][/tr][/table]
Use the spreadsheet below:
Type any number in cell A1, and another number in cell A2. Then in cell A3, type =A1+A2. What happens?[br]
[list][*]In cell A4, compute the product of the numbers in A1 and A2.[/*][*]In cell A5, compute the number in A1 raised to the power of the number in A2.[/*][*]Now, type a new number in cell A1. What happens?[/*][/list]
[list][*]Type a new number in cell A2. What happens?[/*][*]Use nearby cells to label the contents of each cell. For example in cell B3, type "the sum of A1 and A2." (This is a good habit to get into. It will remind you and anyone else using the spreadsheet what each cell means.)[/*][/list]
Use the spreadsheet below. For each problem:
[list][size=150][*]Estimate the answer before calculating anything.[/*][*]Use the spreadsheet to calculate the answer.[/*][*]Write down the answer and the formula you used in the spreadsheet to calculate it.[/*][/size][/list]
[list][/list]The speed limit on a highway is 110 kilometers per hour. How much time does it take a car to travel 132 kilometers at this speed?[br]
In a right triangle, the lengths of the sides that make a right angle are 98.7 cm and 24.6 cm. What is the area of the triangle?[br]
A recipe for fruit punch uses 2 cups of seltzer water, [math]\frac{1}{4}[/math]  cup of pineapple juice, and  [math]\frac{2}{3}[/math] cup of cranberry juice. How many cups of fruit punch are in 5 batches of this recipe?
[size=150]Check in with a partner and resolve any discrepancies with your answer to the last question. Next, type [math]2,\frac{1}{4},\frac{2}{3}[/math] and [math]5[/math] in separate cells. (You may find it helpful to label cells next to them with the meaning of each number.) In a blank cell, type a formula for the total amount of fruit punch that uses the values in the other four cells. Now you should be able to easily figure out:[br][br][/size]How much in 7.25 batches?
How much in 5 batches if you change the recipe to 1.5 cups of seltzer water per batch?[br]
Change the ratio of the ingredients in the fruit punch so that you would like the flavor. How many total cups are in  batch?[br]
Close

Information: IM Alg1.1.7 Lesson: Spreadsheet Computations