Monday 6 PM
Trista Beck
Crystal Clemens
Wade Forbes
Lenore Green-Boyle
Dorothy Kline
Debbie Leavitt
Karlie Nix
Laura Robinson
Cynthia Trainor
Jerica Yoas
TT 9
Nicole Becker
Patty Bell
Jeffrey Bosarge
Kyndal Coleman
Tffany Crenshaw
Amanda Dabney
Angela Lee
Amy Moseley
Joe Reddick
Brittany Smith
Kimberly Segler
Angela Suter
Stacy Taylor
Jennifer West
Helen Wiles
Shannika Williams
Chasity Wyatt
TT 11
Laura Blackman
Tiere Bracks
Jennifer Burroughs
Jill Campbell
Lawrence Campbell
Rachelle Carlberg
Inky Fagbongbe
Sarah Horsley
Ashley Johnson
Timothy Johnson
Amy Moseley
Emmett Proudfoot
Elizabeth Sharp
Brooke Smith
Christy Smithweck
Jimmie Sunday
Jennifer Thurgood
Virginia Warren
Kimberly Wesley
TT 2
Erin Bates
Mozhgan Bayatpour
Maria Beck
Shannon Beck
Emily Forsyth
Sara Jones
Marcia Lyles
Leslie Newton
Terri Onderdonk
Angela Petrey
Corey Roberts
Lawanda Stanton
Alfoncer Watson
Alexander White
Monday, March 31, 2008
Another Educational Video Resource
The Annenberg Foundation has a large number of educational videos demonstrating effective teaching techniques. It is free. If you are not already familiar with it, sign in and get started by CLICKING HERE.
Two sites that offer teachers video classroom materials are: Teacher Tube and School Tube . Students and teachers can post their own videos as well. These two resources are also free.
Two sites that offer teachers video classroom materials are: Teacher Tube and School Tube . Students and teachers can post their own videos as well. These two resources are also free.
Sunday, March 30, 2008
Spreadsheet Instructions on Payout Table Now Available
If you are working on understanding payout tables, first read "Dealing with Payments".
The three videos that are now available are:
Payout 1: Setting Up A Payout Table; Solving for PMT
Payout 2: Solving for PV, NPER, and RATE
Payout 3: Creating an Amortization Table
The three videos that are now available are:
Payout 1: Setting Up A Payout Table; Solving for PMT
Payout 2: Solving for PV, NPER, and RATE
Payout 3: Creating an Amortization Table
Friday, March 28, 2008
What's Left?
1. If you have not shared your ADDRESS BOOK with me, you must do that. (Database project)
2. If you have been able to locate your partner's web site, share your critique with me in Google Docs.
3. TRI-FOLD BROCHURES (Draft due next Monday 3/31 or Tuesday 4/1). Final due Mon 4/7 or Tue 4/8)
4. Are your BLOG posts up to date? They should be. A new blog assignment sheet is available. (See Important links).All BLOG assignments are to be completed by Sunday April 27.
5. How are you doing with completing your WEB SITE? It is due the last day of class.
6. Are you practicing for your WORD PROCESSING EXAM? The exam will be given Monday 4/14 and Tudesay 4/15.
Here are some materials to help:
Practice Exam
Practice Document
Explanation of TABS
Explanation of Headers, Footers and how to set page numbering options.
7. Are you practicing for your SPREADSHEET EXAM?
a. You need to know how to set up an address book and to use the CONCATENATE function to join fields.
b. You kneed to know how to set up a table to enable to determine characteristics of a loan: Amount Borrowed (PV), Annual Interest Rate, Periodic (Monthly Interest Rate (RATE). Number of Periods (Payments) (NPER), and the Payment (always expressed in the table as a negative number (PMT)
c. You need to know how to solve for any of these characteristics in situations where you know 3 of them but do not know one.
d. You need to be able to create an Amortization Table.
Materials, including sample exams, will be added this weekend to assist you with this preparation for the examination.
8. iGoogle Page. I will look at your iGoogle Page on Monday 4/7 and Tuesday 4/8.
2. If you have been able to locate your partner's web site, share your critique with me in Google Docs.
3. TRI-FOLD BROCHURES (Draft due next Monday 3/31 or Tuesday 4/1). Final due Mon 4/7 or Tue 4/8)
4. Are your BLOG posts up to date? They should be. A new blog assignment sheet is available. (See Important links).All BLOG assignments are to be completed by Sunday April 27.
5. How are you doing with completing your WEB SITE? It is due the last day of class.
6. Are you practicing for your WORD PROCESSING EXAM? The exam will be given Monday 4/14 and Tudesay 4/15.
Here are some materials to help:
Practice Exam
Practice Document
Explanation of TABS
Explanation of Headers, Footers and how to set page numbering options.
7. Are you practicing for your SPREADSHEET EXAM?
a. You need to know how to set up an address book and to use the CONCATENATE function to join fields.
b. You kneed to know how to set up a table to enable to determine characteristics of a loan: Amount Borrowed (PV), Annual Interest Rate, Periodic (Monthly Interest Rate (RATE). Number of Periods (Payments) (NPER), and the Payment (always expressed in the table as a negative number (PMT)
c. You need to know how to solve for any of these characteristics in situations where you know 3 of them but do not know one.
d. You need to be able to create an Amortization Table.
Materials, including sample exams, will be added this weekend to assist you with this preparation for the examination.
8. iGoogle Page. I will look at your iGoogle Page on Monday 4/7 and Tuesday 4/8.
Additional Materials
Trifold Brochures:
Click Here for instructions on creating a TRIFOLD BROCHURE IN WORD.
The Trifold Video is now available.
Spreadsheets:
Click Here for a general discussion ("Dealing With Payments") of how to create a PAYOUT TABLE and how loans work. Videos are now available. See the special post on new payout Videos.
Click Here for instructions on creating a TRIFOLD BROCHURE IN WORD.
The Trifold Video is now available.
Spreadsheets:
Click Here for a general discussion ("Dealing With Payments") of how to create a PAYOUT TABLE and how loans work. Videos are now available. See the special post on new payout Videos.
Tuesday, March 25, 2008
Foliotek on Thursday
If you have not already registered for Foliotek, you must bring your credit card on Thursday. I will walk you through the Foliotek process and explain the best way to upload required assignments to Foliotek. You can use this information for other classes where Foliotek is used.
Trouble Opening Your Web Site or Your Partner's Web Site?
Google had a problem but has now fixed it.
If you cannot get to your web site, do this:
1. Go to pages.google.com
2. Sign In
3. Click on Site Settings (on right, near to of Site Manager Page
4. Set a Home Page (on left)
5. Click on Go to my homepage
You should go to your home page. If it works, you can now get to your home page and so can your partner. You may have to tell them to follow these instructions to get their home page to work.
If you cannot get to your web site, do this:
1. Go to pages.google.com
2. Sign In
3. Click on Site Settings (on right, near to of Site Manager Page
4. Set a Home Page (on left)
5. Click on Go to my homepage
You should go to your home page. If it works, you can now get to your home page and so can your partner. You may have to tell them to follow these instructions to get their home page to work.
Trouble Watching Videos?
Are you having trouble watching videos, either my instructional videos or movies that are part of your blog assignments?
If so, you probably need to install the latest version of Quicktime. To do this:
1. Go to http://www.apple.com and click on Downloads and then click on Quicktime. Or you can get there by Clicking Here. Install the version that includes the latest version of iTunes (the default). It will take about 5 minutes to install and download. then you should be set to go. If not, email me!
If so, you probably need to install the latest version of Quicktime. To do this:
1. Go to http://www.apple.com and click on Downloads and then click on Quicktime. Or you can get there by Clicking Here. Install the version that includes the latest version of iTunes (the default). It will take about 5 minutes to install and download. then you should be set to go. If not, email me!
Monday, March 24, 2008
New Spreadsheet Video Posted
A video covering the creation of a multiplication table is now available. It also addresses the meaning and use of ABSOLUTE REFERENCES. CLICK HERE to watch this video.
Blog Assignments Updated
The Revised Blog Assignments are now available.
The Wikipedia Blog Assignment has been rescheduled until Week 14 (April 13). Instructions and links are available by CLICKING HERE.
The Wikipedia Blog Assignment has been rescheduled until Week 14 (April 13). Instructions and links are available by CLICKING HERE.
Friday, March 21, 2008
Spreadsheet As Database Instructions
CLICK HERE for the Spreadsheet as Data Base Lesson in text format.
There are two videos for the Spreadsheet as Database Lesson.
The first covers setting up the database. Click Here to watch the first lesson.
The second lesson should be watched after you have set up your data base and entered data. It covers the method for using the CONCATENATE function to combine text fields and data and how to sort data. I also introduce the terms RELATIVE REFERENCE and ABSOLUTE REFERENCE and explain RELATIVE REFERENCE in some detail. Understanding the difference between relative and absolute references, when each is used, and how to designate a reference as an absolute reference (the default a relative reference) is essential to an understanding of spreadsheets. Click Here to watch the second lesson.
There are two videos for the Spreadsheet as Database Lesson.
The first covers setting up the database. Click Here to watch the first lesson.
The second lesson should be watched after you have set up your data base and entered data. It covers the method for using the CONCATENATE function to combine text fields and data and how to sort data. I also introduce the terms RELATIVE REFERENCE and ABSOLUTE REFERENCE and explain RELATIVE REFERENCE in some detail. Understanding the difference between relative and absolute references, when each is used, and how to designate a reference as an absolute reference (the default a relative reference) is essential to an understanding of spreadsheets. Click Here to watch the second lesson.
Thursday, March 20, 2008
Don't Panic if You Cannot Get To Web Site
If you, or the person critiquing your web site, cannot find your index (beginning) page, DO NOT PANIC. Google has messed up the way they are handling index pages and the site settings link on the Page Manager Page. Just send me a gmail telling me what happened and we will sort it all out when Google gets their act together.
Wikipedia Blog Assignment
The Wikipedia Blog Assignment is as follows:
Read the
NPR blog on Wickipedia.
Also read the
NPR article on Wikipedia.
Then listen to the NPR Podcast on Wikipedia by clicking on the LISTEN button on the NPR article page.
Next read the WIRED story about Virgil Griffith, Wikipedia Scanner, and the changes made to Wikipedia by Diebold, a leading maker of voting machines, the FBI, Walmart, and a variety of politicians. Learn how you can find out who is changing Wikipedia and how the fact that anyone can change Wikipedia (and often does) affects the reliaqbility of Wikipedia.
Write a two or more paragraphs about how and when (if ever) Wikipedia can be a trusted source of information.
Read the
NPR blog on Wickipedia.
Also read the
NPR article on Wikipedia.
Then listen to the NPR Podcast on Wikipedia by clicking on the LISTEN button on the NPR article page.
Next read the WIRED story about Virgil Griffith, Wikipedia Scanner, and the changes made to Wikipedia by Diebold, a leading maker of voting machines, the FBI, Walmart, and a variety of politicians. Learn how you can find out who is changing Wikipedia and how the fact that anyone can change Wikipedia (and often does) affects the reliaqbility of Wikipedia.
Write a two or more paragraphs about how and when (if ever) Wikipedia can be a trusted source of information.
Due Dates (By Popular Request)
Thursday 3/ 20 at midnight - Notification (if applicable) that you cannot reach your partner for web critique
First Class in Week 12 (3/24-25)- Data Base (Week 12)
First Class in Week 12 (3/24-25) - Critiques of Web Sites
First Class in Week 13 (4/1-2) - Draft of Trifoid
First Class in Week 14 (4/8-9) - Final Trifold
First Class in Week 14 (4/8-9) - iGoogle Page
Week 15 (4/15-16)- Spreadsheet and or Word Processing Exam
Week 16 (4/22-23)- Spreadsheet and or Word Processing Exam
Final Classes (4/25) - Final Web Site
First Class in Week 12 (3/24-25)- Data Base (Week 12)
First Class in Week 12 (3/24-25) - Critiques of Web Sites
First Class in Week 13 (4/1-2) - Draft of Trifoid
First Class in Week 14 (4/8-9) - Final Trifold
First Class in Week 14 (4/8-9) - iGoogle Page
Week 15 (4/15-16)- Spreadsheet and or Word Processing Exam
Week 16 (4/22-23)- Spreadsheet and or Word Processing Exam
Final Classes (4/25) - Final Web Site
Data Base (Address Book) Due Week 12
Your address book must have at least 25 entries. It must contain the following fields: Greeting, First Name, Last Name, Suffix, Address, City, State, Zip, Area Code, Phone, Full Name (using CONCATENATE Funuction to combine Greeting, First Name, Last Name, Suffix properly punctuated), CSZ (a combination of City, State and Zip properly punctuated using the CONCATENATE function). and AC and Phone ( a combination of the area code, a "-", and the phone number using the CONCATENATE function).
Share this with me as a Viewer (strange.john@gmail.com).
Share this with me as a Viewer (strange.john@gmail.com).
Tuesday, March 18, 2008
Google Web Site Problems
Google has made changes to their Page Creator which are causing problems. Until they get their problems corrected, DO NOT CHANGE YOUR HOME PAGE EVEN IF IT IS INCORRECT. As soon as Google has gotten things straighted out I will advise you that you can make the appropriate changes.
You may also have difficulties returning to Site Manager from Site Settings. THEREFORE DO NOT CLICK ON SITE Settings until I advise you that it is clear. If you do, and get stuck, just go to pages.google,com and you will be back to SiteManager.
There also have been reports that Google has arbitrarily changed your home page. If so, wait it out and we will straighten it out after Google recovers from their errors. For reviewers: If it appears that you are not going to the intended home page of the site you are reviewing, go to the site plan and click on Home Page. You should then be in the correct place.
I also have had one report that a student had all of her links on her site map, then changed the Look and Google threw away all of her links. If this or other wierd things happen to you while using Google Pages, please let me know as soon as possible!
You may also have difficulties returning to Site Manager from Site Settings. THEREFORE DO NOT CLICK ON SITE Settings until I advise you that it is clear. If you do, and get stuck, just go to pages.google,com and you will be back to SiteManager.
There also have been reports that Google has arbitrarily changed your home page. If so, wait it out and we will straighten it out after Google recovers from their errors. For reviewers: If it appears that you are not going to the intended home page of the site you are reviewing, go to the site plan and click on Home Page. You should then be in the correct place.
I also have had one report that a student had all of her links on her site map, then changed the Look and Google threw away all of her links. If this or other wierd things happen to you while using Google Pages, please let me know as soon as possible!
Enter Photography Contest By March 20!
Last day for entries.
Prizes:
1st - $ 25.00
2nd - $10.00
3rd - $ 5.00
Honorable Mention - New Presidential Dollar
Prizes:
1st - $ 25.00
2nd - $10.00
3rd - $ 5.00
Honorable Mention - New Presidential Dollar
Monday, March 17, 2008
Adding Links to your Web Site Instructional Videos
I have just posted two instructional videos about links.
The first covers Creating a Site Map with Links.
The second discusses Adding Links to Your Web Pages.
The first covers Creating a Site Map with Links.
The second discusses Adding Links to Your Web Pages.
Partners For Critiques
Monday Night
Trista Beck/ Michael Bowman
Crystal Clemens/ Cynthia Trainor
Lenore Green-Boyle/ Wade Forbes
Margaret Gunnison/ Deborah Levitt
Karlie Nix/ Laura Robinson
Dorothy Kline/ Jerica Yoas
Tuesday 9:30
Joshua Milne/ Jennifer Becker
Angela Lee/ Patty Bell
Kyndal Coleman/ Timothy Johnson (11 Class)
Amanda Dabney/ Jeffrey Bosarge
Tiffany Crenshaw/ Joe Reddick
Kimberly Segler/ Chasity Wyatt
Brittany Smith/ Shannika Williams
Angela Suter/ Helen Wiles
Stacy Taylor/ Jennifer West
Tuesday 11
Laura Blackman/ Kimberly Wesley
Tiere Bracks/ Virginia Warren
Jennifer Thurgood/ Jeanieve Burroughs
Alesha Campbell/ Jimmie Sunday
Lawrence Campbell/ Christy Smithweck
Rachelle CArlberg/ Brooke Smith
Inky Fagbongbe/ Elizabeth Sharp
Sarah Horsley/ Emmett Proudfoot
Ashley Johnson/ Amy Mosley
Timothy Johnson/ Kendal Coleman (9:30 Class)
Tuesday 2
Erin Bates/ Leslie Newton
Mozhgan Bayatpour/ Jessica White
Maria Beck/ Terri Onderdonk
Shannon Beck/ Angela Petry
Emily Forsyth/ Corey Roberts
Matthew Kemp/ Lawanda Stanton
Alfoncer Watson/ Sara Jones
Alexander White/ Marcia Lyles
You must email your partner and provide them with the address of your blog. AND you must send me a copy of that email (strange.john@gmail.com) ALSO include your Gmail address and ask them for their Gmail address. You will need to use Gmail addresses when making someone a Viewer of your DOC. If they use an address other than a Gmail account, use that address as a Viewer AS WELL AS their Gmail address. To do this:
1. Sign in to Google
2. Go to pages.google.com
3. Copy your web site address (in blue at top of Page Manager)
4. Go to the Class Blog
5. Click on your class.
6. Click on your partner's name to go to their blog.
7. Place your mouse pointer over on their Email-Me link
At the lower left corner you will see their email address. Copy it down and use in your email to them. If this is NOT a gmail address, ask them for their gmail address.
8. Write a note to them and include the address of your web site (in memory)
9. Put strange.john@gmail.com in the CC area
10. Send
If you have not heard from your partner by Thursday night, email ME!
Trista Beck/ Michael Bowman
Crystal Clemens/ Cynthia Trainor
Lenore Green-Boyle/ Wade Forbes
Margaret Gunnison/ Deborah Levitt
Karlie Nix/ Laura Robinson
Dorothy Kline/ Jerica Yoas
Tuesday 9:30
Joshua Milne/ Jennifer Becker
Angela Lee/ Patty Bell
Kyndal Coleman/ Timothy Johnson (11 Class)
Amanda Dabney/ Jeffrey Bosarge
Tiffany Crenshaw/ Joe Reddick
Kimberly Segler/ Chasity Wyatt
Brittany Smith/ Shannika Williams
Angela Suter/ Helen Wiles
Stacy Taylor/ Jennifer West
Tuesday 11
Laura Blackman/ Kimberly Wesley
Tiere Bracks/ Virginia Warren
Jennifer Thurgood/ Jeanieve Burroughs
Alesha Campbell/ Jimmie Sunday
Lawrence Campbell/ Christy Smithweck
Rachelle CArlberg/ Brooke Smith
Inky Fagbongbe/ Elizabeth Sharp
Sarah Horsley/ Emmett Proudfoot
Ashley Johnson/ Amy Mosley
Timothy Johnson/ Kendal Coleman (9:30 Class)
Tuesday 2
Erin Bates/ Leslie Newton
Mozhgan Bayatpour/ Jessica White
Maria Beck/ Terri Onderdonk
Shannon Beck/ Angela Petry
Emily Forsyth/ Corey Roberts
Matthew Kemp/ Lawanda Stanton
Alfoncer Watson/ Sara Jones
Alexander White/ Marcia Lyles
You must email your partner and provide them with the address of your blog. AND you must send me a copy of that email (strange.john@gmail.com) ALSO include your Gmail address and ask them for their Gmail address. You will need to use Gmail addresses when making someone a Viewer of your DOC. If they use an address other than a Gmail account, use that address as a Viewer AS WELL AS their Gmail address. To do this:
1. Sign in to Google
2. Go to pages.google.com
3. Copy your web site address (in blue at top of Page Manager)
4. Go to the Class Blog
5. Click on your class.
6. Click on your partner's name to go to their blog.
7. Place your mouse pointer over on their Email-Me link
At the lower left corner you will see their email address. Copy it down and use in your email to them. If this is NOT a gmail address, ask them for their gmail address.
8. Write a note to them and include the address of your web site (in memory)
9. Put strange.john@gmail.com in the CC area
10. Send
If you have not heard from your partner by Thursday night, email ME!
Additional Changes to Syllabus
1. Google Talk; Google Maps; Google World; Other Google Tools scheduled to be covered in Week 11 have been postponed indefinitely. Watch for future instructions.
2. Web site Critiques are now due Monday March 24 or Tuesday March 25.
3. In Week 11 we will cover more on DOCS and introduce Google Spreadsheets (using them as Databases). The database project will be due in Week 12 (March 24 or 25). This is NOT a change (but it is a clarification) to the syllabus.
4. DRAFT Trifolds will now be due March 31 or April 1. Final Trifolds will be due April 7 or April 8. This is a change to a previously made change to the syllabus.
4. Videos on DOCS and Spreadsheets as Databases will be posted later this week (Week 11).
5. Additional Blog assignments will be posted later this week.
2. Web site Critiques are now due Monday March 24 or Tuesday March 25.
3. In Week 11 we will cover more on DOCS and introduce Google Spreadsheets (using them as Databases). The database project will be due in Week 12 (March 24 or 25). This is NOT a change (but it is a clarification) to the syllabus.
4. DRAFT Trifolds will now be due March 31 or April 1. Final Trifolds will be due April 7 or April 8. This is a change to a previously made change to the syllabus.
4. Videos on DOCS and Spreadsheets as Databases will be posted later this week (Week 11).
5. Additional Blog assignments will be posted later this week.
Critiques of Web Sites
Each class member will be assigned a partner whose site you are to review. It should be a genuine critique, not a "it looks great" statement. You will want to consider all of these questions (and hopefully others that you think of) when you do your critique.
1. Does the web site work?
2. How complete is it?
3. Is there a complete site map that works?
4. Are the links all working?
5. Are the links on every page?
6. Are they the the best links for that page?
7. Do they work?
8. It the text appropriate to the picture displayed?
9. Are the words in the text correctly spelled?
10. Is the grammar correct?
11. Does the Source show when your mouse is over the picture (will last approximately five seconds)?
12. Does the web site look nice?
13. What might the author do in the remaining five weeks to improve the site?
You should write your critique using Google DOCS. Make sure that I am included as a Viewer. Use this email: strange.john@gmail.com for me.
I will post a movie on how to use DOCS later this week.
If you are absent, a list of "partners" will be posted later this week.
1. Does the web site work?
2. How complete is it?
3. Is there a complete site map that works?
4. Are the links all working?
5. Are the links on every page?
6. Are they the the best links for that page?
7. Do they work?
8. It the text appropriate to the picture displayed?
9. Are the words in the text correctly spelled?
10. Is the grammar correct?
11. Does the Source show when your mouse is over the picture (will last approximately five seconds)?
12. Does the web site look nice?
13. What might the author do in the remaining five weeks to improve the site?
You should write your critique using Google DOCS. Make sure that I am included as a Viewer. Use this email: strange.john@gmail.com for me.
I will post a movie on how to use DOCS later this week.
If you are absent, a list of "partners" will be posted later this week.
Thursday, March 6, 2008
Additional iGoogle Instructional Videos
Publish All Pages and Set the Correct Index Page
Two reminders that are important as you near the completion of you draft web site are contained in this video. Click to watch!
Add ALT and TITLE Modifiers to all IMG Tags in Web Site
You must add ALT and TITLE modifiers to all IMG tags in your web site. For a video review of how to do this, CLICK HERE.
Two reminders that are important as you near the completion of you draft web site are contained in this video. Click to watch!
Add ALT and TITLE Modifiers to all IMG Tags in Web Site
You must add ALT and TITLE modifiers to all IMG tags in your web site. For a video review of how to do this, CLICK HERE.
Monday, March 3, 2008
RSS Feeds
Need help in understanding RSS and in thinking about how to use RSS yourself and in your classes? CLICK HERE to watch my instructional video about RSS Feeds.
Be sure to add Google Reader to your iGoogle page and to subscribe to the class blog!
Be sure to add Google Reader to your iGoogle page and to subscribe to the class blog!
iGoogle Instructional Movie
Need help in developing your iGoogle project? CLICK HERE to watch my instructional video about iGoogle.
Subscribe to:
Comments (Atom)
