Computer Instructions for 3rd Grade Project-Based Lesson by ucv16513

VIEWS: 4 PAGES: 11

									      Computer Instructions for 3rd Grade Project-Based Lesson
        (Compare and Contrast Four Well Known Composers)

          Save Pictures Needed for Brochure in Picture File

1. Double-Click on the Internet site on the desktop that will show pictures of
   instruments.
2. Find one instrument at a time and use the following instructions to save
   the picture.
        Right click on the picture
        Click Save As a Picture
        Click on Save Box, My Pictures
        Click Save
3. Do this same process for each picture you need.


                         Page Setup for Sheet 1

1. Click File
2. Click Page Setup
3. Click page tab, click landscape
4. Click Margin tab
5. Click on the number in the left margin box, erase the number
6. Type 0.5
7. Click on the number in the right margin box, erase the number
8. Type 0.28
9. Click on the number in the top margin box, erase the number
10. Type 0.5
11. Click on the number in the bottom margin box, erase the number
12. Type 0.5

                           Page Setup for Sheet 2

   1. Click File
   2. Click Page Setup
   3. Click page tab, click landscape
   4. Click Margin tab
   5. Click on the number in the left margin box, erase the number
   6. Type 0.58
   7. Click on the number in the right margin box, erase the number
   8. Type 0.25
   9. Click on the number in the top margin box, erase the number
   10. Type 0.5
   11. Click on the number in the bottom margin box, erase the number
   12. Type 0.5
                          Microsoft Excel Page Setup

(Front & Back of brochure – Sheet 1)
   1. At the bottom of the Excel page, click on Sheet 1
   2. Place the cursor on the A above the first column. Click. This will highlight
       the entire column.
   3. Click Format
   4. Click Column. Slide the cursor over to width. Click.
   5. Type the number 42 in the column width box. Click OK.
   6. Place the cursor on the B above the second column. Click.
   7. Click Format
   8. Click Column. Slide the cursor over to width. Click.
   9. Type the number 44 in the Column width box. Click OK.
   10. Place the cursor on the C above the third column. Click.
   11. Click Format.
   12. Click column. Slide the cursor over to width. Click
   13. Type the number 44 in the Column width box. Click OK.
   14. Highlight Column B by clicking on the letter B.
   15. Click the down arrow of the “insert line” icon on the task bar.
   16. Click the third picture on the top row.
   17. Click “File”. Slide down to “Save”. Click.
   18. Type “(Your name – Homeroom name) Project”
   19. Click save button.
   20. Click on Column A, Cell 1
   21. Click Format. Slide cursor down to row & slide over to height and click.
   22. Type in the number 22 in the row height box. Click OK.
   23. Click column A, Cell 2
   24. Click Format. Slide cursor down to row & slide over to height and click.
   25. Type in the number 22 in the row height box. Click OK.
   26. Click Column A, Cell 4
   27. Click Format. Slide cursor down to row & slide over to height and click.
   28. Type the number 30 in the row height box. Click OK
   29. Click Column A, Cell 7
   30. Click Format. Slide cursor down to row & slide over to height and click.
   31. Type the number 16.5 in the row height box. Click OK
   32. Click Column A, Cell 8
   33. Click Format. Slide cursor down to row & slide over to height and click.
   34. Type the number 16.5 in the row height box. Click OK
   35. Click column A, Cell 12
   36. Click Format. Slide cursor down to row & slide over to height and click.
   37. Type the number 30 in the row height box. Click OK
   38. Click Column A, Cell 16
   39. Click Format. Slide cursor down to row & slide over to height and click.’
   40. Type the number 16.5 in the row height box. Click OK
   41. Click Column A, Cell 20
   42. Click Format. Slide cursor down to row & slide over to height and click.
   43. Type the number 30 in the row height box. Click OK
   44. Click Column A, Cell 23
   45. Click Format. Slide cursor down to row & slide over to height and click.
   46. Type the number 16.5 in the row height box. Click OK
   47. Click Column A, Cell 24
   48. Click Format. Slide cursor down to row & slide over to height and click.
   49. Type the number 16.5 in the row height box. Click OK
   50. Click Column A, Cell 28
   51. Click Format. Slide cursor down to row & slide over to height and click.
   52. Type the number 30 in the row height box. Click OK
   53. Click Column A, Cell 32
   54. Click Format. Slide cursor down to row & slide over to height and click.
   55. Type the number 16.5 in the row height box. Click OK.
   56. Click Column A, Cell 3
   57. Click the down arrow button on “insert line” icon on the task bar.
   58. Click the third picture of the second row
   59. Click Column A, Cell 11
   60. Click the down arrow button on “insert line” icon on the task bar.
   61. Click the second picture on the first row.
   62. Click Column A, Cell 19
   63. Click the down arrow button on “insert line” icon on the task bar.
   64. Click the second picture on the first row.
   65. Click Column A, Cell 27
   66. Click the down arrow button on “insert line” icon on the task bar.
   67. Click the second picture on the first row.

(Inside of brochure – Sheet 2)
    1. At the bottom of the Excel page, click Sheet 2
    2. Place the cursor on the A above the first column. (This will highlight the
        entire column.)
    3. Click Format.
    4. Click Column. Slide the cursor over to width (click)
    5. Type the number 42 in the Column width box
    6. Click OK
    7. Place cursor on the B above the second column. Click. This will highlight
        the entire column.
    8. Click Format.
    9. Click Column. Slide the cursor over to width (click)
    10. Type the number 44 in the Column width Box.
    11. Click OK
    12. Place cursor on the C above the third column. Click. This will highlight
        the entire column.
    13. Click Format
    14. Click Column. Slide the cursor over to width (click)
    15. Type the number 41 in the Column width box.
    16. Click OK
17. Highlight Column B by Clicking on the letter B
18. Click the down arrow of the “insert line” icon on the task bar.
19. Click the third picture on the top row.
20. Click the down arrow of the “insert line” icon on the task bar.
21. Click the fourth picture on the top row.
22. Click Column A, Cell 1
23. Click Format – Slide cursor down to row & slide over to height and click.
24. Type the number 22 in the row height box
25. Click OK
26. Click Column A, Cell 2
27. Click Format, Slide the cursor down to row & slide over to height & click.
28. Type the number 22 in the row height box
29. Click OK
30. Highlight row 3 across Columns A & B & C
31. Click the arrow on the “insert line” icon on the task bar.
32. Click on the third picture on the second row
33. Click column A, Cell 4
34. Click Format – Slide down to row, slide over to height, click.
35. Type the number 30 in the row height box
36. Click OK
37. Click Column A, Cell 7
38. Click Format, Slide down to row, slide over to height, click.
39. Type the number 16.5 in the row height box. Click OK.
40. Click OK
41. Click Column A, Cell 12
42. Click Format, Slide down to row, slide over to height, click
43. Type the number 30 in the row height box. Click OK.
44. Click Column A, Cell 15
45. Click Format, slide down to row, slide over to height, click
46. Type the number 16.5 in the row height box. Click OK
47. click Column A, Cell 20
48. Click Format, slide down to row, slide over to height, click.
49. Type the number 30 in the row height box. Click OK
50. Click column A, Cell 23
51. Click Format, slide down to row, slide over to height, click.
52. Type the number 16.5 in the row height box. Click OK.
53. Click Column A, Cell 28
54. Click Format, slide down to row, slide over to height, Click
55. Type the number 30 in the Row height box. Click OK
56. Click Column A, Cell 31
57. Click Format, slide down to row, slide over to height, click.
58. Type the number 16.5 in the row height box. Click OK
59. Highlight row 11 across Columns A, B, & C
60. Click the arrow on the “insert line” on the task bar.
61. Click the second picture of the first row.
62. Highlight row 19 across Columns A, B, & C
   63. Click the arrow on the “insert line” on the task bar.
   64. Click the second picture of the first row.
   65. Highlight row 27 across Columns A, B, & C
   66. Click the arrow on the “insert line” on the task bar.
   67. Click the second picture of the first row.
   68. Save


           Typing Instructions for 3rd Grade Project-Based Lesson

                                  Microsoft Excel

(Front & Back of brochure – Sheet 1)
   1. Click Sheet 1
   2. Highlight columns A & B by clicking and holding on letter A – slide over to
       C. Release left click
   3. Click the “center information” button on task bar.
   4. Click Column A, Cell 1
   5. Click “B” on the task bar to bold the print
   6. Click in the font size box and type the number 17. Enter.
   7. Type “How Did Music”
   8. Click Column A, Cell 2
   9. Click “B” on the task bar to bold the print
   10. Click in the font size box and type the number 17. Enter.
   11. Type “Get to the Public”
   12. Click Column A, Cell 4
   13. Click “B” on the task bar to bold the print
   14. Click the font size box and type the number 15. Enter.
   15. Type “Kenny G”
   16. Save.
   17. Click Column A, Cell 7
   18. Click the font size box and type the number 13. Enter.
   19. Type the information you found about how Kenny G gets his music to the
       public.
   20. Click Column A, Cell 8
   21. Click the font size box and type the number 13. Enter.
   22. Type the information you found about how Kenny G gets his music to the
       Public.
   23. Click Column A, Cell 12
   24. Click “B” on the task bar to bold the print
   25. Click the font size box and type the number 15. Enter.
   26. Type “Johannes Brahms”
   27. Click Column A, Cell 16
   28. Click the font size box and type the number 13. Enter.
   29. Type the information you found about how Brahms got his music to the
       public.
30. Click Column A, Cell 20
31. Click “B” on the task bar to bold the print
32. Click the font size box and type the number 15. Enter.
33. Type “W. C. Handy”
34. Save.
35. Click Column A, Cell 23
36. Click the font size box and type the number 13. Enter.
37. Type the information you found about how Handy got his music to the
    public.
38. Click Column A, Cell 24
39. Click the font size box and type the number 13. Enter.
40. Type any other information you found about Handy getting music to public.
41. Click column A, Cell 28
42. Click “B” on the task bar to bold print
43. Click the font size box and type the number 15. Enter.
44. Type “Amadeus Mozart”
45. Click Column A, Cell 32
46. Click the font size box and type the number 13. Enter.
47. Type the information you found about how Mozart got his music to the
    public.
48. Click Column B, Cell 1
49. Click “B” on the task bar to bold print
50. Click the font size box and type the number 17. Enter
51. Type “Extra Facts I Have”
52. Click Column B, Cell 2
53. Click “B” on the task bar to bold print
54. Click the font size box and type the number 17. Enter
55. Type “Learned in Researching”
56. Click column B, Cell 4
57. Type extra information fact #1
58. Click Column B, Cell 12
59. Type extra information fact #2
60. Save.
61. Click Column B, Cell 20
62. Click “B” on the task bar to bold print
63. Click the font size box and type the number 15. Enter
64. Type “Which Composer Do I Like?”
65. Click column B, Cell 23
66. Type in your choice of favorite composer and tell why.
67. Save.
68. Click Insert on the task bar. Slide cursor down to the word “picture” &
    slide on down to “WordArt”. Click.
69. Choose the WordArt you wish in your brochure. Click on it. Click OK.
70. Type “Composers”. Hit Enter & type “of”. Enter & type “the”. Enter & type
    “Ages”.
71. Click OK
   72. Place cursor on the word “Composers” until you see a cross form. Click &
       hold left click down. Now move the whole writing with your finger where
       you need it to be. Position it at the top of column C.
   73. Click insert on the task bar. Slide cursor down to the word “picture” &
       slide on down to “WordArt”. Click.
   74. Choose the Word Art you wish in your brochure. Click on it. Click OK.
   75. Type “Then”. Hit Enter & type “&”. Enter & type “Now”.
   76. Click OK
   77. Place cursor on the word “Then” until you see a cross form. Click & hold
       left click down. Now move the whole writing with your finger where you
       need it to be. Position it at the bottom of column C.
   78. Click insert on the task bar. Slide cursor down to the word “picture” &
       slide down to “From File”.
   79. Find picture of a grand piano. Highlight by clicking on grand piano.
   80. Click Insert.
   81. Place cursor on the picture of the piano until you see a cross form. Click
       and that will allow you to move the piano where you need it.
   82. Click Column C, Cell 33
   83. Click “Center Information”
   84. Type your “by:” and then your name
   85. Click Column C, Cell 34
   86. Type Homeroom teacher’s name, dash, and then the date
   87. Save.

(Inside of brochure) – Sheet 2
    1. Click Sheet 2
    2. Highlight Columns A, B, & C.
    3. Click the “center information” button on the task bar.
    4. Click Column A, Cell 1
    5. Click “B” on the task bar to bold type
    6. Click the font size box and type the number 17. Enter.
    7. Type “Major Instrument”
    8. Click Column A, Cell 2
    9. Click “B” on the task bar to bold type
    10. Click the font size box and type the number 17. Enter.
    11. Type “Of Composers”
    12. Click Column A, Cell 4
    13. Click “B” on the task bar to bold type
    14. Click the font size box and type the number 15. Enter.
    15. Type “Kenny G”
    16. Click Column A, Cell 5
    17. Click Align left button
    18. Type the instrument your research found that Kenny G plays.
    19. Click Column A, Cell 7
    20. Click Insert from the task bar
    21. Slide down to picture, slide over and down to “from file”, Click.
22. Highlight the name of the picture of the instrument Kenny G plays.
23. Click Insert.
24. Place cursor on the picture of the instrument until you see a cross form.
    Click and that will allow you to move the instrument where you need it.
25. Click Column A, Cell 12
26. Click “B” on the task bar to bold type
27. Click the font size box and type the number 15. Enter.
28. Type “Johannes Brahms”
29. Click Column A, Cell 13
30. Click Align Left button
31. Type the name of the instrument your research found that Brahms played.
32. Click Insert from the task bar
33. Slide down to picture, slide over and down to “from file”, Click.
34. Highlight the name of the picture of the instrument Brahms played.
35. Click Insert.
36. Place cursor on the picture of the instrument until you see a cross form.
    Click and that will allow you to move the instrument where you need it.
37. Click Column A, Cell 20
38. Click “B” on the task bar to bold type
39. Click the font size box and type the number 17. Enter.
40. Type “W. C. Handy”
41. Click Column A, Cell 21
42. Click Align Left button
43. Type the name of the instrument your research found that Handy played.
44. Click Insert from the task bar
45. Slide down to picture, slide over and down to “from file”, Click.
46. Highlight the name of the picture of the instrument Handy played.
47. Click Insert.
48. Place cursor on the picture of the instrument until you see a cross form.
    Click and that will allow you to move the instrument where you need it.
49. Click Column A, Cell 28
50. Click “B” on the task bar to bold type
51. click the font size box and type the number 17. Enter.
52. Type “Amadeus Mozart”
53. Click Column A, Cell 29
54. Click Align Left button
55. Type the name of the instrument your research found that Mozart played.
56. Click Insert from the task bar
57. Slide down to picture, slide over and down to “from file”, Click.
58. Highlight the name of the picture of the instrument Mozart played.
59. Click Insert.
60. Place cursor on the picture of the instrument until you see a cross form.
    Click and that will allow you to move the instrument where you need it.
61. Click Column B, Cell 1
62. Click “B” on the task bar to bold type
63. Click the font size box and type the number 17. Enter.
64. Type “When & Where Did”
65. Click Column B, Cell 2
66. Click “B” on the task bar to bold the type
67. Click the font size box and type the number 17. Enter.
68. Type “Composers Live”
69. Click Column B, Cell 4
70. Click “B” on the task bar to bold type
71. Click font size box and type the number 15. Enter.
72. Type “Kenny G”
73. Click Column B, Cell 6
74. Type “Born –“ and then type the correct information from your research
75. Click Column B, Cell 8
76. Type “Died –“ and then type the correct information from your research
77. Click Column B, Cell 10
78. Type the year of birth and death of Kenny G
79. Click Column B, Cell 12
80. Click “B” on the task bar to bold type
81. Click the font size box and type the number 15. Enter.
82. Type Johannes Brahms
83. Click Column B, Cell 14
84. Type “Born –“ and then type the city and country where Brahms was born.
85. Click Column B, Cell 16
86. Type “Died –“ and then type the city and country where Brahms died.
87. Click Column B, Cell 18
88. Type the year Brahms was born and died
89. Click Column B, Cell 20
90. Click “B” on the task bar to bold type
91. Click font size box and type the number 15. Enter.
92. Type “W.C. Handy”
93. Click Column B, Cell 22
94. Type “Born –“ and then type the city and country where Handy was born.
95. Click Column B, Cell 24
96. Type “Died –“ and then type the city and country where Handy died.
97. Click Column B, Cell 26
98. Type the year Handy was born and died
99. Click Column B, Cell 28
100.        Click “B” on the task bar to bold type
101.        Click font size box and type the number 15. Enter.
102.        Type “Amadeus Mozart”
103.        Click Column B, Cell 30
104.        Type “Born –“ and then type the city and country where Mozart was
            born.
105.        Click Column B, Cell 32
106.        Type “Died –“ and then type the city and country where Mozart
            died.
107.        Click Column B, Cell 34
   108.      Type the year Mozart was born and died.
   109.      Click Column C, Cell 1
   110.      Click “B” on the task bar to bold type
   111.      Click font size box and type the number 17. Enter.
   112.      Type “Style of Music Each”
   113.      Click Column C, Cell 2
   114.      Click “B” on the task bar to bold type
   115.      Click font size box and type the number 17. Enter.
   116.      Type “Composer Created”
   117.      Click Column C, Cell 4
   118.      Click “B” on the task bar to bold type
   119.      Click font size box and type the number 15. Enter.
   120.      Type Kenny G
   121.      Click Column C, Cell 7
   122.      Click font size box and type the number 13. Enter.
   123.      Type the type of music Kenny G composes
   124.      Click Column C, Cell 12
   125.      Click “B” on the task bar to bold type
   126.      Click font size box and type the number 15. Enter.
   127.      Type “Johannes Brahms”
   128.      Click Column C, Cell 15
   129.      Click the font size box and type the number 13. Enter.
   130.      Type the type of music Brahms composed
   131.      Click Column C, Cell 20
   132.      Click “B” on the task bar to bold type
   133.      Click font size box and type the number 17. Enter.
   134.      Type “W. C. Handy”
   135.      Click Column C, Cell 23
   136.      Click font size box and type the number 13. Enter.
   137.      Type the type of music Handy composed
   138.      Click Column C, Cell 28
   139.      Click “B” on the task bar to bold type
   140.      Click font size box and type the number 17. Enter.
   141.      Type “Amadeus Mozart”
   142.      Click Column C, Cell 31
   143.      Click font size box and type the number 13. Enter.
   144.      Type the type of music Mozart composed
   145.      Save.

                              Change Font Colors

(Sheet 1)
      1. Click Sheet 1 at the bottom of the Excel page
      2. Highlight Column A, Cells 7 & 8
      3. Click Font Color icon on task bar
      4. Click the color you wish Kenny G to be (All of Kenny G will be the
          same color)
      5. Click Column A, Cell 16
      6. Click font color icon on the task bar
      7. Click the color you wish Brahms to be
      8. Highlight Column A, Cells 23& 24
      9. Click Font Color icon on task bar
      10. Click the color you wish Handy to be
      11. Click Column A, Cell 32
      12. Click Font color icon on task bar
      13. Click the color you wish Mozart to be


(Sheet 2)
   1. Highlight Columns A, B, & C, Cells 5, 6, 7, 8, 9, 10, 11
   2. Click Color for Kenny G
   3. Highlight Columns A, B, & C, Cells 13, 14, 15, 16, 17, 18, 19
   4. Click Color for Brahms
   5. Highlight Columns A, B, & C, Cells 21, 22, 23, 24, 25, 26, 27
   6. Click Color for Handy
   7. Highlight Columns A, B, & C, Cells 29, 30, 31, 32, 33, 34, 35,
   8. Click Color for Mozart
   9. Save.

								
To top