TaylorS+KadeB+ss2+module

=//Spread Sheet 2 Module// = **Texas essential knowledge & skills Technology Applications Correlation**  **One primary goal in developing training modules for classroom teachers was to build their technology competencies as described in the Technology Application TEKS through the 8th grade level. Obtaining this goal will better prepare the classroom teacher to incorporate these skills into their curriculum and instructional strategies. The Spreadsheet 2 Module incorporates and introduces the following knowledge and skills, as outlined in the Texas Essential Knowledge and Skills for Technology Applications, k-5.** **K-5 TEKS**  ** 6-8 TEKS  **   ** spreadsheet 2 Portfolio Requirements ** **  Product frm Module:  ** **  Complete the Module Activities  ** **  At the competion of this lesson you will be able to design and setup a chart or pictograph for your classroom use. Save a digital version for your portfolio. ** ** Response in Journal:  ** **  Read the article, "partners in learning: Twelve Ways Technology Changes The Teacher-Student Relationship" and answer the following questions 1. In what ways does the article suggest that teachers learn how to integrate computers into their classroom? 2. List 4 of the Key Rhemes and describe how they are actualized in your classroom. 3. Specifically, what does the article say about "one-computer" classrooms? 4. Save your answers in a file called Solving.doc in your portfolio on the network. ** ** Applied Example:  ** **  learners will create a merged spreadsheet and word processing document related to student learning. ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">** Pre/Post Checklist:  ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">**  include your Pre/Post Checklist with your portfolio. ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">** Spreadsheet 2 Checklist  ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">**  Please use this checklist to monitor yourself throughout this training. Before beginning, pleas go down the "Pre" column check each Excel Spreadsheet 2 skill whick you have already mastered. At the end of the training, check the skills you have in the "post" column. Save in your Portfolio under the name Spread2_Check.doc ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">  Spreadsheet 2 using Microsoft Excel<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 1. Open the Microsoft Excel application.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 2. Create a spreadsheet containing the following information.
 * <span style="font-size: 120%; font-family: 'Arial Black', Gadget, sans-serif;">**(2) Foundations. The student uses data input skills appropriate to the task.**
 * <span style="font-size: 120%; font-family: 'Arial Black', Gadget, sans-serif;">  ** <span style="font-family: 'Arial Black', Gadget, sans-serif;">7) solving problems. The student uses appropriate computer-based productivity tools to create and modify solutions to problems  **
 * <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">** <span style="font-family: 'Arial Black', Gadget, sans-serif;">the student is expected to: (B) use appropriate software, including the use of work proccessing and multimedia, to express ideas and solve problems.   ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">  <span style="font-family: 'Arial Black', Gadget, sans-serif;">
 * <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">** <span style="font-family: 'Arial Black', Gadget, sans-serif;">(8) Solving Problems. The student uses research skills and electronic communication, with appropriate supervision, to create new knowledge   ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">**  <span style="font-family: 'Arial Black', Gadget, sans-serif;">the student is expected to: (B) use electronic tools and research skills to build a knowledge base regarding a topic, task, or assignment.   ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">  <span style="font-family: 'Arial Black', Gadget, sans-serif;">
 * <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">** <span style="font-family: 'Arial Black', Gadget, sans-serif;">(9) Solving Problems. The student uses Tech. apps. to faciliate evaluation of work, both process and product   ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">**  <span style="font-family: 'Arial Black', Gadget, sans-serif;">The student is expected to: (B) use software features, such as slide show previews, to evaluate final product.   ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">  <span style="font-family: 'Arial Black', Gadget, sans-serif;">
 * <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">** <span style="font-family: 'Arial Black', Gadget, sans-serif;">(10) Communication. The student formats digital information for appropriate and effective communication.   ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">**  <span style="font-family: 'Arial Black', Gadget, sans-serif;">The student is expected to: (C) use appropriate applications including, but not limited to, spreadsheets and databases to develop charts and graphs by using data from various sources.   **
 * <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">** 4) information acquisition. The student uses a variety of strateies to aquire information from electronic resources, with appropriate supervision.  ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">**  The student is expected to: (B) apply appropriate electronic search strategies in the acquisition of information including keywork and Boolean search strategies.  ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">
 * <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">** (7) Solving problems. The student uses appropriate computer-based productivity tools to create and modify solutions to problems  ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">**  The student is expected to: (B) create and edit spreadsheet documents using all data tpes, formulas and functions, and chart information;  ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">
 * <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">** (8) Solving Problems. The student uses research skills and electronic communication, with appropriate supervision, to create new knowledge.  ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">**  The student is expected to: (E) integrate aqcuired technology applications skills, strategies, and use of the work processor, database, spreadsheet, telecommunications, draw, paint, and utility programs into the foundation and enrichment curricula.  ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">
 * <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">** 10) Communication. The student formats digital information for appropriate and effective communication.  ** <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;">**  The student is expected to: (C) create a variety of spreadsheet layouts containing descriptive labels and page settings; (D) demonstrate appropriate use of fonts, styles, and sizes, as well as effective use of graphicsand page design to effectively communicate;and (D)Match the chart style to the data when creating and labeling charts. (E) (D) demonstrate appropriate use of fonts, styles, and sizes, as well as effective use of graphics and pagedesign to effectively communicate  **



3. Widen Column A and column E so that all contents are visible.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 4. Place your cell pointer in cell B7. Instead of manually keying a formula to calculate the total number of visitors per day, use the AutoSum function from the toolbar.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 5. Confirm the formula of SUM (B3:B6) by pressing <Enter>.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 6. Highlight Cells B7 through D7.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 7. Choose the <Edit> menu.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 8. Choose <Fill> and <Right>.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 9. Place your cell pointer in cell E3. Now we are going to calculate the average number of visitors per animal.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 10. Choose the menu, then <Function>.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 11. For the Function name choose <AVERAGE>. Ten click <OK>.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 12. A dialog box opens up. Click <OK> to confirm that the range of cells to be averaged is B3:D3.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 13. Highligh Cells E3 through E6.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 14. Choose the <Edit> menu.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 15 Choose <Fill> and <Down>.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> Formatting Numbers<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 1. With cells E3 through E6 highlighted, choose the <Format> menu, then .<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 2. Choose the <Number> tab and choose <Number> as the category.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 3. Set the decimal places to 0. Then click <OK>.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> Formatting the Title<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 1. Highlight Cells A1 through E1.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 2. Choose <Format> and <Cells>.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 3. Choose the <Alignment> tab.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 4. Choose <Center Across Selection> as the <Horizontal Text alignment>. Then click <OK>.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 5. Change the type size of your title to 14 pts.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 6. Choose <File> and <Save As>. Type ZOO as the filename. Make sure you save to your network folder.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> Creating a Graph Using information from the Spreadsheet<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 1. Highlight Cells E3 through E6.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 2. Choose <Insert> and <Chart>.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> <span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 3. Choose the <Standard Types> tab. Choose <Column> as the Chart type.<span style="display: block; font-size: 110%; font-family: 'Arial Black', Gadget, sans-serif; text-align: center;"> 4. Click <Next>. 5. Choose the <Data Range> tab. Set the <Series in:> to <Rows>.4.

6. Click <Next>. 7. Choose the <Titles> tab. Type "Houston Zoo Visitation" as the <Chart title>. 8. Type "Avg. No. Visitors/Animal" as the <Value (Y) axis>. 9. Now choose the <Legend> tab and deselect.

10. Click <Next>. 11. For the <Place chart:? choose <As new sheet:>. 12. Click <Finish>.

Editing Text within a chart 1. Click on the title of the Chart "Houston Zoo Visitation" to highlight it. 2. Move your cursor to the end of the line and press Enter. Type "April 10-12". 3. Click somewhere in the unhighlighted area. 4. Save the changes made to your file. Making a Pictograph from your Chart 1. Click on the first bar to select the series representing rabbits. 2. Choose <Format> and <Selected Chart area>. 3. Choose the <Patterns> tab and then <Fill Effects>. 4. Choose, <Picture>, then <Clipart>. 5. Now it is time to locate the picture of a rabbit. click on <Clipart>, then try to find a rabbit. If you do not have a rabbit, choose another animal. 6. Repeat steps 1-8 for each of the other animals (sharks, turtles, and lions). 7. Save the Changes made to your file. 8. Minimize Excel. Merging a Spreadsheet with a word processing Document 1. Create a new word processing document in Microsoft Word. 2. Change the top margin to 2", To do this, choose <File>, <Page setup> then the <Margins> tab. Set the top margin to 2". Then coose <OK>. 3. Key in the following letter. it should look exactly like this one on a page. April 15, 1998

Dear parents, We have been studying animals in Science. As you know, last Tuesday your child visited the Houston Zoo as part of our animals unit. Part of their assignment was to record how many people visited the rabbits, sharks, turtles, and lions over an average weekend. When we returned to school, each student prepared a chart representing this info. I am enclosing your child's chart so you can see what a great job he/she has been doing in Science! sincerely,

Your Name Here, Science Teacher.

4. Choose <File> and <Save As>. Type ZOO as the filename. Make sure you save to your network folder. Now you have 2 documents called ZOO. One is a spreadsheet and one is a word processing document. 5. After the last line of your letter, insert a page break so that we can place the chart on the second page. To do this, choose <Insert> then <Break> then <Page Break>. Now we are going to copy and paste our spreadsheet chart onto the second page of our word processing document. 6. Minimize Word. 7. Maximize Excel. 8. Click in the chart area to select the chart and then go to <Edit> <Copy> or choose <Copy> from the toolbar. 9. Maximize Word. 10 Make sure your curser is at the top of the second page. Choose the <Edit> menu then <Paste> or choose <Paste> from the toolbar. 11. Go to print preview and you will see that the second page will look like this: Notice that the chart is not centered. We need to do that. 12. Close out of Print Preview. 13. Click on the chart to select it. Drag it to the center of the page so that it looks like this when you preview it: 14. Save the changes you have made to your file. 15. Fill out your post evaluation Checklist and resave it in your portfolio. 16. You will need to implement spreadsheets using graphs or pictographs within the next 2 weeks of school. After implementing, fill out the and save those in your network portfolio. 