← Back to Semester 1 Hub
🏛️ CCSU Meerut ⏱️ 75 Marks External (3 Hours) 📄 3M, 7.5M & 15M Blueprint ⭐ 10-Year (2011–2020) Complete Question Coverage
SECTION A • 3 MARKS EACH

Very Short Answer Questions & Conversions

CCSU Blueprint: All 5 Questions Compulsory • 15 Marks Total

Q1. Master Number System Conversions (Binary, Decimal, Octal, Hexadecimal & Fractions).

🔥 Compulsory in All 10 Years (2011–2020) 3 Marks
✍️ Step-by-Step Solutions:

1. Binary to Decimal Conversions (2011, 2013, 2015, 2016, 2017, 2018):

  • $(1101011)_2 = 1\cdot 2^6 + 1\cdot 2^5 + 0\cdot 2^4 + 1\cdot 2^3 + 0\cdot 2^2 + 1\cdot 2^1 + 1\cdot 2^0 = 64+32+8+2+1 = \mathbf{107_{10}}$
  • $(1110101)_2 = 1\cdot 2^6 + 1\cdot 2^5 + 1\cdot 2^4 + 0\cdot 2^3 + 1\cdot 2^2 + 0\cdot 2^1 + 1\cdot 2^0 = 64+32+16+4+1 = \mathbf{117_{10}}$
  • $(11011101)_2 = 128 + 64 + 0 + 16 + 8 + 4 + 0 + 1 = \mathbf{221_{10}}$
  • $(11001100)_2 = 128 + 64 + 0 + 0 + 8 + 4 + 0 + 0 = \mathbf{204_{10}}$
  • $(101010)_2 = 32 + 0 + 8 + 0 + 2 + 0 = \mathbf{42_{10}}$
  • $(11010)_2 = 16 + 8 + 0 + 2 + 0 = \mathbf{26_{10}}$

2. Decimal to Binary Conversions (2012):

  • $(32)_{10} = \mathbf{(100000)_2}$ ($32 = 2^5$).
  • $(435)_{10}$: Continuous division by 2 gives remainders bottom-up: $\mathbf{(110110011)_2}$.
  • $(1694)_{10}$: Continuous division by 2 gives: $\mathbf{(11010011110)_2}$.

3. Octal to Decimal Conversions (2014, 2015, 2016, 2017):

  • $(562)_8 = 5\cdot 8^2 + 6\cdot 8^1 + 2\cdot 8^0 = 320 + 48 + 2 = \mathbf{370_{10}}$
  • $(2614)_8 = 2\cdot 512 + 6\cdot 64 + 1\cdot 8 + 4\cdot 1 = 1024 + 384 + 8 + 4 = \mathbf{1420_{10}}$
  • $(777)_8 = 7\cdot 64 + 7\cdot 8 + 7\cdot 1 = 448 + 56 + 7 = \mathbf{511_{10}}$

4. Hexadecimal to Decimal Conversions (2014, 2015, 2016, 2017, 2018):

  • $(FAB)_{16} = 15\cdot 16^2 + 10\cdot 16^1 + 11\cdot 16^0 = 3840 + 160 + 11 = \mathbf{4011_{10}}$
  • $(3C)_{16} = 3\cdot 16 + 12 = 48 + 12 = \mathbf{60_{10}}$
  • $(7E)_{16} = 7\cdot 16 + 14 = 112 + 14 = \mathbf{126_{10}}$
  • $(A32)_{16} = 10\cdot 256 + 3\cdot 16 + 2\cdot 1 = 2560 + 48 + 2 = \mathbf{2610_{10}}$
  • $(FA3)_{16}$ to Binary: $F=1111, A=1010, 3=0011 \implies \mathbf{(111110100011)_2}$

5. Fractional Conversions (2019, 2020):

  • $(10110.11)_2$: Integer part $= 16+4+2 = 22$. Fractional part $= 1\cdot 2^{-1} + 1\cdot 2^{-2} = 0.5 + 0.25 = 0.75 \implies \mathbf{22.75_{10}}$.
  • $(61.3)_{10}$ to Binary: $61 = (111101)_2$. Fractional $0.3 \times 2 = 0.6 (0), 0.6 \times 2 = 1.2 (1), 0.2 \times 2 = 0.4 (0) \implies \mathbf{(111101.0100\dots)_2}$.

Q2. Differentiate between an Analog Computer and a Digital Computer.

🔥 Repeated: 2011 3 Marks
✍️ Model Answer:
FeatureAnalog ComputerDigital Computer
Data RepresentationProcesses continuous physical signals (voltage, speed, pressure).Processes discrete electrical pulses representing binary bits ($0$ and $1$).
Accuracy & NoiseApproximate accuracy; subject to electrical noise and temperature drift.Exact mathematical precision; 100% reproducible results.
Memory StorageVery limited or no memory storage.Massive memory capacity (RAM, SSD, Hard Drive).
ExamplesAutomobile speedometer, analog thermometer, slide rule.Desktops, laptops, smartphones, supercomputers.

Q3. What is the difference between a File and a Directory?

🔥 Repeated: 2011 3 Marks
✍️ Model Answer:
  • File: A named, permanent collection of related data, text, or compiled instructions stored on secondary media. It has a specific file name and extension (e.g., report.docx, data.xlsx, index.html).
  • Directory (Folder): A logical organizational catalog inside the file system used to group and store files and subdirectories in a hierarchical tree. It contains directory metadata and references pointing to files.

Q4. What is the Taskbar in Windows? List out its various components.

🔥 Repeated: 2011, 2017, 2020 3 Marks
✍️ Model Answer:

The Taskbar is a persistent horizontal desktop bar typically located at the bottom of the screen. Its four key parts are:

  1. Start Button: Opens the Windows Start Menu to access installed apps, settings, and power options.
  2. Quick Launch Toolbar / Pinned Apps: Houses single-click shortcuts for frequent applications.
  3. Active Task Buttons Area: Displays rectangular buttons or icons for every currently running application window.
  4. Notification Area (System Tray): Located at far right; displays system clock, volume control, network connectivity, and background utilities.

Q5. Differentiate between CRT Display and LCD Display.

🔥 Repeated: 2011, 2018, 2019 3 Marks
✍️ Model Answer:
ParameterCRT (Cathode Ray Tube)LCD (Liquid Crystal Display)
Working PrincipleFires electron beams at phosphor dots inside a vacuum tube.Liquid crystals modulate light from a LED/CCFL backlight.
Physical SizeDeep, bulky, and heavy.Flat-panel, ultra-thin, lightweight, and compact.
Power & HeatHigh power consumption and noticeable heat radiation.Low power consumption (up to 70% energy savings).
Eye ComfortProduces flicker that causes eye fatigue.Flicker-free, sharp image output with zero radiation.

Q6. What is the role of I/O Devices in a computer? Why are they necessary?

🔥 Repeated: 2012, 2013, 2020 3 Marks
✍️ Model Answer:

A computer's central processor only understands binary signals ($0$ and $1$). Input/Output (I/O) devices serve as the essential bridge between the human user and the digital computer:

  • Input Devices (Keyboard, Mouse, Scanner): Accept human-understandable data (keystrokes, audio, clicks) and convert them into binary machine code for the CPU.
  • Output Devices (Monitor, Printer, Speaker): Translate processed binary output back into human-perceptible formats (visual images, printed text, audio). Without I/O devices, a computer would be an isolated, unusable black box.

Q7. Define Seek Time, Latency Time, and Access Time of a Hard Disk.

🔥 Repeated: 2013 3 Marks
✍️ Model Answer:
  • Seek Time: The time required for the magnetic Read/Write head assembly to move across platters to position itself directly over the target cylinder/track ($4\text{ to }10\text{ ms}$).
  • Latency Time (Rotational Delay): The time taken for the rotating magnetic disk to spin the requested sector under the read/write head. Average Latency $= \frac{1}{2 \times \text{RPM}}$.
  • Access Time: The total time elapsed between issuing a read/write command and when data transmission begins: $$\mathbf{\text{Access Time} = \text{Seek Time} + \text{Latency Time} + \text{Transfer Time}}$$

Q8. Differentiate between Cache Memory and Virtual Memory.

🔥 Repeated: 2014, 2016 3 Marks
✍️ Model Answer:
  • Cache Memory: Physical high-speed semiconductor Static RAM (SRAM) located on or adjacent to the CPU chip. It stores frequently used instructions to eliminate CPU idle wait states caused by slower Main RAM.
  • Virtual Memory: A software/OS memory management technique that reserves a portion of the secondary hard disk (Pagefile/Swap Space) to simulate extra RAM, allowing programs larger than physical memory to execute via Paging.

Q9. What is an IC (Integrated Circuit)? How did it help in reducing the size of computers?

🔥 Repeated: 2014 3 Marks
✍️ Model Answer:

An Integrated Circuit (IC / Microchip) is a miniature electronic circuit fabricated onto a tiny semiconductor wafer (silicon) that integrates thousands to billions of transistors, diodes, resistors, and capacitors into a single package.

How ICs Revolutionized Computer Size: Before ICs, 2nd-generation computers relied on bulky, discrete transistors wired manually. ICs allowed millions of components to fit within a fingernail-sized silicon chip, drastically reducing physical computer size from entire rooms (3rd Gen: SSI/MSI) down to desktop and handheld microprocessors (4th Gen: VLSI/ULSI), while multiplying processing speeds and lowering heat generation.

Q10. Explain the effect of the DOS command: dir | sort | more.

🔥 Repeated: 2013 3 Marks
✍️ Model Answer:

This command combines three DOS utilities using pipe operators (|) that redirect the standard output of one command as the input of the next:

  1. dir: Lists all files and subdirectories in the current directory.
  2. | sort: Pipes that directory listing into the sort filter, arranging the file names alphabetically in ascending order.
  3. | more: Pipes the sorted output through the paginator, displaying one full screen of files at a time and pausing with -- More -- until the user presses any key.

Q11. List standard shortcut keys in MS-Word (Open, Save, Copy, Select All, New, Close).

🔥 Repeated: 2015, 2016 3 Marks
✍️ Model Answer:
Shortcut KeyFunction Performed
Ctrl + OOpen an existing document file.
Ctrl + ASelect the entire document text and objects.
Ctrl + CCopy selected text/object to clipboard.
Ctrl + SSave the active document.
Ctrl + NCreate a blank new document.
Ctrl + WClose the active document window.

Q12. Expand essential abbreviations: RAM, ROM, PROM, EPROM, LCD, HDD, USB.

🔥 Repeated: 2018, 2019 3 Marks
✍️ Model Answer:
  • RAM: Random Access Memory
  • ROM: Read Only Memory
  • PROM: Programmable Read Only Memory
  • EPROM: Erasable Programmable Read Only Memory (UV erasable)
  • LCD: Liquid Crystal Display
  • HDD: Hard Disk Drive
  • USB: Universal Serial Bus
SECTION B • 7.5 MARKS EACH

Medium Answer Questions, Comparisons & Real Flowcharts

CCSU Blueprint: Attempt Any 2 out of 3 • 15 Marks Total

Q13. Draw a complete flowchart to find the real roots of a quadratic equation ($ax^2 + bx + c = 0$).

🔥 Repeated: 2015 7.5 Marks
✍️ Real Vector Flowchart Solution:
START Read Coefficients a, b, c Calculate D = b² - 4ac Is D ≥ 0 ? NO Print "Roots Imaginary" YES Is D == 0 ? YES r1 = r2 = -b/(2a) NO r1=(-b+√D)/(2a), r2=(-b-√D)/(2a) STOP

Q14. Draw a flowchart to compute the Area and Circumference of a Circle ($A = \pi R^2, C = 2\pi R$).

🔥 Repeated: 2018 7.5 Marks
✍️ Real Vector Flowchart Solution:
START Read Radius R Area = 3.14159 * R * R Circumference = 2 * 3.14 * R Print Area, Circumference STOP

Q15. Draw a flowchart to pick up the largest of three unequal positive integers ($A, B, C$).

🔥 Repeated: 2016, 2020 7.5 Marks
✍️ Model Flowchart:

Logic: Compare $A$ and $B$. If $A > B$, check if $A > C$ (if yes, $A$ is largest; else $C$ is largest). If $B \ge A$, check if $B > C$ (if yes, $B$ is largest; else $C$ is largest).

[START] ──> [Read A, B, C]
              ↓
        < Is A > B ? >
       /              \
    YES                NO
    /                    \
< Is A > C ? >        < Is B > C ? >
 /          \          /          \
YES         NO        YES         NO
 |           |         |           |
[Print A] [Print C] [Print B]  [Print C]
   \         |         /          /
    ──────> [STOP] <──────────────

Q16. What are High-Level Languages? Why are they called problem-oriented? Compare Compiler, Interpreter, and Assembler.

🔥 Repeated: 2011, 2015, 2020 7.5 Marks
✍️ Model Answer:

High-Level Languages (HLL): Programming languages that use English words, familiar mathematical notations, and structured syntax (e.g., C, Python, Java, FORTRAN). They are called problem-oriented because the programmer focuses on solving the real-world mathematical or business problem rather than worrying about the internal hardware architecture or CPU register addresses.

Language Translators Comparison:

FeatureAssemblerCompilerInterpreter
Input LanguageAssembly Language (Mnemonics).High-Level Language.High-Level Language.
Translation ModeDirect 1-to-1 conversion.Translates entire source program in one pass into .exe.Translates and executes code line-by-line directly.
Execution SpeedVery fast.Fast execution once compiled.Slower execution due to runtime translation.
ExamplesNASM, MASM.GCC (C/C++), Java javac.Python, JavaScript, PHP.

Q17. Compare Impact vs Non-Impact Printers. Compare Laser and Dot-Matrix Printers.

🔥 Repeated: 2011, 2012, 2014, 2016 7.5 Marks
✍️ Model Answer:
  • Impact Printers: Form characters by physically striking an inked ribbon against the paper with print hammers (Dot-Matrix, Daisy Wheel, Line Printer). They are noisy, produce lower-resolution output, but can print multipart carbon copies.
  • Non-Impact Printers: Form characters using electrostatic toner, heat, or ink spray without mechanical impact (Laser, Inkjet, Thermal). They are whisper-quiet, provide superior DPI resolution (up to 2400 DPI), but cannot create carbon copies in a single pass.
Comparison MetricDot-Matrix Printer (Impact)Laser Printer (Non-Impact)
TechnologyPrint head pins striking inked ribbon.Rotating laser beam charging a drum to fuse dry toner.
Speed UnitCharacters Per Second (CPS: 100–600 CPS).Pages Per Minute (PPM: 15–50+ PPM).
Cost Per PageExtremely low (few paisa per page).Higher initial toner cost; economical for bulk text.
ApplicationRailway tickets, bank passbooks, billing counters.Office publishing, academic theses, corporate reports.

Q18. Differentiate between System Software and Application Software.

🔥 Repeated: 2013, 2015 7.5 Marks
✍️ Model Answer:
ParameterSystem SoftwareApplication Software
Primary PurposeManages, coordinates, and controls computer hardware resources.Performs specific end-user business or productivity tasks.
User InteractionOperates in background; transparent to the typical user.Direct interaction through GUI or user interfaces.
DependencyCan run independently; required for computer to boot.Cannot run without an underlying operating system.
ExamplesWindows, Linux, Device Drivers, BIOS, Compilers.MS Word, MS Excel, Web Browsers (Chrome), Media Players.

Q19. What do you understand by Desktop Publishing (DTP)? Explain its features and applications.

🔥 Repeated: 2018, 2019 7.5 Marks
✍️ Model Answer:

Desktop Publishing (DTP) refers to the creation of publication-quality printed and digital media (books, magazines, newsletters, brochures, posters) using personal computers and specialized page-layout software.

Key Features of DTP:

  • WYSIWYG (What You See Is What You Get): Screen display accurately reflects final printed output.
  • Precise Typography & Kerning: Micro-control over font families, leading, tracking, and word spacing.
  • Master Pages & Multi-Column Grids: Enables consistent formatting across multi-page documents.
  • Color Separation (CMYK): Prepress color separation for professional offset printing presses.
  • Common DTP Software: Adobe InDesign, QuarkXPress, Adobe PageMaker, CorelDRAW.

Q20. Explain the working of Windows Explorer. How is data organized in files and directories?

🔥 Repeated: 2012, 2014, 2017 7.5 Marks
✍️ Model Answer:

Windows Explorer (File Explorer) is the default file management graphical application in Windows. It uses a dual-pane layout:

  • Left Pane (Navigation Tree): Shows the hierarchical directory structure: Drives (C:, D:), Libraries, and Network shares.
  • Right Pane (Content Pane): Displays the files and subfolders of the currently selected folder.

Hierarchical File Organization: Data is organized into a root directory followed by branches of subdirectories. Every file is uniquely addressed via its Path:

C:\ (Root)
 ├── BCA\
 │    ├── Semester-1\
 │    │    ├── notes.txt      (Absolute Path: C:\BCA\Semester-1\notes.txt)
 │    │    └── syllabus.pdf

Q21. Write the step-by-step installation process of a printer in Windows OS.

🔥 Repeated: 2011 7.5 Marks
✍️ Model Answer:
  1. Connect the printer to the PC via USB cable or local Wi-Fi/Ethernet network and power on the printer.
  2. Open Control Panel $\to$ select Devices and Printers (or Windows Settings $\to$ Printers & Scanners).
  3. Click on "Add a Printer" button at the top toolbar.
  4. Windows automatically scans for Plug-and-Play devices. If detected, click on the printer and click Next.
  5. If not detected automatically, select "The printer that I want isn't listed" $\to$ choose "Add a local printer with manual settings".
  6. Select the communication port (e.g., USB001).
  7. Insert manufacturer driver disc or select Have Disk $\to$ browse to downloaded driver .inf file.
  8. Type a name for the printer $\to$ choose whether to share it $\to$ click Print a Test Page to confirm successful installation $\to$ click Finish.
SECTION C • 15 MARKS EACH

Long Detailed Questions, Architectural Schematics & Software Mastery

CCSU Blueprint: Attempt Any 3 out of 5 • 45 Marks Total

Q22. Draw a neat schematic block diagram of a digital computer system. Explain all functional units and system buses in detail.

🔥 Appeared in 8 Out of 10 Papers 15 Marks
✍️ Model Answer & Architectural Diagram:
CENTRAL PROCESSING UNIT (CPU) CONTROL UNIT (CU) Supervises & Coordinates Timing/Signals ARITHMETIC LOGIC UNIT (ALU) Arithmetic (+,-,*,/) & Logical (>,<,=) Ops INTERNAL CPU REGISTERS PC, MAR, MDR, AC, Instruction Register INPUT UNIT Keyboard, Mouse, Scanner, Mic OUTPUT UNIT Monitor (VDU), Printer, Plotter PRIMARY / MAIN MEMORY RAM (Volatile) & ROM (Non-Volatile BIOS) SECONDARY / AUXILIARY STORAGE Hard Disk (HDD), SSD, Pen Drive, Optical Discs BUS LEGEND Data Bus Control Bus

System Buses Explained:

  • Data Bus: Bidirectional bus carrying actual data between CPU, memory, and devices.
  • Address Bus: Unidirectional bus driven by CPU to designate the memory address to read or write.
  • Control Bus: Carries timing, synchronization, and command signals (Read, Write, Interrupt).

Q23. Memory Classification: Differentiate between RAM and ROM. Explain PROM, EPROM, and EEPROM. Differentiate Main Memory vs Auxiliary Memory.

🔥 Appeared in All 10 Years (2011–2020) 15 Marks
✍️ Model Answer:
ParameterRAM (Random Access Memory)ROM (Read Only Memory)
VolatilityVolatile: Data lost instantly when power is cut.Non-Volatile: Retains stored data permanently without power.
OperationRead and Write operations.Read-only during normal computing.
Stored ContentActive programs, OS runtime files, user data.BIOS firmware and bootstrap loader.
SpeedHigh speed (nanoseconds).Slower than RAM.

The ROM Family:

  1. PROM (Programmable ROM): Manufactured blank; can be programmed once using electrical high voltage (blowing internal microscopic fuses). Cannot be erased afterwards.
  2. EPROM (Erasable Programmable ROM): Contains a transparent quartz crystal window. Exposing the chip to intense Ultraviolet (UV) radiation for 20–30 minutes erases all stored data, allowing reprogramming.
  3. EEPROM (Electrically Erasable Programmable ROM): Can be erased and rewritten electrically byte-by-byte without removing the chip. Modern Flash Memory (SSDs, USB Pen Drives, BIOS chips) is based on EEPROM technology.

Main Memory vs Auxiliary (Secondary) Memory:

  • Main Memory (RAM): Directly accessed by CPU via address/data buses; fast, volatile, and limited in capacity (8GB–32GB).
  • Auxiliary Memory (HDD/SSD/Optical): Not directly accessed by CPU; non-volatile, massive capacity (512GB–4TB), highly economical per gigabyte, but thousands of times slower than RAM.

Q24. What is an Operating System? Explain its major functions. Differentiate between Multiprogramming, Multitasking, and Multiprocessing.

🔥 Repeated in 8 Out of 10 Papers 15 Marks
✍️ Model Answer:

An Operating System (OS) is system software that acts as an intermediary interface between computer hardware and the user/applications, managing hardware resources efficiently.

Five Major Functions of an Operating System:

  1. Processor Management (CPU Scheduling): Allocates CPU time to active processes using scheduling algorithms (Round Robin, FCFS, Priority).
  2. Memory Management: Keeps track of every memory byte, dynamically allocates RAM to running programs, and deallocates upon program termination.
  3. File System Management: Manages directories, files, read/write permissions, and disk sector allocation (FAT32, NTFS, EXT4).
  4. Device Management (I/O): Communicates with peripheral hardware using device drivers, managing input/output buffers and Spooling (Print spooler).
  5. Security & Error Handling: Protects user data through authentication, passwords, firewall, and handles hardware/software exceptions.

Multiprogramming vs Multitasking vs Multiprocessing:

TypeCore MechanismCPUs / Cores
MultiprogrammingMultiple programs reside in RAM simultaneously. When one waits for I/O, CPU switches to another to prevent CPU idle time.Single CPU.
Multitasking (Time-Sharing)Logical extension of multiprogramming. CPU time is divided into microscopic slices (quanta), rapidly switching so user feels all apps run at once.Single CPU.
MultiprocessingExecuting multiple processes concurrently using two or more physical CPUs or cores simultaneously.Multiple CPUs / Multicore.

Q25. MS-DOS Architecture: Significance of `CONFIG.SYS`, `AUTOEXEC.BAT`, and `COMMAND.COM`. Describe Directives (FILES, BUFFERS, DEVICE). Explain Batch Files.

🔥 Repeated in 9 Out of 10 Papers 15 Marks
✍️ Model Answer:

Three Fundamental Files in MS-DOS:

  • `COMMAND.COM`: The DOS Command Processor and shell. It displays the command prompt (C:\>), parses user input, and contains all internal commands in resident memory.
  • `CONFIG.SYS`: Configuration text file evaluated by the DOS kernel at initial boot. Key directives include:
    • FILES=40: Specifies the maximum number of files DOS can open simultaneously.
    • BUFFERS=20: Allocates memory cache buffers for disk transfers.
    • DEVICE=C:\DOS\HIMEM.SYS: Loads device drivers for hardware into memory.
    • COUNTRY=001: Sets international date, time, and currency formats.
    • SHELL=C:\DOS\COMMAND.COM /P: Specifies alternate command interpreter location.
  • `AUTOEXEC.BAT`: Automatic Execution Batch file executed immediately after `CONFIG.SYS`. Sets system paths (PATH C:\DOS;C:\TC\BIN), prompt styles, and starts default programs.

Batch Files in DOS:

A Batch File (.bat) is an uncompiled text script containing a series of sequential DOS commands executed line-by-line automatically.

:: Create a batch file to backup student files
COPY CON backup.bat
@ECHO OFF
ECHO Backing up documents for %1 ...
IF NOT EXIST C:\BACKUP MD C:\BACKUP
COPY C:\DATA\%1\*.* C:\BACKUP\
ECHO Backup of %1 Complete!
^Z (Press Ctrl+Z and Enter to save)

Q26. MS-DOS Commands: Differentiate Internal vs External Commands. Explain `FORMAT`, `PROMPT`, `DIR`, `ATTRIB`, `DISKCOMP`, and file management commands.

🔥 Repeated: 2013, 2015, 2016 15 Marks
✍️ Model Answer:
CommandTypeSyntax & Purpose
DIRInternalDIR /P /W: Displays files in directory; /P pauses per page, /W wide view.
MD / CD / RDInternalMD folder (Make directory), CD folder (Change directory), RD folder (Remove directory).
COPY / DELInternalCOPY file1.txt file2.txt (Duplicate file), DEL file.txt (Delete file).
FORMATExternalFORMAT A: /S: Formats disk, establishes file system, /S copies system boot files.
ATTRIBExternalATTRIB +R -H file.txt: Modifies file attributes (+R Read-Only, +H Hidden, +A Archive).
PROMPTExternalPROMPT $P$G: Customizes command prompt to display current drive & path followed by >.
DISKCOMPExternalDISKCOMP A: B:: Compares track-by-track contents of two floppy disks.

Q27. Master Guide to MS-Excel: Features (AutoSum, AutoFill, AutoShapes, Wizard, Drag & Drop, Charts, PivotTable), Formulas, and Business Applications.

🔥 Repeated in 8 Out of 10 Papers 15 Marks
✍️ Model Answer:

MS-Excel is an enterprise spreadsheet application organized in a workbook containing multiple worksheets arranged in grid coordinates (Rows 1 to 1,048,576 and Columns A to XFD).

Core Features of MS-Excel:

  1. AutoSum ($\Sigma$): Automatically creates a summation formula (=SUM()) for adjacent row or column ranges.
  2. AutoFill: Dragging the bottom-right fill handle of a cell automatically increments series (e.g., $1, 2, 3\dots$, Jan, Feb\dots, custom mathematical series).
  3. PivotTable: An interactive multidimensional data aggregation tool that summarizes large data sheets by grouping, pivoting, and calculating sums/averages dynamically.
  4. Chart Wizard & Visualization: Translates numerical records into Bar, Column, Pie, Line, and Scatter charts for business presentations.
  5. Drag and Drop: Moving cell blocks directly by grabbing border boundaries.

Master Excel Formulas:

  • =SUM(A1:A10): Adds all numbers in range.
  • =AVERAGE(B1:B10): Computes mean score.
  • =COUNT(C1:C10): Counts numeric entries in range.
  • =IF(D2 >= 40, "Pass", "Fail"): Conditional logical test.
  • =VLOOKUP(lookup_val, table_array, col_index, [exact_match]): Searches left column and retrieves value from matching row.

Q28. Explain the three ways to create a table in MS-Access in detail.

🔥 Repeated: 2015, 2016, 2018 15 Marks
✍️ Model Answer:
  1. 1. Design View (Developer Mode):
    • The most granular and professional method.
    • Columns: Field Name, Data Type (Short Text, Number, Date/Time, Currency, AutoNumber), and Description.
    • Bottom pane configures Field Properties: Field Size, Format, Input Mask, Validation Rule, Default Value.
    • User explicitly sets the Primary Key by clicking the key icon on the ribbon to ensure non-null uniqueness.
  2. 2. Datasheet View (Spreadsheet Grid Mode):
    • Opens a grid with default columns (ID, Click to Add).
    • User immediately enters data directly into rows and columns; Access automatically determines field data types based on the input entered.
  3. 3. Table Wizard:
    • Provides pre-designed templates for common business entities (Customers, Orders, Employees, Invoices).
    • A step-by-step wizard dialog guides the user to select fields from sample tables, configure primary keys, and establish foreign-key relationships automatically.

Q29. Windows GUI Mastery: Detailed functions of Windows Editor Notepad, Paint, Control Panel, and Network Neighbourhood.

🔥 Repeated: 2013, 2014, 2015, 2020 15 Marks
✍️ Model Answer:

Functions of Windows Editor Notepad:

  1. Entering and Editing Text: Lightweight plain-text editor supporting unformatted ASCII/Unicode text.
  2. Moving around in text: Standard arrow keys, Home (beginning of line), End (end of line), Ctrl+Home (top of document), Ctrl+End (bottom of document).
  3. Entering Time and Date: Pressing shortcut key F5 instantly prints current system timestamp (e.g., 11:45 AM 14-Nov-2026).
  4. Searching and Replacing: Ctrl+F opens Find dialog; Ctrl+H opens Replace dialog.
  5. Page Setup & Printing: File → Page Setup allows setting Margins (Left, Right, Top, Bottom) and adding Headers & Footers (&d for date, &p for page number); Ctrl+P prints document.

Control Panel: Central administrative console for configuring system hardware, network adapters, user passwords, date/time, and Add/Remove programs.

Network Neighbourhood: Windows feature that displays all computers, shared network printers, and network drives on the local area network (LAN).

Q30. Write an in-depth note on MS-PowerPoint: Slide Master, Transitions, Animations, and Presentation Delivery.

🔥 Repeated: 2011, 2013, 2018, 2019 15 Marks
✍️ Model Answer:

MS-PowerPoint is a presentation graphics package that creates professional slide shows combining text, graphics, charts, video clips, and audio narrations.

Core Features of MS-PowerPoint:

  • Slide Master: The top slide in the hierarchy that stores theme and layout information (fonts, background, logos). Changes made to the Slide Master automatically apply to every slide in the presentation.
  • Slide Transitions: Motion effects that occur when advancing from one slide to the next during a slide show (Fade, Push, Wipe, Zoom).
  • Custom Animations: Entrance, emphasis, and exit motion applied to individual text boxes, images, or bullet points on a slide.
  • Speaker Notes & Handouts: Presenter view allows the speaker to see hidden notes and upcoming slides on their private monitor while audiences view the full slide on a projector.
  • Delivery Controls: Shortcut F5 starts slide show from beginning; Shift+F5 starts from current slide; Esc exits.

Q31. What is Assembly Language? Explain its advantages and disadvantages over Machine Level Language. Explain features of DOS.

🔥 Repeated: 2020 15 Marks
✍️ Model Answer:

Assembly Language: A low-level programming language that replaces obscure binary machine code with human-readable symbolic abbreviations called Mnemonics (e.g., MOV AX, BX; ADD AX, 05; JMP loop).

Advantages over Machine Level Language:

  • Easier to Understand and Code: Using mnemonics instead of long strings of 0s and 1s makes programming far less error-prone.
  • Easier Debugging: Locating errors in assembly syntax is straightforward compared to checking binary digits.
  • Symbolic Addressing: Variables and memory locations are given symbolic names (e.g., SUM, COUNT) rather than absolute hexadecimal hardware addresses.

Disadvantages:

  • Machine Dependent: Assembly programs written for Intel x86 processors cannot execute on ARM or RISC processors.
  • Requires Translation: Requires an Assembler program to convert mnemonics into executable binary machine code before execution.