Gauhati University, located in Guwahati, Assam, is one of the prominent educational institutions in Northeast India. It offers a wide range of undergraduate and postgraduate courses to students across various disciplines. The Bachelor of Commerce (BCom) program at Gauhati University is highly regarded for its comprehensive curriculum and focus on practical applications in the business world. In this article, we will explore the Gauhati University BCom 3rd Sem Computer Applications in Business Question Paper for the year 2023, shedding light on its importance and the Questions asked in Examinations.
4 (Sem-3/CBCS) COM SE 1/2/3 2023
COMMERCE
(Skill Enhancement Course)
OPTION-C
GU BCom 3rd Sem
Paper: COM-SEC-3034
Full Mark : 50
Time :- 2
(Computer Application in Business)
1. Choose the correct answer of the following: 1×4=4
তলত দিয়াবোৰৰ পৰা শুদ্ধ উত্তৰটো বাচি উলিওৱা:
(a) Which of the following is a spreadsheet?
তলৰ কোনটো স্পেডছিট?
(i) MS-Word
(ii) MS-PowerPoint
(iii) MS-Excel
(iv) MS-Access
(b) A DBMS software allows the user to create a
এটা DBMS চফটৱেৰ উপভোক্তাৰ এটা কৰিব দিয়ে। তৈয়াৰ
(i) Document
(ii) Sheet
(ii) Database
(iv) SQL
(c) Which of the following gives a logical structure of a database graphically?
তলৰ কোনটোয়ে ডাটাবেছ এটাৰ logical গঠনৰ লেখ প্রদান কৰে?
(i) Entity diagram
(ii) E-R diagram
(iii) SQL
(iv) Database diagram
(d) Which feature of MS-Word helps to create list in a document?
MS-Word ত এটা ডকুমেন্টত কোনটো বৈশিষ্ট্যই তালিকা বনোৱাত সহায় কৰে?
(i) Word Art
(ii) Insert
(iii) Numbers
(iv) Bullets and Numbering
2. Answer the following questions: 2x3=6
তলত দিয়া প্রশ্নবোৰৰ উত্তৰ দিয়া:
(a) Mail Merge
(b) PowerPoint masters
(c) Electronic spredsheet
3. Write short notes on the following: (any two) 5×2=10
তলত দিয়াবোৰৰ ওপৰত চমু টোকা লিখা: (যিকোনো দুটা)
(a) Charts in MS-Excel
(b) Relational Data Model
(c) Applications of Spreadsheets
(d) What is SQL in DBMS?
4. Answer the following questions: (any three) 10×3=30
তলত দিয়া প্রশ্নসমূহৰ উত্তৰ দিয়া: (যিকোনো তিনিটা)
(a) How do you create a chart in a MS-Word document? What are the different methods? 5+5=10
MS-Word ডকুমেন্ট এখনত কেনেকৈ ছার্ট প্রস্তুত কৰিবা? বিভিন্ন পদ্ধতিসমূহ কি কি?
(b) Define Electronic Spreadsheet. Discuss the technique of inserting a formula in a spreadsheet with the help of an example. 4+6=10
ইলেকট্রনিক স্প্রেডছীটৰ সংজ্ঞা দিয়া। এটা উদাহৰণৰ সহায়ত এটা ফৰমূলা স্প্রেডছীটত সুমুৱা কৌশল আলোচনা কৰা।
(c) Briefly discuss the usage of MS-PowerPoint. Mention the basic features of MS-PowerPoint. 4+6=10
MS-PowerPoint-ৰ ব্যৱহাৰ সম্পৰ্কে চমুকৈ আলোচনা কৰা।MS-PowerPoint-ৰ বৈশিষ্ট্যসমূহ উল্লেখ কৰা।
(d) What is database? What is the use of SQL in database? Briefly discuss about SQL statements with example. 2+2+6=10
ডাটাবেছ কি? ডাটাবেছত SQL-ৰ ব্যৱহাৰ কি? উদাহৰণৰ সৈতে SQL statement সমূহ আলোচনা কৰা।
(e) What is E-R diagram? Discuss about the construction of E-R diagram with example. 3+7=10
E-R চিত্র কি? উদাহৰণৰ সৈতে E-R চিত্র গঠন সম্পর্কে আলোচনা কৰা।
(f)What is word processing? Briefly discuss any four features of word processing. 2+8=10
রার্ড প্রছেছিং কি? ৱাৰ্ড প্ৰছেছিংৰ যিকোনো চাৰিটা বৈশিষ্ট্য চমুকৈ আলোচনা কৰা।
******