COM111 Assignments

Assignments

I.                   Poster assignments

Prepare poster in any open source software in any IT topics related to agriculture.

II.                Presentation

Prepare and present any one topic from agroinformatics.

III.             Written Assignments

Prepare answers for any twenty five questions of the following and mail.

1.      List down the ISPs? Any 15.

2.      List down any ten mail servers.

3.      Explain about Getting started with MS Word

4.      Explain about Saving and Printing in MS Word

5.      How to create a Bibliography in MS Word

6.      How to write, insert or change an equation in MS Word

7.      How to view the privacy option in MS Word.

8.      Who is the developer of iOS?

9.      What is windows phone?

10.  Brief android.

11.  Draw the logo of any five operating systems.

12.  List down any ten operating system?

13.  What is meant by IEEE?

14.  Brief more about wireless fidelity/

15.  Explain mobile network?

16.  Explain about tracking changes and comments in MS Word

17.  How to enable or disable macros in Office files (MS Word)

18.  Explain about i) commands that might be disabled when more than one person is editing a document ii) Conflict resolution mode in Word iii) Save and refresh documents with Updates(MS Word)

19.  How to Add, change, find or clear conditional formats(Conditional Formatting) in MS Excel

20.  Explain the list of Worksheet functions in MS Excel

21.  How to use a shared workbook in MS Excel

22.  How to track changes in a shared workbook in MS Excel

23.  How to protect worksheet or workbook elements in MS Excel

24.  How to apply data validation to cells in MS Excel

25.  Create a chart from start to finish(charts→ Creating chats) in MS Excel

26.  How to i) Chart your data ii) Change the chart type of an existing chart, Difference b/w Smart art graphic and chart(charts→ Creating chats) in MS Excel

27.  Add or remove a secondary axis in a chart(charts→ Formatting chats) in MS Excel

28.  Change the display of Chart axes(charts→ Formatting chats) in MS Excel

29.  What is meant by Formula broken(Formulas→ Correcting formulas) in MS Excel

30.  How to find and correct errors in formulas(Formulas→ Correcting formulas) in MS Excel

31.  How to create a new Desktop database in MS Access

32.  How to Split a database in MS Access

33.  i) What and where is the Backstage view ii) How to repair or remove the Office programs iii) What is add-in crashing in MS Access

34.  i) What is File block ii) What is Clip Organizer in MS Access

35.  How to add records to a table by using Append Query in MS Access

36.  Explain the Accessibility features in Microsoft office, How to encrypt a database by using a database password in MS Access

37.  How to Customize the list of recently used files, How to Automatically save and recover office files(MS Access)

38.  What are the ways to share an Access database(MS Access)

39.  Explain about Access 2010 specifications(MS Access)

40.  How to convert a database to the Access 2010 file format, How to help, prevent and correct database file problems by using Compact and Repair(MS Access)

41.  Explain the Introduction of Access Programming(MS Access)

42.  Explain about working with sounds in MS PowerPoint

43.  Explain about working with shapes in MS PowerPoint

44.  How to create and print notes pages, What is a Slide Master in MS PowerPoint

45.  How to create or customize a Slide master, Apply one or more slide masters to a presentation in MS PowerPoint

46.  i) How to Customize the list of recently used files ii) How to use the document recovery task pane to recover your files 

47.  i) How to Customize the list of recently visited places ii) How to open a PowerPoint 2010 presentation in PowerPoint 2003 or earlier(MS PowerPoint)

48.   How to Recover Unsaved Versions in Office 2010(MS PowerPoint)

49.  How to Broadcast your presentation to a remote audience(MS PowerPoint)

50.  What is File block in MS PowerPoint

51.  i) How to Organize the slides into sections ii) What is a Slide layout iii) How to add slide numbers, notes page numbers and date/time(MS PowerPoint)

52.  LCD Monitors

53.  Scanning terminologies

54.  Printing terminologies

55.  Effective searching tips

56.  Email etiquette

57.  Network cable types

58.  Color coding voltage for SMPS

59.  Web designing

60.  Web hosting

61.  Interesting computer facts.

62.  Find some E-learning applications/software.-

63.  Explain ISP. ISP in India-

64.  ICANN.-

65.  Web hosting service.-

66.  Social networking service-

67.  HD video/Television-

68.  Phishing-

69.  Spam-

70.  Firewall-

71.  CRT monitors-

72.  Difference b/w wireless and wired network with E.g.

73.  Programming language with e.g.-

74.  Programming s/w with e.g.

75.  CPU-

76.  Removable drives with e.g.-

77.  What is a Spreadsheet-

78.  What is a Word processor-

79.  Explain about computer Virus

80.  What is Network Access Protection

81.  Information technology

82.  Backup & recovery strategies-

83.  Web browser

84.  Web Slice

85.  DBMS-

86.  ODBC

87.  Search engine with e.g.-

88.  Internet information services

89.  Encryption and decryption

90.  Spyware

91.  Troubleshooting in windows

92.  Proxy server-

93.  Client & server

94.  How to change the layout or style of a chart in MS Excel-

95.  i) How to change the scale of horizontal(category) axis in a chart ii) How to change the scale of vertical(value) axis in a chart(MS Excel)

96.  Define and solve a problem by using Solver in MS Excel-

97.  Define and use names in formulas (MS Excel)-

98.  i) Define or clear a print area on a worksheet ii) How to correct a #NULL! Error(MS Excel)-

99.  How to remove hidden data and personal information by inspecting workbooks(MS Excel)-

100.          How to i) find or replace text and numbers on a worksheet ii) Turn off recommended update and diagnostic settings (MS Excel)-

101.          How to Outline a list of data in a worksheet (MS Excel)-

102.          Explain subtotal and total fields in a PivotTable reports, How to copy cell values not formulas (MS Excel)-

103.          How to use Headers and footers in worksheet printouts (MS Excel)-

104.          What is a PowerPoint template? How to apply a template to presentation. How to create and print notes pages (MS PowerPoint) -

105.          How to i) package a presentation for CD ii) deliver and distribute the presentation iii) Use e-mail to send a presentation or a link to a presentation (MS PowerPoint)

106.          How to i) Show markup and add comments ii) Work on a presentation at the same time as others work(MS PowerPoint)

107.          How to i) Name and save your presentation ii) Open or save a presentation in a different file format (MS PowerPoint)

108.          How to create an expression in Microsoft Access

109.          Insert a picture or Clip art(Pictures and Clip art) in MS Word

110.          Headers, Footers and Page numbers in MS Word

111.          Page breaks and Section breaks in MS Word

112.          Creating documents in MS Word

113.          Move the Quick access Toolbar and Customize the Quick access toolbar(Getting Help) in MS Word

114.          How to check Spelling and Grammar(Spelling, grammar and thesaurus)      in MS Word

115.          How to i) Set the default font ii) Apply, customize and save a document theme(Formatting) in MS Word

116.          How to i) add or remove text effects ii) Adjust the spaces b/w lines and paragraphs iii) Apply strikethrough formatting iv) Make text superscript or subscript(Formatting) in MS Word

117.          How to create a Table of contents in MS Word

118.          Keyboard shortcuts for MS Word

119.          Managing Worksheets(Getting started with Excel→ Worksheets) in MS Excel

120.          Editing Data(Getting started with Excel→ Worksheets) in MS Excel

121.          Apply or remove cell borders on a worksheet(Getting started with Excel→ Worksheets→ Formatting Data)in MS Excel

122.          Apply or remove cell shading(Getting started with Excel→ Worksheets→ Formatting Data) in MS Excel

123.          Change the color of text, Reposition the data in a cell(Getting started with Excel→ Worksheets→ Formatting Data) in MS Excel

124.          Add or remove a sheet background, Show or hide gridlines on a worksheet(Getting started with Excel→ Worksheets→ Formatting Data) in MS Excel

125.          Selecting and Navigation(Getting started with Excel→ Worksheets) in MS Excel

126.          How to i) Apply conditional formatting ii) Chart your data iii)  Create a workbook(Getting started with Excel→ Introduction to Excel) in MS Excel

127.          How to i) Filter data by using Auto filter ii) Format numbers in a worksheet iii) Create a Formula (Getting started with Excel→ Introduction to Excel)

128.          How to i) Sort data by using Auto filter ii) Create an Excel table iii) Use a function in a formula iv) Enter data in a worksheet(Getting started with Excel→ Introduction to Excel) in MS Excel

129.          How to get started with Access 2010(Getting started)

130.          Explain about  Access 2010 user interface(Getting started)

131.          What’s new in Microsoft Access(Getting started)

132.          How to Export Access data to a Word document(Reports)

133.          How to add data to Access database(Access basics)

134.          How to update data by using a query(Adding and modifying data) in MS Access

135.          How to Import or link to data in an Excel workbook  in MS Access

136.          How to i) Minimize the Ribbon ii) Customize the Ribbon in MS Access

137.          How to i) Move the Quick Access Toolbar ii) Customize the Quick Access Toolbar in MS Access

138.          Keyboard shortcuts for Microsoft Access

139.          How to i) Crop a picture ii) Reduce the file size of a picture in MS PowerPoint

140.          How to Add, change or delete shapes in MS PowerPoint

141.          How to i) Add, copy or delete a textbox ii) Change the color, style or weight of a line in MS PowerPoint

142.          How to i) Apply background picture, color or watermark to the slides ii) Use Portrait and landscape slide orientation in the same presentation

143.          What is a theme? How to apply a theme to add color and style to the presentation in MS PowerPoint

144.          How to animate i) text or objects ii) SmartArt graphic in MS PowerPoint

145.          How to i) Add transitions b/w slides ii) Change or remove transition in MS PowerPoint

146.          What is a Presenter View? How to create and print notes pages in MS PowerPoint

147.          Explain i) Minimizing the Ribbon ii) Customizing the Ribbon in MS PowerPoint

148.          How to i) Move the Quick Access Toolbar ii) Customize the  Quick Access Toolbar in MS PowerPoint

149.          What’s new with Windows7 taskbar (Basic)

150.          Working with Files and Folders (Basic)

151.          Explain the overview of Start menu(Basic)

152.          Explain about Using programs(Basic)

153.          Explain about Using Mouse(Basic)

154.          Explain about Menus, buttons, bars and boxes(Basic)

155.          Explain about Working with Digital pictures(Basic)

156.          Explain about Printing a document(Basic)

157.          Introduction to Computer(Basic)

158.          Parts of a computer(Basic)

159.          What is new with Windows desktop(Basic)

160.          Customize the Ribbon in MS Word.

161.          What is Protected View in MS Word

162.          How to Automatically Save and Recover files in MS  Word.(File management)

163.          Different reading views  in Word(Reading Documents)

164.          Explain heading styles(Formatting), Show or Hide Formatting Marks(Reading Documents)

165.          What is Word Art? Add, change or delete Word Art, What is Clear Formatting(Formatting)

166.          Tables in MS Word

167.          Charts in MS Word

168.          Getting started with Excel

169.          Keyboard shortcuts in Excel

170.          Create or Delete an Excel Table in a worksheet

171.          Add or remove a secondary axis in a chart, Change the scale of depth axis in a chart

172.          Creating a chart in Excel

173.          Move or Copy cells and cell content (Getting started with Excel→ Worksheets→ Copying and moving data.

174.          Entering data in Worksheet(Getting started with Excel→ Worksheets)

175.          Introduction to forms(Access basics)

176.          Introduction to queries(Access basics)

177.          Introduction to tables(Access basics)

178.          Introduction to controls(Access basics)

179.          Database design basics(Access basics)

180.          How to select and use an Access template(Access basics)

181.          Define the structure of an Access database(Access basics)

182.          How to protect the data with backup and restore(Access basics)

183.          What’s new in PowerPoint 2010

184.          How to get started with Microsoft PowerPoint 2010

185.          How to get familiarize with i) PowerPoint workspace ii) the Ribbon in PowerPoint 2010

186.          How to i) Add, rearrange and delete slides ii) Add slide numbers, notes page numbers and date/time

187.           How to use views in PowerPoint 2010

188.          How to i) Add text to a slide ii) Change the color of text

189.          How to i) Wrap text around an object in PowerPoint ii) Add bullets or numbers to text iii) Adjust the indent in a bulleted or numbered list on the Ruler

190.          Explain Working with Tables in MS PowerPoint

191.          Keyboard shortcuts for Windows

192.          Explain about Icons. Types of Icons

193.          Explain about the Taskbar

194.          Working with Windows

195.          How to manage multiple windows

196.          Explain about- Customizing the computer