Monday, Nov. 12, 2012

Essential Question: What is a spreadsheet or worksheet?

Start up: Students will be given an Excel Handout of the Excel screen. Students are to brainstorm similarities of Microsoft Excel to Microsoft Word. Write down 4 things that are similar comparing an Excel spreadsheet to a Word document.

Students will be given a brief introduction to Microsoft Excel and given some Excel activities so they may later insert an Excel spreadsheet into a Microsoft Word document.

Teacher will demonstrate using Netscape showing students ways that a spreadsheet may be sorted and organized using different worksheets in a workbook. Netscape allows what is on the teacher’s computer screen to be viewed on the student computers as well as using the overhead projector. This helps individualize instruction for students and helps them to be focused on what the teacher is teaching rather than being on the internet or trying to type while the teaching is instructing. The objective is to engage the students.

Students will be guided through an excel activity and then given 2 other excel activities to work on independently. Teacher will walk around the room and monitor to ensure student’s understanding of the Excel activities.

Practice 1—Sales for the Month
Teacher will guide students through activity
Students will type in text and numbers in a worksheet
Format all numbers as currency
Center the Spreadsheet heading and merge cells A1-E1
Apply shading to Row 1 and 2
Center headings in Row 2
Create a formula to display a total for each sales rep
Create a formula to display a total for each product
Make an excel folder and save as "Sales for the Month"

Task Number 1- Gray’s Incorporated Outstanding Salesmen
Students will input data into an excel spreadsheet
Students will perform calculations using the autosum function.
Students will bold all headings and format numbers as currency.
Save as "Task Number 1" in your Excel folder
Task Number 2- Salary Package/Gray’s Executive Officers
Students will input data correctly into an Excel spreadsheet
Students will insert formula to determine salary package
Students must capitalize all proper nouns.
Students should bold headings and underline headings.
Left align text and right align numbers
Save as "Task Number 2"

Students will be given a daily grade on "Task Number 2" to ensure understanding.

5 pts. off will be deducted for:
Every formatting error (including alignment, underlining, capitalization)
Each wrong calculation of the salary package.
Closure: Teacher will ask questions of students and monitor students to ensure understanding.