1st Mid Term Computer Project Work
First Term Computer Project Work
Take screenshot of following tasks which is given below and make a report and send it to PLKcomputerSIR@gmail.com by or Before 10th July 2024
A. Create a database "school". Create a table "student" with following fields(Design View).
Field Name | Data type |
---|---|
StudentID | Autonumber |
StudentName | Text |
Class | Number |
English | Number |
Nepali | Number |
Computer | Number |
- Make StudentID as primary key.
- Set Caption "Eng Mark" , "Nep Mark" and "Comp Mark".
- Set default value 10 for field class .
- Set the validation rule: >=0 AND <=100
- Set the validation text : Enter the marks between 0 to 100.
- Enter any five data in table "student".[Datasheet View]
- Display all records of table "student".
- Display all records in descending order of marks of Computer.
- Display all those records, where the mark in "English" are greater than or equal to 80.
- Display all those records where marks in all subjects are greater than or equal to 80.
- Display all those records where student name start with "A" or "S".
- Display all the records for those students whose marks in "Computer" are between 60 to 80.
- Display records by student ID.
- Delete the records of "abc" student.
- Update the marks of English by 10 to all students.
- Calculate total by adding marks of Eng, Nepali and Computer.
- Calculate Average by dividing total by 3.
- Make remarks if average marks is greater than or equal to 40 then "Pass" , otherwise "Fail".
D. Add two more records using Form crated above.
E. Make a report of table "student".
F. Make a report of query "q7 " created above.
Submit your project report by or before : 11th September
Instructions for Your Project: "Navigating the Digital Landscape: Ethical, Secure, and Technological Innovations in E-Commerce" Cover Page: - Include the following information: - Your Name - Your Class - Your Roll Number - Project Title: Navigating the Digital Landscape: Ethical, Secure, and Technological Innovations in E-Commerce Introduction: - Write a brief introduction (1-2 paragraphs): - Explain the importance of understanding ethical issues, security, and technology in the context of e-commerce. Chapters: Chapter 2: Ethical and Social Issues in ICT - Discuss ethical considerations in the use of ICT, such as privacy, data security, and the digital divide. Chapter 3: Computer Security - Explain key concepts in computer security, including the importance of protecting data and systems from cyber threats. Chapter 4: e-Commerce - Explore the role of technology in transforming traditional commerce into e-commerce, including the advantages and challenges. Chapter 5: Contemporary Technology - Discuss recent technological advancements and their implications for the future of e-commerce and society as a whole. Formatting: - Ensure your project is well-organized and easy to read: - Use neat handwriting or type the project. - Use headings and subheadings where necessary. Visuals: - Include diagrams where applicable: Conclusion: - Write a brief conclusion (1 paragraph): - Summarize the key points from each chapter and the importance of integrating ethical, secure, and technological practices in e-commerce. You can mail your report to plkcomputersir[at] gmail[dot]com