Please check here for important dates and other information related to the course.
I send out electronic progress reports via email every other Friday. If you are not receiving one, please email me and make sure I have the correct email address. If you do not have an email address, please look for a hard copy sent home with your child on Friday.
!!!! EXCEL FINAL EXAM IS FRIDAY!!!!!! 11/6
Week of 11/30 - 12/4
EOCT's are Monday thru Thursday
Friday there will be a substitute teacher. Your assignments are due at the end of class on Friday.
There will be an Access Quiz on Tuesday 12/8
Week of 11/2 - 11/6
Day
GPS Standard
Essential Question(s)
DO NOW
Tasks/ Activities
MON
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create Pivot Tables and Charts
What is a pivot table? What vocabulary is associated with it?
Free Write
Ethics Worksheet Discussion
Small Group Skit design
HW - Excel study Guide
TUES
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create Pivot Tables and Charts
What is a Pivot Chart? Is it similar to a normal Excel Chart?
Free Write
Keytrain
Pivot Chart Intro
Pivot Chart practice pairs)
WED
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create Pivot Tables and Charts
How do you setup for a pivot chart?
Does it provide different data than a pivot table or is it just for display of data?
Free Write
Pivot table and chart review
Pivot Table and Chart test
THURS
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish industry appropriate files.
All subareas
Excel Unit Review
Free Write
Excel Class Review
Class review game (teams)
Keytrain Practice
FRI
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish industry appropriate files.
All subareas
Excel Final
Free Write
Excel Final
Week of 10/26 - 10/30
Day
GPS Standard
Essential Question(s)
DO NOW
Tasks/ Activities
MON
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create Pivot Tables and Charts
What is a pivot table? What vocabulary is associated with it?
What do you remember about Pivot Tables from Friday?
Keytrain Practice
Pivot table Article Questions
Article/Questions Discussion
Graphic Representation or Key Points Illustration
TUES
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create Pivot Tables and Charts
When should a pivot table be used?
What sort of data is necessary for using a Pivot Table?
Free Write
Pivot Table Inventory Intro
Classroom Inventory Assignments
Begin Inventory
WED
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create Pivot Tables and Charts
How do you setup and run a pivot table?
Free Write
Keytrain Practice
Key Inventory Data into Spreadsheets
Pivot Table practice (whole class)
THURS
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create Pivot Tables and Charts
Pivot Table Practice
Free Write
Keytrain
Pivot Tables Class Practice Review
Pivot Tables Individual Exercises
FRI
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create Pivot Tables and Charts
.
.
Pivot Table Practice
Free Write
Lunch Duty Pivot Table Practice (pairs) Students will make changes to others spreadsheets and then owner will create tables to answer questions.
System Wide spreadsheet explanation and practice
Keytrain Practice
Week of 10/19 - 10/22
Last week was a week filled with testing, meetings, and other necessary interruptions. Due to the interruptions, we were not able to get to many of the things I had planned for the week completed. So this week's lesson plans look very much like last weeks.
Day
GPS Standard
Essential Question(s)
DO NOW
Tasks/ Activities
MON
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create an effective chart or graph which represents relevant data.
Edit and label chart components such as axis, legends, titles, and data tables.
Functions and Charts Review
Write as many facts, terms, and ideas about charts and functions as you can.
Finish Article Presentations
Keytrain Practice
Discuss Functions Scenarios HW
Charting Quiz Review
TUES
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create an effective chart or graph which represents relevant data.
Edit and label chart components such as axis, legends, titles, and data tables.
Quiz over chart elements
Test on creating a chart
Free Write
Chart Elements Quiz
Charting Quiz
WED
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create Pivot Tables and Charts
What is a pivot table? What vocabulary is associated with it?
What things should you look for in choosing a college?
Keytrain Practice
Pivot Tables Vocab
Pivot Tables Intro
THURS
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create Pivot Tables and Charts
When should a pivot table be used?
How do you setup and run a pivot table?
Free Write
Pivot Tables Class Practice
Pivot Tables Individual Exercise
Week of 10/12 - 10/16
Day
GPS Standard
Essential Question(s)
DO NOW
Tasks/ Activities
MON
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create an effective chart or graph which represents relevant data.
Edit and label chart components such as axis, legends, titles, and data tables.
How do you design a spreadsheet and chart from scratch?
How do you determine what data is relevant for your chart?
What things should you look for in choosing a college?
Healthy Web quest activity
Article presentations
TUES
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create an effective chart or graph which represents relevant data.
Edit and label chart components such as axis, legends, titles, and data tables.
Quiz over chart elements
Present Articles
Free Write
Finish Article presentations
Chart Elements Quiz
Keytrain
WED
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create an effective chart or graph which represents relevant data.
Edit and label chart components such as axis, legends, titles, and data tables.
Test on creating a chart
Free Write.
PSAT (lesson depends on attendance)
Charting Quiz
THURS
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create Pivot Tables and Charts
What is a pivot table? What vocabulary is associated with it?
Free Write
Keytrain
Work on Essays
Pivot Tables
FRI
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create Pivot Tables and Charts
.
.
What is involved in creating a pivot table?
Free Write
Pivot tables review
Finish Pivot tables activity
Week of 10/5 - 10/9
Day
GPS Standard
Essential Question(s)
DO NOW
Tasks/ Activities
MON
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create an effective chart or graph which represents relevant data.
Edit and label chart components such as axis, legends, titles, and data tables.
How do you create a chart in Excel?
How was your weekend?
Key Essays
Chart Intro
Class survey
TUES
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create an effective chart or graph which represents relevant data.
Edit and label chart components such as axis, legends, titles, and data tables.
What are the chart elements?
What purpose do each of them serve?
Free Write
1. Chart Instruction
2.Holiday Charting Exercise
WED
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create an effective chart or graph which represents relevant data.
Edit and label chart components such as axis, legends, titles, and data tables.
How do edit charts and make formatting changes?
Free Write.
1.Basket weaving Chart practice
2.
THURS
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Create an effective chart or graph which represents relevant data.
Edit and label chart components such as axis, legends, titles, and data tables.
How do edit charts and make formatting changes?
My Personality is ……
1.Chart Elements Quiz
2.Charting Quiz (Excel Case Test)
FRI
BCS-CA2-6 BCS-CA2-2 b. Create a variety of business and technical documents using template or composition…..
Use merge features to create specialized documents Apply editing and enhancement features to cell contents.
.
How can you improve your reading and critical thinking skills?
Free Write
1.Keytrain
2.Critical Thinking
Week of 9/28 - 10/2
Day
GPS Standard
Essential Question(s)
DO NOW
Tasks/ Activities
MON
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Identify components of the spreadsheet window using correct terminology.
Create, edit and apply templates.
What do the different Excel Functions mean?
How to you interpret written directions into Functions?
How was your weekend?
Functions Demo
Formulas/Functions Practice Spreadsheet
TUES
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Apply and edit functions
Copy, move and verify accuracy of formulas
What do Excel Functions actually do for your data?
Free Write
1. Review Functions
2.Finish Formula functions practice
3.Written Function Scenarios w/s in pairs
WED
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Apply and edit functions
Apply and edit functions
Copy, move and verify accuracy of formulas
What do Excel Functions actually do for your data?
Free Write.
1.Substitute
2.Finish Function Scenarios
THURS
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
.
Apply and edit functions
Apply and edit functions
Copy, move and verify accuracy of formulas
What is a SumIf function? How is it different from and If?
My Personality is ……
1.If Statements introduction
2.If Statements practice (car dealer spreadsheet – whole class)
FRI
BCS-CA2-6 BCS-CA2-2 b. Create a variety of business and technical documents using template or composition…..
Use merge features to create specialized documents Apply editing and enhancement features to cell contents.
.
How can you improve your reading and critical thinking skills?
Free Write
1.Keytrain
2.Critical Thinking
Week of 9/21 - 9/25
Day
GPS Standard
Essential Question(s)
DO NOW
Tasks/ Activities
MON
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Identify components of the spreadsheet window using correct terminology.
Create, edit and apply templates.
What vocabulary is associated with Excel? What are some of the major functions of the Excel window?
Why is appearance important in business? Can it affect your career?
Formatting (shading, number formats, fill series) Demo
Creating a template (save as)
Party Planning Template
TUES
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Identify components of the spreadsheet window using correct terminology.
Create, edit and apply templates.
How do you create and save a template for future use in excel?
Free Write
Finish Party planning template
Formulas review
Formulas practice
WED
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Identify components of the spreadsheet window using correct terminology.
Apply and edit functions
How do you write a formula in Excel?
Free Write.
Family budget spreadsheet using formulas
Grocery List template
THURS
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Identify components of the spreadsheet window using correct terminology.
Apply and edit functions
How do you write a formula in Excel? What functions are available for calculations?
Free Write
With partner – tropical foods project.
FRI
BCS-CA2-6 BCS-CA2-2 b. Create a variety of business and technical documents using template or composition…..
Use merge features to create specialized documents Apply editing and enhancement features to cell contents.
.
How can you improve your reading and critical thinking skills?
Free Write
Keytrain
Critical Thinking
Week of 9/14 - 9/18
Day
GPS Standard
Essential Question(s)
DO NOW
Tasks/ Activities
MON
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Identify components of the spreadsheet window using correct terminology.
Create, edit and apply templates.
What vocabulary is associated with Excel? What are some of the major functions of the Excel window?
Describe your most memorable vacation or your dream vacation.
Graphic Object Skills h/o
Excel Window Demo
Formatting practice (names on Smartboard)
Templates Instruction
Home Contents Inventory template
TUES
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Identify components of the spreadsheet window using correct terminology.
Create, edit and apply templates.
How do you create and save a template for future use in excel?
Free Write
Creating a template (save as)
Party Planning Template
WED
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Identify components of the spreadsheet window using correct terminology.
Apply and edit functions
How do you write a formula in Excel?
Crete an acrostic name poem for your name.
Formula review and practice
Family budget spreadsheet using formulas
THURS
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Identify components of the spreadsheet window using correct terminology.
Apply and edit functions
How do you write a formula in Excel? What functions are available for calculations?
Free Write
With partner – tropical foods project.
FRI
BCS-CA2-6 BCS-CA2-2 b. Create a variety of business and technical documents using template or composition…..
Use merge features to create specialized documents Apply editing and enhancement features to cell contents.
.
How can you improve your reading and critical thinking skills?
Free Write
Keytrain
Critical Thinking
Week of 9/7 - 9/11
Day
GPS Standard
Essential Question(s)
DO NOW
Tasks/ Activities
MON
NO SCHOOL
LABOR DAY
NO SCHOOL
LABOR DAY
NO SCHOOL
LABOR DAY
NO SCHOOL!
TUES
BCS-CA2-2 b. Create a variety of business and technical documents using template or composition…..
Use merge features to create specialized documents
How do you complete the mail merge process?
Free Write
Finish writing college letters
Small group proofreading
Revisions
Print Letters
WED
BCS-CA1-4 Students will use spreadsheet software to create, edit, and publish.
Identify components of the spreadsheet window using correct terminology.
How do you correctly address and print an address on an envelope?
What makes you smile?
Envelope addressing
Print Envelopes
keytrain
THURS
BCS-CA2-2 b. Create a variety of business and technical documents using template or composition…..
Use merge features to create specialized documents
What vocabulary is associated with Excel? What are some of the major functions of the Excel window?
What characteristics do you look for when choosing friends and/or boyfriends and girlfriends?
Excel Intro vocab
Pages (358, 365, 372, 379, 387) 27 words
Read pages 358 – 360
Excel window demo
FRI
BCS-CA2-6 Students will utilize appropriate methods to collaborate, publish, and interact with peers, teachers, experts, and other audiences,
.
How can you improve your reading and critical thinking skills?
Free Write
Keytrain
Template in Excel
(Inventory)
Week of 8/31 - 9/4
Day
GPS Standard
Essential Question(s)
DO NOW
Tasks/ Activities
MON
BCS-CA2-2 b. Create a variety of business and technical documents using template or composition…..
Create tables including calculations and special features.
How do sort data in a table?
What are the different font types and when is it appropriate to use them?
Tolerance is the word of the month. What does it mean and why is it important?
Demonstration – font types and sorting data in a table
Fruit tables
TUES
BCS-CA2-2 b. Create a variety of business and technical documents using template or composition…..
Use merge features to create specialized documents
What is mail merge used for? How does it make writing many letters easier?
Free Write
Mail merge introduction
College survey
Letter writing activity
WED
BCS-CA2-2 b. Create a variety of business and technical documents using template or composition…..
Use merge features to create specialized documents.
What is mail merge used for? How does it make writing many letters easier?
Describe your happiest memory?
1.Finish mail merge addresses and letter writing.
2.Small group proofreading
3.Revisions
THURS
BCS-CA2-2 b. Create a variety of business and technical documents using template or composition…..
Use merge features to create specialized documents
How do you use mail merge to send out letters to people on a mailing list?
Free Write
1.Print letters and envelopes.
2.Keytrain
FRI
BCS-CA2-6 Students will utilize appropriate methods to collaborate, publish, and interact with peers, teachers, experts, and other audiences,
.
How can you improve your reading and critical thinking skills?
Free Write
1.Keytrain
2.Team Building
3.Critical Thinking building
Week of 8/24 - 8/28
Day
GPS Standard
Essential Question(s)
DO NOW
Tasks/ Activities
MON
BCS-CA2-2 b. Create a variety of business and technical documents using template or composition…..
m. Manipulate graphics by resizing, cropping, scaling…
Import and link charts, tables, etc.
What is a travel itinerary? Why is it important to have one for extended vacations?
If you could go back in time, to where and when would you choose to go?
Turn in Country brochures and rubrics
Itinerary explanation in pairs
Itinerary project
TUES
BCS-CA2-2 b. Create a variety of business and technical documents using template or composition…..minutes
What are minutes for meetings? How do you record them?
Free Write
Finish Itinerary assignment
Minutes notes and examples
Minutes hw assignment (visit community or after school org meeting and record minutes for them)
WED
BCS-CA2-2 b. Create a variety of business and technical documents using template or composition…..
Create tables including calculations and special features.
How do tables help sort information? How are they created and data sorted?
Define success. What makes someone successful? Money? Family? Happiness?
1.Tables intro
2.Sorting records and tables data
3.Continue with table project
THURS
BCS-CA2-2 b. Create a variety of business and technical documents using template or composition…..
. Create tables including calculations and special features.
How do you use mail merge to send out letters to people on a mailing list?
Free Write
1.Finish Table project
2.Mail merge intro
FRI
BCS-CA2-6 Students will utilize appropriate methods to collaborate, publish, and interact with peers, teachers, experts, and other audiences,
.
How can you improve your reading and critical thinking skills?
