Computer Applications and Graphics
Get the full GTU study material, English & Gujarati textbook PDFs, syllabus curriculum, and solved previous year question papers.
English Book & Chapters
English Book Coming Soon
We are working hard to add this material. Stay tuned for updates!
Follow on Instagram for UpdatesGTU Previous Year Papers
Papers Coming Soon
We are working hard to add this material. Stay tuned for updates!
Follow on Instagram for UpdatesComputer 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
- 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
- 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
- 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