SYLLABUS FOR CLASS 9

RATIONALE

A multitude of computing tools are now an integral part of business, industry and government offices where computer technologies such as email, Internet, spreadsheet and word processor all serve to enhance communication and information access, and thus improve work efficiency and productivity. Knowledge and skills in these areas have become a valuable skill, if not a prerequisite, in the job market.

Up until class 9, students in Bhutan have, in general, little exposure to Information and Communication Technology (ICT), and hence do not possess the relevant skills. There are substantial numbers of students who will leave the formal educational system at the end of class 10 and class 12. Students who leave at classes 10 and 12 will, in general, join the workforce shortly afterwards.

Computer Applications, therefore, has been introduced in view of market demand for computer literate employees and student demand for relevant courses on modern computing technologies. This course aims at making students computer literate. Increasingly, the term literacy would encompass the knowledge and skill of using the online information. Preparingour children with necessary computer knowledge, skills and values will prepare them to cope withthe knowledgebased economy.

For students pursuing higher studies in the area of ICT, this course provides encouraging experience and “soft” lead-in to higher level of computing technologies in classes XI and XII.

AIMS

Teachers should help the students to:

  • Understand the computing terminology and fundamental concepts.
  • Acquire skills in applying healthy and safe practices of computing.
  • Understand the history and evolution of computers and the Internet.
  • Acquire skills and knowledge to use appropriate resources both within and beyond the classroom.
  • Develop confidence in using a variety of computing technologies in relation to real-world situations.
  • Establish the foundation upon which ICT skills can be developed.

LEARNING EXPERIENCES

Students should:

  • Be encouraged to learn through inquiry, exploration and experimentation.
  • Have opportunities to relate their activities to real-world situations/examples/cases.
  • Have opportunities to familiarize with and practice different computing applications independently and in groups.
  • Be provided opportunities to acquire proper knowledge about computers.
  • Be provided adequate hands-on experiences in using computers.

LEARNING OUTCOMES

These experiences should help the students to

  • Demonstrate understanding of historical evolution of computers and the Internet.
  • Identify the common components of a computer and describe their functions.
  • Employ safe and healthy practices when operating computers and accessing online information.
  • Demonstrate knowledge and understanding of computing concepts through the use of appropriate terminology in the correct context.
  • Use relevant online information to enhance their work productivity.
  • Learn independently through inquiry, exploration and experimentation.
  • Use appropriate tools/applications to solve a variety of tasks or problems.

COURSE CONTENT FOR CLASS 9

1.Evolution and History of Computers (5%)

  • A brief background only

2.Hardware and Peripherals (15%)

  • Basic computer components: monitor, keyboard, mouse, CPU
  • Memory: RAM (volatile), ROM/firmware (non-volatile), capacity (bit, byte, KB, MB, GB)
  • Storage devices: fixed drives (hard disk), removable drives (floppy drive, Zip drive, CD ROM drive), storage capacity (bit, byte, KB, MB, GB)
  • Printers: dot matrix, line printer, ink jet printer, laser printer

3.Software (5%)

  • System Software and Application Software: concept, definition and differences
  • Operating System: concept, definition and functions
  • Explanations and examples of various softwareprograms such as word processor, spreadsheet, presentation, email, web browser, antivirus, etc.

4.Introduction to Windows (10%)

  • Windows terminologies: menus, icons, title bar, menu bar, scroll bar, maximise, minimise, restore, cursor, mouse pointer, dialog box, application window, document window, desktop, program, taskbar, screensaver, wallpaper
  • Mouse operations: left click, right click, double click, drag and drop, select, copy and paste, cut and paste(use Paint program to practise mouse skills)
  • Keyboarding skills: use Typing Tutor to practise (software on PGCTIS Resource CD)
  • Windows shortcuts: using combined keys and function keys as alternative to using mouse

5.File and Computer Management (15%)

  • Files and folders: concept, create, rename, delete
  • Directories and paths: concept, create, rename, delete
  • Managing Desktop and Recycle Bin
  • Backing up files on a floppy
  • Searching files: using wild cards * and ?
  • Using essential MS DOS commands and wild characters: copy, dir, md, rd, del, cls, time, date, *, ?
  • Using Windows disk maintenance tools: ScanDisk, Disk Defragmenter, Disk Cleanup
  • Hardware maintenance: protecting from dust and liquid, and power fluctuations (stabiliser/CVT/MCB/UPS)
  • Healthy operation practices: proper start up and shut down procedures, disconnecting mains before opening computer cabinets, using proper voltage settings, keeping computers clean, taking break from computer screen regularly, etc.

6.Word Processing using Microsoft Word (25%)

  • Concept, and orientation of screen, menu and toolbars
  • Creating and editing (backspace, delete, copy, cut, paste, selecting text) document
  • Saving, opening and deleting documents
  • Character formatting (font attributes)
  • Paragraph formatting (indent, line spacing, justification)
  • Page formatting (orientation, size, margin, border, number)
  • Bullets and numbering
  • Header and footer
  • Spell check, thesaurus, search and replace, help
  • Previewing and printing (print menu features)
  • Using clipart and drawing tools (WordArt, AutoShapes)
  • Using tables (insert/delete row and column, shading)
  • Using Equation Editor

7.Spreadsheet using Microsoft Excel (25%)

  • Concept, and orientation of screen, menu and toolbars
  • Spreadsheet terminologies (cell, worksheet, workbook)
  • Using cell references, and selecting cells and ranges
  • Data entry and editing data (AutoFill, sort, copy, cut, paste)
  • Cell formatting (fonts, shading, alignment, text wrap, merge, split, borders)
  • Using in-built functions and creating simple formulae (with arithmetic operators +, –, *, / and with functions such as SUM, AVERAGE, etc.)
  • Using and modifying charts
  • Previewing and printing (print menu features)

MODES OF ASSESSMENT

The course at this level will be assessed internally by the school. The assessment will consist of two modes – continuous assessment and written examination – as explained below.

1.Continuous Assessment (20%)

The continuous assessment consists of class work and course work (small project work/assignments). Both class work and course work will carry a credit of 10% each.

Class work will be assessed regularly after every unit or topic. This will provide teachers the opportunities to judge how well the student is faring in the topic and accordingly try new strategies to help him learn better.

Students will be required to do two assignments. Each assignment will not be more than 5 pages or three sheets, and should be submitted as a soft copy (i.e. on a floppy). These assignments will be based on a topic or a related set of topics already covered.

For details on assessment of class work and project work (referred here as course work), refer Continuous Assessment Classes VI to X Teachers’ Guide, CAPSD, 1999.

2.Examination (80%)

There will be two papers for examination – theory and practical. There will be no choice of questions in either paper.

PaperI

Questions will be in the form of multiple choice, fill in the blanks, short answer type or mix of the three covering the entire syllabus. It is onehour written examination and will be evaluated out of 30 marks.Use of computers is not required. Answers must be written in the question booklet only.

Paper II

This paper will contain questions which require the use of computersand therefore, it should be conducted in the computer laboratory. The focus here will be on assessing the word processing skills using Microsoft Word, and spreadsheet skills using Microsoft Excel. This paper will be evaluated out of 50 marks. It istwohour practical examination. The completed work should be submitted on a floppy disk provided.

WEIGHTING OF TOPICS FOR EXAMINATION

Evolution and History of Computers / 2 / Paper I
30
Hardware and Peripherals / 10
Software / 3
Introduction to Windows / 5
File and Computer Management / 10
Word Processing (Microsoft Word) / 25 / Paper II
50
Spreadsheet (Microsoft Excel) / 25
Total Marks / 80 / 80

SUPPLIED TEXTBOOKS AND REFERENCES

Textbook

  • Computer Applications Class 9 (2004). Sangeeta Panchal and Alka Sabharwal. OxfordUniversityPress, India.

References

  • Introductory Information Technology. The Complete Textbook for Class IX (2002). Satish Jain and Shashank Jain. BPB Publications, India.
  • PGCTIS course handouts and reference books
  • PGCTIS resource CD

SYLLABUS FOR CLASS 10

COURSE CONTENT FOR CLASS 10

1.Introduction to Computer Networks (5%)

  • Concept
  • Advantages and disadvantages
  • Types: based on area coverage (LAN, WAN) and based on topology or layout (linear, bus, ring, star)
  • Network protocols: basic concepts only
  • Network devices: cable (co-axial, UTP, fiber optic, etc.), hub, switch, router, server (web, mail, etc.)

2.Internet and Email (25%)

  • Concept and brief history of the Internet
  • Resources required for dial-up Internet connection: modem, phone line, web browser, and demonstration
  • Common terminologies:ISP, URL, domain types (.com, .edu, .org, .bt, .sg, .info), web page, email, download, hyperlinks, home page, etc.
  • Using search engines ( Boolean search techniques (using +, AND, OR, NOT)
  • Using bookmarks (Favorites in Internet Explorer)
  • Printing: directly and using a word processor (copy-paste)
  • Downloading from the Internet
  • Creating email: account, user ID, password
  • Using email: sending mail and attachment, replying, forwarding, sending copies (cc, bcc)
  • Using email: blocking spam, netiquettes

3.Data Security and Computing Issues (10%)

  • Computer virus – concept, effects, types (worms, macro, boot sector, multipartite, etc.)
  • Using antivirus: examples (Norton, Panda, McAfee, Inoculate) and demonstration
  • Updating virus definitions
  • Health issues: RSI, ergonomics
  • Copyright issues: software piracy, illegal or unethical contents
  • Privacy protection: password, ID, data encryption

4.Presentation using Microsoft PowerPoint (20%)

  • Concept, and orientation of screen, menu and toolbars
  • Create and save presentation files
  • Insert and delete slides
  • Formatting slides (fonts, alignment, design, layout)
  • Adding custom animation and sound effects
  • Adding clip arts and drawings
  • Running slide shows
  • Previewing and printing (print menu features)

5.Database using Microsoft Access (40%)

  • Concept, and orientation of screen, menu and toolbars
  • Creating tables using appropriate data types
  • Table relationships
  • Creatingqueries
  • Designing forms (using proper button layouts, colour and font choice)
  • Creating reports
  • Previewing and printing (tables, queries, forms)

MODES OF ASSESSMENT

Assessment at this level will be of two types. Continuous assessment will be done internally by the school.The examination will be conducted by the Bhutan Board of Examinations Division.

1.Continuous Assessment (20%)

The continuous assessment consists of class work and course work (small project work/assignments). Both class work and course work will carry a credit of 10% each.

Class work will be assessed regularly after every unit or topic. This will provide teachers the opportunities to judge how well the student is faring in the subject and accordingly try new strategies to help him learn better.

Students will be required to do two assignments. Each assignment will not be more than 5 pages or three sheets, and should be submitted as a soft copy (i.e. on a floppy). These assignments will be based on a topic or a related set of topics already covered.

For details on assessment of class work and project work (here referred to as course work), refer Continuous Assessment Classes VI to X Teachers’ Guide, CAPSD, 1999.

2.Examination (80%)

There will be two papers for examination – theory and practical. There will be no choice of questions in either paper.

Paper I

Questions will be in the form of multiple choice, fill in the blanks, short answer type or mix of the three covering the entire syllabus. It is onehour written examination and will be evaluated out of 30 marks. Use of computers is not required. Answers must be written in the question booklet only.

Paper II

This paper will contain questions which require the use of computers and therefore, it should be conducted in the computer laboratory. Students will have to design a database using Microsoft Access. They will also have to prepare a write-up in the form of a Microsoft PowerPoint presentation on the database they designed. This paper will be evaluated out of 50 marks. It is twohour practical examination. The completed work should be submitted on a floppy disk provided.

WEIGHTING OF TOPICS FOR EXAMINATION

Computer Networks / 3 / Paper I
30
Internet and Email / 20
Data Security and Computing Issues / 7
Presentation (Microsoft PowerPoint) / 15 / Paper II
50
Database (Microsoft Access) / 35
Total Marks / 80 / 80

SUPPLIED TEXTBOOKS AND REFERENCES

Textbook

  • Computer Applications Class 10 (2004). Sangeeta Panchal and Alka Sabharwal. OxfordUniversityPress, India.

References

  • Introductory Information Technology. The Complete Textbook for Class X (2002). Satish Jain and Shashank Jain. BPB Publications, India.
  • ICSE Computer Application for Class IX (2006). Dr Gautam Roy. Allied Publishers Pvt Ltd., India.
  • PGCTIS course handouts and reference books
  • PGCTIS course CDs