Course

Unit I

Introduction to Computers & Networks 6hrs.

Introduction to Computers – Operating System, CPU, Input and Output Devices, Main and Auxiliary Storage Devices, Software and Hardware, Introduction to Computer Networks, Basics of HTML, WWW, URL, Email, Network Security

Unit II

Word Processing and Spreadsheets 6hrs.

Word Processing- Basics of creating a document, Formatting a document, Printing a document. Spreadsheet – Basics of creating a worksheet, Creating tables, charts, pivot table & charts, Working with formulas

Unit III

Database Management system and Presentation 6hrs.

Database Management system – Creating a database table, queries, Developing forms and reports, Presentation- Creating a presentation using slide master and template, Formatting the slides, Animations, Transitions, Slide show

Unit IV

Multimedia 6hrs.

Introduction of multimedia, Basic Elements, Hardware, Applications of Multimedia, Authorizing Tools, Introduction to Video, and Audio editing software’s.

Unit V

Application of Computers in Food Science and Nutrition 6hrs.

Applications – Nutrition Education and Counselling, Nutrient and Diet calculations, Use of statistical software, Accessing Digital Library, e-Journals in Food Science and Nutrition, Relevant Nutrition software’s, Applications and Webpages.

Pre requisite: Basics of computer usage, Windows, Microsoft office

Course Objectives:

1. To learn the computer peripherals in the operation of computers
2. To understand the computer network in sharing of information through computers
3. To acquire the skills in the applications of windows in documentation, data analysis and presentation

Course Outcomes:

CO1: Understanding the basic Components of Computers and Network elements.

CO2: Developing professional-looking newsletters, pamphlets, charts, simple calculations etc using the authorizing tools

CO3: Able to create and manage databases & develop a presentation skills using the authorizing tools CO4: Elicit multimedia presentation focusing on utilization of authorizing tools.

CO5: Able to apply computer applications in meal management practices and explore the nutritional software’s and ejournals in professional and academic endeavours.

Skills: Acquire the skills in exploring windows applications in development of documents, data analysis in spread sheet and power point presentation.

CO-PO Mapping

Evaluation pattern:

*Lab evaluation 20 marks, Project 10 marks, Assignment/seminar 10 marks.

Text books:

1. Microsoft Office 2019 Complete, BPB Publications
2. Dinesh Maidasani – Learning Computer Fundementals, MS Office and Internet and Web Technology, Laxmi Publications

Reference Books:

1. BPB’s Computer Course Windows 10 with MS Office
2. John Walkenbach Herb Tyson Michael R. Groh FaitheWempen Lisa A. Bucki – Microsoft Office 2010 Bible, Wiley
3. Andrew Tanenbaum (2009) IV Edition, Computer Networks, Pearson Education and Dorling Kindersley Publishers, Delhi.
4. Ralf Steinmetz and Klara Nahrstedt (2011) Multimedia- Computing, Communications and Applications, Pearson Education and Dorling Kindersley Publishers, Delhi.
5. Learn Microsoft Office 2019: A comprehensive guide to getting started with Word, PowerPoint, Excel, Access, and Outlook by Linda Foulkes