ANU UG 1st Sem Computer Fundamentals Lab Experiment 1 — Assembling & Disassembling of Computer System

 Aim:

To study, identify, assemble, and disassemble the various hardware components of a computer system.

Objective:

• To familiarize with the internal and external parts of a computer.
• To understand the role and interconnections of each component.
• To learn how to properly assemble and disassemble a desktop computer.
• To practice safety measures while handling hardware components.

Apparatus / Requirements:

• System Unit (CPU Cabinet)
• Motherboard
• Processor (CPU)
• RAM Modules
• Hard Disk / SSD
• SMPS (Power Supply)
• Optical Drive (if available)
• Monitor, Keyboard, Mouse
• Screwdriver Set, Anti-static Wrist Strap, Cleaning Brush
• Connecting Cables (SATA / Power Cables)

Theory:

A computer system consists of input, output, storage, and processing units.

• Assembling involves integrating all internal hardware components such as motherboard, CPU, RAM, storage drives, and power supply into the cabinet and connecting external peripherals.
• Disassembling is the reverse process, performed carefully to avoid damage.Proper handling ensures the computer’s performance, longevity, and maintenance safety.Understanding each component’s location, function, and connection is vital for troubleshooting and hardware upgrading.

Procedure:

A. Disassembling Steps:

1. Power off the computer and unplug all cables.
2. Remove the cabinet side panels using a screwdriver.
3. Disconnect all internal power and data cables.
4. Carefully remove the hard disk, RAM, SMPS, and CPU fan.
5. Unscrew the motherboard from the base plate.
6. Arrange all components systematically and label them.

B. Assembling Steps:

1. Fix the motherboard into the CPU cabinet using screws and spacers.
2. Insert the processor into the CPU socket and lock it properly.
3. Apply thermal paste and mount the CPU fan.
4. Insert RAM into the memory slots carefully.
5. Connect the power supply (SMPS) and plug in 24-pin and 4-pin connectors to the motherboard.
6. Mount storage devices (HDD/SSD) and connect SATA power and data cables.
7. Connect front-panel connectors (Power SW, Reset, LED indicators).
8. Close the cabinet panels, reconnect peripherals (monitor, keyboard, mouse).
9. Power ON the system and check if POST (Power-On Self-Test) completes successfully.

Precautions:

• Always switch off the power and remove cables before handling components.
• Use an anti-static wrist strap to avoid electrostatic discharge (ESD).
• Handle components by edges; never touch circuitry.
• Maintain proper grounding and avoid metallic contact.
• Organize screws and small parts to prevent misplacement.

Observation Table:

Component Name	Type / Capacity	Slot / Port	Status (Working / Faulty)
Motherboard	ATX / Micro ATX	Cabinet	Working
Processor	Intel Core / AMD	CPU Socket	Working
RAM	8 GB DDR4	DIMM Slot	Working
Hard Disk	500 GB HDD	SATA Port	Working
SMPS	450 W	Cabinet	Working

Result:

Successfully demonstrated the assembling and disassembling of a computer system. Identified and described the function of each hardware component.

Viva Questions:

1. What are the main components inside a system unit?
2. Why is an anti-static wrist strap important?
3. What is the function of the SMPS?
4. Define POST in a computer.
5. What are the differences between HDD and SSD?

ANU UG/Degree 1st Sem Computer Fundamentals and Office Automation Lab Manual

 ANU UG/Degree 1st Sem Computer Fundamentals and Office Automation Lab Manual: Get the complete ANU UG/Degree 1st Sem Computer Fundamentals & Office Automation Lab Manual — with practical exercises, sample tasks, and download link. Ideal for B.Sc / B.Com students preparing for lab exams and assignments. 

If you're a student enrolled in the ANU UG / Degree 1st Semester course, the Computer Fundamentals & Office Automation Lab Manual is an essential companion for your practical sessions. This lab manual covers hands-on tasks using MS Office tools—Word, Excel, PowerPoint—and core computer fundamentals that build your foundation in computing.

Let’s get started!

List of Experiments:

1. Demonstration of Assembling and Dessembling of Computer Systems.

2. Identify and prepare notes on the type of Network topology of your institution.

3. Prepare your resume in Word.

4. Using Word, write a letter to your higher official seeking 10-days leave.

5. Prepare a presentation that contains text, audio and video.

6. Using a spreadsheet, prepare your class Time Table.

7. Using a Spreadsheet, calculate the Gross and Net salary of employees(Min 5) considering all the allowances.

8. Generate the class-wise and subject-wise results for a class of 20 students. Also generate the highest and lowest marks in each subject.

9. Using IF, AND, OR, and IFERROR to Automate Grade Evaluation.

   a. Create a table of student scores in different subjects.

   b. Use IF to assign grades (A/B/C/Fail).

   c. Use IFERROR to handle missing scores or invalid data.

10. Employee Database Search Using VLOOKUP, HLOOKUP, XLOOKUP, INDEX, and MATCH

    a. Create a database of employees (Name, ID, Department, Salary).

   b. Implement VLOOKUP to search by employee ID.

   c. Use HLOOKUP to extract department heads by role.

   d. Apply XLOOKUP for more flexible searches.

   e. Use INDEX + MATCH as an alternative to VLOOKUP.

11. Sales Report Analysis Using Pivot Tables and Charts

     a. Use a dataset of product sales (Product, Region, Date, Quantity, Revenue).

     b. Create Pivot Tables to summarize data by region/product.

     c. Insert Pivot Charts for visual analysis (e.g., bar, line).

    d. Add slicers to make the dashboard interactive.

12. Designing a Data Entry Form with Drop-downs and Input Rules

    a. Create a student registration form.

    b. Add drop-down lists for course selection using Data Validation

    c. Add input messages to guide users.

    d. Add error alerts for wrong entries.

13. Monthly Budget Planning using Goal Seek and Scenario Manager

      a. Create a simple personal budget (income, expenses, savings).

      b. Use Goal Seek to determine income needed to save a desired amount.

      c. Use Scenario Manager to compare different budgeting scenarios (best/ worst/ realistic case).

     d. Create a one-variable Data Table to analyze how different expenses affect savings.

14. Dashboard Creation Using Combo Charts, Sparklines & Slicers

     a. Use existing sales or attendance data.

     b. Insert combo charts (e.g., column + line).

     c. Add sparklines to show trends.

     d. Use slicers with Pivot Tables to control dashboard elements.

    e. Finalize and format for interactivity.

All the content is copyrighted and no one cant distribute any other format.

ANU PG (M.A, M.Sc, M.Com) 2nd Sem Reg / Supply Exam Results April 2025

  ANU PG (M.A, M.Sc, M.Com) 2nd Sem Reg / Supply Exam Results April 2025 are now available, the candidates who are looking for results can check their results from below links

Check your results from below links

M.A. POLITICAL SCIENCE II SEMESTER REGULAR EXAMINATIONS JULY-2025 RESULTS.

M.SC. PHYSICS II SEMESTER REGULAR EXAMINATIONS JULY-2025 RESULTS.

MASTER LIBRARY & INFORMATION SCIENCE II SEMESTER REGULAR EXAMINATIONS JULY-2025 RESULTS.

M.A. PERFORMING ARTS (CINEMA AND TV) II SEMESTER REGULAR EXAMINATIONS JULY-2025 RESULTS.

M.C.A II SEMESTER REGULAR EXAMINATIONS JULY-2025 RESULTS.

M.A. MUSIC (VOCAL) II SEMESTER REGULAR EXAMINATIONS JULY-2025 RESULTS.

M.A JOURNALISM & MASS COMMUNICATION II SEMESTER REGULAR EXAMINATIONS JULY-2025 RESULTS.

M.A. APPLIED LINGUISTICS AND TRANSLATION STUDIES II SEMESTER REGULAR EXAMINATIONS JULY-2025 RESULTS.

M.COM II SEMESTER REGULAR EXAMINATIONS JULY-2025 RESULTS.