Computers Applications (Practical)

Paper Code: 
FSD 124
Credits: 
6
Contact Hours: 
90.00
Max. Marks: 
100.00
Objective: 

This course will enable the students-

  1. To expose students to basic microeconomic concepts.
  2. To provide a method/ approach to help draw correct conclusions/ solve economic problems.
  3. To understand, explain and quantify the mechanism by which the total amount of resources possessed by society is allocated among alternative uses.

Course Outcomes (COs):

Courses

Learning outcomes (at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course Title

 

 

The students will be able to –

CO19 Explain the fundamental concepts of computers.

CO20 Analyse the use of office automation tools in daily work.

CO21Create effective and well formatted documents.

CO22 Design presentation using presentation tools and enhance presentation skills

CO23 Explain the advantage of collaborative documents

CO24 Apply internet knowledge for exploring research in the area of fashion & textiles

 

Approach in teaching :

Assessment task

 

 

Interactive       Lectures,

will include Class

 

FSD 124

 

Computers Applications (Practical)

Group Discussions, Powerpoint presentations, Video Tutorials

Learning Activities for the students: Self- learning assignments, Practice case studies and worksheets in Ms Word, Ms Excel and MS PowerPoint.

test, Semester end examinations,

student’s presentations and assignments.

 

6.00
Unit I: 
Introduction to Computers
  • Introduction to Computers (definition, characteristics & uses), Evolution of computers, System unit (memory, ALU & control unit), Input / Output devices, Storage devices (Memory- primary & secondary).
  • Introduction to Software, its type (system, application & utility); Programming languages (machine, assembly & high-level), Language processors (assembler, compiler & interpreter), Generation of computers.
  • Scanning of documents and pictures

 

6.00
Unit II: 
Windows
  • Windows explorer; Control panel, Setting wallpaper, screen saver, background. Creating a folder, Compressing/ Zipping files (WinZip), Virus & Antivirus.

 

20.00
Unit III: 
Microsoft Word
  • Introduction to Word Processor, Features & Shortcut keys of Word processors, Working with Documents, Editing Documents in Word, Formatting Documents, Formatting Paragraphs, Formatting Page Reference Concept
  • Inserting pictures, Hyperlinks & Clip Art, Understanding & creating Tables and Lists, Using Header and Footers Styles, Proofing text (Spell check, Auto correct), Mail Merge, Using Templates, Managing page formatting tools.

 

24.00
Unit IV: 
Microsoft Excel
  • Introduction to Spreadsheets & workbooks, creating, saving, editing & formatting a workbook, Features & Shortcut keys of Microsoft Excel
  • Filling series, fill with drag, data sort, cell referencing (Relative, Absolute, Mixed), What-if analysis Entering formula, Using Built-in Functions, Creation of List.
  • Working with Graphs, Using Chart Wizard, Using Logical Functions, Use of Macros, PIVOT Table & Chart Generation

 

24.00
Unit V: 
Microsoft PowerPoint
  • Introduction, uses & features of Microsoft Powerpoint, Presentation tips, components of slide, using templates and wizards, choosing an auto layout, using outlines, adding subheadings, editing text, formatting text, using master slide. Adding slides, changing color scheme, changing background and shading, adding header and footer, adding clip arts and auto shapes.
  • Various presentation, working in slide sorter view (deleting, duplicating, rearranging slides), adding transition and animations to slide show, inserting music or sound on a slide, inserting action buttons or hyperlinks for a presentation, set and rehearse slide timings, viewing slide show, Printing slides.

VI:Internet                                                                                                                      10 hrs

  • Internet Communication Protocols, Types of Internet Connections, ISPs, Domain Name System, Intranets, Email Concepts (receiving, sending, addressing, downloading, formatting, sending attachment).
  • Sending & Receiving Secure Email, chatting, conferencing, Email mailing list, Newsgroup, IRC, ICQ, Video mail and Video Conferencing.

 

Essential Readings: 

Suggested Text Books:

  • Norton Peter, (2006), Introduction to Computers, (6th edition). TMH.
  • Sinha, P. K. & Sinha, Priti, (2003), Foundations of Computing, (1st edition), BPB Publications.
  • Ron Mansfield, R., Olsen,J. W.(1999) Mastering Word 2000
  • Simon,J., (2000), Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables, Wiley.
  • Courter, Mastering Office 2000, BPB Publications.
  • Bill Bruck, MS-Office 2000, TMH.
  • Young,M.L., (2002).Internet Complete Reference, (2nd Edition), TMH Publishing Co. Ltd.
  • Rajaraman,V., (2010), Fundamentals of Computers, (4th edition), Prentice Hall India Pvt. Limited.
  • Content Development Group, Working with MS Office 2000, TMH.
  • Mansfield & Olsen, Mastering Word 2000, BPB Publications.

 

Suggested Reference Books:

  • Martin, Hansen, Klingher& Beth, Mastering Excel 2000, BPB Publications.
  • Murray, Mastering PowerPoint 2000, BPB Publications.
  • Mahapatra& Sinha, Essentials of Information Technology, Dhanpat Rai Publishing.
  • Leon, Alex &Leon, Mathews, (1999), Introduction to Computers, Vikas Publishing House.

 

E-Resources:

 

References: 

Reference Journals:

Examination Scheme

Continuous Assessment

Distribution of Marks (Practical Record)

Semester End Exam

Component

Marks

Component

Marks

Component

Marks

Practical Record

20

Microsoft Word

05

Submission

20

Excel Sheet

20

Test

05

Microsoft Excel

10

Power point

Presentation

15

Attendance

05

Microsoft Powerpoint

05

Word Document

10

Viva Voce

05

Total

30

Total

20

Total

70

 

Academic Year: