Page 24 of 93
Week 11 - Task 3 : Search Engines & Netiquette : Students should know what search engines are and how to use the search engines. A few topics would be given to the students for which they need to search on Google. This should be demonstrated to the instructors.
Week 12 - Task 4 : Cyber Hygiene : Students would be exposed to the various threats on the internet and would be asked to configure their computer to be safe on the internet. They need to first install an anti virus software, configure their personal firewall and windows update on their computer. Then they need to customize their browsers to block pop ups, block active x downloads to avoid viruses and/or worms.
Week 13 Module Test A test which simulates all of the above tasks would be crafted and given to the
LaTeX and Word
Week 14 – Word Orientation : The mentor needs to give an overview of LaTeX and Microsoft/ equivalent (FOSS) tool word : Importance of LaTeX and MS/ equivalent (FOSS) tool Word as word Processors, Details of the four tasks and features that would be covered in each, Using LaTeX and word – Accessing, overview of toolbars, saving files, Using help and resources, rulers, format painter in word.
Task 1 : Using LaTeX and word to create project certificate. Features to be covered:-Formatting Fonts in word, Drop Cap in word, Applying Text effects, Using Character Spacing, Borders and Colors, Inserting Header and Footer, Using Date and Time option in both LaTeX and Word.
Week 15 - Task 2 : Creating project abstract Features to be covered:-Formatting Styles, Inserting table, Bullets and Numbering, Changing Text Direction, Cell alignment, Footnote, Hyperlink, Symbols, Spell Check , Track Changes.
Week 16 - Task 3 : Creating a Newsletter : Features to be covered:- Table of Content, Newspaper columns, Images from files and clipart, Drawing toolbar and Word Art, Formatting Images, Textboxes and Paragraphs
Week 17 - Task 4 : Creating a Feedback form - Features to be covered- Forms, Text Fields, Inserting objects, Mail Merge in Word.
Week 18 - LaTeX and Word Module Test - Replicate the given document inclusive of all features
Week 19 - Excel Orientation : The mentor needs to tell the importance of MS/ equivalent (FOSS) tool Excel as a Spreadsheet tool, give the details of the four tasks and features that would be covered in each. Using Excel –
Accessing, overview of toolbars, saving excel files, Using help and resources
Task 1 : Creating a Scheduler - Features to be covered:- Gridlines, Format Cells, Summation, auto fill, Formatting Text
Week 20 - Task 2 : Calculating GPA - .Features to be covered:- Cell Referencing, Formulae in excel – average, std.deviation, Charts, Renaming and Inserting worksheets, Hyper linking, Count function, LOOKUP/VLOOKUP
Week 21 - Task 3 : Performance Analysis - Features to be covered:- Split cells, freeze panes, group and outline, Sorting, Boolean and logical operators, Conditional formatting
Week 22 - Task 4 : Cricket Score Card - Features to be covered:-Pivot Tables, Interactive Buttons, Importing Data, Data Protection, Data Validation
Week 23 – Excel Module Test - Replicate the given document inclusive of all features
LaTeX and MS/equivalent (FOSS) tool Power Point
Week 24 - Task1 : Students will be working on basic power point utilities and tools which help them create basic power point presentation. Topic covered during this week includes :- PPT Orientation, Slide Layouts, Inserting Text, Word Art, Formatting Text, Bullets and Numbering, Auto Shapes, Lines and Arrows in both LaTeX and Powerpoint.