1. Introduction to Computers and Safe Working Practices:
Overview of safe working practices and safety rules. Assembly of Desktop PC, installing basic application software and Windows OS, booting process, hardware and software troubleshooting, computer aptitude, history of computers & inventions, input & output devices, computer components, computer storage devices, computer languages, computer file extensions, Microsoft Windows, etc.
2. Computer Components and Operating Systems:
a. Components of a computer and their functions.
b. Introduction to Windows OS and its main features.
3. DOS and Linux Operating System:
a. Command line interface (DOS and LINUX).
b. Basic DOS commands and Linux features.
c. Understanding DOS, Linux commands and file systems.
4. Word Processing:
a. Applications in MS Office.
b. Creating, saving, formatting, and printing documents using Word Processing Software.
c. Working with objects, macros, mail merge, templates, and other tools in Word.
5. Data visualization or analysis using MS-Excel
a. Introduction to Excel features and data types.
b. MS Excel functions, call referencing, and linking sheets
c. MS Excel revision, lookup functions, and cell naming
d. Custom formatting, protection, Macros, Charts, pivot tables, power queries and power BI
6. MS-Power Point Presentation
a. Create, modify, save, share and configure presentation.
b. Format presentation; manage tables and bulleted text, hyperlinks, Manage graphic elements.
c. Manage Audio & Video elements
d. Manage transitions, animations, slide show and manage collaboration
7. Data Base Management System
a. Database concepts, DBMS, RDBMS, primary key, foreign key and normalization rules
b. SQL Queries and Functions.
c. Using the DDL, DML and DCL statements
d. Transaction, ACID properties, and constraints.
e. Joining tables, sub queries, and various SQL functions.
8. Communicating in a Connected World
a. Understanding local networks and network devices.
b. Explaining the concept of network communication
c. Introduction to internet, web browsers, and search engines
9. Computer Network and Web Design
a. Computer Network Setup and configure a Computer Network and Web Page Design Concepts
b. Use the internet, setup internet access and communication.
c. Static and dynamic web pages Creating web pages using HTML, CSS and open source CMS
d. Introduction to JavaScript for web development, JavaScript and embed JavaScript in HTML pages.
e. Create a dynamics website using an open source tool
10. E-Commerce, Cyber Security, and Cloud Computing
a. Browse e-Commerce sites to identify products and services, introduction operations, payment gateways and security issues.
b. Cyber security overview, protect information, computer and network from Viruses, spywares and other malicious code, and compliance with IT Act
c. Cloud computing benefits, working with cloud services, web hosting cloud application development life cycle.
11. Programming in Python and Java (Command Line)
a. Data Types, operators, control flow with decisions and loops, document and structure code.
b. Perform operations using modules and tools.
c. Object Oriented Programming with Java language flow control.
d. Classes Overloading and inheritance Abstract Classes and interfaces in Java.
e. Troubleshooting Java Issues.