Public Service Commission Preparation & Blogging

Post Top Ad

Ms-Office Practical Guides

In this section, we present the learning materials for your computer practical exam especially in Ms-Office. Most important, frequently asked Questions, Practical Guides, Practice Sets, and Tips & Tricks from Ms-word, Ms-excel, Ms-powerpoint, Ms-Access and HTML for the practical exam preparation of PSC Computer Operator and Data Entry Supervisor. Let's started to learn.


Ms-Word

Practical Guides

Ms-Word

Asked Papers

Ms-Word

Practice Sets

Ms-Word

Tips & Tricks


Ms-Excel

Practical Guides

Ms-Excel

Asked Papers

Ms-Excel

Practice Sets

Ms-Excel

Tips & Tricks


Ms-Powerpoint

Practical Guides

Ms-Powerpoint

Asked Papers

Ms-Powerpoint

Practice Sets

Ms-Powerpoint

Tips & Tricks


Ms-Access

Practical Guides

Ms-Access

Asked Papers

Ms-Access

Practice Sets

Ms-Access

Tips & Tricks


Multiple Choice Questions Sets

Here we presents the selected, Most important, frequently asked Multiple Choice Questions from Ms-word, Ms-excel, Ms-powerpoint, Ms-Access and HTML for the written exam preparation of PSC Computer Operator and Data Entry Supervisor. Let's Get started to learn.


Ms-Word

MCQ Sets

Ms-Excel

MCQ Sets

Ms-Powerpoint

MCQ Sets

Ms-Access

MCQ Sets


HTML

MCQ Sets

Operating System

MCQ Sets



Interviews Preparations

The most important part of preparing for an Interview is practice. Preparation is the key to a successfull interview so take a look at Preparations Questions and Tips & Tricks how to answer them. Let's Get started to learn.


Interview Questions

Asked Before

Tips & Tricks

Based on Experience



Question Papers

I knew its hard to find the right question papers in internet from one website. But it's good to say here i collects questions papers sets that are previously asked from psc exams. These questions will be helpful for the final preparation of your exam. Let's start to expand your knowledge.


Section Officer

Asked Before

Computer Officer

Asked Papers

Nayab Subba

Asked Papers

Computer Operator

Asked Papers


Kharidar

Asked Papers

Asst. C.O.

Asked Papers



Modal Practice Paper Sets

Here we have writes some sample practical paper sets for your exam. Try to solve these questions within time at home frequently. If you solve this within time you will cover almost every quetions in exam hall. These questions will be helpful for the final preparation of your exam. Let's start to practice.


Section Officer

Modal Sets

Computer Officer

Asked Papers

Nayab Subba

Modal Sets

Computer Operator

Modal Sets


Kharidar

Modal Sets

Asst. C.O.

Modal Sets



Tutorials & Courses

In this section, we presents the learning materials for your Public Service Commission exam, bank exam, Nea exam, institutional exan etc. This section contains chapters with solutions, cources, or any thing that helps for your written exam, practical exam & interview based on curriculam. Let's start to prepare for your exam.


Section Officer

Tutorials

Computer Officer

Tutorials

Nayab Subba

Tutorials

Computer Operator

Tutorials


Kharidar

Tutorials

Asst. C.O.

Tutorials



Blogging & Wordpress Tutorials, Courses

In this place, you will find blogging tips, new strategies, and will teach you how to be a bogger with just the most basic computer skills. Everything you need to know to start blogging-we'll show you how step by step for blogging and wordpress. Let's Get started to learn.


Wordpress

Tips

Blogging

Tips

Wordpress

New Strategies

Blogging

New Strategies


Blogging

Make Money

Wordpress

Make money

Blogging

Guide

Wordpress

Guide


Blogging

For Beginners

Wordpress

For Beginners

Blogging

Tutorials

Wordpress

Tutorials


Wordpress

How to start?

Blogging

How to start?

Blogging

Intermediate

Wordpress

Intermediate


Post Top Ad

Course Title: System Analysis and Design
Course no: CSC-252 Full Marks: 70+10+20
Credit hours: 3 Pass Marks: 28+4+8
Nature of course: Theory (3 Hrs.) + Case Study
Course Synopsis: This course help launch the careers of successful systems analyst – or of users assuming an active role in building systems that satisfy their organization's information needs. Also provides a solid foundation of systems.
Goal: This course will provide the concept of system representation.
Course Contents
Unit 1. Overview of Systems Analysis and Design 4 Hrs.
Introduction to system analysis and design, Types of Information Systems and Systems Development, Developing Information Systems and the Systems Development Life cycle, Systems analysis and design tools
Unit 2. Modeling Tools for Systems Analyst 5 Hrs.

Modeling with Data Flow Diagrams, Drawing DFDs with CASE, Modeling with Entity – Relationship Diagrams

Unit 3. Structured Methodologies 6 Hrs.
The need for a Structured Methodology, CASE as an Enabling Technology, Advantages and Disadvantages of Modeling and Data Dictionaries, Other Specification Tools

Unit 4. Systems Analysis 8 Hrs.

Systems planning and initial Investigation, Information Gathering, The tools of Structured Analysis, Feasibility Study, Cost/ Benefit Analysis
Unit 5. Systems Design 8 Hrs.

The process and Stages of systems Design, Input/ Output Forms Design, File Organization and Data Base Design
Unit 6. System Implementation 8 Hrs.
System Testing and quality Assurance, Implementation and Software Maintenance, Hardware / Software Selection and the Computer Contract, Project Scheduling and Software

Unit 7. Object-Oriented Analysis and Design 6 Hrs.
Object-Oriented Development Life Cycle, the Unified Modeling Language, Use-Case Modeling, Object Modeling: Class Diagrams, Dynamic Modeling: State Diagrams
Dynamic Modeling: Sequence Diagramming, Analysis Verses Design
Case studies: Student must have to do one case study covers all chapters.
Text books: Jeffrey A. Hoffer, Joey F. George, Joseph S. Valacich, Modern Systems Analysis and Design, Pearson Education, Second Edition
References: Englewood Cliffs, New Jersey, Systems Analysis and Design. Jeffrey L. Whitten, Loonnie D. Bentley, 5rd Edition, Systems Analysis and Design Methods.
Grady Booch, Pearson Education, Object Oriented analysis and design with applications

4th semester syllabus:Introduction to Cognitive Science 
 Course Title: Introduction to Cognitive Science

Course no: CSC-255                                                           Full Marks: 70+10+20
Credit hours: 3                                                                     Pass Marks: 28+4+8
Nature of course: Theory (3 Hrs.) + Lab (3 Hrs.)
Course Synopsis: An introduction to cognitive science and its relation with other sciences. It covers briefly the area of Artificial Intelligence, Computational models and connectionist approach. 

Goal:
·        The student will gain an introductory understanding of what it means to say that intelligence is computational The student will:
o       Acquire a good understanding of what an algorithm is and learn how to implement algorithms in the programming language LISP
o       Develop an introductory understanding of formal models for computation, the limits of computation, the Chomsky hierarchy, and the Turing-Church hypothesis
·        The student will study some of the modern attempts to demonstrate a computational model for intelligence through an introduction to the discipline of artificial intelligence, including introductions to knowledge representation, search, and artificial neural networks.
·        Finally, the student will explore some of the positions taken in the ongoing discussion of this issue. In Philosophy and Linguistics, we will begin with Descartes, and look (and discuss) Turing, Gelernter, Newell and Simon, Penrose, Searle, and others, finishing with a partial response to Descartes given to us by Chomsky and others.
Course Contents:
Unit 1. Introduction to the Problem                                                        6 Hrs.

Cognitive Science and other Science, Descartes, Marr, Algorithms and Computation, Turing's response to Descartes, Application related system in the Cognitive Science.
Unit 2. Brief Introduction to Artificial Intelligence                               13 Hrs.
History and background of Artificial Intelligence, Knowledge representation, Human information processing and problem solving, Search, Expert system, Introduction of Neural Networks.

Unit 3. Computation                                                                                              11 Hrs.

Introduction, Basic Model for Computation, The Turing Machine, Computational and Language: the Chomsky hierarchy, The Physical Symbols Systems Hypothesis, Illustration of practical examples.

Unit 4. Approaches                                                                                                15 Hrs.
The connectionist approach, Different models and tool: Gelernter, Penrose, Pinker, Searle; Response to Descartes: Natural Language Processing, Parameters in the Natural Language Processing.

Text / Reference books:
1.      Thinking about consciousness / David Papineau, Oxford: Clarendon Press New York: Oxford University Press, 2002.

2.      Copeland, Jack:  Artificial Intelligence:  A Philosophical Introduction. Blackwell Publishers.
3.      Cognition in a digital world / edited by Herre van Oostendorp,  Mahwah, N.J.: L. Erlbaum Associates, 2003
4.      The evolution and function of cognition / Felix Goodson, Mahwah, N.J.: Lawrence Erlbaum Associates, Publishers, 2003.
Course Title: Technical Writing
Course no: ENG-256                                                                       Full Marks: 90+10
Credit hours: 3                                                                                 Pass Marks: 36+4
Nature of course: Theory (3 Hrs.)
Course Synopsis:     This course offers a number of tools for writing in technical fields, by presenting clear explanations of key concepts and skills in written communication. The writing process is placed in a systems approach that integrates readings, planning, writing, and revising. Other features include suggestions about how to select, organize and present information in reports, papers and other documents.
Goal: This course presets the types of writing skills students need to have for a career in technology.
Unit 1.                                                                                                             15 Hrs.
Turk & Kirkman, Writing is communicating, Thinking about aim and audience, Organization and layout of information, the use of headings and numberings, Rutherfoord, Foundations (audience, language an style, organization), Grammar Units (subjects and verbs, agreement: pronouns; pronoun references; avoiding shifts; modifiers; clause and simple sentence; compound sentences; complex an d compound – complex sentences; fragments, run-ones, and comma splices; transition words; parallelism).
Unit 2.                                                                                                             15 Hrs.
Turk & Kirkman, Algorithms for complex possibilities and procedures, style for Readability, Writing with a computer, Informative summaries, Choosing and using tables, illustrations and graphic presentation techniques; Rutherfoord, , Writing Elements, (Technical definitions, technical descriptions, summaries, graphics, instructions, comparisons and contrast), Mechanics Units, (Capital letters; abbreviations and acronyms; end punctuation; commas; parentheses; dashes, brackets, ellipses, slashes, and hyphens; apostrophes; quotations).
Unit 3.                                                                                                             15 Hrs.
Turk & Kirkman, Writing instructions, Writing descriptions and explanations, Writing letters and memoranda, Writing minutes and reports of proceedings, Writing in Examinations: Rutherfoord, Formes of Technical Communications (technical reports; forms, memos, and e-mail; business; letters; presentations; the job search: resume and letters), Appendices (common symbols and abbreviations; tips for word processing; sample reports; irregular verbs; job applications.
Text books:
Truck, Christopher & John Krikman. Effective Writing: Improving scientific, technical and business communications. Second edition. London and New York: E & FN Spoon, 1989. First Indian Reprint, 2003. ISBN 0-19-14660-1.
Futherford, Andreas J. Basic Communications Skills for Technology. Second Edition. Pearson Education, 2001. First Indian Reprint, 2001. ISBN 81-7808-281-0
Reference Books:
Lannon, John M. Technical Writing, Sixth Edition. New York: HarperCollins 1994. ISBN 0-673-52294-6.
Raman, Meenakshi, and Sangeeta Sharma. Technical Communications: Principles and Practice. New Delhi: Oxford University Press, 2004. ISBN 0-19-566804-9.
Gerson, Sharon J., and Stenven M. Gerson. Technical Writing: Process and Product. Third Edition. Pearson Education Asia, 2000. First Indian Reprint, 2001. ISBN 81-7808-381-7.
Mohan, Krishna, and Meera Banergi. Developing Communication Skills. New Delhi: Macmillan, 1990. ISBN 0-333-92919-5
Wehmeier, Sally, Chief Ed. Oxford Advanced Learner's Dictionary of Current English. Oxford University Press, 2005. ISBN 0-19-431665-3.
Lafferty, Petter, and Julian Rowe, eds. The Hutchinson Dictionary of Science. Oxford: Helicon, 1993,. ISBN 009-177151-X

Database Management System
Course no: CSC-253                                                                                   Full Marks: 70+10+20
Credit hours: 3                                                                                              Pass Marks: 28+4+8
Nature of course: Theory (3 Hrs.) + Lab (3 Hrs.)
Course Contents:
Unit 1: 19 Hrs.
Introduction to database: 4 Hrs
Characteristics of database approach, Advantages of using DBMS, Database concept and architecture,Data Abstraction,Data independence Data Models , Instances and schema,Schema architecture,Database Languages,Database Manager,DatabaseAdministrator,Database Users

Data models: 5 Hrs
Entity-relationship Model:Entities and entity sets,Relationship and Relationship sets,Attributes,Mapping constraints,Keys,Weak and Strong entity types,E-R Diagrams,Reducing E-R Diagrams to Tables,Specialization and Generalization,Aggregation,Pr: Design E-R Database Schema
Relational Model: 5 Hrs
Structure of Relational Database,The Relational Algebra,The Tuple Relational Calculus,The Domain Relational Calculus,Modifying the Database,Views.Historical Models:Basic concept of Hierarchical and Network ModelPr: Relational Commercial Languages: 5 HrsStructure Query LanguageQuery by Example (QBE)
Unit 2: 12 Hrs.
Integrity & Security: 4 Hrs
Domain Constraints,Referential Integrity,Assertion and Triggers,Authorization & Authentication,Data encryption
Theory of database design: 4 Hrs
Functional dependencies,Trivial and non trivial dependencies,Closure of a set of functional dependencies,Irreducible sets of dependencies.
Normalization: 4 Hrs
Non-loss decomposition and functional dependencies,First, second, and third normal forms,Dependency preservation,Boyce-Codd normal form
Unit 3: 14 Hrs.
Transaction Processing: 5 HrsDesirable properties of transactions,Implementation of atomicity and durability,Concurrent executions,Schedules and recoverability,Testing for Serializability
Concurrency Control: 5 Hrs
Overview of Concurrency Control,Locking techniques,Lock-based protocols,Timestamp-based protocols,Commit protocols,Optimistic technique,Granularity of data items,Time stamp ordering multi version concurrency control,Deadlock handling - detection and resolution
Database Recovery: 4 Hrs
Failure Classification,The Storage Hierarchy,Transaction Model,Log-Based recovery,BufferManagement,Checkpoints,Shadow Paging,Failure with Loss of Non-volatile Storage
Laboratory works:
The course involves a mini project using any one of the popular Commercial database packages like Oracle, MySql, MS SQL Server, or MS Access etc.
Prerequisite: Be familiar with at least one high-level programming language such as C, C++ or Java, Introduction to Operating Systems, Data Structures and Algorithms

Textbooks: A. Silberschatz, H.F. Korth, and S. Sudarshan, Database System Concepts, 4th Edition, McGraw Hill (ISBN: 0-07-120413)
References:
1. C. J. Date, An Introduction to Database Systems, 8th Edition, Addison Wesley
2. Raghu Ramakrishnan, and Johannes Gehrke, Database Management Systems, McGraw-Hill, 2003. (ISBN: 0-07-246563-8)
3. Ramez Elmasri and Shamkant B. Navathe, Fundamentals of Database Systems, 4th Edition, Pearson Addison Wesley; 2003, (ISBN: 0321122267)
Homework
Assignments: Homework assignments can be given according to the course covered throughout the semester.
Computer Usage: Windows or Linux based PC or workstation, Commercial database package installed in the Database server.
Category Content:
Science Aspects: 50%
Design Aspects: 50%

4th semester syllabus:Computer Graphics

Course Title: Computer Graphics
Course no: CSC-254                                                                                          Full Marks: 70+10+20
Credit hours: 3                                                                                                     Pass Marks: 28+4+8
Nature of course: Theory (3 Hrs.) + Case Study

Course Synopsis: This Graphics hardware, software, and applications, data structures for graphics, graphics languages, models for 2D and 3D objects, clipping, hidden surface elimination, depth buffer, raster graphics, shading rendering, splines tools.
Goal: The objective of this course is to understand the theoretical foundation of 2D and 3D graphics.
Course Contents:
Unit 1. 5 Hrs.
Introduction, Advantage of Computer Graphics, Areas of Applications, Hardware and Software for Computer Graphics. (Hard Copy, Display Technologies), Random Scan Display System, Video Controller, Random Scan Display Processor. Raster Graphics, Scan Conversion Algorithms (Line, Circle, Ellipse), Area Filling (Rectangle, Ellipse), Clipping (Lines, Circle, Ellipse), Clipping Polygons.
Unit 2. 10 Hrs.
Geometrical Transformations, Homogenous coordinates, 2D and 3D Transformations, Matrix Representations, Window to View Port Transformation. 3D Viewing, Projections, Mathematics of Projections.
Unit 3. 15 Hrs.
3D Object Representation, Representing Curves and Surfaces, (Polygon Meshes, Parametric Cubic Curves, Quadratic Surface), Solid Modeling (Sweep Representation, Boundary Representation, Spatial Partitioning Representation)
Unit 4. 12 Hrs.
Visible Surface Determination, Various Techniques, Algorithms for Visible Surface Detection, (Z- Buffer, List priority, Scan Line Algorithms), Shading and Illumination models.
Unit 5. 3 Hrs.
Introduction to virtual Reality and Animation.
Laboratory works: All algorithms covered in the text to be implemented in PHIGS/OpenGL in C/C++.
Text / References books:
1. Foley, J. D., A. V. Dam, S. K. Feiner, J. F. Hughes, Computer Graphics Principle and Practices, Addison Wesley Longman, Singapore Pvt. Ltd., 1999.
2. Hearn Donald, M. P. Baker, Computer Graphics, 2E, Prentice Hall of India Private Limited, New Delhi, 2000

No comments:

Post a Comment

Post Top Ad