LUPMIS

Annex 15: IT Training Content

The IT training of TCPD staff by the Project consists of three blocks:

• The first block is an introduction. It is of general nature and has the target audience of rather unexperienced computer users. It can be carried out by general, public or private computer training centres, and does not request high level of trainers’ skill.

• The second block is of specific, advanced nature and will result in specialized computer skills with strong orientation towards GIS, DBMS and land use mapping. Trainees have to have a good general computer background. The training has to be in strong supervision by the Project, but not necessarily been carried out by the Project. It can be done by specific institutes or specially trained trainers, e.g. through trainers training (see also Chapter 8).

• The third block is an adaptation of the training to the methodology and the techniques (see also Chapter 1) developed by the Project. Project-specific methods are taught. Trainers have to be fully aware of the Project approach. The training has to be tailor-made for the specific needs of future work.

There should be tests conducted, for each subject (i.e. lines in the listings below) internally, but well documented, and for each block formal tests to be carried out under external supervision, also well documented.

Block 1: General IT training (introduction)

• Introduction (concept and use of computers, advantages, problems, main components, management)
• Typing (keyboard skills)
• Windows (operating system, layer between hardware and software, Windows explorer, file handling, copy, rename, search, folder structure, different versions of Windows, file extension, backup, safety, user account, administrator; utilities for zip, pdf)
• Word (file handling, copy/paste, select, fonts, paragraph formats, setup, print, find / replace, views, insert tables / graphics, page break, footer, draw / graphics, table, page number, spelling, thesaurus)
• Excel (file handling, copy/paste, structure of rows/columns, calculations, graphs, print, special copy, insert graphics, multiple sheets, formats to save)
• Graphics, e.g. Paint Shop / Visio (file handling, copy/paste, brush, replace, colors, definition of colors, file formats, zoom, fill, layers, vectors, text, layers, palettes, animation; charts, symbols)
• Presentation, e.g. PowerPoint (layout, write, fonts, color, insert graphics, print, animation, templates)
• Internet (concept, technology, connection, browsers, URL, email, netiquette, search engines, references, HTML, PHP, CMS, Web 2.0)
• Hardware (concept, all components, mass storage types, cards, faults, screen, resolution, drivers, installation of software, UPS)
• Network administration (LAN, WLAN, protocols, security, backup, trouble shooting, password, DNS, cabling, resource sharing, Internet access, hardware installation, formatting, backend-frontend, virus protection, firewall)

Block 2: Advanced IT training for LUPMP

• GIS: Software, e.g. Spatial Commander, later Map Maker (start with small scale, zoom, pan, layers, select, query, attribute table, polygon / line / point, edit, vector vs raster, print, coordinates, insert xy coordinates, project conversion, change attribute table / reference to database, import / export to other formats, QC, check of data, GIS utilities for data conversion, georeferencing; design of GIS at TCPD)
• DBMS, e.g. MS Access (concept, theory, tables, data types, design, relations, queries, reports, links, forms, menu development; concept of permit database and link to GIS)
• SQL, e.g. MS SQL Server, PostGreSQL (SQL codes, functions, possibly also VB, compiler, debugging, link to other databases, GIS)
• Cartography (mapping, coordinates, accuracy, topographic vs thematic, scale, projection, datum, map layout, legend, orientation, GPS, purpose of maps)
• Land use assessment and land use mapping (purpose of land use mapping, land use classification, tools, scale, field work)
• GIS for land use planning (modeling, buffer, operations as listed in Annex A5.2, communication with land use planners)
• GPS (technology, coordinates, projection, datum, accuracy, error, tracking, GPS data formats, transfer to PC and GIS)
• GIS on Internet (Maps API, Google Earth, web for dissemination, possibly also PHP; see also Chapter 7.2)
• Data situation in Ghana (acquisition, office networks, public GIS sources, private GIS enterprises, Internet sources, accuracy)
• 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)

Block 3: Adaptation of training for Project approach

• GIS: Land use planning by the Project (land use planning models as defined by land use planners, scales as applied, limitations of modeling)
• Permit and building database (installation, application, development)
• Land use mapping for land use planning by the Project (scale, land use classes applied, generalization levels, carried out by District staff)
• Presentation to District Assemblies and stakeholders
• Participatory GIS approach, as defined by the Project
• GPS handling in the Project
• etc

Copyright @ TCPD / LUPMP - version 2.0