{"id":2531,"date":"2023-10-03T09:03:30","date_gmt":"2023-10-03T09:03:30","guid":{"rendered":"http:\/\/localhost\/ecole9ja\/?p=2531"},"modified":"2023-10-03T09:08:20","modified_gmt":"2023-10-03T09:08:20","slug":"week-6-ss1-third-term-data-processing-notes","status":"publish","type":"post","link":"https:\/\/ecolebooks.com\/nigeria\/posts\/week-6-ss1-third-term-data-processing-notes\/","title":{"rendered":"Week 6 &#8211; SS1 Third Term Data Processing Notes"},"content":{"rendered":"<p>\u00a0<strong>WEEK SIX<br \/>\n<\/strong><strong>TOPIC:SPREASHEET III<br \/>\n<\/strong><strong>LOADING EXCEL APPLICATION<br \/>\n<\/strong>Click on all programs, check the programs and click on the Microsoft suites then click on the excel application.<\/p>\n<p>\u00a0<strong>CREATING EXCEL DOCUMENT<br \/>\n<\/strong>Once Excel is open, you can enter data into a file by clicking on a particular cell, then typing<br \/>\ntext, numbers, or formulas. Your changes will be entered into the current cell.<\/p>\n<ul>\n<li>\n<div>Press the tab to enter your data and move the active cell to the right of the current one.\n<\/div>\n<\/li>\n<li>\n<div>Press enter key to enter your data and move the active cell to the next row, usually to the beginning of that row.\n<\/div>\n<\/li>\n<li>\n<div>Use the arrow keys to enter your data and move the active cell in the indicated direction.\n<\/div>\n<\/li>\n<li>\n<div>Press the end key, right-arrow key to move to the last cell in a row.\n<\/div>\n<\/li>\n<\/ul>\n<p>\u00a0<br \/>\n\u00a0<strong>ENTERING DATA IN A WORKSHEET<br \/>\n<\/strong>Locate the cell where you want to enter data on the worksheet and click on the cell. For example point and click on cell A1.<br \/>\n<img decoding=\"async\" align=\"left\" src=\"https:\/\/ecolebooks.com\/nigeria\/wp-content\/uploads\/9jalessonsimages\/100323_0903_Week6SS1Th1.png\" alt=\"\"\/><\/p>\n<p>\u00a0<br \/>\n\u00a0<br \/>\n\u00a0<br \/>\n\u00a0<br \/>\n\u00a0<br \/>\n\u00a0<br \/>\n\u00a0<br \/>\n\u00a0<br \/>\n\u00a0<br \/>\n\u00a0<br \/>\n\u00a0<br \/>\n\u00a0<br \/>\n\u00a0Type in your entry from the keyboard and notice the appearance of the entries in the formula bar with the cell address.<br \/>\nPress &#8216;Enter&#8217; key.<\/p>\n<p>\u00a0<strong>EVALUATION<br \/>\n<\/strong><\/p>\n<ol>\n<li>What are the steps involved in creating a Spreadsheet?\n<\/li>\n<li>Explain how to enter data into Excel.\n<\/li>\n<\/ol>\n<p>\u00a0<strong>EDITING DATA IN A WORKSHEET<br \/>\n<\/strong>Wrong entries may either be entirely re-typed or the particular cell\/range of cells can be corrected. <\/p>\n<p>\u00a0<strong>To retype<\/strong>:<br \/>\nMove the cell pointer to the cell to be corrected or re-type the entry and press &#8216;Enter&#8217;<br \/>\nTo correct only the mistake:<br \/>\nMove the cell pointer to the cell and double click on the cell.<br \/>\nMake the correction by inserting, deleting or retyping.<br \/>\nPress &#8216;Enter&#8217;.<\/p>\n<p>\u00a0<strong>SAVING A WORKSHEET<br \/>\n<\/strong>Saving for the first time:<br \/>\nClick on &#8216;Home&#8217; button,<br \/>\nClick &#8216;Save As&#8217; button and wait for a dialog box to open.<br \/>\nType in your desire filename (i.e. the name of the document).<br \/>\nClick &#8216;Save&#8217; button or press enter on the keyboard.<br \/>\nSaving while working (after the first saving).<br \/>\nClick on &#8216;save&#8217; icon on the Quick Access tool bar or click on &#8216;office button&#8217; to open the menu.and click &#8216;save&#8217; from the options.<\/p>\n<p>\u00a0<strong>RETRIEVING A SAVED WORKSHEET<br \/>\n<\/strong>Retrieving a worksheet means to open an already saved worksheet from its location in the computer. This is usually done to view, edit or update the worksheet.<br \/>\nLoad\/start Microsoft Excel<br \/>\nClick on &#8216;Office Button&#8217;<br \/>\nClick &#8216;Open&#8217; option from the list and wait for a dialog box to open.<br \/>\nNavigate to the file you want to open and double click on it. <\/p>\n<p>\u00a0<strong>GENERAL EVALUATION<br \/>\n\t\t\t<\/strong><\/p>\n<ol>\n<li>Define a cell.\n<\/li>\n<li>State steps involved in saving a worksheet for the first time.\n<\/li>\n<li>Highlight the steps in retrieving a saved document.\n<\/li>\n<\/ol>\n<p>\u00a0<strong>READING ASSIGNMENT<\/strong><br \/>\n\t\tA Handbook on Computer Studies for Schools and Colleges by NiyiAdekolegan<\/p>\n<p>\u00a0<strong>WEEKEND ASSIGNMENT<br \/>\n<\/strong><\/p>\n<ol>\n<li>___ is a collection of cells organized into rows and columns where data is stored and manipulated.  A. Worksheet B. Graph C. Workbook D. Active cell\n<\/li>\n<li>\n<div>___ is a space in a worksheet formed by the intersection of a row and a column.\n<\/div>\n<p>A. Workbook B. Sheet C. Cell D. Cell Reference.\n<\/li>\n<li>\n<div>There are \u2026\u2026\u2026 rows per worksheet in Excel. A. 1,048,576 B. 1,048,765\n<\/div>\n<p>C. 1,408,576 D. 1,022,333\n<\/li>\n<li>\n<div>There are ___ columns per worksheet in Excel. A. 16,387 B. 16,384 C. 16,684\n<\/div>\n<p>D. 15,341\n<\/li>\n<li>\n<div>The address of a cell is known as ___ A. Cell space B. Cell reference C. Cell Menu\n<\/div>\n<p>D. Active cell\n<\/li>\n<\/ol>\n<p>\u00a0<strong>THEORY<br \/>\n<\/strong><\/p>\n<ol>\n<li>\n<div>Highlight the steps in saving a worksheet\n<\/div>\n<\/li>\n<li>\n<div>In Excel, what do you understand by the term &#8220;retrieving&#8221;?\n<\/div>\n<\/li>\n<\/ol>\n<p><strong><br \/>\n\t\t\t<\/strong>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0WEEK SIX TOPIC:SPREASHEET III LOADING EXCEL APPLICATION Click on all programs, check the programs and&#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-2531","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\/2531","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=2531"}],"version-history":[{"count":1,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/posts\/2531\/revisions"}],"predecessor-version":[{"id":2532,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/posts\/2531\/revisions\/2532"}],"wp:attachment":[{"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/media?parent=2531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/categories?post=2531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/tags?post=2531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}