Computer Studies Paper 2 Questions and Answers - Kassu Jet Joint Mock Exams 2023

Instructions to candidates

1. Answer all the questions
2. All questions carry equal marks
3. Passwords should NOT be used while saving in the CD/Removable storage medium
4. All answers must be saved in your CD/Removable storage medium
5. Make a printout of the answers on the answer sheet
6. Arrange your printouts and tie/staple them together
7. Hand in all the printouts and the CD/Removable storage medium used

QUESTIONS

QUESTION ONE

What Is Artificial Intelligence?

Artificial Intelligence is the field of developing computers and robots that are capable of behaving in ways that both mimic and go beyond human capabilities. AI-enabled programs can analyze and contextualize data to provide information or automatically trigger actions without human interference.

What Is Machine Learning?

Machine learning is a pathway to artificial intelligence. This subcategory of AI uses algorithms to automatically learn insights and recognize patterns from data, applying that learning to make increasingly better decisions.
By studying and experimenting with machine learning, programmers test the limits of how much they can improve the perception, cognition, and action of a computer system.
Deep learning, an advanced method of machine learning, goes a step further. Deep learning models use large neural networks — networks that function like a human brain to logically analyze data — to learn complex patterns and make predictions independent of human input.

How Companies Use AI and Machine Learning

To be successful in nearly any industry, organizations must be able to transform their data into actionable insight. Artificial Intelligence and machine learning give organizations the advantage of automating a variety of manual processes involving data and decision making. Some expressions including basic numbers like squares of numbers e.g 232 and base value of numbers like H4C16 can be processed.
By incorporating AI and machine learning into their systems and strategic plans, leaders can understand and act on data-driven insights with greater speed and efficiency. The table below shows the company’s per country that have implemented AI and machine language and the expected growth rate in five years time.

1. Using a word processor application, create the above document as it appears and save it as KASU 1 exam 13 marks
2. Insert the AutoShape as it appears 2 marks
3. Spell check your document 1 mark
4. Copy the above document into a new word document and save it as Kasu Final exam 3 marks
5. Format all the titles in the document as follows:
   1. Font type Aerial 1 mark
   2. Font size 14.5 1 mark
   3. Font colour Black, text 1 1 mark
   4. Double underline 1 mark
   5. Bold italic 1 mark
   6. Character spacing Expanded 150% 2 marks
6. Insert a dropped drop cap to 2 lines in the first paragraph starting with the word “artificial intelligence” and in margin drop cap to 2 lines in the second paragraph starting with the word “machine learning” 2 marks
7. Find the abbreviation AI and replace it with artificial intelligence 2 marks
8. Insert two columns in the 2nd last paragraph starting with “to be successful” with a line in between them 2 marks
9. Format the titles in the table as follows:
   1. Centre align all the titles 1 mark
   2. Change the text direction of the titles on the table to 900 1 mark
   3. Double strike through 1 mark
   4. Bold 1 mark
10. Enter a formular to get the yearly increament for Kenya 2 marks
11. Enter a formula to calculate the total NO. of AI machines in the five countries above 2 marks
12. Insert a row above row one, merge all the cells and enter an appropriate title for the table 3 marks
13. Insert the header of your document as © your name and footer as your class and admission number 2 marks
14. Insert a caption with the title Artificial intelligence in East Africa 2 marks
15. Print KASU1 exam and Kasu Final exam 2 mark

QUESTION TWO
The table below shows a soccer league at the end of the season. The league comprises of 15 teams and each played 29 matches to close the season. Using a spread sheet program, represent the data and answer the questions below:

1. Create a workbook called LEAGUE_RESULTS (1 Mark)
2. Using a customised INPUT FORM, enter the following data into a worksheet and format it
   exactly as it appears. (10 Marks)
3. Set data validation criteria to ensure that matches won, drawn or lost do not exceed 29. A message "INCORRECT!" should be displayed in case the validation rule is violated. (4 Marks)
4. Rename the worksheet as LeagueTable (2 Marks)
5. Given that the total number of games played by each team in the season is 29, determine the number of games lost by each team. (2 Marks)
6. Calculate the points obtained by each team during the season given that: - (3 Marks)
   

   Results	Points
   Win	3
   Draw	1
   Loss	0

7. Determine each team’s position in the league given that the team with the highest number of points becomes the first position in the league. (4 Marks)
8. Determine the number of teams that garnered above 55 points in the league. Label the cell appropriately. (3 Marks)
9. Given that teams get cash awards based on their positions according to the table below.
   Apply an appropriate formula to determine the team awards. (4 Marks)
   

   Team Position	Team Award
   1	$ 1,000,000
   2	$ 500,000
   3	$ 250,000
   4	$ 125,000
   Others	$ 0

10. Sort the data in ascending order by Team Position. (1 Mark )
11. Copy the worksheet LeagueTable to a new worksheet and rename it as CountyTeams (1 Mark)
12. Using SubTotals function in CountyTeams worksheet, determine the Average Points of all the teams in each county (5 Marks)
13. Using worksheet LeagueTable plot a column graph on its own worksheet renamed as LeagueAnalysis showing the TeamName and TeamPoints only. (7 Marks)
14. Print the following: (3 Marks)
    1. Formulas only in LeagueTable worksheet
    2. CountyTeams worksheet
    3. LeagueAnalysis worksheet

MARKING SCHEME

QUESTION 1

Question two