Computers Applications (Practical)

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

This course will enable the students to -

  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

Paper Code

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

 

Unit I: 
CONTENT

I: 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

        II: 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.

        III: 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.

        IV: 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

        V: Microsoft Powerpoint                                                            24 hrs

  • 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: 
  • Abhay Upadhyay, Elementary of Computers.
  • 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.
  • 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.

 

Academic Year: 
2021-22
  • Printer-friendly version
  • PDF version