ADVANCE DIPLOMA IN COMPUTER APPLICATION (ADC0766)

 

Course:ADVANCE DIPLOMA IN COMPUTER APPLICATION (ADC0766)
Duration:1 Year
Content:Computer Concept & Fundamentals, Operating System, Note Pad, Word Pad, MS Paint, MS Office (Word, Excel, Power Point, Access), Typing Master, Tally Prime (Basic Introduction), DTP ( Photoshop, Corel Draw), Introduction to Internet & Email, HTML,CSS, Bootstrap, Project / Assignment.


SYLLABUS & Content wise Marks Distribution:

তলৰ SYLLABUS ত CLICK কৰি লাগতিয়াল প্রশ্ন-উত্তৰবোৰ বা 'Theory' বোৰ শিকা । আৰু Video ৰ Linkত Click কৰি ইয়াৰ বিষয়ে Practical চোৱা ৷ 


1st Semester or PART-I

1.Computer Fundamentals- 30 Marks

(a) THEORY (COMPUTER FUNDAMENTAL), MCQ

(b) COMPUTER FUNDAMENTAL WRITTEN AND SHORT NOTE

(c)

 PRACTICAL (COMPUTER FUNDAMENTAL) VIDEO (YOUTUBE)


2.Operating System (Windows)- 10 Marks,

(a)THOERY (OPERATING SYSTEM), MCQ

(b) OPERATING SYSTEM WRITTEN AND SHORT NOTE

(c) PRACTICAL (OPERATING SYSTEM) VIDEO (YOUTUBE)


3. Note Pad

(a) Note Pad MCQ

(b) Note Pad Theory (from Wikipedia)

(c) Note Pad Information Video (Hindi from Youtube)


4. WordPad

(a) WordPad MCQ

(b) WordPad Theory (from Wikipedia)

(c) WordPad Practical (Video from Youtube) 


5. MS Paint

(a) MS Paint MCQ

(b) MS Paint Theory (from Wikipedia) 

(c) MS Paint Video (from youtube) 


Microsoft Office


6.

(Word/10,

(a) THEORY (WORD) MCQ,  

(b) MS WORD WRITTEN AND SHORT NOTE

(c) Video-1

PRACTICAL (WORD)


7.

Excel/10,

THEORY (EXCEL) MCQ,

MS EXCEL WRITTEN AND SHORT NOTE

 Video-1

PRACTICAL (EXCEL)


Video-2

PRACTICAL (EXCEL)


8.

Power Point/10,

 THEORY (POWER POINT) MCQ,

MS POWERPOINT WRITTEN AND MCQ

Video-1

PRACTICAL (POWER POINT)



9.

Access/10)- 40 Marks

 THEORY (ACCESS), MCQ,

MS ACCESS WRITTEN AND SHORT NOTE,

Video-1

PRACTICAL (ACCESS)

 


SOME PRACTICAL OR MOCK QUESTIONS, COURSE: ADCA0766

PART-I


Syllabus / Topics

PRACTICAL OR MOCK QUESTIONS

Computer Concept &  Fundamentals: 10 Marks

Fitting a computer with all required devices (Input, Processing & Output). Or Ask Mock.

Operating System (Windows): 10 Marks

Make a user account & a password. / Mock

MS Word (MS Office): 10 Marks

Write an application in MS Word.  / Mock

Or: Make your Bio-data or Resume in Microsoft Word.  / Make an any table.

MS Excel (MS Office): 10 Marks

Make five students’ mark sheet data in MS Excel. / Show uses of five formulas. / Mock

MS PowerPoint (MS Office): 10 Marks

Prepare a presentation in MS PowerPoint (Include Slide, Design & Animations) / Mock

MS Access (MS Office): 10 Marks

Create a digital record form in MS Access (Using Table, Buttons, & Designs) / Mock

Notepad: 10 Marks

Write Name & Reg. No. in notepad. / Mock

WordPad: 10 Marks

Insert a picture in WordPad. / Mock

MS Paint: 10 Marks

Draw an any picture in MS Paint. / Mock

Computer Concept: 10 Marks

Show the process of shutdown a computer.

or Computer Fundamentals: 10 Marks

Show the process of connecting any Pen Drive or USB drive. / Mock

or: Oral on the course syllabus:

 

 





2nd Semester or PART-II: 

Typing Master, Tally Prime (Basic Introduction), DTP ( Photoshop, Corel Draw), Introduction to Internet & Email, HTML,CSS, Bootstrap, Project / Assignment.



TYPING MASTER:



VIDEO:







Tally Prime (Basic Introduction):



VIDEO:


DTP ( Photoshop, Corel Draw):



VIDEO:





VIDEO:


Introduction to Internet & Email:



VIDEO:





VIDEO:


HTML:



VIDEO:



CSS:


VIDEO:


Bootstrap:

BOOTSTRAP NOTES (FROM WIKIPEDIA, FOR WRITTEN)

VIDEO:

BOOTSTRAP PRACTICAL VIDEO-1 FROM YOUTUBE




# SOME PRACTICAL QUESTIONS ON THE TOPICS: 1.Typing Master, 2.Tally Prime (Basic Introduction), 3.DTP 3.(A)Photoshop, 3(B).Corel Draw), 4.Introduction to Internet & 5.Email, 6.HTML, 7.CSS, 8.Bootstrap

FROM GOOGLE GEMINI:

*Here is a set of practical, hands-on questions and assignments designed to test and build real-world skills across these topics. They are structured to move from basic operational tasks to creative design and coding.


1. Typing Master & Keyboard Proficiency

  • Warm-up: Complete a 5-minute typing test. Note your initial WPM (Words Per Minute) and Accuracy percentage.

  • Blind Typing Challenge: Type a printed paragraph of 100 words without looking down at the keyboard even once.

  • Accuracy Focus: Type a complex text containing numbers and special symbols (e.g., #, @, &, *) aiming for 98% accuracy, regardless of speed.

2. Tally Prime (Basic Introduction)

  • Company Creation: Create a new company named "Alpha Traders" for the current financial year. Set up the currency configuration.

  • Ledger Creation: Create the following ledgers under their correct accounting groups:

    • Capital A/c

    • State Bank of India (Bank A/c)

    • Purchase A/c

    • Sales A/c

    • XYZ Distributors (Sundry Creditors)

  • Voucher Entry: Record a transaction where "Alpha Traders" purchases goods worth RS10,000 from XYZ Distributors on credit, and then make a partial payment of RS 5,000 via the Bank voucher.

3. Desktop Publishing (DTP)

A. Adobe Photoshop

  • Passport Photo Layout: Take any portrait image, remove its original background smoothly, replace it with a solid blue background, and arrange 8 passport-sized copies on an A4 canvas ready for printing.

  • Image Restoration: Take an old or damaged digital photo, use the Clone Stamp and Healing Brush tools to remove scratches/blemishes, and adjust the brightness/contrast to make it look new.

B. CorelDRAW

  • Business Card Design: Design a professional, double-sided business card (3.5 \times 2 inches). Use vector shapes, align text perfectly, and incorporate a custom logo using the Pen tool.

  • Trifold Brochure: Create a layout for a 3-page folding brochure. Set up precise guidelines for folding margins and design a cohesive color palette for the background and text headers.

4. Introduction to Internet & 5. Email

  • Advanced Search Techniques: Use Google Search operators to find a specific PDF document about "Web Design Trends 2026" exclusively from educational domains (.edu).

  • Professional Email Etiquette: Compose a mock job application email. You must:

    • Attach a dummy resume file.

    • Use the CC field to send a copy to your personal backup email.

    • Create and insert a formal text-based Email Signature at the bottom.

6. HTML & 7. CSS

  • Semantic Structure: Create a basic portfolio webpage using HTML5 structural elements (<header>, <nav>, <main>, <section>, <footer>).

  • Data Layout: Build a 4x3 HTML table showcasing a weekly class timetable, merging cells for lunch breaks using colspan or rowspan.

  • CSS Styling: Link an external CSS file to your HTML page to:

    • Change the font family to a clean sans-serif.

    • Create a navigation bar where links change color smoothly when hovered over (transition property).

    • Center a <div> box both vertically and horizontally using CSS Flexbox.

8. Bootstrap

  • Responsive Grid System: Build a photo gallery webpage using the Bootstrap grid. Ensure it displays:

    • 1 column on mobile screens (col-12)

    • 2 columns on tablets (col-md-6)

    • 4 columns on desktops (col-lg-3)

  • Component Assembly: Create a landing page navbar that collapses into a hamburger menu on small devices. Add a responsive Jumbotron/Hero section below it with a functional Bootstrap Button component.



*SOME NEW UPDATES MAY ADD IN FUTURE


No comments:

Post a Comment

Subscribe to: Posts (Atom)