| |
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. |
| |
|