Making Connections : Lesson Plan

From: Subject: Making Connections : Lesson Plan Date: Fri, 1 Feb 2008 09:12:00 -0600 MIME-Version: 1.0 Content-Type: multipart/related; type="text/html"; boundary="----=_NextPart_000_0000_01C864B2.80C06D70" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 This is a multi-part message in MIME format. ------=_NextPart_000_0000_01C864B2.80C06D70 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Content-Location: http://mconn.doe.state.la.us/lessonplan_preview.php?lesson_id=127643 Making Connections : Lesson Plan

Lesson Plan

Title:  Pecoraro, L. - = Feb 11 -=20 Feb 15 - IBCA

Subject:  Business = Education=20

Grade = Level:  9 - 12

Overview:

Assignments on Board

Approximate=20 Duration:  1 week

Content Standards:=20

Standard = 18
     The=20 student will apply proper keyboarding techniques to input = data and=20 produce personal and business documents. =

Benchmarks:=20
=
BE-18-A
     Develop touch=20 keyboarding skills at acceptable speed and accuracy = levels. =
BE-18-C
     Develop=20 keyboarding skills to input and manipulate text and = numerical data=20 to produce usable documents.

Objectives:
CH 11 Excel - = =93Inserting=20 Formulas in a Worksheet=94 =96 Students will: insert a = formula in a cell=20 using =93Auto Sum=94 button; type a formula in the formula = bar; use the=20 paste function to insert a formula; name a range of cells = and use a=20 range in a formula; create an absolute and mixed cell = reference,=20 link cells between worksheets; link worksheets using 3-D = references;=20 plan and create a worksheet.

Lesson Materials=20 and Resources:

Technology Tools=20 and Materials:

Hardware:

Software:

Other:

Background=20 Information:

Lesson=20 Procedures:
All work will be saved on the = student's=20 computer.

Monday =96 Excel =96 Ch 10 =96 Students = will complete=20 Assessments 1 =96 8 (pg 456 =96 460 in Office book, Red = section).=20 Students will do =93Thinking Offline=94 questions 1-14 for = Ch 10, page=20 454.

Tuesday =96 Print packet of selected exercises = and=20 assessments from Ch 10 (excel) for a grade. Questions will = be=20 checked in class and students will print them. Students have = questions, handouts, and chapter summaries to study from Ch = 9 &=20 10 for the test tomorrow.

Wednesday =96 TEST on Ch 9 = & 10=20 (excel). After test, students will start Ch 11 (excel) =96 = =93Inserting=20 Formulas in a Worksheet=94. Students will complete exercises = 1-=20 7.

Thursday =96 Ch 11 (excel) in MS Office Book =96 = Continue on=20 Exercises 8 =96 15.

Friday =96 Ch 11 (Excel) =96 = Complete Exercises=20 16 =96 23. Save all exercises. Selected ones will be printed = next week=20 for a grade in a packet. Start Assessments if=20 time.

OBJECTIVES: CH 11 Excel - =93Inserting Formulas = in a=20 Worksheet=94 =96 Students will: insert a formula in a cell = using =93Auto=20 Sum=94 button; type a formula in the formula bar; use the = paste=20 function to insert a formula; name a range of cells and use = a range=20 in a formula; create an absolute and mixed cell reference, = link=20 cells between worksheets; link worksheets using 3-D = references; plan=20 and create a worksheet.

Assessment=20 Procedures:
Tuesday - Ch 10 packet of selected = exercises=20 and assessments will be printed for a = grade.

Wednesday - TEST=20 on Excel Ch 9 & 10 (Students have handouts, questions, = and=20 chapter summaries to study).

Accommodations/Modifications:
Any=20 student who has an IEP will have their guidelines followed. =
Any=20 student who is 504 will have their guidelines = followed.
=20 ----- written by Luzette=20 Pecoraro

Explorations and=20 Extensions:

Lesson=20 Development Resources:

Reflections:

Contact=20 Information:
Luzette Pecoraro
lulupec@bellsouth.net=20
Northshore High School

Additional=20 Contacts:

MarcoPolo=20 Lesson:  No

=20 =

------=_NextPart_000_0000_01C864B2.80C06D70 Content-Type: text/css; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Location: http://mconn.doe.state.la.us/mc01.css .button01 { COLOR: #ffffff; BACKGROUND-COLOR: #004b84 } .button02 { COLOR: #ffffff; BACKGROUND-COLOR: #206ba4 } .button03 { FONT-SIZE: 10px; COLOR: #ffffff; BACKGROUND-COLOR: #cc8800 } .button04 { FONT-SIZE: 13px; COLOR: #ffffff; FONT-FAMILY: 'Arial Narrow'; = BACKGROUND-COLOR: #206ba4 } .button05 { FONT-SIZE: 17px; COLOR: #ffffff; BACKGROUND-COLOR: #cc8800 } .interLink { FONT-WEIGHT: 600; MARGIN-BOTTOM: 10px; CURSOR: pointer; COLOR: #004b84; = TEXT-DECORATION: underline } DIV.interLink:hover { COLOR: red } P { FONT-FAMILY: Arial, Verdana, Helvetica, Sans-serif } FONT { FONT-FAMILY: Arial, Verdana, Helvetica, Sans-serif } TD { FONT-FAMILY: Arial, Verdana, Helvetica, Sans-serif } LI { FONT-FAMILY: Arial, Verdana, Helvetica, Sans-serif } TEXTAREA { FONT-FAMILY: Arial, Verdana, Helvetica, Sans-serif } SELECT { FONT-FAMILY: Arial, Verdana, Helvetica, Sans-serif } A:link { COLOR: #004b84 } A:visited { COLOR: #004b84 } A:hover { COLOR: red } A:active { COLOR: red } .sideBarLink01:link { FONT-WEIGHT: bold; FONT-SIZE: 100%; COLOR: #ffffff; TEXT-DECORATION: = none } .sideBarLink01:visited { FONT-WEIGHT: bold; FONT-SIZE: 100%; COLOR: #ffffff; TEXT-DECORATION: = none } .sideBarLink01:hover { FONT-SIZE: 100%; COLOR: #000000; TEXT-DECORATION: none; = 1background-color: #000000 } .sideBarLink01:active { FONT-SIZE: 100%; COLOR: #000000; TEXT-DECORATION: none; = 1background-color: #000000 } #sectionLink1 { COLOR: #ffffff; TEXT-DECORATION: none } #sectionLink1:hover { COLOR: #cc8800; TEXT-DECORATION: none } .stTDLink1:visited { COLOR: #ffffff; TEXT-DECORATION: none } .stTDLink1:link { COLOR: #ffffff; TEXT-DECORATION: none } .stTDLink1:active { COLOR: #ffffff; TEXT-DECORATION: none } .stTDLink1:hover { COLOR: #aaaaaa; TEXT-DECORATION: none } .edit_class { COLOR: #004b84 } .sectionHead { FONT-WEIGHT: bold; FONT-SIZE: 150%; COLOR: #ffffff } .sideMenu { FONT-SIZE: 85%; COLOR: #ffffff } .tableHead01 { FONT-WEIGHT: bold; FONT-SIZE: 85%; COLOR: #ffffff } .builderMenu01 { FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffffff } .bannerText1 { PADDING-RIGHT: 2px; PADDING-LEFT: 2px; FONT-SIZE: 10px; PADDING-BOTTOM: = 2px; COLOR: #000000; PADDING-TOP: 2px; 1background-color: #cfd2e5 } .bannerText2 { FONT-SIZE: 10px; COLOR: #000000; 1background-color: #cfd2e5 } ------=_NextPart_000_0000_01C864B2.80C06D70--