21CSL381 Mastering Office syllabus for IS

MS-Word -

Working with Files, Text – Formatting, Moving, copying and pasting text, Styles – Lists – Bulleted and numbered lists, Nested lists, Formatting lists. Table Manipulations. Graphics – Adding clip Art, add an image from a file, editing graphics, Page formatting - Header and footers, page numbers, Protect the Document, Mail Merge, Macros – Creating & Saving web pages, Hyperlinks.

MS-Excel-

Modifying a Worksheet – Moving through cells, adding worksheets, rows and columns, Resizing rows and columns, selecting cells, Moving and copying cells, freezing panes - Macros – recording and running. Linking worksheets - Sorting and Filling, Alternating text and numbers with Auto fill, Auto filling functions. Graphics – Adding clip art, add an image from a file, Charts – Using chart Wizard, Copy a chart to Microsoft Word.

MS-Power Point -

Create a Presentation from a template- Working with Slides – Insert a new slide, applying a design template, changing slide layouts – Resizing a text box, Text box properties, delete a text box - Video and Audio effects, Color Schemes & Backgrounds Adding clip art, adding an image from a file, Save as a web page.

MS-Access -

Using Access database wizard, pages and projects. Creating Tables – Create a Table in design view. Datasheet Records – Adding, Editing, deleting records, Adding and deleting columns Resizing rows and columns, finding data in a table & replacing, Print a datasheet. Queries - MS-Access.

Microsoft Outlook-

Introduction, Starting Microsoft Outlook, Outlook Today, Different Views In Outlook, Outlook Data Files

Course Outcomes (Course Skill Set):

At the end of the course the student will be able to:

CO 1. Know the basics of computers and prepare documents, spreadsheets, make small presentations with audio, video and graphs and would be acquainted with internet.

CO 2. Create, edit, save and print documents with list tables, header, footer, graphic, spellchecker, mail merge and grammar checker

CO 3. Attain the knowledge about spreadsheet with formula, macros spell checker etc.

CO 4. Demonstrate the ability to apply application software in an office environment.

CO 5. Use Google Suite for office data management tasks

Assessment Details (both CIE and SEE)

• The weightage of Continuous Internal Evaluation (CIE) is 50% and for Semester End Exam (SEE) is 50%.
• The minimum passing mark for the CIE is 40% of the maximum marks (20 marks).
• A student shall be deemed to have satisfied the academic requirements and earned the credits allotted to each course. The student has to secure not less than 35% (18 Marks out of 50) in the semester-end examination (SEE).

Continuous Internal Evaluation (CIE):

NOTE: List of experiments to be prepared by the faculty based on the syllabus mentioned above.

CIE marks for the practical course is 50 Marks.

The split-up of CIE marks for record/ journal and test are in the ratio 60:40.

• Each experiment to be evaluated for conduction with observation sheet and record write-up. Rubrics for the evaluation of the journal/write-up for hardware/software experiments designed by the faculty who is handling the laboratory session and is made known to students at the beginning of the practical session.
• Record should contain all the specified experiments in the syllabus and each experiment write-up will be evaluated for 10 marks.
• Total marks scored by the students are scaled downed to 30 marks (60% of maximum marks).
• Weightage to be given for neatness and submission of record/write-up on time.
• Department shall conduct 02 tests for 100 marks, the first test shall be conducted after the 8th week of the semester and the second test shall be conducted after the 14th week of the semester.
• In each test, test write-up, conduction of experiment, acceptable result, and procedural knowledge will carry a weightage of 60% and the rest 40% for viva-voce.
• The suitable rubrics can be designed to evaluate each student’s performance and learning ability. Rubrics suggested in Annexure-II of Regulation book
• The average of 02 tests is scaled down to 20 marks (40% of the maximum marks).

The Sum of scaled-down marks scored in the report write-up/journal and average marks of two tests is the total CIE marks scored by the student.

Semester End Evaluation (SEE):

SEE marks for the practical course is 50 Marks.

• SEE shall be conducted jointly by the two examiners of the same institute, examiners are appointed by the University
• All laboratory experiments are to be included for practical examination.
• (Rubrics) Breakup of marks and the instructions printed on the cover page of the answer script to be strictly adhered to by the examiners. OR based on the course requirement evaluation rubrics shall be decided jointly by examiners.
• Students can pick one question (experiment) from the questions lot prepared by the internal /external examiners jointly.
• Evaluation of test write-up/ conduction procedure and result/viva will be conducted jointly by examiners.
• General rubrics suggested for SEE are mentioned here, writeup-20%, Conduction procedure and result in -60%, Viva-voce 20% of maximum marks. SEE for practical shall be evaluated for 100 marks and scored marks shall be scaled down to 50 marks (however, based on course type, rubrics shall be decided by the examiners)
• The duration of SEE is 02 hours

Rubrics suggested in Annexure-II of Regulation book