1-Basic-Computer-Organisation:

Syllabus: CPU, Primary Memory (RAM, ROM, Cache), Secondary Storage Device, I/O Devices, Unit of Memory (Bit, Byte, Kilo Byte, Mega Byte, Tera Byte, Peta Byte) 

Classification of Computer(Super, Mainframe, Mini, PC)

2-Classificartion-of-Computer

Classification of Computer(Super, Mainframe, Mini, PC)

Concepts-of-Software :

Definition of Software, Types of Software-System Software (Transalator, Assembler, Interpreter, Compiler, Loader, Linker, Operating System: Definition and function, types of OS- Single Use, Multiuse, Multiprogramming, Multiprocessing, Time Sharing) Application Software: Definition and Example), Utility Software, Concept of GUI and CUI with example of LIUNX(Basic Commands)

Number-System :

Binary, Octal, Decimal, Hexadecimal number system, conversion
between number system, Weighted Code (BCD, Binary, 84-2-1 code),
non-weighted code (GREY, Excess-3), encoding schemes (ASCII, ISCII,
uni code), 1’s complement, 2’s complement.

9 Hours of Study

5-Boolean-Algebra:

Postulates, logic gates: NOT, AND, OR, NAND, NOR, XOR, XNOR, truth tables.

De Morgan theorem, SOP, POS, Simplifications using KMap, and

Boolean algebra, logic circuits.

6-Concept-of-Programming:

Instruction (Definition, Example), Program (definition, example),
Programming Language (concept of high-level, low-level, and assembly
language), Procedural and Non-procedural programming, Concept of
Structured Programming, Object-Oriented Programming.

2 Hours

7- Algorithm fundamentals: 
Definition, characteristic of an algorithm, recursive and non-recursive
algorithms, representation of algorithms using flowcharts, pseudo code,
efficiency of algorithm, space complexity, time complexity, Asymptotic
Notation- big O, big Omega, big Theta.

8-Introduction to Problem Solving: 

 
Steps for Problem Solving (analysing the problem, developing an
algorithm, coding, testing, and debugging).

9-Introduction-to-Spreadsheets:

Spreadsheets and their applications: an overview of spreadsheet software

(e.g., Open Office, Google Sheets, Excel), creating workbooks, modifying

workbook, zooming in on a worksheet, and arranging multiple workbooks

windows, adding buttons to the quick access toolbar, customizing the

ribbon, maximizing usable space in the program window, and navigating the

spreadsheet interface, entering and editing data in cells, saving, opening,

and closing spreadsheet files.

10-Working-with-Data-and-Tables:

Entering and revising data, moving data within a workbook, finding and

replacing data, correcting and expanding upon worksheet data, defining

tables.

11-Performing-Calculations-on-Data

Naming groups of data, creating formulas to calculate values (e.g., SUM,

AVERAGE, COUNT), summarizing data that meets specific conditions (e.g.,

AVERAGEIF, COUNTA, COUNTBLANK, COUNTIFS, SUMIF, IFERROR etc),

finding and correcting errors in calculations.

12-Changing-Workbook-Appearance

Formatting Cells, defining styles, workbook themes and table styles,

making numbers easier to read, changing the appearance of data based

on its value, adding images to worksheets.

13-Data-Analysis-and-Manipulation

Limiting data appearance on screen, working with text functions for data

cleaning, Splitting and combining data, Data normalization and

standardization, working with ranges and named ranges, conditional

formatting, data validation and error checking, using logical functions

(e.g., IF, AND, OR), sorting and filtering data.

14-Advanced-Spreadsheet-Features

Creating and managing tables, working with charts and graphs, importing

and exporting data, using Goal Seek.

15-Reporting-and-Presentation-of-Results

Designing informative reports and summaries, creating interactive

dashboards for data presentation, data visualization best practices,

documenting data analysis processes, presenting findings to stakeholders.

16-Collaboration-and-Sharing

Protecting worksheets and workbooks, sharing spreadsheets with others,

tracking changes and commenting,