E N D
Microsoft Map 97 Microsoft Map 97 is a tool that allows the user to analyze data that have a geographic component. Maps allow the user to comprehend the meaning of large amounts of data. Trends and relationships that may not be apparent in purely numeric data can often be seen when the data are placed into a map. Microsoft Map 97 is free with Microsoft Windows/Microsoft Excel. Help for Microsoft Map 97 is available in the help areas on your computer and on the WWW. Help for the newly released (and very powerful) Microsoft MapPoint 2001 (which is sold as a separate software package) is available with the software and on the WWW. Back To Index: http://www.GeoCities.com/rtmorphine/
Microsoft Excel 2000 Menus Bar Geographic Data & Demographic Data From “Mapstats” MS Excel File Microsoft Excel 2000 “Map” Icon Creating A Map With Microsoft Map 97 1. Microsoft Map 97 components are located in the following folder: C:\Program Files\Common Files\Microsoft Shared\Datamap 2. Run the MapInfo Data Installer for the map: DATAINST.EXE. The “Map Manager” dialog box will appear. Select the desired map from “Map Features” or, if you’ve previously created a map, “Map Templates”. 3. Launch Microsoft Excel 97 or Microsoft Excel 2000. 4. Enter the data in columns. One column must contain geographic data (i.e., state names, country names, et cetera). You can enter your own data, import data from external sources, and/or use the geographic and demographic datasets that come with MS Excel 97 and MS Excel 2000. The third source of data is in an MS Excel file named “Mapstats”. The “Mapstats” file is located in a folder named “Data”. The “Data” folder is located in the “Datamap” folder. 5. Select a cell range. One of the selected columns must contain geographic data. 6. Click the “Map” icon on the “Standard” toolbar. (It looks like a globe.) 7. Click and drag an area where you want the map to appear. If more than one map is applicable to your dataset, a “Multiple Maps Available” dialog box will appear and tell you to select the map that you want to use. 8. The applicable map, a “Map” menus bar, a “Map” toolbar, and a “Microsoft Map Control” box will appear. Edit the map with these tools. You can save the map as a template.
Microsoft Map 97 Menus Bar The Format Type(s) Options Will Vary Depending On The Format Type(s) Chosen Possible Column Values Category Shading Current Format Type(s) & Column Value(s) Value Shading Dialog Box For Format Options Dialog Box For Legend Options Graduated Symbol Dot Density Column Chart Pie Chart Double-Clicking In This Area (Which Is Purple In This Example) Initiates The “Format Properties” Dialog Box – The “Format Properties” Dialog Box Also Can Be Initiated By Clicking The Format Type(s) Options In The “Map” Menu The User Can Click-And-Drag The Desired Format Type(s) & Column Value(s) Into The Selection Box
Microsoft Map 97 Toolbar Help Show/Hide Microsoft Map Control Grabber Add Text RedrawMap Zoom Percentage Of Map Select Objects CenterMap Custom Pin Map Map Refresh Map Labels Display Entire
Microsoft Map Control Current Map Template Possible Column Values Category Shading Current Format Type(s) & Column Value(s) Value Shading The User Can Click-And-Drag The Desired Format Type(s) & Column Value(s) Into The Selection Box Dot Density Graduated Symbol Pie Chart Column Chart Double-Clicking In This Area (Which Is Purple In This Example) Initiates The “Format Properties” Dialog Box – The “Format Properties” Dialog Box Also Can Be Initiated By Clicking The Format Type(s) Options In The “Map” Menu – The “Format Properties” Dialog Box Has Two Tabs: A Format Options Tab & A Legend Options Tab – The Format Options Tab’s Name Will Vary Depending On The Format Type(s) Chosen
Microsoft Map 97 Provides 16 Different Colors BLACK SILVER MAROON RED GREEN LIME OLIVE YELLOW NAVY BLUE PURPLE FUCHSIA TEAL AQUA GRAY WHITE
WORLD NORTH AMERICA UNITED STATES w/ AK and HI Inset CANADA MEXICO EUROPE UNITED KINGDOM & IRELAND SOUTHERN AFRICA AUSTRALIA Microsoft Map 97 Has 9 Major Geographic Regions
Single-Series Maps Value Shading (default) Category Shading Dot Density Graduated Symbol Others: Labels (Feature) Highways, Cities, Lakes, Etc. (Feature) Multiple-Series Maps Pie Chart w/ Value Or Category Shading Column Chart w/ Value Or Category Shading Custom Pin Map Others: Zoom Mapstats (Demographic Data Included With Microsoft Map 97) Types Of Maps In Microsoft Map 97
Value Shading Map Format • Single-Series • Uses Different Shades Of A Color • Shows Map Regions As Having Different Numeric Values Based On Their Color Shade
Category Shading Map Format • Single-Series • Uses Different Colors • Shows Map Regions As Belonging To Different Categories Based On Their Color
Dot Density Map Format • Single Series, But Can Be Used To Build Multiple Series • Shows Data As Dots • Each Dot Represents Some Quantity
Graduated Symbols Map Format • Single-Series, But Can Be Used To Build Multiple Series • Shows Data As Symbols Of Various Sizes • Larger Symbols Represent Higher Data Values
Pie Charts Map Format • Multiple-Series • A Pie Chart Is Displayed Over Each Area • Can Be Used With Either Category Or Value Shading • Can Have Either Absolute Or Percentage Values
Column Charts Map Format • Multiple-Series • A Column Chart Is Displayed Over Each Area • Can Be Used With Either Category Or Value Shading • Can Have Absolute, Percentage, Or Time-Series Values
Custom Pin Map Format • User Can Place Symbols & Add Text • Different Symbols Can Be Used To Represent Different Features • Size, Color, Text, And Placement Of Symbols Can Be Altered
Zoom Map Format • User Can Increase Or Decrease The Magnification Of Any Area On The Map • Select A Higher Zoom Percentage To Expanded An Area • Select A Lower Zoom Percentage To Contract An Area
Summary Of Microsoft Map 97 Microsoft Map 97 is a tool that allows the user to analyze data that have a geographic component. Microsoft Map 97 has several major limitations, though. It does not allow more than 16 different colors, although “Value Shading” maps show various shades of a color. It does not have separate maps for Asia or for most of Africa. When a map is revised it sometimes loses data; this can be a major problem and is something the user needs to check during revisions and when copying a map. Microsoft has released Microsoft MapPoint 2001, a truly awesome mapping and geographic information system (GIS) package, as part of their Microsoft Office Suite of productivity software. However, where Microsoft Map 97 is free with Microsoft Windows/Microsoft Excel, Microsoft MapPoint 2001 is sold as a separate software package. A free 60-day trial version of Microsoft MapPoint 2001 is available from Microsoft.
Internet HyperLinks For Maps (In No Particular Order) • Expedia.com: http://www.expedia.com/ • An Atlas Of Cyberspaces: http://www.cybergeography.org/atlas/atlas.html • MS & USGS: MSN: Encarta Learning Zone: TerraServer: http://terraserver.microsoft.com/ • MS & USGS: TerraServer.com: http://www.terraserver.com/ • Microsoft: MS MapPoint 2001: http://www.microsoft.com/office/mappoint/default.htm • MP2K (Magazine For MS MapPoint): http://www.mp2kmag.com/ • Microsoft: MSN: Encarta Learning Zone: Atlas: http://encarta.msn.com/maps/mapview.asp • NationalGeographic.Com MapMachine: www.nationalgeographic.com/resources/ngo/maps/ • U.S. Census Geography Topics: http://www.census.gov/geo/www/index.html • U.S. Census Bureau Gazetteer: http://www.census.gov/cgi-bin/gazetteer • U.S. Census Bureau (TIGER): http://www.census.gov/geo/www/tiger/index.html • USGS Map Browser Information: http://www.nationalatlas.gov/mapit.html • USGS National Mapping Information: http://mapping.usgs.gov/ • WSI Corporation: Intellicast.com: http://intellicast.com/ • The Library Of Congress: Map Collections: http://lcweb2.loc.gov/ammem/gmdhtml/gmdhome.html • About.com: Geography: http://geography.about.com/education/geography/ • CIA WWW Site: http://www.odci.gov/cia/publications/factbook/index.html • IRI/LDEO Climate Data Library: http://ingrid.ldgo.columbia.edu/ • NAVSTAR Global Positioning System Joint Program Office: http://www.laafb.af.mil/SMC/CZ/homepage/ • About.com: Computer-Aided Design: GIS/Mapping: http://cad.about.com/compute/cad/msub_gis.htm • University Of Texas: Map Ref.: http://www.lib.utexas.edu/Libs/PCL/Map_collection/Cartographic_reference.html • Smithsonian Institution: Internet Reference Tools: http://www.sil.si.edu/ProjectAccess/reference.htm • Britannica.com: http://www.britannica.com/ • MountainTop Computing: VRML Maps & Globes: http://www.mtop.com/
Microsoft Map 97 The End Of The Presentation Back To Index: http://www.GeoCities.com/rtmorphine/