{"id":2527,"date":"2023-10-03T09:02:13","date_gmt":"2023-10-03T09:02:13","guid":{"rendered":"http:\/\/localhost\/ecole9ja\/?p=2527"},"modified":"2023-10-03T09:08:20","modified_gmt":"2023-10-03T09:08:20","slug":"week-4-ss1-third-term-data-processing-notes","status":"publish","type":"post","link":"https:\/\/ecolebooks.com\/nigeria\/posts\/week-4-ss1-third-term-data-processing-notes\/","title":{"rendered":"Week 4 &#8211; SS1 Third Term Data Processing Notes"},"content":{"rendered":"<p>\u00a0<br \/>\n\u00a0<strong>WEEK FOUR<br \/>\n<\/strong><strong>TOPIC:SPREADSHEET I<br \/>\n<\/strong><strong>DEFINITION OF SPREADSHEET: <\/strong>A spreadsheet is a collection of cells organized into rows and columns where data is stored and manipulated. The spreadsheet is known as worksheet. A <em>spreadsheet<\/em> begins with row number one and column A. <strong>A cell<\/strong> is a space in a worksheet formed by the intersection of a row and a column. Each cell can contain a number, text or formula. A cell can also reference another cell in the same <em>worksheet<\/em>, the same <em>workbook<\/em> or a different <em>workbook<\/em>. Each cell has an address called <strong>Cell Reference<\/strong>e.g. A1, B3, C7 etc. combination of more than one sheet is referred to as workbook. The worksheets can accept thousands of rows of data and columns in form of fields.<strong>Active Cell<\/strong> is recognized by heavy border surrounding. It is the cell that is currently worked upon.<\/p>\n<p>\u00a0<img decoding=\"async\" src=\"https:\/\/ecolebooks.com\/nigeria\/wp-content\/uploads\/9jalessonsimages\/100323_0902_Week4SS1Th1.png\" alt=\"\"\/><br \/>\n\t\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0A SPREADSHEET<\/p>\n<p>\u00a0<strong>CONTENT OF SPREADSHEET<br \/>\n<\/strong>When you are setting out a spreadsheet, you have to enter values, labels and formulas.<\/p>\n<ul>\n<li>VALUES: Values are those numbers you already know before starting the spreadsheet operation. These values are inserted into cells of the spreadsheet.\n<\/li>\n<li>LABELS: Labels are words you enter to explain the values. You would not just enter a list of numbers without explanation. Putting labels next to each of the numbers makes it easier for to check it through.\n<\/li>\n<li>FORMULA: Formulas are the mathematical equations you insert into the cells. Formulas are commands that instruct the computer on what to do.\n<\/li>\n<\/ul>\n<p>\u00a0<strong>EVALUATION<br \/>\n<\/strong><\/p>\n<ol>\n<li>Define a worksheet.\n<\/li>\n<li>What do you understand by cell reference?\n<\/li>\n<\/ol>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n<p>\u00a0<br \/>\n\u00a0<strong>USES OF SPREADSHEET<br \/>\n<\/strong>There are various uses of spreadsheet. It uses varies according to the intended purpose. Some of its uses are as follows:<\/p>\n<ol>\n<li>Spreadsheets are used for administrative functions.\n<\/li>\n<li>Spreadsheets are used for creating reports.\n<\/li>\n<li>They are used for preparation of daily sales.\n<\/li>\n<li>They are used in computing school results.\n<\/li>\n<li>They are used for project budgeting control.\n<\/li>\n<li>They are used for drawing balance sheets.\n<\/li>\n<li>Excel can store and calculate the data as directed using existing data.\n<\/li>\n<li>Spreadsheet can be used for analysis and decision making.\n<\/li>\n<li>\n<div>It makes calculations much easier than working things out yourself.\n<\/div>\n<p>\u00a0<\/li>\n<\/ol>\n<p><strong>GENERAL EVALUATION<br \/>\n<\/strong><\/p>\n<ol>\n<li>State the uses of spreadsheet.\n\t\t\t\t<\/li>\n<li>Excel can be used to create analysis, Explain.\n<\/li>\n<li>What is an active cell?\n<\/li>\n<li>What are the contents in spreadsheet?\n<\/li>\n<\/ol>\n<p>\u00a0<strong>READING ASSIGNMENT<\/strong>: Modern Computer studies by Victoria, page 25<br \/>\n\t\t\t<strong>WEEKEND ASSIGNMENT<br \/>\n<\/strong><\/p>\n<ol>\n<li>\n<div>A cell can also reference another cell in the same\u2026\u2026..A. <em>worksheet B. workbook <\/em>\n\t\t\t\t<\/div>\n<p><em>C. cellular D. sheet<\/em>\n\t\t\t\t<\/li>\n<li>\n<div>Spreadsheet can be used for data analysis and\u2026\u2026\u2026\u2026making A. cell B. decision\n<\/div>\n<p>C. data D. reference\n<\/li>\n<li>The\u2026\u2026\u2026\u2026.. can contain thousands of rows of data and columns in form of fields. A. cell B. worksheet C. reference cell D. excel\n<\/li>\n<li>The cell that is been currently worked upon is known as \u2026\u2026\u2026\u2026\u2026cell. A. current B. active C. reference D. initial\n<\/li>\n<li>\n<div>A \u2026\u2026\u2026.. can also reference another cell in the same <em>worksheet. A. cell B. sheet <\/em>\n\t\t\t\t<\/div>\n<p><em>C. worksheet D. none<\/em>\n\t\t\t\t<\/li>\n<\/ol>\n<p>\u00a0<strong>THEORY<br \/>\n<\/strong><\/p>\n<ol>\n<li>Define an active cell.<strong><br \/>\n\t\t\t\t\t<\/strong><\/li>\n<li>List and explain the THREE major contents in a spreadsheet.<strong><br \/>\n\t\t\t\t\t<\/strong><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 \u00a0WEEK FOUR TOPIC:SPREADSHEET I DEFINITION OF SPREADSHEET: A spreadsheet is a collection of cells&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,212],"tags":[],"class_list":["post-2527","post","type-post","status-publish","format-standard","hentry","category-posts","category-third-term-ss1-data-processing"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/posts\/2527","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/comments?post=2527"}],"version-history":[{"count":1,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/posts\/2527\/revisions"}],"predecessor-version":[{"id":2528,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/posts\/2527\/revisions\/2528"}],"wp:attachment":[{"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/media?parent=2527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/categories?post=2527"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/tags?post=2527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}