IT WORKSHOP

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

TA: Sowmini(PhD) and Sarvesh(MTech)

Evaluation Policy

Command Line Interface (CLI) versus Graphical User Interface(GUI)

• Why the GUI will never kill the sacred command line

Submission Policy

• Zip all the relevant files together. For e.g., for Latex assignments, you will need to zip the .tex file and any image files you have used to include in the document and any style files that you might have used that are not part of the standard Latex library.
• The name of the zip file MUST be mexx.zip where xx stands for your reg. no.
• Mail this .zip file from your SCIS email a/c to my a/c apcs@scis.uohyd.ac.in

Datafiles/Ebooks for Minors/Major

• emp.xls
• major.ods
• Unix Programming Environment
• Latex by Leslie Lamport

ASSIGNMENTS

1. Assignment -- 1

---

2. Assignment -- 2: Excel exercises
1. 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+
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.

---

3. Assignment -- 3:
   1. Create a document about a Turing Award winner of your choice while ensuring that no two people talk about the same winner. The document should consist of a figure, two tables about their education and awards received, use the features of enumerate and itemize. It should also use the cross-referencing feature to refer to the figures and tables.
   2. Here is an Example pdf file with advanced Tables and Equations that you need to reproduce exactly.

   ---

4. Assignment -- 4: Make a presentation about the Turing award winner you have chosen including all the tables/figures using beamer.

---

5. Assignment -- 5: Do the following exercises using sed.
   1. Create a file containing reg. nos of the I.M.Tech. format (17MCMExx format). Then, write the sed command to convert them to the M.Tech.(CS) format (17MCMTxx format).
   2. Take the file Unix.txt and write only the lines containing the word "Unix/unix" into a new file while also replacing "Unix/unix" to "Linux/linux" respectively.
   3. Using the file /etc/hosts file in your system, write only the comment lines to a file called comments.txt, all lines that start with a digit to a file called ipv4.txt and all lines that start with "f" to the file called ipv6.txt.
   4. Create an empty file called imtech-2017-marks.csv. Replace the extension "csv" of that file with "ods". Also, replace string "marks" with "attend". Use a single sed command to do this.
   5. In the Example file, replace the various versions of OpenFlow such as "openFlow", "Openflow", "openflow", "open flow" etc. with the right spelling of "OpenFlow" with a single regular expression.
   6. NOT FOR MARKS: Here is a website that has grep/awk/sed challenges for those who want to become Linux geeks!

   ---

6. Assignment -- 6: Do the following exercises using awk.
   1. Repeat the exercises for amazon.ods file using awk. You will need to convert the ods file to a csv file first before you can use it with awk.
   2. Use the Marks file and compute the average of internal and major. Also compute the total number of students per grade.

   ---

7. Assignment -- 7: Scripting Exercises
   1. 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.
   2. List all files whose size is larger than a given size in a given directory.
   3. Check the disk usage of a user and print a message "WARNING: Disk usage exceeding quota value" where quota is the value given as a parameter and the user name is also a parameter to the script.
   4. Write a script that replaces all spaces in the file name with _.
   5. 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.
   6. For every line in greedy-mds-800-150.out, paste the last two columns of the corresponding lines in ga-mds-800-150.out.
   7. Write a script that takes a directory name and a file extension as input and for all the files with that extension in that directory, prints the name of the file, its size, the number of lines in the file in descending order of the number of lines.
   8. Find all the files in which the string "printf" occurs in the directory /usr/include. Print only the unique file names in which this string occurs. At the end, print the number of files in which this string occurs.
   9. Write a shell script that takes a uid as an argument and prints out that person's name, home directory, shell and group number. Print out the name of the group corresponding to the group number, and other groups that person may belong to. (groups, awk, cut. Also look at /etc/passwd and /etc/groups).
   10. Given a process ID (PID) as input, write a script that checks whether the process is still running or not. (hint: use ps and sleep commands)

Introduction to Linux

• Linux Command Reference
• Introduction to Linux Command Shell for Beginners
• Introduction to Linux
• Eight simple tutorials for basics of Unix/Linux
• sed: an introduction and tutorial by Bruce Barnett
• The Unix School: awk and sed
• Introduction to Unix
• sed and awk presentation

Introduction to Latex

• 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.
• Latex Tutorial from Tex Users' Group
• Introducing Latex
• Getting Started with Latex
• A Latex Primer
• Typesetting Tables with Latex
• Latex WikiBook

Introduction to Beamer

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

• Beamer Tutorial in Beamer
• Themes in Beamer
• Setting transparent images as background in slides
• Beamer User Guide
• Wikibook on Latex Presentations
• Using Beamer Themes

Introduction to MS-EXCEL

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

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:

• Feedback Controller Figure
• Flow chart

Basic Shell Scripting

• suffix.sh
• unsuffix.sh
• simple-mv.sh
• Renaming the extension of a group of files
• Checking if a parameter is a directory
• Example illustrating if-elif-else
• Example illustrating if-else-if-else
• Example illustrating $# and case
• Example illustrating && and ||

• Learning the Shell
• Bash Scripting Tutorial
• Ryan's Bash Scripting Tutorial

Introduction to HTML and CSS

• HTML Tutorial
• HTML Color Names
• CSS Tutorial
• CSS Introduction
• Simple Personal CSS templates
• Free CSS Templates