(EDU 33692) Students will choose a specific community research project and apply various online research techniques and Microsoft softwares to develop a community wiki. Students will present their results in class and submit them to the class wiki.

Thursday, May 28, 2009

Interlude: Raising Resumes...

I hate writing my resume. I always associate resume writing with the deprivation of doing fun things. Last Monday, Memorial Day, a vacation day, a day I don't have to be responsible for work duties, I have already committed to retuning my resume so I can get a better job. (Sigh)

So how do I write a resume? It's sad that I have to spend my time learning how to do something I really don't want to do, wasting even more of my fun time. So here are a couple of good online tutorials:
There are two categories of resumes, the chronological resume and the functional resume. What are the differences? What are the basic sections of a resume?

Finally, every job sector has its own nuances of the resume form. Here are some examples.
People unfamiliar with word processing software tend to view computers as electronic typewriters. Using word processing software is like entering a new world, with fundamental questions to be answered, like what kind of font, or page margin, or paragraph justification should I use?

Living in America, most of the letters we write are business oriented. Examine the following formats:
For extra credit, answer the questions on this form.

Page Setup

Let's look at a very old resume of mine. I don't even know who this person is any more. Personality aside, let your eye look for various formatting techniques I use to make this resume.Here are some of the basic word processing techniques used to make the resume pop.
  • Portrait/Landscape layout
  • Page Margins
  • Header/Footer
  • Page View
    1. Normal -- text editing
    2. Page Layout -- for visual reference
  • View Paragraphs
  • Tools | Options | View

Headers & Footers

  • Tab Sets
    1. Left
    2. Center
    3. Right
  • Field Codes
    1. Date
    2. FileName
    3. Page
  • Reference Information

Format Selected Text -- Ctrl-d

  • Font
  • Size
  • Format
    1. Bold -- Ctrl-b
    2. Italic -- Ctrl-i
    3. Underline -- Ctrl-u
  • Effects -- super/subscript, small caps, shadow

Format Selected Paragraphs

  • Alignment
  • Indentation
  • Spacing -- Special

Numbered and Bulleted Lists

Tables

  • Select All -- Ctrl-double-click
  • Borders/Shading
    1. Cells -- Affect only selected cells
    2. Paragraph -- Affect only selected text
  • Using the Ruler
  • Cell Height/Width

Tuesday, May 26, 2009

Class #3: PowerPoint slides

Oh great computer golem! Please let >70% of the computers work this time,
let my class see the wonders of the Web and beyond! ;-)


So today we will begin using PowerPoint. Of the softwares that make up the Microsoft Office suite, PowerPoint is the most abused. It is intended to communicate information in a primarily graphic way, with a little bit of text interspersed throughout the slides. We will use it to develop a "community map" that other classes and residents of the Northside Williamsburg Brooklyn neighborhood can use.

Community maps can be very helpful in delivering information in a quick, easy to understand way. As an Internet application, there are many potential startup businesses that could be developed rather quickly. For example, I have a penchant for drinking beer, so I created a map of the neighborhood, showing where all of the bars and pubs are located. Beer Here!

We will develop our own mockup maps that will graphically store the following information:
  • Street names
  • Address numbers
  • Business/Points of interest
  • Trees located on the sidewalk
Today, working in groups of 2-3 (no more) we will access our wikispace to develop 4 city blocks using PowerPoint slides that map out one city block per slide. Each group will:
  1. Choose one of the six locations listed
  2. Use the 'Northside' PowerPoint file to locate the streets and addresses of each lot in the 4 city block area.
  3. Use Google Maps to identify any trees on the sidewalks in the 4 city block area, and
  4. Use search engines to located businesses, churches, etc. that have an associated web page
Each group should organize their tasks so that everyone is helping to produce one final PowerPoint file for the group. For example, one person could be responsible for every aspect of one city block. Or, one person could be responsible for locating every tree in the 4 city block area. However your group wants to organize the work, make sure that whomever is responsible for a particular slide types their name into that particular slide. Everyone needs to have a way to save their work (flash drives, floppy disks, email, etc.) so that everyone's work can be merged.

Tuesday, May 19, 2009

Class #2: Word!

Oh great projector eye! Defy me not this class,
let my class see the wonders of the Web and beyond! ;-)

So I looked over all of your feedback about what you'd like to learn in this class (soon to be only six classes...), and the common threads I pulled out were as follows:
  1. PowerPoint – basic and animation techniques
  2. Excel – mastering spreadsheet skills
  3. Additional Internet skills (virus detection, e-commerce, etc.)
There is typing software available on these computers (see ___). Unfortunately, we will not have time to look at Outlook, Publisher, or Java. I will try to at least show examples of web-based applications, but no full lessons on these subjects. Sorry!

So this week we'll look at Word, next week PowerPoint, and the following Excel. If any of you have specific questions about these softwares, post a comment to this blog, so I can focus the lesson to your needs accordingly.

Let's look at what we've done so far ...

We're well on our way to making a great community wiki! From the Williamsburg Preschool across the street, a pool in the neighborhood and art on the BQE (of course in Queens...), so much to learn about our neighborhood. Sweet memories of Harry Van Arsdale Jr.'s Local 3 beats rusty red paint any day. Let's barc for Our Lady of Mt. Carmel!

I can't wait to learn about Metropolitan Pool, Spoonbill & Sugartown, and Bedford Cheese Shop...

Please make sure to include actual links to specific webpages (google.com isn't very helpful) and also write a one or two paragraph summary about what you learned through your research.

So let's see what's on tap tonite...

Using Word to make nice looking documents:


How to avoid looking like all you're doing is cutting and pasting off the Internet

Let's start by seeing how well you can recreate a page in Word. After I hand out what the page should look like, format the following text and graphic, making the layout look exactly the way it looks on the handout page. "Exactly" means same font formatting, page margins, and paragraph formatting. Copy and paste the following text and graphic into a blank Word document, and see how closely you can make your Word page look like the one I handed out:

This is a Pre-Test! It's only a Pretest...
In the Event of a Real Test, You will be Provided Additional information...

Brooklyn's Northside Williamsburg Community will soon appreciate the efforts we are making to create an online archive of our collective memories of our neighborhood. By working with the Natural Science Lab's walking tours, we will memorialize their experiences online, making a reference for people in the future to look upon and remember how quickly our places are changing, even disappearing.






If all you do is "cut and paste" Internet text into a Word document, it's going to be real obvious what you're doing. At the very least, you should make the text look uniform, that is, have the same font formatting, and use your page margins to make the information look more like an academic research paper. Let's see how we can do that...

If you don't know anything about Word, the odds are you're going to treat it like a typewriter, which is a very bad thing. So let's get right to our first rule:

Rule #1: If you're hitting a key more than once, you're doing it wrong.

Hitting the space bar, the enter key, or any other button on the keyboard repeatedly so that you can get the words on the page where you want them (like horizontal or vertical centering) works on a typewriter, but it's the wrong way to go when using Word. So if you used the space bar or Enter key to try to get the words and graphics to line up like my page, you need to learn a new skill. Let's look at a couple of the basic techniques.
  1. Page Margins. Use a ruler to figure out what your white space measurements are for the top, bottom, left and right sides of the page. Then use the following command, File | Page Setup. The 'Margins' tab will allow you set the white space margins to the fraction of an inch. You can choose 'Portrait' or 'Landscape' layout, depending on how you want the information to fall on the page. The 'Layout' tab is also help in defining page borders and Header and Footer margins.
  2. Header and Footer. Did you notice how the top lines of text and the bottom line of text don't line up with the rest of the text, called the body text? This is because these lines are placed in the Header and Footer sections of the page. To access these parts, use the command, View | Header and Footer. Now you can cut and paste the first lines of information into the Header.
  3. Ruler. If you know how to use a typewriter, you know how to use a ruler. Use the command, View | Ruler to make it appear. You can change the length of the lines in a paragraph by 'clicking and dragging' the margin marks left and right. You never have to hit the space bar again if you know how to use the ruler.
  4. Field Codes. The footer line is made up of text that the Word document, not you, figure out. Use the command, Insert | Field to access the dialog box, and select whichever automated piece of information you what to include in the footer. I always include the FileName, Page Number, and Date and Time at the bottom of every Word page I create. It makes it easier for me to figure out where the document is saved on my computer if this information is printed out in the footer space.
Okay, let's step back from the page structure and figure out how to look at the page.

Rule #2: If you're squinting at the screen, you're doing it wrong.
Viewing a Page can be done in several ways. Clicking on the buttons on the lower left corner of the Word window allow you to jump quickly between the views. The most popular view are
  1. Normal. View the document this is best when you are typing, or working only with the body of the document – no footers, headers or page margin consideration. The text will look biggest in this view.
  2. Page Layout. If you're playing with the margins, headers or footers, this is the view you need to be in. So this view is where you should be if you're trying to make the page "look pretty."
  3. Print Preview. Save trees! Use the command File | Print Preview to get a look at how the page will actually look when it's printed out before you print it out.

Rule #3: The more you click the mouse, the stupider you become.
Using Word means formatting text. To format text, you first need to select text. Most people use the "click and drag" technique to highlight text. But you don't have to, and once you become mouse-free, you'll never go back! So let's see how we can use the keyboard to view and format text.
  1. The arrow keys. Instead of using the mouse to drag the "elevator" on the right side of a window up and down, you can use the arrow keys on the bottom right side of the computer to do exactly the same thing. The 'Page Up' and 'Page Down' buttons, above the arrow keys, do, surprisingly, exactly what they say.
  2. Selecting text. Using the arrow keys, place the cursor to the left of the first character you want to select, then hold down the 'Shift' key, and use the arrow keys to select the text you want to grab.
  3. Accelerator key. Holding the 'Ctrl' button while using the arrow keys allows you to move and select through a document twice as fast. Most important! Ctrl-Home takes you all the way to the beginning of the document, and Ctrl-End takes you all the way to the bottom of the document.
  4. The Hotkeys. You need to memorize these key combinations, so get them into your notebook:
Ctrl-z Ctrl-x Ctrl-c Ctrl-v
Ctrl-a Ctrl-s Ctrl-d Ctrl-f
Ctrl-q Ctrl-w Ctrl-o Ctrl-p
F1 F2 F4 F8 F9


Example of Tree Identification Dichotomous Key

NYC Leaf Key Official Report USDA Forest Service Report


Tuesday, May 12, 2009

Class #1: Web-based Skills

Hola Boricua!

It's 30 minutes before our class, and three men are standing on tables trying to get the projector to work. Welcome to another wonderful Boricua class....

What you're reading now is one of of my class blogs. I write up what I expect to do an hour or two before the class actually starts, as a record of what the objectives for that class are going to be. That way, as students start rolling in, they can start reading about what's going on in the class tonight, and students that miss the class know where to go to pick up missed work.

So since I'm not going to have a working projector, here's what we're going to do tonight: learn about Web search engines. By the end of this class you will know:
  • How to access a variety of different search engines,
  • Write "queries" to help you find the answer to various questions
  • Begin your community research project, saving your work on a wiki page.
So let's get started!

Search engines have existed for fifteen years now, and all of them compare keywords you supply to an existing database of information stored on web pages. Google (or for you energy conservationists, Blackle) is the most popular one, but many others engines exist, and you may find some of them more helpful when "surfing the Web" for educational resources. For example, meta-search engines, like Webcrawler, or Dogpile, search multiple search engines at the same time. Ask.com is running a bunch of commercials to raise its standing. Most search engines have an advanced function that allows you to narrow your search.

A Chronology of Search Engines

Year Released

Search Engine

1993

Aliweb

1994

WebCrawler


Infoseek


(now Go)


Lycos


Metacrawler

1995

AltaVista


Excite

1996

Dogpile


Inktomi


(nowYahoo)


Ask Jeeves


HotBot


Mamma

1997

Northern Light

1998

Google


Ixquick

1999

AlltheWeb

2000

Singingfish


Teoma


Vivisimo


(Now Ask)


Exalead


Gigablast


Turbo10


Picsearch

2001

Grokker


Kartoo

2002

FindSounds

2003

Info.com


Blinkx

2004

Yahoo! Search


Clusty

2005

MSN Search


Answers.com


Myriad Search


Lexxe

2006

Windows LiveSearch


Quintura


AnooX.com

2007

Krozillo


SearchWeaver


Yotophoto



Don't just use Google! Quintura is an example of a graphic based search engine. Click on the link and type 'Boricua College' into the text box. On the right side of the screen you will see the standard list of links of information that pertain to your search terms. On the left, however, is a unique graphical map, which shows similar search terms that are connected in some way to 'Boricua College.' What the connection is to Barnard College, I have not a clue...

Another innovation is "natural language" queries. If I go to Lexxe, and type in 'why do birds fly south in the winter?" into the text box, I will get my standard list of links on the right, but on the left, I will find some possible answers to my question, like "it's too cold," or "they can find more food." Clusty organizes your search results into specific categories to help narrow your search. Answers.com offers similar technologies.

Let's practice using this blog, and using search engines. Look at the following list of questions:
  1. What zoo in England has a white-faced saki?
  2. This person -- the 15th of 17 children born of former slaves -- grew up to become a college president.
  3. Many consider this doctor to be the originator of the Blood Bank concept.
  4. Why did Michael Jordan choose the #23 to wear as his signature number?
  5. What kind of shoes do football players wear?
  6. Who sank the first 3-point goal in the history of college basketball, and in what year did he sink it?
  7. In what city was the game of basketball invented?
  8. Who was the "father of professional baseball?"
  9. What color is a polar bear's skin?
  10. How many times does your heart beat in a day?
  11. Who was the first woman elected to the US Senate?
  12. How many years have people lived in the Artic?
  13. What was the name of the first professional baseball team, where and when was it located?
  14. Which states do not observe Daylight Savings Time?
  15. What kind of trees lose their leaves in the fall?
  16. Mount Everest borders which two countries?
  17. What percent of the Earth is covered by water? By ice?
  18. What male animal hatches his eggs in his mouth?
  19. What is the name for a beetle's hardened forewings?
  20. What country has the most tornadoes?
  21. When was the first world series? How much did a single ticket cost? How much money did each winning team member receive?
  22. What unit of measure is equivalent to 4 miles?
  23. In what year did two teams from Manhattan play in the World Series
  24. What instruments are used to determine the altitude of the North Star?
  25. In what year did two teams from Manhattan play in the World Series?
  26. Which ancient Olympic event included both boxing and wrestling?
  27. During the Chinese New Year, oranges and tangerines are believed to be symbols of?
  28. What three national documents did Benjamin Franklin sign?
  29. The current twelve month calendar we use (January, February, ...) is named after what person?
  30. Who was the last teenager to rule England?
  31. How many World War II soldiers are buried at the Tomb of the Unknowns?
  32. Which state borders the most other states? Name all the states.
  33. What species are the world's largest reptiles?
  34. When was the first United States flag officially approved by Congress?
  35. Who was the first American female millionaire?
  36. What is the last line of the Magna Carta?
  37. What was it that made Nat Turner lead his famous revolt in 1831?
Use search engines of your choice to answer any of the above questions. Once you have found an answer, follow these instructions to post your answer to this blog.
  • Open a new tab (Ctrl-t) and load this page a second time. By clicking back and forth on the tabs, you can read the instructions in one tab, and execute the commands in the other.
  • Scroll to the end of this posting, on the line that starts, "posted by terminus," and click on the 'comments' link.
  • On the right side of the screen, type your name in the text box.
  • Type in the number of the question, and your answer, under your name.
  • Below the text box, click on the 'Anonymous' radio button.
  • Once you're happy with your answers (remember we're all going to read them in a few minutes) click on the orange 'Publish Your Comment' button below the text box.

NOTE: Once someone has correctly answered a question, no one else can answer the question.

Homework

Find a research topic that refers to something, anything that is located within the Northside Williamsburg neighborhood. Its boundaries are the East River, McCarren Park, the BQE, and Metropolitan Avenue. Here are several maps to help orient you:

Each student will save his/her work for this class on their own wiki page. Click on the link, and click on your name. This will take you to your page. To edit your page, click on the 'Edit This Page' button on the upper right side of the page. The Edit Toolbar will appear at the top of the screen. Type or copy/paste in all of your research. And now the most important part: make sure you save your information by clicking on the 'Save' button on the Edit toolbar. The toolbar will disappear, and your page will be updated. So long as you save your work, I will always be able to restore your work.