Monday, Nov. 26, 2012

Start up: Review for Microsoft Test

Students will log on to quizstar to take review. Students will check to see which ones they got wrong and write down the question and answer.

Students will complete Job Simulation Activities on pgs. 218-226 in the Century 21 book which help prepare and review for the Microsoft Word certification test. They will include:
Table activities
Letter activities
Outline activities
Email activities
Numbered list activities
Memo activity
Unbound report
Organizational chart
Powerpoint presentation
Follow directions listed in the book and save as directed in the book.

Friday, November 16, 2012

1st Round of Playoffs---GHS vs. Rome
Go Big Red!!!!
Have a happy Thanksgiving!!!

Create a folder in your Word folder. Title it JOB SIMULATION. Save each job in your JOB SIMULATION FOLDER.
Students will complete Job Simulation Activities on pgs. 218-226 in the Century 21 book which help prepare and review for the Microsoft Word certification test. They will include:


Table activities
Letter activities
Outline activities
Email activities
Numbered list activities
Memo activity
Unbound report
Organizational chart
Powerpoint presentation
Follow directions listed in the book and save as directed in the book.

Thursday, Nov. 15, 2012

I am at a FBLA conference in Athens with students.

Essential Question: What is an agenda and when would it be used in the workplace?

Students will complete Job Simulation Activities on pgs. 218-226 in the Century 21 book which help prepare and review for the Microsoft Word certification test. They will include:

·      Table activities

·      Letter activities

·      Outline activities

·      Email activities

·      Numbered list activities

·      Memo activity

·      Unbound report

·      Organizational chart

·      Powerpoint presentation

·      Follow directions listed in the book and save as directed in the book.

Wednesday, November 14

Teacher will discuss and demonstrate how to hyperlink text in a document. With the hyperlink feature, users can quickly create text and image links to Web site addresses (URLs) directly within documents. Without having to exit Word, users can simply click on the links and be brought directly to the corresponding Web site.

To prepare for the Microsoft Certification test students will complete Activity 44 on pg. 89 in the Word It! Book.

Students will learn to hyperlink text to Web site addresses within a document
Students should follow all directions listed in the book
After completing assignment, students should test hyperlinks to see if done correctly
Students should save the document as COLLEGES
The next activity expands on Word’s hyperlink feature. In the following activity, students will hyperlink a set of images to Web site addresses within a Word document.

Students will complete Activity 45 Image Links on pg. 91 of the Word It! Book.
Students will hyperlink images to Web site addresses within a document.
Students should follow all directions in book and document should not exceed one page
Click on each hyperlink when finished to verify that each link has been entered correctly.

Save document in your Word folder as IMAGES.

 

Students will be given data files and format a term paper in MLA style.

Students will save the work as Word Project 1.

 
Closure: Teacher will ask questions of students and monitor students to ensure understanding.

Tuesday, Nov. 13, 2012

Students will complete Activity 42 on pg. 84 of the Word It! Book
Students will demonstrate skills previously learned in properly formatting a letter
Students will insert an Excel worksheet into a Word document
Students will format cells in an Excel worksheet including the date
Students will save the document in their Word folder as IDOL.

On Monday, students learned to use the AutoSum function in Excel.

Students will complete Activity 43 on pg. 87 in the Word It! Book

Students will properly format a memorandum
Students will use the AutoSum function in an Excel worksheet inserted into a Word document.
Students will save the document in their Word folder as BUMPER.
Closure: Teacher will ask questions of students and monitor students to ensure understanding.

　

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