Day 19 (7)

Before you leave today you will know how to create an Excel spreadsheet.

  1. Typing Web: Please keep your eyes on your screen while you practice!!
    1. E 1–Team Roster
    2. Use your PG-#3 Planning Form that you already created
    3. Follow these written instructions:
      1. Get into Excel
        1. Click the Windows button in the lower left corner of your screen
        2. Begin to type Excel
        3. Click Excel when it pops up
      2. Click BLANK WORKBOOK
      3. Save the workbook as E-1 Team Roster to your Dream Team folder located in your 7th Grade Tech Apps folder in your Google Drive
        1. Click the FILE tab
        2. Click SAVE AS
        3. Click BROWSE
        4. Click GOOGLE DRIVE on the left side of the dialog box
        5. Navigate to your Dream Team folder
        6. Type in the filename E-1 Team Roster
        7. Click SAVE
      4. Insert a header with the text: The <Year><Team Name> Roster
        1. Click the INSERT tab
        2. Click HEADER & FOOTER
        3. In the CENTER BOX in the HEADER type The <current year> <your team name> Roster–LOOK AT JOE’S EXAMPLE TO HELP YOU UNDERSTAND HOW THIS SHOULD LOOK
        4. In cells A1 to F1 enter the following column headings:
          1. Click in cell A1 & type First Name
          2. Hit TAB 1 time & type Last Name
          3. Hit TAB 1 time & type Position
          4. Hit TAB 1 time & type Height
          5. Hit TAB 1 time & type Weight
          6. Hit TAB 1 time & type Uniform #
        5. Bold and center align cells A1 – F1
          1. Point and click in the MIDDLE  cell A1 and click and drag to cell F1 and let go to select all of cells A1 to F1
          2. On the Home tab click Bold and click the Center align button
        6. Enter the information for each of your players. use your PG-3 Planning Form to help you or just make it up as you go. When you are entering the height use the format 6’0″ – LOOK AT JOE’S EXAMPLE TO HELP YOU UNDERSTAND HOW THIS SHOULD LOOK
        7. Rename the worksheet tab to Team Roster
          1. at the bottom of your screen DOUBLE CLICK sheet1 and type the new name which is Team Roster
        8. Resize the columns so that all the data displays properly
          1. Point at the line between columns A & B and when the pointer changes to a black double headed arrow, double click–do this for all the columns that contain information in this spreadsheet
        9. Sort the roster by last name and then by first name in ascending order
          1. Click the DATA TAB
          2. Click the SORT button
          3. For SORT BY click Column B to sort on Last Name first, click VALUES under SORT ON, and click A to Z for ascending order under ORDER
          4. Click ADD LEVEL
          5. Next to THEN BY choose Column A to sort on First Name just in case more than 1 player has the same last name
        10. View the roster to be sure it sorted correctly
        11. Print your roster & hand it in
  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










YOUR JOB (this is an email from Tracey Medinger, a member of the Bellevue Public Library Board):

We talked a few weeks ago about having your one of your business classes or your FBLA group create some bookmarkers for the Bellevue Public Library. I finally had time to email you some info. We could actually use a couple of different designs so please have the kids come up with fun creative options. They can use front & back if they want but these should not be overly busy in the design.  Not too many pictures, gifs, etc.  We would like them to include the library hours listed below and also information about Amazon Smiles.

Library Hours (use on the bookmarkers)

Mon, Tue, Thu, Fri: 10:00 AM – 5:30 PM

Wednesday: 10:00 AM – 7:00 PM

Saturday: 10:00 AM – 3:00 PM

Closed Sunday

Amazon Smiles (use on the bookmarkers)

The Amazon Smile Foundation will donate 0.5% of the purchase price from your eligible Amazon Smile purchases to Friends of the Bellevue Public Library which is a non-profit organization dedicated to supporting the goals of the library. You can access Amazon Smile online at and choose Bellevue Public Library (Bellevue, IA) in the “Choose Your Charity” section.

**Don’t use this part on the bookmarkers but just a note that the key to this is that the Amazon Smiles user must choose the correct Friends of the Bellevue Public Library.  There are several because there are several different towns of Bellevue around the country. Please have the kids emphasize this somehow on the bookmarkers.  It could just be that they bold, highlight or change the color of the wording for Bellevue, IA or something like that so it stands out. The Amazon Smiles user must choose the one specific to Bellevue IA.  It looks like the following on the website:

We are in no hurry for this.  Our next board meeting is 11/07.  I would like to have a good dozen or so options to present to the group at that meeting.  Can you review when the kids have them done and send me your top 12 before then?  Let me know if you have any questions and THANK YOU so much to you & the kids for working on this for us!!

Thank You,


  1. Create a new 11 X 8.5 (landscape) file in Publisher
  3. SIZE
  4. CREATE NEW PAGE SIZE–fill in the dialog box with the following information:
  5. Click OK
  7. PAGE
  8. Page 1 is the front & page 2 is the back of the bookmark
  9. Print 2 sided flip on the short edge