DIPLOMA IN IT PRABESH (D.I.T.P)

Chapter details

1. ✓ What is computer? Who invented the computer?
2. ✓ The full form of the Computer
3. ✓ Basic parts of Computer.
4. ✓ How to start / Restart/shutdown, Screen lock?
5. ✓ Hibernate shutdown, hibernate by CMD
6. ✓ Change Desktop Background /How set multiple pictures on the desktop.
7. ✓ Show/Hide system icon
8. ✓ Set screensaver 3D Text
9. ✓ How to show/hide the system Icons on Windows 7

Chapter details

1. ✓ Learn about File / Folder
2. ✓ How to create a folder?
3. ✓ File/Folder Delete Process
4. ✓ How to rename file or folder
5. ✓ How to change the file/folder icon?
6. ✓ How to hide a folder?
7. ✓ How to unhide a folder?
8. ✓ How to create a notepad?
9. ✓ How to create a shutdown batch file using notepad
10. ✓ List of shortcut keys

Chapter details:

1. ✓ Advantages & Disadvantages of computer
2. ✓ Von Neumann Architecture
3. ✓ Classification of computer
4. ✓ Hardware and software
5. ✓ Input-Output Device
6. ✓ Classification of monitor
7. ✓ Printer
8. ✓ Software | Classification of software

Chapter Details:

1. ✓ Desktop
2. ✓ About Recycle bin
3. ✓ File Extension
4. ✓ Memory Unit and Size
5. ✓ Classification of Memory unit
6. ✓ Primary Memory
7. ✓ Secondary memory
8. ✓ Users & User account
9. ✓ Create / Manage user account by MMC
10. ✓ How to Reset Windows 7 Password?
11. ✓ Switch user, Log off
12. ✓ How to take a screenshot?
13. ✓ Open Calculator, time and date change
14. ✓ Run Commands for Windows 7
15. ✓ Full forms

Chapter details

1. ✓ Remote Desktop connection
2. ✓ Computer Front pannel & back panel
3. ✓ Desktop computer assembling

1. What is Microsoft Word

✓ Extension of Microsoft Word

✓ How to start Microsoft Word

2. File tab

✓ New File

✓ Open File

✓ Save and Save as a File

✓ Converting Word document into PDF

✓ Difference between Save and Save as

3. Keyboard Shortcuts of MS Word

✓ A to Z alphabetical keyboard shortcuts

✓ Others shortcuts & Mouse click shortcuts

1. Page Setup

✓ Page Size, Orientation, Margins 

✓ Columns, Page Break

✓ Borders ad colors

2. Font

✓ Text color, Highlighter, Font effects (Bold, Italic, underline, strike through)

✓ Change case

✓ Subscript, superscript

✓ Format painter

3. Paragraph settings

✓ Bullets, numbering

✓ Multilebel list

4. Insert

✓ Table (marge, color and format)

✓ Pictures (insert Pictures, format, change pictures)

✓ Shapes (insert shapes, color,text)

✓ Smart Art (make a smart Art chart of a memory unit)

✓ Screenshot

1. Page Setup

✓ Page Size, Orientation, Margins 

✓ Columns, Page Break

✓ Borders ad colors

2. Font

✓ Text color, Highlighter, Font effects (Bold, Italic, underline, strike through)

✓ Change case

✓ Subscript, superscript

✓ Format painter

3. Paragraph settings

✓ Bullets, numbering

✓ Multilebel list

4. Insert

✓ Table (marge, color and format)

✓ Pictures (insert Pictures, format, change pictures)

✓ Shapes (insert shapes, color,text)

✓ Smart Art (make a smart Art chart of a memory unit)

✓ Screenshot

1. ✓ What is excel?
2. ✓ How to start excel?
3. ✓ What is the workbook, and what is worksheet?
4. ✓ Worksheet rename, color, delete, add.
5. ✓ What is the cell? What is a column? What is the row? (insert a column, insert row, delete row)
6. ✓ What is a formula bar? What is the name box?
7. ✓ Some keyboard shortcuts.

1. ✓ Fill handle -
2. ✓ sum formula -
3. ✓ basic formula - (today, now, some, counta)
4. ✓ Average formula -
5. ✓ Dropdown list (static, dramatic)
6. ✓ Data validation
7. ✓ Conditional formatting (duplicate value, text that, equal to, etc.)
8. ✓ Format as a table.
9. ✓ Chats

1. ✓ Create a number table one to many relations.
2. ✓ Concatenation
3. ✓ If condition,countif, multiple if condition, and function.
4. ✓ Data filter, data shorting, charts.
5. ✓ goal seek
6. ✓ V-lookup
7. ✓ Macro recording
8. ✓ Project (invoice, school mark sheets, employee attendance, Train ticket booking system)
9. ✓ Print sheet.