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.

Friday, November 9, 2012

Today is a make-up day for any unfinished assignment to be completed and/or make up the table test. Students are to use time wisely to complete assignments to replace zeros in the gradebook.

Thursday, Nov. 8, 2012

Students will finish mail merge activities which include learning to make a database that is needed for the mail merge activity.
Students will also complete Word It! Activity 29 learning to make mailing labels
for the mail merge activities.
Students will complete a handout reinforcing skills to make labels.

Wed., Nov. 7, 2012

Mail Merge Activities

Students will complete the following activities
Activity 28 Prom Invites in Word It! on pg. 54.
Mail Merge Activity 29 in Word It! on pg. 57.
Students will create a sheet of labels with different addresses. Green Briar High School Mail Merge Handout

Tuesday, Nov. 6, 2012

Word Project: Apply and Manipulate Textboxes
Report with Hyperlinks

 
 

Tuesday, November 6, 2012

Students will complete the following activities:

• Word Project and Manipulate Textboxes handout

• Report with Hyperlinks (on other side of first assignment)

• Employee Personal Form

Monday, Nov. 5, 2012

Monday—

Start up: Finish Create and write a newsletter about GHS Homecoming using a template as a guide. Students should insert clipart appropriate to the content of the newsletter.

Some important dates and information about Homecoming:

 

Monday, Oct. 22--Orders due for Homecoming t-shirts.  Long sleeved shirts are $15 and short sleeve shirts are $10. Shirts will be delivered during 4^th period on Wed., Oct. 31

 

Tues.-Thurs. Oct. 23-25 we will vote for the Homecoming Court during both lunches.

 

Dance tickets will be sold during both lunches for $10 each beginning Monday, October 22 and sold until 

Friday, Nov. 2.

There will be no sales at the door and no discount for Platinum. If you attend with a date from another school, you must give the name of the student and the name of the school he/she attends.

 

 The week of October 29-Nov. 2 will be our Homecoming Spirit Week Dress days. 

Monday- Neon Day

Tuesday- Intellectual (Nerd) Day

Wednesday- America Day

Thursday-College day

Friday- Spirit Day

 

We will vote for Homecoming Queen during both lunches on Tues., Oct. 30- Thursday, Nov. 1.

 

The Homecoming Parade is Thursday, Nov. 1 around the Gainesville Square at 6:00. Please let me know if your club plans on participating. 

 

Friday, Nov. 2, we will have a pep rally. The cheerleaders and band will perform and well as some GHS students. The speaker at the pep rally will be Dr. Merrianne Dyer, the superintendent of Gainesville City Schools and City Councilwoman and former GHS teacher, Myrtle Figueras. Some senior football players will talk about the game against Loganville.

 

The Homecoming Queen will be crowned at halftime of the football game that night.

 

The Homecoming Dance will be Saturday, Nov. 3 from 8:30-11:00 at the Arts Depot. 

Students will complete Activity 23 Thank You Letter in Word It! on pg. 44.

·        The letter is a modified block style letter.

·        Create an envelope for the letter

Students will complete Activity 24 Cover Letter on pg. 47 in Word It!

·        The letter is a block style letter

·        Create an envelope for the letter.

Students will complete Activity 25 Complaint Letter on pg. 50 in Word It!

·        The letter should be modified block style

·        Create an envelope