GRADE YOUR TEACHER

GOAL: Before you leave class today you will have the opportunity to show what you have learned in the Excel Unit.

EXCEL TEST–This WILL go in the TEST/PROJECT portion of your grade.

  1. Create the following spreadsheet. Be sure to use a FORMULA to calculate TOTAL PRICE and use a FUNCTION to calculate the TOTAL NUMBER IN STOCK and AVERAGE TOTAL PRICE.
  2. PRINT SHOWING YOUR ANSWERS & SHOWING YOUR FORMULAS
  3. Excel Test

IF TIME PERMITS AFTER THE TEST START THIS:

  1. CREATE AN ACCOUNT IN WEEBLY:
    1. Go to Weebly
    2. Click SIGN UP
    3. Choose to SIGN UP WITH GOOGLE–you can use your school account–if any pop up come up, close them
    4. Click to CREATE A NEW SITE
    5. Do you want to sell online? NOT NOW
    6. Choose a THEME
    7. Click START EDITING
    8. Click USE A SUBDOMAIN OF WEEBLY
    9. For the name, name it the name of your dream team, like this:  bellevueeagles
  2. WATCH & DO THIS VIDEO ON HOW TO ADD/CHANGE NAMED PAGES –SHOW ME WHEN YOU HAVE ALL YOUR PAGES NAMED
    1. Create ALL your pages (DO NOT WORRY ABOUT CONTENT ON THE PAGES RIGHT NOW YOU WILL DO THAT ONCE YOU HAVE ALL YOUR PAGES CREATED & ESTABLISHED.) Here are some suggestions (you can add more, delete these, or change them in any way later):
      1. About Us
      2. Contact Us
      3. Meet The Team
      4. See Our Schedule

Before you leave today you will know how to use Microsoft Publisher to create graphic design projects for your dream team.

  1. Typing Web: Please keep your eyes on your screen while you practice!!
  2. THE DREAM TEAM DESKTOP PUBLISHING UNIT
    1. DTP 1, 2, 3–WATCH THIS VIDEO TO HELP YOU
    2. The VIP pass should be 2.75 by 4.75
    3. The TShirt design should be the whole page
    4. Print the Business Card, VIP Pass, and T-Shirt Design
  3. Open the 7th Grade Tech Apps Word Online for and at the TOP write about how you can use what you learned today outside of this classroom. SHARE the file with me AGAIN.

Before you leave today you will know how to use Microsoft Publisher to design a magazine advertisement for your Dream Team.

  1. THE DREAM TEAM DESKTOP PUBLISHING UNIT–DTP 4–MAGAZINE ADVERTISEMENT–read the directions in the book–use Joe’s example on page 13 to help you. Follow these instructions:
    1. Create a new file using Microsoft Publisher
    2. You may use the entire paper–8.5 by 11 for the advertisement–like Joe did
    3. Your advertisement must grab the reader’s attention with an easy-to-read message
    4. Look at some sample advertisements online to get ideas for your advertisement
    5. Your message and team logo should be the two most prominent elements on the advertisement–Look at Joe’s
    6. Use only 1 to 2 different fonts
    7. Print when you are done
  2. Open the 7th Grade Tech Apps Google Doc. At the TOP of the Doc write about how you can use what you learned today outside of this classroom. SHARE the Doc with me AGAIN–just click SHARE

YOU HAVE TODAY AND THE NEXT CLASS TO FINISH THIS LESSON PLAN

Today you will begin to create your Dream Team Website. Please strive to complete everything in BOLD below, if possible. Continue beyond, if time permits.

GOAL: Before you leave today: Create a weebly account, and create and name all the pages in your website.

  1. CREATE AN ACCOUNT IN WEEBLY:
    1. Go to Weebly
    2. Click SIGN UP
    3. Choose to SIGN UP WITH GOOGLE–you can use your school account–if any pop up come up, close them
    4. Click to CREATE A NEW SITE
    5. Do you want to sell online? NOT NOW
    6. Choose a THEME
    7. Click START EDITING
    8. Click USE A SUBDOMAIN OF WEEBLY
    9. For the name, name it the name of your dream team, like this:  bellevueeagles
  2. WATCH & DO THIS VIDEO ON HOW TO ADD/CHANGE NAMED PAGES –SHOW ME WHEN YOU HAVE ALL YOUR PAGES NAMED
    1. Create ALL your pages (DO NOT WORRY ABOUT CONTENT ON THE PAGES RIGHT NOW YOU WILL DO THAT ONCE YOU HAVE ALL YOUR PAGES CREATED & ESTABLISHED.) Here are some suggestions (you can add more, delete these, or change them in any way later):
      1. About Us
      2. Contact Us
      3. Meet The Team
      4. See Our Schedule
  3. WATCH THIS VIDEO TO LEARN HOW TO ADD STRUCTURE & OBJECTS TO YOUR WEB PAGES
  4. WATCH THIS VIDEO TO LEARN HOW TO INSERT ITEMS IN THE MEDIA & MORE SECTIONS ON THE LEFT SIDE OF YOUR WEEBLY SCREEN
  5. Click ELEMENT and try to add as many different elements as you can today. EXPERIMENT!! Use ALL the elements except Custom HTML and Search Box
    1. Photo Gallery
    2. Slide Show
    3. Map
    4. YouTube video
  6. Watch this video about How to Publish a Weebly site.
    1. Send the link for the published site to me by copying the ink and pasting it in a Google Doc shared with me. Also, in the Google Doc, do you have your own PERSONAL email address? If you do, please type it in the Google Doc also.
  7. Continue to customize your web pages using what you learned in the video. Be sure to include the following (1 per page of your website):
    1. Use different page layouts
    2. Insert an animated clipart (EXTRA CREDIT)
    3. Insert a photo gallery
    4. Insert a slide show
    5. Insert a form
    6. Limit scrolling–use 2-3 columns if necessary on a page
    7. Insert a map
    8. Insert other Media & More options to make your site impressive.
    9. Load your projects from this class somewhere in your website:
      1. Team Logo
      2. Team Roster
      3. Letter to the League
      4. Press Release
      5. Equipment Inventory List
      6. Player Personnel Form
      7. Average Salary
      8. Season Schedule
      9. Projected Revenue from Ticket Sales
      10. Top 5 Salaries
      11. Business Card
      12. VIP Pass
      13. T-Shirt Design
      14. Magazine Advertisement
  8. Publish the site again to update it.
  9. HERE IS HOW YOU UPLOAD THE DOCUMENTS YOU MADE IN THIS CLASS THIS QUARTER:
    1. Open the file in the program you created it in (Word, Excel, or Publisher)
    2. Click FILE
    3. Click SAVE AS
    4. Under the filename, where it says SAVE AS TYPE, click the down pointing arrow & choose PDF
    5. Close the program (Word, Excel, or Publisher)
    6. Go to a page in your website where you would like to put one of the files you created in this class that you just saved as a PDF
    7. On the left side of your screen click SHOW ALL ELEMENTS
    8. Drag the SCRIBD DOCUMENT element onto your page
    9. Click the Scribd Document you just drug onto your page
    10. Upload the PDF file (it will rotate and look like it can’t, but it will eventually)

Leave a Reply

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