This course will provide student a much-needed knowledge of computer hardware and networking, enabling them to identify and rectify the onboard computer hardware, software and network related problems. With the help of this course the student will be able to understand the hardware specifications and installation of System Software MS-Windows, Linux and the required device drivers. In addition, hardware and software level troubleshooting process, tips and tricks would be covered. Usage of web browsers, e-mails, news groups and discussion forums would be covered. In addition, awareness of Ms Office- Word, Excel and PowerPoint and other Cloud based productivity enhancement and collaboration tools would be introduced.
To get familiar with hardware components of a computer, I/O Devices, ports etc.
To understand basic command of Linux.
Learn how to use Internet for productivity and self-paced lifelong learning.
Understand the concepts of Compression, Multimedia and Antivirus tools.
Study Office Tools such as Word processors, Spreadsheets and PowerPoint etc.
Identification of peripherals of a PC, Laptop, Server and Smart Phones: Prepare a report containing the block diagram along with the configuration of each component and its functionality, Input/ Output devices, cache memory and secondary storage technologies, digital storage basics, networking components and speeds.
Introduction to operating system. Installation of Windows and Linux operating systems. Windows: -Evolution of operating system. Introduction to software. Types of software (MS office, VLC media player, Win rar), open office, web browser, etc.) .
This task covers basic commands and system administration in Linux, including basic Linux commands in bash, ping, ssh, ifconfig, scp, netstat, ipstat, nslookup, traceroute, telnet, host, ftp, arp, wget,route.
Every student should individually set up and configuring a new Virtual Machine and Exporting and packaging an existing Virtual Machine into a portable format.
Internet: Introduction and evolution of internet. Study of various internet-based services like email, social network, chat, etc. Introduction to cyber security and cyber laws.
Internet Services: Web Browser usage and advanced settings like LAN, proxy, content, privacy, security, cookies, extensions/ plugins.
Server: Introduction to server. Difference between server and normal desktop. Evolution of servers. Study of various servers like email, data, domain, etc.
MS Word: Importance of MS office - -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 Word.
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.
MS PowerPoint: Basic power point utilities and tools which help ful to create basic power point presentation. Topic covered during this includes PPT Orientation, Slide Layouts, Inserting Text, Word Art, Formatting Text, Bullets and Numbering, Auto Shapes, Lines and Arrows.
Introduction to HTML & Basic syntax of html Attributes, elements, lists, and basic programs.
Excel Orientation: The importance of MS office 2007/10 tool Excel as a Spreadsheet tool, 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.
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, Sorting, Conditional formatting.
Store, sync, and share files with ease in the cloud using Google Drive Document creation and editing text documents in your web browser using Google docs Handle task lists, create project plans, analyze data with charts and filters using Google Sheets Create pitch decks, project presentations, training modules using Google Slides.
Manage event registrations, create quizzes, analyze responses using Google Forms o Build public sites, internal project hubs using Google Sites .
Online collaboration through cross-platform support using Jam board.
Keep track of important events, sharing one's schedule, and create multiple calendars using Google Calendar.
COURSE INSTRUCTOR: Amanapu Yaswanth
SCHEDULE: Thursday , 8.00 a.m. – 10.00 a.m.