Application Package
- Why is excel also known as spreadsheet or worksheet? Explain it with respect to the following: worksheet, graphics, and database management system.
- What is meant by word processing and slide presentation?
- Discuss the difference between word processing and data processing.
- Why mail merge is considered as an important feature in MS word? Explain with its advantages.
- Why MS Access is considered as RDBMS? Explain different objects of MS ACCESS.
- Explain importance and use of Hyperlinks in Ms-Word documents.
- What are workbooks and worksheets in Ms-excel?
- What is pivot table? What role does it play in spreadsheet management?
- Write any five mathematical functions in Ms-excel with example.
- What do you mean by presentation? Why Ms PowerPoint is considered as powerful tools for this purpose in comparison to Ms-word or Ms-excel.
- Why Ms-access is considered as RDBMS? Explain how we create a report.
- Explain about the features of word processing software.
- Define worksheet? Explain how excel helps in data analysis.
- What do you mean by pivot table? What are its uses and applications?
- What is Ms-PowerPoint? Explain the importance of presentation in modern business scenario?
- Explain about the features of Ms-Word.
- What is PowerPoint? Mention the types of transition that are usually used in PowerPoint.
- Explain the importance of templates and hyperlinks in Ms-Word documents.
- What are relative and absolute cell references in Ms-Excel? Define formula and function in MS-Excel.
- What is pivot table in Ms-Excel? How can MS-Excel be the best software for managers in any business organizations for data management purpose?
- What is Ms-word? Explain the importance of MS-Power point interactive presentation?
- Discuss the functions of mail merge in Ms-word.
- What is master slide? Discuss the application of master slide option in MS PowerPoint.
- What do you mean by workbook, worksheet and cell in term of spreadsheet? Also, discuss about chart in worksheet.
- Define header and footer. Why is it important to create header and footer?
Operating System
- What is operating system? Explain the features of operating systems.
- What is operating system? Explain different types of operating system with examples.
- Explain why GUI operating system is more popular than text based (CUI) operating system.
- What is disk operating system (Dos)? Write its features.
- What is windows operating system? Write its features.
- What is booting? Explain different types of booting.
- What is command? Explain different types of command.
- Explain the concept of open source operating system?
- “operating system software is the interface between user and application software.” Justify.
- Write short notes on: a) UNIX b) LINUX c) File and Directory d) Spooling e) Buffering f) Process
Programming Concepts and Logics
- What is programming languages? Explain the types of programming languages with merits and demerits.
- What is language processor? Explain briefly the different language processor.
- What is programming? Differentiate between compiler and interpreter.
- Explain the different program control structure with their use and example.
- What are the program design tools? Describe different types of program design tools.
- Define program and software? Differ between program and software.
- What is program logic? What are the symbols used to draw the flowchart.
- Differ between flowchart and algorithm with suitable example.
- What is flowchart? Differ between program flowchart and system flowchart.
- What are the characteristics necessary for programming to be considered as a high-level language?
Database
- What is data processing? Discuss some operations of data processing.
- What is sequential file processing? Explain its advantages and limitations. What is random file organization? Explain its advantages and disadvantages.
- What is database management system? Explain its advantages and disadvantages. Write some applications areas of DBMS.
- What is data model? Explain its advantages and disadvantages. What is keys? Explain different types of keys with example.
- What is database language? Explain DDL and DML.
- What is RDBMS? Explain.
- What is differ between a database and DBMS?
- In a database table, what does each column represent?
- Explain the various steps in data processing.
- What do you mean by ER diagram? Explain the various symbols used in ER model.
- Describe the various functions of DBMS.
- What do you mean by DBMS? Explain the components of a DBMS.