Std. XII Experiment No. 12 – SOP2: Database Concepts using LibreOffice Base

📘 Experiment No. 11 – SOP1: Database Concepts using LibreOffice Base

In this blog, we will explore Experiment No. 12: SOP2 – Database Concepts using LibreOffice Base, exactly as prescribed in the Class XII Practical Journal.
A copy-paste ready journal section is also provided at the end for students.

---

---

✂️ COPY & PASTE THIS IN YOUR PRACTICAL JOURNAL

(Students can directly copy everything below into their journal.)

 

Experiment No. 12 

SOP2-Database concepts using LibreOffice Base

1. Steps to create database in LibreOffice Base:

1. Click on start button -> All Programs -> LibreOffice -> LibreOffice Base.

2. Click on the Finish button on the Database Wizard window.

3. Specify location and Database name on ‘Save As’ dialog box.

4. Click on Save Button.

2. Steps to create Employee Table :

1. Click on Tables in the Database section on the left side of the screen.

2. Click on ‘Create Table in Design view…’ in task section.

3. create following fields:

Field Name	Field Type
Empid	Text
Empname	Text
Empdept	Text
Empqual	Text
Empjoindate	Date
Empsal	Number

4. Right click and mark the empid field as Primary Key field.

5. Click on the file menu and select the save option.

6. Specify Table name as ‘Employee’ and click on Ok button on Save as Dialog box.

3. Steps to create Queries:

1. Click on Queries in the Database section on the left side of the screen.

2. Click on ‘Create Query in Design view…’ in task section.

3. Select your Table on ‘Add Table or Query’ Dialog box, click on add button and close it.

4. Double click on the fields you want in your query.

5. Specify given condition in ‘criterion’ under particular field column.

6. Click on the ‘Run Query’ option at the Toolbar.

Std XII - Experiment No. 11 – SOP1: Database Concepts using LibreOffice Base

📘 Experiment No. 11 – SOP1: Database Concepts using LibreOffice Base

A Complete Blog to Share with Class XII IT Students

In this blog, we will explore Experiment No. 11: SOP1 – Database Concepts using LibreOffice Base, exactly as prescribed in the Class XII Practical Journal.

A copy-paste ready journal section is also provided at the end for students.

---

---

✂️ COPY & PASTE THIS IN YOUR PRACTICAL JOURNAL

(Students can directly copy everything given below the box into your journal.)

Experiment No. 11

SOP1-Database concepts using LibreOffice Base

1. Steps to create database in LibreOffice Base:

1. Click on start button -> All Programs -> LibreOffice -> LibreOffice Base.

2. Click on the Finish button on the Database Wizard window.

3. Specify location and Database name on ‘Save As’ dialog box.

4. Click on Save Button.

2. Steps to create Student Table:

1. Click on Tables in the Database section on the left side of the screen.

2. Click on ‘Create Table in Design view…’ in task section.

3. create following fields:

Field Name	Field Type
Rollno	Text
Studname	Text
class	Text
div	Text
city	Text
dob	Date

4. Right click and mark the rollno field as Primary Key field.

5. Click on the file menu and select the save option.

6. Specify Table name as ‘Student’ and click on Ok button on Save as Dialog box.

3. Steps to create Form:

1. Click on Form in the Database section on the left side of the screen.

2. Click on ‘Use wizard to create form…’ in the task section.

3. Select your Table on ‘Form Wizard’ Dialog box, select all the fields and click on the next button.

4. click on the next button on the “set up a subform” tab.

5. select appropriate arrangement style for controls on form and click on next button.

6. click on the next button on the “set data entry” tab.

7. Select the appropriate style for form and click on the next button.

8. specify form name and click on Finish button.

Std. XI SOP 1: Use of Accounting package to create a company

 

📘 Experiment No. 11 SOP 1: Use of Accounting package to create a company

A Complete Guide for Class XI (Information Technology)

Computerized accounting has become an essential part of modern business operations. For Class XI IT students, mastering tools like Tally ERP and understanding GST concepts is a key practical skill.
In this blog, we will walk through Experiment No. 11 SOP 1: Use of Accounting package to create a company, as prescribed in your practical journal.

Below, you will also find a copy-paste ready section to write directly in your Practical Journal. Make sure you fill in any blank fields such as your name, roll number, and date before submission.

---

---

✂️ COPY & PASTE THIS IN YOUR PRACTICAL JOURNAL

(Everything given below can be directly written in your Journal)

Title: 

SOP 1: Use of Accounting package to create a company

1. Open Tally Prime

2. Click on “Continue in Educational Mode”.

3. Press the combination key ‘Ctrl+F3’ to invoke the ‘Shut Company’ screen.

4. Press Enter key to shut the existing open company.

5. From the ‘Select Company’ Screen choose the option ‘Create Company’.

6. On the company creation screen Enter Company Name and press Enter key.

7. Enter Mailing Name and press Enter key

8. Enter the address and press Enter key

9. Select the state from the list and press Enter key

10. Enter pin code and press Enter key

11. Enter details like telephone number, fax number, email address, mobile number and website and press Enter key.

12. Press enter key till the dialog box appears to accept click on the yes.

13. On the company Features screen set company features and click on yes to Accept the changes.

Std. XII Experiment No. 10 – SOP 3: Computerized Accounting with GST

 

📘 Experiment No. 10 – SOP 3: Computerized Accounting with GST

    In this blog, we will walk through Experiment No. 10 – SOP 3: Computerized Accounting with GST, as prescribed in your practical journal.

Below, you will also find a copy-paste ready section to write directly in your Practical Journal. Make sure you fill in any blank fields such as your name, roll number, and date before submission.

✂️ COPY & PASTE THIS IN YOUR PRACTICAL JOURNAL

(Everything mentioned below can be directly copy-pasted/write in your Journal)

Experiment No. 10

Title: SOP3 - Computerised Accounting with GST

Step 1: Steps to create Company

1. Select the “Create Company” option from the Company Info Menu.

2. Enter all the details in company creation form.

3. On company feature dialog box set Yes to “Enable Goods and Service Tax(GST)” and enter GST details also set Yes to “Set/Alter Company GST rate and other details”

4. Press Enter key to accept and create the company.

Step 2: Steps to create Ledgers

1. Gateway of Tally -> Masters -> Create -> Accounting Masters -> Ledger

2. In the Ledger creation form, enter all the details and select the appropriate Group for the ledger.

3. Press Enter key to accept and create the Ledger.

4. By using above steps create following ledgers

Sr. No.	Ledger	Group
1	Purchase	Purchase Accounts
2	M/s. Jalaram Textiles	Sundry Creditors
3	Input IGST	Duties & Taxes
4	Sales	Sales Accounts
5	M/s Dress Align Garments	Sundry Debtors
6	Output CGST	Duties & Taxes
7	Output SGST	Duties and Taxes

Step 3: Steps to create Unit of Measure

1. Gateway of Tally -> Masters -> Create -> Inventory Masters -> Unit

2. Enter details under the Unit creation form and create Pieces as a unit.

Step 4: Steps to Create Stock Group

1. Gateway of Tally -> Masters -> Create -> Inventory Masters -> Stock Group

2. Enter details under the Stock Item Creation form and create ‘Shirts’ as a Stock group.

Step 5: Steps to Create Stock Item

1. Gateway of Tally -> Masters -> Create -> Inventory Masters -> Stock Item

2. Enter details under the Stock Item Creation form and create ‘T Shirts’ as a Stock Item

Step 6: Steps for voucher entry

1. Gateway of Tally -> Transactions -> Vouchers

2. Select the appropriate voucher type from the button panel on the right handside.

3. Select appropriate ledgers under Db/Cr and enter correct values in vouchers.

4. By using above steps enter the given transactions in appropriate vouchers.

Step 7: Steps to display Reports

1. Sales Invoice

1. Gateway of Tally -> Display More Reports -> Day Book -> Sales

2. GSTR 2

1. Gateway of Tally -> Display More Reports -> Statutory -> GST Reports -> GST computation

Step 8: Steps to Print Reports

3. Sales Invoice

1. Gateway of Tally -> Display More Reports -> Day Book -> Sales -> Ctrl+p

4. GSTR 2

1. Gateway of Tally -> Display More Reports -> Statutory -> GST Reports -> GST computation -> Ctrl+p