Computer Applications

Paper Code: 
24GBCA102A
Credits: 
4
Contact Hours: 
60.00
Max. Marks: 
100.00
Objective: 

This course will enable the students to –

1.     Understand basic skills in MS-Office suites.

2.     Use computer for basic purposes of preparing documents, personnel/business letters, excel spreadsheets and professional PowerPoint presentations. 

 

 

Course Outcomes: 

Course

Learning outcomes

(at course level)

Learning and teaching strategies

Assessment

Strategies

Course Code

Course

Title

24GBCA 102A

 

 

 

 

 

 

 

Computer Applications

 

 

 

 

 

 

 

CO37: Apply the knowledge of computer, software and data processing in solving variety of tasks.

CO38: Examine the various components of Windows and create well formatted documents using word processor tool.

CO39: Apply advanced word processing tools to create documents and spreadsheets.

CO40: Design spreadsheets, apply basic functions and charts to analyze data

CO41: Create visually appealing slides that effectively communicate information.

CO42: Contribute effectively in course-  specific interaction.

Approach in teaching:

Interactive Lectures, Discussion, Tutorials, Demonstrations, Team teaching, Teaching using advanced IT audio-video tools

 

Learning activities for the students:

Self-learning assignments, Effective questions, Simulation, Seminar presentation, Giving tasks.

Assessment Strategies

Class test, Semester end examinations, Quiz, Solving problems in tutorials, Assignments, Presentation.

 

 

12.00
Unit I: 
Introduction to Computer

Introduction to Computer: 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).

Introduction to Data Processing: Elements of Data Processing, Data Processing Activities.

Introduction to Computer Security, Introduction to Basics of Internet, Security Threat and Security Attack, Malicious Software, Hacking. Users Identifications and Authentication.

 

 

12.00
Unit II: 
Windows

Windows: Introduction to Windows, features of Windows (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.

Word processors: Introduction to word processing, Features of Word processors, working with formatted documents, Shortcut keys. Finding & replacing text, go to (5) command.

Formatting documents, selecting text, formatting characters, changing cases, Paragraph formatting, Indents, Using format painter, Page formatting, Header & footer, Bullets & numbering, Tabs.

 

12.00
Unit III: 
Advanced Word processing Tools

Advanced Word processing Tools: Forming tables, proofing text (Spell check, Auto correct), Inserting pictures, Mail merging, Printing, Getting Help.

Spreadsheets: workbooks, creating, saving & editing a workbook, renaming sheet, cell entries (numbers, labels, and formulas), spell check, find and replace; Adding and deleting rows and columns. Filling series, fill with drag, data sort, Formatting worksheet

 

12.00
Unit IV: 
Spreadsheets

Spreadsheets: Functions and its parts, Mathematical Functions (FLOOR, CEILING, ROUND, SUM, PRODUCT, QUOTIENT); Date & Time (DATE, DATEVALUE, DAY, TIME, HOUR, MINUTE, SECOND, MONTH, TODAY, YEAR, WEEKDAY, WEEKNUM, NOW), Text (EXACT, LEFT, LEN, LOWER, MID, PROPER, REPLACE, RIGHT, TRIM, UPPER, VALUE,); Statistical Functions (AVERAGE, COUNT, MAX, MIN, MEDIAN, MODE), Cell referencing (Relative, Absolute, Mixed), What-if analysis. Introduction to charts: types of charts, creation of chart from adjacent data/ nonadjacent data, printing a chart, printing worksheet.

Presentation Software: Uses, Presentation tips, components of slide, templates and wizards, using template, choosing an auto layout, using outlines, adding subheadings, editing text, formatting text, using master slide; adding slides, changing color scheme, changing background and shading.

 

12.00
Unit V: 
Presentation Software

Presentation Software: 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:

Internet Communication Protocols, Types of Internet Connections, ISPs, Domain Name System, Intranets, Email Concepts (receiving, sending, addressing, downloading, formatting, sending attachment), Configuring e-mail software.

 

Essential Readings: 
  1. Peter Norton, “Introduction to Computers”, TMH, 2001.
  2. Ed Bott, “Using Microsoft Office 2007”, Pearson Education India.
  3. John Walkenbach (Author), Herb Tyson (Author), Michael R. Groh (Author), FaitheWempen (Author), Lisa A. Bucki, “Microsoft Office 2010 Bible”, Wiley India.

 

References: 

ESSENTIAL READINGS:

  1. Peter Norton, “Introduction to Computers”, TMH, 2001.
  2. Ed Bott, “Using Microsoft Office 2007”, Pearson Education India.
  3. John Walkenbach (Author), Herb Tyson (Author), Michael R. Groh (Author), FaitheWempen (Author), Lisa A. Bucki, “Microsoft Office 2010 Bible”, Wiley India.

SUGGESTED READINGS:

1.       Mahapatra& Sinha, “Essentials of Information Technology”, Dhanpat Rai Publishing.

JOURNALS:

  1. https://journal-bcs.springeropen.com/
  2. https://jisajournal.springeropen.com/
  3. https://www.sciencedirect.com/journal/thinking-skills-and-creativity

e -RESOURCES:

  1. https://home.csulb.edu/~murdock/dosindex.html
  2. https://support.microsoft.com/en-us/office/basic-tasks-for-creating-a-po...
  3. https://www.excel-easy.com/
  4. https://support.microsoft.com/en-us/office/Analyse-data-in-excel-3223aab...

 

Academic Year: