IT WORKSHOP

Timings: We: 14:00-17:00


Tentative Course Schedule and Syllabus may be consulted to understand the contents of the course and the tentative plan for covering them.


Evaluation Policy

There will be assignments given out - two in Linux commands, two for Latex, one for Beamer, two for Excel, one for drawing. Out of these the top 4 will be taken for 40 marks. There will be one minor for 20 marks. The major will be for 40 marks.


ASSIGNMENTS


Introduction to Linux

We learn to use Linux command line for navigating and show how it is useful and fast as compared to GUI. Below are some links which are quite good to get to know Linux for beginners.


Introduction to Latex

Latex, written by Leslie Lamport is a typesetting tool rather than a text processor. It is built on top of Tex written by Donald Knuth.

More Tables and Equations with Latex

Here is the Second Example with Tables and Equations pdf file that is to help you exercise and improve your Latex skills.


Introduction to Beamer

Beamer is a presentation Latex document class that allows one to develop presentations like Microsoft Powerpoint. There are many themes that are already built into Beamer that give different look and feel. They also have interesting features such as being able to go directly to one section/slide of your presentation by having links at the top of the slide in some themes.

You can use different Color Themes by using the command \usecolortheme{albatross} or \usecolortheme{crane} etc. You can also specify with colors as an option to the color theme as follows: \usecolortheme[RGB={128,64,128}]{structure}

Here is an Example References frame for Beamer


Introduction to MS-EXCEL

This is the data set we will use for Excel related labs. For the purpose of the following assignments, assume the following:

The internal marks are to be computed as follows: Internal = bestOf(minor1, minor2)+AverageOf(assign1, assign2, assign3)+Seminar. Total = Internal+Major. Grades are given as follows:

Understanding how to use Complex Equations

We will understand how to use complex equations to compute required results from raw data. For this purpose, we shall compute the internal marks out of the related marks of the given data set, then, the total and the grades for each person. The grade is computed as per the table given above.

Help for Nested If Functions

Understanding how to use VLOOKUP function

Instead of using a complex equation to compute the grade, we will use VLOOKUP for grade computation.

VLOOKUP function help

Excel Vlookup Function and VLookup Example

Using Excel VLookup

Understanding how to use charts in Excel

Draw a bar chart of how many students are in each grade. Then, plot a curve out of it.

Help for Charts in Excel

Charts in LibreOffice

Understanding how to use Filters in Excel

Display data of only those students who match a certain grade - such as all B grade students etc. This can be done by using filters.

Help for Filters in Excel

Applying Filters in LibreOffice

Applying Advanced Filters

Understanding how to use Pivot Tables

We will understand how to use pivot tables in this section. In the first link below, there is an Example data set which we will use to do the exercises specified there. Then, we will generate the grade distribution from our own data set using pivot tables. In the earlier class, we had used the frequency function and set up the data in a way that can be used for generating bar and pie charts. We will do the same with pivot tables and see that it is more easy with pivot tables.

Pivot Tables data file and exercises

Help for Pivot tables

Pivot tables in LibreOffice

Using Pivot Tables to count values


Introduction to OODRAW/Xfig

In this part of the lab course, we will learn how to draw pictures, export them to .eps or other formats and include them in .doc/.ppt/.tex files.

The complete OODRAW guide

LibreOffice draw fundamentals

Xfig User Manual

Download and use the free shapes in the link below and re-create the Example Figure using OpenOffice.

Free Shapes for OpenOffice Draw

Draw the following figures in either Xfig or OODRAW:


Introduction to HTML and CSS

You need to create your own personal home page on the DCIS web server. For this, you need to create a directory "public_html" and under this create a file called "index.html" that contains the basic information. You can also use Cascading Style Sheets (CSS) to create more complex pages easily.