Educational Blog - Ajiboye Gbenga @ Sunlite Digital ALBESTA ACADEMY LEKKI

  SPREADSHEET PACKAGE 1    DEFINITION, EXAMPLES, USES, FEATURES AND TERMINOLOGIES Definition of Spreadsheet 1. A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. It can also be used to analyzes, and charts numeric information. 2. Spreadsheet is a computer program or software which allows calculations to be carried out on several cells that have numbers Examples of Spreadsheet Packages 1. iWork Numbers – Apple Office Suite 2. Lotus 1-2-3 3. OpenOffice – Calc 4. Lotus Symphony – Spreadsheets 5. Microsoft Excel 6. VisiCalc 7.SeaTable 8. AirTable 9.SmartSheet 10. LibreOffice 11. Google Sheets 12. Quip 13. JotForm Table 14. Zoho 15.EtherCalc 16. Stackby Uses/Application Areas of Spreadsheet 1. Accounting. 2. Statistical calculations. 3. Preparation of student results. 4. Obtaining tax estimation 5. Preparation of daily sales FEATURES AND TERMINOLOGIES OF SPREADSHEET PACKAGE 1. Active Cell:  The active cell is the cell

 NUMBER BASE 1 Number Base System Binary, Decimal,Octal, Hexadecimal and Conversion of Number Base System Introduction Representation of data in the computer makes use of the number base system. When data and instruction is entered into the computer, the computer will convert it into machine readable language i.e binary digits 0’s and 1’s. The main number system used in digital hardware are: (i)                 Binary number system (base 2)  (ii)               Decimal/Denary number system (base 10)  (iii)             Octal number system (base 8)  (iv)             Hexadecimal number system (base 16) (i)                 Binary number system (base 2) : This is base 2 number and therefore requires only digits (0’s and 1’s or off and on)- For example 10011 2 , 100111 2 (ii)               Decimal/Denary number system (base 10) : This uses various symbols called digits for ten distinct values (0,1,2,3,4,5,6,7,8,9) to represent numbers. For example 29, 54, 140, 275, e.t.c (iii)             Oc

  MID TERM PROJECT MARK OBTAINABLE : 50 MARKS      CLASS : SSS2 1. Download and install Capcut Video editing software on your computer 2. Research online on how to use Capcut video editing software 3. Create amazing Birthday video for yourself/ your parents (Dad/Mum) using Capcut 4. Add their favourite song to the birthday video Hints: ·      *   Get amazing pictures from your parent ·      *  Import the pictures into Capcut video editing software ·      *  Add songs to the birthday   video ·      *  Add effect (In/Out) to the video ·      *  Export your video when done   Submission : To be submitted on resumption with your laptop/save on a flash drive.

  MID TERM PROJECT MARK OBTAINABLE : 50 MARKS      CLASS : SSS1 Use python programming language to: (1) Evaluate temperature in Celsius with the following parameters: Given the formula:   F =   9/5*temp+32 (a) 50 (b) 65 (c) 45 (d) 30 (2) Evaluate Simple Interest with the following parameters: Given that I = P*R*T/100 (a) P=200, R = 2%, T = 5 yrs (b) P=5000, R = 5%, T = 2 yrs (c) P=3000, R = 6%, T = 3 yrs (d) P= 6000, R = 5%, T = 5 yrs   Submission: Submit to: sunlitedigitalhub@gmail.com  

  MID TERM PROJECT MARK OBTAINABLE : 50 MARKS    CLASS : JSS3 Use any search engine of your choice to research on the following computing terms: (a) Expert System   (i) Meaning of Expert System   (ii) Benefits of Expert System (iii) Disadvantages of Expert System (b) Robotics (i) Meaning of Robotics   (ii) Benefits of Robotics (iii) Disadvantages of Robotics (Iv) Parts of a Robot   N:B:- To be printed with spiral binding. Submission : To be submitted on resumption  

  MID TERM PROJECT MARK OBTAINABLE : 50 MARKS   CLASS : JSS2 Title : Create Custom Presentation File for Your Favourite  Computer Topic Using Any Presentation Package Details : Based on the topic you love the most, create a presentation file with animation and transition of a minimum of 5 slides with custom background design. Rubrics :  ● The presentation should contain at least a slide that shows why you love the topic with animation. ● The last slide should contain the name of the school ( Albesta Academy Lekki ) and the name of your Instructor ( Mr  Gbenga ) Submission: Submit the presentation file to : sunlitedigitalhub@gmail.com

  MID TERM PROJECT MARK OBTAINABLE : 50 MARKS   CLASS : JSS1 Create an interactive conversation between two characters with  (MBlock) . Steps: 1. Download and intall Mblock on your device 2. Use any two (2) characters of your choice 3. Add your favourite background 4. Add your codes 5. Add sound/record your voice to the conversation   Submit to : sunlitedigitalhub@gmail.com  

 INFORMATION TRANSMISSION  MEANING, METHODS, MEANS AND MODES OF RECEIVING INFORMATION MEANING, OF INFORMATION TRANSMISSION Information Transmission is the process of sending out processed data from one person or place to another in a meaningful form through a communication medium. Methods of Information Transmission There are two methods of transmitting information, namely: A. Ancient Method of Information Transmission B. Modern Method of Information Transmission Ancient Methods of Transmitting Information These are the methods used by our forefathers before the development of modern technology in passing on information . They include the following: a. Oral (Face to Face) Communication This is a method whereby the sender (informant) meets with the receiver (recipient) face-to-face to pass information across. b. Beating Drums Drum beating is another way of transmitting information from the sender to the receiver. Drums are used to informing the Villagers of certain invents such as hunti

  OUTPUT DEVICES  DEFINITION, EXAMPLES, DESCRIPTION AND DIFFERENCES BETWEEN MONITOR AND PRINTER DEFINITION OF OUTPUT DEVICES  Output devices are devices that enable the computer to communicate the results of data processing carried out by it to the user. These devices enable the computer to display text, graphics (pictures and images) and produce sound. Examples of Output Devices are: 1. Monitor 2. Printer 3. Speaker 4. Plotter 5. B raille embosser 6. Projector 7. GPS (Global Positioning System) 1.  Monitor :  The monitor, also called Visual Display Unit (VDU) is a TV-like structure attached to the System Unit through the VGA cable. It displays text and graphics (pictures and images). The content showing on the monitor is called a soft copy. 2.  Printer :    A printer is a device attached to the System Unit through the USB cable or other types of cable. It is used to produce the information (text, graphics, images, illustrations) showing on the monitor on paper, transparencies, and pl