Sunday, 20 November 2022

U-4 Web application / class 10 IT (402)

 

Class – 10th

IT (402)

Book : Domestic Data Entry Operator

Unit-4 Web Application and Security



Fill in the blanks

SESSION 1: WORKING WITH ACCESSIBILITY OPTIONS

1)    Computer Accessibility refers to the user friendliness of a computer system for all, regardless of their disability.

2)    when a  combination of hardware and software, it enables a person with a disability or impairment  to use a computer. It is known as Assistive Technology.

3)    Cognitive impairments and learning disabilities, such as dyslexia, attention deficit hyperactivity disorder (ADHD) or autism.

4)    Visual impairment such as low-vision, complete or partial blindness, and color blindness.

5)    Hearing impairment including deafness.

6)    Motor or dexterity impairment such as paralysis, cerebral palsy, or carpal tunnel  syndrome and repetitive strain injury.

7)    Accessibility Options in Control Panel are used to customize the way your keyboard,  display, or mouse function. Many of these features are useful for people with disabilities

8)    StickyKeys is an accessibility feature to help computer users with physical disabilities, but it is also used by others as a means to reduce repetitive  strain.

9)    Filter Keys is a feature of Microsoft Windows. It is an accessibility function that tells the  keyboard to ignore brief or repeated keystrokes, making typing easier for people with  hand tremors.

10) ToggleKeys is also a feature of Microsoft Windows. It is an accessibility function which is designed for people who have vision impairment or cognitive disabilities.

11)  When ToggleKeys is turned on, computer emits sound cues when the locking keys (Caps Lock, Num Lock, or Scroll Lock) are pressed. A high sound is emitted when the keys are switched on and a low sound is emitted when they are switched off.

12)  SoundSentry is designed to help users with auditory impairments. SoundSentry generates  visual warnings, such as a blinking title bar or a flashing border, whenever the computer generates a sound.

13)  ShowSounds instructs applications that convey information by sound, to also provide information visually, through text captions or informative icons.

14)  High Contrast is an accessibility feature to assist people with vision impairment. You can change the size and color of fonts and the background for ease of viewing.

15)  Cursor Options is also an accessibility feature that assists people with vision impairment by changing the blink rate and width of the cursor.

16) MouseKeys is an accessibility feature that assists people who have difficulty using a mouse. This option uses the keyboard (especially numeric keypad) as a pointing device instead of a mouse.

17) Select the General Tab, a window to configure additional accessibility options will be displayed.

18) Serial Keys is an accessibility feature that assists people that have difficulty using a keyboard or a mouse (or both).

19)  The option in Microsoft Windows XP used for helping users with physical disabilities and to reduce repetitive strain is sticky keys .

20)   Sound Sentry is designed to help users with  auditory  impairments.

21)   The High Contrast option in Microsoft Windows XP is designed to assist people with vision  impairments.

22)   Serial Key  is designed to assist people that have difficulty using a keyboard or a mouse.

23)  special devices  such as Sip, Puff and Breath Switches to provide input to the computer through Serial Ports.

24) sticky keys  options allow us to press Ctrl key and ‘A’ key separately.

 


SESSION 2: NETWORKING FUNDAMENTALS

1)    A computer network is a collection of computers and other hardware components interconnected by communication channels (cables or satellites) that allow sharing of resources and information.

2)    Networks in which all computers have an equal status are called peer to peer networks.

3)    Networks in which certain computers have special dedicated tasks, providing services to other computers (in the network) are called client server networks.

4)    The computer(s) which provide services are called servers and the ones that use these services are called clients.

5)    There are two major types of network Local Area Network (LAN) and Wide Area Network (WAN).

6)    A local area network (LAN) is one which connects computers and devices in a limited geographical area such as home, school, computer laboratory, office building, or closely positioned group of buildings.

7)    Local Area Networks offer very high speeds and are used for connecting computers and peripherals such as printers, scanners, etc.

8)    A wide area network (WAN) is one which covers a broad area (i.e., any network that links across metropolitan, regional, or national boundaries)

9)    The Internet is a global system of interconnected computer networks that use the standard  Internet protocol suite to serve billions of users worldwide. It is a network of networks that consists of millions of private, public, academic, business, and government networks.

10)  World Wide Web (abbreviated as WWW or W3, commonly known as the Web), is a system of interlinked hypertext documents accessed via the Internet.

11)  A Web Browser is a software used to view Web sites and acts as an interface between the user and the World Wide Web.

12)  Advantages of networking are sharing data, can transfer files, share hardware, share interent access, usage of network based applications.

13)  Internet connections are provided by Internet Service Providers (ISP) such as Bharat Sanchar Nigam Limited (BSNL), Airtel, MTS, Vodafone, Tata Docomo, etc.

14) Á modem is a device that converts digital computer signals into a form (analog signals) that can travel over phone lines.

15)  Wi-Fi is a popular technology that allows an electronic device such as computers or mobile phones to exchange data wirelessly over a network, including high-speed Internet connections.

16)  Full form of WiMAX is Worldwide Interoperability for Microwave Access.

17) The acronym for LAN is Local Area Network .

18)  Three types of Wired Internet Connectivity are Dial-Up  , DSL & Cable Internet Access.

19)  Three types of Wireless Internet Connectivity are 3G , WiMAX & Wi-Fi.

 

 

SESSION 3: INTRODUCTION TO INSTANT MESSAGING

1)    Instant messaging (IM) is a form of communication over the Internet that offers an instantaneous transmission of text-based messages from sender to receiver.

2)    Most instant messaging software include the option for performing file transfers, audio chat, video calling and conferencing, sharing desktops, etc. apart from standard text chat.

3)    instant messaging software such as Yahoo! Messenger, Windows Live Messenger use email addresses for managing the account and software such as Skype use standard names.

4)    There are two kinds of instant messaging software – application based and Web based.

5)    Application based instant messaging software is downloaded and installed on user’s computer. Some of the popular instant messaging software are: Google Talk ,  Yahoo! Messenger ,  Skype ,  Windows Live Messenger ,  Rediff Bol, etc.

6)    Web based instant messaging software is accessed using browsers such as Internet Explorer, Mozilla Firefox, Google Chrome, etc.

7)     Computer, Internet  ,  Microphone and Web Camera are required for audio and video conferencing.

7)

 SESSION 4: CHATTING WITH A CONTACT – GOOGLE TALK

1)    Typing your messages in uppercase is extremely rude - it’s considered shouting and very aggressive.

 

 SESSION 5: CREATING AND PUBLISHING WEB PAGES – BLOG

1)       A blog is a discussion style site used by non-technical (or technical users) users for creating personal web pages. Blogs are similar to an online personal diary and simple to use.

2)       Blogs are usually managed using a web browser and this requires active internet connection.

 

 SESSION 6: USING OFFLINE BLOG EDITORS

1)    There are several free offline blog editors available that can be downloaded and installed on the local computer such as:  Qumana ,  Windows Live Writer ,  Blogdesk

 

SESSION 7: ONLINE TRANSACTIONS

1)       Online transactions have made transactions very convenient and simplified the workflow in many forms in a business.

2)       Online transactions deals with transfer of money over the internet. Revolution in the electronic media has made transaction handling easy.

3)       NEFT/ RTGS are some other examples of online funds transfer. Numerous benefits of online transactions like, fast transaction speed, convenience, low risk of theft etc has exponentially increased its use among people.

4)       Online shopping is a form of electronic commerce where customers can buy or sell goods over the Internet.

5)       COD  means Cash on delivery.

6)       Indian Railway Catering and Tourism Corporation (IRCTC) is an online portal that can be used for booking travel tickets.

SESSION 8: INTERNET SECURITY

1)    Internet security is a branch of computer security specifically related to the Internet, often involving browser security but also network security.

2)    The Internet represents an insecure channel for exchanging information leading to a high risk of intrusion or fraud, such as phishing.

3)    Online threats such as Phishing, email spoofing, chat spoofing, etc. can increase the chances of users getting compromised.

4)    You can reduce the risks by using best practices such as using Antivirus Software, Antispyware Software, Firewalls, strong passwords, etc. in addition to spreading awareness of the best Practices

5)    Use strong passwords, a combination of alphanumeric and special characters could be used for creating a password that is not so easy to crack or guessed by other users.

6)    Use encryption software: (Usually available within the operating system) to protect your data from unauthorized users. If encryption software is not available within the operating system, use a 3rd party software.

7)    Computers are prone to attacks from software known as Malware that could harm your computer. Malware track browsing behavior or transmit personal data from your computer; programs such as keyloggers could be installed on your computer track and transmit every key that is pressed on a keyboard (keystrokes) to unauthorized users.

8)    Firewalls could be software or hardware and can assist in keeping a computer and a network secure. Firewalls analyze the network traffic and determine if the traffic should be allowed or not.

 

 SESSION 9 : MAINTAIN WORKPLACE SAFETY

1)    Basic safety rules to follow at workplace – Fire safety, Falls and slips, Electrical safety, Use of first aid.

2)    Learning First Aid is the social and civic responsibility of very human being. If provided effectively and on time then it may save life.

3)    Every organization must have basic First Aid Kit. Kit must have all necessary items. Make sure to check for the expiry of medical related items.

 SESSION 10 : PREVENT ACCIDENTS AND EMERGENCIES

1)    Accident: an accident is an unplanned event that may happen all of a sudden and may lead to unwanted or unprecedented results/outcomes.

2)    Accidents may be of following types : - Accidents at workplace : Slips and fall accidents, fire , Industrial disease/illness , Road traffic accidents , Clinical Accidents , Sports related accidents.

3)    An emergency situation might pose a sudden risk to life, property health etc. and needs intervention to prevent deteriorating results/ hazards.

 SESSION 11 : PROTECT HEALTH AND SAFETY AT WORK

 1)    An organization can face some health hazards that could put the lives of the employees in danger. A hazard is anything that is the source of any potential harm, damage or any kind of potential loss of health or life

2)    Hazards can be of different types depending on the industry and the environment in which the employees work. The different types of hazards include: ● Physical ,● Chemical ,● Biological ,● Mechanical

3)    Evacuation is the process of emptying a place in case of an emergency, disaster.

4)    An organization can face some health hazards that could put the lives of the employees in danger.

5)     Hazards can be of different types depending on the industry  and the Environment  in which the employees work.

6)     Organization must have a designated emergency management  for emergencies

 

Thursday, 17 November 2022

U-3 DBMS/ Class 10th IT (402)

 Class – 10th

IT (402)

Book : Domestic Data Entry Operator

UNIT 3: DATABASE MANAGEMENT SYSTEM

Fill in the blanks

SESSION 1: APPRECIATE THE CONCEPT OF DATABASE MANAGEMENT

 SYSTEM

Fill in the blanks

1)    A database is an organized collection of data. You can visualize it as a container of information.

2)    Database programs such as Microsoft Access, OpenOffice.org Base, and MySQL Well known DBMSs include Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, PostgreSQL, MySQL, FoxPro, and SQLite.

3)    A DBMS (database management system) is a software package with computer programs that controls the creation, maintenance, and use of a database.

4)    Flat File means  Data is stored in a single table. Usually suitable for less amount of data.

5)    Relational means Data is stored in multiple tables and the tables are linked using a common field. Relational is suitable for medium to large amount of data.

6)    A database is an organized collection of data.

7)     A _Microsoft Access, / OpenOffice.org Base,/ MySQL _is a software package that can be used for creating and managing databases.

8)     A _Microsoft Access / OpenOffice.org Base is a database management system that is based on the relational model.

9)    Three popular DBMS software are Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, PostgreSQL, MySQL, FoxPro, and SQLite.

10)  A Primary Key (PK) is a unique value that identifies a row in a table.

11)  Composite Key is a combination of _one or more columns.

12) A foreign key is a column or a set of columns in one table that references the primary key columns in another table.

13) The database management systems contain multiple files that are to be stored in many different locations in a system or even across multiple systems. Because of this, there were sometimes multiple copies of the same file which lead to data redundancy.

14) Data integrity means that the data is accurate and consistent in the database. Data Integrity is very important as there are multiple databases in a DBMS. All of these databases contain data that is visible to multiple users. So it is necessary to ensure that the data is correct and consistent in all the databases and for all the users.

15) Data Security is an important concept in a database. Only authorised users should be allowed to access the database and their identity should be authenticated using a username and password. Unauthorised users should not be allowed to access the database under any circumstances as it violates the integrity constraints.

16) Data consistency is ensured in a database because there is no data redundancy. Data Consistency means there should be multiple mismatching copies of the same data. All data appears consistently across the database and must be same for all the users viewing the database. Moreover, any changes made to the database are immediately reflected to all the users and there is no data inconsistency.

17)  

SESSION 2: CREATE AND EDIT TABLES USING WIZARD AND SQL

 COMMANDS

Fill in the blanks:

1. A table is a set of data elements that is organized using a model of vertical columns(which are identified by their name) and horizontal rows.

2. A Column or Field or Attribute is a set of data values of a particular type, one for each row of the table.

3. A Row or Record or Tuple represents a single, data item in a table.

4. Datatypes are used to identify which type of data we are going to store in the database.

5. There are Two (1Create table in Design View , 2. Use Wizard to Create Table ) ways to create a table.

6. Field properties can be set in both the _design view_ and _datasheet view_ .

 

SESSION 3: PERFORM OPERATIONS ON TABLE

Fill in the blanks:

1. The types of languages used for creating and manipulating the data in the Database are __Data Definition Language. __ & _Data Manipulation Language .

2. A _Data Definition Language (DDL)  is a standard for commands that define the different structures in a database.

3. A data manipulation language (DML)  is a language that enables users to access and manipulate data in a database.

4. A query language is a part of DML involving information retrieval only.

5.A popular data manipulation language is Structured Query Language (SQL) .

6. Entity, attribute and relationships are the basic building blocks of a database.

7. There are three specific types of relationships that can exist between a pair of tables: one-to-one, one-to-many, and many-to-many. 

 

SESSION 4: RETRIEVE DATA USING QUERY

Fill in the blanks

1. A form helps the user to systematically store information in the database.

2. A form enables users to view, enter, and change data directly in database objects such as tables.

3. SELECT statement retrieves zero or more rows from one or more database tables or database views.

4. By default, data is arranged in ascending order. order using ORDER BY clause.

5. UPDATE statement is used for modifying records in a database.

6. DELETE statement is used to remove one or more records in a Database.

 

SESSION 5: CREATE FORMS AND REPORTS USING WIZARD

Fill in the blanks:

1. To create a form you need to select FORMS_ option available under Database section.

2. A QUERY is helps to collect specific information from the pool of data in the database.

3. data dashboard is used to display the display the summary of data.

4. Graphical user interfaces (GUIs) are the interfaces with which the user interacts.

5. Data from multiple tables can be stored in database. .

 


L-1 Indian Heroes in IT/ Class 6 Computer

 Class-6th  Subject : Computer Science L-1 Indian Heroes in IT Paste and label Indian Heroes in IT and write their inventions / contribution...