Day 32 (7)

FINISH: Before you leave today you will know how to enter a formula to calculate the total, how to calculate projected revenue, and how to change the number of decimal places when using currency format.

  1. Typing Web: Please keep your eyes on your screen while you practice!!
  2. THE DREAM TEAM EXCEL UNIT
    1. Watch this video to make an example spreadsheet & follow these written instructions to help you:
      1. Create a new blank workbook using Excel
      2. Save the workbook to your 7th Grade Tech Apps The Dream Team folder as E-4 Projected Revenue 
      3. In cell A1, enter the title: Bellevue Buckeyes Stadium Projected Ticket Sales Revenue
      4. In cell A2 enter the following subtitle: Based on a stadium seating capacity of 65,000
      5. In cells A3 to E3 enter the following column headings: Section, Price, # of Seats, # of Home Games, Total Sales
      6. Bold and center align cells A3 to E3
      7. Enter your section names, price per ticket for each section, number of seats in each section, and the number of home games
      8. Enter a formula in cell E4 to compute the Total Sales for the first section. This is computed by multiplying the Price by the # of seats by the number of home game. All formulas in Excel must start with an equal sign (=) and the multiplication symbol is the astrick (*). So click on cell E4 and type the following: =b4*c4*d4 and hit enter. You just calculated the Total Sales for the first section in your stadium.
      9. Copy the formula in cell E4 to cells E5 through E8:
        1. Click on cell E4 one time
        2. Point at the NOTCH in the lower right corner of the cell & when it turns into a BLACK PLUS SIGN click and drag to cell E8. You just coped the formula to the other cells to calculate the Total Sales for the other sections of your stadium!
      10. In cell D9 enter the following text: Total Projected Sales–you will most likely need to make column D wider by pointing at the small line between columns D & E and clicking & dragging
      11. Enter a formula in cell E9 to compute the Total Projected Sales for all of the sections in the Total Sales column:
        1. Click 1 time in cell E9
        2. Click the HOME tab
        3. Click on the arrow on the right side of the AUTOSUM button
        4. Click SUM
        5. Hit enter
      12. Format column E as currency showing the “$” symbol and 0 decimals
      13. Merge & center align the title in A1 across all 5 columns
      14. Merge & center align the subtitle in A2 across all 5 columns
      15. Format the title, subtitle, and the column headings with an appropriate font size and style
      16. Center align cells D4 to D9
      17. Format the worksheet using your team’s colors
      18. Rename the worksheet tab: Tix Sales
        1. At the bottom of your spreadsheet DOUBLE CLICK on SHEET1
        2. Type Tix Sales
      19. Put your logo in the spreadsheet
      20. Proofread
      21. Save
      22. RAISE YOUR HAND TO SHOW YOUR TEACHER
      23. Print show your answers:
        1. File
        2. Print–choose the M553 or the 8600 printer
        3. Change the orientation from PORTRAIT to LANDSCAPE
        4. Toward the bottom of the print options click the CUSTOM SCALING button–choose to fit to all columns to 1 page if it is on more than 2 pages
        5. Change PRINT ONE SIDED to PRINT TWO SIDED FLIP ON THE SHORT EDGE
        6. Click PRINT
      24. Print showing your formulas:
        1. Formulas tab
        2. Click SHOW FORMULAS (toward the right end of the ribbon options)
        3. File tab
        4. Print
        5. Print Orientation — LANDSCAPE
        6. Custom Scaling — FIT ALL COLUMNS ON 1 PAGE
        7. Change PRINT ONE SIDED to PRINT TWO SIDED FLIP ON THE SHORT EDGE
        8. Click PRINT
  3. Create your own Projected Ticket Sales spreadsheet–create a new Excel spreadsheet to start and use Joe’s and mine (in the video) as examples. Use the steps above to help you. WHEN YOU ARE DONE:
    1. Print show your answers:
      1. File
      2. Print–choose the M553 or the 8600 printer
      3. Change the orientation from PORTRAIT to LANDSCAPE
      4. Toward the bottom of the print options click the CUSTOM SCALING button–choose to fit to all columns to 1 page if it is on more than 2 pages
      5. Change PRINT ONE SIDED to PRINT TWO SIDED FLIP ON THE SHORT EDGE
      6. Click PRINT
    2. Print showing your formulas:
      1. Formulas tab
      2. Click SHOW FORMULAS (toward the right end of the ribbon options)
      3. File tab
      4. Print
      5. Print Orientation — LANDSCAPE
      6. Custom Scaling — FIT ALL COLUMNS ON 1 PAGE
      7. Change PRINT ONE SIDED to PRINT TWO SIDED FLIP ON THE SHORT EDGE
      8. Click PRINT
  4. At the TOP of the Word Online file for this class write about how you can use what you learned today outside of this classroom. SHARE the Word Online file with me AGAIN.

12 thoughts on “Day 32 (7)

  1. How to protect your personal password.
    social media, bullying, online etiquette, safety and communication skills.
    How to find age appropriate sites for research/ how to know it is one
    Reaching about the dangers of meeting people from online when you have no idea who they are.
    What information not to give out on the internet.
    What nudes are and why you should never send them
    To give credit and how copy+paste is bad (high school/college)
    Private account- why you should have it.

  2. 1. how to keep your computer and information safe
    2. how to stay safe on the internet
    3. How people hack you
    4. how dangerous the internet is
    5. what the qualities are to have a good project/presentation

  3. I think that the most important thing to realize is that 4th and 5th graders are 1-2 years before getting a email, Facebook , Snap chat and stuff if they don’t have that already. They don’t know about how people can hack and do stuff to your computer and how they can track you and they can find you. That’s why you need to watch what personal and private information they put on their social media stuff. and most girls are like into shopping and stuff but when they get into online shopping they don’t know if they are buying stuff or what they are doing. they also don’t know about scams and like what 4th grader wouldn’t click on a pop up that says “CLICK ME AND YOU COULD WIN 5,000,000 DOLLARS AND A TRIP TO THE BAHAMAS!!” any body that doesn’t know about scams would do that. also if you download something from like a weird pop up that says download this game before it even out yet, that gives hackers all the information they could want onto a persons computer.

  4. I think we should teach them about the cloud and how everything is always on the internet whether it’s deleted and you can’t see it or not. Cyber-bullying, be polite and respectful and never say something you wouldn’t want to say to someone in person. Privacy and not giving out personal information. Sharing is important, but not everything needs to be shared. Use private profiles and change passwords frequently.

  5. Some ideas I have about computer and business security is what kind of software people use to stay safe,also what computer crimes are and what happens,also what jobs you can get in computer and bussiness security.

  6. Computer Safety, Cyberbullying, Rules when on a computer. All of these are important and need to be told to young students and kids with computers.

  7. 1-Social media scams-There alot of scams involving email and other social media
    2-Online gaming safety-Many kids play games on the internet with other people
    3-Viruses in link-A link can promise something but then give a virus to your computer
    4-Buying stuff-Buying things off the internet can sometimes be a scam
    5-Downloads-Downloading things directly from the internet can sometimes give you a virus
    6-scams-There are many scams on the internet right now such as the your computer has a virus scam

  8. I think this class is important, especially since many jobs will want you to have lots of knowledge about computers. In the future, computers will most likely be used more and more. I think important things are: how to make a good website, knowledge about cloud and google drive, and how to use features like Word and Presentation to make a good and professional project.

  9. I think it is important to take this class because it teaches you home row, tips on creating a good website, and cloud computing.
    But I also think that this class should teach us about internet safety like, protecting your email, what to post and not to post on social media in terms of helping you get into college or a sophisticated middle/high school.

  10. I personally think that students should take this class! It is a great opportunity for students to learn more about computers, and work in groups and do projects at the same time.

Leave a Reply

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