R24ES04 IT IT Workshop Lab 0 0 2 1
(Common to All Branches)
Course Objectives:
1. To assemble and disassemble a computer.
2. To solve hardware and software problems.
3. To learn about Networking of computers and use Internet facility for Browsing and Searching.
4. To develop project documentation using MS word
5. To work with various productivity tools including Excel, PowerPoint.
6. To work with different online repositories such as GITHUB, AI CHATBOT.
SYLLABUS
1.PC Hardware & Software Installation
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 on the personal computer. Lab Instructor should verify the installation and follow it up with a Viva.
Task 4: Every student should install Linux on the computer. Lab instructor should verify the installation and follow it up with a Viva.
2.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. Also, plug-ins like Macromedia Flash and JRE for applets should be configured.
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. COs-CO2
3.MS WORD
Task 1: 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 2: 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.
4.EXCEL
Excel Orientation: The mentor needs to tell the importance of MS office or 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 1: Creating a Scheduler - Features to be covered: Gridlines, Format Cells, Summation, and 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
Task 1: Students will be working on basic power point utilities and tools which help them create basic power point 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.COs-CO3
6.AI TOOLS – Chat GPT
Task 1: Prompt Engineering: Experiment with different types of prompts to see how the model Responds. Try asking questions, starting conversations, or even providing incomplete sentences to See how the model completes them. Ex: Prompt: "You are a knowledgeable AI. Please answer the following question: What is the capital of France?"
Task 2: Creative Writing: Use the model as a writing assistant. Provide the beginning of a story or a description of a scene, and let the model generate the rest of the content. This can be a fun way to Brainstorm creative ideas Ex: Prompt: "In a world where gravity suddenly stopped working, people started floating upwards. Write a story about how society adapted to this new reality."
7.Explore – GITHUB 6
Task 1: Students should understand GITHUB and should possess accounts in it.
Task 2: Students should explore different repositories available in GITHUB and student should Create his/ her own simple repositories.
Task 3: Students should take simple experiments /presentations and upload them in their GITHUB Account.
Task 4: Students should understand how GITHUB Enterprise Cloud is used and also explore the GIT and GIT HUB resources. COs-CO3
Reference Books:
1. Comdex Information Technology course tool kit, Vikas Gupta, WILEY Dream tech, 2003
2. The Complete Computer upgrade and repair book, Cheryl A Schmidt, WILEY Dream tech, 2013, 3rd edition
AIETTA | AR24|CSE|R24ES04| IT Workshop Lab
Avanthi Institute of Engineering and Technology (Autonomous) 1st BoS-CSE Page 3
3. Introduction to Information Technology, ITL Education Solutions limited, Pearson Education, 2012, 2nd edition
4. PC Hardware - A Handbook, Kate J. Chase, PHI (Microsoft)
5. IT Essentials PC Hardware and Software Companion Guide, David Anfins on and Ken Quamme. – CISCO Press, Pearson Education, 3rd edition
6. IT Essentials PC Hardware and Software Labs and Study Guide, Patrick Regan–CISCOPress, Pearson Education, 3rd edition
7. "Microsoft Word 2021: A Beginner’s Guide"by Steve Lambert.
8. "Excel 2021: A Comprehensive Guide"by Chris Benham.
9. "Microsoft PowerPoint 2021: A Beginner’s Guide" by Steve Lambert
10. GITHUB Quick Start Tutorials
WEB REFERENCES:
1. https://en.wikipedia.org/wiki/Main_Page
2. https://edu.gcfglobal.org/en/office2007
3. https://www.w3schools.com
Sample Short and Long Answers questions of Various Cognitive Levels
L1: Remember
1. Identify Peripherals of a computer
2. Draw a Block Diagram of the CPU and explain the components along with the functions.
3. Explain the various steps in assembling and dissembling of the CPU.
4. Write the basic utilities used while creating a PowerPoint presentation.
L2: Understand
1. How to install windows operating system.
2. What are search engines and brief the advantages of search engines.
3. Explain the process of creating a project abstract.
4. Explain how to explore GITHUB resources
L3: Apply
1. Explain the process orientation and connectivity boot camp
2. Write the different formulae used while calculating GPA
3. Explain the insertion of various templates while creating power point presentations.
4. Discuss the format for customization your browser for effective searching and online etiquette
L4: Analysing
1. Analyze a structured approach to experiment with prompts.
2. Explore different repositories available in GITHUB.
3. "Imagine a world where every person is born with a unique, magical ability that reflects their deepest desire or fear. Describe a day in the life of a character who discovers that their ability is far more powerful and dangerous than they ever imagined. How does this revelation affect their relationships, their view of themselves, and their place in society?"
AIETTA | AR24|CSE|R24ES04| IT Workshop Lab
Comments