| |
Subject: English/Second Language |
|
1. Topic-
|
|
|
2. Content-
|
| Creating a basic payroll using functions, formulas, copying, pasting,
and printing. |
| |
|
3. Goals: Aims/Outcomes-
|
1. Identify Excel as a tool used for manipulating data
2.Identify, gather and input data into a spreadsheet
3.Successfully create, copy and paste formulas and functions.
4. to be able to work collaboratively with peers in groups
5. Successfully print areas of the spreadsheet. |
| |
|
|
4. Objectives-
|
1.Identify ways of utilizing Excel as a tool
2. Students will be able to identify and create a spreadsheet.
3. Students will successfully record data and be able to create, copy
and paste formulas and functions.
4. Students will acquire information using various resources.
|
| |
|
5. Materials and Aids-
|
Students will be provided a computer workstation in the computer
lab.
Students will utilize Microsoft Excel to develop a spreadsheet using
the data
they obtain.
Students will have access to the Internet.
Students will be given a copy of the rubric to refer to while working
on this lesson.
A laptop/projector set up will be provided for presentation.
A flash drive will be used to save and copy student work onto the
laptop.
A shared drive will be available to store completed spreadsheets. |
| |
|
6. Procedures/Methods-
|
|
A. Introduction-
1.First we will discuss uses of spreadsheets
2.A payroll with three records will be opened and cell contents identified.
3.Discussion on the data necessary to complete a payroll. |
| |
|
|
B. Development-
1.As a class we will add one record of data.
2.Each student will verbally add their record (fictitious); the payroll
now contains 10-12 records.
3.I will demonstrate formula building, copying, pasting and printing. |
| |
|
|
C. Practice-
1.Students will complete the payroll (pay).
2. Overtime, bonus will be added to the spreadsheet
(use of absolute value)
3.They are encourage to look on each others screens and speak out
loud.
4. Students will be given opportunity to print (print preview). |
| |
|
|
D. Independent Practice-
1.Students will create a spreadsheet from scratch(grocery budget,address
list or book inventory a book inventory
2. They will create, copy an paste formulas and functions.
3.They are encourage to look on each others screens and speak out
loud. |
| |
|
|
E. Accommodations (Differentiated Instruction)-
1.Slow typists - they will be able to Open my completed spreadsheet
(as emphasis in this class is not on typing)
2.Quick to create - we we add the overtime calculation and bonus (using
absolute value)
3.Experienced in a payroll (completed examples of advanced payrolls
will be on shared drive, to be explored during breaks) |
| |
|
|
F. Checking for understanding-
1.I will walk around the room as they create and work on their spreadsheets
2.Challenge students by changing the data (pay rate)- does the 'ripple
down' effect occur?
|
| |
|
|
G. Closure-
1.Verbally as a class (encouraging them to speak out loud) describe
(while I write on board) the steps to create a spreadsheet.
2.Students will reflect on what they have learned. |
| |
|
7. Evaluation-
|
I will provide a graded rubric with comments after the project is
completed.
|
| |
|
8. Teacher Reflection-
|
As an instructor, I have never done this. The students have always
evaluated me!
Students will be evaluated using a rubric.
I will forward each student's completed rubric via email. |
| |
|