bcs topics All Diploma Courses I Semester Subject: Basic Computer Skills Contact hrs/Week: 06 Total Contact Hrs

/ Sem.: 96

Course Content 1 Concept of Hardware & Software.. 2 Word processing.. 3 Spreadsheet and Charts

10 Hrs 20 Hrs 20 Hrs

4 Dataprocessing.. Hrs 16 5 Presentation.. 6 Internet Basics. 15 Hrs 15 Hrs 16 Hrs Total 96 Hrs

Page 1 of 6

bcs_geos_sios Department of Technical Education All Diploma Courses I Semester Subject: Basic Computer Skills Total Contact Hrs / Sem.: 96

Contact hrs/Week: 06

General Educational Objectives : After the completion of the study of this subject students should be able to 1. Recognize the various models of computer system 2. Recognize the various parts, physical components of a computer 3. Understand the cable connections and booting steps 4. Know the various I/O devices 5. Understand the need of Operating System 6. Use the various DOS commands 7. Understand the use of mouse buttons 8. Appreciate working under windows environment 9. Appreciate the use of Windows Explorer 10. Create any document 11. Know to format the document and take a printout 12. Create a worksheet in 13. Use functions and formula 14. Know to format the worksheet and take a printout 15. Create a database in 16. Create view, form, table, query and report 17. Know to take the printout of the report 18. Create a presentation using PowerPoint 19. Know to Insert Slides into the presentation 20. Understand various slide transitions 21. Demonstrate the slide show 22. Know to print the handouts 23. Understand the basics of Internet 24. Create an e-mail account 25. Know to send and receive mails 26. Use search engine while browsing 27. Use any Kannada Software package Specific Instructional Objectives: 1 Concepts of Hardware and Software Identify the models of computers - Tower, Desktop, Laptop, Palmtop Identify and understand front panel switches and back panel connectors of a computer system. 1.3 Identify and Understand the physical components of computer : 1.3.1 Motherboard (System Board) 1.3.2 Processor chip 1.3.3 Memory 1.3.4 HDD 1.3.5 FDD 1.3.6 CDD(R/W) 1.3.7 SMPS 1.3.8 Ports (Serial, Parallel & USB) 1.3.9 VGA/SVGA/AGP 1.3.10 Sound card 1.1 1.2

Page 2 of 6

bcs_geos_sios Network Card MODEM Card (internal and External) Input devices - Keyboard, Mouse, Scanner, Joystick, Compact Disk etc Output devices - Monitor, Printer, Plotter, etc. 1.4 Understand the need of an Operating system 1.5 Differences between command line and graphical user interface 1.6 Understand the meaning of the following terms : 1.6.1 Single user single tasking 1.6.2 Single user multi tasking 1.6.3 Multi user multi tasking 1.6.4 Batch processing 1.6.5 Real time Processing 1.6.6 Distributed processing 1.7 Do the connections of the system, switch on and understand the booting steps 1.8 Understand the concept of file and directory, naming rules for files / directories, types of files 1.9 Basic DOS commands - CLS,DIR, Date, Time, Version, MD, CD, RD, Del, Copy, Ren, Volume; Use of wild characters, Format, Path, Type 1.10 Getting started with 1.10.1 Windows 1.10.2 Desktop 1.10.3 Icons 1.10.4 Mouse operations - single click, double click, click & drag 1.10.5 Shortcuts 1.10.6 Popup Menus 1.10.7 Start button 1.10.8 Keyboard operations in window 1.10.9 Task Bar 1.10.10 Customizing the desktop 1.11 1.11.1 1.11.2 1.11.3 1.11.4 1.11.5 1.11.6 1.11.7 1.12 1.13 1.14 1.15 1.16 1.17 Exposure to Windows Operating System Logging on to Windows Starting and closing a program Switching between programs, documents Re-sizing windows - Maximize, Minimize and restore Find - file, folders, etc. Run - starting a program using run command Shutdown - shutdown / restart computer Practice Windows Explorer - through My computer, Icon and shortcut entry Creating/opening a document Understand clipboard concept for copy, cut and paste Editing and saving the document in Floppy/ Hard disk Study and understand Windows utilities -notepad, WordPad, paint, calculator etc Study and understand Windows system tools - scandisk, backup, system info, WinZip, etc 1.3.11 1.3.12 1.3.13 1.3.14

Page 3 of 6

bcs_geos_sios 2 Utilities WORD PROCESSING 2.1.1 Invoking word application and understand the different parts - title bar, Menu bar, Toolbar, Scrollbar, Control button, etc 2.1.2 Create a new document - edit, save, close 2.1.3 Page setup (Layout) 2.1.4 Text formatting - Selection of Fonts, font size, alignments, line spacing, paragraph alignment, indents & tabs 2.1.5 Creating documents with Multiple columns 2.1.6 Inserting symbols, file, hyperlink, clipart and pictures into the document 2.1.7 Page formatting - Inserting page numbers, date, time, fields, header and footer, footnote, comments etc 2.1.8 Practicing the utilities like find, replace, goto, spell check, grammar check, thesaurus, word count, auto text and autocorrect 2.1.9 Creating drawings and charts using drawing toolbar 2.1.10 Creating tables and borders 2.1.11 Creating templates, envelopes & labels 2.1.12 Object Linking and Embedding (OLE) 2.1.13 Taking printout of the document 2.1.14 Mail-merging 2.1.15 Creating Macros and customizing Word 2.1.16 Exiting Word 2.2 SPREADSHEET AND CHARTS 2.2.1 Invoking Excel application and understand the different parts - title bar, Menu bar, Toolbar, Scrollbar, control window, etc 2.2.2 Creating an excel book 2.2.3 Understanding the excel sheet, cell, rows & columns, sheet size, navigating the workbook 2.2.4 Entering data - numeric, text and formula 2.2.5 Formatting a cell - number, date, time, text, alignment, border, font, pattern, protection, etc. 2.2.6 Formatting rows and columns 2.2.7 Understand Filling series 2.2.8 Selecting cells, rows or columns 2.2.9 Clearing contents and formats of the cells selected 2.2.10 Creating different types of graphs for given data 2.2.11 Formatting charts 2.2.12 Dealing with formulas, functions related with text, logical, mathematical, etc 2.2.13 Manipulating Data - Sorting, filtering, validation, importing & exporting data 2.2.14 Working with windows - Splitting, freezing and setting the print area 2.2.15 Creating an excel report 2.2.16 Printing an excel sheet/part of an excel sheet 2.2.17 Object Linking and Embedding (OLE) 2.2.18 Creating Macros and customizing Excel 2.2.19 Exiting Excel 2.3 DATAPROCESSING 2.3.1 Starting Access and understanding the concept of data, field, record, table and database 2.3.2 Creating a database, tables, view, forms, query, report, index etc 2.3.3 Use of wizards to create tables 2.3.4 Create a report and take the printout 2.3.5 Creating Macros and customizing Access 2.3.6 Exiting Access 2.4 PRESENTATION 2.1

Page 4 of 6

bcs_geos_sios

3 3.1

3.2 3.3 3.4 4

2.4.1 Invoking PowerPoint application and understand - title bar, Menu bar, Toolbar, Scrollbar, control window, etc 2.4.2 Creating a presentation using auto context wizard, Design Templates and Blank presentation 2.4.3 Opening, saving, closing a presentation 2.4.4 Working with slides - Inserting pictures, tables, sound files, outline, slide transitions 2.4.5 Slide show - manual, auto 2.4.6 Printing handouts 2.4.7 Creating Macros and customizing PowerPoint 2.4.8 Exiting PowerPoint INTERNET Understand the meaning of : Network, Internet, intranet, internet server, internet browser, Webpage, Website, URL's, Search engines, http, www, WTML, DHTML and Outlook Logging on to internet, browsing the net, using search engines, Downloading a file Creating an E-Mail ID, Sending and Receiving E-Mails, voicemail, video mail, video conferencing, etc Chatting Practice on any Kannada Software Package

SAMPLE EXERCISES WORD PROCESSING 1. Create a business or personal letter 2. Create a company letterhead 3. Create a simple newsletter 4. Create a memo 5. Create a resume 6. Create an Invitation/Greeting Card 7. Create the cover page of a project report 8. Create a mail merged letter/Invitation 9. Create a Macro which inserts a picture and formats the text SPREADSHEET 1. Create a worksheet with 4 columns. Enter 10 records and find the sum of all columns 2. Create a report containing the pay details of the employees 3. Create a results sheet containing Candidate's Register No., Name, Marks for all subjects, Total and result. Total and result must be calculated as below: Total is sum of marks in all subjects Result is Distinction if Total >= 70 % First Class if Total > = 60 % and < 70 % Second Class if Total >= 50 % and < 60 % Pass if Total >= 35 % and < 50 % provided the candidate has secured at least 35 marks in each subject. Fail otherwise. 4. Create a simple Bar chart to highlight the sales of a company for 3 different periods 5. Create a pie-chart - give legends 6. Create a worksheet importing data from a database and calculate sum of all the columns 7. Create a Macro which creates a line chart using the data in the worksheet

DATABASE

Page 5 of 6

bcs_geos_sios

1.Create a simple table for result processing 2.Design a query table for the same table 3.Design a form to update/modify the table contents 4.Design a report to print the result sheet and marks card for the above table. PRESENTATION 1.Create a simple presentation to list simple DOS commands, Hardwares, Software's etc. INTERNET BASICS 1.Practice browsing of different sites using search engine 2.Practice Understanding different e-mail services-Gmail, Yahoo mail, rediff mail etc. 3.Practice creating e-mail account, Sending Receiving & Storing of mails

Page 6 of 6