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 acti...

 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)       ...

  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  

  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 m...

  INTRODUCTION TO PYTHON (PRACTICAL) What is Python? Python is a popular programming language. It was created by Guido van Rossum, and released in 1991. It is used for: web development (server-side), software development, mathematics, system scripting(video game).  Python IDLE  IDLE is a simple integrated development environment (IDE) that comes with Python. It’s a program that allows you to type in your programs and run them. Python Keyboard shortcuts  The following keystrokes work in IDLE and can really speed up your work. Keystroke Result CTRL+C  -Copy selected text  CTRL+X Cut selected text  CTRL+V  Paste  CTRL+Z Undo the last keystroke or group of keystrokes CTRL+SHIFT+Z Redo the last keystroke or group of keystrokes  F5 Run module N:B :- Save Python file extension at .py to run python program. For example myfirstpythonprogram.py My First Python Program print ( "Hello, World!" ) print ( "Albesta Academy is Great!" ) print ( "Godline...