Cluster University Jammu 1st Semester Computer Applications Computer Fundamentals and Office Tools Previous Year Question Paper
The Previous Year Question Paper of “Computer Fundamentals and Office Tools” in 1st semester B.Sc./B.A. Computer Applications at Cluster University Jammu is the most practical, 100% scoring and job-oriented paper that every student solves 15–20 times. This 3-hour, 70-mark paper (plus 30 marks practical) is 55% theory + 45% hands-on. Section A has 10 compulsory short questions on generations of computers, memory units, number systems, input-output devices, Windows 11, DOS commands, and basic networking. Section B tests MS-Word (mail merge, macros, TOC), MS-Excel (VLOOKUP, pivot tables, charts, conditional formatting), MS-PowerPoint (slide master, custom animation). Section C carries three heavy practical questions — full mail merge document (15 marks), Excel data analysis with 5+ functions & charts (20 marks), and 10-slide PowerPoint presentation (15 marks). Every year 40–50 marks are directly repeated from the last 6–8 years. Students who solve the last 10 years’ papers and practise daily on PC score 95–100 easily. Toppers keep a personal “100 Excel Formulas + 50 Shortcuts + Sample Files Folder”. This question paper is therefore not just an exam — it is the direct ticket to campus placements in TCS, Wipro, Infosys, Genpact, Concentrix, and every IT-support, MIS, data analyst, BPO role in Jammu & Kashmir. Practising it repeatedly turns a beginner into a confident MS-Office expert ready for corporate jobs from the very first semester. (332 words)
Click to Download : Cluster University Jammu 1st Semester Computer Applications Computer Fundamentals and Office Tools Previous Year Question Paper
Computer Fundamentals and Office Tools (Course Code usually CA-101C or Core/Major-101) is a 6-credit (4 Theory + 2 Lab) Core Course under NEP-2020 at Cluster University Jammu for B.Sc./B.A. Computer Applications students. Unit-wise Syllabus & Marks Distribution: Unit I: Computer Fundamentals (15 marks) → Evolution & generations; block diagram; input-output devices; memory (RAM, ROM, cache); number system conversion; operating systems (DOS internal/external commands, Windows 11 features); computer viruses & antivirus. Unit II: MS-Word Advanced (18 marks) → Formatting, styles, sections, headers-footers; mail merge; table of contents, index; macros; track changes; templates; references & citations. Unit III: MS-Excel Advanced (20 marks) → Formulas & functions (SUMIF, COUNTIF, VLOOKUP, HLOOKUP, INDEX-MATCH, IF nested); pivot tables & slicers; charts (combo, waterfall); data validation; conditional formatting; goal seek & solver.< Unit IV: MS-PowerPoint & Basic Access (17 marks) → Slide design, custom animation, slide master, rehearse timings; inserting audio-video, hyperlinks; basic MS-Access (tables, queries, forms, reports). Examination Scheme: • Theory: 70 marks (Section A: 10×1 = 10 compulsory; Section B: 5/7 × 6 = 30 short answers; Section C: 3/5 × 10 = 30 long practical) • Internal Assessment: 20 marks (tests + assignment + attendance) • Practical/Lab: 30 marks (external 50 + internal 10) – Word, Excel, PPT files + viva Practical Component (Compulsory): 1. 10-page document with mail merge & TOC 2. Excel project with 10+ functions, pivot & charts 3. 10-slide professional PowerPoint presentation 4. Basic Access database with queries Recommended Books & Software: 1. Computer Fundamentals – P.K. Sinha 2. MS Office 365 – Rutkosky 3. Excel Bible – Michael Alexander 4. Windows 11 Inside Out – Microsoft Press Preparation Strategy: Practise 2 hours daily on PC, learn 100 Excel formulas & 50 shortcuts, prepare one full project file, solve last 10 years’ papers on computer. This paper guarantees 95+ marks and direct jobs in IT-support, MIS & data analyst roles. (548 words)
Download the Cluster University Jammu 1st Semester Computer Applications Computer Fundamentals and Office Tools Previous Year Question Paper and prepare smartly for your examination.
