JSS 3 WEEK 9 - 10: SPREADSHEET (PRACTICALS)


SPREAD SHEET

A Spread sheet application is productivity software in which a computer user can manage personal and business finance with the help of a spread sheet program.
A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array is a model–view–controller element that may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.
Spreadsheet users may adjust any stored value and observe the effects on calculated values. This makes the spreadsheet useful for “what-if” analysis since many cases can be rapidly investigated without manual recalculation. Modern spreadsheet software can have multiple interacting sheets, and can display data either as text and numerals, or in graphical form.
Productivity software is a software that assists people to gain more efficiency and effectiveness while performing daily activities. You can use a spread sheet program to perform calculations, analyze data and present information.

EXAMPLE OF SPREAD SHEET

1.                   LOTUS 1-2-3: This is a spread sheet program from lotus software (now part of IBM) which has added integrated charting, plotting and database capabilities

2.                   STATVIEWS: This is a spread sheet program than can perform many analyses by template. It creates presentation quality graph and table with a singles of the mouse.

3.                   MICROSOFT EXCEL: This is powerful spread sheet that allows you to organize data complete calculate take decision, graph data and develop reports. It is also has basic features to help you create, edit and format worksheet.

GRAPH IN EXCEL

A graph is a great way of representing your data. With graph, data are easily understood and also they are easily edited for better data presentation. You can create dozens of different charts, from pie chart to bar chart and more.

DATA SENSE: This is the foundation of any chart in the worksheet that you use to create. Chart data is the content of a group of related cells, such as one row or column of data in your worksheet.

CUSTOMIZED CHARTS: Any chart created can be customized and can also change to the formatting of the chart, text, change the chart type and much more.


CHART TYPES
1.                   COLUMN
2.                   BAR
3.                   LINE GRAPH
4.                   PIE
5.                   SCATTER
6.                   AREA
7.                   DOUGHNUT E.T.C
 


WORK SHEET
Worksheet commonly refers to a sheet of paper with questions for students and places to record answers. The term may also refer to a single array of data in spreadsheet software or an informal piece of paper that an accountant uses to record information.
A worksheet or sheet is a single page in a file created with an electronic spreadsheet program such as Excel or Google Spreadsheets. A worksheet is used to store, manipulate, and display data. A worksheet is a collection of cells where you keep and manipulate the data. By default, each Excel workbook contains three worksheets.
Each worksheet is composed of a very large number cells – which are the basic storage unit for data in a file or workbook.
The cells are arranged in a grid pattern using rows and columns.
While a Workbook is the collection of several worksheets, so therefore it can be said that a Workbook comprises of multiple worksheets.

In Excel 2013:

  • There are 1,048,576 rows per worksheet;
  • There are 16,384 columns per worksheet;
  • By default, each new file contains only one worksheet;
  • The number of sheets per file is limited only by the amount of memory available on the computer.
* In earlier versions of Excel, the default number of worksheets per file was three.
For Google Spreadsheets:

·         There is a maximum of 256 columns per sheet;
·         The maximum number of cells for all worksheets in a file is 400,000;
·         The current default number of worksheets for new files is one;
·         There is a maximum of 200 worksheets per spreadsheet file.
Each worksheet also has a name. By default, the worksheets are named Sheet1, Sheet2, Sheet3 and so on.

Comments

Post a Comment

Popular posts from this blog

JSS 3 WEEK 4: INTERNET (SEARCH ENGINES)

Image
THE INTERNET Internet is a global wide area network that connects computer systems across the world. It also means international network. To connect to the internet, you must have access to an internet service provider (ISP), which acts the middleman between you (the user) and the internet. The internet can be defined as a global system of interconnected computer networks that use the standard internet protocol suite (TCP/IP) transmission control protocol/internet protocol to serve billions of users worldwide. It is a network of networks that consists of millions of private, public, academic, business and government networks. It is a platform for exchange of resources and services through the inter-linked hypertext documents of the worldwide web (www) and the infrastructure to support email. THE BASIC TERMS OF INTERNET The internet can be defined as a global system of interconnected computer networks that use the standard internet protocol suite (TCP/IP) transmission con...
Read more

JSS 3 WEEK 7 - 8: HUMAN ISSUE

Image
MEANING OF HUMAN ISSUES Human issues in ICT involve all human related duties, functions or responsibilities that are associated with the use of computer. Computer professionals are the individuals that have obtained sufficient education and training in the field of computers and earn livelihood from their chosen profession. COMPUTER PROFESSIONALS AND THEIR FUNCTIONS Computer Manager: He heads the ICT department, coordinates and ensures that IT need of organization is met in conformity with the policy. System Analyst: He examines the feasibility or potential computer application, design computer base system and recommend kind of program to be used in the organization. Computer Programmer: He encodes/writes the procedures detailed by the system analyst in the language suitable for a given computer. Writes computer programs Computer Educator: Computer educator trains people on how to use computer hardware and software and enlighten people on new computer policy...
Read more

JSS 3 - CHARTS AND GRAPHS

Image
CHART AND GRAPHS A graph is a representation of a set of objects where some pairs of the objects are connected by lines. Or graph is a diagram that shows relationship between numbers or figures. The quantities are usually measured along two axes( x and y). A graph is also called chart. While a chart is a graphical representation of data, in which "the data is represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a pie chart". A chart can represent tabular numeric data, functions or some kinds of qualitative structure and provides different info. Charts are often used to ease understanding of large quantities of data and the relationships between parts of the data. Charts can usually be read more quickly than the raw data. They are used in a wide variety of fields, and can be created by hand (often on graph paper) or by computer using a charting application. Certain types of charts are more useful for presenting a given data se...
Read more