Computer Applications and Graphics

GTU Study
KHUDKIBOOK
COMPUTER APPLICATIONS AND DI04052091
FREE PDF DI04052091
Code: DI04052091 Credits: 3 Semester 4 CT

Computer Applications and Graphics

Get the full GTU study material, English & Gujarati textbook PDFs, syllabus curriculum, and solved previous year question papers.

Computer Applications and Graphics Syllabus — Unit-wise Content

The official GTU curriculum for Computer Applications and Graphics (subject code DI04052091) as prescribed for CT · Semester 4 divides the course into 3 units, covering 57 listed topics. The unit-wise breakdown below is read from the GTU syllabus document for this subject code, so you can check what the course actually covers before deciding which papers to attempt.

Download the official syllabus PDF (DI04052091)

Unit 1 Basics of Computer Systems and Internet

5 lecture hours

  •  Introduction to a Computer
  • Generations of Computer
  • Operating system concepts
  • purpose and functions Operations of OS  Window Basic: Creating folder
  • Searching files/Folders
  • Overview of Control Panel and Taskbar
  • Installation of MS-office/any application software  Introduction to internet
  • Basic Internet Terminologies: Browser
  • Website, URL, WWW, Introduction to Email  Gmail: Create an account
  • Adding Contacts
  • Composing an Email
  • Creating and Managing Labels
  • Filters and Signature
  •  Google Drive: Create a folder
  • Upload and Download Files/folders
  • Sharing Files/Folders
  • Forms: Create a Form
  • Validate a Form
  • Share a Form
  • Managing Response Program Name: Diploma Engineering Level: Diploma Branch: Ceramic Technology Subject Code : DI04052091 Subject Name : Computer Applications and Graphics

Unit 2 MS Word – Document Processing

5 lecture hours

  •  Functions and features of Word processor
  • Text Basics: Typing the text
  • Alignment of text
  • Editing Text: Cut, Copy
  • Select All, Clear
  • Find & Replace  Text Formatting and saving file: New, Open
  • Save As, Formatting Text: Font Size
  • Font Style
  • Font Color
  • Use the Bold
  • Italic, and Underline
  • Change the Text Case
  • Line spacing
  • Paragraph spacing
  • Shading text and paragraph
  • Working with Tabs and Indents  Table and its options
  • Inserting rows or columns
  • merging and splitting cells
  • Arithmetic Calculations in a Table.  Working with pictures
  • Inserting Pictures from Files.  Mail Merge  Printing Documents

Unit 3 MS Excel – Data Analysis and Charts

5 lecture hours

  •  Introduction to Excel interface
  • understanding rows and columns
  • Naming Cells
  • working with excel workbook and sheets  Perform Calculations with Functions: Creating Simple Formulas
  • Setting up your own formula
  • Date and Time Functions - date
  • today, now, date, if, Logical Functions -and, or, not, if, Lookup and Reference Functions- Vlookup
  • Mathematical Functions - sum, sum if, rand
  • Statistical Functions - min, max, average
  • count if, count
  • Text Functions - text
  • exact.  Sort and Filter Data with Excel: Sort and filtering data
  • using number filter
  • Text filter
  • Custom filtering
  • Removing filters from columns
  • Conditional formatting  Create Effective pie and bar Charts to Present Data Visually  Page Setup and Printing Worksheets Program Name: Diploma Engineering Level: Diploma Branch: Ceramic Technology Subject Code : DI04052091 Subject Name : Computer Applications and Graphics

Study on Android App:

Download Khudkibook on Google Play Store

More Subjects in Semester 4

GTU Study
KHUDKIBOOK
ENTREPRENEURSHIP DEVELOPMENT 3340001
FREE PDF 3340001

Entrepreneurship Development

Code: 3340001 Credit: 3
Open →
GTU Study
KHUDKIBOOK
DRYING AND FIRING 3345201
FREE PDF 3345201

Drying And Firing

Code: 3345201 Credit: 3
Open →
GTU Study
KHUDKIBOOK
GLASS-II 3345202
FREE PDF 3345202

GLASS-II

Code: 3345202 Credit: 5
Open →
GTU Study
KHUDKIBOOK
VITREOUS ENAMEL 3345203
FREE PDF 3345203

Vitreous Enamel

Code: 3345203 Credit: 5
Open →
GTU Study
KHUDKIBOOK
WHITE WARE 3345204
FREE PDF 3345204

White Ware

Code: 3345204 Credit: 7
Open →
GTU Study
KHUDKIBOOK
REFRACTORY 3345205
FREE PDF 3345205

Refractory

Code: 3345205 Credit: 7
Open →
GTU Study
KHUDKIBOOK
ESSENCE OF INDIAN 4340001
FREE PDF 4340001

Essence of Indian Knowledge and Tradition

Code: 4340001 Credit: 2
Open →
GTU Study
KHUDKIBOOK
CONTRIBUTOR PERSONALITY DEVELOPMENT 4340002
FREE PDF 4340002

Contributor Personality Development

Code: 4340002 Credit: 2
Open →
GTU Study
KHUDKIBOOK
INTEGRATED PERSONALITY DEVELOPMENT 4340003
FREE PDF 4340003

Integrated Personality Development Course

Code: 4340003 Credit: 2
Open →
GTU Study
KHUDKIBOOK
DRYING AND FIRING 4345201
FREE PDF 4345201

Drying and Firing

Code: 4345201 Credit: 3
Open →
GTU Study
KHUDKIBOOK
GLASS-2 4345202
FREE PDF 4345202

Glass-2

Code: 4345202 Credit: 4
Open →
GTU Study
KHUDKIBOOK
INDUSTRIAL MANAGEMENT 4345203
FREE PDF 4345203

Industrial Management

Code: 4345203 Credit: 3
Open →
GTU Study
KHUDKIBOOK
WHITE WARE 4345204
FREE PDF 4345204

White Ware

Code: 4345204 Credit: 5
Open →
GTU Study
KHUDKIBOOK
REFRACTORY 4345205
FREE PDF 4345205

Refractory

Code: 4345205 Credit: 5
Open →
GTU Study
KHUDKIBOOK
ENTREPRENEURSHIP & START-UP DI04000081
FREE PDF DI04000081

Entrepreneurship & Start-up

Code: DI04000081 Credit: 3
Open →
GTU Study
KHUDKIBOOK
HUMAN RESOURCES MANAGEMENT DI04000141
FREE PDF DI04000141

Human Resources Management

Code: DI04000141 Credit: 3
Open →
GTU Study
KHUDKIBOOK
GLASS-2 DI04052011
FREE PDF DI04052011

Glass-2

Code: DI04052011 Credit: 4
Open →
GTU Study
KHUDKIBOOK
CERAMIC ART AND DI04052021
FREE PDF DI04052021

Ceramic Art and Design

Code: DI04052021 Credit: 4
Open →
GTU Study
KHUDKIBOOK
QUALITY CONTROL DI04052031
FREE PDF DI04052031

Quality Control

Code: DI04052031 Credit: 4
Open →
GTU Study
KHUDKIBOOK
DRYING AND FIRING DI04052041
FREE PDF DI04052041

Drying and Firing

Code: DI04052041 Credit: 3
Open →
GTU Study
KHUDKIBOOK
ADVANCE WHITE WARE DI04052051
FREE PDF DI04052051

Advance White Ware

Code: DI04052051 Credit: 4
Open →
GTU Study
KHUDKIBOOK
STRUCTURAL CLAY PRODUCTS DI04052061
FREE PDF DI04052061

Structural Clay Products

Code: DI04052061 Credit: 4
Open →
GTU Study
KHUDKIBOOK
ADVANCE REFRACTORY DI04052071
FREE PDF DI04052071

Advance Refractory

Code: DI04052071 Credit: 4
Open →
GTU Study
KHUDKIBOOK
REFRACTORIES FOR IRON DI04052081
FREE PDF DI04052081

Refractories for Iron and Steel Plants

Code: DI04052081 Credit: 4
Open →