Instructor:Bergdolt Course Title: Business Tech Applications Date Oct 23-27

Class(es): 2nd&3rd period

Day 1 /

Overview:

Spreadsheet Applications
Learning Objectives:
Create , edit, and print workbooks
Write formulas
Create Functions
Sort and Filter Data
Crate charts and graphs
Background/Preparation: / Procedures/Activities/Learning Experiences: (Students will)
Report card day and parent conference / Time on Task / Materials/Equipment/Technology:
Evaluation/Assessment Strategies:
Content Standard(s):
Utilize spreadsheet features, including formulas, functions, sorting, and filtering data, templates, charts, and graphs in creating / Integrated Content: SA, TW, R, W, S, SS, M, ES, PS, MS, CTSO /

Total=

/ Remediation
Meet with students after school
Essential Questions:
How do spreadsheet applications simplify
Data commonly used in business settings
: / CCRS:
Day 2 /

Overview:

Spreadsheet Applications
Learning Objectives:
Create , edit, and print workbooks
Write formulas
Create Functions
Sort and Filter Data
Crate charts and graphs
Background/Preparation:
: / Procedures/ Activities /Learning Experiences: (Students will)
Drill - “Sales Forcast” (inserting formulas and adding shading, borders, dollar signs, and image)
Work in Testout / Time on Task / Materials/Equipment/Technology:
Evaluation/Assessment Strategies:
Content Standard(s):
Utilize spreadsheet features, including formulas, functions, sorting, and filtering data, templates, charts, and graphs in creating / Integrated Content: SA, TW, R, W, S, SS, M, ES, PS, MS, CTSO /

Total=

/ Remediation
Meet after and before school with students
Essential Questions:
How do spreadsheet applications simplify
Data commonly used in business settings / CCRS:

*Provisions for individual differences will be made based upon specifications in the student’s Career/Tech Implementation Plan.

Available Industry Credential: Course/Program Culminating Product:

Day 3 /

Overview:

Spreadsheet Applications
Learning Objectives:
Create , edit, and print workbooks
Write formulas
Create Functions
Sort and Filter Data
Crate charts and graphs
Background/Preparation: / Procedures/ Activities /Learning Experiences: (Students will)
Drill - Review – inserting formulas
Excel ch3 Red Dots (see “Check-off” list for required content and elements / Time on Task / Materials/Equipment/Technology:
Evaluation/Assessment Strategies:
Excel ch3 Red Dots
Content Standard(s):
Utilize spreadsheet features, including formulas, functions, sorting, and filtering data, templates, charts, and graphs in creating / Integrated Content: SA, TW, R, W, S, SS, M, ES, PS, MS, CTSO
. /

Total=

/ Remediation
Meet with students after school
Essential Questions:
How do you professionally create and develop business documents? Why is this process important? / CCRS:
Day 4 /

Overview:

Spreadsheet Applications
Learning Objectives:
Create , edit, and print workbooks
Write formulas
Create Functions
Sort and Filter Data
Crate charts and graphs
Background/Preparation: / Procedures/ Activities /Learning Experiences: (Students will)
Excel Test #2 (“The Street” Stock Chart) see instruction sheet / Time on Task / Materials/Equipment/Technology:
Evaluation/Assessment Strategies:
Excel Test #2 – “The Street”
Content Standard(s):
Utilize spreadsheet features, including formulas, functions, sorting, and filtering data, templates, charts, and graphs in creating / Integrated Content: SA, TW, R, W, S, SS, M, ES, PS, MS, CTSO /

Total=

/ Remediation
Meet with students after school
Essential Questions:
How do spreadsheet applications simplify
Data commonly used in business settings / CCRS:

*Provisions for individual differences will be made based upon specifications in the student’s Career/Tech Implementation Plan.

Available Industry Credential: Course/Program Culminating Product:

: