A13.3 Training content - LUPMISManual

A13.3 Training Content


A13.3.1 For GIS Staff (GIS Technical Specialists)

A separate report ‘ICT / GIS Training at LUPMP’ is available upon request.

A) Introduction to ICT:

Introduction
- Concept and use of computers
- Hardware vs software
- Advantages
- Main components
- Management
- Constraints

Typing
- Keyboard skills
- Kiran typing tutor

Windows
- Operating system: Layer between hardware and software
- Windows explorer
- File handling
- Copy
- Rename
- Search
- Folder structure
- Different versions: XP and Vista
- File extensions
- Backup
- Safety
- User account
- Administrator
- Utilities for zip, pdf
- Basics of network
- Virus threat

Word
- Different versions: 2003 and 2007
- File handling
- Select
- Copy/paste
- Move
- Select
- Fonts
- Paragraph formats
- Setup
- Print
- Find / replace
- Special characters
- Views
- Insert tables
- Insert graphics
- Page break
- Footer
- Draw in graphics
- Table properties
- Graphic properties
- Page number
- Spelling
- Thesaurus
- Text box
- Paper size and margins
- Formats to save: doc, docx, txt, rtf

Text editor
- WordPad, Editor, Notepad,
- Advantages of txt files

Excel
- Different versions: 2003 and 2007
- File handling
- Copy/paste
- Structure of rows/columns
- Formats
- Calculations / formulas
- Graphs
- Print
- Special copy
- Insert graphics
- Multiple sheets
- Formats to save: xls, xlsx, txt, csv

Graphics: Paint Shop
- File handling
- Copy/paste
- Move
- Brush
- Replace
- Colors
- Selection tools
- Definition of colors
- Graphic formats: jpg, gif, bmp, tif etc
- Zoom
- Fill
- Layers
- Vectors
- Text
- Layers
- Palettes
- Animation
- Charts
- Symbols

Internet
- Browsing, availability of online information
- URL
- Email
- Netiquette
- Search engines: Google etc
- References

Hardware (can be done in separate training)
- Components
- Harddisk
- Screen
- Resolution
- Installation of software
- UPS
- Installation of printer

Introduction to database  (can be done in separate training)
- Basics of MS Access
- Difference to spreadsheets
- File formats: dbf, mdb


Advanced ICT:

Advanced graphics: Visio
- Difference to Paint Shop
- File handling
- Templates
- Diagrams

Presentation: PowerPoint
- Layout
- Add text
- Fonts
- Color
- Insert graphics
- Insert picture
- Insert shape
- Slide show
- Print
- Animation
- Templates
- Formats to save: ppt, pptx

File conversions
o   Graphic file formats

Advanced internet
- Concept
- Technology
- Connection
- Browsers
- URL
- Search engines
- HTML
- PHP
- CMS
- Web 2.0

Hardware
- Concept
- All components
- Mass storage types
- Cards
- Faults
- Screen
- Resolution
- Drivers
- Installation of software
- UPS

Hardware setup
- Setup of all project hardware components
- Cabling, interfacing
- Hardware maintenance
- Printer installation
- Drivers

Introduction to network administration
- LAN
- WLAN
- Protocols
- Security
- Backup
- Trouble shooting
- Password
- DNS
- Cabling
- Resource sharing
- Internet access
- Hardware installation
- Formatting
- Backend-frontend
- Virus protection
- Firewall

Virus treatment
- Virus scanner
- Software
- Quarantine
- Danger due to online exposure

QC / Data accuracy assessment
- QC procedures
- QA, control
- Content of QC
- Reporting
- Intervals,
- Accepted data accuracy
- Data tolerance
- Internal / external control
- Automatic data QC processes


Introduction to GIS / Map Maker:

The best curricula outline of this section is the GIS Manual, produced by the Project.

Theoretical introduction to GIS: Concepts and aspects of:
- Computerized mapping
- Data layers nad overlays
- Raster vs vector data
- Cartography
- Thematic mapping
- Modeling
- Scales

GIS Software: Map Maker
- Installation and configuration of Map Maker
- Start with small scale, existing maps
- Menu system, project manager
- Layers
- Polygon / line / point features
- Load layers
- Zoom
- Pan
- Views
- Grid
- Hide layer
- Measure distances, areas
- Query
- Linked data table (attribute table)
- Display of vectors vs rasters
- Live layer
- Simple print
- Coordinate display
- Insert and import xy coordinates
- Style sets
- GIS file formats: dra, dbf, shp etc, tif, jpg, ecw, world files
- Advantages to (and comparison with) ArcView, ArcGIS

Use of GIS manual
- Hardcopy
- On-line
- Exercise

Vector data handling
- Digitize polygon / line / point
- Vertex points
- Edit polygon / line / point
- Label points: Check, edit
- Treatment of island polygons
- Database: Entry, modification
- Tools: Cutter, join, snap
- Selection manager
- Edit tools

Raster data handling
- Resolution
- Georeferencing

Cartography with GIS (requires earlier introduction to cartography, see below)
- Mapping
- Coordinates
- Accuracy
- Topographic vs thematic maps
- Scale
- Projection
- Datum
- Map layout
- Legend
- Orientation

Print and presentation
- Map furniture
- Layout
- Print templates
- Transfer to graphics programs

GPS
- Technology
- Coordinates
- Projection
- Datum
- Accuracy
- Error
- Tracking
- GPS data formats
- Transfer to PC and GIS

Land use mapping
- Purpose of land use mapping
- Land use classification
- Scale of mapping
- Level of detail
- Concept of minimum mapping unit
- Field work
- Data to be collected in the field

GIS for land use planning: Introduction
- Modeling
- Buffer


Introduction to DBMS

DBMS: MS Access
- Concept
- Theory
- Tables
- Data types
- Design
- Relations
- Queries
- Reports
- Links
- Forms
- Menu development

MS SQL Server: Introduction


Cartography

Basics of cartography
- Presentation of spatial features on map,
- Latitude / longitude on earth
- Existence of difference coordinate systems,
- Need for projection
- Meter vs feet, awareness of units
- Conversion degrees to meter
- Discussion of map and features displayed on maps
- Different scales


GIS for land use planning with LUPMP

This is a preliminary syllabus, which will be adjusted after block 2 training has been completed, experiences collected accordingly, and land use planning models are defined.

The best curricula outline of this section is the GIS Manual, produced by the Project.

Advanced GIS: Map Maker
- Style libraries, with colors for LUPMP land use plan maps
- Projection conversion, including War Office
- Change attribute table / reference to database, with land use data tables
- Import from and export to other formats, including to/from Survey Dept
- Check of data, QC
- GIS utilities for data conversion

Vector data handling
- Vector utilities
- Generate cells (UTM 30 etc)
- Buffer creation with values of LUPMP (distance, function)
- Digitization and reproduction of sector layout maps

Raster data handling
- Import
- Raster utilities
- Georeferencing of acquired satellite images
- Error assessment of ground truthing
- Combination of satellite imagery and aerial photographs
- Raster data index

Data table handling
- Link data tables
- Merge data tables
- Database utilities
- Import census data, compile census distribution maps

Land use planning by the Project
- Concept of GIS at TCPD
- Awareness of difference between GIS for cartography and for modeling
- Concept of decision support tool
- Land use planning models as defined by planners (structure maps, sector maps etc)
- Work with LUPMP scales (2,500, 25,000): Conversion and considerations
- Standards and terminology at LUPMP
- Creation of UPN
- Limitations of modeling and of digital planning tools
- Site analyses

Land use mapping for land use planning by the Project
- Applied scales
- Land use classes applied
- Generalization levels, carried out by District staff

Presentation
- Design of layout of LUPMP maps
- Marginalia
- Incorporation of layout into all maps produced
- Creation of standardized TCPD maps
- Addressing District Assemblies and stakeholders

Participatory GIS approach
- PGIS: Concept
- Data collection and presentation under PGIS

GPS handling in the Project
- Garmin-type handheld GPS
- PDA GPS

Land use planning
- Communication with land use planners
- Coordination by planners

GIS on internet
- Maps API
- Google Earth
- Web for dissemination
- Other means of land use plan dissemination

SQL: MS SQL Server: Introduction
- SQL codes
- Functions, possibly also VB,
- Compiler
- Debugging
- Link to other databases, GIS

Permit database
- Concept of permit database
- Link to GIS
- Installation
- Development
- Application: Entry, processing and retrieval of applications
- Link to LIS
- Link to UPN

GIS data situation in Ghana
- Acquisition
- Office networks
- Public GIS sources
- Private GIS enterprises
- Internet sources
- Accuracy