home

Spreadsheets and Databases

home

 

 

     For the spreadsheet and database assignment, I used Optical Character Recognition

(OmniPage Professional OCR) to scan the membership list from the back of the

Global Ratification and Elections Network letterhead. I retained those members of the

World Coordinating Council who were listed as leaders of youth or student organizations.

This was done somewhat arbitrarily, and these persons are not necessarily going to be working

on or with the Graduate School's Student Council. That will be up to them as the council develops.

(The web site will not be registered with the search engines until after the GSWP Board and the

World Coordinating Council Members have had an opportunity to express whether there is both

the qualification and desire to take on such responsibilities.)

 

I also went to the United States Census Bureau for world population figures.

These were in a table which I did not immediately form into neat columns.

At first, I cut and pasted the table into Excel, dragging the 'A' column delimiter

to the right until all figures were enclosed in a single column. Then, I selected all

of column A and went to the Data/Convert-Text-to-Columns menu option.

Upon conversion, all the information was neatly divided into appropriate columns.

Alice Rice showed me that if I save it as html source, then those steps are not necessary

              

Excel Database   The Resultant Catalog     
Excel Spreadsheet 1
showing some
World Population
figures from the
U.S. Census Bureau

Excel Spreadsheet 2

Projected Budgets
will go into the GSWP
Administrative Folder
Global Ratification &
Elections Network figures
 A Graph

 

 

Java applet

 

 

top of page

 

home