IGCSE Information Technology Practical Test 2008

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the required action before sending a printout to the printer?

Print the document without proofreading

Turn in the printout immediately after completing it

Check that your Centre number and name are visible (correct)

Add handwritten information to the printout

What kind of function should be used to show the department name in the Department column?

A lookup function (correct)

A conditional function

A pivot table function

A statistical function

Which column is used as the lookup value for obtaining the department name?

Item number column

Description column

Department column

Dcode column (correct)

How should the lookup function reference the J8CODE.CSV file?

Using both absolute and relative referencing Signup and view all the answers

What document format is required to be loaded for the clerical tasks?

.CSV format Signup and view all the answers

How many items should the lookup function replicate to display department names?

Seven items Signup and view all the answers

What should be done at the end of the assignment with all printouts?

Place them in the Assessment Record Folder Signup and view all the answers

What should be hidden from view in the data during the interrogation process?

Column D Signup and view all the answers

What essential information must be printed in the header of the page?

Name, Centre number, and candidate number Signup and view all the answers

What should you do after completing each task during the assignment?

Tick the checklist to track progress Signup and view all the answers

What is the required title for the vertical bar chart?

Total Duration By Department Signup and view all the answers

Which Dcode values should be included in the data interrogation for calls made on 04/01/2008?

PU or SA Signup and view all the answers

When creating the vertical bar chart, what must be ensured about the category axis labels?

They are fully visible Signup and view all the answers

Which formula would correctly calculate the sum of the Duration column for entries coded as MD, given the Dcode column?

SUMIF(Dcode, 'MD', Duration) Signup and view all the answers

What should be the result of the IF function in the Units column if the Code is neither C, I, nor P?

The function returns zero Signup and view all the answers

If the Code 'I' appears in the Units column, what calculation must be performed?

Multiply the Duration by the value of the named cell Intl Signup and view all the answers

When formatting the Units column to no decimal places, which cell format option should be applied?

Rounding the cell values to the nearest integer Signup and view all the answers

Which command is necessary to ensure that cells A2, A3, and A4 are right aligned?

Format these cells using right alignment Signup and view all the answers

What formatting should be applied to rows 1, 6, and 15?

They should be centered and bold Signup and view all the answers

What is the correct page orientation to print the sheet showing the formulae and functions used?

Landscape Signup and view all the answers

Which method should be used to ensure that the printout of the data model shows all contents visible and maintains one page width?

Scale the sheet to fit on one page Signup and view all the answers

Study Notes

General Instructions

Ensure that Centre number, candidate number, and name are visible on all printouts.
Handwritten information in printouts will not be marked.
Follow step-by-step tasks as indicated; use the checklist for tracking progress.
Proofread all documents before printing.
Compile all printouts into the Assessment Record Folder.

Data Management Tasks

Load file J8PHONE.CSV using a suitable software package.
Use a lookup function to display department names in the Department column by referencing the Dcode column and J8CODE.CSV.
Enter data for Codes and Rates:
- C: 1.1 (Cheap)
- I: 3 (Intl)
- P: 1.6 (Peak)

Formatting

Format Rate cells to display one decimal place.
Right-align cells A2, A3, and A4.
Centre align and bold all cells in rows 1, 6, and 15.
Format the Units column to show no decimal places.

Functions and Calculations

Use a Countif function in cell C7 to count 'MD' entries in the Dcode column, excluding rows 1-13, and replicate from C8 to C13 for other departments.
Use a function in cell D7 to calculate the sum of Duration for 'MD', and replicates for other Dcodes in D8 to D13.
Implement an IF function in cell E16 to calculate Units based on Code values, with conditions for Codes C, I, P, and a result of zero for others.

Printing and Page Setup

Set page orientation to landscape for the first data model printout showing formulae.
Ensure all cell contents are visible on the printout, with a header including name and candidate details.
Change orientation to portrait for the values printout, following the same content visibility and header requirements.
Hide rows 1-14 and column D before interrogating data.

Data Interrogation

Identify and print items where the Code is 'I', ensuring necessary headers are included on the printout.
Find calls made on 04/01/2008 with Dcode 'PU' or 'SA' and print this filtered data with headers.

Chart Creation

Extract data for Department and Total Duration to create a vertical bar chart.
Title the chart as "Total Duration By Department" and ensure category axis labels are fully visible without a legend.
Save the chart in an importable format for presentation and print a copy with necessary headers.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

Prepare for the Cambridge IGCSE Information Technology with this practical test from May/June 2008. This quiz will cover key skills and concepts essential for success in the exam. Test your knowledge and readiness for the practical components of the course.