Computer Applications for Economics

Computer Applications for Economics

Course: Skill Enhancement Course
Time: 2 Hours
Semester: 1st
Session: February 2025
Course Code: ECO122S
Maximum Marks: 50
Minimum Marks: 18

---

SECTION A: Short Answer Type Questions (Answer all questions in a maximum of 20 words each.) (8 × 1 = 8 Marks)

Q1.
I. Define an operating system?
An operating system (OS) is system software that manages computer hardware and software resources, enabling communication between the user and the device.

II. What is computer LAN?
LAN (Local Area Network) is a network that connects computers within a limited area like a home, school, or office.

III. What is a spreadsheet?
A spreadsheet is a software tool used for organizing, analyzing, and storing data in tabular form, such as Microsoft Excel.

IV. Briefly define DBMS?
A Database Management System (DBMS) is software used for storing, retrieving, and managing data in databases efficiently.

V. Define PowerPoint?
Microsoft PowerPoint is a presentation software used to create slideshows incorporating text, images, animations, and multimedia.

VI. What is a cell?
A cell is the smallest unit in a spreadsheet, where data is entered, stored, and manipulated.

VII. What is a chart?
A chart is a graphical representation of data used to analyze trends and relationships, commonly found in spreadsheet applications.

VIII. Define Windows?
Windows is a widely used operating system developed by Microsoft, providing a graphical interface for personal and business computing.

---

SECTION B: Medium Answer Type Questions (Answer all four questions with internal choice in a maximum of 150 words each.) (4 × 5 = 20 Marks)

Q2. What is the Internet? What are the various applications of the Internet in the modern world?
The Internet is a global network that connects millions of computers and devices, enabling communication and information sharing worldwide. Its applications include:

1. Communication – Email, social media, and instant messaging.
2. Education – E-learning platforms, online courses, and digital libraries.
3. E-Commerce – Online shopping, banking, and digital transactions.
4. Entertainment – Streaming services, gaming, and online media.
5. Research – Access to vast knowledge repositories and collaborative tools.
   The Internet plays a crucial role in modernizing industries and improving global connectivity.

OR

What is MS Word? How to create a document and insert a table in it?
Microsoft Word is a word-processing application used for creating and editing documents. To create a document and insert a table:

1. Open MS Word and click on New Document.
2. Type content or format as needed.
3. Click on Insert → Table, choose the desired number of rows and columns.
4. Enter data into the table and format it using table tools. Tables help in organizing data efficiently within a document.

Q3. Discuss various layouts of PowerPoint presentations.
PowerPoint provides multiple slide layouts to arrange content efficiently:

1. Title Slide – Used for the presentation title and subtitle.
2. Title & Content – Contains a title with a content area.
3. Two Content – Used for comparison-based slides.
4. Picture with Caption – Includes an image with descriptive text.
5. Blank – A customizable slide with no predefined structure.
   These layouts help in organizing information effectively.

OR

What is a PowerPoint Presentation? Discuss various steps for creating a PowerPoint Presentation.
A PowerPoint Presentation is a slideshow created using Microsoft PowerPoint. Steps to create a presentation:

1. Open PowerPoint and select a blank or template slide.
2. Add slides and choose layouts as required.
3. Insert text, images, and multimedia elements.
4. Apply animations and transitions for a dynamic effect.
5. Preview and save the presentation.
   PowerPoint is widely used for business, education, and training presentations.

Q4. What is Microsoft Excel? What are its features and uses?
Microsoft Excel is a spreadsheet application used for data analysis and visualization. Its features include:

1. Data Organization – Cells, rows, and columns for structured data entry.
2. Formulas & Functions – Built-in mathematical and statistical functions.
3. Charts & Graphs – Data visualization tools.
4. Sorting & Filtering – Helps in data analysis and categorization.
5. Pivot Tables – Summarizes large datasets effectively.
   Excel is used in finance, business analytics, education, and research.

OR

What are fields, records, and files in a database, and how are they related?

• Fields represent individual data attributes (e.g., Name, Age).
• Records are a collection of related fields (e.g., a student's details).
• Files store multiple records, forming a structured database.
  Fields, records, and files together enable data organization in a structured manner.

Q5. What are spreadsheets? Discuss the working of spreadsheets.
Spreadsheets are software applications used for data entry, calculations, and visualization. They consist of:

1. Cells, Rows, and Columns – The basic structure for data storage.
2. Formulas & Functions – Automates calculations like SUM, AVERAGE, etc.
3. Conditional Formatting – Highlights specific data patterns.
4. Data Sorting & Filtering – Helps in organizing large datasets.
   Spreadsheets are used in accounting, finance, and scientific analysis.

OR

What is a database? Discuss features of MS Access.
A database is a structured system for storing and managing data efficiently. MS Access features include:

1. Tables – Stores structured data.
2. Queries – Helps in searching data.
3. Forms – Provides user-friendly data entry interfaces.
4. Reports – Generates formatted output for analysis.
5. Relational Database Management – Connects multiple tables efficiently.
   MS Access is widely used for managing business and academic databases.

---

SECTION C: Long Answer Type Questions (Answer only two questions in a maximum of 300 words each.) (2 × 11 = 22 Marks)

Q6. Explain in detail the concept of Microsoft Windows and its various components. Mention the names of various versions Windows has gone through since its launch.
Windows is an operating system developed by Microsoft, providing a graphical interface for computers. Key components include:

• Desktop – Primary workspace for accessing files and applications.
• Taskbar – Displays open applications and system controls.
• File Explorer – Manages files and folders.
• Control Panel – Settings for hardware, software, and security.

Versions of Windows: Windows 95, 98, XP, Vista, 7, 8, 10, and 11.

Q7. What type of charts can be inserted in Excel, and write down the stepwise process of inserting a chart in a spreadsheet?
Excel allows inserting bar charts, pie charts, line graphs, and scatter plots. Steps to insert:

1. Select data.
2. Click Insert → Chart.
3. Choose the chart type and customize.