031610 econ excel 100m
TRANSCRIPT
Good Day!
DRAW A LINE SEPARATING TODAY & YESTERDAY1) Write: Date: 03/18/10, Topic: Business Debate2) On the next line, write “Opener #28” and then:
1) Plot your mood, reflect in 1 sent.2) Respond to the opener by writing at least 2 sentences about:Your opinions/thoughts OR/AND
Questions sparked by the clip OR/AND
Summary of the clip OR/AND
Other things going on in the news.
Turn on your computers.
Agenda1) Introduce Excel2) Work on Restaurant Plan
End Goal, you will be able to…1) What makes a good restaurant?
Reminder1) Which brunch can bankers come in? Worth $1920 dollars!2) Podcast, EmoIQ Quiz, Biz Plan3) Business plan sections due Block 3/25
Notes #27a, Title: “Excel Notes” Spreadsheet: Math doc, biz used more than Word1) Boxes: Columns=Letters, Rows=Numbers2) Autofill: (right drag corner)3) Total: Type: =sum ( highlight boxes you want )4) Add: Type: = (click 1st box) + (click 2nd box)5) Subt: Type: = (click 1st box) - (click 2nd box)6) Multiply:Type: = (click 1st box) * (click 2nd box)7) Divide: Type: = (click 1st box) / (click 2nd box)8) Multistep: Type: =sum, use () like in math form9) Special Formulas: Type: =formula, () to pick Example: =AVERAGE(H3:H11)10) Charts: Highlight desired, click make chart
1) Create a budget for your budget (one column item, one column price)
2) Use formula to add up the total =sum()
3) Create a graph of the budget
Show Mr. Chiang when done. Ask neighbor or raise hand for help.
Financial Challenge
1) All sales traffic down 20-30%
2) All staff demand 10% raise
3) All health care cost double
4) Taxes double to be 60% (C21)
5) Finance person creates a spreadsheet that adds all these dooms day into one.
Work #27a, “What Should Obama Do?”Team’s Answer (include their name)1) Low biz taxes (on biz income)2) Low worker’s taxes (on worker income)3) Increase mim wage4) Reduce mim wage 5) Reduce cost of health care6) Ease biz lending, so more people can start biz 7) Ease credit lending, so more people go out to eat8) Do nothing new
Debate Format30 seconds - Opener 1 Pro Side30 seconds - Opener 2 Pro Side30 seconds – Opener 1 Con Side30 seconds – Opener 2 Con Side30 seconds - Debaters Regroup 30 seconds – Rebuttal 1 Pro Side30 seconds – Rebuttal 1 Con Side30 seconds – Chiang Q 2 Pro Side30 seconds – Chiang Q 2 Con Side
1 2 3 4 5PRO CON
Rubric:__/4 Factually Informative__/2 Communication Style (C’s 7 tips)
__/2 Active Audience Member __/2 Followed Directions
_____/10 Points
Debate Prep:1) Decide if you are doing the opener
or closer.2) Discuss with your group what
your arguments will be.3) Write some ideas on your
mini-notecard.
Your prep time and 30-second performance will be graded on a
1-10 points scale.
Work #28a, Title “Econ Debate 1”1a, 1b, 1c, 1d, 1e….4e) a) Write a TITLE for each debate b) Write the #1-5 before the debate starts
based on your current views: 1-PRO, 3-Undecided, 5-CON
c) Write at least 1 idea from the PRO sided) Write at least 1 idea from the CON sidee) Write the #1-5 after the debate ends
based on your current views: 1-PRO, 3-Undecided, 5-CON AND WHY
Business Plan (Due Block 3/25-26)1) Work on your sections2) Make sure you talk with your group to have every section be in sync3) Save the links to resources that you will put in the appendix to back your claims.Example:5a: Webpage print out Competitor 15b: Webpage print out Competitor 2
Grading__/60 Your Google Docs Sections of the Written Business Plan__/10 Your Google Docs Presentation Slides For Your Sections __/10 Your Contribution to the Appendix (Labeled: 1a, 1b…8a) __/10 Your Oral Presentation (dress up for presentation, suit or uniform)__/10 Team Work (use of in class time and out of class time to help each other, leader eval, lose points if do each other’s work)__/100 Points Total