- computer Science PAPER-I
- Fundamentals, OS, MS Office, Programming with 'C'
- MOST IMPORTANT QUESTIONS
1. What is an Operating System ? Explain its functions. Explain 10 DOS Commands.
2. Explain Block diagram (or) Logical organisation (or) architecture (or) five basic units of a digital Computer.
3. Explain I/O devices.
4. Difference between Static RAM and Dynamic RAM and Primary memory.
5. Difference between MS DOS and WINDOWS.
6. Explain about Locality of Reference.
7. Differences between RAM and ROM.
MS OFFICE
8. What is MS OFFICE ? What are the main features of MS-Office Suite ?
9. What is Mail Merge, how can you connect it to Multiple users ?
10. Explain the following concepts of MS WORD.
a)Tables b)Templates c)Drawing Objects d)Macros
11. Explain the following POWER POINT Basics.
a)Creating a Presentation b)Opening a Presentation c)Creating a New slide d)Deleting a New Slide e)Copying a Slide
12. Write down the procedure to use POWER POINT to develop a slide presentation for the topic "APPLICATIONS OF MS WORD".
13. What is meant by SELECTION OPERATION ? List out all the Selection Operations and give an example for each Operation.
14. What is a Chart ? Explain different types of Charts and give examples.
15. What is a data base ? How can you create a data base in MS ACCESS ? List out the differences between Relational Data Base and Conventional Data Base.
16. Write a Short notes on the following MS ACCESS Concepts.
a)Tables b)Queries c)Forms d)Reports e)Creating graph objects.
C LANGUAGE
17. How single, double dimension ARRAYS are stored in memory ? How POINTERS are involved in accessing Array Elements ?
18. Explain BIT WISE OPERATORS with examples.
19. What is a Recursive Function ? Write a program to find factorial of a given number using Recursion.
20. List the merits and demerits of typedef and enumerated datatypes.
21. Explain different Data types available in 'C'. Explain about various Operators and Expressions. Discuss OPERATOR PRECEDENCE.
22. What are Structures and Unions in C ? List out the Differences.
23. Describe the Syntax of ITERATIVE STATEMENTS of 'C' language with necessary Illustrations. Describe the use of Arrays. Write a program to sort the list of elements using Arrays.
24. Explain FILES Concept in 'C'. Explain about PREPROCESSOR DIRECTIVES.
25. Programs: i)Matrix Multiplication ii)Find whether the given number is prime or not iii)Fibonacci series iv)Illustrating Bitwise ఒపెరతోర్స్
.........................
- Computer Science Paper-II
- C++ and Data Structures
- MOST IMPORTANT QUESTIONS
(or) Explain the advantages of OOP over POP.
(or) Differences between OOP and POP.
2. Explain Various Concepts of OOP.
a)Classes b)Objects C)Inheritance d)Polymorphism e)Data Abstraction f)Message Passing g)Encapsulation h)Virtual functions
3. Explain the terms Private, Public, protected members of a class and how they are accessed?
4. Explain different concepts of Prototyping.
5. Compare and Constrast the structures in 'C' and Classes in 'C++'.
(or) Differences between structures and Classes in C++.
(or) Advantages of Classes over structures.
6. What is Procedural Abstraction(concept of Black Box)? Explain.
7. Explain different control flow mechanisms in C++.
8. Explain the tools for defining ADT.
9. Explain different I/O streams with examples.
10. Programs: a)fibonacci series b)factorial of a given number c)pascal traingle
11. Define an Array. Explain about the NEW and DELETE operators with examples.
12. Explain Constructors and destructors with examples.
13. What is Recursion ? Explain with example.
Programs with recursion: a)factorial of a given number b)sum of 'n' numbers c)fibonacci series
14. Programs: a)Palindrome testing b)Matrix multiplication c)3-d Array
15. What is a pointer ? How it is different from other variables?
Program: Concatenation of two strings using pointers
16. What is a string ? What are the differences between a string and an array ?
17. Explain different string functions? Program to demostrate String Palindrome.
Program:Sorting
18. Explain C++ program having all types of Inheritances.
19. Explain "this pointer" operation in C++.
20. What is a Template? Write any program for Templates.
21. What is a Linked List? Explain different operations and applications performed on Linked Lists.
22. What is a Stack? Explain different operations and applications performed on Stacks.
23. What is a Queue? Explain different operations and applications performed on Queues.
24. What is a Tree? Explain different operations and applications performed on Trees.
25. What is a Graph? Explain DFS and BFS with examples.
Science Fiction Wallpaper # ౫
Those of you with 1920×1200 displays feel my pain. I’ve gotten some compliments on my choices of backdrops, so I thought I would share a few of my sources. Check them out, if, like me, you are blessed with 24 inches.
Plasmadesign.co.uk
My favorite. He has some free ones, but the main stuff you have to pay for with a nominal fee ($10), that gets you lifetime access to the site. New picts are periodically added.
deviantART
What else can I say? Possibly the best repository on the web. Link to Warning: I can’t seem to find any that go beyond 1400×900. Might be a limitation imposed by the site.
HDR Walls
They have a nice collection of High Dynamic Range photos, at high resolutions. It involves shooting multiple times, with different exposures, and layering them to create dramatic lighting effects and saturation. Not all of them are high-def. But some go up to 1920×1200.
Babes & Wallpapers
Some good images and wallpaper (not all of which are widescreen) ripped from various parts of the Interwebs. Oh, and there are some pretty women to look at too.
B.Sc./B.Com. programs with no computer course as core subject
I Year
Theory Paper-1
Introduction to Computers
Unit-1 : Exploring Computers 12 hrs
Exploring Computers and their uses :
Overview: Computers in our world, The computer defined, Computers for individual users, Computers for organizations, Computers in society, Why are computers so important.
Looking inside the computer system:
Overview: Detecting the ultimate machine, The parts of a computer system, The information processing cycle, Essential computer hardware: processing devices, memory devices, Input and output devices, Storage devices, System software, Application software, Computer data, Computer users.
Using the keyboard and mouse:
Overview: The keyboard and mouse, The keyboard, How the computer accepts input from the keyboard, The mouse, Variants of the mouse, Ergonomics and input devices.
Inputting data in other ways:
Overview: Options for every need and preference, Devices for hand, optical input devices, Audio-visual input devices.
Video and Sound :
Overview: Reaching our senses with sight and sound, Monitors, Ergonomics and monitors, Data projectors, Sound systems.
Unit-2 : Storage Devices and Operating System Basics 12 hrs
Printing :
Overview: putting digital content in your hands, Commonly used printers, High-quality printers, Thermal-wax printers, Dye-sublimation printers, Plotters.
Transforming data into information:
Overview: The difference between data and information, How computers represent data, How computers process data, Machine cycles, Memory, Factors effecting processing speed, The computer’s internal clock, The Bus, Cache memory.
Types of storage devices:
Overview: An ever-growing need, Categorizing storage devices, Magnetic storage devices—How data is stored on a disk, How data is organized on a magnetic disk, How the operating system finds data on a disk, Diskettes, hard disks, Removable high-capacity magnetic disks, Tape drivers, Optical storage devices, Solid-state storage devices, Smart cards, Solid-state disks.
Operating system basics :
Overview: The purpose of operating systems, Types of operating systems, Providing a user interface, Running programs, Managing hardware, Enhancing an OS utility software.
Networking Basics :
Overview: Sharing data anywhere, anytime, The uses of a network, Common types of networks, Hybrid networks, How networks are structured, Network topologies and protocols, Network media, Network hardware.
Unit-3 : Data Communications and Computer Programs 12 hrs
Data Communications :
Overview: The local and global reach of networks, Data communications with standard telephone lines and modems, Modems, uses for a modem, Using digital data connections, Broad band connections, Wireless networks.
Productivity Software :
Overview: Software to accomplish the work of life, Acquiring software, Commercial software, Freeware and public domain software, Open-source software, Word processing programs, Spreadsheet programs, Presentation programs, Presenting information managers.
Database management Systems :
Overview: The mother of all computer applications, Databases and Database Management Systems, Working with a database.
Creating Computer programs :
Overview: What is a computer program, Hardware/Software interaction, Code, machine code, programming languages, Compilers and interpreters, Planning a computer program, How programs solve problems.
Programming languages and the programming process:
Overview: The keys to successful programming, The evolution of programming languages, World wide web development languages, The Systems development life cycle for programming.
Unit-4 : MS-Word 12 hrs
Word Basics : Starting word, Creating a new document, Opening preexisting document, The parts of a word window, Typing text, Selecting text, Deleting text, Undo, Redo, Repeat, Inserting text, Replacing text, Formatting text, Cut , Copy, Paste – Formatting Text and Documents : Auto format, Line spacing, Margins, Borders and Shading.
Headers and Footers : Definition of headers and footers, creating basic headers and footers, creating different headers and footers for odd and even pages.
Tables : Creating a simple table, Creating a table using the table menu, Entering and editing text in a table, selecting in table, adding rows, changing row heights, Deleting rows, Inserting columns, Deleting columns, changing column width.
Graphics : Importing graphics, Clipart, Insert picture, Clip Art Gallery, using word’s drawing features, drawing objects, text in drawing.
Templates : Template types, using templates, exploring templates, modifying templates.
Macros : Macro, Record in macros, editing macros, running a macro.
Mail Merge : Mail Merge concept, Main document, data sources, merging data source and main document, Overview of word menu options word basic tool bar.
Unit-5 : Ms-Power Point 12 hrs
Power Point : Basics, Terminology, Getting started, Views
Creating Presentations : Using auto content wizard, Using blank presentation option, Using design template option, Adding slides, Deleting a slide, Importing Images from the outside world, Drawing in power point, Transition and build effects, Deleting a slide, Numbering a slide, Saving presentation, Closing presentation, Printing presentation elements.
Prescribed Books :
1. Peter Norton, Introduction to Computers, sixth Edition, Tata
McGraw Hill (2007) (Chapters 1,2,3,4,5,6,7,10,11,12)
2. Ran Mansfield, working in Microsoft Office, Tata McGraw Hill
2008). (Chapters : 4 to 9, 11, 12, 24, 25, 28)
Reference Books :
1. Michael Miller, Absolute Beginner’s guide to computer Basics,
Fourth Edition, Pearson Education (2007).
2. Deborah Morley, Charles S.Parker, understanding computers today
and tomorrow, 11th edition, Thomson (2007).
3. Ed Bott, woody Leonhard, using Microsoft Office 2007, Pearson
Education (2007).
60 hrs (2 hrs/ week)
For all B.A./B.Sc./B.Com. programs with no computer course as core subject
II Year
Theory Paper-2
Office Automation Tools
Unit-1 : MS EXCEL BASICS 12 hrs
Excel basics : The usual spread sheet features, Overview of excel
features, Getting Started, Creating a new work sheet, Selecting cells, Navigating with the mouse and keyboard, Entering and editing text, text boxes, text notes, checking spelling, undoing and repeating actions, entering and formatting numbers, entering and editing formulas, referencing cells, order of evaluation in formulas, look up tables, copying entries and equations to minimize typing, more auto fill examples, creating custom fill lists, protecting and un protecting documents and cells.
Rearranging worksheets : Moving cells, copying cells, sorting cell data, inserting rows, inserting columns, inserting cells, inserting as you paste, deleting parts of a worksheet, clearing parts of a worksheet, how formulas react to worksheet design changes, Auditing tools help spot potential problems.
Excel formatting tips and techniques : Excel page setup, Changing column widths and row heights, auto format, manual formatting, using styles, format codes alter a number’s appearance, format painter speeds up format copying, changing font sizes and attributes, adjusting alignments, centering text across columns, using border buttons and commands, changing colors and shading, inserting and removing page breaks, hiding rows and columns.
Organizing large projects : Using names, splitting windows and fixing titles, outlining your worksheets, working with multiple worksheets, using multiple worksheets in a workbook, viewing multiple windows, summarizing information from multiple worksheets.
An introduction to functions : Parts of a function, functions requiring add-ins, online functions help, the function wizard, examples of functions by category, error messages from functions.
Unit-2 : EXCEL CHARTS, GRAPHICS AND FUNCTIONS 12 hrs
Excel’s chart features : chart parts and terminology, instant charts with the chart wizard, creating charts on separate worksheets, resizing and moving charts, adding chart notes and arrows, editing charts, rotating 3-D charts, Changing worksheet values by dragging chart parts, printing charts, deleting charts, setting the default chart type, controlling which series on which axis, adding overlay charts, creating trend lines, data map.
Working with graphics in Excel : Creating and placing graphic objects, resizing graphics, positioning graphics on worksheets, drawing lines and shapes, examples of graphics in Excel, possible sources of excel graphics, Excel slide shows.
Introduction to Excel’s command macros : Recording your own macros, running macros, assigning macros to buttons.
Using worksheets as databases : Database concepts and terms, Creating an excel database, Working with data forms, filtering—a better way to find, sorting excel databases, cross-tabulating databases, adding subtotals to databases.
Automating what-if projects : General organizational tips, scenario manager, finding the right number with solver.
Auditing and trouble shooting worksheets : Using error values to locate problems, using iteration to solve circular references, using the info window to find errors, using the auditing command to trouble shoot.
Unit-3 : MS ACCESS BASICS 12 hrs
Introduction to Access : Access concepts and terms, starting and quitting access, the access workspace and tools, the views.
Creating a simple database and tables : The access table wizard, creating databases without the wizard, field names, data types and properties, adding or deleting fields in tables, renaming fields and their captions, moving fields, deleting fields in tables, resizing fields, changing the appearance of text in tables, freezing columns, primary key fields, indexing fields, viewing a list of database properties.
Forms : The form wizard, saving forms, modifying forms.
Entering and editing data : Typing, adding records, duplicate previous entries without retyping, switching out of data entry mode, when do entries get saved?, undo, correcting entries, global replacements, moving from record to record in a table, entry and navigational shortcuts.
Finding, sorting and displaying data : Queries and dynasets, creating and using select queries, returning to the query design, multiple search criteria, finding incomplete matches, using wildcards in queries, requesting range of records, hiding columns, reformatting dynasets, multilevel sorts, showing all records after a query, saving queries for latter use, cross tab queries, find and replace.
Unit-4 : ACCESS REPORTS, FORMS AND GRAPHICS 12 hrs
Printing reports, forms, letters and labels: simple table, form, and database printing, defining advanced reports, manual reporting and modifying, modifying section contents, properties in reports, saving report formats for reuse, printing mailing labels, changing label designs.
Relational databases : Flat versus relational, how relationships work, Exercise: creating a simple relationship, types of relationships, defining and redefining relationships, deleting relationships, creating relationships.
Expressions, macros and other automation : Expressions, using expressions in reports, using expressions in queries, using expressions in forms, expression builders.
Graphics in databases : Objects: linked, embedded, bound and unbound, unbound graphics as form and report embellishments, bound graphics in records, adding graphics to buttons, chart wizard: charting your data.
Linking, importing and exporting records : Importing versus linking, linking other databases as tables, importing data from spread sheet files, importing data from word files, exporting access data.
Unit-5 : FUNDAMENTALS OF INTERNET 12 hrs
The Internet and the World Wide Web : Overview: what is Internet, The Internet’s history, The Internet’s major services, Understanding the world wide web, Using your browser and the world wide web, navigating the web, closing your browser, getting help with your browser, searching the web, search results and web sites.
E-mail and other Internet Services : Overview: communicating through the Internet, Using E-mail, Using an E-mail program, Stomping out spam, Using web-based e-mail services, More features of the Internet.
Connecting to the Internet: Overview: Joining the Internet phenomenon, Connecting to the Internet through wires, How PC applications access the Internet, Connecting to the Internet wirelessly.
Doing business in the online world : Overview: commerce on the world wide web, E-commerce at the consumer level, E-commerce at the business level, Business, the Internet and every thing, Telecommuters.
Prescribed books:
1. Ron Mansfield, Working in Microsoft office, Tata McGraw Hill (2008)
(chapters 13 to 23 and 29 to 38)
2. Peter Norton, Introduction to computers, Sixth Edition Tata
McGraw Hill (2007)(Chapters 8A, 8B, 9A, 9B).
Reference Books :
1. Michael Miller, Absolute Beginner’s guide to computer Basics,
Fourth Edition, Pearson Education (2007).
2. Deborah Morley, Charles S.Parker, understanding computers today
and tomorrow, 11th edition, Thomson (2007).
3. Ed Bott, woody Leonhard, using Microsoft Office 2007, Pearson
Education (2007).
4. Rajkamal, Internet and web Technologies, Tata McGraw Hill(2007).
Model Question Paper
General Stream B.A./B.Com./B.Sc.: I Year: Theory Paper-1
Introduction to computers
Time 3Hrs Max. Marks: 100
Section-A
Answer all the following questions. 10 * 2 =20 Marks
1.
a) Define a protocol.
b) What is broadband technology?
c) What are translators?
d) Give some examples for application soft wares.
e) What is the difference between “paste” and “paste special”?
f) What are hot keys?
g) What is a hub?
h) What are device drivers?
i) What is a control panel?
j) What is the use of storing data in registers?
Section-B
Answer all the following questions. 5 * 16 = 80 Marks
2. a) Classify the computers according to their size and
functionality.
b) Explain different types of storage devices necessary for
backup.
(or)
c) Discuss in brief different input devices available.
d) Draw the block diagram of a computer and explain it.
3. a) What is an operating system? Explain different types of
operating systems?
b) Discuss the minimum hardware needed for networking.
(or)
c) What are the different impact printers available?
d) Discuss the functionality of data bus and address bus.
4. a) What is the role played by wireless technology in networking?
Discuss the hardware needed for wireless networking.
b) Discuss the various ways of obtaining software in brief.
(or)
c) What is a computer language? Explain different types of
computer languages.
d) Discuss the steps involved in developing a program. Also,
discuss how programs solve problems.
5. a) Explain different parts of a word window. Draw a neat diagram
depicting the Various entities.
b) What are headers and footers? Explain in detail the procedure
to create headers and footers.
(or)
c) Discuss the functionalities of a word processor.
How far M.S. Word accomplishes those features? (6M)
d) What are the various views of a word window? (5M)
e) Discuss the various ways of drawing tables in word. (5M)
6. a) How can we give animation effects for the objects in power point?
b) What is the importance of slide master view in power point?
(or)
c) How auto-content wizard eases the way to create presentations?
d) What are design templates? Also, discuss how can we import a
slide from an Outside presentation.
* * * * *
Model Question Paper
General Stream B.A./B.Com./B.Sc.: II Year: Theory Paper-2
Office Automation Tools
Time: 3Hrs Max.Marks:100
Section-A
Answer all the following questions. 10*2=20 Marks
1.
a) How can we add ‘n’ number of worksheets with a single click?
b) How are browsers and the WWW associated with each other?
c) List out the different ways of viewing a query.
d) What is a modem?
e) What is the difference between E-commerce and Web commerce?
f) Distinguish between front end and back end tools with examples.
g) What are the different possible extensions for an Excel worksheet?
h) How can we use the format painter?
i) List out some of the operators used in Excel.
j) What is bandwidth?
Section-B
Answer all the following questions. 5 * 16 = 80 Marks
2) a) Explain the engineering functions used in excel with examples.
b) Explain the excel workspace with a neat diagram.
(or)
c) Explain Auto filling dates, numbers and strings in Excel.
d) Discuss some of the formatting features of excel.
3) a) How can we perform “What-if” analysis in Excel?
b) Explain the different types of charts available in Excel.
(or)
c) What is the use of macros in excel?
d) How can we detect and avoid circular references in excel?
4) a) Discuss the different ways of creating forms in Access.
b) Explain the important features of M.S. Access.
(or)
c) How can we retrieve the data stored in database?
d) Write procedure to establish relationships in Access.
5) a) Describe the following terminology:
(i) Database management system
(ii) Primary key
(iii)Dynasets
(iv) OLE.
b) Explain working with graphics in Access.
(or)
c) Discuss in brief about linking between databases.
d) How can we export our own data base.
6) a) How can we search for the content present in www?
b) Explain different applications of Internet in brief.
(or)
c) Describe the working of e-mail system.
d) Discuss the pros and cons of E-commerce compared with
traditional commerce.
* * * * *
No comments:
Post a Comment