Showing posts with label Syllabus. Show all posts
Showing posts with label Syllabus. Show all posts

Monday, June 20, 2022

CPCT Syllabus 2022- 23

 Computer Proficiency Certification Test (CPCT) 

MCQ Test - 75 Marks

Hindi Typing test + English Typing test

Topics

Computer (Revision )

    1.History

    2. Generation

    3. Types of Computer

    4.Computer Hardware - Computer Fundament  

        a. Motherboard    b.VGA  C.

    5. Computer Software - 

        a. Operating System

            1. Windows    2. Linux     3.Dos    

    6. MS Word  - Keyboard Shortcut - Extra Fact

    7. MS Excel - Keyboard Shortcut - Formulas - Fact

    8.MS Power Point

    9.Outlook

    10.Application Software

    11.Computer Full Form

    12.Network   

            a. TCP/IP  

    13. Internet

        1. Domain Name  2. browser  3.

    14. File Extension 






#yunussir #computersir #yunussirtutorial #Digitalsir #unishsir

    

    

Monday, May 23, 2022

Python (Syllabus)

 Python Syllabus

UNIT - I

 Planning the computer program: concept of problem solving, problem definition, program design, debugging, types of errors in programming, documentation. Techniques of problem solving: flowcharting, decision table, algorithms, structured programming concepts, programming methodologies viz. Top-down and bottom-up programming. Overview of programming: structure of a python program, elements of python. 

UNIT - II 

Introduction to python: python interpreter, using python as calculator, python shell, indentation. Atoms, identifiers and keywords, literals, strings, operators (arithmetic operator, relational operator, logical or Boolean operator, assignment, operator, ternary operator, bit wise operator, increment or decrement operator) Creating python programs: input and output statements, control statements(branching, looping, conditional statement, exit function, difference between break, continue and pass.), defining functions, default arguments, errors and exceptions. Iteration and recursion: conditional execution, alternative execution, nested conditionals, the return statement. 

UNIT - III 

Recursion, stack diagrams for recursive functions, multiple assignment, the while statement, tables, two-dimensional tables (English) Strings and lists: string as a compound data type, length, traversal and the for loop, string slices, string comparison, a find function.

UNIT - IV

 Looping and counting, list values, accessing elements, list length, list membership, lists and for loops, list operations, list deletion. Cloning lists, nested lists Object oriented programming: introduction to classes, objects and methods, standard libraries.(English)

 UNIT - V 

Data structures: (LINK) ENGLISH arrays, list, set, stacks and queues. Searching and sorting: linear and binary search, bubble, selection and insertion sorting.   

Tally Syllabus

 Tally Syllabus

Unit -1

Unit -2

Account

Inventory

Bank
Unit -3
Job Costing (English)
Cash book and bank book (english)
Journal Register (English )
Purchase Register (English )


Unit -4


Unit -5

Syllabus (DBMS)

  2BCA Notes All previous year paper

Database Management

Database Management

Introduction To Database System : Data - Database Applications -Advantages - Evolution of DB & DBMS- Need for data management, Introduction and applications of DBMS, File systems vS Database systems, Data Models, DBMS Architecture, Data Independence, Data Modeling using Entity-Relationship Model, Enhanced ER Modeling( English).data dictionary

UNIT - II

Relational Database Concept and Design: Introduction to relational database, Structure of Relational Database, Relational model terminology(English) domains, Attributes, Tuples, Relations  , relational DB schema. Relational algebra:  Set Theoretic projection, Select ion, operations Union, Intersection, set difference and division, Join operations: Inner,Outer, Left outer, Right outer and full outer join. Relational Database design, Functional Dependency, definition, trivial ki 7 and nontrivial FD, Normalization 1Nf, 2NF, 3NF,Decomposition using FD dependency preservation, BCNF, Multi valued dependency, 4NF,Join dependency and 5NF.

UNIT - III

Database storage and querying (English)-Basic Concepts of Indexing and Hashing Query Processing,Measures Of Query Cost, Query Processing for Select, Sort ,Join Operations, Basics of Query Optimization(English ), Transformation of Relational Expression( English) Estimating Statistics of Expression( English), Choice of Evaluation Plan link.

UNIT - IV

Concurrency, Recovery and Security -Concurrency Control: Definition of concurrency, lost update, dirty read and incorrect summary problems due to concurrency. (English)Concurrency Control Techniques: Overview of Locking, 2PL, Timestamp ordering, multi-versioning (English), validation Recovery concepts, Shadow paging, Log Based Recovery, Elementary concepts of Database security: system failure, Backup and Recovery Techniques, authorization and authentication.

UNIT - V

Introduction to Current Trends (English)– Centralized and Client Server Architectures, Distributed Databases(Fragment), Object Oriented Database(English), Spatial & Temporal Databases(English), Data Mining WarehousingData Visualization, Mobile Databases( English), OODB & XML Databases, Multimedia & Web Databases.