Can anyone provide the Syllabus of Computer Skill which is compulsory subject in B.Sc 2nd SEM of Dibrugarh University ? Provide the past B.Sc 2nd SEM Computer Skill exam question papers for practice so that I get pass with good marks .

Computer Skill Course is recommended for the B.A. Program in the Semester System as a necessary Course for both General and Major Programs incorporated into the third Semester.

The Course plans to give essential learning of Computer programming and its down to earth applications, which is perceived as a critical apparatus in all fields of advanced scholastics, correspondence and data innovation.

The Course is isolated in two gatherings, Theory (Group A) and Practical (Group B)

GROUP A
PC SOFTWARE (End Semester: 48 and Internal Assessment 12marks)

UNIT I:
MS-Windows: Operating system-Definition & functions, basics of Windows.
Basic components of windows, icons, types of icons, taskbar, activating
windows, using desktop, title bar, running applications, exploring computer,
managing files and folders, copying and moving files and folders. Control
panel – display properties, adding and removing software and hardware,
setting date and time, screen saver and appearance. Using windows
accessories. Classes allotted 8; Marks 10

UNIT-II:
Documentation Using MS-Word - Introduction to Office Automation,
Creating & Editing Document, Formatting Document, Auto-text, Autocorrect,
Spelling and Grammar Tool, Document Dictionary, Page Formatting,
Bookmark, Advance Features of MS-Word-Mail Merge, Macros, Tables, File
Management, Printing, Styles, linking and embedding object, Template.
Classes allotted 6; Marks 10

UNIT III:
Electronic Spread Sheet using MS-Excel - Introduction to MS-Excel, Creating
& Editing Worksheet, Formatting and Essential Operations, Formulas and
Functions, Charts, Advance features of MS-Excel-Pivot table & Pivot Chart,
Linking and Consolidation.
Classes allotted 6; Marks 10

UNIT IV:
Database Management using Excel-Sorting, Filtering, Table, Validation, Goal
Seek, Scenario.
Classes allotted 4; Marks 8

UNIT V :
Presentation using MS-PowerPoint: Presentations, Creating, Manipulating &
Enhancing Slides, Organizational Charts, Excel Charts, Word Art, Layering
art Objects, Animations and Sounds, Inserting Animated Pictures or Accessing
through Object, Inserting Recorded Sound Effect or In-Built Sound Effect.
Classes allotted 6; Marks 10

GROUP B
Practical (End Semester: 32 and Internal Assessment 8 marks)

1. MS-Windows
2. Documentation Using MS-Word
3. Electronic Spread Sheet using MS-Excel
4. Database Management using Excel
5. Presentation using MS-PowerPoint
6. Practical Handbook
7. Viva-voce