Jj
Uka Tarsadia University
B.V. Patel Institute of Business
Management, Computer & Information
Technology
B.B.A.
Semester - I
030030123 – SEC1 Computer Application
EFFECTIVE FROM July-2017
Syllabus Version: 1.01
Uka Tarsadia University
Version 1.01
SEMESTER-I
030030123 – SEC1 Computer Application
Credits: 2: Theory Contact Hours Per week: 2: Theory
Objective of the Course:
To enlighten students with basic computer skills.
To learn the practical application of various tools for business operations.
To give a better understanding of Open Office application.
Student Learning Outcomes:
Students will be able to make business communication effectively
To be able to use Writer, Calc and Impress tools.
To gain knowledge of Open office applications.
Instructional Methods and Pedagogy:
Faculty members hall explain in a class room using black board (chalk and talk method) and
multimedia projector through Power Point Presentation, IT enabled audio-visual techniques,
Case Analysis, Filed Assignment, etc.
Outline of the Course:
No. of Contact Hours Approx.
Unit
Topic of Unit Weight age
No. (Th.) (Pr.)
%
1 Introduction to Open Office 4 - 16.67
2 Introduction to Writer 4 4 16.67
3 Introduction to Impress 4 4 16.67
4 Introduction to Calc 4 4 16.67
5 Working with Calc 4 4 16.67
6 Introduction to Internet 4 - 16.67
Total 24 16 100
Uka Tarsadia University
Version 1.01
BBA Subject Hours
Sem. I 030030123 – SEC1 Computer Application 2hrs/week
(Theory) 2 Credits
Sr. No. Topic Hours
Unit I
1 Introduction to Open Office 04
1.1 What is [Link]?, The advantages of
[Link]., Minimum requirements [JS: Chapter- 1;
Pages 9 - 12, 1 Hour]
1.2 Parts of the main window [JS: Chapter- 1; Pages 12 - 22, 1
Hour]
1.3 Starting a new document, Opening an existing document,
Saving a document, Renaming and deleting files [JS:
Chapter- 1; Pages 23 - 25, 0.5 Hour]
1.4 Using the Open and Save As dialogs, Using the Navigator,
Undoing and redoing changes, Closing a document,
Closing [Link] [JS: Chapter- 1; Pages 25 - 30, 1.5
Hour]
Unit II
2 Introduction to Writer 04
2.1 What is Writer?, The Writer interface, Changing document
views, Moving quickly through a document, Working with
Documents, [JS: Chapter- 4; Pages 76 - 80, 1 Hour]
2.2 Text, Formatting Text, Pages, Adding comments to a
document, Creating a table of contents [JS: Chapter- 3;
Pages 98 - 100, 1 Hour]
2.3 Working with graphics [JS: Chapter- 11; Pages 289 - 293,
1 Hour]
2.4 Managing the Gallery, Drawing Tools, Fontwork [JS:
Chapter- 11; Pages 294 - 301, 1 Hour]
Unit III
3 Introduction to Impress 04
3.1. Getting Started with Impress, What is Impress?, Starting
Impress, Parts of the main Impress window, Workspace
views [JS: Chapter- 6; Pages 144 - 148, 1 Hour]
3.2. Creating a new presentation, Formatting a presentation,
Adding and formatting text, Adding pictures, tables, charts
and media [JS: Chapter- 6; Pages 149 - 158, 1.5 Hour]
3.3. Working with slide masters and styles, Adding comments
to a presentation, Setting up the slide show, Running the
slide show [JS: Chapter- 6; Pages 171 - 173, 1.5 Hour]
Uka Tarsadia University
Version 1.01
Unit IV
4 Introduction to Calc 04
4.1. Getting Started with Calc, What is Calc?, Spreadsheets,
sheets and cells, Parts of the main Calc window [JS:
Chapter- 5; Pages 105 - 108, 1 Hour]
4.2. Opening and saving CSV files, Navigating within
spreadsheets, Selecting items in a sheet or spreadsheet [JS:
Chapter- 5; Pages 109 - 116, 1.5 Hour]
4.3. Working with columns and rows, Working with sheets,
Viewing Calc, Entering data using the keyboard, Speeding
up data entry [JS: Chapter- 5; Pages 117 - 126, 1.5 Hour]
Unit V
5 Working with Calc 04
5.1 Sharing content between sheets, Validating cell contents,
Editing data, Formatting data, Auto formatting cells and
sheets [JS: Chapter- 5; Pages 127 - 133, 2 Hour]
5.2 Formatting spreadsheets using themes, Using conditional
formatting, Hiding and showing data, Sorting records and
using functions [JS: Chapter- 5; Pages 134 - 137, 2 Hour]
Unit VI
6 Introduction to Internet 04
6.1 Introduction of Internet, Working of Internet, Owner of
Internet, Internet Connections [RP: Chapter- 22; Pages 455
– 460; 1 Hour]
6.2 Usages of Internet, Working with World Wide Web [RP:
Chapter- 22; Pages 461 – 466; 1 Hour]
6.3 Internet addresses, Terminologies [RP: Chapter- 22; Pages
466 – 469; 1 Hour]
6.4 Virus, Types of Computer Virus, Antivirus [RP: Chapter-
24; Pages 493 – 497; 1 Hour]
Uka Tarsadia University
Version 1.01
Practical
Sr. No. Topic Hours
Unit 1 Introduction to Open Office 0
Open and Save File
Page Formatting
Text Formatting
Unit 2 Page Layout Setting 4
Adding Comments, Create Table
Working with Graphics, Drawing tools
Use of Gallery
Creating Presentation
Formatting a presentation
Adding Animation
Unit 3 Adding and formatting text, 4
Working with pictures, tables, charts and media
Setting up the slide show
Opening and saving Calc and CSV files with Navigation
Unit 4 Formatting Column, Row and Sheet 4
Validating Data and Content
Formatting Data, Cell
Conditional formatting
Unit 5 Sorting of data 4
Using string functions
Using math functions
Unit 6 Introduction to Internet 0
Text Books:
James Steinberg. (2010) Open Office Basic: An Introduction.
References:
[Link], Sonal Jain. Working with Personal Computer Software. Wiley
India Pvt. Ltd.
***************
Uka Tarsadia University
Version 1.01
Course Outcomes
Upon completion of the course students shall be able to:
CO1: Get an overview of Open office applications.
CO2: Understand Writer and its application.
CO3: Understanding of designing and use of Impress.
CO4: Learn various basic working of Calc.
CO5: Learn advanced working of Calc using functions.
CO6: Learn Internet and types of Virus.
Course Objectives and Course Outcomes Mapping:
To enlighten students with basic computer skills [CO1, CO2, CO3, CO4].
To learn the practical application of various tools for business operations [CO2, CO3,
CO4, CO5].
To give a better understanding of Open Office application [CO1, CO2, CO4, CO6].
Course Units and Course Outcomes Mapping
Unit Course Outcome
Unit
No. CO1 CO2 CO3 CO4 CO5 CO6
1 Introduction to Open Office
2 Introduction to Writer
3 Introduction to Impress
4 Introduction to Calc
5 Working with Calc
6 Introduction to Internet