{"id":2529,"date":"2023-10-03T09:02:49","date_gmt":"2023-10-03T09:02:49","guid":{"rendered":"http:\/\/localhost\/ecole9ja\/?p=2529"},"modified":"2023-10-03T09:08:20","modified_gmt":"2023-10-03T09:08:20","slug":"week-5-ss1-third-term-data-processing-notes","status":"publish","type":"post","link":"https:\/\/ecolebooks.com\/nigeria\/posts\/week-5-ss1-third-term-data-processing-notes\/","title":{"rendered":"Week 5 &#8211; SS1 Third Term Data Processing Notes"},"content":{"rendered":"<p>\u00a0<br \/>\n\u00a0<strong>WEEK FIVE<br \/>\n<\/strong><strong>TOPIC:SPREADSHEET II<br \/>\n<\/strong><strong>EXAMPLES OF SPREADSHEET<br \/>\n<\/strong>There are various types of spreadsheet software which include:<\/p>\n<ul>\n<li>Microsoft excel\n<\/li>\n<li>Lotus 1-2-3,\n<\/li>\n<li>Starview,\n<\/li>\n<li>Supercal etc.\n<\/li>\n<\/ul>\n<p>\u00a0<strong>MICROSOFT-EXCEL<br \/>\n<\/strong>Out of the many examples of spreadsheet packages, Microsoft excel is the most commonly used because of its friendly features. Microsoft excel is part of Microsoft suite. The suite comes in various version such as 2000, 2005, 2007,2010, 2015 etc.<\/p>\n<p>\u00a0Ms- Excel is primarily used for analysis and calculation due to its flexibility<strong>.<\/strong> It has a lot of calculating features and mathematical formulas. Various kinds of mathematical calculations can be done using MS excel. Microsoft Excel is a spreadsheet package used mainly for mathematical calculations and numerical analysis. Examples of calculations that can be performed using MS Excel include; addition, subtraction, multiplication, division, average, etc.<\/p>\n<p>\u00a0Formulas are often used to carry out calculations in Ms excel. The desired formula for any calculation must be preceded with an equal sign (=).<\/p>\n<p>\u00a0<strong>STARTING MS EXCEL<br \/>\n<\/strong>Starting Worksheet (Using Microsoft Excel)<br \/>\nClick Start button;<br \/>\nClick All Programs;<br \/>\nClick Microsoft Office;<br \/>\nClick Microsoft Office Excel.<\/p>\n<p>\u00a0<strong>EVALUATION<br \/>\n<\/strong><\/p>\n<ol>\n<li>Highlight the steps for starting Ms-Excel.\n<\/li>\n<li>\n<div>What are the types of calculations that can be performed in Ms-Excel?\n<\/div>\n<p>\u00a0<\/li>\n<\/ol>\n<p><strong>ARITHMETIC OPERATORS USED IN MS EXCEL<br \/>\n<\/strong>+  Addition\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8211;  Subtraction<br \/>\n\/   Division \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0* Multiplication\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0^  Exponential<br \/>\nWhen creating a formula, you must know MS Excel&#8217;s <strong>order of operations<\/strong>. Certain operations are performed before others. The term <strong>PEMDAS<\/strong> is the acronym to denote MS Excel&#8217;s order of operation.<br \/>\nP &#8212;&#8212;\u00a0\u00a0\u00a0\u00a0Parenthesis (Bracket)<br \/>\nE &#8212;&#8211;\u00a0\u00a0\u00a0\u00a0Exponential<br \/>\nM &#8212;&#8211;\u00a0\u00a0\u00a0\u00a0Multiplication<br \/>\nD &#8212;&#8211;\u00a0\u00a0\u00a0\u00a0Division<br \/>\nA &#8212;&#8211;\u00a0\u00a0\u00a0\u00a0Addition<br \/>\nS &#8212;&#8212;\u00a0\u00a0\u00a0\u00a0Subtraction\u00a0\u00a0\u00a0\u00a0<br \/>\nCalculations enclosed in parenthesis are performed first, followed by calculations involving exponentials. Multiplication and division operations are performed next because they are considered equal in importance. They are performed in the order in which they are encountered from left to right. Addition and subtraction are performed last in the order in which they are encountered from left to right.<\/p>\n<p>\u00a0<strong>Formulas in MS Excel<br \/>\n<\/strong><strong>Examples:<br \/>\n<\/strong>Addition\u00a0\u00a0\u00a0\u00a0=C3+D3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nSubtraction\u00a0\u00a0\u00a0\u00a0=C3-D3<br \/>\nDivision\u00a0\u00a0\u00a0\u00a0=C3\/D3  \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nMultiplication\u00a0\u00a0\u00a0\u00a0=C3*D3<br \/>\nAverage\u00a0\u00a0\u00a0\u00a0=AVERAGE(C4&#8230;C9)<\/p>\n<p>\u00a0<strong>GENERAL EVALUATION<br \/>\n<\/strong><\/p>\n<ol>\n<li>\n<div>In the right order, list the order of calculation operations in Excel.\n<\/div>\n<\/li>\n<li>\n<div>Apart from MS-Excel, list two other types of Spreadsheet packages.\n<\/div>\n<\/li>\n<li>\n<div>Write the full meaning of the acronyms PEMDAS.\n<\/div>\n<\/li>\n<li>\n<div>List two formulas in Ms-Excel.\n<\/div>\n<\/li>\n<\/ol>\n<p>\u00a0<strong>READING ASSIGNMENT<\/strong><br \/>\n\t\tModern Computer studies by Victoria. Page 52.<strong><br \/>\n\t\t\t\t<\/strong><br \/>\n\u00a0<strong>WEEKEND ASSIGNMENT<br \/>\n<\/strong><\/p>\n<ol>\n<li>The acronym that is used to denote MS Excel&#8217;s order of operation is ___ A. PEDDAS B. PEMDAS C. PEMMAS D. PEDDMA<strong><br \/>\n\t\t\t\t\t<\/strong><\/li>\n<li>___ is the formula for finding average in Ms-excel. A. C2\/D2. B. =AVERAGE (C4..C9) C. =C4:C9 D. AV (C4..C9)<strong><br \/>\n\t\t\t\t\t<\/strong><\/li>\n<li>Which of the Calculations are performed first in excel? A. Multiplication B. Addition     C. In parenthesis D. Division<strong><br \/>\n\t\t\t\t\t<\/strong><\/li>\n<li>\n<div>All these except one are example of spreadsheet packages. A. Lotus 1-2-3. <strong><br \/>\n\t\t\t\t\t\t<\/strong><\/div>\n<p>B. Supercal C. Corel sheet D. Ms Excel<strong><br \/>\n\t\t\t\t\t\t<\/strong><\/li>\n<li>&#8220;*&#8221; represents ___ A. addition B. exponential C. multiplication D. none<strong><br \/>\n\t\t\t\t\t<\/strong><\/li>\n<\/ol>\n<p>\u00a0<strong>THEORY<br \/>\n<\/strong><\/p>\n<ol>\n<li>State the steps to load Excel\n<\/li>\n<li>What does the acronym, PEMDAS stand for?\n<\/li>\n<\/ol>\n<p><strong><br \/>\n\t\t\t<\/strong>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 \u00a0WEEK FIVE TOPIC:SPREADSHEET II EXAMPLES OF SPREADSHEET There are various types of spreadsheet software&#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-2529","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\/2529","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=2529"}],"version-history":[{"count":1,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/posts\/2529\/revisions"}],"predecessor-version":[{"id":2530,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/posts\/2529\/revisions\/2530"}],"wp:attachment":[{"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/media?parent=2529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/categories?post=2529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/tags?post=2529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}