AIEM-P : One of the Best Private Polytechnic College in West Bengal

Introduction to IT System Laboratory

Browser features, browsing, using various search engines, writing search queries .
Visit various e-governance/Digital India portals, understand their features, services offered
COMPUTER FUNDAMENDALS- Computer and operating system-fundamentals of computer-components of computer system-Input and Output Devices-Memory handling-Storage devices
Read Wikipedia pages on computer hardware components, look at those components in lab, identify them, recognize various ports/interfaces and related cables, etc.
Install Linux and Windows operating system on identified lab machines, explore various options, do it multiple times
Connect various peripherals (printer, scanner, etc.) to computer, explore various features of peripheral and their device driver software.
Practice HTML commands with CSS try them with various values, make your basic own Webpage
MS Excel
- Apply Custom Formats and Layouts
  A Learner is able to apply skills in Advanced Excel, is able to –
  - Format Cells
  - Apply Custom Values and predefined Formats
  - Apply Borders
  - Design Borders
  - Custom Formatting
- Create advanced formulas
  A Learner is able to Use Simple and Advanced Formulas like –
  - Nested if
  - Reference formulas like –
    lookup, vlookup, hlookup,
    count formula with conditions
  - Index, Match
  - Conditional Loops, etc
- Use Scenarios
  A Learner is able to seek use Goal Seek function, alter scenarios and values in a cell to reach a goal.
- Create Advanced Charts
  A Learner can tell where to use what type of charts, and obtain graphical Charts in various scenarios 3DGraphs, Bar Charts, Pie Chart, Histograms, Line Graph, Sparklines, trend, etc.
- Pivot tables & charts
  A Learner is able to Apply
  - Pivot Tables
  - Design Pivot Table
  - Customize Values
- Manage and Share Workbooks
  A Learner is able to Share Workbook Online, email, save on cloud, edit it Online in Google Sheets, Add Collaborators etc.
MS PowerPoint
- Create a Power Point presentation using slide template.
- Create a Power Point presentation using animation.
- Create a Power Point presentation using transition
- Create a Power Point Presentation with Adding movie and sound.
- Create a Power Point Presentation with Adding tables and chart etc.
- Changing slide colour scheme in presentation.
- Viewing the presentation using slide navigator.
- Create, Save, Run and Print the Power Point Presentation.
Google Utilities
- Create and share files/folders in Google drive
- Create and share Google docs.
- Create and share Google sheets.
- Create and share Google Forms.
- Create and share Google slides.

back

ESTD-2015
EIET
AIEM-P

Computer Science and Technology Engineering

Introduction to IT System Laboratory

Contact Us

Location:

Fax:

Email:

Call: