3rd Term Exams 2024-25
Subject Teacher: Ms Nosheen Fahad Subject: Computer
Grade: 7 Session: 2024-25
Exam Duration: 3 Hours Date: ______________
Instructions:
➢ Have everything ready that you need before starting the exam.
➢ Make sure you have your stationery and water bottle with you.
➢ Make sure you have good internet and working camera.
➢ Work neatly and carefully.
➢ Remember to leave a finger space between the words.
➢ While using a pen cross out any mistake with one neat line. Do not use whitener.
➢ Check each sentence/sum as you write.
➢ Recheck your answers at least three times after you are done with your exam.
➢ Once you are done take clear pictures of all the pages and make a Pdf file of your
work.
➢ Make sure the work is clear and readable in the Pdf before submission.
Best of Luck
Q. No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Total
Total
10 10 10 20 10 20 80
Marks
Marks
Obtained
1
Name: ________________________ Reg. No.: __________
Q.1 Fill in the blanks: (10marks)
1. To balance the audio volume levels, we use _____________________ to increase or lower the
volume of individual tracks.
2. __________________ format is good to use when you want to share your audio file.
3. _____________is the organized data.
4. In a data table the facts should be atomic means that you cannot ______________ the data into
smaller parts.
5. The ________________ stores a piece of information that is unique.
6. ___________________ data cannot be used in calculation.
7. The most important thing while sharing your audio file is _____________________.
8. The task of turning data into information is called _______________________.
9. Text data in computer is stored as __________________________.
10. List of items a business has in stock is often called the ___________________.
Q.2) Multiple choice questions: (10marks)
1.The effect that simulates the way sound waves reflect off many surfaces in a room.
a. Echo
b. Reverb
c. Pitch Shift
d. Fade in / Fade out
2. To write questions in our feedback form we use,
a. Show notes
b. Outline
c. Feedback form
d. Import Function
3. You add credit to the music or any other content you use in your pod cast,
a. To acknowledge the creative work
b. To show respect to intellectual property rights
c. To help build a culture of collaboration
d. All of the above
4. Stock check means,
a. Counting number of items in warehouse or stock room
b. Stock marked with bar codes
2
c. Products for sale
d. Value of stock
5. The number of items in stock to begin with is,
a. Closing stock
b. Stock in
c. Opening stock
d. Stock Value
6. Stock Value is calculated by,
a. adding opening stock and stock in and subtracting stock out from it
b. Multiplying cost of each item by closing stock
c. adding opening stock and stock out and subtracting stock in from it
d. multiplying cost with stock out
7. This is an accounting format for,
a. Percentage
b. Currency
c. increasing and decreasing decimal
d. Comma style
8. This option is used to,
a. Select all the data you have entered
b. Enter calculations
c. Convert data into Data table format
d. Choose currency format for your data
9. We use which tab from the figure below to improve the error message
a. Settings
b. Input message
c. Error Alert
d. Allow
10. Mixing stage is when
a. increase or lower the volume of individual track
b. change the volume level of each track so that the whole podcast sounds right
3
c. Add effects to some parts of the audio clip
d. Select most appropriate audio format
Q.3) True and False: (10marks)
1. The error message appears before applying the validation rule. (T/F)
2. WAV format use compression to make file size smaller. (T/F)
3. Number data in spread sheet is right aligned and text data is left aligned. (T/F)
4. The value “300g” is a number data. (T/F)
5. Scanning the bar code to find out items in inventory is quicker and more accurate. (T/F)
6. We can calculate the sum of all the values in a row by AutoSum button. (T/F)
7. Each fact is stored in one field of the data table. (T/F)
8. Return items will be recorded in stock out column. (T/F)
9. We can apply validation rule to only allow range of values. (T/F)
10. Key field is usually last field of the data table. (T/F)
Q.4)
Picture Based Questions: (20marks)
1.) In the table above, how “Date” field can be made atomic? Which field is the primary key of the
table? Which option we can use to arrange the supplier field in alphabetical order? (3)
2.) What does the AutoSum button do? AutoSum button can be used on what type of data? (2)
3.) The below formula is used to calculate what value? What is meant by closing stock? (2)
4.) Write three type of values that are not allowed, if we apply the validation criteria in the picture
below? (3)
4
5.) According to the validation criteria in the picture above, explain why the two values are circled in the
picture below? (2)
6.) How does error message help us?
(2)
7.) What validation rule is applied in the column of the following table? Which option can be used to
mark the invalid data? (2)
5
8.) Explain why negative and decimal
values are not allowed in the following columns of the data table?
(2)
9.) (2)
6
Q.5) Short Questions: (10marks)
Q1. What information is shown in the top row of a data table? What part of data table stores one
record? (2)
Q2. Data field should be atomic. Explain atomic data field? how we can make the field “Saver name”
atomic? (2)
Q3. What is meant by key field? What is another name of key field? (2)
Q4. Write any 2 advantages of organizing data in a table? (2)
Q5. What is meant by right aligned? Which data is right aligned in the data table? (2)
Q.6) Long Questions: (20marks)
Q1. What are the two types of validation? Briefly describe each type. (5)
Q2. When does the error message appear? What an error message must include? How we can improve
the error message? (5)
Q3. Explain what is the purpose of parameters in DAWs? Explain the following effects and its uses. (5)
1. Reverb 2.Echo 3.Pitch Shift 4. Fade in / Fadeout
Q4. After choosing a product to sell online, describe four steps you will follow to introduce your product
to the customer over the website? (5)
7
8
