COMPUTERS APPLICATIONS (PRACTICAL)

Paper Code: 
FSD-124
Credits: 
06
Contact Hours: 
90.00
Max. Marks: 
100.00
Objective: 
  • To expose students to basic microeconomic concepts.
  • To provide a method/ approach to help draw correct conclusions/ solve economic problems.
  • 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

Paper Code

Paper Title

FSD 124

 

Computers Applications (Practical)

 

 

The students will be able to –

CO 16 Demonstrate basic understanding of computer

CO 17 Work effectively with various programs such as Microsoft word, Microsoft excel and Microsoft power point for preparing report/ seminar/project

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

Approach in teaching : Interactive Lectures, Group Discussions, Power point presentations, Video Tutorials

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

Assessment task will include Class test, Semester end examinations, student’s presentations and assignments.

 

Unit I: 
Course Content:

Introduction to Computers                                                       6 hrs

  • 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

Windows                                                                                    6 hrs

  • Introduction & features (desktop & its components, the window, the application window (various bars), the document window, the dialog window, the icons).
  • Windows explorer; Control panel, Setting wallpaper, screen saver, background. Creating a folder, Compressing/ Zipping files (WinZip), Virus & Antivirus.                                                        

Microsoft Word                                                                        20 hrs

  • 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.

Microsoft Excel                                                                        24 hrs

  • 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

Microsoft Power Point                                                              24 hrs

  • Introduction, uses & features of Microsoft Power Point, 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.          

Internet:                                                                                  10hrs

  • Internet Communication Protocols, Types of Internet Connections, ISPs, Domain Name System, Intranets, Email Concepts (receiving, sending, addressing, downloading, formatting, sending attachment).
  • Sending & Receiving Secure E-mail, chatting, conferencing, E-mail mailing list, Newsgroup, IRC, ICQ, Video mail and Video Conferencing.
Essential Readings: 
  1. AbhayUpadhyay, Elementary of Computers.
  2. Peter Norton, “Introduction to Computers”, TMH, 2001
  3. Mastering Word 2000 – Mansfield and Olsen
  4. Mastering Excel 2000 – Martin, Hansen, Klingher & Beth
  5. Courter, “Mastering Office 2000”, BPB Publications.
  6. Bill Bruck, “MS-Office 2000”, TMH.
References: 
  1. Robbins, “Mastering DOS”, BPB Publications
  2. Content Development Group, “Working with MS Office 2000”, TMH
  3. Mansfield & Olsen, “Mastering Word 2000”, BPB Publications
  4. Martin, Hansen, Klingher & Beth, “Mastering Excel 2000”, BPB Publications
  5. Murray, “Mastering Power Point 2000”, BPB Publications.
  6. Mahapatra & Sinha, “Essentials of Information Technology”, Dhanpat Rai Publishing
Academic Year: 
2019-20
  • Printer-friendly version
  • PDF version