Nov 16

Management – 11/17/17

I.  Bellwork

  • Page 219 Explain the difference between choosing to use Excel or Access to manage data.

II.  Objectives

  • Create well-formed lists and manipulate the data into meaningful information using sorting, filtering, and PivotTables/Charts.
  • Follow multistep procedures when performing data management on Excel lists analyzing the specific results based on explanations in the text.

III.  Classwork – Files are located on iLearn

  • Page 231-232 Using Excel’s Data Management Tools
  • Page 233 Updating Data to Be a Well-Formed List
Nov 16

Marketing – 11/17/17

I.  Bellwork

  1. What are two of your favorite colors?  Explain why.
  2. What are two of your least favorite colors?  Explain why.

II.  Objectives

  • Explain how artistic elements function in display design.
  • Determine the central ideas and information presented in a text by paraphrasing the steps and components of display design in simpler but still accurate terms.

III.  Discussion:

 IV.  Classwork Artistic Design Page 429-433

Steps to Create a Display –  Outline Part 2

Nov 16

Accounting – 11/16/17

3rd Hour

Objectives:

  • Describe significant points made by the speaker relating to credit, financing, and banking
  • Reflect upon the information provided by the speaker and apply it to personal,  academic, and professional endeavors.

Lecture Hall with Guest Speakers

Mrs. Peggy Richard & Mr. Charles Hoff

from DFCU – Dearborn Federal Credit Union

Guest Speaker sheet

4th & 6th Hour:  Chapter 5 Exam

 

 

Nov 15

Management – 11/16/17

I.  Bellwork

  • Page 216  Explain the difference between sorting and filtering.
  • Page 217  What is a PivotTable?

II.  Objectives

  • Using the data filter, sort, and subtotal tools in Excel
  • Create PivotTables and PivotCharts in Excel
  • Follow precisely multi-step procedures when performing data management on Excel lists analyzing the specific results based on explanations in the text.

III.  Classwork

  • 220 Creating a Well-formed Llst
  • 221-222 Sorting a List
  • 223-224 Filtered List
  • 225-226 Outlined List
  • 227-230 Pivot Tables

Page 231-232  Using Excel’s Data Management Tools

Nov 15

Marketing – 11/16/17

I. Bellwork  Q&A

Target Is Remodeling More Than Half Its Stores And The Updates Sound So Convenient

  1. Describe the changes Target is making to their stores.
  2. Why is Target making these changes?
  3. Explain what impact, if any, you believe the changes will make.

II.  Objectives

  • List the steps in creating a display and explain the components of each step
  • Explain how artistic elements function in display design.
  • Determine the central ideas and information presented in a text by paraphrasing the steps and components of display design in simpler but still accurate terms.

III.  Discussion

IV.  Notebook

  • Circle Map:  Display & Design Preparation  p.427
  • Sequence Map – Steps to Create a Display

V.  Classwork Artistic Design Page 427-433

Steps to Create a Display –

Nov 14

Management – 11/15/17

I.  Bellwork Q&A Page 213

  • Explain how businesses use lists.

II.  Objectives

  • Define a well-formed list and explain how it is used
  • Identify the data management features used to used to analyze a list
  • Create a well-formed list in Excel
  • Follow precisely multi-step procedures when performing data management on Excel lists analyzing the specific results based on explanations in the text.

III.  Notebook

  • Circle Map -Characteristics of a well-formed list (p.214)

IV.  Classwork

  • 220 Creating a Well-formed lst
  • 221-222 Sorting a List
  • 223-224 Filtered List
Nov 14

Accounting – 11/15/17

I.  Bellwork Q&A

  1. When is the only time you will record an accounting entry using the petty cash account?
  2. What is credited when petty cash is replenished?
  3. What are two different adjustments that need to be made to the bank statement cash balance when preparing a bank reconciliation?

II.  Objectives

  • Interpret and synthesize information from source documents to prepare a bank reconciliation resolving conflicting information when possible.
  • Analyze data and create formulas in Excel to determine variations in sales which may be related to employee skimming.

III.  Chapter 5 Test on Friday – 3rd hour

                        Thursday for 4th & 6th Hour

IV.  Classwork

  • Finish 5-C on Aplia
  • Forensic Accounting page 112
Nov 14

Marketing – 11/15/17

I.  Bellwork:Q&A

W6_Pit_Stop_Building_Credit

  1. What are the three major Credit Reporting Agencies?
  2. Explain what a FICO score is and how it is used?
  3. In the real world, the recommendation is to keep the credit utilization to what percent?

II.  Objectives

  • Explain how credit scores can have an impact on future financial decision
  • Examine how financial behaviors can impact a credit score
  • Interpret, discuss, and analyze  data to make informed financial decisions

III.  Discussion

IV.  Classwork

A.  H &R Block Budget Challenge

  • Record payments and deposits
  • Take Quiz

B.  Page 418 Vocabulary Content & Academic (10)

 

Nov 13

Management – 11/14/17

I.  Bellwork

A.  NYT: NSA struggling following major leaks

Summarize the article:  1 paragraph 4-6 sentences

  • Who, what, where, why, and how

II.  Objectives:

  • Present information on technology threats, conveying a clear and distinct perspective, such that listeners can follow the line of reasoning, and the organization, development, substance, and style are appropriate to purpose, audience, and a range of formal and informal tasks
  • Evaluate presentations based upon the depth of information provided and skills used to communicate the information

III.  Classwork:

Present Presentation

Evaluate Presentations:   Rubric