IT WORKSHOP

Timings: We: 10:00AM-1:00PM

TA: TBD

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

Assignment-1
Assignment-2: In this assignment, you are expected to reproduce the document given here by writing the Latex source code yourself that will achieve this. You can copy and paste the text instead of typing it into the latex source code. Here is the Ritchie-Thomson image and topo and Color topo to be used for the assignment.

Assignment-3: is based on the command "sed". We will use the text file unix.txt to understand sed a little before we proceed to the assignments.
- Using sed on the sed input file, make sure that the file contains only the string OpenFlow and not any of the combinations "openflow, Openflow, openFlow, open flow, Open Flow, Open flow" etc. Change TCP to tcp, IP (a complete word by itself) to ip and "ip" to IP irrespective of whether it appears in the middle of a word or is a complete word, change "IP" in the middle of the word to "ip" and not if it is a complete word.
- From the name of the file greedy-mds-100-150.out, extract only the number 150 and only the numbers separated by "-".
- In the text of the file Tale of Two cities, change all "it" that are at the start of the line to "IT", then change them back to "it". Similarly, change all "we" to "We".

Assignment-4: The excel sheets we used for various queries can be exported into .csv files and remove the header lines (if possible by using sed). After that, do the following:
For the students' grades sheet:
1. find the average for internal, major.
2. count the number of students in each grade.
For the other excel sheet:
1. extract only the precinct, party and status into another file using awk.
2. find the number of people in each precicnt
3. find the number of people belonging to each party in precinct 2416.
4. find the number of people having PERM status overall and in each precinct.

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.

Latex Introduction .tex file, the images topo and topo2 and Font Colors style package needed for the compilation of the document and the corresponding PDF file. You may also pick up the Latex Introduction Bibliography file as well as the LNCS Bibliography Style file.
Introducing Latex
Getting Started with Latex
A Latex Primer
Typesetting Tables with Latex
Latex WikiBook

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:

Less than 50% : F
50%-54%: D
55%-59%: C
60%-64%: B
65%-74%: B+
75%-84%: A
85% and above: A+

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

Exercise:

Use the Marks file and find the total marks using the formula (bestof(minor1, minor2)+(sumof all assignments/2)+major) and then the grade using thefollowing formula:

Less than 40% : F
40%-49%: D
50%-54%: C
55%-64%: B
65%-70%: B+
75%-80%: A
80% and above: A+

Exercise 2

Use the file Amazon sales file and do the following:

Find the total revenue for each of the different types of product lines and draw a pie chart.
Find the revenue for books sold by only Amazon and not its affiliates.
Find the total number of items shipped and total revenue generated by third party.

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:

Basic Shell Scripting

Some of the scripts demonstrated are given below:

Following are the links to scripting tutorials that may be of use:

EXERCISES

A script that takes the name of the file as input and computes the average of the second column of the contents of the file and outputs the name of the file and the average.

A script to walk through the files in the directory and compute the average of the values in the files. The output consists of one line per file with each line having the name of the file and average of the 2nd column.

Write a program called isyes that returns an exit status of 9 if its argument is "yes" and 1 otherwise. For purposes of this exercise, consider y, yes, Yes, YES and Y all to be valid "yes" arguments. Write the program using an if command and then rewrite it using a case command.

Assignment for Nov. 2, 2016

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.