ATIKA SCHOOL
  • Start
    • SITEMAP
    • KNEC Portal
    • ZERAKI HELP AND SUPPORT
    • Academic Environment
    • KNEC KCSE PROJECT INSTRUCTIONS
  • BLOGS
    • About Us? >
      • Learn more about us
    • CUSTOMER CARE >
      • PRICING
      • Help & Support
    • News and Opinions
    • JOBS IN KENYA AND ABROAD FOR KENYANS AND BEYOND
    • How its Done
  • OUR PRODUCTS
    • All Categories >
      • MORE PRODUCTS >
        • SECONDARY CRE NOTES
        • COURSE BOOKS
        • KCSE KISWAHILI SETBOOKS
        • Backed Up Files and Archives
        • FREE DOCUMENTS
        • PRIMARY 8-4-4 BASED RESOURCES
        • STANDARD 8 RESOURCES
        • HIGH SCHOOL RESOURCES >
          • Biology Paper 3 Exams
          • Secondary Examinations
        • PRIMARY CBC BASED RESOURCES
        • COLLEGE & VARSITY RESOURCES
      • PRIMARY RESOURCES CBC
      • PRIMARY RESOURCES 8-4-4
      • SECONDARY RESOURCES
      • NOTES & TUTORIALS
      • COLLEGE RESOURCES
      • NOVELS and OTHER BOOKS
    • EXAMINATIONS >
      • MOCKS AND JOINT EXAMS >
        • FORM 1 QUESTION PAPERS, ANSWERS AND MARKING SCHEMES COLLECTIONS
        • FORM 2 QUESTION PAPERS, ANSWERS AND MARKING SCHEMES COLLECTIONS
        • FORM 3 EXAMINATIONS, QUESTION PAPERS AND ANSWERS
        • FORM 4 MOCKS PAST EXAMS BY REGION
        • TOP SECONDARY EXAMS ALL SUBJECTS
      • KPSEA NATIONAL EXAMS
      • KCPE >
        • KCPE PAST PAPERS AND ANSWERS >
          • KCPE 2020 RESULTS, REPORTS, QUESTIONS AND ANSWERS
          • KCPE PAST PAPERS 2019 REPORTS, RESULTS, QUESTIONS AND ANSWERS
        • KCPE PAST PAPERS PER SUBJECT
      • KCSE >
        • KCSE PAST PAPERS BY SUBJECT
        • KNEC KCSE PAST PAPERS, MARKING SCHEMES, QUESTIONS & ANSWERS
        • Free KCSE Past Papers Mathematics
        • Free KCSE Biology Questions and Answers
      • QUESTIONS & ANSWERS >
        • SECONDARY >
          • LANGUAGES >
            • Secondary English Questions and Answers
          • TECHNICALS >
            • COMPUTER STUDIES >
              • COMPUTER STUDIES Q & A
              • kcse computer studies paper 2 AND 3 Questions & Answers
            • BUSINESS STUDIES QUESTIONS & ANSWERS
            • KCSE AGRICULTURE TOPICAL QUESTIONS AND ANSWERS
            • KCSE HOME SCIENCE DIRECT QUESTIONS AND ANSWERS
          • SCIENCES >
            • KCSE Mathematics Topical Questions
            • KCSE Biology Topical Questions and Answers
            • CHEMISTRY TOPICAL QUESTIONS AND ANSWERS
            • KCSE Physics Topical Questions
            • KCSE physics Practical Sample Quiz
          • HUMANITIES >
            • C.R.E (CRE) QUESTION AND ANSWERS
            • ISLAMIC RELIGIOUS EDUCATION (IRE) QUESTIONS AND ANSWERS
            • KCSE History Topical Questions and Answers
            • GEOGRAPHY TOPICAL QUESTIONS AND ANSWERS
        • PRIMARY >
          • Standard 4-8 Mathematics Topical Questions from Mocks and KCPE
          • Std 6 Mathematics Notes
    • TUTORIALS >
      • SECONDARY >
        • SCIENCES >
          • FOCUS MATHEMATICS TUTORIALS AND EXAMS FREE
          • KCSE BIOLOGY NOTES
          • FREE KCSE CHEMISTRY NOTES
          • KCSE PHYSICS NOTES, AUDIOVISUALS AND MORE
        • LANGUAGES >
          • ENGLISH >
            • A GUIDE TO SILENT SONG AND OTHER STORIES
            • English KCSE Set Books
            • ENGLISH POETRY QUESTIONS WITH ANSWERS FOR K.C.S.E CANDIDATES
            • ENGLISH GRAMMAR #KCSE
          • KISWAHILI >
            • Bembea ya Maisha
            • CHOZI LA HERI - MWONGOZO
            • KIGOGO - MWONGOZO
            • MASWALI NA MAJIBU YA TUMBO LISILOSHIBA
            • USHAIRI MASWALI NA MAJIBU
            • KCSE Kiswahili Fasihi
        • TECHNICALS >
          • HOME SCIENCE NOTES
          • KCSE BUSINESS STUDIES NOTES
          • COMPUTER STUDIES NOTES LATEST
          • kcse Computer Studies Notes
          • KCSE AGRICULTURE NOTES, SYLLABUS, QUESTIONS, ANSWERS, SCHEMES OF WORK AND OTHERS
        • HUMANITIES >
          • KCSE History Notes Form 1 to 4
          • FREE KCSE CRE NOTES
          • KCSE GEOGRAPHY NOTES
          • IRE NOTES, AUDIOVISUAL, QUESTIONS AND ANSWERS
      • PRIMARY >
        • STANDARD 4: SOCIAL STUDIES
        • NOTES >
          • KISWAHILI
          • SOCIAL STUDIES
        • EXAMINATIONS
        • DecaTurbo Online Series Examinations
        • KCPE Mathematics Notes
        • KCPE and Primary Level Compositions
      • Other Supportive Documents >
        • SYLLABUS >
          • Primary 8-4-4 based Syllabus, Objectives and Lessons
          • Primary Mathematics Syllabus
        • MASOMO VIDEOS
    • CURRICULUM >
      • NEW CURRICULUM DESIGNS >
        • PRIMARY >
          • PRE PRIMARY ONE CURRICULUM WITH SYLLABUS
          • PRE PRIMARY TWO CURRICULUM WITH SYLLABUS
        • SECONDARY >
          • KNEC KCSE SYLLABUS AND COURSE OUTLINES
        • COLLEGE >
          • Regulations for the TIVET Craft and Diploma Business Examinations
    • HIGH INSTITUTIONS >
      • EXAMINATIONS >
        • College and Varsity Past Papers online
      • TUTORIALS >
        • COLLEGE AND UNIVERSITY NOTES AND TUTORIALS
  • MEMBERS RESOURCES
    • Primary >
      • CBC AND 8-4-4 LATEST EXAMS
      • CBC PROFFESSIONAL TOOLS
      • CBC NOTES PRIMARY
      • CBC KPSEA EXAMS
      • Standard 8 (std) English Topical Questions
      • KCPE MATHEMATICS TOPICAL QUESTIONS FROM 1989 TO LAST YEAR
      • STANDARD 8 PAST PAPERS 8-4-4 BASED
    • Secondary >
      • FORM 1 EXAMS WITH ANSWERS
      • FORM 2 EXAMS WITH ANSWERS
      • FORM 3 EXAMS WITH ANSWERS
      • FORM 4 EXAMS WITH ANSWERS
      • KCSE 2020 QUESTIONS AND ANSWERS
      • NOTES SECONDARY
      • MOCKS SECONDARY >
        • kcse form 2 mathematics questions
    • Free Schemes of Work
    • FOCUS A365 SERIES K.C.P.E EXAMINATIONS FOR PRIMARY
    • ALL GROUPS PRODUCTS
    • PREMIUM PRODUCTS 2

Using relevant examples distinguish between a formula and function.

30/4/2022

0 Comments

 

​Using relevant examples distinguish between a formula and function.

  • Formula is a mathematical expression that creates a relationship between cells to return a new value like = B1+b2+c3
  • Functions are inbuilt formula that the user can quickly use instead of having to create a new each time a calculation has to be carried out like =sum(c2:c7)  

Read More
0 Comments

​The information below is maintained by the sales lady at the school canteen. Study it and answer the questions that follow.

17/11/2021

0 Comments

 

​The information below is maintained by the sales lady at the school canteen. Study it and answer the questions that follow.

Picture

​(a) Describe the basic data types used in this spreadsheet (4mks)

  1. Labels
    describing items names
  2. ​Values
    describing units on column B and C

​(b) Provide a single formula that would be used to
(i) Count the number of items whose units are equal; to 15             (2mks)

=COUNTIF(B2:B5,15)   or ​=COUNTIF(B2:B5,=15)

​(ii) Sum the values of items whole units are equal to 12             (2mks)

=SUMIF(B2:B5,"=12") or =SUMIF(B2:B5,"12")

(c) (i) List and describe four areas of application of spreadsheets  (4mks)

  1. Accounting
  2. What IF analysis (forecasting)
  3. Budgeting
  4. Calendars
  5. Expense reports
  6. Forms
  7. Time sheets
  8. Invoices
  9. Purchase Orders
  10. Receipts
  11. Schedules

(ii) Explain data range legend and axis as used in spreadsheet charts          (3mks)

Axis 
  • A reference line from \which distances or angles are measured in a coordinate system, such as the X-axis and y-axis in the Cartesian coordinate system
Legend
  • Brief description accompanying an illustration (chart) also known as a caption 



Read More
0 Comments

State the spreadsheet function that can be used to obtain each of the following values in a worksheet:

15/1/2021

0 Comments

 


State the spreadsheet function that can be used to obtain each of the following values in a worksheet:

(a) Number of cells with values in a column. 
(b) Mean of values in a range of cells. 

  • a) =Count ()
  • b) =Average ()
State the spreadsheet function that can be used to obtain each of the following values in a worksheet:

Read More
0 Comments

Distinguish between a formula and a function as used in spreadsheets.

12/1/2021

0 Comments

 


Distinguish between a formula and a function as used in spreadsheets.

  • A formula is a mathematical expression that creates a relationship between cells to return a new value while a function is an inbuilt predefined formula that the user can quickly use instead of having to create a new one every time they want to do a calculation
Distinguish between a formula and a function as used in spreadsheets.

Read More
0 Comments

Explain two ways in which the use of internet could make reporting of corruption easier

10/1/2021

0 Comments

 


Explain two ways in which the use of internet could make reporting of corruption easier

(b) Explain two circumstances under which the use of wireless communication would be preferred in data communication. 
(c) Figure 2 is an extract of a spreadsheet showing what the students had targeted to score and the actual score in a computer remedial class.
(b) Explain two circumstances under which the use of wireless communication would be preferred in data communication. (c) Figure 2 is an extract of a spreadsheet showing what the students had targeted to score and the actual score in a computer remedial class.
A performance factor is obtained by subtracting the target score from the actual score and dividing the difference by the target score.
Write a formula that uses cell references only that would be entered in cell:
(i) D2 to compute the performance factor. 
(ii) E2 to display the statement ‘more remedials’ if the performance factor is less than zero, ‘exempted’ if the factor is greater than zero and ‘optional remedials’ if otherwise. 
(iii) D8 to display the best performance factor. ​​
RESPONSES
(a) Ways ¡n which internet makes reporting of corruption easier.
  •  Interactiveness: the internet based technology enables real-time dialogue hence instantaneous reporting of cases;
  •  Outreach: the technology allows the coverage of wide areas/can be reported from anywhere;
  •  Social mobilisation: It is easy to use technology to create a network with people or organisations with similar concerns;
  •  Anonymity: With use of the technology, it has become easy to report corruption cases without being known;
  •  Security: The message sent reaches the destination with less risk of being intruded.
(b) Circumstances when wireless is preferred
  •  When the targetted recipients are many and diverse e.g. different  platforms, devices, geographical locations.
  •  When the sender or receiver is mobile and it in practical to use wired media.
  •  When there is no space or it is inconvenient to lay cables e.g in a congested town.
  •  When the distance of travel is very big e.g extraterestial communication.
A performance factor is obtained by subtracting the target score from the actual score and dividing the difference by the target score. Write a formula that uses cell references only that would be entered in cell: (i) D2 to compute the performance factor. (ii) E2 to display the statement ‘more remedials’ if the performance factor is less than zero, ‘exempted’ if the factor is greater than zero and ‘optional remedials’ if otherwise. (iii) D8 to display the best performance factor. ​​
  • Use of the 1F function
  • First selection & output
  • Second selection & output
  • Last selection & output
(iii) = Max (D2:D7)

Read More
0 Comments

The following is an extract from a document created using a wordprocessor.

7/1/2021

0 Comments

 


The following is an extract from a document created using a wordprocessor.

Identify six formats that have been applied on the extract. (b) State three tools in a wordprocessor that would help a user to minimize spelling mistakes when creating a document. (c) The following is an extract of a spreadsheet created to manage sales. Use it to answer the questions that follow.
Identify six formats that have been applied on the extract.
(b) State three tools in a wordprocessor that would help a user to minimize spelling mistakes when creating a document.
(c) The following is an extract of a spreadsheet created to manage sales. Use it to answer the questions that follow.
(i)Write a formula that will compute the number of items whose unit price is more than 10,000. (ii) If the formula = $R2 * C$2 was placed in cell D2, state the output if it was copied to D3. (d) A school administers examinations to all students in sciences, humanities and languages. Use the entities; EXAMINATIONS, STUDENTS, SCIENCES,HUMANITIES and LANGUAGES to illustrate a network database model.
(i)Write a formula that will compute the number of items whose unit price is more than 10,000.
(ii) If the formula = $R2 * C$2 was placed in cell D2, state the output if it was copied to D3. 
(d) A school administers examinations to all students in sciences, humanities and languages. Use the entities; EXAMINATIONS, STUDENTS, SCIENCES,HUMANITIES and LANGUAGES to illustrate a network database model. 
RESPONSES
(a) Formats applied
  • Bold. strikethrough, underline, italics, centre alignment, dropcap, bulleted list, line height / spacing, 2 column paragraph. column break, casing, font type, left alignment, column separator.
(b) Tools for proofreading
  •  Spell checker and grammar/ dictionary;
  • Autocomplete;
  • Autocorrect;
  •  Thesaurus.
(i)Write a formula that will compute the number of items whose unit price is more than 10,000. (ii) If the formula = $R2 * C$2 was placed in cell D2, state the output if it was copied to D3. (d) A school administers examinations to all students in sciences, humanities and languages. Use the entities; EXAMINATIONS, STUDENTS, SCIENCES,HUMANITIES and LANGUAGES to illustrate a network database model.
(i)Write a formula that will compute the number of items whose unit price is more than 10,000. (ii) If the formula = $R2 * C$2 was placed in cell D2, state the output if it was copied to D3. (d) A school administers examinations to all students in sciences, humanities and languages. Use the entities; EXAMINATIONS, STUDENTS, SCIENCES,HUMANITIES and LANGUAGES to illustrate a network database model.

Read More
0 Comments

State three hardware devices that may be required to connect a computer to an existing local area network.

7/1/2021

0 Comments

 

​A) State three hardware devices that may be required to connect a computer to an existing local area network. (3 marks)

  •  A network adapter/network interface card
  •  Network medium/cable
  •  RJ45 connectors/BNC/ST connector/SC connectors/Fibre local connector
  •  Data points (sockets to plug in the cable)
  •  Switch/Hub
  •  Access point/TP link

​B) A publisher intends to use a desktop publishing programme to create a publication which is to have many graphics. State three ways in which the graphics may be acquired for this purpose. (3 marks)

  •  Using digital camera
  •  Scanning the graphics from other sources
  •  Downloading from the internet
  •  Drawing from scratch/Drawing tools
  •  Clip art
  •  Another file

​C) Interpret each of the following spreadsheet formula:

​(i) = countif(D2:D9, “>“&B4) (2 marks)
​(ii) sumif(B3 :B 11, “4M”, D3 :D11) (2 marks)
 (i) = Countif (D2 : D9, “>“ & B4)
  • Count those value in the range D2 :D9 with values greater than the value in cell B4). 
(ii) = Sumif (B3 : B11, “4M” D3 : D11)
  • Sum the values in the cell range D3 : D11 for records whose
  • corresponding values in cell range B3 : B11 equals to “4M”

​(D) The following are the fields of products table in a database created to store records of products manufactured in a factory:

  • product number
  • product name
  • price
  • product description
I. State the appropriate data type for each field. (2 marks)
II. State three properties to be put in place during table design to ensure integrity of the data entered. (3 marks)
I) Product Number — Number/Autonumber/Text
  • Product Name — Text/string
  • Price — Currency/Number
  • Product Description — Memo/Text/String
(II) Properties that can be set in the table design
  •  Data type
  •  Validation/Validation rule
  •  Input mask
  •  Setting required/null value status
  •  Field size
  •  Caption
​(D) The following are the fields of products table in a database created to store records of products manufactured in a factory:

Read More
0 Comments

A retailer uses a spreadsheet program to calculate profits. Figure 1 shows the spreadsheet.

6/1/2021

0 Comments

 


A retailer uses a spreadsheet program to calculate profits. Figure 1 shows the spreadsheet.

A retailer uses a spreadsheet program to calculate profits. Figure 1 shows the spreadsheet.
​(a) Which row contains labels only? 
(b) Write the formula that has been entered in cell F2. 
  •  (a) Row 1 or 1 
  • (b) = D2*E2; = product(D2E2)
  • OR = Product (D2: E2)

Read More
0 Comments

Differentiate between relative cell referencing and absolute cell referencing.

5/1/2021

0 Comments

 


Differentiate between relative cell referencing and absolute cell referencing.

  • Relative referencing, there is use of a formula whose references keeps on changing automatically depending on their relative position when they are copied from one cell to another.
  •  In Absolute referencing, the cells referenced are specific.
Differentiate between relative cell referencing and absolute cell referencing.

Read More
0 Comments

​In a spreadsheet the formula =If(AI>10, A1 *77, A1*50) is entered in a cell. Interpret the results

5/1/2021

0 Comments

 

​​In a spreadsheet the formula =If(AI>10, A1 *77, A1*50) is entered in a cell. Interpret the results. (3 marks)

=If(A1>10,A1 *77,A1 *50)
Compares the value in cell Al ¡fit is greater than 10, if comparison is True, the results of operations Al * 77 is displayed, if it is False the results of the operations A1 * 50 is displayed.
if functions in spreadsheets

Read More
0 Comments

​Explain the function of protect sheet feature in a spreadsheet program

4/1/2021

0 Comments

 

​Explain the function of protect sheet feature in a spreadsheet program. (2 marks)

Function of protect sheet:
  • It is a feature used to prevent unwanted changes to be made on the data contained in a sheet by limit the ability to make changes.
​Explain the function of protect sheet feature in a spreadsheet program

Read More
0 Comments

What is meant by each of the following terms as used in table creation?

4/1/2021

0 Comments

 


What is meant by each of the following terms as used in table creation?

(a) What is meant by each of the following terms as used in table creation?
(i) cell margin; 
(ii) nested table. 
(b) State four types of text wrap that can be applied to a graphic. 
(c) Distinguish between each of the following:
(i) axis labels and data labels; 
(ii) cropping and sizing. 
(d) Figure 1 shows a section of a worksheet containing information on household items.
Use it to answer the questions that follow.
(a) What is meant by each of the following terms as used in table creation? (i) cell margin; (ii) nested table. (b) State four types of text wrap that can be applied to a graphic. (c) Distinguish between each of the following: (i) axis labels and data labels; (ii) cropping and sizing. (d) Figure 1 shows a section of a worksheet containing information on household items. Use it to answer the questions that follow.
(i) Write a formula to calculate the total cost of rice. 
(ii) The prices of all items increased by 10% and the value 10% is placed in cell B8. Using cell addresses with absolute referencing only, write a formula to calculate the new unit price of salt. 
(iii) Write a function to display the number of cells in which the cost per unit is equal to 110. 
(iv) Write a function to display the least total cost for all items. 
(a) (i) Cell margin: Its the space between the boundary of the cell and the text/content inside the cell.
(ii) Nested table: is a table created inside another table.
(b)  In line with text.
  •  Square
  •  Behind text.
  •  Infront of text.
  •  Tight.
  •  Through.
  •  Top and bottom.
  •  None.
  • Solution
  • (c) (i) Axis label: Data corresponding to the vertical or horizontal lines of a given chart whereas the x-axis and y-axis.
  • Data label: are data that provide additional information about a data marker which represents a single data point on a value that originates from a worksheet cell. .
(ii) Cropping is the process of trimming/cutting/hiding vertical or horizontal edges of an object/picture while sizing is the process of enlarging/expanding or reducing/contracting an object/picture to appropriate dimension.
Picture

Read More
0 Comments

Distinguish between a formula and a function as used in spreadsheets.

3/1/2021

0 Comments

 


Distinguish between a formula and a function as used in spreadsheets.

Vertical Divider
Distinguish between a formula and a function as used in spreadsheets.
  • Formulae are user designed expressions that create a relationship between cells and return a value in a chosen cell. While a function is an inbuilt predefined (hidden sub-program) that is found in a spreadsheet program.

Read More
0 Comments

List three paragraph formatting activities  in word processing

2/1/2021

0 Comments

 

​(a) List three paragraph formatting activities  in word processing(3 mks)

  1. alignment
  2. Tabs
  3. Indentation
  4. Outline level
  5. Line spacing
List three paragraph formatting activities in word processing

Read More
0 Comments

The cells K3 to K10 of a worksheet contain remarks on student’s performance such as very good, good, fair and fail depending on the average mark. Write a formula that can be used to count all students who have the remark “very good”

2/1/2021

0 Comments

 
The cells K3 to K10 of a worksheet contain remarks on student’s performance such as very good, good, fair and fail depending on the average mark. Write a formula that can be used to count all students who have the remark “very good” (3mks)
  • = countif(K3:K10,”very good”)

Read More
0 Comments

A student presented a budget in the form of a worksheet as follows:

1/1/2021

0 Comments

 
A student presented a budget in the form of a worksheet as follows
Picture
​The student intends to have spent half the amount by midterm

Read More
0 Comments

A computer accessories vendor needs to order supplies. A spreadsheet is used to calculate the order part of which is shown below.

31/12/2020

1 Comment

 


A computer accessories vendor needs to order supplies. A spreadsheet is used to calculate the order part of which is shown below.

A computer accessories vendor needs to order supplies. A spreadsheet is used to calculate the order part of which is shown below.

(a)Write the formula that can be used in:
(i)D2
(ii)D5 ​

​(b)If a value added tax (VAT) of 16% was charged on each item and the number ordered was decreased by 10%, write a new formula that can be used in D2 

A computer accessories vendor needs to order supplies. A spreadsheet is used to calculate the order part of which is shown below.

Read More
1 Comment

A company has decided to computerize their operations. They have decided to purchase packages instead of developing their own programs. Give three advantages and two disadvantages of this approach.

31/12/2020

0 Comments

 

​(a) A company has decided to computerize their operations. They have decided to purchase packages instead of developing their own programs. Give three advantages and two disadvantages of this approach.

Advantages
  1. Saves on programming effort and exposure on the part of the user (client)
  2. The user gets a well- tried and tested  program
  3. Relatively quick implementation results from use of package
Disadvantages
  1. Purchaser does not have full control over the packages as would have been if it was developed in house
  2. Package is produced to meet general needs & may not be ideal for a particular customer

Read More
0 Comments

Distinguish between labels and formulae with respect to spreadsheet

31/12/2020

0 Comments

 

(a) Distinguish between  labels and formulae with respect to spreadsheet (2mks)

  • Label
    a non- numeric piece of data entered into an electronic spreadsheet cell.  Labels are not used for computations. Any cell entry, which begins with a letter or on apostrophe, is a level.
  • Formulae
    Mathematical computations which join other cells’ values with mathematical operators such as +, -, * or /

​(b) Consider the entries in the cells below

Picture

​(c) ​State the values displayed in cell C14 (2mks)

Error (#value) NB: the = sign is missing in cells C10 and C11

Read More
0 Comments

Explain data series, axis and legends as used in spreadsheet charts. Data, Axis and Legend

29/12/2020

0 Comments

 


Explain data series, axis and legends as used in spreadsheet charts. Data, Axis and Legend

Data Series
  • The selected range in a worksheet that EXCEL converts into a graphic and displays as a chart (in spreadsheet applications)
Axis 
  • A reference line from \which distances or angles are measured in a coordinate system, such as the X-axis and y-axis in the Cartesian coordinate system
Legend
  • Brief description accompanying an illustration (chart) also known as a caption 
Explain data series, axis and legends as used in spreadsheet charts. Data, Axis and Legend

Read More
0 Comments

Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting

29/12/2020

0 Comments

 


Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting

​b) State one way in which a user may reverse the last action taken in a spreadsheet package. 
c) The following is a sample of a payroll. The worksheet row and column headings are marked 1, 2, 3, . and A, B, C. respectively
Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting
Use the following expressions to answer the questions that follow:
  •  Basic pay = hours worked x pay per hour
  • Allowances are allocated at 10% of basic pay
  • Gross pay = basic pay + allowances
  • Tax deductions are calculated at 20% of gross pay
  •  Net pay = Gross pay – tax deductions.
Write formulae using cell references for the following cells;
i) D2 
ii) E4 
iii) F10 
iv) G7 
v) H5 
d) i) State three ways of moving round the page in a Desktop Publishing window. 
ii) State two ways on how information & Communication Technology (ICT) can be used to reduce the spread of HIV/AIDS
EXPECTED RESPONSES
(a) Distinguish  between  the following sets  of terms as used  in  spreadsheets
(i) Worksheet and workbook
  • Worksheet – The working area in an electronic spreadsheet on which a 
  • user enters the spreadsheet data.
  • Workbook – A spreadsheet file. A workbook can obtain several worksheets
(ii) Filtering and sorting
  • Data filtering is a way of organizing spreadsheet data for ease of analysis. Often spreadsheet filters are used to “hide” rows of data that do not meet certain specified criteria. This allows you to analyze (e.g. count, observe etc) only certain “Filtering” groups of data.
  • Data sorting: Is a way of arranging record according to one of the fields in either ascending or descending order.
(b) State one way in which a user may reverse the last action taken in a spreadsheet package
Use the undo command (ctrl + z)
(c)The following is a sample of a payroll. The worksheet row and column headings are marked 1, 2, 3, and A, B, C respectively
Use the following expressions to answer the questions that follow: Basic pay = hours worked x pay per hour Allowances are allocated at 10% of basic pay Gross pay = basic pay + allowances Tax deductions are calculated at 20% of gross pay Net pay = Gross pay – tax deductions. Write formulae using cell references for the following cells; i) D2 ii) E4 iii) F10 iv) G7 v) H5 d) i) State three ways of moving round the page in a Desktop Publishing window. ii) State two ways on how information & Communication Technology (ICT) can be used to reduce the spread of HIV/AIDS
Use the following expressions to answer the questions that follow
  • Basic pay- Hours worked x  pay per hour
  • Allowances  are allowed at 10% of basic pay
  • Gross pay- Basic pay + allowances
  • Tax  deductions are calculated  at 20% of gross  pay
  • Net pay-= gross  pay – tax deductions
Write formulae using cell references for the following cells
  • (i)D2  = B2 * C2
  • (ii)E4 = 10% * D4 or 10% * (B4 * C4)
  • (iii)F10 = D10 + E10
  • (iv)G7 = 20% * F7
  • (v)H5 = H5 – G5
(d) (i) State three ways  of  moving round the page in  desktop  publishing  window 
  • Use cursor keys
  • use mouse scroller
  • Use scroll buttons (horizontal and vertical)
(ii)State two ways on how information & communication technology (ICT) can be used to reduce the spread of HIV/ AIDS
  • Through  advertisements on the Internet
  • Through creation of posters
  • Through discussion  groups  on the internet

Read More
0 Comments

The Formula = k20 + p $18 was typed in cell L21 and then copied to cell M24 of a spreadsheet. Write the formula as it appears in cell M24 (2mks)

29/12/2020

0 Comments

 

​The Formula = k20 + p $18 was typed in cell L21 and then copied to cell M24 of a spreadsheet. Write the formula as it appears in cell M24 (2mks)

  • L23 + Q$18

Read More
0 Comments

List any four tasks that an electronic spreadsheet should be able to perform other than calculations

27/12/2020

0 Comments

 

​(a) List any four tasks that an electronic spreadsheet should be able to perform other than calculations.

  • Production of graphs
  • Automatic  recalculation
  • Projection of growth curves through what-if analysis
  • Have editing and formatting features that can be used to change appearance of data and make necessary changes.
  • Have features of a database therefore they can be used to filter, sort, validate data and remove duplicates.
  • They can import and export data from other programs and platforms.

​(b) Explain what is meant by automatic recalculation as used in a spreadsheet.

Feature of electronic spreadsheet system which runs anytime a cell is updated, causing all formulas, functions and macros which depend on that cell to automatically update their  computations

Read More
0 Comments

The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet.

27/12/2020

0 Comments

 
The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet.  Enter the formulae, as they would appear when copied to the cell M20 of the same spreadsheet.
The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet
The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet

Expected Response

Picture

Read More
0 Comments

Andrew, Jane, David and Zablon had tea, sausages and bananas for breakfast ...

26/12/2020

0 Comments

 
​Andrew, Jane, David and Zablon had tea, sausages and bananas for breakfast. They took one sausage, two sausages, three sausages and one sausage respectively. In addition, they took a cup of tea and two bananas. Tea, sausages and bananas cost Kshs 10, 15 and 5 respectively.
​By naming columns A, B, C … and rows 1, 2, 3 …………….

​(a) Construct a worksheet showing the above information (7mks)

spreadsheet's worksheet

Read More
0 Comments
<<Previous
    COMPUTER STUDIES QUESTIONS AND ANSWERS

    Categories

    All
    1998
    1999
    2000
    2001
    2002
    2003
    2004
    2005
    2006
    2007
    2008
    2009
    2010
    2011
    2012
    2013
    2014
    2015
    2016
    2017
    2018
    2019
    2020
    2022
    Analogue And Digital Systems
    Applications Areas Of ICT
    Areas-where-computers-are-used
    Auxiliary Storage Devices
    Basic-computer-set-up-and-cabling
    Binary Addition
    Binary Subtraction
    Career Opportunities In ICT
    Classification Of Computers
    Classification-of-computers
    Coaxial Cables
    COMPACT DISK
    COMPLETE PAPERS
    Computer Crimes
    Computer-files
    Computer Memory
    Computer Software
    Computer Systems
    COMPUTER VIRUS
    Dashboard
    Database
    Data Collection
    Data Communication
    Data-integrity
    Data Processing
    Data Representation In A Computer
    Data Security And Controls
    Definition And Development Of Algorithm
    Definition-of-a-computer
    Desktop Publisher
    Development-of-computers
    DTP
    DVD
    Editing-and-formatting-a-word-document
    Electronic Data Processing Modes
    Elementary Programming Principles
    Errors-in-data-processing
    Evolution-of-computer-systems
    Fibre Optic Cables
    File Management Using An Operating System
    File-organization-methods
    Flowchart
    Form 1 Level
    Form 2 Level
    Form 3 Level
    Form 3 Mock Exams
    Form 4 Level
    Formatting Features
    Hands On Skills
    HARDCOPY OUTPUT DEVICES
    Hardware
    Impact Of Ict On Society
    IMPACT PRINTERS
    Information
    Input Devices
    Internet And Email
    Introduction To Computers
    Introduction To Networking And Data Communication
    ISP
    Levels-of-programming-languages
    Midterm-exams
    Mind-blowing-q-a
    Mocks
    Network-topology
    NON-IMPACT PRINTERS
    Octal
    Operating Systems
    Output-devices
    Paper-1
    Parts-of-a-computer
    Printers
    Processing-devices
    Processors
    Program-construction
    Program-control-structures
    Program-design
    Program-development
    Program-documentation
    Protocols
    Registers
    Review Questions
    Revision Kits
    Secondary Storage Media
    Section A
    Section B
    Security Threats And Control Measures
    Software
    Spreadsheets
    Stages Of System Development
    Storage Devices
    Symbolic-representation
    System-design
    System Development
    System-documentation
    Term-1
    TERM 2
    The Computer Laboratory
    The CPU
    The Keyboard
    Types Of Computer Files
    Types-of-networks
    User Interface
    Uses-of-computers
    Word Processors
    Worksheet-formatting

    Archives

    December 2024
    February 2023
    November 2022
    September 2022
    April 2022
    January 2022
    December 2021
    November 2021
    July 2021
    March 2021
    February 2021
    January 2021
    December 2020
    October 2020
    April 2020
    February 2020
    October 2019
    August 2019
    July 2019
    April 2019
    March 2019
    November 2018
    August 2018
    July 2018
    December 2017
    November 2017
    October 2017
    July 2017
    August 2016
    June 2016
    January 2016
    December 2015
    November 2015

    RSS Feed



Primary Resources
  • K.C.P.E Past Papers
  • ​Pri - Primary 1 Level
  • Pri  - Primary 2 Level
  • Grade 1
  • Grade 2
  • Grade 3
  • Grade 4
  • Standard 5
  • Standard 6
  • Standard 7
  • Standard 8
  • English
  • Kiswahili
  • Social Studies
  • Science
  • Mathematics
  • Kenya Sign Language
  • I.R.E
  • ​H.R.E
  • Notes
  • Termly Questions
  • Mocks
  • K.C.P.E Past Papers
College Resources
  • E.C.D.E
  • P.T.E
  • D.T.E
  • Technical Diploma
  • Technical Certificate
  • Business Diploma
  • Business Certificate
  • Higher Diploma
  • K.A.S.N.E.B Resources
  • K.M.T.C Resources
  • Varsity Resources
Secondary Resources
  • K.C.S.E Past Papers
  • Form 1
  • Form 2
  • Form 3
  • Form 4
  • Term 1
  • Term 2
  • Term 3
  • English
  • Geography
  • History
  • C.R.E
  • I.R.E
  • ​H.R.E
  • Home Science
  • Computer Studies
  • Business Studies
  • Agriculture
  • Chemistry
  • Biology
  • Physics
  • Mathematics ALT A
  • Mathematics ALT B
  • Kiswahili
  • French
  • Germany
  • Arabic
  • Aviation
  • Art & Design
  • Drawing & Design
  • Building & Construction
  • Metal Works
  • Wood Work
  • Music
  • Kenya Sign Language
  • Electricity
Other Useful Links
  • Academic Environment
  • How its Done
  • News and Opinions
  • Manyam Franchise Support
  • About
  • SITEMAP
  • FOCUS A365 SERIES
  • Membership Details (KCPE/KCSE)
  • Secondary Mocks
  • SYLLABUS
Contact Us
Manyam Franchise
P.O Box 1189 - 40200 Kisii
Tel: 0728 450 424
Tel: 0738 619 279
Tel: 0763 450 425
E-mail - sales@manyamfranchise.com
Photos used under Creative Commons from wwarby, JoshMacDonald, Visual Content, wuestenigel, Homini:), Wonderlane, Mike Licht, NotionsCapital.com, The Official CTBTO Photostream, Nabor Garrido, picsaf.com, OER Africa, Jemimus, andronicusmax, Christoph Scholz, cyanocorax, matsuyuki, Mark Hodson Photos, cathyse97, tompagenet, ToGa Wanderings, crstnksslr, machernucha, panpot, ePublicist
  • Start
    • SITEMAP
    • KNEC Portal
    • ZERAKI HELP AND SUPPORT
    • Academic Environment
    • KNEC KCSE PROJECT INSTRUCTIONS
  • BLOGS
    • About Us? >
      • Learn more about us
    • CUSTOMER CARE >
      • PRICING
      • Help & Support
    • News and Opinions
    • JOBS IN KENYA AND ABROAD FOR KENYANS AND BEYOND
    • How its Done
  • OUR PRODUCTS
    • All Categories >
      • MORE PRODUCTS >
        • SECONDARY CRE NOTES
        • COURSE BOOKS
        • KCSE KISWAHILI SETBOOKS
        • Backed Up Files and Archives
        • FREE DOCUMENTS
        • PRIMARY 8-4-4 BASED RESOURCES
        • STANDARD 8 RESOURCES
        • HIGH SCHOOL RESOURCES >
          • Biology Paper 3 Exams
          • Secondary Examinations
        • PRIMARY CBC BASED RESOURCES
        • COLLEGE & VARSITY RESOURCES
      • PRIMARY RESOURCES CBC
      • PRIMARY RESOURCES 8-4-4
      • SECONDARY RESOURCES
      • NOTES & TUTORIALS
      • COLLEGE RESOURCES
      • NOVELS and OTHER BOOKS
    • EXAMINATIONS >
      • MOCKS AND JOINT EXAMS >
        • FORM 1 QUESTION PAPERS, ANSWERS AND MARKING SCHEMES COLLECTIONS
        • FORM 2 QUESTION PAPERS, ANSWERS AND MARKING SCHEMES COLLECTIONS
        • FORM 3 EXAMINATIONS, QUESTION PAPERS AND ANSWERS
        • FORM 4 MOCKS PAST EXAMS BY REGION
        • TOP SECONDARY EXAMS ALL SUBJECTS
      • KPSEA NATIONAL EXAMS
      • KCPE >
        • KCPE PAST PAPERS AND ANSWERS >
          • KCPE 2020 RESULTS, REPORTS, QUESTIONS AND ANSWERS
          • KCPE PAST PAPERS 2019 REPORTS, RESULTS, QUESTIONS AND ANSWERS
        • KCPE PAST PAPERS PER SUBJECT
      • KCSE >
        • KCSE PAST PAPERS BY SUBJECT
        • KNEC KCSE PAST PAPERS, MARKING SCHEMES, QUESTIONS & ANSWERS
        • Free KCSE Past Papers Mathematics
        • Free KCSE Biology Questions and Answers
      • QUESTIONS & ANSWERS >
        • SECONDARY >
          • LANGUAGES >
            • Secondary English Questions and Answers
          • TECHNICALS >
            • COMPUTER STUDIES >
              • COMPUTER STUDIES Q & A
              • kcse computer studies paper 2 AND 3 Questions & Answers
            • BUSINESS STUDIES QUESTIONS & ANSWERS
            • KCSE AGRICULTURE TOPICAL QUESTIONS AND ANSWERS
            • KCSE HOME SCIENCE DIRECT QUESTIONS AND ANSWERS
          • SCIENCES >
            • KCSE Mathematics Topical Questions
            • KCSE Biology Topical Questions and Answers
            • CHEMISTRY TOPICAL QUESTIONS AND ANSWERS
            • KCSE Physics Topical Questions
            • KCSE physics Practical Sample Quiz
          • HUMANITIES >
            • C.R.E (CRE) QUESTION AND ANSWERS
            • ISLAMIC RELIGIOUS EDUCATION (IRE) QUESTIONS AND ANSWERS
            • KCSE History Topical Questions and Answers
            • GEOGRAPHY TOPICAL QUESTIONS AND ANSWERS
        • PRIMARY >
          • Standard 4-8 Mathematics Topical Questions from Mocks and KCPE
          • Std 6 Mathematics Notes
    • TUTORIALS >
      • SECONDARY >
        • SCIENCES >
          • FOCUS MATHEMATICS TUTORIALS AND EXAMS FREE
          • KCSE BIOLOGY NOTES
          • FREE KCSE CHEMISTRY NOTES
          • KCSE PHYSICS NOTES, AUDIOVISUALS AND MORE
        • LANGUAGES >
          • ENGLISH >
            • A GUIDE TO SILENT SONG AND OTHER STORIES
            • English KCSE Set Books
            • ENGLISH POETRY QUESTIONS WITH ANSWERS FOR K.C.S.E CANDIDATES
            • ENGLISH GRAMMAR #KCSE
          • KISWAHILI >
            • Bembea ya Maisha
            • CHOZI LA HERI - MWONGOZO
            • KIGOGO - MWONGOZO
            • MASWALI NA MAJIBU YA TUMBO LISILOSHIBA
            • USHAIRI MASWALI NA MAJIBU
            • KCSE Kiswahili Fasihi
        • TECHNICALS >
          • HOME SCIENCE NOTES
          • KCSE BUSINESS STUDIES NOTES
          • COMPUTER STUDIES NOTES LATEST
          • kcse Computer Studies Notes
          • KCSE AGRICULTURE NOTES, SYLLABUS, QUESTIONS, ANSWERS, SCHEMES OF WORK AND OTHERS
        • HUMANITIES >
          • KCSE History Notes Form 1 to 4
          • FREE KCSE CRE NOTES
          • KCSE GEOGRAPHY NOTES
          • IRE NOTES, AUDIOVISUAL, QUESTIONS AND ANSWERS
      • PRIMARY >
        • STANDARD 4: SOCIAL STUDIES
        • NOTES >
          • KISWAHILI
          • SOCIAL STUDIES
        • EXAMINATIONS
        • DecaTurbo Online Series Examinations
        • KCPE Mathematics Notes
        • KCPE and Primary Level Compositions
      • Other Supportive Documents >
        • SYLLABUS >
          • Primary 8-4-4 based Syllabus, Objectives and Lessons
          • Primary Mathematics Syllabus
        • MASOMO VIDEOS
    • CURRICULUM >
      • NEW CURRICULUM DESIGNS >
        • PRIMARY >
          • PRE PRIMARY ONE CURRICULUM WITH SYLLABUS
          • PRE PRIMARY TWO CURRICULUM WITH SYLLABUS
        • SECONDARY >
          • KNEC KCSE SYLLABUS AND COURSE OUTLINES
        • COLLEGE >
          • Regulations for the TIVET Craft and Diploma Business Examinations
    • HIGH INSTITUTIONS >
      • EXAMINATIONS >
        • College and Varsity Past Papers online
      • TUTORIALS >
        • COLLEGE AND UNIVERSITY NOTES AND TUTORIALS
  • MEMBERS RESOURCES
    • Primary >
      • CBC AND 8-4-4 LATEST EXAMS
      • CBC PROFFESSIONAL TOOLS
      • CBC NOTES PRIMARY
      • CBC KPSEA EXAMS
      • Standard 8 (std) English Topical Questions
      • KCPE MATHEMATICS TOPICAL QUESTIONS FROM 1989 TO LAST YEAR
      • STANDARD 8 PAST PAPERS 8-4-4 BASED
    • Secondary >
      • FORM 1 EXAMS WITH ANSWERS
      • FORM 2 EXAMS WITH ANSWERS
      • FORM 3 EXAMS WITH ANSWERS
      • FORM 4 EXAMS WITH ANSWERS
      • KCSE 2020 QUESTIONS AND ANSWERS
      • NOTES SECONDARY
      • MOCKS SECONDARY >
        • kcse form 2 mathematics questions
    • Free Schemes of Work
    • FOCUS A365 SERIES K.C.P.E EXAMINATIONS FOR PRIMARY
    • ALL GROUPS PRODUCTS
    • PREMIUM PRODUCTS 2