VNR VIGNANA JYOTHI INSTITUTE OF ENGINEERING AND TECHNOLOGY
B.Tech. I Semester - IT
(25PE2CP102) IT WORKSHOP LABORATORY
TEACHING EVALUATION SCHEME
SCHEME
L T/P C D-D PE LR CP SE TOTA
E L
0 2 1 10 10 10 10 60 100
COURSE PRE-REQUISITES:
Basic Computer Knowledge, Familiarity with Operating Systems, Typing & File Handling
Skills, Basic Internet Skills, Fundamental Knowledge of Office Tools, Logical Thinking &
Problem-Solving Ability, Willingness to Learn New Tools, and Openness to explore both
proprietary (MS Office) and open-source (Linux, LaTeX) platforms.
COURSE OBJECTIVES:
To provide fundamental knowledge of computer hardware components and
develop hands-on skills in assembling, disassembling, and configuring personal
computers.
To train students in installing and managing multiple operating systems (Windows
and Linux) and configuring systems for dual boot.
To impart practical knowledge of networking concepts, including LAN connectivity,
TCP/IP configuration, and safe internet practices (cyber hygiene).
To develop skills in creating professional documents using LaTeX and MS Word
with advanced formatting, tables, images, and editing tools.
To enhance analytical, visualization, and presentation skills using MS Excel for
data analysis and MS PowerPoint for effective communication.
COURSE OUTCOMES: Upon completion of the course, the student will be able to:
CO1: Explain the components of a computer system, identify CPU peripherals, and
describe their functions through block diagrams.
CO2: Assemble and disassemble a personal computer and configure operating systems
(Windows/Linux) including dual boot installation.
CO3: Configure TCP/IP settings, troubleshoot internet connectivity, and apply browser
customizations with appropriate cyber hygiene measures.
CO4: Assess and compare document creation using LaTeX and MS Word by applying
formatting, styles, tables, and mail merge features to meet professional documentation
standards.
CO5: Design and develop analytical reports using MS Excel (formulas, charts, conditional
formatting) and professional presentations in PowerPoint with integrated multimedia and
master layouts.
COURSE ARTICULATION MATRIX:
(Define Correlation of Course Outcomes with Program Outcomes and Program Specific Outcomes
using mapping levels 1 = Slight, 2 = Moderate and 3 = Substantial)
PROGRAM
PROGRAM OUTCOMES (PO) SPECIFIC
CO OUTCOMES (PSO)
PO-1 PO-2 PO-3 PO-4 PO-5 PO-6 PO-7 PO-8 PO-9 PO-10 PO-11 PSO-1 PSO-2 PSO-3
CO-1
CO-2
CO-3
CO-4
CO-5
LIST OF PROGRAMS / EXPERIMENTS / EXERCISES:
PC Hardware
Task 1: Identify the peripherals of a computer, components in a CPU and its functions.
Draw the block diagram of the CPU along with the configuration of each peripheral and
submit it to your instructor.
Task 2: Every student should disassemble and assemble the PC back to working
condition. Lab instructors should verify the work and follow it up with a Viva. Also,
students need to go through the video which shows the process of assembling a PC. A
video would be given as part of the course content.
Task 3: Every student should individually install MS windows Operating system into
Virtual machine. Lab instructor should verify the installation and follow it up with a Viva.
Task 4: Every student should install Linux into Virtual Machine. Lab instructors should
verify the installation and follow it up with a Viva
Internet & World Wide Web
Task1: Orientation & Connectivity Boot Camp: Students should get connected to their
Local Area Network and access the Internet. In the process they configure the TCP/IP
setting. Finally, students should demonstrate, to the instructor, how to access the
websites and email. If there is no internet connectivity preparations need to be made by
the instructors to simulate the WWW on the LAN.
Task 2: Web Browsers, Surfing the Web: Students customize their web browsers with the
LAN proxy settings, bookmarks, search toolbars and pop-up blockers.
Task 3: 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. This should be demonstrated to the instructors by the
student.
Task 4: Cyber Hygiene: Students would be exposed to the various threats on the
internet and would be asked to configure their computer to be safe on the internet. They
need to customize their browsers to block pop ups, block active x downloads to avoid
viruses and/or worms.
LaTeX and WORD
Task 1 : Word Orientation: overview and Importance of LaTeX and Microsoft (MS) office,
Using LaTeX and word – Accessing, overview of toolbars, saving files, Using help and
resources, rulers, format painter in word.
Task 2: Using LaTeX and Word to create a 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 3: 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.
Task 4: Creating a Newsletter: Features to be covered: - Table of Content, Newspaper
columns, Images from files and clipart, Drawing toolbar and Word Art, Formatting
Images, Textboxes, Paragraphs and Mail Merge in word.
Excel Orientation
Using Excel – Accessing, overview of toolbars, saving excel files, Using help and
resources.
Task 1: Creating a Scheduler - Features to be covered: Gridlines, Format Cells,
Summation, auto fill, Formatting Text
Task 2: Calculating GPA - Features to be covered: - Cell Referencing, Formulae in excel –
average, std. deviation, Charts, Renaming and Inserting worksheets, Hyper linking, Count
function, LOOKUP/VLOOKUP
Task 3: Split cells, freeze panes, group and outline, Sorting, Boolean and logical
operators, Conditional formatting
PowerPoint
Task 1: Students will be working on basic power point utilities and tools which help them
create basic PowerPoint presentations. PPT Orientation, Slide Layouts, Inserting Text,
Word Art, Formatting Text, Bullets and Numbering, Auto Shapes, Lines and Arrows in
PowerPoint.
Task 2: Interactive presentations - Hyperlinks, Inserting –Images, Clip Art, Audio, Video,
Objects, Tables and Charts.
Task 3: Master Layouts (slide, template, and notes), Types of views (basic, presentation,
slide slotter, notes etc.), and Inserting – Background, textures, Design Templates, Hidden
slides.
Case Study:
Design and manage Conference Proceedings using MS Word, Excel, and PowerPoint.
MS Word: For drafting, formatting, and compiling research papers, abstracts, and
official documents into a structured proceedings booklet.
MS Excel: For maintaining participant details, registrations, schedules, and
generating analytical reports such as attendance and fee collection.
MS PowerPoint: For preparing and delivering keynote and technical session
presentations, ensuring effective visual communication during the conference.
TEXT BOOKS:
1. Comdex Information Technology course tool kit Vikas Gupta, WILEY Dreamtech
2. The Complete Computer upgrade and repair book, 3rd edition Cheryl A Schmidt, WILEY
Dreamtech.
3. PC Hardware - A Handbook – Kate J. Chase PHI (Microsoft)
REFERENCES:
1. Introduction to Information Technology, ITL Education Solutions limited, Pearson
Education.
2. LaTeX Companion – Leslie Lamport, PHI/Pearson.
3. IT Essentials PC Hardware and Software Companion Guide Third Edition by David
Anfinson and Ken Quamme. – CISCO Press, Pearson Education.
4. IT Essentials PC Hardware and Software Labs and Study Guide Third Edition by
Patrick Regan – CISCO Press, Pearson Education.
ONLINE RESOURCES:
1. https://www.youtube.com/watch?v=IhX0fOUYd8Q
2. https://www.overleaf.com/learn/latex/Tutorials
3. https://support.mozilla.org/en-US/products/firefox/privacy-and-security
4. https://www.cisa.gov/stay-safe-online
