JNTUK B.Tech Computer Applications Lab gives you detail information of Computer Applications Lab R13 syllabus It will be help full to understand you complete curriculum of the year.
Identification of the peripherals of a computer.
To prepare a report containing the block diagram of the CPU along with the configuration of each peripheral and its functions. Description of various I/O Devices
A practice on disassemble the components of a PC and assembling them to working condition.
Examples of Operating systems-Dos, Windows, Installation of MS windows on a PC.
Introduction to Memory and Storage Devices , I/O Port, Device Drivers, Assemblers, Compilers, Interpreters , Linkers, Loaders.
Internet & World Wide Web : Importance of Networking, Transmission Media, Networking Devices- Gateway, Routers, Hub, Bridge, NIC ,Bluetooth Technology, Wireless Technology, Modem, DSL, Dialup Connection.
Orientation & Connectivity Boot Camp and surfing the Web using Web Browsers: Students should get connected to their Local Area Network and access the Internet. In the process they should configure the TCP/IP setting and demonstrate how to access the websites and email. Students customize their web browsers using bookmarks, search toolbars and pop up blockers.
Search Engines & Netiquette: Students should know what search engines are and how to use the search engines. A few topics would be given to the students for which they need to search on Google.
MS Office
Word Orientation: Word as word Processors.
Accessing, overview of toolbars, saving files, Using help and resources, rulers, formatting ,Drop Cap , Applying Text effects, Using Character Spacing, Borders and Colors, Inserting Header and Footer, Using Date and Time option
Creating project : Abstract Features to be covered:-Formatting Styles, Inserting table, Bullets and Numbering, Changing Text Direction, Cell alignment, Footnote, Hyperlink, Symbols, Spell Check , Track Changes,
Images from files and clipart, Drawing toolbar and Word Art, Formatting Images, Textboxes and Paragraphs.
MS Excel
Excel Orientation: The mentor needs to tell the importance of MS Excel as a Spreadsheet tool, give the details of the tasks and features that would be covered in each.
Using Excel Accessing, overview of toolbars, saving excel files, Using help and resources.
Creating a Scheduler – Features to be covered: Gridlines, Format Cells, Summation, auto fill, Formatting Text.
Performance Analysis – Features to be covered: Split cells, freeze panes, group and outline, Sorting, Boolean and logical operators, Conditional formatting.
Power Point
Students will be working on basic power point utilities and tools which help them create basic power point presentation. Topic covered during this week includes :- PPT Orientation, Slide Layouts, Inserting Text, Word Art, Formatting Text, Bullets and Numbering, Auto Shapes, Lines and Arrows, Hyperlinks, Inserting –Images, Clip Art, Tables and Charts in PowerPoint.
Concentrating on the in and out of Microsoft power point. Helps them learn best practices in designing and preparing power point presentation. Topic covered during this week includes: – Master Layouts (slide, template, and notes), Types of views (basic, presentation, slide slotter, notes etc), and Inserting – Background, textures, Design Templates, Hidden slides.
MS Access: Students have to work on creating data bases, tables, storing and organizing data in the data base, querying, Creating Forms and Reports (take appropriate examples.)
TEXT BOOK
- Computer Fundamentals, Anita Goel, Pearson.
- Information Technology Workshop,3e, G Praveen Babu, M V Narayana BS Publications.
- Introduction to Information Technology, ITL Education Solutions Ltd., 2nd & 3rd Eds., PEARSON
- Comdex Information Technology, Vikas Gupta, dreamtech.
REFERENCE BOOK
- Williams, Using Information Technology: Practical Introduction, TMH.
- Essential Computer and IT Fundamentals for Engineering and Science Students, Dr. N.B. Venkateswarlu.
For more information about all JNTU updates please stay connected to us on FB and don’t hesitate to ask any questions in the comment.