WordUsing
Word
|
Microsoft Word |
|
|
Now that you have made Tally Sheets, Graphs, saved your data into Excel, made graphs with Excel and saved it, it is time to write about all that work. You will first need to open Excel and Microsoft Word so you can get started writing your report. When you open your graph in Excel it will appear on the page of Excel. Note Example 1 below. You can move the graph on the Excel page by first left double clicking inside the graph then clicking and dragging the graph to where you want it. You can also copy the graph by first, left double clicking within the graph. You will know it is ready to be dragged or copied when you see the corners indicated with small squares. Note Example 2 below.
|
Example 1 |
||
 |
|
Example 2 |
||
|
Note the small squares, one at each corner. |
 |
small squares at the midpoint of each side. |
After left double clicking inside the graph and you see four small squares at the midpoints of the lines and four small squares at the corners of the graph you are ready to copy your graph. At this time, before you copy the graph if you wish to make it larger or smaller you can do so by clicking on any corner and dragging the graph to the desired size. If you click on the midpoint of a line it will also allow you to change the size of the graph but this method will distort the graph. The corners will not distort the shape as the sides stay proportional as the size is increased or reduced or moved. Now that the graph is the desired size, click on the Edit button and click copy.
Now half the work is done. You need to open Microsoft word. It is already open, But right now you are in Excel. Note the Excel button in Example 3. You need to click on the Microsoft Document button at the bottom of the page. See Example 4 below. This will run Microsoft Word. You are now ready to paste your copied graph into Microsoft Word and start typing your report.
| Example 3 | Example 4 | |
|
|
|
Your report will include information about: (1) your choice for data collection and why you chose that topic, (2) making graphs and the five parts of a graph including information about the width of the bars and the grid lines, (3) inputting data into Excel, (4) using Excel to make graphs, and (5) using Microsoft Word and Excel, copying information from Excel and pasting that information into Microsoft Word.
Lesson Plan 5
Teacher: Matthew T. Bates
Subject: Making a Graph in Excel
Grade Level: 5 th. Grade
Date: June 20, 2003
Lesson Plan 4
Overview: Whereas word processors are extensively used in our everyday lives, many students are unaware of how to take data from Excel, copy it, and paste that information into a word processor
Purpose: Through this lesson students will create a report by coping graphs develop in Excel and pasting those graphs in Microsoft Word. The students will then write a report about the process of data collection, making graphs, inputting data into Excel, making graphs from that data, and coping and pasting those graphs into Microsoft Word.
Objective: Students will be able to:
(a.) open Excel and graphs developed in lesson 4
(b.) open Microsoft Word
(c.) Copy graphs from Excel and paste them into Microsoft Word
(d.) Write a report about the process:
1.) of data collection (lesson 1)
2.) making graphs (lesson 2)
3.) inputting data into Excel (lesson 3)
4.) making graphs from that data (lesson 4)
5.) coping and pasting those graphs into Microsoft Word (lesson 5)
Input/Modeling: Students will observe the process of coping and cutting data from Excel.
Checking for Understanding: Students will copy information they have produced in Excel and paste that information into Microsoft Word.
Independent Practice: The student will make a report using their data and information produced in Excel in Microsoft Word.
Closure: Students will take a quiz about collecting data, making graphs, inputting information into Excel, making graphs with that data in Excel, coping and pasting that information into Microsoft Word.
 |
