031610 econ excel 100m

11

Click here to load reader

Upload: monta-vista-high-school

Post on 28-Jan-2018

224 views

Category:

Documents


3 download

TRANSCRIPT

Page 1: 031610 Econ Excel 100m

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.

Page 2: 031610 Econ Excel 100m

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

Page 3: 031610 Econ Excel 100m

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

Page 4: 031610 Econ Excel 100m

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.

Page 5: 031610 Econ Excel 100m

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.

Page 6: 031610 Econ Excel 100m

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

Page 7: 031610 Econ Excel 100m

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

Page 8: 031610 Econ Excel 100m

Rubric:__/4 Factually Informative__/2 Communication Style (C’s 7 tips)

__/2 Active Audience Member __/2 Followed Directions

_____/10 Points

Page 9: 031610 Econ Excel 100m

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.

Page 10: 031610 Econ Excel 100m

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

Page 11: 031610 Econ Excel 100m

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