BUS 174

[Click picture above for film information]

• What did you think about and feel while watching the film?  
• What does the film mean?  
• What can we learn from seeing this film? 
• How can we integrate those learnings into who we are, what we care about, and how we chose to act in the world as we gain agency (control over our own lives)?

Bus 174 Analysis Questions

Spreadsheet Charts

Monday

Warmup: Enter expenses into spreadsheet
Lesson: Using Charts in Google Spreadsheets

• Pie Charts
• What are they for?
• How do I create them?
• Exploring pie charts?
• Pie Chart Example Data
• What other kinds of charts and graphs are there?
• Bar Chart Example Data

Homework: Please keep tracking expenses

Tuesday

Natalie will be substituting, likely for something boring... or a movie

Pride in our differences week...

Don't forget to bring your permission slips and $$

This Friday, April 20th, EA will observe its fifth Day of Silence

Today, and all this week, we will explore issues of bias and bullying, with a special focus on gender and sexuality.  This is a week of learning, exploring ideas and, for some, healing.  This is a week where we can show that we have grown into mature young men and women ready to discuss important issues.  

As usual there will be zero tolerance for intolerance.

FRIDAY

• Discussion: "Why do bullies exist?"
• Readings from the film "Bully"
• Discussion

Theaters and Times may CHANGE by Friday

Shattuck Cinemas (with John and his family)

2230 Shattuck Avenue, Berkeley, CA

‎2:20‎  ‎4:50‎  ‎7:15‎  ‎9:40pm‎

AMC Bay Street 16

5614 Shellmound Street, Emeryville, CA

‎11:10am‎  ‎1:55‎  ‎4:45‎  ‎7:30‎  ‎10:05pm‎

Piedmont Theatre

4186 Piedmont Avenue, Oakland, CA

‎2:00‎  ‎4:35‎  ‎7:15‎  ‎9:35pm‎

MONDAY

• Do Now: Enter any data collected since last class
• Quickwrite: "What does it mean to be a boy  or a  girl?"
• Short discussion  on The Day of Silence
• Short film: "Just Call Me Kade"

TUESDAY

• NOTE: FILM CLUB MEETS ON THURSDAY THIS WEEK (SORRY)
• Do Now: Enter any data collected since last class
• Quickwrite: "How do you act around people that are different?  By what right do you act the way you do?"
• Short discussion
• Very Short film: "The Bond"
• Long Discussion

WEDNESDAY

Freshman Field Trip to SF State

THURSDAY

• Do Now: Enter any data collected since last class
• 3rd & 4th Period Catch-up day & Extra Credit Poster Contest for Day of Silence and/or Anti-Bullying campaigns

Cleaning up our spreadsheets

Since so many kids have been missing I created a template to catch you up.  Everyone is free to use it if they want but you only get credit for the work I've seen you doing - this is simply so we can all be on the same page for today's lesson.

If your spreadsheet is fugly or nonexistent then use this one and quickly add in some of your own data.  If your's is coolio then spend a moment entering any new data before we begin.

Here's the template: https://docs.google.com/a/envisionacademy.org/templates?category=Finance&sort=hottest&view=domain

And now to Friday the 13th... sort of:

UpsideDown News

WarmUp: Go to the following article and read it.  While reading it think about the following: Is it a realistic depiction of what you experienced?  Does it under or oversell the importance of the UpsideDown Academy?  Are there any errors in the article?

http://blogs.kqed.org/mindshift/2012/04/turning-teacher-student-roles-upside-down/

Purpose: Learn more about spreadsheets, including:

• Resizing columns
• More formulas
• Absolute references
• Formatting as a percentage
• Coloring cells
• Conditional Formatting
• Solving problems

Finish: Extra Credit Presentations

Catch-Up and Extra Credit

Hello Chilren...

Because we're right at the start of the Spreadsheet/Finance Unit Natalie and I decided to give you a break and allow you to use this period to either catch up or to earn extra credit.

NO HEADPHONES UNLESS AND WHILE YOU ARE ACTUALLY USING IMOVIE

DO NOW: Everyone who was here yesterday needs to go to their Expense Tracking Google doc and enter the items they have purchased since yesterday.


Do Second:  If you were NOT here you need to find a friendly friend and get help setting up the Google doc - you only need the "Sheet 2" version


Everyone: You must continue writing down your expenses as 'homework' for this to be the most interesting and informative for you (and to get full credit for the unit)


Now: if you have NOT finished your comercial (edited, titles and transitions, exported, uploaded to school YouTube account, and link emailed to John@envisionacademy.org) you MUST do that now.  It is due this week and you have now, after school today, and MAYBE after school tomorrow and that's it, nothing can be turned in after that.

If you HAVE successfully completed the commercial you  will work on learning about financial scams and will receive EXTRA CREDIT by making a short 2 minute presentation NEXT CLASS on one of these scams.


Your Task: 

• RESEARCH
• Visit this site and look at the 10 scams covered in the slideshow.   
• Pick ONE and follow the links to learn more about the scam - take notes.  
• If it still interests you then Google the term and get more information - write more notes
• PRODUCT
• Create a short (2 minute) presentation on the scam.  
• You may collaborate with ONE friend on this
• It can be a poster, a skit, a fake email that you can send to us and explain verbally, whatever fits the crime...
• If you finish early you may pick another for double extra credit (do another 'presentation' or be prepared to discuss it after another's presentation in order to get the credit)

If you have other schoolwork that you desperately need to do, and your commercial is turned in, you may show Natalie your comercial on Youtube as proof and then, if she agrees what you need to do is important, you may quietly do that instead of getting extra credit.

Spreadsheets #1 - Basic Google Spreadsheets

Welcome back from Spring Break!

Announcement: Film Club will meet TUESDAY after school this week
Commercials can be finished tomorrow and Wednesday after school

Today's Purpose:

• I can create, name, and share a Google SPREADSHEET
• Cut, paste, copy, and drag COLUMNS
• Use data VALIDATION to constrain cell values
• Create a new TAB with a new spreadSHEET
• Create a vertical SUBTOTAL formula that works
• Create a horizontal TOTAL

Homework: 

• Keep a handwritten expense DIARY of everything you spend for the next two weeks


• include data, item name, cost, and category
• The due now each class will be to type that information into the spreadsheet you made today