Scribd
Upload
7 views6 pages

Comprehensive Computer Science Guide

The document outlines a comprehensive curriculum covering various aspects of computer science, including characteristics of computers, data processing cycles, software types, and programming languages. It also delves into practical applications of Microsoft Office tools, computer networking, and artificial intelligence, with specific tasks and definitions for each topic. The structure includes multiple units with detailed questions and requirements for elaboration, differentiation, and practical examples.

Uploaded by

sandhyaambati2007
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views6 pages

Comprehensive Computer Science Guide

The document outlines a comprehensive curriculum covering various aspects of computer science, including characteristics of computers, data processing cycles, software types, and programming languages. It also delves into practical applications of Microsoft Office tools, computer networking, and artificial intelligence, with specific tasks and definitions for each topic. The structure includes multiple units with detailed questions and requirements for elaboration, differentiation, and practical examples.

Uploaded by

sandhyaambati2007
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

UNIT 1

1. Elaborate characteristics of Computer? Explain data processing cycle of Computer? (10 Marks)

-- All characteristics with atleast 2 points, data processing cycle with 4 functions atleast 2 points
including diagram.

2. What is Computer? Explain Block diagram of Computer with neat diagram. (10 Marks)

--Definition of Computer, i/p and o/p devices, MU with functions atleast 2 points, ALU, CU, CPU with
atleast 2 points for each.

3. Differentiate input and output devices? Explain each of them with 2 examples. (5 Marks)

-- i/p and o/p devices with functions atleast 3 points, examples-2 only for each

4. Differentiate RAM and ROM. (5 marks)

--RAM and ROM with 4 points

5. Differentiate SRAM and DRAM. Discuss PROM,EPROM and EEPROM.

--SRAM and DRAM with 2 points, give only definitions for PROM,EPROM and EEPROM.

6. Convert 1234 into Binary, Octal and Hexadecimal systems. Convert 1011110101100 into octal,
hexadecimal number systems. Subtract 11011-1100001. Divide 11100001 with 1101 and find quotient
and remainder. (10 Marks)

7. Elaborate briefly System Software and Application Software with their operating systems. (10 Marks)

---Definition of System software and its functions with 3 types of system software with atleast 3 points
for each(if diagram applicable)

--definition of Application software with its tasks and 4 application software only definitions(no
diagrams)

8. Give definition of Computer? (2 Marks)

9. Differentiate Compiler and interpretor. (5 marks) –atleast 5 pionts

10. What are Utility programs? Give examples. (2 Marks)

11. Discuss Speed and Accuracy of Computer. (2 Marks) –only 2 points to write

12. Explain 4th Generation of Computer. (2 Marks)--only 2 points to write

13. Explain CRT Monitor of Computer with neat diagram. (5 Marks)

--diagram with all its specifications including advantages and disadvantages.


14. What is machine language? (2 Marks)

15. Discuss Opcode and Operand and its advantages. (2 Marks)

16. Elaborate program, data and information. (2 Marks)

17. Explain syntax and language. (2 Marks)

18. Differentiate Assembly language and High level language. (2 Marks) –write only 2 points

19. Give any two examples of Input and output devices. (2 marks)

20. Explain control grid and accelerating nodes in CRT Monitor of Computer. (2 Marks)

21. Differentiate SRAM and DRAM. (2 Marks)

22. Differentiate EPROM and EEPROM. (2 Marks)

UNIT 2

1. Elaborate all the six steps in sending invitation to all employees of the institute using Mail Merge
Facility. (10 Marks)

---only discuss all steps in three lines related to given question. Give definition of mail merge first.

2. Discuss in detail all standard tool bars of Microsoft Word like title bar, menu bar, standard tool bar,
status bar, scroll bar, working space, margins. (10 marks)

--all tool bars with definition with 2/3 lines to remember.

3. Discuss Word Wrap and Indentation. Discuss all types of indentation. (5 Marks)

--defintion must with 2/3 lies each

4. Define Margins and four types in Microsoft Office Word. (5 marks)

5. Discuss in detail all standard tool bars of Microsoft Word with its types in Microsoft Office Word. (5
marks).

6. Discuss in detail all formatting tool bars of Microsoft Word with its types in Microsoft Office Word. (5
marks).

7. How to draw a table and line in Microsoft Office Word using Microsoft Office Word. (5 marks).

8. Discuss in detail all drawingg tool bars of Microsoft Word with its types in Microsoft Office Word. (5
marks).

9. Discuss ruler, header and footer in Microsoft Office Word. (2 Marks)


10. How to start Microsoft Office Word. (2 Marks)

11. Explain “Save as”, “Page setup” in Microsoft Office Word. (2 Marks)

12. Explain “Undo”, Repeat” in Microsoft Office Word. (2 Marks)

13. How to merge a cell in a Table using Microsoft Office Word. (2 Marks)

14. How to split a cell in a Table using Microsoft Office Word. (2 Marks)

15. How to add a clipart and picture using Microsoft Office Word. (2 Marks)

16. Differentiate Line Color and Fill color using Microsoft Office Word. (2 Marks)

For 2 marks Qs, write only definitions.

UNIT 3

1. Elaborate all the alignment toolbars of Microsoft Office Excel. (10 Marks)

--in slide 5 of UNIT 3

2. Elaborate all the font toolbars of Microsoft Office Excel. (5 Marks)

--in slide 4 of UNIT 3

3. Discuss Auto sum, Fill, Clear, Sort Filter and Find select options in Microsoft Office Excel. (5 Marks)

4. Elaborate the importance of IF, COUNT, COUNTIF formulas in Microsoft Office Excel. (5 Marks)

---write only definition and formula clearly with explanation

5. Elaborate the importance of BAR chart, PIE chart, Line chart and column chart in Microsoft Office
Excel. (5 Marks)

6. How Sorting is done in Microsoft Office Excel. Discuss sorting data in Ascending order and Descending
order. (5 Marks)

--definition of sorting with example, write steps for Ascending and Descending

7. Give definition of Microsoft Office Excel (2 Marks)

8. How to start Microsoft Office Excel (2 Marks)

9. Elaborate the importance of COUNTIF formula in Microsoft Office Excel. (2 Marks)

10. Discuss ‘Orientation’ and ‘Merge and Centre’ in Microsoft Office Excel. (2 Marks)

11. Discuss ‘Number’ and ‘Accounting’ Format in Microsoft Office Excel. (2 Marks)
12. Discuss percent style, comma style, increase decimal and decrease decimal in Microsoft Office Excel.
(2 Marks)

13. What is cell style in Microsoft Office Excel? (2 Marks)

14. What is Conditional Formatting in Microsoft Office Excel? (2 Marks)

15. How to start Microsoft Office PowerPoint? (2 Marks)

16. How to add a transition to a slide? (4 Marks)

17. How to add a transition and animations to a slide in Microsoft Office PowerPoint? (10 Marks)

--definition with all points related to transition and animations only

18. How create a Table in Microsoft Office PowerPoint? (5 Marks)

--all points related to it.

19. How to add audio and video to a slide in Microsoft Office PowerPoint? (5 Marks)

20. How to create a chart to a slide in Microsoft Office PowerPoint? (2 Marks)

21. How to edit chart data to a slide in Microsoft Office PowerPoint? (2 Marks)

22. How to add smart art and clip art to a slide in Microsoft Office PowerPoint? (2 Marks)

23. How to add a picture to a slide in Microsoft Office PowerPoint? (5 Marks)

UNIT 4

1. Narrate the importance of Computer Network. Discuss in detail all the types of Computer Networks
with neat diagrams wherever necessary. (10 Marks)

2. Briefly elaborate all the networking topologies with neat diagrams. Mention each of their advantages
and disadvantages. (10 Marks)

3. Differentiate Website and Webpage. (5 Marks)

4. Differentiate Static Webpage and Dynamic Webpage. (5 Marks)

5. Explain the need of Computer Network? (2 Marks)

6. Differentiate MAC Address and IP Address. (2 Marks)

7. Define the terminologies of Node, Server, Computer Network, Repeater and Router? (5 Marks)

8. Elaborate Hub with neat diagram. Mention the types of Hub. (5 Marks)

9. Define terminologies of Internet, URL, Webserver and Web browser. (2 Marks)


10. What is Web Hosting? Discuss in detail all the types of Web Hosting? (5 Marks)

11. Define terminologies of Cookies and Add-ons. (2 Marks)

12. Give examples of Search engines. (2 Marks)

13. Give the definition of e-mail. (2 Marks)

14. Narrate the importance of Chat and Voip in Computer Networks? (2 Marks)

15. Give definition of e-mail. Discuss all the four components of e-mail system. (5 Marks)

16. Write advantages and disadvantages of e-mail. (2 Marks) –2 points for each

17. Give examples of LAN, WAN, MAN, PAN. (2 Marks)

UNIT 5

1. What is Artificial Intelligence? Narrate its importance. Give healthcare applications of Artificial
Intelligence. (10 Marks)

--slide 2&3 , give any 4 applications

2. How Artificial Intelligence came into existence? (5 Marks)

--slide 5,6

3. Mention the importance of Logic, problem solving in Artificial Intelligence. ( 2 Marks)

4. Mention the importance of Planning, Learning involved in Artificial Intelligence. (5 Marks)

5. Discuss Data science, NLP, Computer vision in Artificial Intelligence. (5 Marks)

--give definition and 4 imp points related

6. Give advantages and disadvantages of Artificial Intelligence. (5 Marks)

7. what is machine learning? Why machine learning is important. (2 Marks)

8. Narrate all four approaches of Machine Learning with suitable example for each of them. (10 Marks)

9. Narrate types and applications of Reinforcement Learning? (5 Marks)

10. Discuss Linear regression and Logistic regression algorithms in machine Learning. (5 marks)

---definition and how it works and use, pros and cons

11. Give real time example for machine learning (2 marks)

12. Narrate advantages and disadvantages of Machine Learning. (2 marks)


13. Write steps involve in choosing an algorithm. (2 Marks)

14. Write advantages and disadvantages of Reinforcement Learning? (2 Marks)

15. Discuss types of Reinforcement Learning? (2 Marks)

16. Write main points involved in Reinforcement Learning? (2 Marks)

17. Write advantages and disadvantages of Unsupervised Learning? (2 Marks)

18. Discuss Clustering and Association in Unsupervised Learning? (2 Marks)

19. Give example of Unsupervised Learning? (2 Marks)

20. Give the importance of Unsupervised Learning? (2 Marks)

21. What is Decision Tree? Discuss all the terminologies in Decision Tree. (5 Marks)

Common questions

Powered by AI

RAM (Random Access Memory) is volatile memory that temporarily stores data and programs currently in use by the CPU, allowing for quick access and modifications, which enhances performance during active sessions . In contrast, ROM (Read-Only Memory) is non-volatile, designed to permanently store system firmware that does not change, such as bootloader instructions, providing stability and security for fundamental system operations . The volatility of RAM makes it suitable for dynamic tasks where speed is critical, while the permanence of ROM supports essential, unchanging startup processes.

The fourth generation of computers, marked by the development of microprocessors, ushered in significant technological advancements by integrating thousands of transistors onto a single silicon chip . This innovation drastically reduced the size and cost of computers while increasing their power and reliability. Personal computers became feasible, leading to widespread consumer adoption and a revolution in software development, as well as the establishment of modern computing platforms . This era was pivotal in transitioning computing from specialized applications to an essential element of everyday life, enabling subsequent innovations in mobile and internet technologies.

The hexadecimal system, which uses base-16 notation, is instrumental in computing for representing binary-coded values in a more condensed and human-readable form. For instance, the hexadecimal representation of the binary number 1011 1110 is BE . Compared to binary systems, which can be verbose, and octal systems which use base-8, hex efficiently encapsulates large binary values, facilitating easier interpretation and debugging of machine-level instructions, especially in scenarios dealing with memory addresses and color codes in web design or graphics programming .

Reinforcement learning provides significant advantages in real-world applications by enabling systems to learn optimal actions through trial and error, which supports the development of policies that maximize cumulative rewards over time . This method is particularly beneficial in environments where explicit programming is not feasible due to complexity or uncertainty. However, disadvantages include the high computational cost and the extensive amount of data required to train models effectively, making it challenging to apply in environments where real-time processing or immediate results are necessary .

System software acts as a bridge between hardware and user applications, managing hardware operations and providing a platform for running application software. It includes the operating system, device drivers, and utility softwares . In contrast, application software refers to programs designed for end-users to perform specific tasks such as word processing, browsing the internet, or managing data . The core role of system software is to facilitate hardware functionality, while the application software directly aids users in achieving individual tasks.

The mail merge process involves the following steps: (1) setting up the main document, (2) connecting to a data source such as a contact list, (3) inserting placeholders for personalization, (4) previewing the merged document, (5) completing the merge to generate individual documents or emails, and (6) testing before final sending . Each step is crucial as it ensures that the information is correctly personalized for recipients, remains consistent across documents, and is appropriately formatted to fit the communication objectives without manual errors or inefficiencies.

Machine learning involves training algorithms on data sets to identify patterns, enabling them to make decisions with minimal human intervention, unlike traditional programming where explicit instructions are predefined by developers . This difference allows machine learning to adapt and improve automatically with experience, making it ideal for applications where the system needs to predict outcomes or where the data evolves over time . The ability to dynamically learn and adjust is crucial for handling large, complex data sets in modern applications, such as automatic image recognition or predictive analytics.

In machine language, an opcode (operation code) specifies the operation to be performed, such as addition or subtraction . An operand, on the other hand, is the data to be processed or the address where data is located . This delineation allows for the precise execution of instructions by the CPU, improving the efficiency and reliability of computing processes as each instruction can be accurately dissected and implemented, ensuring correct data manipulation . These components are fundamental for low-level programming as they align directly with the machine's hardware capabilities.

A hub is a basic networking device that connects multiple computers in a local network, but unlike switches or routers, it broadcasts data packets to all connected devices . This can lead to network inefficiencies since every device receives every packet regardless of its address, which increases traffic and potential collisions . In contrast, switches and routers direct packets based on MAC or IP addresses, enhancing overall network performance by reducing unnecessary data transmission and improving speed and security.

Static web pages display pre-written content each time they are loaded, providing consistent and stable user experiences without server-side scripting . Dynamic web pages are generated in real-time based on server processing, allowing content to be tailored based on user interactions or data retrieval, making them highly interactive and personalized . The static nature is suitable for information that does not require frequent updates, whereas the dynamic capability of web pages enhances user engagement and functionality by adapting to user inputs or changes in database content.

You might also like