Failing to print the spreadsheet formula view on a single landscape page with row and column headings and gridlines visible.

Before printing, switch to formula view, set the page to landscape, turn on row and column headings and gridlines, and fit the sheet to one page.

Confusing Advertising, paid promotional messaging, with Sales Promotion, a short-term incentive or offer.

Keep the two terms separate: advertising is a paid message, sales promotion is a short-term incentive.

Omitting standard letter layout conventions, salutation, date, formal close, alignment, in mail merge tasks.

Build the letter to full formal format, date, salutation, body, complimentary close, before running the mail merge.

Giving purely generic advantages or disadvantages in the 8-mark extended questions, without grounding the argument in the named business scenario.

Name the specific business from the scenario in every point you make, not a generic business in the abstract.

Generating a database query that includes extra fields beyond what the question specifies.

Re-read the question and restrict the query output strictly to the named fields, nothing more.

Answering Unit 2 theory questions in generic terms rather than applying them to the named business in the scenario.

Name the business from the scenario and apply every point directly to its situation.

Treating absolute cell referencing, locking a cell such as column B row 15 so it does not shift, as optional when replicating a formula down a column.

Use an absolute reference for any cell that must stay fixed when a formula is copied down or across.

Writing an IF function's text output without quotation marks, for example =IF(E4>500000,YES,NO) instead of =IF(E4>500000,"YES","NO").

Put quotation marks around any text result inside an IF function, or the formula will not run correctly.

CCEA GCSE · เคล็ดลับการสอบ

Business and Communication Systems 8240 เคล็ดลับการสอบ

In Business and Communication Systems, correct work on screen is not the same as a correct printout. Here is where the 175 marks sit across both units, and the print and formula checks that quietly cost marks every series.

อ่าน 4 นาทีอัปเดตเมื่อ: 3 ก.ย. 2569

ภาพรวมข้อสอบ

จำนวนฉบับ

คะแนนเต็ม

175

เวลาสอบ

3ชม.

ประเภทคำถาม

ฉบับ	เวลา	คะแนน	จำนวนข้อ	น้ำหนักคะแนน	ประเภทคำถาม
Unit 1: Software Applications for Business	2ชม.	100	4	40%	Word processing / DTP poster design, Spreadsheets, formulae and mail merge, Database applications (queries, relationships, reports), Multimedia presentation authoring
Unit 2: The Business Environment	1ชม.	75	3	35%	Business ownership, communication and stakeholders (scenario 1), Recruitment, selection, training and digital trading (scenario 2), Legislation, market research and the marketing mix (scenario 3)

เกณฑ์เกรด

A*ABC*CDEFGU

ข้อกำหนดเครื่องคิดเลข

This is a non-calculator subject in the conventional sense. Unit 1 is completed on a school computer using word processing, spreadsheet, database and presentation software, and any arithmetic runs through spreadsheet formulae such as SUM, AVERAGE and IF, not a handheld calculator. No physical or electronic calculator is required or permitted in either unit.

AO1: AO1: recall, select and communicate knowledge and understanding of concepts, issues and terminology (25%)
AO2: AO2: apply skills, knowledge and understanding in a variety of contexts and in planning and carrying out investigations and tasks (50%)
AO3: AO3: analyse and evaluate products, make reasoned judgements and present appropriate conclusions (25%)

จัดทำจากข้อสอบเก่าและเกณฑ์การให้คะแนนจริง (2023–2025)

พร้อมทดสอบตัวเองหรือยัง?

เปลี่ยนบันทึกเหล่านี้เป็นข้อสอบจริง รับข้อสอบ AI ไม่จำกัด ตรวจให้ทันทีพร้อมคำอธิบาย

ฝึกทำหัวข้อนี้

ข้อผิดพลาดที่พบบ่อย

1highคะแนนที่เกี่ยวข้อง: 2Spreadsheets & Mail Merge (Unit 1, Task 2)
Failing to print the spreadsheet formula view on a single landscape page with row and column headings and gridlines visible.
วิธีหลีกเลี่ยง: Before printing, switch to formula view, set the page to landscape, turn on row and column headings and gridlines, and fit the sheet to one page.
2mediumคะแนนที่เกี่ยวข้อง: 1Marketing and the marketing mix
Confusing Advertising, paid promotional messaging, with Sales Promotion, a short-term incentive or offer.
วิธีหลีกเลี่ยง: Keep the two terms separate: advertising is a paid message, sales promotion is a short-term incentive.
3mediumคะแนนที่เกี่ยวข้อง: 2Mail merge (Unit 1, Task 2)
Omitting standard letter layout conventions, salutation, date, formal close, alignment, in mail merge tasks.
วิธีหลีกเลี่ยง: Build the letter to full formal format, date, salutation, body, complimentary close, before running the mail merge.
4highคะแนนที่เกี่ยวข้อง: 4Extended evaluation questions (Unit 2)
Giving purely generic advantages or disadvantages in the 8-mark extended questions, without grounding the argument in the named business scenario.
วิธีหลีกเลี่ยง: Name the specific business from the scenario in every point you make, not a generic business in the abstract.
5mediumคะแนนที่เกี่ยวข้อง: 2Database Applications (Unit 1, Task 3)
Generating a database query that includes extra fields beyond what the question specifies.
วิธีหลีกเลี่ยง: Re-read the question and restrict the query output strictly to the named fields, nothing more.
6highคะแนนที่เกี่ยวข้อง: 2Unit 2 scenario questions
Answering Unit 2 theory questions in generic terms rather than applying them to the named business in the scenario.
วิธีหลีกเลี่ยง: Name the business from the scenario and apply every point directly to its situation.
7mediumคะแนนที่เกี่ยวข้อง: 2Spreadsheet formulae
Treating absolute cell referencing, locking a cell such as column B row 15 so it does not shift, as optional when replicating a formula down a column.
วิธีหลีกเลี่ยง: Use an absolute reference for any cell that must stay fixed when a formula is copied down or across.
8mediumคะแนนที่เกี่ยวข้อง: 2Spreadsheet formulae
Writing an IF function's text output without quotation marks, for example =IF(E4>500000,YES,NO) instead of =IF(E4>500000,"YES","NO").
วิธีหลีกเลี่ยง: Put quotation marks around any text result inside an IF function, or the formula will not run correctly.

เปลี่ยนเคล็ดลับให้เป็นเกรดดีเยี่ยม

thinka เปลี่ยนจุดอ่อนของคุณเป็นแบบฝึกหัดที่ตรงจุด พร้อมตรวจทันทีและฟีดแบ็กแบบข้อสอบจริง เรียนอย่างชาญฉลาดขึ้น

เริ่มทำข้อสอบฟรี ดูราคา

ฝึกทำข้อสอบจริง พร้อม AI ตรวจคำตอบและให้ฟีดแบ็กทันที

เริ่มทำข้อสอบฟรี