Preface
From Compsci1
| Line 1: | Line 1: | ||
===LEARNING OUTCOMES=== | ===LEARNING OUTCOMES=== | ||
| - | In Lesson 4 you created a grade sheet for a class of 4th graders based on a template you had put together at the beginning | + | In Lesson 4 you created a grade sheet for a class of 4th graders based on a template you had put together at the beginning of the same lesson. You learned that you can easily adapt a template for use with other classes that you might teach. You learned about the organization of spreadsheets. You learned about rows and columns, and the cells at the intersection of those rows and columns. You learned how to select cells and how to address cells using row and column coordinates. You learned how to enter formulas into certain cells in order to have Excel do calculations for you--totals and percentages in |
| - | + | ||
| - | of the same lesson. You learned that you can easily adapt a template for use with other classes that you might teach. You | + | |
| - | + | ||
| - | learned about the organization of spreadsheets. You learned about rows and columns, and the cells at the intersection of | + | |
| - | + | ||
| - | those rows and columns. You learned how to select cells and how to address cells using row and column coordinates. You | + | |
| - | + | ||
| - | learned how to enter formulas into certain cells in order to have Excel do calculations for you--totals and percentages in | + | |
| - | + | ||
particular. | particular. | ||
| - | :You filled the rows and columns with labels and grades. You had a first introduction to the idea that a spreadsheet can be | + | :You filled the rows and columns with labels and grades. You had a first introduction to the idea that a spreadsheet can be a powerful tool for handling numeric data that requires mathematical or statistical processing. |
| - | + | ||
| - | a powerful tool for handling numeric data that requires mathematical or statistical processing. | + | |
:In this tutorial you will have the opportunity to reinforce what you learned in Lesson 4. At the same time you will learn | :In this tutorial you will have the opportunity to reinforce what you learned in Lesson 4. At the same time you will learn | ||
| + | how to maintain a spreadsheet. This you will do by making enhancements to the spreadsheet you created in Lesson 4. You will also learn about some of the logical processing capabilities of spreadsheets, capabilities which enable you to give an "intelligent" flavor to the applications that you build. In particular, you will learn about the following | ||
| - | + | *features of the Excel spreadsheet. | |
| - | + | **Recapitulation and Reinforcement | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | features of the Excel spreadsheet. | + | |
| - | *Recapitulation and Reinforcement | + | |
Revision as of 16:36, 3 October 2006
LEARNING OUTCOMES
In Lesson 4 you created a grade sheet for a class of 4th graders based on a template you had put together at the beginning of the same lesson. You learned that you can easily adapt a template for use with other classes that you might teach. You learned about the organization of spreadsheets. You learned about rows and columns, and the cells at the intersection of those rows and columns. You learned how to select cells and how to address cells using row and column coordinates. You learned how to enter formulas into certain cells in order to have Excel do calculations for you--totals and percentages in particular.
- You filled the rows and columns with labels and grades. You had a first introduction to the idea that a spreadsheet can be a powerful tool for handling numeric data that requires mathematical or statistical processing.
- In this tutorial you will have the opportunity to reinforce what you learned in Lesson 4. At the same time you will learn
how to maintain a spreadsheet. This you will do by making enhancements to the spreadsheet you created in Lesson 4. You will also learn about some of the logical processing capabilities of spreadsheets, capabilities which enable you to give an "intelligent" flavor to the applications that you build. In particular, you will learn about the following
- features of the Excel spreadsheet.
**Recapitulation and Reinforcement
