BCCA Bachelor of Commerce ( Computer Applications ) First Semester
University Syllabus Course and Classes For BCCA First Semester New Pattern 2019-20 onwards. Old First Semester 2016-17 onwards pattern syllabus is in this page after New 2019-20 syllabusAtlanta Computer Institute Nagpur conducts Tuition Classes for BCCA First Semester Second Semester Third Semester Fourth Sem Fifth Sem Sixth Semester for all universities in India . The Following syllabus is of Nagpur University. Final Year Projects Training is also given to BCCA Students. Practicals are also taken.
RTMNU BCCA New Semester pattern Syllabus 2019-20 onwards
Paper – I
Course name - English and Business Communication – I
( New 2019 -20 Onwards )
Course code - 1T1
UNIT I
A. Comprehension of an Unseen Passage
B. Enriching Vocabulary: Synonyms and Antonyms, Single Word for a Group of Words, Change of Word from Noun to Adjective &vice-versa.
UNIT II
Business Correspondence: Application for Employment, Job Offer Letters, Sales letters, Claim and Adjustment Letters
UNIT III
Communication Process: Sender, Channel, Message, Receiver and Response
Types of Communication:
a. According to mode: a. Oral b. Written
b. According to Medium: a. Electronic b. Print
c. According to number of participants: a. Dyadic b. Group
d. According to Direction: a. One-way b. Two-way
e. According to Purpose: a. General b. Business(Specific)
UNIT IV
Textbook entitled ‗Prism: Spoken and Written Communication, Prose & Poetry‘ published by Orient Black Swan
Prose
i) With the Photographer – Stephen Leacock
ii) Socrates and the Schoolmaster – F. L. Brayne
iii) Speech on Indian Independence – Jawaharlal Nehru
Poetry
i) On Television - Roald Dahl
ii) The Felling of the Banayan Tree – Dilip Chitre
iii) Stay Calm - Grenville Kleiser
Reference Books:
(For UNIT I)
i) English Grammar – N.D.V. Prasada Rao (S.Chand) 36
ii) Developing Communication Skills – Krishna Mohan & Meera Banerji (Macmillan
(For UNIT II)
i) Business Communication: Urmila Rai, S.M. Rai- (Himalaya Publishing House)
ii) Business Correspondence and Report Writing – R. C. Sharma& Krishna Mohan (Tata McGraw-Hill)
iii) Developing Communication Skills – Krishna Mohan & Meera Banerji (Macmillan)
(For UNIT III)
i) Business Communication and Management- Dr. K.R.Dixit (Vishwa Publishers, Nagpur)
(For UNIT IV)
Prescribed Text Book :
i) Prism: Spoken and Written Communication, Prose & Poetry published by Orient BlackSwan
Paper - II
Course Name - Financial Accounting ( New 2019-20 onwards )
Course code -1T2
UNIT – I
Accounting Concepts:- Introduction, Accounting Concepts and Conventions, Generally Accepted Accounting Principles(GAAP), Conceptual Basis of a Balance Sheet, Capital and Revenue Income and Expenditure, Indian Accounting Standards AS 1 to AS 10.
Mechanics of Accounting:- Introduction, Classification of Accounts, Double Entry System, Overview of Accounting cycle, Preparing journals, Subsidiary Books, Ledger, Preparation of Trial Balance (Theory & Numerical)
UNIT – II
Preparation of final Accounts of Sole Traders :- Introduction, Describe format of P & L Account, Format of Balance Sheet, Treatment of Adjustments, The components of a set of final accounts for a sole trader. Prepare Trading Account, Profit & Loss Account and Balance Sheet (Theory & Numerical)
UNIT – III
Valuation of Goodwill – Meaning and need for valuation of goodwill, Feature of goodwill, Factors influencing valuation for goodwill, Average profit method (Future 37
maintainable profit method), Weighted average profit method, Super profit method, Capitalization method, Annuity Method. (Theory & Numerical)
UNIT – IV
Consignment Accounts :- Meaning, Needs, Advantages and formalities in consignment, difference between a consignment and a sale, Performa invoice, Account sales, Accounting procedure of consignment, valuation of consignment stock (Theory & Numerical)
Reference Books:
1. M.N. Arora, K.V.Achalapati, S.Brinda, Finiancial Accounting, Taxmann
2. M. Hanif, A. Mukherjee, Financial Accounting, McGraw-Hill.
3. N. Ramachandran, Ram Kumar Kakani, Financial Accounting for management,
McGraw-Hill.
4. Dhanesh K Khatri, Accounting for Management, McGraw-Hill.
5. Shukla, M.C., T.S. Grewal and S.C.Gupta. Advanced Accounts. Vol.-I. S. Chand & Co., New Delhi.
6. S. N. Maheshwari, Financial Accounting, Vikas Publication, New Delhi.
7. T.S, Grewal, Introduction to Accounting, S. Chand and Co., New Delhi
8. P.C. Tulsian, Financial Accounting, Tata McGraw Hill, New Delhi
9. Dr. Pramod Fating, Dr. Vijay Bagde, Dr. Sarang Javkhedkar, Dr. Milind Gulhane – Financial Accounting - Sir Sahitya Kendra, Nagpur
10. Dr. K. Karemore, Dr. Vijay Bagde, Dr. Tekade, Prof. G. Khorgade, Dr. T Chaudhari – Financial Accounting - Sir Sahitya Kendra, Nagpur
Paper - III
Course Name - Fundamentals of Computer ( New 2019-20 Onwards )
Course Code – 1T3
UNIT – I
Understanding the Computer:- Introduction, Evolution, Generation, Classification and Application of computers. Memory and Storage Systems: Introduction, Memory representation, Random Access Memory, Read Only Memory, Storage systems, Magnetic storage systems, Optical storage systems, Magneto optical system, Solid-state storage devices. 38
UNIT – II
Input Devices: Introduction, Keyboard, Pointing devices, Scanning devices, Optical recognition devices, Digital camera, Voice recognition system, Data acquisition sensors, Media input devices. Output Devices: Introduction, Display monitors, Printers, Impact printers, Non-impact printers, Plotters, Voice output systems, Projectors, Terminals. Computer Codes: Introduction, Decimal system, Binary system, Hexadecimal system, Octal system, Conversion of numbers
UNIT – III
Computer Software: Introduction, Types of computer software, System management programs, System development programs, standard application programs. Programming Languages: Introduction, History of programming languages, Generations of programming languages, Characteristics of good programming languages, Developing a program, Running a program.
Data Communication and Networks: Introduction, Data communication using modem, Computer network, Network topologies, Network protocol and software, Application of network.
UNIT – IV
Operating Systems: Introduction, History of operating systems, Functions of operating systems, Process management, Memory management, File management, Device management, Security management, Types of operating systems, Providing user interface, Popular operating systems. Microsoft Software: Introduction, MS-DOS, MS Word systems, MS Excel systems, MS PowerPoint systems, MS Access systems,
Text Book:
1. E Balagurusamy, Fundamentals of Computers, Mc Graw Hill Education.
Reference Books:
1. Dr. Rajiv Midha, S. Brinda, Fundamental of Information Technology, Taxmann.
2. Madhulika Jain, Shashank Jain, Satish Jain, Information Technology Concepts, BPB Publication.
3. Dr. Rajiv Midha, Information Technology, Taxmann 39
4. B. Ram, Computer Fundamentals (Architecture & organization), New Age International Publisher.
5. Turban, Rainer, Potter, Introduction to Information Technology, Wiley India Edition.
6. Sanjay Saxsena, Introduction to Information Technology, Vikash Publishing House Pvt.Ltd.
7. Dr. Sushila Madan, Information Technology, Taxmann.
Paper - IV
Course Name – Programming in ‘C’ ( New 2019-20 onwards )
Course Code – 1T4
UNIT – I
Data Types, Operators and some statements: Identifiers and keywords, Constants, C Operators, Type Conversion. Writing a Program in C: Variable declaration, Statements, Simple C Programs, Simple Input Statements, Simple Output Statements. Control Statements: Conditional Expressions, Loop Statements, Breaking control statements.
UNIT – II
Functionsand Program Structures:Introduction, Defining a Function, Types of User Defined Functions,Return Statement, Actual & Formal Arguments, Local & Global Variables, Scope of Variables, Recursive Functions.Arrays:One dimensional array, Array Declaration, Array Initialization, Two dimensional array, Declaration and initialization of two dimensional array, multidimensional array, Character array and Strings functions.
UNIT – III
Pointers: Pointer Declaration, Pointer Arithmetic, Pointers and Functions, Pointers and Arrays, Pointer and Strings, Array of Pointers, Pointers to Pointers. More on Functions: Pre-processors, Macros, Header Files, standard Functions.
UNIT-IV
Structures, unions and File handling:Declaration of Structure, Initializing a Structure, Array of Structure, Arrays within Structure, Pointer and Structure, 40
Union.Data File Operations: Review of input/output Functions, Opening and Closing of files, Simple File Operation, Structures and File Operation, Block Read/Write, More on File operations, Random Access File processing.
Text Book:
1. D. Ravichandran, Programming in C, New Age International Publishers.
Reference Books:
1. E. Balaguruswami, Programming in ANSI C,McGraw-Hill.
2. R Subburaj, Programming in C, Vikash Publishing House Pvt. Ltd.
3. S.K.Shrivastava&Dipali Srivastava, C in Depth, BPB Publication.
4. YashwantKanetkar, Let Us C, BPB Publication, 9th Edition.
5. Veugopal Prasad, Mastering C, McGraw-Hill.
6. Schildt, The Complete Reference C, McGraw-Hill.
BCCA Part – I Semester – I ( Old 2016-17 pattern)
Paper -I: English – I (Communication Skills) ( Old 2016-17 onwards )
UNIT – I
Language as Skill of Communication, Phonetics, Articles, The Proposition, Tenses, Subject-Verb Accord, The Infinitive, The Participle, Clauses, Degrees of Comparison, Transformation of Sentences, Direct and Indirect Speech.
UNIT – II
Modifiers, Sentence Connectives, The Gerund, Punctuation and Capitalization, Vocabulary, Use of Abbreviations, Correct Usage, Differentiating the Pairs of Words, Eponym, Concord, Homophones, Letter Writing.
UNIT – III
Paragraph Writing, Proposal Writing, Verbal Communication, Oral Presentation, Technical Written Communication, Forms of Technical Writing, Report Writing, Advertising, Precis Writing.
UNIT – IV
Collections of Short Essays, Collections of Short Stories, Interview Skills and Group Discussion, Communication : Process & Elements, Reading Comprehension, Principle
of Public Speaking, How to Create a Power Presentation, Speaking Skills, Listening Skills.
Text Book:
1 Er. A. K. Jain, Dr. Pravin S. R. Bhatia, Dr. A. M. Sheikh, Professional Communication Skills, S. Chand.
Reference Books:
1. Tracy Bretag, Jaonna Crossman, Sarbari Bordia, Communication Skills, McGraw-Hill.
2. Dr. S. S. Narula, Personality Development & Communication Skills,Taxmann.
3. Anne Eisenberg, ABeginner‘s Guide to Technical Communication, McGraw-Hill.
Paper -II: Financial Accounting ( Old 2016-17 Pattern )
UNIT – I
Introduction to Financial Accounting: Accounting as an information system, Financial, cost and management Accounting and their interrelationships, Finance Function and
Accounting, Accounting as an academic Discipline, Accounting as an Career and Profession, Place of Accounting Officers in the Organization, Auditing and Internal Control, Ethical Issues in Accounting, Forms of Organizations and Their Effect on
Accounting, Accounting and Corporate Governance. Accounting Concepts, Standards and IFRS: Introduction ,Accounting Concepts and Convention, Accounting Policies,
Generally Accepted Accounting Principles(GAAP), International Financial Reporting Standards(IFRS),Indian Accounting Standards(Ind AS),India‘s Road map to Convergence with IFRS, Indian Government Accounting Standards(IGAS).
Presentation of Financial Statements: Balance Sheet: Conceptual Basis of a Balance Sheet, Capital and Revenue Expenditure and receipts, Classification of Item on a Balance sheet, Format of Balance Sheet, Balance Sheet Equation, Preparing Balance Sheet.
UNIT – II
Preparation of final Accounts: The Income Statements: Introduction, Format of Profit and Loss Account, Profit and Loss account of a Manufacturing Concern, Appropriation of Profit, Advantages of Profit and Loss Account. Mechanics of Accounting: Introduction, Classification of Accounts, Double Entry System, Overview of Accounting cycle, Preparing journals, Subsidiary Books, Ledger, Preparation of Trial Balance, Accounting Errors and Their Rectification, Bank Reconciliation statement (BRS), Computerised Accounting. Fixed Assets and Depreciation Accounting: Introduction, Cost of Fixed Assets, Depreciation, Method of computing depreciation, Accounting Treatments for transactions, Impairment of Assets.
UNIT – III
Inventory Valuation: Introduction, Record Keeping for Inventory, Perpetual inventory System, Inventory Valuation/Measurement, Methods of Valuation of Inventories, Analysis of Inventories. Corporate Accounts: Introduction to Companies, Types of Companies, Shares and Share Capital, Issue of Shares. Share Issue: Payments in Installment, Buyback of Shares, Debentures and Bonds, Income Statement/Profit and Loss Account, Balance Sheet, Company Annual Report. Cash Flow Statement: Introduction to Cash Flow Statement, Cash and Cash Equivalents, Cash Flow Activities, Operating Activities, Some Special Items, Free cash Flow, Fund Flow Statement,
Analysis of cash Flow Statement, Preparation of cash Flow Statement.
UNIT – IV
Financial Statement Analysis: Introduction Techniques for financial Statement Analysis Horizontal Analysis: Comparative and Trend Statements, Vertical Analysis: Common Size, Liquidity Ratios: Current and Quick Ratio, Solvency Ratios: D/E, Interest Coverage, Profitability ratios: (GP,NP,EBIT,EBDITA,EPS), Return Ratios: ROI, ROE,
Turnover Ratios, Analysis of Stock and Debtors, Working Capital Management, Stock Prices and Financial Data: P/E. Investments: Introduction, Financial Instruments, Assets and Liabilities, Joint Ventures, Subsidiaries and Associates, Consolidated Financial Statement, Business Combinations, Accounting for Investments, Contemporary Issues in Accounting : Introduction ,Foreign Currency Accounting , Creative Accounting, Forensic Accounting , Environmental Accounting, Lean Accounting Human Resource Accounting, Objectives of Human resource Accounting, HRA in India, Inflation Accounting, Responsibility Accounting, Transfer Pricing, Segment reporting,
Extensible business Reporting Language(XBRL).
Text Book:
1. Varadraj Bapat, Mehul Raithatha, Financial Accounting, McGraw-Hill.
Reference Books:
1. M.N. Arora, K.V.Achalapati, S.Brinda, Finiancial Accounting, Taxmann
2. M. Hanif, A. Mukherjee, Financial Accounting, McGraw-Hill.
3. N. Ramachandran, Ram Kumar Kakani, Financial Accounting for management, McGraw-Hill.
4. Dhanesh K Khatri, Accounting for Management, McGraw-Hill.
Paper -III : Fundamentals of Computer ( Old 2016-17 Onwards )
UNIT – I
Understanding the Computer: Introduction, Evolution of computers, Generation of computers, Classification of computers, Computing concepts, The computer system,
Application of computers. Computer Organization and Architecture: Introduction, Central processing unit, Internal communications, Machine cycle, The bus, Instruction set. Memory and Storage Systems: Introduction, Memory representation, Random Access Memory, Read Only Memory, Storage systems, Magnetic storage systems, Optical storage systems, Magneto optical system, Solid-state storage devices, storage evaluation criteria.
UNIT – II
Input Devices: Introduction, Keyboard, Pointing devices, Scanning devices, Optical recognition devices, Digital camera, Voice recognition system, Data acquisition sensors, Media input devices. Output Devices: Introduction, Display monitors, Printers, Impact printers, Non-impact printers, Plotters, Voice output systems, Projectors, Terminals. Computer Codes: Introduction, Decimal system, Binary system, Hexadecimal system, Octal system, 4-bit Binary Coded Decimal(BCD) Systems, 8-bit BCD Systems, 16-bit Unicode, Conversion of numbers
UNIT – III
Computer Software: Introduction, Types of computer software, System management programs, System development programs, standard application programs, Unique application programs, Problem solving, Structuring the logic, Using the computer. Programming Languages: Introduction, History of programming languages, Generations of programming languages, Characteristics of good programming languages, Categorization of High-level languages, Popular High-level languages, Factors affecting the choice of languages, Developing a program, Running a program. Data Communication and Networks: Introduction, Data communication using modem, Computer network, Network topologies, Network protocol and software, Application of network.
UNIT – IV
Operating Systems: Introduction, History of operating systems, Functions of operating systems, Process management, Memory management, File management, Device management, Security management, Types of operating systems, Providing user
interface, Popular operating systems. Microsoft Software: Introduction, MS-DOS, MS Word systems, MS Excel systems, MS PowerPoint systems, MS Access systems, MS Publisher,
Text Book:
1. E Balagurusamy, Fundamentals of Computers, Mc Graw Hill Education.
Reference Books:
1. Dr. Rajiv Midha, S. Brinda, Fundamental of Information Technology, Taxmann.
2. Madhulika Jain, Shashank Jain, Satish Jain, Information Technology Concepts, BPB Publication.
3. Dr. Rajiv Midha, Information Technology, Taxmann
4. B. Ram, Computer Fundamentals (Architecture & organization), New Age International Publisher.
5. Turban, Rainer, Potter, Introduction to Information Technology, Wiley India Edition.
6. Sanjay Saxsena, Introduction to Information Technology, Vikash Publishing House Pvt. Ltd.
7. Dr. Sushila Madan, Information Technology, Taxmann.
Practical List of Fundamentals of Computer
1.Insert a line chart with the following data. Specify Chart title as .Yearly Income (In
Lakhs)..
COUNTRIES GOLD DIAMOND IRON ORE
INDIA 50 35 60
USA 40 40 35
CHINA 45 55 60
JAPAN 60 65 70
2. Create a Table of Contents for Generations of Computers.
3. Create the following result card in Ms-Word
Mount Carmel School
Sector 46, Chandigarh.
Class 9th Roll No. 123
Student Name Maninder Raj
Father‘s Name Sh.S.S. Chauhan
Result Card
Term-II Examination
Subject Max. Marks Marks Obtained
English 100 92
Maths 100 93
Science 100 98
Social Studies 100 88
Hindi 100 78
Computer Science 100 90
Total 600 539
Position in the Class: IInd
Remarks: Good
Parents Signature Principal Signature
4. Write all the options of standard and formatting toolbar. Use different types of bullets
and numbering. Divide the page in two columns.
5. Using Mail merge, write a letter to all the selected candidate for their final interview
on 20th Sep 2008 at Dotcom Services Ltd, Nawab Layout, Nagpur 10 at 11:00 am
along with necessary documents, resume and 2 Passport size photographs.
6. Create the following table by Insert Table option of MS Word
Country
Population Chart
Year
Population (In
Lakhs)
INDIA
1998 80
1999 90
2000 100
USA
1998 60
1999 70
2000 80
UK
1998 70
1999 75
2000 80
Total
Population
Population Chart
Year
Population (In
Lakhs)
INDIA
1998 80
1999 90
2000 100
USA
1998 60
1999 70
2000 80
UK
1998 70
1999 75
2000 80
Total
Population
Apply Auto format (Table web2) to the above table.
Calculate Total Population by using formula .SUM..
7. Create your resume using Resume Wizard.(Using Templates)
8. Write a Cotemporary letter regarding launch of new product in a company.(Using Templates).
9. Make a list of the following functions with example and syntax.
i. Sum
ix. Upper
ii.
Average x. Lower
iii.
Max xi. Today
iv.
Min xii. Now
v.
Count xiii. Roman
vi.
Round xiv. Mean
vii. Sqrt
xv. Median
viii. ABS
xvi. Mode
10. Calculate Profit and prepare a Column chart in MS Excel using the data.
Month
Net Sales
(Rs.
Lakhs)
Total Cost
(Rs.
Lakhs)
Profit
(Rs.
Lakhs)
Jan-02 22 18
Feb-02 24 9
Mar-02 32 24
Apr-02 26 23
May-02 30 24
Jun-02 34 25
Jul-02 35 30
a) Give chart Title -Profit Report
b) X axis Title -Months
c) Y axis Title -Amt(in Lakhs)
11. Prepare billing report for M/s.Total Synergy Consultancy Private Limited (TSCPL) in
MS Excel.
Figures in =000
Consultant Qtr 1 Qtr 2 Qtr3 Qtr 4 Yearly Total
R.Bhatnagar Rs9,752.00 Rs10,129.00 Rs8,212.00 Rs7,032.00
M.Lath Rs5,755.00 Rs6,477.00 Rs5,447.00 Rs4,584.00
P.Sharma Rs6,769.00 Rs6,758.00 Rs6,378.00 Rs1,644.00
K.Pandey Rs3,708.00 Rs5,795.00 Rs6,188.00 Rs1,636.00
M.Swamy Rs5,009.00 Rs2,009.00 Rs7,643.00 Rs7,323.00
Total•
Prepare Pie Chart showing consultant‘s contribution to Total yearly Billing from the
above example.
12. Prepare a statement of Marks (Calculate the Total Marks, Average and Grade using
functions Sum, Average and IF).
Criteria for Grade:
Average >=75 ----Distinction
Average >=60 ----First
Average >=50 ----Second
Average >=45 ----Third
13. Prepare the following table in a worksheet using Ms-Excel
Name Basic DA HRA Gross
Pay
PF Net
Pay
Rojer 10000 2000 2780
Mack 20000 1050 1500
Simon 35000 2100 1900
Fredric 25000 2500 2100
Harry 20000 1000 1500
Perform the following calculations:
a) Gross Pay=Basic Pay +DA+HRA
b) PF=12% of DA
c) Net Pay=Gross Pay-PF
Perform the following formatting:
a) Set column width=10
b) Set row height=15
c) Text Alignment:
i. Horizontal : Center
ii. Vertical : Centre
BCCA Syllabus RTMNU
Page 7 of 76
14. Prepare following table for .DOTCOM SOLUTIONS LIMITED.
DOTCOM SOLUTIONS LIMITED
INVENTORY DATABASE
INV.CODE DESC QTY RATE PRICE
P1002 TV-COLOUR 21" 35 11000
P1001 TV-COLOUR 29" 15 28000
P1003 DVD 20 12000
P1007 STERIO 53 6000
P1008 WASHING MACHINE 21 18000
P1005 REFRIGERATOR 40 8000
P0004 DISH WASHER 5 20000
P1009 MIXER 35 3000
P1010 GRINDER 20 5000
i) Calculate price and apply Auto format to the above table.
ii) Sort the records in the table in ascending order of INV.CODE.
15. Using conditional formatting on the above table perform the following :
a) Highlight those INV.CODE values where INV.CODE is greater than
P1005.
b) Highlight those quantity values where Qty is between 30 and 50.
c) Highlight (Single Underline) the rate values where rate is less than 10000 and (Bold) greater than or equal to 20000.
d) Highlight (Strikethrough) the price value where price is equal to 3, 20,000 and (Bold-Italic) not equal to 1, 00,000.
16. Following data of DOTCOM SOLUTIONS LTD. is given
Sales
Variable costs
Fixed expenses
Rs.40, 00,000
Rs.30, 00,000
Rs.70, 000
I.
II.
III.
IV.
Calculate:
Contribution
Profit Volume Ratio
Break Even Point
Margin of Safety
NOTE: Contribution=sales – variable cost
PVR= (contribution /sales) *100
BEP = (fixed cost / PVR)*100
MOS=Profit / PVR*100
Profit=contribution-fixed expense
17. Use IF Function
i. From the data given below check whether the expenses are over budget or within budget using function IF.
Actual
Over/Within Budget
Predicted Expenses
Expenses
1500 900
500 900
500 925
2000 1500
ii.
Design a mark sheet and enter record of any 5 students for three subject and
check whether their result is PASS or FAIL using (IF-AND).
Table structure should be as given:
Sr.
No
Student
Name
Marks
Subject
1
Subject2 Subject3 Result(PASS/FAIL)
Condition: result will be .PASS. if marks of each subject are greater than 45.
18. Enter the following data in MS-Excel
Property
Value
Commission
100,000 7,000
200,000 14,000
300,000 21,000
400,000 28,000
From the above data calculate the following using function SUMIF
.
Sum of the commissions for property values over 160,000
.
Sum of the commissions for property values below 300,000.
.
Sum of the commissions for property values over 100,000
19. Create Timetable by inserting table in Power Point.
20. Using the following data create a chart in power Point.
Sub 1 Sub 2 Sub 3 Sub 4
John 56 56 60 67
Rita 45 67 80 45
Joseph 56 67 89 78
9.
Create a Power Point presentation using Auto Content Wizard.
10. Create
a PowerPoint presentation showing various features of MS Office.
Demonstrate the use of master slide.
11. Create a Power Point presentation listing various design templates available. Use
various types of bullets and numbering. Each slide should have Animation effect.
12. Create a Power Point Presentation for explaining various network topologies.
13. Create
an advertisement in Power Point with maximum 6 slides. Each slide
should have custom animation.
14. Create a table EmpMaster in MS-ACCESS with following details:
Field Name Data Type Description
Emp_Id Text Size=15, Input Mask: ###-##-###
Emp_Name Text Size=20, Format: > (Display in Uppercase)
Address Text Size=30
Joining_date Date Format=.Short date., Validation rule =
Employee joined between 01/01/07 and date()
Married Yes/No
No_of_Children Number Validation Rule : not more than 2 (<=2)
a) Set Emp_Id as Primary key. b) Insert information about 10 Employees.
c) Use column width as best fit.
d) Print the table design view and datasheet view.
15. Create a table BookDetails in MS-ACCESS with following details:
Field Name Data Type Description
Book_Id Text Size=3 , Like Eg: B101
Title Text Size=20, Format: < (Display in lowercase)
Author Text Size=20, Format: > (display in uppercase)
Publication Text Size=30
Edition_No Number Format=Byte
Price Currency Use Currency Symbol Rs.
Pages Number Format=Byte
a) Set Book_Id as Primary key. b) Insert information about 10 Books.
c) Use column width as best fit.
d) Print the table design view and datasheet view.
16. Consider the following table and perform the operation given below:
ProductDetails
Prod_Id Prod_Name Company_Name Country
101 Chavanprash Dabur Ltd India
121 Chocolates Amul Ltd India
126 Face wash Amway Ltd USA
163 Soap Hindustan Lever Ltd India
132 Cold Cream Nivea Ltd Germany
135 Hair Gel L‘Oreal Pvt Ltd Australia
111 Deodorant Coty Incorporation South Africa
106 Hair Shampoo Amway Ltd USA
a) Select only those records whose country = .India.
b) Select only those record whose company = .Amway Ltd.
c) Print the table datasheet view of both a) and b) after selection.
17. Consider the following table and perform the operation given below
Employee_Details
Emp_Id Emp_Name Desg Dept_Name Add City Sal
1 Rakesh Programmer CMP Ramanagar Nagpur Rs. 10,000.00
2 Amit Clerk ACT Khamla Nagpur Rs. 4,500.00
3 Anjali Operator REC Sadar Nagpur Rs. 2,200.00
4 Sachin Accountant ACT Tilaknagar Nagpur Rs. 11,500.00
5 Sagar Sr.
Accountant
ACT Ravinagar Nagpur Rs. 12,500.00
6 Abhilash Operator STO Dharampeth Nagpur Rs. 2,200.00
o
Select Emp_Name, Desg and Sal from Employee_Details.
o
Select All fields from Employee_Details where Dept_Name = .ACT. AND Sal
> 4000.
o
Print the Query design view, Datasheet view and SQL view of a) and b
18. Consider the following table and perform the operation given below
Account
AcctId AcctType Amount
A1 Saving Rs.50,000.00
A2 Saving Rs.25,000.00
A3 Fixed Rs.100,000.00
A4 Fixed Rs.55,000.00
A5 Saving Rs.25,000.00
a) DELETE FROM Account WHERE Amount <=25,000
b) Print the Query design view, Datasheet view and SQL view.
19. Make a directory naming CPC in DOS. Under that make three sub directories
BCAI, BCA II, BCAIII. Also explain the commands used in making the directories
and subdirectories in DOS.
20. Using Tree Command in DOS make the following tree diagram
C:\MANAGER
FINANCE_MANAGER
PROJECT
GENERAL_MANAGER
SALES
Also explain the commands used in making the above tree diagram.
21. Using tree command in DOS make the following tree diagram
C:\CPC
BCA
MCM
BCAI
BCAII
BCAIII
MCMI
MCMII
PGDCCA
Also explain the commands used in making the above tree diagram.
22. Make a file named .compute.txt. in DOS and write the definition and characteristics
of computer in that file.
Rename the file compute.txt to computer.txt.
Also explain the commands used in making the file and renaming file. Explain
the difference between copy and ren Command.
23. Make a file named .compute.txt. in DOS and write the definition and characteristics
of computer in that file.
Copy the contents of file compute.txt to computer.txt.
Also explain the commands used in making the file and copying the contents
of one file to another file.
24. Make a file named file1.txt in DOS and enter the following text in that file.
WWW can be defined as a set of standards for storing, retrieving, formatting
and displaying information using client/server architecture, graphical user
interfaces and a hypertext language that enables dynamic link to documents.
World Wide Web is a repository of information spread all over the world and
linked together.
Copy the contents of file1.txt to file2.txt also explain the difference between
rename and copy command.
Paper -IV: Programming in C ( Old 2016-17 onwards)
UNIT – I
Data Types, Operators and some statements: Identifiers and keywords, Constants, C Operators, Type Conversion. Writing a Program in C: Variable declaration, Statements, Simple C Programs, Simple Input Statements, Simple Output Statements, and Features of stdio.h. Control Statements: Conditional Expressions, Loop Statements, Breaking control statements.
UNIT – II
Function and Program Structures: Introduction, Defining a Function, Return Statement, Types of Functions, Actual & Formal Arguments, Local & Global Variables, Multifunction Program, and The Scope of Variables, Recursive Function, and ANSI Function Slandered. Arrays: Array Notation, Array Declaration, Array Initialization, Processing with Arrays, Arrays and Functions, Multidimensional Array, Character Array.
UNIT – III
Pointers: Pointer Declaration, Pointer Arithmetic, Pointers and Functions, Pointers and Arrays, Pointer and Strings, Array of Pointers, Pointers to Pointers. More on Functions: Pre-processors, Macros, Header Files, standard Functions.
UNIT-IV
Structures, unions and Bit Fields: Declaration of Structure, Initializing a Structure, Functions and Structures, Array of Structure, Arrays within Structure, Structure within structure, Pointer and ?Structure, Union, Bit Fields, Typedef Enumerations. Data File Operations: Review of input/output Functions, Opening and Closing of files, Simple File Operation, Structures and File Operation, Block Read/Write, More on File operations, Low level File operations, Random Access File processing.
Text Book:
1. D. Ravichandran, Programming in C, New Age International Publishers.
Reference Books:
1. E. Balaguruswami, Programming in ANSI C, McGraw-Hill.
2. R Subburaj, Programming in C, Vikash Publishing House Pvt. Ltd.
3. S. K. Shrivastava & Dipali Srivastava, C in Depth, BPB Publication.
4. Yashwant Kanetkar, Let Us C, BPB Publication, 9th Edition.
5. Veugopal Prasad, Mastering C, McGraw-Hill.
6. Schildt, The Complete Reference C, McGraw-Hill.
Practical List of Programming in C
A1.
Draw a flowchart, write an algorithm and program in .C. to check whether the entered character is either alphabet, Digit or Special Character.
A2.
Draw a flowchart, write an algorithm and program in .C. to check whether the entered character is in either Uppercase or Lowercase and also convert that character either in Uppercase or Lowercase by using toupper(), tolower(), getchar(), putchar( ), isupper( ) and islower( ) library functions.
A3.
Draw a flowchart, write an algorithm and program in .C. to generate the mark
sheet of student using following information.
a.
Name of the student.
b.
Roll Number
c.
Course Name
d.
Marks of 5 subjects, each subject carries 100 marks. Passing marks of
each subject is 45.
e.
Calculate Total Marks.
f.
Calculate Percentage.
g.
Display the Result, the conditions for result is –
•
Result = .Pass., if the student get 50% aggregate and must not get
less than 45 marks in each subject.
•
Else Result = .Fail.
h.
Display the Grade, The grade will be –
•
Grade = .Distinction., If Percentage>=75.
•
Grade = .First Class., If 60 <= Percentage < 75.
•
Grade = .Second Class, If 50 <= Percentage <60.
•
Grade = .Fail., If Percentage < 50.
A4.
Draw a flowchart, write an algorithm and program in .C. to generate and print Fibonacci series and check whether each number is prime or unprimed.
A5.
Draw a flowchart, write an algorithm and program in .C. to generate and print Fibonacci series and check whether each number is EVEN or ODD.
A6.
Draw a flowchart; write an algorithm and program in .C. to convert the total number of days into number of years, months and remaining days. Consider 360 days in a year and 30 days in month.
A7.
Draw a flowchart; write an algorithm and program in .C. to perform the following arithmetic operations using arithmetic operators in switch statement. The Arithmetic operations are addition (+), Subtraction (-), Multiplication (*), Integer Division (/) Real Division (/), modulo (%) and Raise to power (^).
A8.
Draw a flowchart; write an algorithm and program in .C. to check the entered character is vowel or not using switch statement.
A9.
Draw a flowchart; write an algorithm and program in .C. to convert Decimal Number to its equivalent Binary Number.
A10.
Draw a flowchart; write an algorithm and program in .C. to convert Binary Number to its equivalent Decimal Number.
A11.
Draw a flowchart; write an algorithm and program in .C. to find LCM and HCF of two numbers.
A12.
Draw a flowchart, write an algorithm and program in .C. to Print and evaluate the following series. The series is ----
Sum = (x)+(x^2/2!) )+(x^3/3!) )+(x^4/4!) +(x^5/5!) )+………………..
A13.
Draw a flowchart, write an algorithm and program in .C. to Print and evaluate the following series. The series is ----
Sum = (x)+(x^3/3!) )+(x^5/5!) )+(x^7/7!) +(x^9/9!) )+………………..
A14.
Draw a flowchart, write an algorithm and program in .C. to enter the Nine digit number, find and print even and odd numbers from that nine digit number also find the summation of all even number and odd numbers.
A15.
Draw a flowchart, write an algorithm and program in .C. to check the entered number is Palindrome or not also print the reverse of the given number.
A16.
Draw a flowchart, write an algorithm and program in .C. to swap the values of two variables with and without using third variable.
A17.
Draw a flowchart, write an algorithm and program in .C. to generate and print the Prime Factors of a given number.
A18.
Draw a Flowchart; Write an Algorithm and Program in .C. to Calculate the Mean and Variance of 10 Integer Numbers.
Where Mean = .(Xi)/N and
Variance =. (Xi-.)2/N
A19. Draw a Flowchart; Write an Algorithm and Program in .C. to Find the Largest and smallest number form a single dimension array.
A20.
Draw a Flowchart; Write an Algorithm and Program in .C. to Search an Element
from a single dimension array with its position using Sequential search
Technique. Print the message .Element found at position _____., if the element
present in an array and print message .Element Not Found., If element is not present in an array.
A21.
Draw a Flowchart; Write an Algorithm and Program in .C. to insert an element in a given position in an array.
A22.
Draw a Flowchart; Write an Algorithm and Program in .C. to delete an element from a given position of an array.
A23.
Draw a Flowchart; Write an Algorithm and Program in .C. to Sort elements of a given array using Bubble Sort in an ascending order.
A24.
Draw a Flowchart; Write an Algorithm and Program in .C. to find the sum of Each Row and each column of a given Matrix and also find the sum of all elements.
A25.
Draw a Flowchart; Write an Algorithm and Program in .C. to convert the matrix into Transpose of Matrix also print both the original and Transpose of Matrix.
A26.
Draw a Flowchart; Write an Algorithm and Program in .C. to add two matrices of the given range and print all the three matrices.
A27.
Draw a Flowchart; Write an Algorithm and Program in .C. to find the product of two matrices of the given range and print all the three matrices.
A28.
Draw a Flowchart; Write an Algorithm and Program in .C. to check the entered String is Palindrome or not with and without using String Manipulation Functions.
A29.
Draw a Flowchart; Write an Algorithm and Program in .C. to Find the given character and replace that character with new character of the original text also print the modified text.
A30.
Draw a Flowchart; Write an Algorithm and Program in .C. to count the number of spaces, alphabets, digits, special symbols from a given text using String Manipulation Functions.
A31.
Draw a Flowchart; Write an Algorithm and Program in .C. to count the number of spaces, alphabets, digits, special symbols from a given text using ASCII Characters.
A32.
Draw a Flowchart; Write an Algorithm and Program in .C. to count the number of words and all characters excluding spaces from a given text without using string manipulation Functions.
A33.
Draw a Flowchart; Write an Algorithm and Program in .C. to concatenate two strings into third string without using string manipulation Functions.
A34.
Draw a flowchart, write an algorithm and program in .C. to Design and Print the following Output of any entered string, for example
P
P
R
P
RI
P
RI N
P
RI NT
P
RI N
P
RI
P
R
P
A35.
Draw a Flowchart; Write an Algorithm and Program in .C. to Append to string arrays in third array.
A36.
Draw a Flowchart; Write an Algorithm and Program in .C. to Sort a String array in either Ascending or Descending order.
A37.
Draw a Flowchart; Write an Algorithm and Program in .C. to insert an element in an appropriate position in a sorted array. The array is sorted in an ascending order.
A38.
Draw a flowchart, write an algorithm and program in .C. to Design and Print the following Output.
1
2 3 2
3 4 5 4 3
4 5 6 7 6 5 4
5 6 7 8 9 8 7 6 5
A39.
Draw a flowchart, write an algorithm and program in .C. to Design and Print the following Output.
*
***
*****
*******
*****
***
*
A40. Draw a flowchart, write an algorithm and program in .C. to Design and Print the following Output.
1
01
010
1010
10101
010101
A41.
Write an algorithm, draw a flowchart and develop =C‘ program to Create a
structure Student containing fields for Roll No., Name, Class, Year and Total
Marks. Create 10 students and store them in a file.
A42.
Write an algorithm, draw a flowchart and develop =C‘ program to create a file .abc.txt. and store the text. Copy the content from .abc.txt. to another file .xyz.txt. using putc() and getc() function. Also read the content of both files.
BCCA Part 1 Semester 1 New & Old
BCCA Part 1 Semester 2 New & Old
BCCA Part 2 Semester 3 ( BCCA Semester 3 ) New & Old
BCCA Part 2 Semester 4 ( BCCA Semester 4 ) New & Old
BCCA Part 3 Semester 5 ( BCCA Semester 5 ) New & Old
BCCA Part 3 Semester 6 ( BCCA Semester 6 ) New & Old
BCA Bachelor Of Computer Application, BCCA, Bachelor of Commerce & Computer Application BE IT/CS, Information technology/Computer Science MCA, Master of Computer Application MCM, Master of Computer Management Diploma , Polytechnic B.Arch Bachelor Of Architecture, Others,
