Author: Msomi Bora

TOPIC 1: MANAGEMENT OF DATABASE INFORMATION SYSTEM Updating Database The Record in an Existing Database Search a Record in an Existing Database In this sub topic explains how to update existing data. Microsoft Office Access 2007 provides a number of tools for updating existing records, including datasheets, forms, queries, find-and-replace, and the new Data Collection feature. As you proceed, remember that updating data is not the same process as entering new data. Use an update query to change existing data You use update queries to add, change, or delete part (but not all) of one or more existing records. You…

COMPUTER NOTES FOR FORM THREE Click the links below to view the notes: TOPIC 1 – IMPACT OF INFORMATION AND COMMUNICATION TECHNOLOGY (ICT) ON THE SOCIETY TOPIC 2 – WEB DEVELOPMENT TOPIC 3 – DATABASE AS INFORMATION SYSTEMS

TOPIC 3: DATABASE AS INFORMATION SYSTEMS Manual Data Processing System Manual data processing system Describe Manual data processing system Manual data processing system refers as traditional way of data processing. These data are made up by computer. They are pencil and paper data processing. It’s a physical organization of raw data to turn into usable form of information. This usually can be applicable when data is collected through paper questionnaire, or postcards. Electronic Data Processing Systems The Electron Data Progressing System Describe the Electronic Data Progressing System Electronic data processing system refers as modern way of data processing. These data are made…

TOPIC 2: WEB DEVELOPMENT Introduction to Web Page Design The Concepts of a Webpage Explain Concepts of a webpage A web page is a document commonly written in Hypertext Markup Language (HTML) that is accessible through the Internet or other network using an Internet browser. A web page is accessed by entering a URL address and may contain text, graphics and hyperlinks to other web pages and files. The page you are reading now is an example of a web page. Website a set of related web pages located under a single domain name. or this is is a collection of related…

TOPIC 1 IMPACT OF INFORMATION AND COMMUNICATION TECHNOLOGY (ICT) ON THE SOCIETY The Role of ICT in Daily Life The Role of ICT in Business, Medicine Engineering, Data Management and Entertainment Explain the Role of ICT in Business, Medicine Engineering, Data Management and Entertainment a) In Education Students and teachers records processing and keeping as a computer aided learning (CAL) as well as computer aided instruction (CAI) used to access teaching and learning materials in the internet ( online learning Facilitate distance learning Can be used as a research tool e.g. to analyze data from experiment To assist education management.…

 COMPUTER NOTES FOR FORM TWOClick the links below to view the notes: TOPIC 1 – WORD PROCESSINGTOPIC 2 – SPREADSHEETTOPIC 3 – COMPUTER NETWORKS AND COMMUNICATIONSTOPIC 4 – THE INTERNET

TOPIC 4: THE INTERNET Concepts of Internet The Internet Describe the Internet Internet is a wide world connection of computer which enables sharing of resource like files and folders, picture and music, teaching materials like notes / tutorials and computers. This is the global system of interconnected computer networks that use the Internet protocol suite (TCP/IP) to link devices worldwide. Communication between networks is called inter networking. Therefore internet comes from the word inter networking meaning a connection of data communication. The communication in which the end instruments are computers. The internet is a worldwide public networks that interconnect thousands of…

TOPIC 3: COMPUTER NETWORKS AND COMMUNICATIONS Introduction to Local Area Network (LAN) and Wide Area Network (WAN) The Computer Network Describe a Computer Network A network can be defined as a group of computers and other devices connected in some ways so as to be able to exchange data. Each of the devices on the network can be thought of as a node; each node has a unique address. Addresses are numeric quantities that are easy for computers to work with, but not for humans to remember. Example: 204.160.241.98 Some networks also provide names that humans can more easily remember…

TOPIC 2: SPREADSHEET Concept and Terminologies The Spreadsheet Program Describe the Spreadsheet Program A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form. Alternatively referred to as a worksheet, a spreadsheet is a file made of rows and columns that help sort data, arrange data easily, and calculate numerical data. Examples of spreadsheet programs are: Google sheet iWork numbers Libre Office Lotus 1-2-3 Lotus Symphony Microsoft Excel Open Office Today Microsoft Excelis the most popular and widely used spreadsheet program (figure 1) The Spreadsheet Terminology Explain Spreadsheet Terminology TERMINOLOGIES USED IN SPEADSHEET (EXCEL)…

TOPIC 1: WORD PROCESSING Starting and Ending a Wording Processing Program The Meaning of Word Processing Explain the Meaning of Word Processing Word processing is the process of creating, editing, storing and printing typed documents. One is able to write text, store it electronically, display it on a screen, modify it by entering commands and characters from the keyboard, and print it. The Importance of Word Processing Explain the Importance of Word Processing The importance of word processing are as following: Saves time— Word processing helps teachers use preparation time more efficiently by letting them modify materials instead of creating…