Teaching Assistants: Manyam, Anil, Lakshman Rao, Kiranmayi, Sridhar
Please use the MS-WORD data sheet and Excel data sheet to do the minor questions on WORD and Excel.
Please use the WORD data sheet and Excel data sheet to do the major questions related to WORD and Excel respectively. Dowload and use the Earth picture to be used in Latex document.
You may also download the Latex Cheat Sheet as help for the Latex part.
In this lab, the students are expected to reproduce the Sample Document in Microsoft Word. This is to understand the capabilities of the tool itself as well as how comfortable students are with various sections of Microsoft Word. The image to be included in the document is that of Thompson and Ritchie.
In this lab, we will explore MS-WORD further for more advanced features. I had asked that in the first document, you must use automatic sectioning and captioning for getting the section numbers and table and figure numbers. If you have not done so, you will see issues in this lab. So, please do that first before you start doing this lab.
Understanding how automatic sectioning and captioning change section/caption numbering automatically
Students need to add a new section between sections 2 and 3 titled "The Favorite Things in my Life". This will have two sub-sections: "My Dream" - what you would like to do in your life and how to go about achieving your dream (please be as honest as you can be and think about what you want to write). The second sub-section will contain your favorite picture and the title of this section will be "My Favorite Picture".
Understanding how to use cross-referencing
When referring to the various tables and figures in the document, use the cross-referencing feature of the tool. DO NOT TYPE "In Figure 1" yourself and change it every time a new table/picture/section is added to the document. Instead learn to use cross-referencing.
Understanding how to use Table of Contents
Now, generate the table of contents of the document.
Understanding how to re-generate the Table of Contents
Add a last section titled "Conclusions" in which you tell me what you feel you have learnt in the last 3 labs and was it useful. What can be done to improve the lab sessions.
Now, re-generate the table of contents.
Converting the document from single column to double-column
Convert the Single Column document into a double-column document without table of contents. What are the difficulties encountered? Make a section before Conclusions section about the difficulty level of converting from one format to another and how you overcame it.
SUBMIT YOUR DOCUMENT AFTER ALL THESE CHANGES as the final submission of your work on MS-WORD
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/2). 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.
Understanding how to use VLOOKUP function
Instead of using a complex equation to compute the grade, we will use VLOOKUP for grade computation.
Excel Vlookup Function and VLookup Example
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.
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.
Understanding how to use Pivot Tables
Help for using Pivot Tables in Excel
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.
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.
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.
Here is the Second Example with Tables and Equations pdf file that is to help you exercise and improve your Latex skills.
