IMPORTANT: EVERYDAY SHARE A GOOGLE DOC WITH ME AT THE END OF CLASS TELLING ME HOW FAR YOU GOT AND WHAT YOU LEARNED!! THIS WILL BE GRADED!! YOU ARE EXPECTED TO REMEMBER TO DO THIS EVERYDAY–WHETHER YOU ARE REMINDED OR NOT!!!

Before you leave today you will know how to merge & center cells and how to shade and use different colors in an Excel spreadsheet.

  1. Typing Web: Please keep your eyes on your screen while you practice!!
  2. THE DREAM TEAM EXCEL UNIT
    1. E 3–Season Schedule–PLANNING FORM–Open it & print it & do it
    2. When you are done planning the schedule, follow these written instructions:
      1. Create a new blank workbook using Excel
      2. Save the workbook to your 7th Grade Tech Apps The Dream Team folder as E-3 Season Schedule
      3. In cell A1, enter the title: YOUR TEAM NAME 20XX Season Schedule–enter YOUR team name & the current year
      4. Merge & center align the title across the four columns of the worksheet
        1. Point to the middle of cell A1 & click & drag to cell D1
        2. On the HOME tab click MERGE & CENTER
      5. Format the title with an appropriate font size, style, & color–use Joe’s as an example
      6. In cells A2 to D2 enter the following column headings: Date, Opponent, Location, Time
      7. Complete the spreadsheet with the information for the E-3 Planning Form
      8. See if you can figure out how to do the following:
        1. Shade each row that contains an away game
        2. Format the worksheet using your team colors
      9. Rename the worksheet tab Season Schedule
      10. Proofread
      11. Print
  3. Open the 7th Grade Tech Apps Google Doc.
  4. At the TOP of the Doc write about how you can use what you learned today outside of this classroom.
  5. SHARE the Doc with me AGAIN–just click SHARE

Leave a Reply

Your email address will not be published. Required fields are marked *