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

Wednesday, Oct. 31, 2012

Activity 48 pg. 98 in Word It!

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.

Tuesday, October 30, 2012

Activity 47 School Newsletter on pg. 95 in Word It!

·        Students will create and format a newsletter

·        Students will format with columns

·        Format properly using directions in the book

Monday, Oct. 29, 2012

Dawgs beat the Gators 2 years in a row!!! Happy Monday!

Monday—

Start up: Review for test

 Table Test

Friday, October 26, 2012

Happy Friday!
Students will complete a table review handout for a table test on Monday.
We will play a game to review for the test.
Complete any unfinished tables.

Thursday, October 25, 2012

Start up:
Look at the Wednesday post and do the 10 names and address info as instructed of your favorite musicians. You can make it up.
Complete Schedule for Oak Bay Glee Club Table Handout

• You MUST follow all written directions step by step 

Wednesday, Oct. 24, 2012

Students will complete the table handout with the following tables:

• Family Vacation
• Career Profile
• Instate Tuition

If you finish the 3 tables, come up with 10 names of recording artists that you like or with whom you are familiar. You must have the following info:

1. Name of artist
2. Recording company or name of band
3. Street Address
4. City
5. State
6. Zip Code

Type the following information in a word document and save as "Names for Mail Merge".

Tuesday, October 23, 2012

Essential Question: How do I insert a function into a table?

Starter Activity: Students will complete the table review sheet using the Century 21 book and/or the ribbon on the computer.

Students will complete the following tables on the handout

• Family Vacation
• Career Profile table
• Instate Tuition table

Monday, Oct. 22, 2012

Start up: Table Handout

Plans that were not completed on Oct. 11:

Students will complete the tables on pg. 98 of the Century 21 book.
Table 1
–Make the main title " Famous Composers"
Secondary title should be 1756-1899
Sort the composers info in alphabetical order
Save as 34B-TBL1 Table 2
Main title –Top Ten Daily Newspapers
Secondary title- United States
Save as 34B-TBL2 Table 3
Main title—Top Baseball Movies
Secondary title- Fall 1999
Column headingsl-Rank, Movie, Year, and Percent of Votes
Don’t forget the 10^{th movie info in the left column
Add the source
Save as 34B-TBL# Type the table in Activity 1 as shown on pg. 189
All rows should have a height of .5
Center the table vertically and horizontally
Save as WPS-ACT1 Finish any uncompleted tables.}

Friday, October 19, 2012

PINK OUT! Go Big Red! Beat Clarke Central!

Essential Question: How do you sort text in a table?

Complete table 2 on pg. 199 of the Century 21 Book

·        Follow all directions in the left margin

·        Include the source note outside the table

·        Save as 63B-TBL2

Complete table 3 on pg. 199 of the Century 21 Book

·        Follow all directions in the left margin

·        Save as 63B-TBL3

Students will complete Table 1 on pg. 200 of the Century 21 Book

·        Follow all directions in the left margin

·        Add missing information

·        Save as 64B-TBL1

Complete any unfinished tables.

Thursday, Oct. 18, 2012

Essential Question: How do you add shading to a table?

Students will complete the table at the bottom of pg. 194 in the Century 21 Book.

·        Shade as pictured.

·        Save as 61C-TBL1

Students will complete Table 3 on pg. 195 of the Century 21 Book.

·        Add the missing information to the table with the names in the left margin

·        Shade as pictured and follow directions in the left margin.

·        Save as 61C-TBL3

Page 196 in the Century 21 Book

·        Open 61C-TBL3 and make the changes as directed.

·        Save as 62C-TBL1

Type table 1 on page 197 of the Century 21 Book

·        Follow directions in the left margin of the book

·        Change row heights as directed

·        Save as 62D-TBL1

Type table 2 on pg. 197 of the Century 21 Book

·        Follow directions in the left margin of the book concerning:

o   Row height

o   Shading

o   Alignment

·        Save as 62D-TBL3

Type the table on pg. 198 of the Century 21 book.

·        Follow directions in left margin of book.

·        All data should fit on a single line.

·        Save as 63B-TBL1

Tuesday, Oct. 16, 2012

Essential Question: How do you split cells in a table?

Students will complete the tables on pg. 190 of the Century 21 Book.

·      Activity 3

o   Student s will learn to split cells

o   Shade the table as pictured

o   Center horizontally and vertically

o   Save as WP8-ACT3

·      Activity 4 A

o   Type the table with the Top 10 All Time Films

o   Shade as pictured

o   Sort the table by year of the release

o   Save as WP8- ACT4A

Students will complete the table on pg. 191

·      Students will type the table “Fifth & Sixth Grade Tournament Schedule”

·      Shade the table as pictured

·      Save as WP8-ACT5

Students will complete the table on pg. 192 of the Century 21 Book

·      Follow directions in left column

·      Change row height to .3 for all rows

·      Change vertical alignment to Center for the column headings and to Bottom for all other rows

·      Center horizontally and vertically

·      Save as 60C-TBL1

Students will complete the table 2 on pg. 193 of the Century 21 Book.

·      Follow directions in the left margin to change the row heights.

·      Follow all formatting directions--- bold main title and column headings, and alignment

·      Save as 60C-TBL2

Students will complete table 3 on pg. 193 of the Century 21 Book.

·      Follow directions in left margin of the book.

·      Change row heights as directed in book.

·      Save as 60C-TBL3