JNTU-KAKINADA : Syllabus for IT Workshop

Objectives:

The IT Workshop for engineers is a 6 training lab course spread over 45 hours.

The modules include training on PC Hardware, Internet & World Wide Web and Productivity tools including (word processor, spread sheet, presentation sw) Word, spread sheet Excel, Power Point and Publisher.

PC Hardware Identification of basic peripherals, assembling a PC, installation of system software like MS Windows, Linux and the device drivers. Troubleshooting Hardware and software _ some tips and tricks .

Internet & World Wide Web: Different ways of hooking the PC on to the internet from home and workplace and effectively usage of the internet, web browsers, email, newsgroups and discussion forums .Awareness of cyber hygiene( protecting the personal computer from getting infected with the viruses), worms and other cyber attacks .

Productivity tools Crafting professional word documents; excel spread sheets, power point presentations and personal web sites using the Microsoft suite of office tools and LaTeX.

(Note: Student should be thoroughly exposed to minimum of 12 Tasks)

PC Hardware

Task 1: 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.

Task 2(Optional) : A practice on disassemble the components of a PC and assembling them to working condition.

Task 3 : Installation of MS windows and LINUX on a PC.

Task 4 : Exposure to Basic commands and system administration in Linux including: Basic Linux commands in bash, Create hard and symbolic links.

Task 5 :

Hardware Troubleshooting (Demonstration):

Students have to be given a PC which does not boot due to improper assembly or defective peripherals. Identification of a problem and fixing it for getting to working condition.

Software Troubleshooting (Demonstration): Students have to be given a malfunctioning CPU due to system software problems. Identification of a problem and fixing it for getting to working condition.

Internet & World Wide Web

Task 6 : 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.

Task 7: 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.

Task 8 : Cyber Hygiene (Demonstration) : Awareness of various threats on the internet. To install an anti virus software and to configure their personal firewall and windows update on their computers.

LaTeX and Word

Word Orientation : Importance of LaTeX and MS/ equivalent (FOSS) tool Word as word Processors.

Details of the four tasks and features that would be covered in each, Using LaTeX and word Accessing, overview of toolbars, saving files, Using help and resources, rulers, format painter in word.

Task 9 : Using LaTeX and word to create project certificate. Features to be covered:-Formatting Fonts in word, Drop Cap in word, Applying Text effects, Using Character Spacing, Borders and Colors, Inserting Header and Footer, Using Date and Time option in both LaTeX and Word.

Task 10: 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.

Excel

Excel Orientation : The mentor needs to tell the importance of MS/ equivalent (FOSS) tool Excel as a Spreadsheet tool, give the details of the four tasks and features that would be covered in each. Using Excel

Accessing, overview of toolbars, saving excel files, Using help and resources

Task 11 : Creating a Scheduler – Features to be covered:- Gridlines, Format Cells, Summation, auto fill, Formatting Text

LOOKUP/VLOOKUP

Task 12 : Performance Analysis – Features to be covered:- Split cells, freeze panes, group and outline, Sorting, Boolean and logical operators, Conditional formatting

LaTeX and MS/equivalent (FOSS) tool Power Point

Task 13 : 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 both LaTeX and Powerpoint.

Task 14 : Concentrating on the in and out of Microsoft power point and presentations in LaTeX. 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), Inserting Background, textures, Design Templates, Hidden slides.

REFERENCES :

1 Scott Muellers Upgrading and Repairing PCs, 18/e, Scott. Mueller, QUE, Pearson,2008

2 The Complete Computer upgrade and repair book,3/e,Cheryl A Schmidt, Dreamtech

Click on the link below to download:

JNTU-KKD : Syllabus for IT Workshop.

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.