KSAWU----SEP 2024 BA 1sem and Sem Office tools and C programs

Course Title: Office Management Tools Lab.

Course Code: 24BACAML1.2 

Credits: 2 Hrs/Week: 4 Hrs                                                     Contact Hours: 45

Formative assessment: 10 marks Term end exam: 40 marks Exam duration: 03 hrs

Students shall gain knowledge of computer hardware and software. Understand basics of

operating systems for using office automation tools.

open office  Software Click Here

Part A: MS Office

1. Microsoft Word: Assignments on preparing word documents using different features of MS Word.

2. Microsoft Excel: Assignments on creating excel worksheets using different data, applying formulas, creating charts.

3. Microsoft Power Point: Assignments on Creating presentations slides using different features of power point.  Powerpoint basic

Part B:

4. Draft a letter asking for quotations of different peripheral devices for your computer lab and mail the letter using mail merge in open office writer.

5. Create a database of students, which contains marks obtained by students of a class in different subjects and then calculate maximum, minimum, average and sum of marks in each subject. Also calculate % of each student using functions and formulas in Libre/Open Office Calc also draw pie chart and bar graph also.

6. Make a simple presentation on your college, use 3D effects, animation on network

topologies.

7. Demonstrate how to create email-id and uploading and downloading files.