{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Application","Definitions","PGP","Technologist","Technician"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Application","index":0,"n_rows":105,"n_cols":12,"rows_kept":105,"cut":false,"hidden":false,"merged":[[105,1,105,7],[106,1,106,7],[107,1,107,7],[108,1,108,7],[104,1,104,2],[104,3,104,7],[87,9,101,9],[87,10,101,10],[87,11,101,11],[69,9,74,9],[69,10,74,10],[69,11,74,11],[75,10,80,10],[75,11,80,11],[81,10,86,10],[81,11,86,11],[21,8,26,8],[45,9,50,9],[45,10,50,10],[45,11,50,11],[51,9,56,9],[51,10,56,10],[51,11,56,11],[21,9,26,9],[21,10,26,10],[39,11,44,11],[21,11,26,11],[27,9,32,9],[27,10,32,10],[27,11,32,11],[1,1,2,11],[15,10,20,10],[4,2,4,3],[9,8,14,8],[15,8,20,8],[8,1,8,2],[57,1,62,2],[27,8,32,8],[33,8,38,8],[87,1,101,2],[7,9,7,11],[9,9,14,9],[9,10,14,10],[9,11,14,11],[15,9,20,9],[9,1,14,2],[15,1,20,2],[21,1,26,2],[33,11,38,11],[39,9,44,9],[39,10,44,10],[15,11,20,11],[27,1,32,2],[33,1,38,2],[39,1,44,2],[45,1,50,2],[51,1,56,2],[63,11,68,11],[57,9,62,9],[57,10,62,10],[57,11,62,11],[33,9,38,9],[33,10,38,10],[63,9,68,9],[63,10,68,10],[87,8,101,8],[39,8,44,8],[45,8,50,8],[51,8,56,8],[57,8,62,8],[63,8,68,8],[69,8,74,8],[75,8,80,8],[81,8,86,8],[75,1,80,2],[81,1,86,2],[63,1,68,2],[69,1,74,2],[75,9,80,9],[81,9,86,9]]}
[]
[null,"SUBMISSION TO THE SA COUNCIL FOR PROFESSIONAL AND TECHNICAL SURVEYORS\nIN SUPPORT OF AN APPLICATION FOR ASSESMENT OF QUALIFICATION(S) FOR REGISTRATION"]
[]
[]
[null,"Applicant Name :"]
[null,"Date :"]
[]
[{"$nulls":9},"Categories"]
[null,"Courses",null,"Institution","Subject (Module)","Annexture number","Credits","Lecture Hours/ Classes","Total","PGP","GIS T","GT"]
[1,"Mathematics and Applied Mathematics ",{"$nulls":6},{"$f":"SUM(H10:H15)","v":0},100,75,75]
[2]
[3]
[4]
[5]
[6]
[7,"Physics ",{"$nulls":6},{"$f":"SUM(H16:H21)","v":0},25,20,20]
[8]
[9]
[10]
[11]
[12]
[13,"Information Technology",{"$nulls":6},{"$f":"SUM(H22:H27)","v":0},75,60,60]
[14]
[15]
[16]
[17]
[18]
[19,"Geo-spatial Information Science",{"$nulls":6},{"$f":"SUM(H28:H33)","v":0},175,120,120]
[20]
[21]
[22]
[23]
[24]
[25,"Photogrammetry and Remote Sensing",{"$nulls":6},{"$f":"SUM(H34:H39)","v":0},75,60,60]
[26]
[27]
[28]
[29]
[30]
[31,"Coordinate Systems and Map Projections",{"$nulls":6},{"$f":"SUM(H40:H45)","v":0},50,40,40]
[32]
[33]
[34]
[35]
[36]
[37,"Business and Project Management",{"$nulls":6},{"$f":"SUM(H46:H51)","v":0},25,25,25]
[38]
[39]
[40]
[41]
[42]
[43,"Professional Practice and Ethics",{"$nulls":6},{"$f":"SUM(H52:H57)","v":0},25,25,25]
[44]
[45]
[46]
[47]
[48]
[49,"Category Specific Research Project",{"$nulls":6},{"$f":"SUM(H58:H63)","v":0},75,50,30]
[50]
[51]
[52]
[53]
[54]
[55,"3D Modelling /Cartography/visualisation",{"$nulls":6},{"$f":"SUM(H64:H69)","v":0},75,75,75]
[56]
[57]
[58]
[59]
[60]
[61,"Data Aquisition (From Primary and Secondary Sources inc Surveying, GPS etc.)",{"$nulls":6},{"$f":"SUM(H70:H75)","v":0},65,40,20]
[62]
[63]
[64]
[65]
[66]
[67,"Geographic Science",{"$nulls":6},{"$f":"SUM(H76:H81)","v":0},50,50,50]
[68]
[69]
[70]
[71]
[72]
[73,"Selected Core Themes and electives",{"$nulls":6},{"$f":"SUM(H82:H87)","v":0},210,140,0]
[74]
[75]
[76]
[77]
[78]
[79,"Further time for electives",{"$nulls":6},{"$f":"SUM(H88:H102)","v":0},175,120,0]
[80]
[81]
[82]
[83]
{"$rows_empty":9}
[84]
[{"$nulls":9},{"$f":"SUM(J1:J102)","v":1200},{"$f":"SUM(K1:K102)","v":900},{"$f":"SUM(L1:L102)","v":600}]
[]
[null,"Notes by Assessor:"]

{"sheet":"Definitions","index":1,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,2,4],[3,2,3,4],[3,1,4,1]]}
["GUIDELINES FOR THE MINIMUN CORE THEMES (STUDY AREAS) IN GEOGRAPHICAL INFORMATION SCIENCE (GISc) FOR REGISTRATION IN THE CATEGORY:"]
[]
["COURSE"]
[null,"Common Courses","Categories"]
[null,null,"PGP","GIS T","GT"]
[1,"Mathematics and Applied Mathematics ",100,75,75]
[null,"Differential and integral calculus of functions of one variable, differential euations, partial derivatives, mean value theorem, solving systems of linear and non-linear equations, functions (eg. Trignometric, hyperbolic), cinic sections, complex numbers, matrix algebra, intersection of lines/ planes, distance from points to line/planes, differential geometry. series and polynomials. Statistics: descriptive Statistics - Univariate: Sampling and the collection of data, frequency distributions and graphical representations. Descriptive measures of location and dispersion. Probability and inference: Introductory probability theory and theoretical distributions. Sampling distributions. Estimation theory and hypothesis testing of sampling averages and propotions (one and two sample cases). Identification, use and interpretation of statistical computer packages and statistical techniques. Multivariate statistics, curve fitting (eg. regression and correlation)."]
[2,"Physics ",25,20,20]
[null,"Kinematics, Newton's laws of motion, work, energy, power, rotational dynamics, torque, angular momentum, gravitation, periodic motion, simple harmonic motion, interference, wave motion, diffraction, refraction and reflection of waves, Doppler effect, electric charge and field, electric potential, capacitance, resistance, electric current, electromagnetic induction, magnetic field, electromagnetic spectrum."]
[4,"Information Technology",75,20,60]
[null,"Introduction to computer hardware, operating systems, data communications (local and wide area cover networks), word processing, spreadsheets, internet, software development (science/ engineering) in a current programming language, systems development (including systems analysis and design), databases and database management systems, 2-D and 3-D CAD, security of systems and information, end-user computing, databases and database management systems, data warehouses and data mining."]
[5,"Geo-spatial Information Science",175,60,120]
[null,"Nature of geo-spatial information, geo-spatial information in planning and decision-making, components of a Geographic Information System, data acquisition and manipulation, non-spatial data, feature classification, spatial entities, data structures (vector, raster, hybrid), data modelling, topology, geo-spatial databases and DBMS, spatial analysis, spatial modelling, spatial statistics, design and implementation of GIS, standards for geo-spatial information, metadata and geo-libraries, data quality, data uncertainties, applications (in different fields), 2.5D and 3-D geo-spatial information (including different structures), temporal, and spatial data infrastructure."]
[6,"Photogrammetry and Remote Sensing",75,60,60]
[null,"Acquisition of images, image media and formats incl. Image compression, principles of analogue and digital photography, photogrammetric measurement and data processing including geometry of images, ortho-rectification, mosaicing, georeferencing, digital elevation models. Accuracy and reliability assessment of photogrammetrically derived data, image (photo) interpretation, image processing (including image enhancement, image feature extraction, classification). Applications in resource managemen, topographical mapping, ortho-image maps, applications in land cover and land use studies, interpretation of results, presentation of data/ information (both hardcopy and digital). Fundamentals of remote sensing; digital data and image characteristics; multipspectral, corrections, image enhancement); image classification and anlysis. Earth radiation model and electro-magnetic spectrum, satellite orbits; geometry of sensors and sensor systems (airborne and satellite)."]
[7,"Coordinate Systems and Map Projections",50,120,40]
[null,"Two-dimensional coordinate systems, three-dimensional coordinate systems, grid reference systems, shape of the Earth, mathematical representations of the Earth (including reference ellipsoids), geographical coordinates, different types of map projection transformations, reference datums and ellipsoids, SA Survey co-ordinate system and UTM system."]
[10,"Business and Project Management",25,40,25]
[null,"Management functions (planning, controlling, organising, decision-making), human resource management, financial management and management accounting, marketing and client relations, labour legislation, taxation, project planning, costing, resource allocation, project control and reporting, business communication, report writing, contract law."]
[11,"Professional Practiceand Ethics",25,50,25]
[null,"Professionalism, professional ethics, different types of professional practices, partnerships and partnership law, structuring a practice, client relationships, SA Council for Professional and Technical Surveyors (including legislation and rules), and social responsibility. (A minimum of 30% of the time must be spent on professionalism)."]
[12,"Category Specific Research Project",75,25,30]
[null,"The reserch project must have a system design and or spatial analysis component and include reporting and presentation of final results. The time spend on research topic selection, research proposal, analysis and interpretation, progress reporting, and liaison with research supervisor must be a minimal of 300 hours."]
[null,"Category specific themes (study areas)"]
[17,"3D Modelling /Cartography/visualisation",75,25,75]
[null,"Visual perception, graphicacy, cartographic communication (including information sense-making, information use and information-knowledge trasformation), graphic space, semiotics, symbolization, map representation, colour, cartographic design, typonomy, generalization, map use, multimedia mapping, 2-D and 3-D visualization, interactive mapping), image maps, intellectual property and copyright, privacy rights, information economics, computer-assisted cartography systems, and map printing."]
[22,"Data Aquisition (From Primary and Secondary Sources inc Surveying, GPS etc.)",65,50,20]
[null,"Primary data acquisition methods, including surveying techniques, photogrammetry, remote sensing and GPS observations. The nature of observations and data acquisition, types of errors, accuracy, precision, law of error propagation. Data capture from secondary data sources, including digitizing, scanning and manual input. Principles and methods of managing the quality of collected data. The relationship between data quality and their fitness for use in GIS applications. Data needs, data capture techniques, data integration, data standards. Error modelling and data uncertainity: presentation of spatial data. Data cleaning, migration and manipulation. Metadata collection and capture (sources, national and international standards, use of metadata). Spatial and attribute data transfer formats. Social surveys questionair."]
[23,"Geographic Science",50,75,50]
[null,"Geography its Nature and Prospectives (eg. Location. Space, place., scale., pattern, regionization, globalization), Population (eg. Distribution, change), Cultural Pattern and Process (eg. Cultural landscapes), Political Organization of space (eg. territorial of politics) Agricultural and rural Land Use, Industrialization, Cities and Urban Land Use (eg. models of urban stems, internal city structures), physical geography (eg. earth systems, resources, earth science concepts - atmosphere, hydrosphere, pedisphere, biosphere)."]
[24,"Selected Core Themes and electives",210,180,0]
[null,"University to add lectures/ contact hours to any three (3) or more core study areas other than the research project"]
[null,"Further time for electives",175,100,0]
[null,"Grand Total",{"$f":"SUM(C6:C33)","v":1200},{"$f":"SUM(D6:D33)","v":900},{"$f":"SUM(E6:E33)","v":600}]

{"sheet":"PGP","index":2,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,0,3,3],[1,0,1,6],[0,0,0,6],[19,5,20,7],[2,0,2,7]]}
["SA COUNCIL FOR PROFESSIONAL AND TECHNICAL SURVEYORS, RESULTS OF ASSESSMENT  FOR MINIMUM QUALIFICATION REQUIREMENTS FOR GISc PROFESSIONAL REGISTRATION"]
["To be used in conjuction with subject area content specifications\nOne lecture is considered to be 45 – 60 minutes in length\nSubject area teaching may be included in more than one course"]
[{"$f":"Application!C5","v":0}]
["Professional GISc Practitioner",null,null,null,"Self Assesment","Result","Additional Credits Requirement","Additional Lecture Hours Requirement"]
[]
[null,"Common Subject Areas","PGP","%"]
[1,"Mathematics and Applied Mathematics ",100,{"$f":"SUM(C7/$C$36)","v":8.3333333333333329E-2},{"$f":"SUM(Application!H10:H15)","v":0},{"$f":"IF(E7<C7,\"Inadequate Hours\",\"Adequate Hours\")","v":"Inadequate Hours"},{"$f":"IF(E7<C7,SUM((C7-E7)*4)/10,0)","v":40},{"$f":"IF(E7<C7,SUM(C7-E7),\" \")","v":100}]
[2,"Physics ",25,{"$f":"SUM(C8/$C$36)","v":2.0833333333333332E-2},{"$f":"SUM(Application!H16:H21)","v":0},{"$f":"IF(E8<C8,\"Inadequate Hours\",\"Adequate Hours\")","v":"Inadequate Hours"},{"$f":"IF(E8<C8,SUM((C8-E8)*4)/10,0)","v":10},{"$f":"IF(E8<C8,SUM(C8-E8),\" \")","v":25}]
[3,"Basic Surveying and Engineering Surveying",{"$nulls":4},0," "]
[4,"Information Technology",75,{"$f":"SUM(C10/$C$36)","v":6.25E-2},{"$f":"SUM(Application!H22:H27)","v":0},"Inadequate Hours",30,75]
[5,"Geo-spatial Information Science",175,{"$f":"SUM(C11/$C$36)","v":0.14583333333333334},{"$f":"SUM(Application!H28:H33)","v":0},"Inadequate Hours",70,175]
[6,"Photogrammetry and Remote Sensing",75,{"$f":"SUM(C12/$C$36)","v":6.25E-2},{"$f":"SUM(Application!H34:H39)","v":0},"Inadequate Hours",30,75]
[7,"Coordinate Systems and Map Projections",50,{"$f":"SUM(C13/$C$36)","v":4.1666666666666664E-2},{"$f":"SUM(Application!H40:H45)","v":0},"Inadequate Hours",20,50]
[8,"Adjustments, Error Theory and Statistics",{"$nulls":4},0," "]
[9,"Earth and Environmental Science",{"$nulls":4},0," "]
[10,"Business and Project Management",25,{"$f":"SUM(C16/$C$36)","v":2.0833333333333332E-2},{"$f":"SUM(Application!H46:H51)","v":0},"Inadequate Hours",10,25]
[11,"Professional Practice and Ethics",25,{"$f":"SUM(C17/$C$36)","v":2.0833333333333332E-2},{"$f":"SUM(Application!H52:H57)","v":0},"Inadequate Hours",10,25]
[12,"Category Specific Research Project",75,{"$f":"SUM(C18/$C$36)","v":6.25E-2},{"$f":"SUM(Application!H58:H63)","v":0},"Inadequate Hours",30,75]
[null,"Subtotal Common Subject Areas",{"$f":"SUM(C7:C18)","v":625},{"$f":"SUM(D7:D18)","v":0.52083333333333326},{"$f":"SUM(E7:E18)","v":0},"Inadequate Hours",{"$f":"SUM(G7:G18)","v":250},{"$f":"SUM(H7:H18)","v":625}]
[]
[null,"Category specific Subject Areas","PGP","%"]
[13,"Cadastral Studies and Land Tenure",{"$nulls":4},{"$f":"IF(E22<C22,SUM((C22-E22)*4)/10,0)","v":0},{"$f":"IF(E22<C22,SUM(C22-E22),\" \")","v":" "}]
[14,"Geodesy and Satellite Surveying",{"$nulls":4},0," "]
[15,"Land Management and Planning",{"$nulls":4},0," "]
[16,"Precise Engineering Surveying",{"$nulls":4},0," "]
[17,"3D Modelling /Cartography/visualisation",75,{"$f":"SUM(C26/$C$36)","v":6.25E-2},{"$f":"SUM(Application!H64:H69)","v":0},"Inadequate Hours",30,75]
[18,"Mineral Management",{"$nulls":4},0," "]
[19,"Mineral Valuation/evaluation/statistics",{"$nulls":4},0," "]
[20,"Mining Geology",{"$nulls":4},0," "]
[21,"Rock Mechanics",{"$nulls":4},0," "]
[22,"Data Aquisition (From Primary and Secondary Sources inc Surveying, GPS etc.)",65,{"$f":"SUM(C31/$C$36)","v":5.4166666666666669E-2},{"$f":"SUM(Application!H70:H75)","v":0},"Inadequate Hours",26,65]
[23,"Geographic Science",50,{"$f":"SUM(C32/$C$36)","v":4.1666666666666664E-2},{"$f":"SUM(Application!H76:H81)","v":0},"Inadequate Hours",20,50]
[24,"Selected Core Themes and electives",210,{"$f":"SUM(C33/$C$36)","v":0.17499999999999999},{"$f":"SUM(Application!H82:H87)","v":0},"Inadequate Hours",84,210]
[null,"Subtotal Common Subject Areas",{"$f":"SUM(C22:C33)","v":400},{"$f":"SUM(D22:D33)","v":0.33333333333333331},{"$f":"SUM(E22:E33)","v":0},"Inadequate Hours",160,400]
[null,"Further time for electives",175,{"$f":"SUM(C35/$C$36)","v":0.14583333333333334},{"$f":"SUM(Application!H88:H102)","v":0},"Inadequate Hours",70,175]
[null,"Total",{"$f":"SUM(C22:C33)+SUM(C7:C18)+C35","v":1200},{"$f":"SUM(D19+D34+D35)","v":0.99999999999999989},{"$f":"SUM(E35+E34+E19)","v":0},"Inadequate Hours",{"$f":"SUM(G7:G33)-G19+G35","v":480},{"$f":"SUM(H7:H33)-H19+H35","v":1200}]

{"sheet":"Technologist","index":3,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[20,4,20,6],[3,0,3,3],[0,0,0,5],[1,0,1,5],[19,1,19,6],[2,0,2,7]]}
["SA COUNCIL FOR PROFESSIONAL AND TECHNICAL SURVEYORS, RESULTS OF ASSESSMENT FOR MINIMUM QUALIFICATION REQUIREMENTS FOR GISc TECHNOLOGIST REGISTRATION "]
["To be used in conjuction with subject area content specifications\nOne lecture is considered to be 45 – 60 minutes in length\nSubject area teaching may be included in more than one course"]
[{"$f":"Application!C5","v":0}]
["GISc Technologist",null,null,null,"Self Assesment","Result","Additional Credits Requirement","Additional Lecture Hours Requirement"]
[]
[null,"Common Subject Areas","GIS T","%"]
[1,"Mathematics and Applied Mathematics ",75,{"$f":"SUM(C7/$C$36)","v":8.3333333333333329E-2},{"$f":"SUM(Application!H10:H15)","v":0},{"$f":"IF(E7<C7,\"Inadequate Hours\",\"Adequate Hours\")","v":"Inadequate Hours"},{"$f":"IF(E7<C7,SUM((C7-E7)*4)/10,0)","v":30},{"$f":"IF(E7<C7,SUM(C7-E7),\" \")","v":75}]
[2,"Physics ",20,{"$f":"SUM(C8/$C$36)","v":2.2222222222222223E-2},{"$f":"SUM(Application!H16:H21)","v":0},{"$f":"IF(E8<C8,\"Inadequate Hours\",\"Adequate Hours\")","v":"Inadequate Hours"},{"$f":"IF(E8<C8,SUM((C8-E8)*4)/10,0)","v":8},{"$f":"IF(E8<C8,SUM(C8-E8),\" \")","v":20}]
[3,"Basic Surveying and Engineering Surveying",{"$nulls":4},0," "]
[4,"Information Technology",20,{"$f":"SUM(C10/$C$36)","v":2.2222222222222223E-2},{"$f":"SUM(Application!H22:H27)","v":0},"Inadequate Hours",8,20]
[5,"Geo-spatial Information Science",60,{"$f":"SUM(C11/$C$36)","v":6.6666666666666666E-2},{"$f":"SUM(Application!H28:H33)","v":0},"Inadequate Hours",24,60]
[6,"Photogrammetry and Remote Sensing",60,{"$f":"SUM(C12/$C$36)","v":6.6666666666666666E-2},{"$f":"SUM(Application!H34:H39)","v":0},"Inadequate Hours",24,60]
[7,"Coordinate Systems and Map Projections",120,{"$f":"SUM(C13/$C$36)","v":0.13333333333333333},{"$f":"SUM(Application!H40:H45)","v":0},"Inadequate Hours",48,120]
[8,"Adjustments, Error Theory and Statistics",{"$nulls":4},0," "]
[9,"Earth and Environmental Science",{"$nulls":4},0," "]
[10,"Business and Project Management",40,{"$f":"SUM(C16/$C$36)","v":4.4444444444444446E-2},{"$f":"SUM(Application!H46:H51)","v":0},"Inadequate Hours",16,40]
[11,"Professional Practice and Ethics",50,{"$f":"SUM(C17/$C$36)","v":5.5555555555555552E-2},{"$f":"SUM(Application!H52:H57)","v":0},"Inadequate Hours",20,50]
[12,"Category Specific Research Project",25,{"$f":"SUM(C18/$C$36)","v":2.7777777777777776E-2},{"$f":"SUM(Application!H58:H63)","v":0},"Inadequate Hours",10,25]
[null,"Subtotal Common Subject Areas",{"$f":"SUM(C7:C18)","v":470},{"$f":"SUM(D7:D18)","v":0.52222222222222214},{"$f":"SUM(E7:E18)","v":0},"Inadequate Hours",{"$f":"SUM(G7:G18)","v":188},{"$f":"SUM(H7:H18)","v":470}]
[]
[null,"Category specific Subject Areas","GIS T","%"]
[13,"Cadastral Studies and Land Tenure",{"$nulls":4},{"$f":"IF(E22<C22,SUM((C22-E22)*4)/10,0)","v":0},{"$f":"IF(E22<C22,SUM(C22-E22),\" \")","v":" "}]
[14,"Geodesy and Satellite Surveying",{"$nulls":4},0," "]
[15,"Land Management and Planning",{"$nulls":4},0," "]
[16,"Precise Engineering Surveying",{"$nulls":4},0," "]
[17,"3D Modelling /Cartography/visualisation",25,{"$f":"SUM(C26/$C$36)","v":2.7777777777777776E-2},{"$f":"SUM(Application!H64:H69)","v":0},"Inadequate Hours",10,25]
[18,"Mineral Management",{"$nulls":4},0," "]
[19,"Mineral Valuation/evaluation/statistics",{"$nulls":4},0," "]
[20,"Mining Geology",{"$nulls":4},0," "]
[21,"Rock Mechanics",{"$nulls":4},0," "]
[22,"Data Aquisition (From Primary and Secondary Sources inc Surveying, GPS etc.)",50,{"$f":"SUM(C31/$C$36)","v":5.5555555555555552E-2},{"$f":"SUM(Application!H70:H75)","v":0},"Inadequate Hours",20,50]
[23,"Geographic Science",75,{"$f":"SUM(C32/$C$36)","v":8.3333333333333329E-2},{"$f":"SUM(Application!H76:H81)","v":0},"Inadequate Hours",30,75]
[24,"Selected Core Themes and electives",180,{"$f":"SUM(C33/$C$36)","v":0.2},{"$f":"SUM(Application!H82:H87)","v":0},"Inadequate Hours",72,180]
[null,"Subtotal Common Subject Areas",{"$f":"SUM(C22:C33)","v":330},{"$f":"SUM(D22:D33)","v":0.3666666666666667},{"$f":"SUM(E22:E33)","v":0},"Inadequate Hours",132,330]
[null,"Further time for electives",100,{"$f":"SUM(C35/$C$36)","v":0.1111111111111111},{"$f":"SUM(Application!H88:H102)","v":0},"Inadequate Hours",40,100]
[null,"Total",{"$f":"SUM(C22:C33)+SUM(C7:C18)+C35","v":900},{"$f":"SUM(D19+D34+D35)","v":1},{"$f":"SUM(E35+E34+E19)","v":0},"Inadequate Hours",{"$f":"SUM(G7:G33)-G19+G35","v":360},{"$f":"SUM(H7:H33)-H19+H35","v":900}]

{"sheet":"Technician","index":4,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[36,1,36,7],[3,0,3,3],[0,0,0,5],[1,0,1,5],[2,0,2,7],[19,0,19,5]]}
["SA COUNCIL FOR PROFESSIONAL AND TECHNICAL SURVEYORS, RESULTS OF ASSESSMENT FOR MINIMUM QUALIFICATION REQUIREMENTS FOR GISc TECHNICIAN REGISTRATION "]
["To be used in conjunction with subject area content specifications\nOne lecture is considered to be 45 – 60 minutes in length\nSubject area teaching may be included in more than one course"]
[{"$f":"Application!C5","v":0}]
["GISc Technician",null,null,null,"Self Assessment","Result","Additional Credits Requirement","Additional Lecture Hours Requirement"]
[]
[null,"Common Subject Areas","GT","%"]
[1,"Mathematics and Applied Mathematics ",75,{"$f":"SUM(C7/$C$36)","v":0.125},{"$f":"SUM(Application!H10:H15)","v":0},{"$f":"IF(E7<C7,\"Inadequate Hours\",\"Adequate Hours\")","v":"Inadequate Hours"},{"$f":"IF(E7<C7,SUM((C7-E7)*4)/10,0)","v":30},{"$f":"IF(E7<C7,SUM(C7-E7),\" \")","v":75}]
[2,"Physics ",20,{"$f":"SUM(C8/$C$36)","v":3.3333333333333333E-2},{"$f":"SUM(Application!H16:H21)","v":0},{"$f":"IF(E8<C8,\"Inadequate Hours\",\"Adequate Hours\")","v":"Inadequate Hours"},{"$f":"IF(E8<C8,SUM((C8-E8)*4)/10,0)","v":8},{"$f":"IF(E8<C8,SUM(C8-E8),\" \")","v":20}]
[3,"Basic Surveying and Engineering Surveying",{"$nulls":4},0," "]
[4,"Information Technology",60,{"$f":"SUM(C10/$C$36)","v":0.1},{"$f":"SUM(Application!H22:H27)","v":0},"Inadequate Hours",24,60]
[5,"Geo-spatial Information Science",120,{"$f":"SUM(C11/$C$36)","v":0.2},{"$f":"SUM(Application!H28:H33)","v":0},"Inadequate Hours",48,120]
[6,"Photogrammetry and Remote Sensing",60,{"$f":"SUM(C12/$C$36)","v":0.1},{"$f":"SUM(Application!H34:H39)","v":0},"Inadequate Hours",24,60]
[7,"Coordinate Systems and Map Projections",40,{"$f":"SUM(C13/$C$36)","v":6.6666666666666666E-2},{"$f":"SUM(Application!H40:H45)","v":0},"Inadequate Hours",16,40]
[8,"Adjustments, Error Theory and Statistics",{"$nulls":4},0," "]
[9,"Earth and Environmental Science",{"$nulls":4},0," "]
[10,"Business and Project Management",25,{"$f":"SUM(C16/$C$36)","v":4.1666666666666664E-2},{"$f":"SUM(Application!H46:H51)","v":0},"Inadequate Hours",10,25]
[11,"Professional Practice and Ethics",25,{"$f":"SUM(C17/$C$36)","v":4.1666666666666664E-2},{"$f":"SUM(Application!H52:H57)","v":0},"Inadequate Hours",10,25]
[12,"Category Specific Research Project",30,{"$f":"SUM(C18/$C$36)","v":0.05},{"$f":"SUM(Application!H58:H63)","v":0},"Inadequate Hours",12,30]
[null,"Subtotal Common Subject Areas",{"$f":"SUM(C7:C18)","v":455},{"$f":"SUM(D7:D18)","v":0.7583333333333333},{"$f":"SUM(E7:E18)","v":0},"Inadequate Hours",{"$f":"SUM(G7:G18)","v":182},{"$f":"SUM(H7:H18)","v":455}]
[]
[null,"Category specific Subject Areas","GT","%"]
[13,"Cadastral Studies and Land Tenure",{"$nulls":4},{"$f":"IF(E22<C22,SUM((C22-E22)*4)/10,0)","v":0},{"$f":"IF(E22<C22,SUM(C22-E22),\" \")","v":" "}]
[14,"Geodesy and Satellite Surveying",{"$nulls":4},0," "]
[15,"Land Management and Planning",{"$nulls":4},0," "]
[16,"Precise Engineering Surveying",{"$nulls":4},0," "]
[17,"3D Modelling /Cartography/visualisation",75,{"$f":"SUM(C26/$C$36)","v":0.125},{"$f":"SUM(Application!H64:H69)","v":0},"Inadequate Hours",30,75]
[18,"Mineral Management",{"$nulls":4},0," "]
[19,"Mineral Valuation/evaluation/statistics",{"$nulls":4},0," "]
[20,"Mining Geology",{"$nulls":4},0," "]
[21,"Rock Mechanics",{"$nulls":4},0," "]
[22,"Data Acquisition (From Primary and Secondary Sources inc Surveying, GPS etc.)",20,{"$f":"SUM(C31/$C$36)","v":3.3333333333333333E-2},{"$f":"SUM(Application!H70:H75)","v":0},"Inadequate Hours",8,20]
[23,"Geographic Science",50,{"$f":"SUM(C32/$C$36)","v":8.3333333333333329E-2},{"$f":"SUM(Application!H76:H81)","v":0},"Inadequate Hours",20,50]
[24,"Selected Core Themes and electives",null,null,null,"Adequate Hours",0," "]
[null,"Subtotal Common Subject Areas",{"$f":"SUM(C22:C33)","v":145},{"$f":"SUM(D22:D33)","v":0.24166666666666664},{"$f":"SUM(E22:E33)","v":0},"Inadequate Hours",58,145]
[null,"Further time for electives",null,{"$f":"SUM(C35/$C$36)","v":0},null,null,0," "]
[null,"Total",600,{"$f":"SUM(D19+D34+D35)","v":1},{"$f":"SUM(E35+E34+E19)","v":0},"Inadequate Hours",{"$f":"SUM(G7:G33)-G19","v":240},{"$f":"SUM(H7:H33)-H19","v":600}]