Bca 1st Semester Solved Assignment In Excel

BCS-011 COMPUTER BASICS AND PC SOFTWARE IGNOUE SOLVED ASSIGNMENT

IGNOU BCA 1st Semester Solved Assignments for January-June 2017 session is now available here at absolutely free of cost .

We have added BCS-011 COMPUTER BASICS AND PC SOFTWARE solved assignments and remaining assignments will be added as soon as possible.

You can easily download these assignments from below given links and start writing on notebook.

 

Course Code : BCS-011 Course

Title : Computer Basics and PC Software

Assignment Number : BCA (1)-011/Assignment/16-17

Maximum Marks : 100

Weightage : 25%

Last Dates for Submission : 15th October, 2016 (For July 2016 Session) 15th April, 2017 (For January 2017 Session)

This assignment has three questions of 80 marks. Answer all the questions. Rest 20 marks are for viva voce. You may use illustrations and diagrams to enhance explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation. Please give precise answers. The word limit for each part is 200 words.
Question 1: (Covers Block 1)
(7×4=28 Marks)
(a)
A person has written a program for analysis of data. The program and data are available in written form with the person. List steps of activities that the person will have to follow to run the program on the data using a Computer. Also, explain the function of each component of a computer.
(4 Marks)
(b)
What is RAM in the context of computer? Why is it needed? What is SRAM and its role in a computer? A computer has primary memory still it requires hard disk, why? Explain the storage organization of a Hard disk and access time for it.
(4 Marks)
(c)
Convert the following numbers as directed
(i) Decimal 325.6125 into binary and hexadecimal
(ii) Decimal 32768 into hexadecimal and binary
(iii) Character s and T to ASCII and Unicode
(iv) Hexadecimal AAA1 to decimal and binary
(4 Marks)
(d)
A 2 inch disk has 8 recording surfaces (4 plates), this disk has 512 tracks with each track having 512 sectors of 512 bytes each. Calculate the capacity and recording density for the disk. This disk rotates at a speed of 6000 rpm and has an average seek time of 10ms; what will be the average access time of the disk?
(4 Marks)
(e)
Compare and contrast the following printing technologies
(i) Impact versus non-impact printer
(ii) Inkjet versus Laser printer
(iii) Character versus dot matrix printers
(iv) Line printers versus page printer
(4 Marks)
4
(f)
Explain the characteristics/functions of any four input devices.
(4 Marks)
(g)
Explain the uses of following Software: (i) Disk backup (ii) Disk management (iii) Disk Checker (iv) System restore
(4 Marks)
Question 2: (Covers Block 2)
(7×4=28 Marks)
(a)
What is cloud Computing? Explain with the help of an example. What are the features, advantages and disadvantages of cloud computing? Differentiate between cloud computing and Internet based architecture.
(4 Marks)
(b)
Explain the features and uses of the following computer software:
(i) Anti-virus programs
(ii) Debuggers
(iii) Device drivers
(iv) Multimedia Authoring applications
(4 Marks)
(c)
What is the need of Operating system for a Computer System? Explain the file management, I/O Management and memory management in the context of Operating system with the help of an example.
(4 Marks)
(d)
Differentiate between the following
(i) Process and Thread
(ii) Serial Processing and Simple Batch processing
(iii)Timesharing and Multiprogramming operating systems
(iv) Unix and Windows
(4 Marks)
(e)
Draw a flow chart and write an algorithm for a program that adds 10 even numbers starting from 2. (You must use looping).
(4 Marks)
(f)
Define the following terms in the context of programming with the help of an example:
(i) Data Types
(ii) Arrays
(iii)Subroutines and functions
(iv) Logical and relational operators
(4 Marks)
5
(g)
Explain the following with the help of an example/diagram, if needed:
(i) Open Source Software Licensing
(ii) Timesheet Management
(iii) Use of Primary Key in a table of a database
(iv) Use of chart and macros in MS-Excel
(4 Marks)
Question 3: (Covers Block 3)
(6×4=24 Marks)
(a)
What are the advantages of using computer Networks? What is a twisted pair cable? What are its characteristics? Compare and contrast the features of twisted pair cable to optical fiber cable in the context of data transmission.
(4 Marks)
(b)
A company has one single office building having about 1000 rooms in a city from where it controls all its operations. What kind of network the company should make for its office? The company makes about 100 dealers all over the county; what kind of network company should make to communicate with dealers? Justify your answer.
(4 Marks)
(c)
Explain the concept of DNS. Explain the components of an IP address with the help of an example. What is the significance of network mask? Explain with the help of an example.
(4 Marks)
(d)
Explain the functioning of a search engine. You want to identify the latest developments in the area of Internet. Make a search phrase which may give you good result.
(4 Marks)
(e)
List major security threats while using email, chat and social networking. How can you reduce the risk due to these threats?
(4 Marks)
(f)
Explain the following in the context of Internet and its applications, giving their features and uses:
(i) E-learning
(ii) Social Networking

 

Click Below to download

BCS-011 COMPUTER BASICS AND PC SOFTWARE

BCS-011 Computer Basics and PC Software Solved assignment 2017 Ignousolvedassignments.com by raviasdoga on Scribd

 

Click Below to download

BCS-011 COMPUTER BASICS AND PC SOFTWARE

Did you like this? Share it:

Tweet

Algebra Teaching Tips

Itm Assignment Doc Integrative Studies In Social Sciences

Solving Linear Equations Using Substitution

Online Statistics Problem Solver

Unbalanced Assignment Problem Ms Excel Solver

Java Practice Assignment Walkthrough

The Model Behind The Scene Overview Or Tools User S Manual

Get Help Algebra Homework

Assignment Mathematical Optimization

Organic Chemistry Help Online For Any Student Needing Help

Welcome To Math Assignment Experts Math Assignment Experts

How To Solve Assignment Problem Hungarian Method Simplest Way

Aiou Solved Assignment Code Statistics Aiou Assignments

How To Set Up A Linear Optimization Problem Using Excel Solver

Assignment Accounting

Mathematics Assignment Experts Usa In Classifieds

Math Homework Assignment

Step By Step Tutorial Of Session Sports Aerodynamics

Upload Your Assignment And Let Us Solve It For You

Solve Calculus Homework Help Employment Law Essays

0 Replies to “Bca 1st Semester Solved Assignment In Excel”

Lascia un Commento

L'indirizzo email non verrà pubblicato. I campi obbligatori sono contrassegnati *