March 12, 2022

Uncategorized

HSD 2206: EDUCATION AND DEVELOPMENT3 Past Paper

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY UNIVERSITY EXAMINATIONS 2014/2015 YEAR 2 SEMESTER II EXAMINATION FOR THE DEGREE OF BACHELOR OF COMMUNITY DEVELOPMENT HSD 2206: EDUCATION AND DEVELOPMENT DATE: APRIL 2015 TIME: 2 HOURS INSTRUCTIONS: Answer Question One (Compulsory) and Any Other Two Questions QUESTION ONE (30marks) a) Explain the following terms using relevant examples i) Educational policies (2marks) ii) Development (1mark) iii) Education development (2marks) b) Discuss five problems facing education in developing countries (10marks) c) Explain five solutions to the problems facing developing countries in education development (10marks) d) Describe gender issues facing education in Kenya (5marks) QUESTION TWO (20marks) Explain the role played by UNESCO in education development process in developing countries QUESTION THREE (20marks) Discuss challenges facing quality assurance and standards in developing countries QUESTION FOUR (20marks) Discuss the influence of globalization in education in developing countries QUESTION FIVE (20marks) “To what extent has education contributed towards socio-economic development in Kenya”?

HSD 2206: EDUCATION AND DEVELOPMENT3 Past Paper Read Post »

Uncategorized

HSD 2206: EDUCATION AND DEVELOPMENT2 Past Paper

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY UNIVERSITY EXAMINATIONS 2014/2015 YEAR II SEMESTER I EXAMINATION FOR THE DEGREE OF BACHELOR OF DEVELOPMENT STUDIES HSD 2206: EDUCATION AND DEVELOPMENT DATE:DECEMBER 2014 TIME: 2 HOURS INSTRUCTIONS: Answer question one and any other two questions. QUESTION ONE The Kenyan 8-4-4 was developed to achieve certain objectives. i. Explain any three objectives of the 8-4-4 system of education. (6 marks) ii. Explain any five challenges that the system has encountered during implementation. (15 marks) iii. What are the likely effects of the challenges on the economic development. (9 marks) QUESTION TWO i. The Kenyan Government intends to stop universities from offering certificates and Diplomas to concentrate on degrees only. Explain any five likely effects in the education sector. (10 marks) ii. Explain any five dilemmas facing education in Kenya. (10 marks) QUESTION THREE The recent growing interest in Agribusiness may require a change in education policy in agricultural education in Kenya. Discuss. (20 marks) QUESTION FOUR i. Discus five advantages of an educated population. (10 marks) ii. State five factors that can improve quality of education in Kenya. (10 marks)

HSD 2206: EDUCATION AND DEVELOPMENT2 Past Paper Read Post »

Uncategorized

HSD 2206: EDUCATION AND DEVELOPMENT Past Paper

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY UNIVERSITY EXAMINATIONS 2015/2016 YEAR II SEMESTER I EXAMINATION FOR THE DEGREE OF BACHELOR OF DEVELOPMENT STUDIES HSD 2206: EDUCATION AND DEVELOPMENT DATE:DECEMBER 2015 TIME: 2 HOURS INSRUCTIONS: Answer question one and any other two questions CASE STUDY The social function of education has also been analysed with reference to its possible contribution to economic development. Considerable research has been carried out in this field but the relationship between education and economy is still to be precisely defined. In the popular mind education and affluence are usually associated. Rich countries boast of advanced educational systems while poor countries are educationally backward. The argument that education leads to economic development rests on two assumptions i. Education changes behavour ii. Such changes results in the production of more goods and services. Reference has already been made that a greater amount of education leads to higher incomes but there is no form evidence that those with higher educational attachments are better and because of their higher productions. It could be that education is being used there to merely convene a criterion for selecting persons with aptitudes such as greater flexibility motivating imitative and problem motivation initiative and problem adaptive. These attributes are certainly a help to productivity but the is no proof that they are generated by education. Finally education has to compete in growth terms with other areas of investments. It is arguable for instance that the building of roads and power stations may contribute more to economic growth compared to educational investment but general education should be distinguished from specialized expertise for doing specific jobs certain technical training is necessary. The requisite training is said to contribute towards economic development. QUESTION ONE a. Define the following terms as they are used in education. i. Investment (2 marks) ii. Investment spending. (2 marks) iii. Consumer spending (2 marks) b. State and explain ten direct benefits of education. (10 marks) c. Elaboratively discuss six roles of education in development. (6 marks) d. Education is viewed as a prime mover to development. Basing on the above statement. Justify the ?? of education in developing counties. (6 marks) QUESTION TWO Discuss vividly the problems that hinder the development of education in developing countries in Africa. (20 marks) QUESTION THREE Explain how education can help in conflict situation. (20 marks) QUESTION FOUR Discuss four modes of funding of education in developing countries. (20 marks) QUESTON FIVE Loans as a method of financing education has been so adaptive by many scholars in developing countries. Discuss the merits of this statement basing on Higher Education Loans Board (HELB) in Kenya. (20 marks)  

HSD 2206: EDUCATION AND DEVELOPMENT Past Paper Read Post »

Uncategorized

HDS 2103: EDUCATION AND DEVELOPMENT Past Paper

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY UNIVERSITY EXAMINATIONS 2018/2019 YEAR I SEMESTER I EXAMINATION FOR THE DEGREE OF BACHELOR OF DEVELOPMENT STUDIES HDS 2103: EDUCATION AND DEVELOPMENT DATE: DECEMBER 2018 TIME: 2 HOURS Answer all questions in this section. SECTION ONE QUESTION ONE a. Detail the history of education from ancient to modern times. (10 marks) b. Explain the various aims of education and comment on their relevance to development. (10 marks) c. To what extent is education a public good? (10 marks) SECTION TWO Answer any two questions in this section QUESTION TWO With the use of relevant examples, compare and contrast teacher centered and student centered philosophies of education. (20 marks) QUESTION THREE Assess the importance of education in achievement of Kenya’s development plan (Vision 2030) and the big 4 agenda. (20 marks) QUESTION FOUR Using relevant examples contrast the various ways through which education can be financed. (20 marks) QUESTION FIVE Discus the role of education in achievement of sustainable development goals. (20 marks)

HDS 2103: EDUCATION AND DEVELOPMENT Past Paper Read Post »

Uncategorized

HBT 2105: DATA COMMUNICATION AND COMPUTER NETWORK Past Paper

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLO7GY University Examinations 2018/2019 SECOND YEAR FIRST SEMESTER EXAMINATION FOR THE DEGREE OF BACHELOR OF BUSINESS INFORMATION TECHNOLOGY HBT 2105: DATA COMMUNICATION AND COMPUTER NETWORK DATE: APRIL 2019 TIME: 2 HOURS INSTRUCTIONS: ANSWER QUESTION ONE AND ANY OTHER TWO QUESTIONS Question One (30 Marks) a) With the aid of a diagram, describe the elements of a data communication system. (6 Marks) b) Explain five (5) factors to be considered when selecting cabling media. (5 Marks) c) Explain two (2) limitations of microwave transmission media. (4 Marks) d) Explain the difference between the following with reference to networking: (i) Physical topology and logical topology (4 Marks) (ii) LAN and WAN (4 Marks) (iii) Intranet and Extranet (4 Marks) e) Explain the role of a gateway and state where it resides in the OSI model. (3 Marks) Question Two (20 Marks) a) Explain the difference between the following: (i) Guided and unguided transmission media (2 Marks) (ii) Half duplex and full duplex transmission mode (2 Marks) (iii) Synchronous and asynchronous transmission (2 Marks) (iv) Serial and parallel transmission (2 Marks) b) With the aid of a diagram, describe the operation of the FDDI topology access method. (4 Marks) c) Explain four (4) advantages of fibre optic transmission system. (8 Marks) Question Three (20 Marks) a) Explain the difference between the following: (i) Circuit switching and packet switching (4 Marks) (ii) Peer to peer and server based networks (4 Marks) (iii) Coaxial thinnet and coaxial thick net (4 Marks) b) Explain the following modulation schemes: (i) Time division multiplexing (3 Marks) (ii) Frequency division multiplexing (3 Marks) c) Explain the term CRC (2 Marks) Question Four (20 Marks) a) Explain the difference between: (i) Multiplex and demultiplexer (4 Marks) (ii) Dial up connection and leased connection (4 Marks) b) Explain four (4) situations where communication via radio signals for LAN may be preferable over cable communication. (4 Marks) c) Explain the need for standard in data communications. (2 Marks) d) Explain three (3) standards for data communication. (3 Marks) e) Explain the differences between connection oriented and connection less data transmission. (3 Marks) Question Five (20 Marks) a) With the aid of a diagram, describe the TCP/IP model, illustrating how it maps to the OSI model. (10 Marks) b) Explain the operation of CSMA/CD. (10 Marks)

HBT 2105: DATA COMMUNICATION AND COMPUTER NETWORK Past Paper Read Post »

Uncategorized

HSD 3107 : AGRICULTURE AND NATIONAL RESOURCE MANAGEMENT Past Paper

W1-2-6-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY UNIVERSITY EXAMINATIONS 2012/2013 EXAMINATION FOR THE DEGREE OF MASTER OF …………………………………….. HSD 3107 : AGRICULTURE AND NATIONAL RESOURCE MANAGEMENT DATE: DECEMBER 2012 TIME: 1.30 HOURS INSTRUCTIONS : ANSWER ANY THREE QUESTIONS QUESTION ONE Using the concept of the ‘Three World’s of Agriculture’ explain the characteristics of sub-saharan agriculture and its implication for food security and poverty reduction . [20 marks] QUESTION TWO “Africa needs more trade NOT AID” Explain this statement in the context of the agricultural sector. [20 marks] QUESTION THREE Using any TWO examples, Explain the role of technology in promoting agricultural productivity in developing countries. QUESTION FOUR Agriculture has the potential to both degrade and restore the environment. Explain . QUESTION FIVE One of the hindrances to the growth and productivity of African Agriculture is the policy environment under which it operates. Explain this statement and suggest ways in which the policy environment in African countries could be improved. [20 marks]

HSD 3107 : AGRICULTURE AND NATIONAL RESOURCE MANAGEMENT Past Paper Read Post »

Uncategorized

EGS 2309: GIS DATABASE SYSTEMS Past Paper

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY University Examinations 2016/2017 YEAR III SEMESTER II EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN GIS EGS 2309: GIS DATABASE SYSTEMS DATE: DECEMBER, 2016 TIME: 2 HOURS INSTRUCTIONS: Answer Question ONE and Any Other TWO Questions. Question One – 30 Marks a) Define the following terminologies as used in GIS database. [3 marks] i. Relation ii. Attribute iii. Domain iv. Tuple v. Degree vi. Cardinality b) Explain how database is said to be shared, description of data and logically related. [6 marks] c) Describe the following acronyms. [6 marks] d) Highlight, with example, GIS data. [6 marks] e) Assuming you are mandated to set up a database for a private enterprise briefly highlight the levels which should Question Two – 20 Marks a) Define normalization . [2 marks] b) Describe the process of normalization. [3 marks] c) Highlight main normalization forms. [15 marks] Question Three – 20 Marks a) What is a model? [2 marks] b) Briefly discuss principal types of data models. [18 marks] Question Four – 20 Marks a) Difference between relationship type and relationship. [2 marks] b) What do you understand by the term constraint as used in RDBMS? [2 marks] c) Briefly highlight two main types of constraints. [6 marks] d) Describe main GIS data formats, giving examples where necessary. [10 marks] Question Five – 20 Marks a) What do you understand by DBMS? [2 marks] b) Highlight functionalities, merits and demerits of DBMS. [18 marks]

EGS 2309: GIS DATABASE SYSTEMS Past Paper Read Post »

Uncategorized

EGS 2308: DIGITAL MAPPING Past Paper

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY University Examinations 2016/2017 YEAR III SEMESTER II EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN GIS EGS 2308: DIGITAL MAPPING DATE: DECEMBER, 2016 TIME: 2 HOURS INSTRUCTIONS: Answer Question ONE and Any Other TWO Questions. Question One – 30 Marks a) Differentiate between systematic and adhoc data collectors. [4 marks] b) Explain five advantages of conducting field survey as opposed to aerial chorography as a method of data collection in digital mapping. [6 marks] c) What steps should be taken to minimize errors while scanning and digitizing? [5 marks] d) Explain the five purposes of digital mapping. [5 marks] e) Explain any five sources of discrepancies or errors in spatial data. [5 marks] f) List and explain the common forms of reliefs depiction. [5 marks] Question Two – 20 Marks a) List five sets of data you would use in a mapping exercise for land use planning. Explain the role that each data set will play. [10 marks] b) You have given several data sets for digital mapping exercise. Explain how you will select suitable data set for your exercise. [10 marks] Question Three – 20 Marks a) Discuss the cross slide digitizer. [5 marks] b) Explain the criteria used in selection of characteristic points in an image. [10 marks] c) Discuss the errors associated with digitizing maps. [5 marks] Question Four – 20 Marks a) Explain the concept of Geo referencing highlighting the three main processes involved. [8 marks] b) Explain the method via which raster to vectors conversion can be implemented. [6 marks] c) Give three advantages and disadvantages of raster data models. [6 marks] Question Five – 20 Marks a) Explain the aspects that would enable you extract information from an image. [10 marks] b) Discuss the use of DTMS in a crop suitability and industrial site selection. [5 marks] c) What is the relevance of meta data? And what does it encompass? [3 marks] d) Outline two advantages of a TIN as compared to a grid DTM. [2 marks]  

EGS 2308: DIGITAL MAPPING Past Paper Read Post »

Uncategorized

EGS 2307: TRANSPORTATION PLANNING Past Paper

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY University Examinations 2016/2017 YEAR III SEMESTER II EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN GIS EGS 2307: TRANSPORTATION PLANNING DATE: DECEMBER, 2016 TIME: 2 HOURS INSTRUCTIONS: Answer Question ONE and Any Other TWO Questions. Question One – 30 Marks a) Define transportation planning. [2 marks] b) County government of Trans Nzoia wants to prepare a transportation plan. Highlight cardinal steps which need to be adhered to. [6 marks] c) Briefly discuss two main categories of transport systems. [6 marks] d) Describe the relationship between land use and transportations. [6 marks] e) Highlight major causes of road accidents in Kenya. [9 marks] Question Two – 20 Marks a) Define environment eternity. [2 marks] b) Highlight social and environmental impacts caused by transportation systems. [18 marks] Question Three – 20 Marks a) Define traffic analysis zone. [2 marks] b) How does zoning interrelate with transport modeling. [8 marks] c) Describe the most significant component of urban dynamics. [10 marks] Question Four – 20 Marks a) Highlight the differences between public transport and private transport systems. [10 marks] b) Briefly discuss transportation planning period. [10 marks] Question Five – 20 Marks Highlight major policy and transportation planning issues. [20 marks]

EGS 2307: TRANSPORTATION PLANNING Past Paper Read Post »

Uncategorized

DIT 0103: SPREADSHEETS3 Past Papers

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY UNIVERSITY EXAMINATIONS 2012/2013 EXAMINATION FOR THE CERTIFICATE IN INFORMATION TECHNOLOGY DIT 0103: SPREADSHEETS DATE: AUGUST 2012 TIME: 1 ½ HOURS INSTRUCTIONS: ANSWER QUESTION ONE AND ANY OTHER TWO QUESTIONS QUESTION ONE a. Explain the term spreadsheet. [2 marks] b. Outline at least four (4) uses of Ms-Excel as a spreadsheet program. [4 marks] c. With examples, distinguish between i. Absolute referencing and ii. Cell referencing [4 marks] d. Briefly explain the difference between worksheet and workbook. [3 marks] e. Write down the procedure followed to insert columns between columns. [2marks] f. Name four types of electronic spreadsheet in use in the market. [5 marks] g. Explain the meaning of freezing panes. [2marks] h. Write down the steps for applying freezing panes. [4 marks] i. Explain the following term as used in Ms Excel; i. Home ii. Cell-pointer iii. Function iv. Formula [4 marks] QUESTION TWO a. What is Microsoft Excel. [2 marks] b. State four areas where spreadsheets are applicable. [4 marks] c. Write down the procedure of copying and pasting data in Ms Excel. [4 marks] d. Define chart graphs in Ms Excel and list down six types of charts used in Ms Excel. [5 marks] e. What do you understand by data sort? Then write down the procedures to follow when data sorting. [5 marks] QUESTION THREE (20 MARKS) a. State three (3) major toolbars that are commonly used in excel. [3 marks] b. Outline the steps followed to insert a new sheet tab and colour code it. [6 marks] c. How can one get help about a feature in excel in case of need? [1 mark] d. Distinguish between the term cut and copy. [4 marks] e. State and explain six basic features found in Microsoft Excel. [6 marks] QUESTION FOUR a. Write down the steps followed when adjusting column width. [3 marks] b. What is the difference between relative referencing and Absolute referencing. [6 marks] c. In Ms Excel spreadsheets, how do we use Auto-correct operation, highlight the steps followed when auto-correcting. [4 marks] d. Differentiate between save and save as used in Ms Excel. [2 marks] e. Write down the procedure for editing data in a worksheet. [3 marks] f. Write down the procedure followed when deleting a cell. [2 marks]  

DIT 0103: SPREADSHEETS3 Past Papers Read Post »

Uncategorized

DIT 0103: SPREADSHEETS2 Past Paper

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY UNIVERSITY EXAMINATIONS 2012/2013 EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 0103: SPREADSHEETS DATE: AUGUST 2012 TIME: 1.5 HOURS INSTRUCTIONS: ANSWER QUESTION ONE AND ANY OTHER TWO QUESTIONS QUESTION ONE What is Microsoft excel. [2 marks] Write down the procedure of moving data is Ms Excel. [2 marks] Explain the meaning of freezing panes. [2 marks] Write down the steps for applying freezing panes. [2 marks] Explain the following terms as used in Ms Excel i)Home ii)Cell-pointer iii.Function 6. Formula                                                                                                                              [4 marks] 7. Explain briefly any four general features of Electronic spreadsheets. [4 marks] 8. State any four chart types used in Ms Excel to represent data. [4 marks] 9. Explain any four advantages of using electronic spreadsheets over m annual spreadsheets. [8 marks] QUESTION TWO Write down the steps followed when adjusting column width. [3 marks] What is the difference between relative referencing and absolute referencing? [6 marks] In Ms Excel spreadsheet, how do we use Auto-correct operation, highlight the steps followed when Auto-correcting.                                                                                                                          [4 marks] Differentiate between Save and Save As in Ms Excel. [2 marks] Write down the procedure for editing data in a worksheet. [3 marks] Write down the procedure followed when deleting a cell. [2 marks] QUESTION THREE – 20 MARKS What do you understand by data sort? Then write down the procedure to follow when data sorting.                                                                                                                                                 [6 marks] Write down the procedure of copying and pasting data in Ms Excel. [4 marks] How would you perform the following? Insert a worksheet Rename a worksheet iii.            Delete a worksheet ii) Insert a row iii)Insert a column        [5 marks] iv) Autofilll command is widely used in Ms Excel, briefly explain its purpose. [2 marks] v) Write down the steps followed when using Autofill command. [3 marks] QUESTION FOUR-20 MARKS Explain any four advantages of using a spreadsheet program. [8 marks] Mr. Gilbert is a leader at Jomo Kenyatta University and wishes to use Microsoft excel to process the marks of students during their end of semester exam. The table below shows the details                entered in the program. A B C D E F G I J 1 NAME QS EXCEL WORD TOTAL AVERAGE MAX MIN RANK 2 MARY 56 23 57 3 BENTA 89 45 78 4 SALOME 52 66 78 5 JANE 23 45 47 6 AMIN 46 38 56 7 KIRWA 44 39 22     3Give the formula for calculating; 4The total score for Mary 5The average score for Salome i.  The maximum score for Kirwa ii)The minimum score for Jane iii)The rank for Amin                                                                                                           [10 marks] iv) Outline at least 4 applications of a spreadsheet program. [2 marks] QUESTION FIVE Explain the following terms as used in Microsoft Excel Cell-pointer Workbook i. Cell address                                                                                                                      [6 marks] Use the students results as shown below to answer the questions that follow   A B C D E F G H I J K 1 2 NO ADMISSION NO NAME MATH GRADE PROG GRADE ELEC GRADE SUM AVG 3 1 2012/0151 JOHN SAMBU 50 60 90 4 2 2012/0142 PETER RUTO 80 35 83 5 3 2012/0193 JAMES ANDREW 30 70 94 6 4 2012/0204 PAUL JOHN 60 35 81 7 TOTAL 8 MEAN 9 STANDARD DEV   Write the formula that find the sum of all subject marks for the student whose admission no. is 2012/0151 [2 marks] Write a formula that finds the mean of MATH marks to 1 decimal place for all students. [2 marks] i.   Write a formula to grade the MATH mark in (b) using the range 0-40 and grade = 4, 41-50,             grade 3 51-60, grade 2 61-100, grade 1.                                                                                       [3 marks] i)Write a formula for calculating the standard deviation. [3 marks] ii)Using the table in (b), suggest the errors that may occur in b(i) for the following conditions; iiCursor pointer is placed in cell H3, when writing the formula When the value of cell j3, is larger than can fit in cell. iii.            The value of cell H3 is changed to “X”                                                                     [4 marks]

DIT 0103: SPREADSHEETS2 Past Paper Read Post »

Uncategorized

DIT 0103: SPREADSHEETS Past Paper

W1-2-60-1-6 JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY University Examinations 2012/2013 STAGE I EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY DIT 0103: SPREADSHEETS DATE: AUGUST, 2012 TIME: 2 HOURS   INSTRUCTIONS:     Answer Question ONE and Any Other TWO Questions. Question One – 40 marks a) Define the following terms: i) Legend                                                                                                            [2 marks] ii) Template                                                                                             [2 marks] iii) Function                                                                                              [2 marks]   b) Different between the two referencing styles used in spreadsheets by using examples. [6 marks] c) State the steps of creating a named range. [3 marks] d) State five application areas of spreadsheets. [5 marks] e) Describe the three components of a spreadsheet. [6 marks] f) State any five advantages of using electronic spreadsheets. [5 marks] g) Differentiate between copying and moving data in a worksheet. [4 marks] h) State aid explain briefly the four datatypes used in spreadsheets. [5 marks] Question Two – 20 marks a) A worksheet contains the data shown below:   Cell A1 A2 A3 C1 C2 C3 G1 G2 Entry 5 7 10 10 15 15 =sum if(A1:C3”<=10”)     i) State the value displayed in G1.                                                         [3 marks] ii) Write the formular or function that can be used to display the highest vlue/entry from the range in cell G2. iii.Using the nested if control structure award a grade to the sum at cell G1 whereby: 70 – 100 – A 50 – 70 – B <49 – C                                                                                               [5 marks] b)   A B C D E 1 Name Score Award     2 James 50       3 Mary 33       4 Ann 62       5           6 Rate 30       7           8             c) Differentiate between absolute referencing and relatives referencing style. [4 marks] Question Three a) A worksheet contains the data as shown below:   A B C D E F G   1 8   20           2 11   45           3 14   52           4                 5                   i) The formula = COUNTIF (C1: C3, “20”) was entered at G1. Write down the value that was displayed.                                                                    [2 marks] i) Write down the formula that would be entered at cell B7 to sum the values in column A whose values are greater or equal to 5. [3 marks] iii.        The formula = $C2 + C$3 is entered in cell C5 and then copied to D10.  Write down the formula as it appears in the destination cell.               [2 marks] b) Use the following information to answer the questions below: Total                            Remark 350 – 500                    Distinction 300 – 349                    Credit 200 – 299                    Pass 0 – 199                        Fail Assuming the total mark is in cell D4.  Write a nested if statement that will allocate the remarks above.                                                                                                [5 marks] i) Differentiate between copying and moving data in a worksheet. [4 marks] ii) State the four datatypes accepted to spreadsheets and briefly explain each. [4 marks]

DIT 0103: SPREADSHEETS Past Paper Read Post »

Scroll to Top