L-5 Ms-Access / Class-8 Q-Ans

Class - VIII

Subject : computer Science 

  L-5 Ms-Access 

Book Exercise

A) Fill in the blanks

1.) Datasheet View allows you to view data stored in your tables.

2.) Datasheet View  is used to enter and view the data for the records.

3.) The primary key  is the unique identifies for each record in a table .

4.) The report is created in design  view.

5.) Data type determines what kind of data the field can store.

B) Answer the following questions:

1.) What is primary key? How to set a primary key?

Ans: A primary key is a unique identifier for a record in a database table.

To set a primary key:

1. Open the table in design view.
2. Select the field you want as the primary key.
3. Click on the "Primary Key" icon in the toolbar.

Alternatively, right-click on the field and select "Primary Key" from the context menu.

2.) What is a form in ms-access? Give details of different views information.

Ans: A form in MS Access is a user interface that allows for easier data entry, editing, and viewing of records in a database table.

Different Views:

1. Form View: Allows users to interact with and enter data into the form fields.

2. Design View: Lets you modify the structure, layout, and properties of the form.

3. Layout View: Offers a more visually-oriented way to modify form layout and design.

4. PivotTable View: Allows for data analysis in a table format with drag-and-drop functionality.

5. PivotChart View: Enables creation and modification of dynamic charts based on the form's data.

6. Datasheet View: Presents data in a spreadsheet-like format for easy viewing and editing.

These views provide different ways to work with and customize forms in MS Access.

3.) What is database? Name their major objects?

Ans: A database is a structured collection of data organized in a way that allows for efficient storage, retrieval, and manipulation.

Major Objects in a Database:

1. Tables: Store data in rows and columns, forming the foundation of a database.

2. Queries: Retrieve specific data from tables based on defined criteria.

3. Forms: Provide a user-friendly interface for data entry, editing, and viewing.

4. Reports: Present data in a formatted and printable layout for analysis or documentation.

5. Indexes: Improve the speed of data retrieval by creating efficient access paths.

6. Relationships: Define connections between tables to establish links between related data.

7. Forms: Provide a user-friendly interface for data entry, editing, and viewing.

8. Reports: Present data in a formatted and printable layout for analysis or documentation.

These objects work together to help organize, manage, and utilize data effectively within a database system.

4.) What is table?

Ans: A table is a structured collection of data organized into rows and columns. It is a fundamental object in a database where information is stored, representing entities such as customers, products, or orders. Each row in a table corresponds to a specific record, while each column represents a different attribute or field of the data.

5.) What are fields and fields data type?

Ans: Fields are individual columns within a database table that represent specific attributes or properties. They define the type of information that can be stored for each record.

Field Data Types specify the kind of data that a field can hold, such as text, numbers, dates, or binary data. Common data types include Text, Number, Date/Time, Boolean, and Memo.

Class-9 IT(402) /Book -Domestic Data Entry Operator /Fill-Up /Unit-1 Introduction to IT-ITes Industry

 

Class-9 IT(402) Book -Domestic Data Entry Operator

Unit-1 Introduction to IT-ITes Industry

Important Fill in the blanks 

Session-1

1. Information Technology (IT) means creating, managing, storing and exchanging information.
2. Full form of GIS is geographical information system.
3. Information Technology that enables the business by improving the quality of service is Information Technology enabled Services (ITeS).
4. ITeS is also called web-enabled services or remote services that cover the entire operations which exploit Information Technology for improving the efficiency of an organisation.
5. Examples of Information Technology Enabled services provide a wide range of career options that include opportunities in all offices like call centres, payrolls, logistics management, revenue claims processing, medical billing, coding, medical transcription, legal databases, back office operations, content development, GIS (geographical information system), web services and Human Resource (HR) services, etc.
6. Business Process Outsourcing (BPO) services means performing business operations through an outside service provider .
7. Some of the BPO services are as follows: (a) Financial and Accounting Services , (b) Taxation and Insurance Services, (c) E-Publishing and Web Promotion, (d) Legal Services and Content Writing, (e) Multimedia and Design Services, (f) Document Management Services, (g) Software Testing Services, (h) Health Care Services.
8. The IT BPM (Business Process Management) industry has been fueling India’s growth.
9. Multinational Companies (MNCs) have their headquarters outside India but operate in multiple locations worldwide including those in India.
10. Indian Service Providers (ISPs) started with their operations in India. Most of these organisations have their headquarters in India while having offices in many international locations.
11. Global In-house Centers (GIC) organisations cater to the needs of their parent company only and do not serve external clients.
12. A personal computer (PC) is used to work at home, to do household accounts, play games, surf the web, use  e-mail, create music, and pursue a range of other hobbies. PC is also used to play games.
13. Many libraries are  computerized. Each book has a barcode associated with it. This
14. makes it easier for the library to a keep track of books and the availability of a specific book.
15. A Learning Management System (LMS) is being used by many countries to manage school systems. A student or teacher can register himself/herself on the official website to access it and can get many services from it.
16. Computers are used in business organisations for payroll calculation, budgeting, sales analysis, financial forecasting, managing and maintaining stocks.
17. Scientists and engineers use computers for performing complex scientific calculations, Computer Aided Design (CAD) or Computer Aided Manufacturing (CAM) applications are used for drawing, designing and for simulating and testing the designs.
18. Bank customers use Automated Teller Machines (ATM) for cash deposits and withdrawal, or to view current balance.
19. Computerised Axial Tomography Machine (CAT): Using this machine three-dimensional (3D) images of different parts of the body can be made. These images are helpful in the diagnosis of diseases.
20. MRI (Magnetic Resonance Imaging Machine) machines are used to give the digital impression of internal organs of the body by using strong magnetic fields and radio waves.
21. Electrocardiogram (ECG) Machine  is used to monitor the heartbeat and records the electrical impulses and shows it in the form of a graph.
22. EEG (Electro ‑ encephalography) Machine is used to record the activities of the brain and display them on a computer screen.  

L-4 Photoshop 2 /Class-8 Computer

          Class-8^th
Subject – Computer Science
L-4 Photoshop 2

A)    Multiple Choice Question (Fill in the blanks )

1) Full form of PSD is _________________

a)     Photoshop Document

b)     Phone Document

c)     Parallel Data

d)     All of these

Ans: a) Photoshop Document

2) Vactor graphics is composed of  _________________

a)     Pixels

b)     Shapes

c)     Palette

d)     None of these

Ans: b) shapes

3) CMYK stands for   _________________

a)     Cyan, Magenta, Yellow, Key (Black)

b)     Cyan, Magenta, Yellow, Green

c)     Cyan, Magenta, Yellow, Blue

d)     None of these

Ans: a) Cyan, Magenta, Yellow, Key (Black)

4) The    ____________ PPI value, the better quality print you will get.

a)     Lowest

b)     Medium

c)     Highest

d)     100 PPI

Ans: c) Highest

5) Shortcut key to canvas size is    _________________

a)     Alt + Ctrl +D

b)     Alt + Ctrl +C

c)     Alt + Ctrl +G

d)     Alt + Ctrl +K

Ans: B) b)  Alt + Ctrl +C

 B)Multiple State “T” for True or “F” for False.

1)     You can not delete the layers once they have been created.    FALSE

2)     Control F is the shortcut for hiding / showing your rulers.        TRUE

3)     Every tool can be activated by a letter keystroke.                     TRUE

4)     A digital camera is a camera that store picture on film.            FALSE

5)     PNG stands for Public Network Graphics.                                 FALSE

C)    Guess My Name:

1)     It is made of Pixels.                              (  Bitmap / Vector graphics )

Ans: Bitmap

2)     Face recognition technology.               ( Smile detection / Red Eye correction )

Ans: Red Eye Correction

3)     Organized some photo.                        ( Collage / Brush tool)

Ans: Collage

4)     It moves images in different angles.    ( Rotating / Pen tool)

Ans: Rotating

D)    Long answer type questions:

1)     What do you mean by cropping? Explain.

Ans: Cropping: Cropping refers to the process of removing or trimming parts of an image to focus on a specific area. It involves selecting a portion of the image and discarding the rest, effectively resizing the image by removing unwanted content.

 

2)     How can you rotate an image? Explain.

Ans: Rotating an Image: To rotate an image, you can use software like an image editor. You select the image, choose a rotation option (usually found in the menu or toolbar), and specify the angle by which you want to rotate the image (e.g., 90 degrees clockwise). The software then adjusts the image accordingly.

 

3)     What is the difference between Bitmap and Vector graphics?

Ans: Bitmap vs. Vector Graphics: Bitmap graphics are composed of pixels and are resolution-dependent, meaning they can lose quality when resized. Vector graphics, on the other hand, are made of mathematical shapes defined by vectors and are resolution-independent, allowing them to be resized without losing quality. Bitmap graphics are suitable for detailed images and photographs, while vector graphics are great for logos, illustrations, and designs that require scalability without loss of quality.

U-2 Spreadsheet IT(402) Class 10th Pr

  Class -10th 

IT (402)

UNIT 2: ELECTRONIC SPREADSHEET (ADVANCED)

Practical Marks : 5

Download Open Office:

1) Analyse data using scenarios and goal seek.

• • Use consolidating data Create subtotals 
•  • Use “what if” scenarios Use “what if” tools 
•  • Use goal seek and solver 

2)  Link data and spreadsheets :

• • Setup multiple sheets by inserting new sheets. 
•  • Create reference to other sheets by using keyboard and mouse. 
•  • Create references to other documents by using keyboard and mouse. 
•  • Create, Edit and Remove hyperlinks to the sheet. 
•  • Link to external data. 
•  • Link to registered data source.

3)  Share and review a spreadsheet :

• • Set up a spreadsheet for sharing. 
•  • Open and save a shared spreadsheet. 
•  • Record changes. 
•  • Add, Edit and Format the comments. 
•  • Review changes – view, accept or reject changes. 
•  • Merge and compare sheets. 

4)  Create and Use Macros in spreadsheet  :

• • Demonstrate the use of a macro recorder. 
• • Create a simple macro. 
• • Use a macro 
•  • Access cells directly 
• • Using a macro. 
•  • Sort the columns using macro.