Exam Details

Subject PC Software Skills
Paper
Exam / Course Bachelor of Computer Applications
Department School of Computer and Information Sciences (SOCIS)
Organization indira gandhi national open university
Position
Exam Date June, 2016
City, State new delhi,


Question Paper

Three married couples are to cross a river in a boat which can hold only two persons. One of the persons must row the boat. Each of the three husbands is a jealous man who will not.allow his wife to be left in the company of other men, unless he is also present. Show how the jealous husbands and their wives can accomplish the trip by representing all the states on the left and the right banks of the river.

What is a Pivot table What are the uses of Pivot tables? Discuss with the help of an example.

Prove that for all n 2^n n^2 .

Explain the following terms:

Autoformat

Autofill

WYSIWYG

Format Painter

Workbook

Define a browser. Explain any two differences between the two basic categories of browsers.

Explain the following:

TELNET

ISP

FTP

What are Macros in Excel Write the steps to create and run a Macro.

Prove that the product of four consecutive natural numbers cannot be the square of an integer.

Explain the use of the following functions with an example for each:

RAND()

SUMIF()

What is Chart Wizard in MS-Excel and what are its advantages? List the steps involved in creating a chart through Chart Wizard.

5. Write short notes on the following:

SMTP

POP

E-mail

Scenario Manager

Autofilters


Departments

  • Centre for Corporate Education, Training & Consultancy (CCETC)
  • Centre for Corporate Education, Training & Consultancy (CCETC)
  • National Centre for Disability Studies (NCDS)
  • School of Agriculture (SOA)
  • School of Computer and Information Sciences (SOCIS)
  • School of Continuing Education (SOCE)
  • School of Education (SOE)
  • School of Engineering & Technology (SOET)
  • School of Extension and Development Studies (SOEDS)
  • School of Foreign Languages (SOFL)
  • School of Gender Development Studies(SOGDS)
  • School of Health Science (SOHS)
  • School of Humanities (SOH)
  • School of Interdisciplinary and Trans-Disciplinary Studies (SOITDS)
  • School of Journalism and New Media Studies (SOJNMS)
  • School of Law (SOL)
  • School of Management Studies (SOMS)
  • School of Performing Arts and Visual Arts (SOPVA)
  • School of Performing Arts and Visual Arts(SOPVA)
  • School of Sciences (SOS)
  • School of Social Sciences (SOSS)
  • School of Social Work (SOSW)
  • School of Tourism & Hospitality Service Sectoral SOMS (SOTHSM)
  • School of Tourism &Hospitality Service Sectoral SOMS (SOTHSSM)
  • School of Translation Studies and Training (SOTST)
  • School of Vocational Education and Training (SOVET)
  • Staff Training & Research in Distance Education (STRIDE)

Subjects

  • ANALYSIS AND DESIGN OF ALGORITHM
  • Basics Mathematics
  • BUSINESS COMMUNICATION
  • C' Programming and Data Structure
  • C++ and Object Oriented Programming
  • Computer Basics and PC Software
  • Computer Fundamentals and PC Software
  • Computer Networks
  • COMPUTER ORIENTED NUMERICAL TECHNIQUES
  • E-COMMERCE
  • Foundation Course in English for Computing
  • Foundation Course in Mathematics in Computing
  • FUNDAMENTAL OF COMPUTER NETWORKS
  • Intranet Administration
  • Introduction to Computer Organisation
  • Introduction to Internet Programming
  • INTRODUCTION TO SOFTWARE ENGINEERING
  • Introduction to System Software
  • Multimedia
  • NETWORK PROGRAMMING AND ADMINISTRATION
  • PC Software Skills
  • Programming In C++
  • STATISTICAL TECHNIQUES
  • TCP/IP PROGRAMMING
  • Theory of Computer Science
  • WEB PROGRAMMING