Geography: Computer Techniques

Annotating Photographs and Maps

Run MS Publisher. Click 'Blank Print Publication' in the lower left corner of the screen. The default page size is A4. Choose File/Page Setup and under the Printer and Paper tab choose Portrait or Landscape according to the orientation of your image (probably landscape). To change the printer select the one you require from the list - to print in A3 you must select an A3 printer. Press OK to confirm your settings. To print in A3 choose File/Page Setup again and click on the Full page option under Layout.

Choose Insert/Picture/From File and select your image from its source (e.g. memory stick, though it's probably better to transfer files to your N drive). The image may be bigger than the page so click on it and use Shift/drag to scale it with the corner markers. Leave white space around it for the annotations.

Add lines and text boxes for the annotations. Write on the image if you wish but choose areas of uniform colour and a contrasting colour for the text so it can be easily read. To select lines with arrows find the Autoshapes button in the tool bar, choose Lines and the one with an arrow.

Save your file and print as required.

Large Scale Map or Plan

In Photoshop, create a new file 38cm x 28cm (A3) or 28cm x 19cm (A4). Make sure the background colour is white and resolution is 100 dpi.

Load Getamap. Use the cursor to zoom in on the area of your choice to the scale you want (probably 1:50,000 or 1:25,000). Press Alt/Prt Sc to copy the screen contents. Alternatively, scan in sketch maps or plans from other sources.

Back in Photoshop choose File/New (Ctrl-N) and OK. Press Edit/Paste to place the copy of the screen you just copied. Choose the rectangle selection tool (dotted rectangle) and draw around the map. Choose Image/Crop to leave just the map. With the map still selected (or press Ctrl-A to make sure) press Ctrl-C to copy it.

Switch to the big blank file you created earlier and press Ctrl-V (Edit/Paste) to paste the map section. Notice that this creates a new layer in the layers palette - this is useful for later manipulations.

To add more map squares switch back to Getamap and navigate to an adjacent area. Repeat the Alt-Prt Sc and paste the screen shot to a new file in Phiotoshop. Select and crop the map area and copy and paste it into the big file.

The second paste creates a third layer in the image. Hold down the Ctrl key and use the mouse to drag the new map section so that it lines up with the first map - there will probably be an overlap. Use the zoom tool to magnify the area between the two map sections so that you can join them up exactly. Press Ctrl-0 (zero) to show the whole of the map image.

Repeat these actions as many times as required.

If you need to rotate or scale any map section select the layer with the section you want and place Ctrl-T. This places a box around the map section with handles on the corners and in the middle of the sides. Drag the handles to scale the map. Put the mouse cursor outside the corners and drag to rotate the section.

When you have finished pasting and arranging map sections choose Layer/Flatten

Mark Sites of Interest

E.g. where you have photographs or carried out a survey.

To place text on the image click the text tool, click on the map and select the font and size you want. Type the text and click the tick mark in the top toolbar to confirm. Use the Ctrl key to drag the text to the place you want. To put a circle or box round the text use the rectangular or elliptical selection tool to draw around the text and choose Edit/Stroke. Choose the colour you want for the border by clicking on the swatch and press OK. Press Ctrl-E to merge the text layer into the layer below (Layer/Merge Down).

Charts From Excel

Click here for instructions on creating bar charts, pie charts and line charts in Excel. Click here for instructions on creating X-Y charts and combination charts.

If you have data that you have placed in charts that relates to locations on your map you may want to place the charts on the map.

Create or open the chart in Excel and use copy or Prt Sc to grab the chart and paste it into your map in Photoshop. The chart will probably be too big for your needs so you could reduce it with Ctrl-T. Alternatively, you could make the white areas of the chart transparent so that only the chart, legend and text are visible.

To do this select the Magic Wand tool, click on the white area surrounding the chart and press the Delete key to remove it. This makes the deleted parts completely transparent, which is not the best arrangement. To add a transparent background to the chart proceed as follows: choose Layer/New/Layer. In the layers palette drag this new layer under the chart layer. Working on the new layer drag a rectangular selection the same size as the chart. Fill this area with black (press D to get black as the foreground colour and Alt-Backspace to fill the selection. Drag the Opacity control to a lower setting to make the black fill transparent. This should be a good effect as the chart is now distinct but you see through the least important parts.

Select the Chart layer in the Layers palette and press Ctrl-E to merge it into the background. You can now use Ctrl-T to scale the chart.

Advanced Techniques - Pivot Tables in Excel

For analysing data such as those you might have gathered during fieldwork the pivot table in Excel is a brilliant tool. If you can get your head round the sort of data a pivot table requires then the use of this amazing tool would really benefit your project work.

We know that some data is suitable for plotting as charts and this makes it much easier to see trends and patterns. Data suitable for charts has either one or two axes like those we find on a pie chart (one axis) or a bar, line or X-Y chart (two axes). Examples of data suitable for charts include pebble size at a single location (pie chart or histogram), traffic flow during the day (line chart) and house price against distance from city centre (X-Y chart).

On the other hand, even simple geographical data often has more than two axes or dimensions. Questionnaire data can have many axes depending on what questions are asked. If you do something like a shopping survey by questionnaire then you can process the results in Excel with the database setting or with a pivot table. This page shows how to analyse questionnaire data using database techniques. For really effective analysis and presentation use a pivot table, as in this example, which builds on the database approach.

A pivot table lets you see quickly how one factor relates to another, for example how destination, mode of transport and purpose of journey are related (e.g. for grocery shopping use a car to the local supermarket, for special items take the train to London). If you are collecting data by questionnaire then try to be aware of how the data you collect might be analysed with a pivot table. If you want to see how a data variable is related to two other factors then you will almost certainly find a pivot table useful. If you have many variables that relate to the same two factors then you analyse each variable in turn by dragging them onto the data area of the table.

In studying industrial location, for example, you might design a questionnaire to discover what factors local companies took into account when deciding on their current site. (Factors might include access to raw materials, access to transport, availability of land or buildings, costs, availability of skilled labour, environmental restrictions and level of government grants.) A pivot table is well suited to analysing the results of such a questionnaire as you can plot one variable against two others (you can, in fact, any number of variables if your data requires it).

Climatic data provide another example as they can have multiple axes for time (e.g. year and month, possibly day) and the climatic variables such as rainfall, sunshine hours, wind speed, maximum temperature, minimum temperature - see here for details.

Home