Fundamentals of Computer
Fundamentals of Computers includes the topics history, generation, classification, computer system, hardware and software, liveware, firmware and cache memory, peripherals, computer media, networking, security and viruses, file management, ASCII and Unicode standards, IT policy, electronic act.
Operating Systems consists the topics such as introduction to operating systems, types, functions, command line operations, windows, introduction to GUI, windows operating system, basic windows elements (desktop, taskbar, my computer, recycle bin, starting) shutting down windows, file management, windows explorer, windows applications (control panel, character map, paint etc), finding files and folders, start programs, changing windows settings, creating shortcuts, system tools (disk scanning, disk defragment, backup, restore, format)
Word Processing - Microsoft Word
This category consists of concept of word processing, types, creating saving and opening documents, screen elements, copy, move, delete and format text, find and replace text, uses of devnagari font, bullets and numbering, tables, borders and shadding, indentation and tab setting, newspaper style columns, header, footer, endnote, foot note, section and breaks, graphics pictures, charts, word art, symbols, organization charts, default settings, mail merge, auto correct, speller, thesaurus, menu and toolbar, document security, master document, references and tables, setting page layout, preview and printing.
Electronic Spreadsheet - Microsoft Excel
This category includes the topics such as concept of electronic spreadsheets, types, organization of spreadsheet applications, cells, rows, columns, worksheets, workbooks and workspaces, creating opening and saving workbooks, screen elements, editing copying moving and delete cell contents, calculation with devnagari fonts, cell formatting, using formulas, relative absolute and mixed cell references, basic functions, generating series, default options, sorting filtering data, summarizing and sub totals, charts, header footer, speller, customizing menu and toolbar, import export data, pivot table, goal seek, scenario and audit, page setting, preview and printing.
DBMS - Microsoft Access
This category includes the topics such as introduction to data, database and DBMS, concept of tables, fields, records, relationship and indexing, data types, creating modifying and deleting tables, formatting and validating field data, simple queries, forms, reports and macros.
Presentation System - Microsoft PowerPoint
Presentation System category includes the topics such as creating opening and saving slides, formatting slides, slide show, animation, inserting build in pictures, tables, charts, graphs, organization chart etc.
PHP Scripting Language
Some MCQ sets from PHP scripting language.
C++ Programming Language
Some multiple choice question sets from C++ Programming Language basic concepts. This category requires further refinement.
Data Structures and Algorithms
Multiple Choice Questions Sets from Data Structures and Algorithms. The category contains questions from basic concepts and it requires further refinement.
Information System Analysis and Design
Building information systems is not an easy process but requires certain skills and capabilities to understand and follow a systematic procedure towards making of any information system. Waterfall model is one of the oldest methodologies. Later Prototype Model, Object Oriented Model, Dynamic Systems Development Model, and many other models became very popular for system development.
This category requires refinement.
This category includes the intermediate and advance topics on networking such as Basic Network Theory, Network Connectivity, Advanced Network Theory, Common Network Protocols, TCP/IP Services, Network LAN Infrastructure, Network WAN Infrastructure, Remote Networking, Computer Security, Network Security, Disaster Recovery, Advanced Data Storage Techniques, Network Troubleshooting, Network Support Tools, Network Access Points (NAP) etc.
Computer Architecture and Organization
In this section we present multiple choice questions covering following topics:
- Evaluation of Computers, Design Methodology, Set Architecture, MIPS ISA, ALU Design.
- Datapath Design: Single and Multiple Cycle Implementations, Pipelining, Memory Hierarchy, Input/Output System: Bus & Role of Operating System.
Database Management System and Design
This section presents the multiple choice questions (MCQs) from following topics of Database Management System and Design.
Introduction, A Database Model, Relational Database Model, Integrity, RDBMS, SQL and Embedded SQL, Writing Basic SQL SELECT Statements, Restricting and Sorting data, Single Row Functions, Displaying Data from Multiple Tables, Aggregation Data Using Group Functions, Sub Queries, Manipulating Data and Creating &Managing Tables, Creating Views and Controlling User Access, Using Set Operators, Datetime Function, Database Design: Logical Design, Conceptual Design, Mapping Conceptual to Logical, Pragmatic issues, Physical Design, Integrity and Correctness, Relational Algebra, Relational Calculus. Normalization: 1NF, 2NF, 3NF, BCNF, 4NF,5NF, DKNF. Architecture of DBMS: Client-server, Open Architectures, Transaction Processing, Multi-User & Concurrency, and Backup & Recovery Database, Basic Concept of major RDBMS products: Oracle, Sybase, DB2, SQL Server and other Databases.
This section contains the multiple choice questions (MCQs) from the Programming Languages, Language Processors etc.