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 ………..

  1. Typing Web: Please keep your eyes on your screen while you practice!!
  2. FINISH E-4–SHOW ME THEN PRINT
  3. THE DREAM TEAM EXCEL UNIT
    1. E 5–Top 5 Salaries
    2. Follow these written instructions:
      1. Open the E-2 Average Salary file you already created
      2. From the FILE menu choose SAVE AS and rename it E-5 TOP 5 SALARIES
      3. Change the HEADER of the spreadsheet to the following: TOP 5 PLAYER SALARIES
      4. Delete the entire row  that contains the AVERAGE SALARY
        1. with your cursor, POINT at the ROW NUMBER on the left side of your screen and RIGHT CLICK 1 time (my average salary row is 12)
        2. choose DELETE when you RIGHT CLICK on the ROW NUMBER that contains the average salary information
      5. Sort the spreadsheet by Salary from HIGHEST to LOWEST
        1. Click in cell G4
        2. Click the DATA tab
        3. Click SORT
        4. Sort by: CHOOSE SALARY from the drop down list
        5. Under ORDER choose LARGEST TO SMALLEST from the drop down list
        6. Click OK
      6. Delete all of the rows that do not contain the top five salaries
        1. Point at the first row number below the top 5 salaries (mine is row 7) and when you have a RIGHT POINTING BLACK ARROW, CLICK and DRAG to the last row in the spreadsheet
        2. RIGHT CLICK on the selected rows & choose DELETE
      7. Create a PIE CHART to show a comparison by last name of the top 5 paid players and their salaries
        1. WATCH THIS VIDEO TO HELP YOU
      8. Proofread
      9. Save
      10. Print
  4. Open the 7th Grade Tech Apps Google Doc.
  5. At the TOP of the Doc write about how you can use what you learned today outside of this classroom.
  6. SHARE the Doc with me AGAIN–just click SHARE

 

Leave a Reply

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