Subject: Computer Applications II
1. Topic-
Creating Your Own Spreadsheet
2. Content-
Workbook, Spreadsheet, Rows, Columns, Interface, View, AutoSum, Sorting, Charts, Format Numbers
3. Goals: Aims/Outcomes-
1. Students will gain the knowledge and skills to create their own mini Spreadsheet
2. Identify, gather and input data into a spreadsheet
3. Create, copy and paste formula in a spreadsheet
4. To work cooperatively with peers in groups.
5. Successfully print spread to a document and drop into School Loop a particular area of a spreadsheet.
6. Identify MS Excel 2007 as a tool used for organizing and manipulating data.
4. Objectives-
1. Identify key ways of utilizing MS Excel 2007 as an essential computer technology tool
2. Create a spreadsheet within a workbook.
3. Input data, create, drag & drop, copy & paste formulas and functions.
4. Obtain information from various sources.
5. Review the MS Excel interface, standard/formatting toolbars and ribbon/tabs.
6. Review a workbook/worksheet, cells, columns, rows and MS Excel cursors.
7. Basic use of various Mathematical formulas.
5. Materials and Aids-
1. LCD Projector
2. Computer with MS Office and Internet access for all students to obtain data.
3. Worksheet handouts
4. Rubric sample of a completed Spreadsheet.
5. (P) Personal drive to save and store completed self-created spreadsheet.
6. Procedures/Methods-

A. Introduction-

Whole class discussion Q & A about MS Excel Spreadsheet, e.g., what has been learned so far.

B. Development-

2. MS Excel Spreadsheet will be open and cell contents identified.
3. Review previous lesson worksheets.
4. Question student on completing lesson "Common Task?
5. Request student to demonstrate knowledge of naming, deleting worksheet and adjusting row heights and column width, in addition to formatting cells

C. Practice-

1.As a class we will create on mini-spreadsheet.
2.Each student will verbally add their record (? What your age, birthday and or year etc...)
3. Mr. Burns will demonstrate formula function, drag & drop, copy and pasting, print screen and printing to a document.

D. Independent Practice-

1.Student will create their own spreadsheet, either using homework data or accessing source data from various sources, including the Internet.
2.It's OK for students to work in no more thank groups of 3 student per-peer group and speak out loud.
3. Student will be given drive on how to setup print area, print screen and printing to a document.
4. Also, how to drop completed spreadsheet into School Loop.

E. Accommodations (Differentiated Instruction)-

1. If student prefer, they can complete the assignment using hand written paper form, using the computer to copy inputed data and calculators to calculate data results.

2.Those students who are quick to create will be given additional point for becoming TA and or monitors.
3. Experienced in spreadsheet creation will display their completed spreadsheet using the LCD projection and teacher computer.

F. Checking for understanding-

1. I will case the lab/classroom to monitor students/groups as they work on their spreadsheets.
2.Challenge students on various ways to review data, sort, chart and format numbers.
3. Review student selecting print area, print screen and printing to a document.

G. Closure-

1.Whole class discussion Q & A, group presentation of created spreadsheets.
2. student can use whiteboard to demonstrate points of view.
3. Student will write reflections on what they learned.
7. Evaluation-
1. Mr. Burns will review each students workbook/spreadsheet individually to check they have the understanding of how to create a spreadsheet.
2. An MS Excel sample assignment will stand as a rubric.
3. Critique and scored assignments will be returned to student for further discussion.
8. Teacher Reflection-
Review of the lesson overall and it affect on student computer technology learning, and noting those areas of weakness and strength.

This Lesson Plan is available at (