Re-appear BCA I (First) Semester Examination 2013-14
Course Code: BCA103 Paper ID:X831203
Computer Fundamentals and Programming Concepts
Time: 3 Hours Max. Marks: 70 Max Marks: 75
Note: Attempt six questions in all. Q. No. 1 is compulsory.
1. Answer any five of the following (limit your answer to 50 words). (4x5=20)
a) What are the advantages and limitations of digital computers?
b) Write the steps required to create a data table in MS-Access.
c) What is the purpose of FORMAT command in MS-DOS? Write its syntax.
d) Write the syntax of an MS-Excel function to find the median among n values.
e) What are various options available in MS-Power point to print handouts of a presentation file?
f) Write the steps to insert/delete rows/columns of a table in MS-Word.
g) Write a program to test if a character from the keyboard is a lower case letter.
h) Convert (715.415)8 to its decimal, binary and hexadecimal equivalents.
2. Draw a functional block diagram of a modern digital computer. Explain each component. (10)
3. List and explain the functionality of the following input/output devices used in a computer system. (2.5x4=10)
a) Bar code reader
b) Scanner
c) Plotter
d) Visual Display Unit
4. Explain the salient features of MS-DOS as an operating system. (10)
5. What are the options available for page setting in MS-Word? What is the use of printing preview? (10)
6. What methods are available to analyze the data stored in a MS-Excel worksheet? How can you plot a graph from a worksheet? (10)
7. Write a C program that uses ‘for’ loop to find the sum of the following harmonic series for a given value of n and display the sum. (10)
1 + 1/2 + 1/3 +………….+ 1/n.
8. Explain the following terms with respect to MS-Power point. (2.5x4=10)
a) Slide sorter
b) Clipart
c) Wordart
d) Slideshow