Share this:

 

FIRST TERM
SUBJECT: COMPUTER STUDIES CLASS: JSS 3

SCHEME OF WORK

WEEK TOPIC
1. REVISION/INTERNET.
2. USES OF SEARCH ENGINES.
3. DIGITAL DIVIDE I.
4. DIGITAL DIVIDE II.
5. DIGITAL LITERACY I.
6. DIGITAL LITERACY II.
7. DATABASE.
8. FORMS OF DATABASE.
9. SPREAD SHEET.
10. SPREAD SHEET PACKAGES.
11. REVISION.

REFERENCES
A handbook on computer studies by: Niyi Adekolegan.
 

  • On-line Materials.
  • Simple guide to computer by: Henry Udu.

 

WEEK ONE

TOPIC: INTERNET

The word “INTERNET” stands for International Network simply put as NET. It comprises of all computers around the world, connected together to share resources and information irrespective of distance and/or geographical location. The Internet is a worldwide communication medium or pool from where people all over the world could exchange retrieve, disseminate and store information thus, turning the world into a global village. It is the use of internet that actually turns the world into a global village where users like government, military, educational and commercial institutions around the world become one. There is no person, company, government or country that can claim single ownership of the internet. The computers within the internet are connected via communication equipment including telephone lines i.e. wired or wireless, satellites etc.

 

WHAT IS INTERNET?

The internet, that is, International Network is an electronic means of communication via a computer network, whereby people all over the world can have access to information at any time in a matter of seconds. Information can be given to people all over the world to see and retrieve at the same time using computer and telephone. It is the fastest and the most reliable means of data and information transfer.

Internet is a worldwide communication medium where people all over the world can exchange, retrieve, disseminate and store information. No one person or organization owns the internet. It belongs collectively to the telecommunication companies.

 

EVALUATION

ecolebooks.com
  1. What is Internet?
  2. What is another name for Internet?

     

E-MAIL

E-mail simply means electronic mail. It is the most widely used resource on the net. It has a common resource provided by the net from sending and receiving electronic. E-mail has become the live wire for many businesses and personal communication. It is easier, faster and better. Emails are sent and received to or from any part of the world in a second. To send e-mail involves composing the message, connecting and sending the message. Generally, the message is created or composed on the computer and sent through the same medium to the destination. To facilitate effective use of e-mail facilities, user also needs to have his or her own e-mail address (i.e. [email protected]), because in any form of letter writing there is always the addresser’s address and the addressee’s address.

 

EVALUATION

  1. What is E-mail?
  2. Give an example of e-mail address

     

WORLD WIDE WEB (WWW)

The World Wide Web (www) is a package designed to present detailed information about an organization, product services. The World Wide Web, also referred to as the web, is the global collection of multimedia document and files, which are stored on computer connected to the internet. There are specific sites called website that have unique feature or information. A website is a collection of web pages maintained by the owner of the site. It is like having files containing information about your activities all in one collection. Each of the site has unique address and is called UNIFORM RESOURCE LOCATORS (URL) by which the site can be reached or located for whatever information. A typical URL anatomy made of three parts.

 

Part Meaning

Http://   protocol

www.lycos.com/ the name of the computer where the information is located

Index the path and filename of the file retrieve

 

GENERAL EVALUATION

  1. What is the World Wide Web?
  2. What is URL?
  3. The URL can be divided into how many parts?
  4. What is a website?

 

READING ASSIGNMENT

A HANDBOOK ON COMPUTER PAGE 14

 

WEEKEND ASSIGNMENT

  1. Another name for INTERNET is ……
    1. NET  (b) Network (c) global village   (d) LAN
  2. The INTERNET has turned the whole world into a ……
    1. Computer  (b) Network (c) global village  (d) town
  3. ……. is the fastest and the most reliable means of data and information transfer  
    1. www  (b) e-mail (c) Internet   (d) protocol
  4. E-mail simply means ………………..
    1. Internet  (b) electronic mail (c) International network  (d) electronic means
  5. A website is a collection of …………………..
    1. web pages  (b) e-mail addresses  (c) network   (d) computers

     

THEORY

  1. What is the World Wide Web?
  2. Give an example of e-mail address

 

 

 

 

 

 

 

 

 

 

 

WEEK TWO

TOPIC: USES OF SEARCH ENGINE

search engine is a software program or script available through the Internet that searches documents and files for keywords and returns the results of any files containing those keywords.

A search engine is a site on the WWW that allows you to search for other websites. It is more powerful than a web directory. It will search the web or the basis of the keyword that you give.

There are thousands of different search engines available on the Internet, each with their own abilities and features. The first search engine ever developed is considered Archie, which was used to search for FTP files and the first text-based search engine is considered Veronica.

Today, the most popular and well-known search engine is Google. Other popular search engines include AOLAsk.com, Baidu, Bing and Yahoo.

A search engine has a huge database of internet resources such as web pages, newsgroups, programs, images etc. The major function of a search engine is that it helps to locate information on World Wide Web.

 

EVALUATION

  1. What is a search engine?
  2. List TWO examples of search Engine.

Image From EcoleBooks.com

THE MOST POPULAR SEARCH ENGINE IS GOOGLE.COM

  • Search Engine Components

Generally there are three basic components of a search engine as listed below:

  1. Web Crawler
  2. Database
  3. Search Interfaces

     

  1. Web crawler

It is also known as spider or bots. It is a software component that traverses the web to gather information.

  1. Database

All the information on the web is stored in database. It consists of huge web resources.

  1. Search Interfaces

This component is an interface between user and the database. It helps the user to search through the database.

 

EXAMPLE OF SEARCH ENGINES

Search Engine 

Description 

Google 

It was originally called BackRub. It is the most popular search engine globally.

Bing 

It was launched in 2009 by Microsoft. It is the latest web-based search engine that also delivers Yahoo’s results.

Ask 

It was launched in 1996 and was originally known as Ask Jeeves. It includes support for match, dictionary, and conversation question.

AltaVista 

It was launched by Digital Equipment Corporation in 1995. Since 2003, it is powered by Yahoo technology.

AOL.Search 

It is powered by Google. 

LYCOS 

It is the top 5 internet portal and 13th largest online property according to Media Matrix.

Alexa 

It is a subsidiary of Amazon and used for providing website traffic information.

 

USES OF SEARCH ENGINES

Search engines can be used to:

  • To carry out research.
  • To search information about peoples, places and products.
  • Get definition of words, acronyms, etc.
  • Download applications from the internet.
  • To lookup other websites.

 

GENERAL EVALUATION

  1. List the search engine components.
  2. State THREE uses of search engines.
  3. Write briefly on Google and Bing
  4. What is web crawler?

READING ASSIGNMENT

Simple guide to computer page 6

 

WEEKEND ASSIGNMENT

  1. A program through the Internet that searches documents and files for keywords and returns the results of any files containing those keyword is called…………. A. web Crawler B. search engine C. websites D. internet
  2. The following are components of search engine except……A. web crawler B. search interface C. database D. website.
  3. Which of these search engines was launched in 2009 by Microsoft A. Bing B. Google C. AOL D. LYCOS
  4. ………………. It is top 5 internet portal and 13th largest online property according to Media Matrix. A. Bing B. Google C. AOL D. LYCOS
  5. ……………….. is also known as spider or bots. A. web crawler. B. Search interface C. Search engine D. Database.

     

THEORY

  1. List and explain TWO examples of search engines.
  2. What is search engine?

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    WEEK THREE

TOPIC: DIGITAL DIVIDE I.

Digital Divide is used to describe the division of the world into two different groups. i.e. those that have access to the internet and those who do not have access to the internet. In other words, it is the unequal access by some members of the society to information and communication technology. The term global digital divide refers to differences in technology development and access between countries or continents.

 

In the technology revolution, Digital divide is basically the disparity between those that have access to technology tools and those who don’t.

 

THOSE THAT HAVE ACCESS  

  • Educated people.
  • People living in urban areas or cities.
  • More industrially developed countries.
  • People with high income.
  • People with good skills, knowledge and ability to use the internet.

 

THOSE THAT DO NOT HAVE ACCESS

  • Uneducated people
  • People living in rural areas or villages.
  • Less industrially developed countries.
  • People with low income
  • People that lack skill, knowledge and ability to use the internet.

 

FACTORS AFFECTING DIGITAL DIVIDE

The major factors affecting digital divide are listed below:

  1. Economy factor
  2. Geographical factor
  3. Fear of technology
  4. Social factor
  5. Lack of motivation

 

EVALUATION

  1. What is Digital Divide?
  2. List the factor affecting digital divide.

 

GENERAL EVALUATION

  1. What do you understand by the term “Digital Divide”?
  2. Mention TWO groups of people who have access to digital technology and those who do not.
  3. Explain economic factor.
  4. How does lack of motivation affect digital divide?

 

READING ASSIGNMENT

A handbook on computer studies page 1

 

WEEKEND ASSIGNMENT

  1. ………………. is a term that describes the disparity between users and non-users of information technologies. A. Digit divide B. Literacy C. Digital divide D. None.
  2. Which of these options describes digital divide? A. combination of those that uses ICT and that who do not B. educated and uneducated computer operator C. gap between computer literate and computer illiterate. D. all
  3. Low income earners do not benefit from digital divide because A. they are illiterate B. high cost of technology devices. C. they are not interested in ICT D. none
  4. Which of these factors describe hindrance of the network because of forest? A. society factor B. geographical factor C. economic factor D lack of Motivation.
  5. One of the following is not a factor affecting digital divide. ? A. eagerness factor B. geographical factor C. economic factor D lack of motivation.

     

THEORY

  1. What is digital divide?
  2. Mention two features of old economy.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

WEEK FOUR

TOPIC: DIGITAL DIVIDE II.

 

OLD ECONOMY

Old economy is the economy system mainly based on subsistence farming. It involves trade by barter. It is associated with the under-developed or developing countries of the world.

 

FEATURES OF OLD ECONOMY

  1. Its processes were time consuming.
  2. It required a lot of labour.
  3. It was mechanically driven.
  4. Scarcity of labour and low manpower development.
  5. Intense labour based production.
  6. It was constrained by space, time and distance

 

EVALUATION

  1. List THREE factors that affect digital divide.
  2. Explain economic factor.

 

NEW ECONOMY

The new economy was an evolution of developed countries from an industrialized/manufacturing based wealth creation economy to the service sector based economy. As a new economy is emerging, the old economy is fading out gradually.

 

FEATURES OF NEW ECONOMY

  1. It is a digital economy.
  2. It is not constrained by time, space and distance.
  3. It is technologically driven.
  4. It is a global economy.

 

BENEFITS OF NEW ECONOMY

  1. Globalization: new economy has turned the whole world into global village.
  2. Electronic commerce: E-commerce is the act of buying and selling over the internet facilitated by immediate payment via credit cards.
  3. Digital Economy: the new economy involves the use of information and communication technology (ICT) with the use of computers and telecommunication equipment for information processing.
  4. Job opportunities: New economy emphasizes more on what you know, what you have to offer and what you are prepared to do.

 

COMPARISON OF THE OLD ECONOMY AND NEW ECONOMY

Old Economy

New Economy

  1. Cost of business was high.

Cost is cheaper.

  1. It was a manual processing era.

Automated processing era.

  1. It was mechanically driven.

It is technology driven.

  1. The processing speed was slow.

It is fast in processing.

  1. It required a lot of labour.

It requires a few labour force.

 

GENERAL EVALUATION

  1. Differentiate between New economy and Old economy
  2. List and explain TWO features of new economy.
  3. How is new economy driven by technology?
  4. Explain the term Globalization.

 

READING ASSIGNMENT: A HANDBOOK ON COMPUTER STUDIES PAGE 4-6

 

WEEKEND ASSIGNMENT

  1. Which of the economy is mechanically driven? A. new economy B. digital economy C. old economy D. none
  2. Old economy is constrained by time because of………A. lack of enough manpower B. time is too short C. it is mechanically driven D. none
  3. Which of the options describe new economy? A. industrial Age B. machine age. C. technology driven age D. electrical driven age
  4. Which of the economy is driven by technology? A. old economy B. ancient economy C. new economy D. A and B.
  5. Which of the economy uses more of manpower? A. old economy B. ancient economy C. new economy D. A and B.

 

THEORY

  1. Differentiate between old economy and new economy.
  2. State two features of both economy.

WEEK FIVE

TOPIC: DIGITAL LITERACY I.

 

The term digital describes electronic technology that generates stores and processes data in terms of two states which is either positive or negative, 0 or 1.

However, literacy is the ability to read and write or the ability to use language to read, write, listen and speak.

 

Digital literacy is a term that refers to someone’s ability to understand, organize, locate, analyze, and evaluate information by using digital forms of technology. It includes writing papers, creating multimedia presentations, and posting information about yourself or others. It is also the awareness, attitude and ability of individuals to appropriately use digital tools and facilities to identify access, manage, integrate, evaluate, analyze and synthesize digital resources.

 

DEFINITION: Digital literacy is the ability to use information and communication technologies to find, evaluate, create and communicate information.

It involves the use of digital devices such as smartphones, tablets, laptops and desktop PCs for the purpose of communication, expression, collaboration and advocacy.

It was initially focused on digital skills and use of computer but has been shifted to using of network devices including internet and social media.

 

EVALUATION

  1. Define digital literacy.
  2. Differentiate between digital literacy and digital illiteracy.

 

However, digital literacy is distinct from computer literacy and digital skills.

  • Computer literacy refers to knowledge and skills in using computers such as desktop PCs and laptops. It focuses on practical skills in using software application packages.
  • Digital skills are limited to practical abilities in using digital divides such as laptops and smartphones.
  • Digital literacy is the combination of the two terms computer literacy and digital literacy.

 

CHARACTERISTICS OF DIGITAL LITERACY

  1. Ability to use digital tools to identify, manage and access, evaluate, integrate and analyze digital resources.
  2. Ability to use information responsibly.
  3. Development of analytical skills, critical thinking skills, writing and communication skills.
  4. Digital literacy provides the technical fluency skills needed to engage with computers and the internet.

 

GENERAL EVALUATION

  1. Differentiate between digital literacy and computer literacy.
  2. List TWO characteristics of digital literacy.
  3. Define digital literacy.
  4. Who are digital literates?

 

READING ASSIGNMENT: A HANDBOOK ON COMPUTER STUDIES PAGE 8

 

WEEKEND ASSIGNMENT

  1. …………… describes the knowledge and skills in using computers such as desktop PCs and laptops. A. Digital literacy B. Computer Literacy C. Digital skills D. Digital divide
  2. ……………….. literacy is the ability to use information and communication technologies to find, evaluate, create and communicate information. . A. Digital literacy B. Computer Literacy C. Digital skills D. Digital divide
  3. One of these options is a characteristic of digital literacy. A. development of analytical skills. B. increasing social life C. meeting new people D. none
  4. One’s ability to understand, organize, locate, analyze, and evaluate information by using digital forms of technology. A. Digital divide B. digital literacy C. digital skills D. None
  5. …………….is limited to practical abilities in using digital devices such as laptops and smartphones. A. Digital skill B. Digital literacy C. Digital divide D. None

 

THEORY

  1. Define digital literacy.
  2. Mention THREE characteristics of digital literacy.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

WEEK SIX

TOPIC: DIGITAL LITERCAY II.

 

USES OF DIGITAL LITERACY

  • In Education: digital literacy is more than having the knowledge of how to use a computer, what your software program does or the function of the hardware but also about using that knowledge to actually facilitate the learning process. Educators are often required to be certified in digital literacy to teach certain software, and more prevalently to prevent plagiarism among students.

     

  • In Society: it helps to communicate and keep up with societal trends. Literacy in social network services and web sites help people stay in contact with others, pass timely information and even sell goods and services.

     

  • In Workforce: those who are digitally literate are more likely to be economically secure. Many jobs require a working knowledge of computers and internet to perform basic functions.

 

  • Digital composition: is a new type of composition that focuses on technology’s impact in writing environment. The goal of digital composition is that it increases the ability to produce a relevant, high quality product instead of just paper work.

 

  • Social Media: Digital literacy allows a digital literate to have major voices online through different social media platforms.

     

EVALUATION

  1. Explain digital composition.
  2. What do you understand by digital literacy?

 

BENEFITS OF DIGITAL LITERCAY

  1. It has led to great increases in information that can be quickly accessed.
  2. Digital competence helps the citizenry find new opportunities for a better life.
  3. It saves time and money by paying bills, applying for jobs and all online transactions.
  4. Digitally literate computer owners are far more likely to incorporate the internet into their daily lives.

     

GENERAL EVALUATION

  1. List THREE uses of digital literacy.
  2. Differentiate between digital literacy and computer literacy.
  3. What is digital composition?
  4. How does digital literacy affect social media?

 

READING ASSIGNMENT: A HANDBOOK ON COMPUTER STUDIES PAGE 8

 

 

WEEKEND ASSIGNMENT

  1. Which of the options increases the ability to produce a relevant, high quality product instead of just paper work? A. Social media B. Digital divide C. digital composition D. All
  2. ……………..helps people to communicate and keep up with societal trends. A. Social media B. Digital literacy C. digital composition D. All
  3. Digital literacy allows people to improve……….A. get job B. their knowledge C. friendship relationship. D. none
  4. …………..helps to increase in formation acquisition. A. Social media B. Digital divide C. Digital literacy D. All
  5. One’s ability to understand, organize, locate, analyze, and evaluate information by using digital forms of technology is. A. digital divide B. digital literacy C. digital skills D. None

     

THEORY

  1. List and explain TWO uses of digital literacy.
  2. Mention TWO benefits of digital literacy.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

WEEK SEVEN

TOPIC:
DATABASE

 

Database is an application that is used to store information in a structured way. It is a collection of records or data in an organized form.

 

A database is an organized collection of related information that allows the storage of different types of record with appropriate interconnections.

 

Databases are designed to offer an organized mechanism for storing, managing and retrieving information. Database operates through the use of tables.

 

CONCEPT OF DATABASE

The idea of database came as a result of how people keep files in an office cabinet. In the ancient time, there were no computers and most fillings and storing were done manually. This allows redundancy of data and time wastage.

 

Advantages of Database

  1. It enables file or document sharing
  2. It allows consistency of data.
  3. It saves time.
  4. No data redundancy.
  5. It allows full file access.

 

Disadvantages of Database

  1. It is expensive to maintain.
  2. It requires experienced database administrator.
  3. It requires sophisticated software.

 

EVALUATION

  1. What is database?
  2. Mention TWO advantages and TWO disadvantages of database.

 

DATA BASE TERMINOLOGIES

  • Table: a table is the basic unit of a database. It is a collection of related data about a specific subject. The table is divided into rows and columns.
  • Field: this is an area reserved for each piece of individual data, such as student ID, No etc.
  • Record: A record is a group of related fields pertaining to one person, place or thing. Databases consist of records and each record represents one item in a database.
  • Key field: A key field or primary key is a field that uniquely identifies each record in a file. The data in a key field is unique to a specific record.
  • File: is a collection of related records. If you work with a computer, you are already working with files.

 

 

SUMMARY

  • Database is a collection of inter related files or tables.
  • File: is a collection of related records.
  • Record: is a collection of related fields.
  • Field: is the smallest unit of data about a person, thing, place, etc.

 

GENERAL EVALUATION

  1. List and explain TWO database terminologies.
  2. Explain database concept.
  3. What is file?
  4. List and explain two database terminologies.

 

READING ASSIGNMENT: SIMPLE GUIDE TO COMPUTER PAGE 23

 

WEEKEND ASSIGNMENT

  1. ……………..is a group of related fields pertaining to one person or thing. A. Record B. Database B. File C. Key D. Table
  2. The basic unit of database is ……………………. A. record B. database B. file C. key D. table
  3. An application that is used to store information in a structured way is called…………. A. record B. database B. file C. key D. table
  4. Database allows……………….A. storage of large information B. allows redundant data C. none D. all
  5. Which of the term does not relate to database? A. key B. record C. file D. none

 

THEORY

  1. What is a table in database?
  2. Differentiate between row and column.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

WEEK EIGHT

TOPIC: FORMS OF DATABASE.

 

There are various forms or ways by which database can be set up. They include:

  1. Flat file database
  2. Relational database
  3. Hierarchical database
  4. Network database
  5. Operational database
  6. Distributed database
  7. End user database

 

  1. FLAT FILE DATABASE

This is the traditional data file storage system ideal for storing small amounts of data that needs to be humanly readable or edited by hand. They are called flat because they contain only one table. The disadvantage is that flat files can be corrupted easily.

 

  1. RELATIONAL DATABASE

This is the most common of all the different types of database, files are organized in tables called relations. Each table has a key filed which is used to connect to other tables. Hence the tables are connected through several key fields.

 

  1. HIERARCHICAL DATABASE

This form of database has a tree-like structure. In this database, a single table acts as the root of the database from which other tables are connected. All windows operating system operate tree like database.

 

EVALUATION

  1. Mention the forms of database.
  2. Explain relational database

     

  3. NETWORK DATABASE

This database was designed to solve some of the more serious problems with hierarchical database model. Visually network database looks like hierarchical database.

 

  1. DISTRIBUTED DATABASE

This form of database is stored on different location connected by client/server network. Data that is been stored are transmitted through network. Each work group may have their own database and are connected through network.

 

EXAMPLES OF DATABASE

  1. Microsoft Access
  2. Microsoft SQL server
  3. Sybase
  4. FoxBASE
  5. Oracle

 

GENERAL EVALUATION

  1. Write short notes on distributed database and flat file database
  2. What is database?
  3. What is relational database?
  4. What differentiate relational database other forms of database?

 

READING ASSIGNMENT: SIMPLE GUIDE TO COMPUTER PAGE 27

 

WEEKEND ASSIGNMENT

  1. Which of the database connects several tables? A. network database B. flat file database C. relational database D distributed database
  2. Which of the databases is like tree structure? A. network database B. flat file database C. relational database D. distributed database
  3. One of these applications is not a database application. A. oracle B. foxBASE C. spreadsheet D. MS Access
  4. Which of the databases was designed to solve more problem? A. network database B. flat file database C. relational database D. distributed database
  5. All but one is not among the types of database. A. network database B. flat file database C. digital database D. distributed database

 

THEORY

  1. Why is relational database mostly used?
  2. Explain network database

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

WEEK NINE

TOPIC: SPREADSHEET I.

 

Spreadsheets are like lined paper with columns. The sheet itself comprises of columns (vertical) and rows (horizontal) which are in turn, made up of cells. A spreadsheet is the computer equivalent of a paper ledger sheet.

 

Spreadsheet can be defined as the combination of rows and columns used in performing arithmetic calculations. It was first constructed in 1979 and has developed into one of the most widely used software products during the 1980s. It is widely used in a diverse range of discipline such as mathematics, engineering, science, medicine, the arts, social science, accounting and education.

Image From EcoleBooks.com

SPREAD SHEET

 

SPREADSHEET PACKAGE

Electronic spreadsheet is an application package used mostly in accounting, statistics, financial and inventory control.

Spreadsheet package is a software that allows the use of numerical data and thereby performing automatic calculations on numbers contained in a table. Spreadsheet packages are used to handle accounting problems, financial analysis, budgeting, charting and graphing, scientific applications, inventory, statistical data, etc.

 In a spreadsheet, as you enter the numbers, the computer puts them on to the screen in neat columns. You can tell the program to compute the totals, subtotals, percentages and show them on the screen faster than your eye can blink.

TYPES OF SPREADSHEET

  1. Lotus 1-2-3
  2. Supercal
  3. Visicalc
  4. Microsoft Excel
  5. Corel Quattro.
  6. StatView

 

EVALUATION

  1. What are spreadsheets?
  2. Mention THREE types of spreadsheet applications.

 

Microsoft Excel is preferable to the other earlier packages because:

  • It is user friendly.
  • It is flexible.
  • It contains advanced features.

 

USES OF SPREADSHEET

  1. Spreadsheet is used for calculations of large figures
  2. They are used to enter text, numerical values and formulas into electronic worksheet.
  3. We use spreadsheets to view data in various formats (pie charts, line graphs and bar graphs).
  4. They can be used for collection and records analysis.
  5. They are used in preparing budget.
  6. They are used for preparing examination results.

 

GENERAL EVALUATION

  1. List THREE uses of spreadsheet applications.
  2. Why is Ms excel more preferable than other spreadsheet programs.
  3. List various spreadsheet formats.
  4. Apart from Microsoft excel, list TWO other types.

 

READING ASSIGNMENT: SIMPLE GUIDE TO COMPUTER PAGE 45

 

WEEKEND ASSIGNMENT

  1. Which of these programs can calculate large numbers? A. Ms word B. Ms access B. spreadsheet programs. D. all
  2. Analysis is made with which of these applications. A. Ms word B. Ms access B. spreadsheet programs. D. all
  3. All except one is not an example of spreadsheet programs. A. Lotus 1-2-3 B. Supercal C. Visicalc D. Ms Word.
  4. …………….contains rows and columns. A. Spreadsheet B. Workbook C. Ms word. D. All
  5. Preparing examination results can easily be computed with………… A. spreadsheet B. workbook C. Ms word. D. all

 

THEORY

  1. Define spreadsheet program
  2. List THREE spreadsheet program

 

 

 

 

 

 

 

 

 

 

 

 

 

WEEK TEN

TOPIC: SPREADSHEET II.

 

SPREADSHET TERMINOLOGIES

  1. A cell is a space in a worksheet formed by the intersection of a row and a column.

Image From EcoleBooks.com

 

An active cell is the cell that is currently worked upon. E.g cell G7 is the active cell the above diagram.

 

  1. ROW: is defined as the horizontal space that is going across the window. Numbers are used to designate each ROW’s location.

Image From EcoleBooks.com

 

  1. COLUMN: is defined as the vertical space that is going up and down the window. Letters are used to designate each COLUMN’s location.

Image From EcoleBooks.com

 

  1. FORMULAS: formulas allow the spreadsheet users to do calculations with figures. The inclusion of formula has made the application unique. Formulas are group of characters we enter that serve as instruction for the spreadsheet package to perform calculations on the data is a spreadsheet.

    Example, C4= A4+F5 would calculate and display the sum of cell A4 and cell F5 into cell C4.

 

  1. RANGES: spreadsheet packages have another important feature called ranges. A range is simply a block cells. Formulas can act on a single cell or be directed to act on a range of cells. For example A4:E4 includes the cell A4, B4, C4, D4 and E4. Any calculation performed in A4 will also be performed in others cells.

 

  1. FUNCTIONS: functions are actually used as shortcuts when performing mathematical calculations. They are pre-programmed formula that give power and flexibility to spreadsheet calculations. Example AVERAGE, SUM, MAX, MIN etc.

 

EVALUATION

  1. List THREE terminologies and explain briefly.
  2. What is cell?

 

LOADING SPREADSHEET PPACKAGES

MICROSOFT EXCEL PACKAGE.

 

Starting Worksheet (Using Microsoft Excel)

Loading is the act of opening a program in order to use it. So to load Microsoft Excel, we follow these steps

  • Click Start button
  • Click All Programs
  • Click Microsoft Office
  • Click Microsoft Office Excel

 

GENERAL EVALUATION

  1. Highlight the procedures for loading Microsoft Excel program
  2. What do you understand by an active cell?
  3. What is row in database?
  4. What is the relationship between row and column?

 

READING ASSIGNMENT A HANDBOOK ON COMPUTER STUDIES PAGE 36

 

WEEKEND ASSIGNMENT

  1. …………….. is simply a block cells. A. Formula B. Range C. Function D. None
  2. ……………… are actually used as shortcuts when performing mathematical calculations. A. Formula B. Range C. Function D. None
  3. …………… allows the spreadsheet users to do calculations with figures. . A. Formula B. Range C. Function D. None
  4. All except one is not an example of spreadsheet programs. A. Lotus 1-2-3 B. Supercal C. Visicalc D. Ms Word.
  5. Analysis is made with which of these applications. A. MS Word B. Ms access B. spreadsheet programs. D. All

 

THEORY

  1. Highlight the procedures for loading Microsoft Excel program
  2. What is a cell?



Share this:


subscriber

Leave a Reply

Your email address will not be published. Required fields are marked *

Accept Our Privacy Terms.*