Fundamentals of (ICT) 22001 Syllabus MSBTE Diploma I Scheme.

l. RATIONALE

In any typical business setup in order to carry out routine tasks related to creating business documents. perform data analysis and its graphical representations and make electronic slide show presentations, the student needs to learn. various software as office automation tools like word processing applications. spreadsheets and presentation tools. They also need to use these tools for making their project reports and presentations. The objective of this course is to develop the basic competency in students for using these office automation tools to

accomplish the job.

2. COMPETENCY

The aim of this course is to help the student to attain the following industry identified competencies through various teaching-learning experiences:

Use computers for internet services, and electronic documentation slide presentations.

4. TEACHING AND EXAMINATION SCHEME

Fundamentals of (ICT) 22001 Syllabus MSBTE Diploma I Scheme

(~'): For the courses having an ONLY practical examination, the PA has two components under
practical marks i.e, the assessment of practicals (seen in section 6) has a weightage of 60%
/ie.15 marks) and micro-project assessment (seen in section 12) has a weightage of 40%
(i.e. 10 marks}. This is designed to facilitate the attainment of COs holistically. as there is no
theory ESE.
Legends: L-Lecture: T — Tutorial/Teacher Guided Theory Practice: P - Practical; C — Credit
ESE - End Semester Examination: PA - Progressive Assessment: # No theory exam

s.no	Practical Outcomes (PrOs)	unit no.	approx hrs required
1	Manage files and folders. Create, copy, rename, delete, move files and folder	I	1
	Word Processing
2	Create, edit and save a document: apply formatting features on the text - line. paragraph	II	2*
3	Use bullets, and numbering. page formatting	II	2
4	insert and edit images and shapes, sizing, cropping,, color background, group/ ungroup.	II	2
5	Insert ard apply various table formatting features on it	II	2
6	Apply page layout features ) I. Themes, page background., paragraph, page setup ii. Create multicolumn page iii. Use different options to print the documents	II	2*
7	use mail merges with options.	II	1
	spreadsheet	III
8	Create, open and edit worksheet I. Enter data and format it, adjust row height and column width ii. Insert and delete cells, rows, and columns iii. Apply wrap text, orientation feature on cell	III	2
9	Insert formulas, “IF” conditions, functions, and named ranges in the worksheet	III	2*
10	Apply data Sort, Filter, and Data Validation features	III	2
11	Create charts to apply various chart options.	III	1
	Apply Page setup and print options for the worksheet to print the worksheet
12	Presentation Tool	IV	2*
13	Create slide presentation I. Apply design themes to the given presentation ii. Add new slides and insert pictures/images, shapes	IV	2
14	Add tables and charts in the slides Run slide presentations in different modes Print slide presentations as handouts	IV	1
15	Apply animation effects to the text and slides	IV	1
	Add audio and video files in the given presentation
16	Internet Basics	V	1
17	Configure Internet connection	V	1
18	Use the internet for different web services	V	2*
19	configure browser settings and use browsers		1*
20	total		32

3. COURSE OUTCOMES (COs)

The theory, practical experiences, and relevant soft skills associated with this course are to be taught and implemented. so that the student demonstrates the following industry-oriented COs associated with the above-mentioned competency:

Use the computer system and its peripherals.
Prepare business documents using a word processing tool.
interpret data and represent it graphically using a spreadsheet
Prepare professional presentations.
Use different types of web browsers.

4. SUGGESTED MICRO-PROJECTS

Only one micro-project is planned to be undertaken by a student assigned to him/her at the beginning of the semester. S/he ought to submit it by the end of the semester to develop the industry-oriented COs. Each micro-project should encompass two or more COs which are in fact, integration of PrOs. UOs and ADOs, The micro-project could be industry application based. internet-based, workshop-based. laboratory-based or field-based, Each student will have to maintain a dated work diary consisting of individual contributions in the project work and give a seminar presentation of it before submission. The total duration of the microproject should not be less than /6 (sixteen) student engagement hours during the course In the first four semesters. the micro-project could be group-based. However, in higher semesters. it should be individually undertaken to build up the skill and confidence in every student to become a problem solver so that s/he contributes to the projects of the industry. a suggestive list is given here. Similar micro-projects could be added by the concerned faculty:

a. Word documents: Prepare Time Table, Application, Notes, Reports (Subject teacher shall assign a document to be prepared by each student).

b. Slide Presentations: Prepare slides with all Presentation features such as classroom presentations, presentations about departments, and presentations of reports. (Subject teacher shall assign a presentation to be prepared by each student)

c. Spreadsheets: Prepare Pay bills, tax statements, and student assessment records using a spreadsheet. (Teacher shall assign a spreadsheet to be prepared by each student).

5. SUGGESTED LEARNING RESOURCES

S.NO	Title of book	Author	Publication
1	Computer Fundamentals	Goel, Anita	Pearson Education, New Delhi, PO _ 2014, ISBN: 978-8131733097
2	Computer Basics Absolute Beginner's Guide, Windows 10	Miller. Michael	QUE Publishing; 8th edition August 2015, ISBN: 978-0789754516
3	Linux: Easy Linux for Beginners	Alvaro, Felix	CreateSpace Independent Publishing Platform- 2016, ISBN: 978-153368373 1
4	Microsoft Office 2010: On-Demand	Johnson, Steve	Pearson Education, New Delhi India, 2010: ISBN: 9788131770641
5	Microsoft Office 2010 for Windows: Visual Quick Start	Schwartz. Steve	Pearson Education, New Delhi India, 2012, ISBN:9788131 766613 Wiley Publishing, New Delhi. 2003 ISBN: 978-0764542220
6	OpenOffice.org for Dummies	Leete, Gurdy, Finkelstein Ellen, Mary Leete	Wiley Publishing, New Delhi. 2003 ISBN: 978-0764542220
7	Computer Fundamentals	Dr. Rajendra Kawale	Devraj Publications, Dist Solapur. Maharashtra