Syllabus Computer Teacher

Unit I – Fundamentals of Computer

1. Characteristics of Computers
2. Input, Output, Storage Units
3. CPU and its organization
4. Number Systems: Decimal, Binary, Octal, Hexadecimal and their conversion
5. ASCII Code, Unicode
6. Memory Units: RAM, ROM, Cache
7. Secondary storage devices: Hard disks, CD-ROM, DVD, Optical devices, USB, Flash drives
8. Input and Output devices
9. Software and its types: System software, Application software, Utility software

Unit II – Operating System

1. History of Operating System
2. Types of Operating Systems: Batch, Multiprogramming, Multitasking, Time sharing, Parallel, Distributed, Real-time
3. Functions of Operating System: Memory management, Scheduling, Resource management
4. Common Operating Systems: Introduction to MS-DOS, basic commands
5. Windows: Overview of different versions, Basic Windows elements, File management through Windows

Unit III – Office Automation Tools

Word Processing

1. Basic concepts
2. Saving, closing, opening an existing document
3. Selecting text, Editing text
4. Finding and replacing text
5. Printing documents, Creating and printing merged documents
6. Character and paragraph formatting
7. Page design and layout
8. Editing and profiling tools: Spell check, graphics handling, tables and charts, Document templates, Wizards

Spreadsheet Packages

1. Creating, saving, editing workbook
2. Inserting and deleting worksheets
3. Entering data in cell/formula, copying, moving cells
4. Functions: Basic mathematical, Date and time
5. Formatting worksheet: Formatting cells, charts, graphs

Presentation Packages

1. Creating, opening, saving presentations
2. Working in different views
3. Adding, formatting text
4. Making notes pages and handouts
5. Drawing and working with objects
6. Adding Clipart, other pictures
7. Designing slideshows, Running, controlling slideshows
8. Printing presentations

Unit IV – Programming in ‘C’ and Data Structures

Introduction to Programming

1. Types of Programming Languages
2. Problem-solving tools: Algorithms, Flowcharts
3. Language Translators: Assembler, Interpreter, Compiler
4. Process of Linking and Loading
5. Testing and debugging a program

Introduction to ‘C’

1. Keywords, Variables, Constants, Literals, Identifiers
2. Data types: Built-in, User-defined
3. Operators: Expression, Input-Output statements, Conditional statements (if, if-else, switch)
4. Loop statements: do-while, for, while loop
5. Functions: Definition, types, prototype, formal and actual parameter, return type, function call by value and by reference

Data Structures

1. Array: Types, Creation, operations (one-dimensional, two-dimensional)
2. Stack: Implementation, operations (push, pop, traversal)
3. Queue: Implementation, operations (traversal, insertion, deletion)

Unit V – Database Management System

1. Database Concepts: Relational Data Model, Domain, Tuple, Relation
2. Keys: Super key, Candidate key, Primary key, Foreign key, Alternate key
3. Relational Algebra: Selection, Projection, Union, Cartesian Product, Joins
4. Structured Query Language (SQL)
5. Concepts, advantages of using SQL
6. Data types: Number, Character, Date
7. Data Definition Language (DDL): Create, Alter, Drop, Truncate
8. Data Manipulation Language (DML): Insert, Select, Update, Delete
9. SQL Functions: Single row functions, group functions
10. Basic knowledge of MS Access

Unit VI – Communications and Internet Technologies

Networking Concepts

1. Fundamental of Network
2. Types of network: LAN, MAN, WAN
3. Network Topologies
4. Transmission media, Modes of communication
5. Networking Devices: Modem, Hub, Switches, Bridge, Router, Gateway
6. Communication Protocols: TCP/IP suite, IP addressing, MAC address, subnetting
7. Network Security: Threats, Prevention from Viruses, Worms, Trojan Horses, Spam
8. Use of cookies, Firewall projection, Cyber Law (India IT Act 2000)

Internet Concepts

1. Introduction, Growth, Anatomy of Internet
2. Basic Internet terminologies, Netiquette
3. Internet Applications: Email, WWW, Telnet, FTP, Search Engines, E-Commerce
4. Governance, Impact on society

Unit VII – Web Technologies

1. HTML: History, document structure, tags (container, non-container)
2. Formatting tags, ordered and unordered lists, Description list
3. Images, Tables, Links
4. Forms and control: Text box, Radio button, Checkbox, List box, Submit and Reset buttons
5. HTML 5 tags

Unit VIII – Emerging Technologies

1. Fundamentals of Artificial Intelligence (AI)
2. Application, role of AI in different domains
3. Fundamentals of Cloud Computing
4. Features, applications of Cloud
5. Introduction to Data Science, its applications
6. Basic concepts of Internet of Things (IoT)

Teaching aptitude

Here is the expanded version with each topic in a separate line:

1. Philosophical and sociological basis of Education
   • Relationship between Education and Philosophy
   • Relationship between Education and Society
2. Educational Philosophies
   • Idealism
   • Naturalism
   • Pragmatism
3. Psychological Basis of Education
   • Concept of Educational Psychology
   • Growth and Development
   • Theories of Learning: Thorndike, Skinner, Pavlov, Kohlberg
4. Educational Technology
   • Meaning of Educational Technology
   • Nature and types of Educational Technology
   • Teaching and Learning
   • Levels of Teaching
   • Phases of Teaching
   • Maxims and Principles of Teaching
   • Measurement and Evaluation
5. Educational Administration and Management
   • Concept and Purpose of Educational Administration
   • Supervision and Inspection
   • Guidance and counselling