CSEC IT brochure by Macmillan Caribbean

Completely revised to cover the new syllabus!

Mapped directly to the content and order of the 2018 CSECÂŽ IT syllabus

Helps students attain the best possible grades in their examinations

Uses activity-based learning to develop transferable skills and workplace flexibility

Available Early 2020

csec IT bled.indd 1

Available as both print and eBook

9781380023322

30/08/2019 16:47

Overview

Information Technology for CSEC® Examinations, Third Edition is fully updated to the new syllabus and equips students with vital IT skills for the 21st century: • 100% alignment with the rationale, aims and objectives of the new syllabus • Excellent opportunities for active learning and assessment to ensure complete exam readiness • Industry-leading practice, alongside examples and activities reflecting the contemporary Caribbean and wider world, equips students for further education and fulfilling careers in IT-related fields

How is the book organised? The introduction explains the book’s content and hands-on approach

The book offers ten chapters grouped into three main sections to mirror the syllabus’s three examination profiles:

1 • Computer Fundamentals

Mobile network ▶

ITQ 3.1 Why might someone on the move want to join a computer network?

ACTIVITY

✔ ✔ ✔ ✔ ✔ ✔

ACTIVITY 3.2 Advantages and disadvantages of mobile networks

This activity is suitable for individual work or small groups.

• Write down all the computers, smartphones, laptops, tablets and games consoles

you have used or seen in the last week. Include devices that you have seen on TV or in films. • For each device in your list record what it was being used for. • Review your list with the other members of the group to create a combined list. • Share this list with the class by displaying it on the class noticeboard.

Wi-Fi ▶

ITQ 3.2 a) What is the main difference between a wired and a wireless network? b) Give ONE advantage of using a wireless network.

broader skills to master any website creation program. We would encourage you to experiment with and explore different website creation programs to widen your understanding of the concepts given in this chapter.

Local Area Networks Local area network ▶

Local Area Networks (LANs) are everywhere! A local area network (LAN) is a computer network that interconnects computers the end of this chapter ✔ Plan a website structure and organisation of pages. within a limited area such as a home,By school, laboratory or office building. you should be able to: ✔ nearby Chances are there is a government office or a private organisation Designthat and create simple pages. has a LAN in operation. The computer lab at your school may well have a local ✔ Insert hyperlinks into a web page. area network in operation. As a matter of fact, there may be more than one LAN ✔ Evaluate a website for content accuracy, user friendliness and effective display. in operation at your school.

Most modern computing devices have networking facilities built in. Desktop computers and laptops will usually have a network port into which a physical network cable can be plugged and a wireless network adapter allowing the computer to join a Wi-Fi network without a physical cable. Smartphones are able to connect to a mobile network and they also include a wireless Wi-Fi network adapter. Wi-Fi is a standard for wireless communication between computing devices. In a wired network computing devices communicate using physical wires. In a wireless network computing devices communicate using electromagnetic (radio) waves of different frequencies. Types of wireless communication are Bluetooth, Wi-Fi and mobile 2G (second generation), 3G, 4G, but more about them later. Most networks are a combination of wired and wireless. Networks range from a few computers connected together in an office to billions of computers connected together to create the Internet.

SeaMonkey Composer (seamonkey-project.org) and LibreOffice Writer (libreoffice. org) are website creation programs that are free to download, install and use. Wix and Weebly are two examples of free online Internet-based website creation tools. Concept map Planning a website hub

Figure 3.1 A four-computer local area network using a hub.

Creating web pages

Reasons for the website

Inserting content

Audience

Viewing in a web browser

Number and content of pages

172

1st proofs updated

Adding hyperlinks to web pages Link to another web page Link to place in web page Link to email address

Layout of The network within the head office of Carib Travel Services is a local area network. pages

Planning a website structure and organisation of pages The idea of a website was introduced in Chapter 3 ‘Computer networks and web technologies’. A website is a collection of web pages created by companies, organisations or individuals to share information. Web pages are stored in the cloud and are viewed using a web browser program on an Internet-connected device. Look back at Chapter 3 if you need to refresh your memory.

Testing a website

Suggest the primary purpose for which EACH of the following websites was created: (a) www.cxc.org (b) www.games.com (c) www.foxnews.com

ITQ 6.2 Suggest who the intended audience for EACH of the following websites is: (a) www.cxc.org (b) www.games.com (c) www.foxnews.com

Publishing a website

Testing for accuracy Testing for accuracy

Python program

Input kms covered

kmsCovered = 0 print ('A simple program to see if a vehicle service has to be perfo kmsCovered = input('Please give the kms the vehicle has covered if int(kmsCovered) >= 100000: print('YES vehicle needs a service') else: print('NO service needed on this vehicle')

Algorithm

Figure 6.1 The Pan Macmillan Science Fiction and Fantasy page is an example of a great user interface design.

ITQ 6.1

Processing If kms >= 100,000 service is yes else service is no

Output service

Flowchart

Write 'A simple program to see if a vehicle requires a service.' Write '‘Please give the kms covered since last service.' Get the kms covered If the kms is greater than or equal to 100000 then Write 'Yes service required' Else Write 'No service required' Pseudocode

Yes

• to educate and inform • to persuade • to sell goods and services • to collect feedback • to connect family and friends. The website created by Carib Travel Services is primarily used to provide information to passengers and potential clients for vehicle rentals.

Web hosting and domain names

Number >= 100000

Output Output ‘YES Service required’

Output Output ‘NO Service required’

Input values

Reason

Expected Result

34450

typical values

No service required

157082

typical values

Yes service required

extreme values

No service required

1000000

extreme values

Yes service required

two

invalid type

error

Table 10.9 Test data for testing the simple service test program.

PROGRAM servicetest; VAR kms : REAL; BEGIN WRITELN ('A simple program to see if a vehicle service is required'); WRITELN ('Please give the kms covered since last service '); READ (kms); WRITELN (kms); IF (kms >=100000) THEN BEGIN WRITELN ('YES Service required'’); END ELSE BEGIN WRITELN ('NO Service required on this vehicle'); END; WRITELN ('Press Enter to finish.'); READLN; END.

Web design is an art. As you surf the World Wide Web, take note of the wide variety of web page designs. Before we start there are some important matters you should consider if you are going to create an effective website. The first is: what is the main purpose of the website? Websites are created for lots of different reasons. Some reasons are: • to entertain

Test data: This is a simple program so test data will include a few ex values and a few examples of more extreme and unexpe values that do not meet this criteria the expected result w

Input ‘welcome’

BEGIN WRITE 'A simple program to see if a vehicle requires a service.' WRITE 'Please give the kms covered since last service.' READ the kms covered IF kms >= 100000 THEN WRITE 'Yes service required' ELSE WRITE 'No service required' ENDIF END Pascal program

Reasons for the website

User documentation: A Carib Travel Services (CTS) program. CTS needs to se covered since the last service equals or exceeds 100,000. if a service is required or not required. The input is the k service. Limitations: The input must be a number.

Begin

Output ‘welcome’

End

ACTIVITY 10.17 Input, compile, correct, run and test the service test

This activity is suitable for individual work or small groups. Input, compile, correct, run, test and document the service t

ACTIVITY 10.18 Demonstrating an IF-THEN simple decision

Copy the above program and modify it to read in a student’s t if the mark is greater than or equal to 50 and ‘fail’ if the mark

Scan this code for support material for different versions of common web design programs, or visit

Testing for accuracy

Link to user file

328

173

1st proofs updated

Start to understand the requirements of the syllabus. Consider what some familiar computing devices are being used for.

9• Problem-so 101

The Input-Process-Output (IPO) chart for the Service Test algorithm is:

The algorithm, pseudocode, flowchart, Pascal and Python program source code:

To help, we have prepared a wide range of practice activities that will help you A computer network may be classified based on its geographic span. Computer develop all the skills you will need. All the main word-processing packages, networks are designed to meet the data communication needs of individuals and including Microsoft Word and LibreOffice Writer, have features that allow you to organisations. A small network may connect computers in multiple rooms a web pages. The explanations given in this chapter should help you, create and in edit building; large networks may connect computers in different countries. The three whichever web page creation program you choose to use. It is not our intention types of network based on geographic span are discussed below. to limit your skills to one particular website creation program but to give you the

All these tasks are achieved by networking computers together.

Introductory Activity

An example of Information Technology in action that you will be familiar with is in your school. Students’ attendance, and examination and test scores, will be stored on a computer and processed so that questions such as ‘Which students passed the test?’ and ‘What is the attendance record of a particular student?’ can be answered quickly and easily. The answers are incorporated in the student’s term report to be viewed by parents or guardians. This is what Information Technology is all about: technology that manages information to make solving problems, answering questions and displaying results quicker and easier. In this book we will be looking at how to use Information Technology to help Caribbean citizens operate more effectively. Whether the task is to process the payroll in a factory, advertise new products on the World Wide Web, write letters to customers or keep supplier records up to date, Information Technology can help.

The ability to plan, design, create, publish and maintain an effective web page is a highly sought-after skill. There are many specialist website creation programs available but to master the basic concepts of website creation a word-processing

program is an ideal tool. To create an effective website you need to consider: the Distinguish between different reason for the website; the intended audience; and the number of pages and their layout and content. Your website will need text, images and hyperlinks. In this types of network: LANs, MANs chapter, we will help you to master website creation and to use the available features to create great-looking websites. and WANs You will need to spend a considerable amount of time practising at the computer.

ACTIVITY 3.1 Uses of a network in your company In small groups use the company you created in the Introduction or use St. Luago Fashion. • Discuss how the employees and management in your company will need to communicate and share data and resources. • Select three employees and create a short report outlining the tasks these employees will be able to achieve using the company network. • Display your report on the classroom noticeboard for the rest of the class.

See pages 8-9 of this brochure!

• Program implementation 9 • Computer 1 10 Problem-solving Fundamentals and program design

6 • Mastering web page design

Mastering web page design

This activity is suitable for individual work or small groups. 1. List the names of mobile network providers in your territory. 2. Discuss the advantages and disadvantages of a mobile network when compared with a traditional wire-based telephone system. You may start by considering coverage, cost and availability of alternatives. 3. Elect one member of the group to present a summary of your findings to the rest of the class.

A computer network is a group of computing devices that are connected together so that they can share data and resources. A mobile network is a network of communication and computing devices where the last link is over a mobile phone network. Originally developed for mobile phone systems, mobile networks now carry data as well as voice communication. Persons on the move with smartphones can now join a computer network. Computer networks are needed because organisations want to communicate with others and share data files and other resources. At Carib Travel Services (CTS) some of the newer buses are fitted with Wi-Fi, accessed using a mobile network, allowing passengers to access the Internet when travelling on the bus. Employees of CTS want to be able to communicate with each other using email. All the computers in CTS head office need to access the company printer and so need to be connected together.

Information Technology is the use of technology to process data into useful information. You will already be familiar with some of the technologies because you will already have used or seen computers, smartphones, laptops, tablets and games consoles in action.

In the following pages we are going to cover all you need to know to achieve a great grade in the Caribbean Examinations Council (CXC) Information Technology (IT) Examination. In this new 3rd edition, we comprehensively cover the Information Technology Syllabus CXC 30/G/SYLL 17 effective for examinations from May to June 2020. We want to help you gain a full understanding of all the topics included in the syllabus. To make this easy we have structured the book to follow the syllabus closely. We will be using lots of examples that you will be able to relate to and we will support your learning by suggesting activities throughout the text. As you progress through a topic there will be In-Text Questions (ITQs) that you can use to check your understanding and at the end of each chapter we will provide examination-style multiple choice questions and structured questions. The activities that are included in the text are designed to encourage you to apply what you have learnt to your own situation. You can complete some of the activities on your own but many of the activities involve working with classmates in a collaborative way. Look out for group activity icon and the individual activity icon <insert group & individual icons in margin>. If you complete all the activities you will have all the skills you will need for a great School Based Assessment (SBA). We recommend that you start a notebook to record everything in one place. The SBA requires you to apply the knowledge, skills and aptitudes you have learnt in a practical way

This introduction will help you to:

Computer network ▶

Introduction to Information Technology for students in the Caribbean

Welcome to Information Technology for CSEC Examinations 3rd Edition

3 • Computer networks and web technologies

Introduction to computer Information processing networks

1 • Computer Fundamentals Introduction

Introduction to Information Technology

13 1• •Computer ComputerFundamentals Fundamentals networks and web technologies

What is covered in this book

Start to understand the term ‘Information Technology’. Learn about what is included in this book.

On completion of this course of study in IT, as well as getting a great examination result, you will have developed an understanding of important IT concepts and practical, hands-on, IT skills. These are listed in the table below.

Understand that the syllabus requires the mastering of both theory and practical skills. Start to develop an idea for your own Caribbean company.

Important IT Knowledge

Essential IT Skills

Theory (Chapters 1-4)

Productivity Tools (Chapters 5-8)

Problem-Solving and Programming (Chapters 9-10)

Section 1: Theory gives students a strong grounding in the theory behind information technology, covering computer fundamentals, information processing, computer networks and web technologies, and the social and economic impact of IT.

Section 2: Productivity Tools is fully revised – new screenshots, updated steps, better sequencing of activities – using Microsoft Office. The exercises, activities and assessment items have all been refreshed to ensure that they are current, relevant and more engaging than ever before.

Section 3 of the book covers problem-solving and programming, taught and practised in a way that encourages transferable skills, and that does not limit you to one programme or computer language. This new edition introduces Python and offers parallel examples of Python and Pascal.

• Develop an understanding of the fundamental hardware and software components and the interrelationships among them • Develop expertise in evaluating computer systems • Develop an understanding of basic information-processing principles and basic networking concepts, including mobile networks and Internet and web technology concepts

viii

1st proofs updated

Full-length specimen papers 01 & 02 provide valuable exam practice

• Maintain safe and secure computing environments • Develop computer-generated documents using a range of tools such as word-processors, spreadsheets, databases and web design software • Apply a structured approach to solving problems • Translate algorithms into high-level programs

A Glossary and an Index enable easy reference

GLOSSARY Acceptance Acceptance occurs when someone (the offeree) agrees to the offer in a contract (from the offeror), thereby committing to the contract. Acquisition One company buys enough shares in the ownership of another, so that it can take overall control. Advertising The use of marketing communications used to promote or sell goods and services to consumers. Airway bill A transport document that accompanies goods shipped by an international courier using air transportation to provide detailed information about the shipment and allows it to be tracked. Assurance This allows your risk of loss from known events (such as a car accident) to be transferred from one party to another in exchange for a payment (premium). Autocratic leadership A management style which involves a manager taking all the decisions with little involvement or input from employees. Automated teller machine (ATM) This is an electronic machine that enables customers to carry out simple transactions without needing to speak to a bank employee (or teller) face-to-face. Average clause A principle of insurance which protects against under-insurance of an asset. If the value of a property at the time of loss or damage is less than its real value, payment by the insurance company will be reduced to a proportion representing the insured value to the actual value of the asset. Average revenue This is the revenue per worker over a given period of time (total revenue divided by total employees). Balance sheet A statement of financial position or balance sheet record total assets (items of value), total liabilities (debts, loans) and owner’s capital or equity in the business (money invested by owners or shareholders) at the end of each trading period. Bank for International Settlements Promotes monetary and financial stability across the globe and has been called ‘the central bank of the central banks’. Basel Committee for Banking Supervision Based in Basel, Switzerland and responsible for banking regulations (e.g. provide recommendations on how much liquidity banks are required to hold). Barter The exchange of goods and services without the use of money. Bill of Lading A transport document used to record the type, quantity and destination of goods being moved or shipped using sea transportation. Bonds These are like IOUs issued by governments or companies (e.g. government wants to borrow money for new schools or hospitals, it sells bonds to investors). The bonds will have an end date when the government or company will repay the original cost of the bond to the investor. Corporate bonds are issued by companies. Debentures are issued by larger companies or governments to borrow money. Bookkeeping Records business transactions. Single entry bookkeeping is a simple record of income and expenses using a manual cash book, journal or a spreadsheet. Double-entry bookkeeping records every transaction twice, as a credit to one business ledger account and a corresponding debit to another. Brand awareness Ways to increase the way customers can identify of a product, so it is not confused with competitors’ products. Brand image Special features of a product and the values it stands for put on the packaging and advertising. Brand loyalty The extent to which customers become loyal to a product and are repeat purchasers of it. Branding The process involved in creating the name, term, design or symbol that a business uses to distinguish itself or its products from competitors.

406

Breach Failure to carry out or fulfil contractual obligations. Budget A financial plan for the future covering incomes and expenditures that is used to control costs in a business. There are three possible outcomes: total annual income is equal to total annual (the budget balances); annual income exceeds expenditure (budget surplus); or annual income is less than expenditure (budget deficit). Building Society A financial institution which specialises in providing long term loans called mortgages for the purchase of properties. It is mutual society owned by its members. Business banking Bank services provided to business customers. Bureau of standards Government agency which serves to protect standards for consumers and businesses. Business (activities) Organising the production and distribution of goods and services in order to satisfy the needs and wants of consumers. Business plan A document that describes a new business idea and its objectives as well as its products and how and where it intends to make them, finance their production, promote them and earn revenue from them. Business stakeholders People and organisations with an interest how well or badly a business performs. They include consumers, employees, suppliers, trade unions, suppliers, environmental lobby groups and government authorities. Business technology The application of science, data, engineering and information for business purposes, such as the achievement of economic and organisational goals. CAD Computer Aided Design: is software that can create and modifying designs of products on a computer. Two-dimensional (2D) and three-dimensional (3D) designs are possible. CAM Computer Aided Manufacturing: uses technology to automate the manufacturing process. CAD and CAM are related: CAD produces product designs; CAM manufactures products Capacity An individual has capacity to enter into a contract if they have sufficient understanding of the agreement and its possible consequences. Capital (factor of production) Human-made resources or capital goods including machinery, tools and other equipment used in the production of other goods and services. Capital (financial) Money used to fund business operations (see ‘fixed capital’ and ‘working capital’). ‘Sourcing capital is finding and acquiring funding for business or government. Capital gains tax A tax on profits from valuable assets that have increased in value (e.g. shares, antiques, jewellery). Capital goods These are human-made resources that have been bought (e.g. machines, tools, vehicles, computers, buildings). Capital intensive A method of production or production process that employs significantly more machinery and other capital equipment than labour. Capital transfer tax When the ownership (e.g. shares or property) is transferred from one person to another. Career A specialised area of work you develop overtime after years of experience. CAIR The Caribbean Association of Insurance Regulators (CAIR) develops and enforces insurance regulation, according to international standards. CARICOM The Caribbean Community, a supranational organisation bringing together 15 different Caribbean countries to promote economic co-operation.

Cash flow Transfers of cash in and out of a business over time. Net cash flow is the difference between cash flowing into a business and cash flowing out each month. CDB Caribbean Development Bank: aids in economic growth and development and to promotes economic cooperation, with special emphasis on less developed countries. Cellular communications Mobile phone service, e.g. SMS (short message service), MMS (multimedia messaging service) and Mobile apps. Central bank A non-profit-making public-sector institution established by the government of a particular nation or group or nations to control, facilitate and regulate the financial sector to create conditions which encourage economic growth. Chain of command The line or flow of authority within an organisation. Cheque services Customers can be given a chequebook to write cheques to make payments for goods and services received. Cheque clearance is where the customer’s cheque from one bank is paid into the account of the receiver; who may well have an account with another bank. Clearing When banks transfer funds between each other for their customers, helping them to make and receive payments quickly and securely. Close substitutes Different products that both satisfy the same consumer want (e.g. butter and margarine). Collateral Something of value, such as property, machinery or financial assets, that can be used when a loan is being applied for. If the loan is not repaid, the lender takes ownership of the collateral and can sell it to recover their loss. Collective bargaining The process whereby trade union representatives engage in negotiations with employers on behalf of the employees whom they represent, with the aim of reaching an agreement as it relates to improvements in the general working conditions of employees. Chain of command This is the flow of authority within a business. Command A system where the majority of the resources are owned, planned and controlled by the state through a planning authority. Everyone cooperates for the good of society. Commercial banks Financial intermediaries, often referred to as ‘high street banks’, that offer retail and business banking services to their customers including accepting deposits, providing checking accounts and offering loans. Company This is a separate legal entity that is owned by a group of persons, or other companies, who have purchased shares in the business. Conglomerate When two or more companies involved in unrelated activities and industries integrate to form a company, it is called a conglomerate. Consideration This is the term given to what is being done/given (or not being done) as a benefit/ item of exchange in the contract. Generally, consideration takes the form of goods, services or money. Consumer An individual or organisation that is willing and able to buy a good or services to satisfy a need or want. Consumer behaviour How consumers make decisions about buying: what, when, how much, how frequently and who they buy from. Consumer price index (CPI) Shows by how much the average price of the basket of goods and services has changed over time and how quickly. Consumer protection agencies The rights of consumers are recognised through consumer protection agencies which are supported by various laws and acts.

The final chapter offers guidelines for the School-Based Assessment (SBA) and a specimen SBA project and mark scheme

9 ••Computer 1 11 Problem-solving Specimen Fundamentals SBA and program design

Specimen SBA

SUBMISSION CHECK LIST Word-processing 1)

At least four formatting features. Two from: bold, italics, underline, justification (centre, right, line spacing, superscript and/or subscript, font style, font size and page numbering.

Page layout. Changes in page orientation, paper size or text orientation. Use of header footnotes or endnotes.

Any two from: a. Including a graphic or chart resized and positioned on page. b. Text in multiple columns. c. Table formatted with borders, shading of cells and colour.

Possibility High School 4)

Empowering and enabling students to attain new heights

CSEC® Information Technology (General Proficiency) Paper 031 – School-Based Assessment (SBA) Weighting of Paper: 25%

Any two from: a. Auto-generated table of contents with two levels of headings. (5 marks) b. Mail merge with: data source, primary document, inserted fields and merged docu c. Fillable form with at least three of: option box, check box, text box, date picker, drop-down list and command button. (5 marks)

Web design 1)

CARIBBEAN FOOD& DRINK FESTIVAL 2020 EVENT MASTER PLAN

Web page with balance of text and graphics.

Suitable layout and content for intended audience.

Content consistent with requirements.

Any two hyperlinks to: another web page, location within the web page, an email or an on

Spreadsheets

Background Food festivals are popular attractions in many countries worldwide. Food in the . Caribbean is influenced by many other cultures; this makes the Caribbean an increasingly popular destination for any foodie or food travel lover. Over the past decade, many international travellers have planned their vacations to coincide with at least one major food festival. Some of the festivals where ‘foodies’ have enjoyed the cuisine of the region include the Caribbean Food and Wine Festival (Providenciales), Barbados Food and Wine and Rum Festival (Barbados), Cayman Cookout (Cayman Islands) and Saborea Puerto Rico: A Culinary Extravaganza (Puerto Rico). These food and drink festivals have afforded travellers the opportunity to taste some of the local dishes, as well as versions of international dishes of the Caribbean. A major challenge however is the absence of proper coordination among the various territories, resulting in travellers being unable to island hop and experience multiple food festivals during their Caribbean trip.

Correct use of three different functions. Correct use of three different formulae.

Use of relative addressing and absolute addressing.

Formatting any two from: decimal place, currency, comma or percentage.

Justified left, right, centre; font style or font size.

Merged cells or wrap text.

7) 8) 9)

Data sorted. Simple filter showing criteria. Pivot table.

10) Charts showing labels: chart title, data labels, chart axis. 11) Linking of cells in different worksheets. Database

Description of the Project A group of tourism interests in 10 Caribbean islands—Anguilla, Barbados, Barbuda, Bequia, Nevis, Puerto Rico, St. Maarten, Turks and Caicos, Tortola, and Tobago—has collaborated to plan for the staging of the inaugural Caribbean Food and Drink Festival from October 10 to November 26, 2025. You are required to utilize suitable word-processing, web design, spreadsheet, database management as well as programming tools to design and implement computer-based solutions to the tasks involved in the event-planning process.

Create and populate at least two database tables with appropriate fieldnames, types and

Show joined (related) tables.

Simple query on one table.

Complex query on more than one table.

Query with at least one calculated field.

Appropriate form with sub-form.

7) 8)

Evidence of sort. Report showing: title, grouping, summary information and selected fields.

Programming 1) 2) 3)

| GLOSSARY

348

1) 2)

1st proofs updated

Pseudocode or flowchart using: start/end, user-friendly variable names, initialised variab Pseudocode or flowchart using: prompt for data, input, loops and decisions. Trace table: identifying variables, appropriate test data, and values changing.

Working program.

Program: initialises variables, uses loops and decisions.

Program documentation.

How are the chapters organised? Each chapter opens with an overview to orientate students within the topic

Each chapter finishes with a handy summary of all the vital issues and themes of the chapter

Each chapter closes with multiplechoice questions and structured questions

csec IT bled.indd 2

30/08/2019 16:48

Table of Contents Contents About this book Introduction to Information Technology Part 1: Theory Chapter 1 – Computer fundamentals

The concept of information technology Major types of computer systems The major hardware components of a computer system The interrelationship of major hardware components of a computer system Evaluating the relative merits of cloud storage and local storage Selecting appropriate input and output devices The role of the different types of software Different types of user interface Evaluating the suitability of a computer system Troubleshooting basic hardware problems

Chapter 2 – Information processing

Information and data Evaluating the reliability of information obtained from online sources File Organization Choosing an appropriate file access method

Chapter 3 – Computer networks and web technologies

Introduction to computer networks Distinguish between different types of network: LANs, MANs and WANs The functions of the basic components of a network The importance of mobile communications technology Key web technology concepts

Chapter 4 – Social and economic impact of information and communication technology Intro to the concepts of computer security, cyber security and computer misuse Assess the potential impact of computer misuse on the main entities impacted Countermeasures to mitigate effects of identified threats Assess the effects of automation on job security Describe the roles of various personnel in computer-related professions Assess the impact of information and communications technology on select fields

Part 2: Productivity Tools Chapter 5 – Mastering word processing

Create documents using content from a variety of sources Using appropriate document formatting features Using appropriate editing features to structure and organize a document Using review features to enhance document readiness Appropriately use features that allow protection of a document Generating a table of contents for a document Using mail merge features in a range of situations Creating a fillable electronic form for online use

Chapter 7 – Mastering spreadsheets

The purpose of spreadsheets Using appropriate terminologies associated with spreadsheets Using basic pre-defined functions Creating advanced arithmetic formulae Replicating (copying) formulae to other cells Manipulating rows and columns: insert, delete and modify Manipulating data in a spreadsheet Perform charting operations Manipulating one or more worksheets

Chapter 8 – Mastering databases

The concept of a database Terminology commonly associated with a database Creating a database Modifying the table structure Manipulating data in a database

Part 3: Problem-Solving and Programming Chapter 9 – Problem-solving and program design

Outline steps in problem-solving Using divide-and-conquer approach to decompose large everyday problems into smaller tasks Defining a problem by decomposing it into its significant components Distinguishing between variables and constants The concept of an algorithm Representing algorithms in the form of pseudocode and flowcharts Testing algorithms for correctness

Chapter - 10 - Program implementation

Distinguishing between low-level and high level languages Performing checks and tests on programs to verify correctness Declaring variables and constants using basic data types Translating algorithmic statements into high-level language syntax Documenting programs effectively

Chapter 11 - SBA Guidelines and Specimen SBA project Appendix A: Specimen Paper 01 Appendix B: Specimen Paper 02 Glossary Index

Chapter 6 - Mastering web page design

Planning a website structure and organization of pages Designing and creating simple pages Inserting hyperlink into a web page Testing and evaluating a website for accuracy, user friendliness and effective display

Free Online Teaching Resources Free online teaching resources for this course will be available to download via www.macmillan-caribbean.com • Exam practice • Python and Pascal summary sheets • Specimen solutions to activities and exam questions

Free Online Resources for Students Free resources for students to download online via www.macmillan-caribbean.com

Stay up-to-date with Workshops and Webinars! Register your interest: Email caribbean@macmillaneducation.com with the subject line: CSEC IT Stay tuned by following our facebook page

csec IT bled.indd 3

Macmillan Education Caribbean are proud to have worked on this book with authors and advisors from across the Caribbean.

Author team:

Advisors:

Howard Campbell is an experienced educational consultant, software developer and author with over twenty years’ experience in the fields of information systems and education.

Camille Bruno-Audainm - Teacher, St Kitts & Nevis

Dr Alan Wood is a freelance IT consultant with extensive experience in programming and software development (aircraft simulators), systems administration (Space Science Department at the Rutherford Appleton Laboratory). He has also worked as a teacher and teacher trainer in Africa and Guyana.

Keith Burkette - Teacher, St Mary’s College, Trinidad and Tobago Desrie Elwin - ICT Head Teacher, St. Mary’s Academy, Dominica Andrew Samuels - Managing Partner, IT School Initiative, Jamaica Nnaemeke Vesprey - Teacher, Presentation Brothers College, Grenada

Student reviewer: Jesse James - Student, St Vincent Girls High School, St Vincent

Scan the QR code or visit www.macmillan-caribbean.com/pages/ sample_pages_CSECIT to see sample pages from this book!

30/08/2019 16:48

Key features: Chapter Openers

Unit concepts at the beginning of each chapter give a clear and simple explanation of the chapter content, orientating and anchoring students within the topic.

Syllabus Objectives are provided at the beginning of each chapter, mapped directly to the content and order of the syllabus. These main objectives are reflected in the top heading level on the following pages of the chapter for teachers and students alike to easily follow and identify.

A mind map at the beginning of each chapter shows how the chapter content is mapped to the curriculum for ease of teaching.

csec IT bled.indd 4

30/08/2019 16:48

Key features: Worked Examples

Worked Examples throughout the book enable teachers to easily check student understanding.

181

csec IT bled.indd 5

30/08/2019 16:48

Key features: Inside each unit

All content is mapped directly to the 2018 syllabus from CXCÂŽ. Clear top-level headers reflect the main objectives and make it easy for teachers to break down content. The text of the chapter reflects current thinking, technology and IT industry knowledge and is presented in a way that is clear and easy to understand.

Definitions for key terms from the syllabus are indicated clearly in the text and defined on the first use. These important terms are also listed in the glossary at the end of the book.

ITQ In-text questions (ITQs) provide formative assessment - to check studentsâ&#x20AC;&#x2122; understanding throughout the text. Answers are provided at the end of each chapter.

csec IT bled.indd 6

30/08/2019 16:48

In the introduction, students are asked to get into small groups and set up their own imaginary company. Throughout the course, there are guided activities relating to this company which, with the Caribbean Travel Services examples, build the skills required for the SBA and give further real-life context to student decisions.

Individual and group activities offer active learning opportunities throughout.

Diagrams, illustrations and photographs enhance learning and understanding throughout the book.

Caribbean Travel Services provides real-life context and worked examples of a fictional Caribbean company. Students develop their skills and understanding via this engaging concept and thus build a strong foundation for their SBA.

csec IT bled.indd 7

30/08/2019 16:48

EXTENSION ACTIVITY 10.15 Demonstrating an IF-THEN simple decision Copy the above program and modify it to read in a student’s test mark and display ‘pass’ if the mark is greater than or equal to 50.

Key features: Program Implementation

ACTIVITY 10.16 Convert algorithm to source code; input, compile, correct, run and test a program

Use the company you created in earlier activities or use the St. Luago Fashion company. The Board of your company has decided to update underperforming branches. In an earlier activity (Activity 9.5) you created an algorithm to input the annual profit of a branch. If the profit is less than or equal to 50,000, then the output is ‘Update’. • Convert the algorithm to pseudocode or a flowchart. • Convert the pseudocode or flowchart into a high-level language of your choice. • Input, compile, correct, run, test and document this program.

Syntax for conditional branching: IF-THENELSE decisions Demonstrating an IF-THEN-ELSE decision for deciding which of two blocks of instructions to execute. We can pose a variation of the problem above which results in a more useful version. In this version, users receive a clear ‘yes’ or ‘no’ answer.

At Caribbean Travel Services vehicles need to be serviced once they reach 100,000 kms since the last service. Consider designing a solution to the problem; read in the vehicle’s kilometres covered since the last service and decide if a service is needed or if it is not needed. The problem is to decide whether a vehicle needs a service or not.

327

Each new skill learnt from programming starts with a task for the Caribbean Travel Services company. This puts the programming skills and activities in a recognisable context and shows students how these skills will be beneficial to a future career in IT.

Input-Process-Output (IPO) charts clearly set out the expectations for the process of the programming.

csec IT bled.indd 8

30/08/2019 16:48

Support for programming languages Section 3 of the book covers problem-solving and programming, taking students through the process of programming step-by-step. This new edition introduces Python, an industry-leading programming language. Feedback from teachers supports the need for this new and exciting language which is widely used by businesses and by major technology brands, making it a popular language for the modern world. The new edition retains Pascal and offers parallel examples of both which will also support teachers wanting to make the transition from Pascal to Python.

A CTS â&#x20AC;&#x2DC;problemâ&#x20AC;&#x2122; in need of a programming solution serves as an example and gives a complete overview of the whole process of program development: the problem definition, IPO chart, algorithm, pseudocode, flowchart, Pascal and Python source code, user documentation and test data are provided to enable students to understand the entire process. This is ideal for classwork.

CTS Example for Programming Practice

After every overview of the programming skill students practise their new programming skill using the CTS example provided.

Extension activity

An extension activity follows, providing a new problem that students need to translate into program code. Students should complete each activity before moving on as this will help to ensure that they understand how to write source code in their chosen programming language.

Programming Task for the Student Company

The extension activity is followed by a programming task for their student company, which they set up at the beginning of the course. 9

csec IT bled.indd 9

30/08/2019 16:48

Information Technology for CSEC® Examinations Designed to develop IT skills and knowledge relevant to the Caribbean and wider world in the 21st Century, IT for CSEC® Examinations 3rd edition focuses on helping students attain the best possible grade in their examinations while ensuring they are well equipped for further education and fulfilling careers in IT-related fields.

Syllabus match Chapters Chaptersgrouped groupedinto into33clear clearsections sectionstoto mirror mirror the the33examination examinationprofiles. profiles.ToToaid aid teaching, closelymapped mappedtoto teaching each chapter chapter isclosely the the order orderof ofthe the2018 2018CSEC CSEC®®ITITsyllabus. syllabus.

Python and Pascal Python and Pascal are demonstrated side by side, offering familiarity but also industry-leading practice needed for programming careers in the 21st Century.

Caribbean context Examples and activities reflect typical Caribbean contexts, incorporating technology and resources that students can access and afford.

Assessment ‘In-text questions’ check student understanding throughout the text, whilst multiple choice, structured questions and specimen papers provide valuable exam practice.

Active learning Well-designed individual and group Individual and group activities provide opportunities opportunitiesfor foractive activelearning learning throughout throughout the thebook. book.

SBA support SBA skills are integrated throughout using practical activities in the context of a recurring ‘real-world’ case study. The SBA chapter with sample project then guides students to gain top marks.

Productivity tools Provides clearly clearlysequenced sequencedactivity-based activity-based Provides learning, exposing exposingstudents studentstotothe a range learning, most of available office programs, ensuring workup-to-date version of Microsoft Office, ensuring workplace flexibility transferable skills. place flexibility and and transferable skills.

Online resources Visit www.macmillan-caribbean.com to find additional exam practice, Pascal, Python and other language summary sheets, extension activities and specimen solutions to activities and exam questions.

Information Technology for CSEC Examinations, 3rd Edition ®

for CSEC® Examinations

r all learning levels and designed to engage students in the secure exam success and maximise future employability, the second Macmillan’s Principles of Business provides complete coverage of llabus – including full curriculum, coursework and exam support.

Brain te

Micro-enterprises, Caribbean and non-Caribbean scenarios with accompanying questions ask students to apply their learning to different situations.

Additional content such as case study videos, worksheets and answers.

ers as

James McCloskey (UK) Rachael Raghoo Bitu (Trinidad)

Pause points for students to digest what they have read and confirm comprehension.

Check

Helping relate topics to the real world while building communication and collaboration skills through student-led learning.

Expert v

Structured to mirror the CXC syllabus with related Specific Objectives grouped together in each unit.

project

s iew

king hin

Critical t

ctiv

Author team: Riana Balliram (Trinidad) Peter Budd (China/UK) Edith Emmanual (St Lucia) Marsha Guiness (Jamaica)

Advisors: Alana Gadjahar (Trinidad) Kevin James (Jamaica) Roxanne Williams (St Vincent) Student reviewer: Seline Sundar (Trinidad)

Credible and current insights into the subject area from Caribbean business people and those in the global economic environment to inspire entrepreneurship.

Exercises to encourage students to think deeper by questioning, challenging and considering different perspectives or contexts.

Puzzles and activities to consolidate learning in a visual and active way.

CSEC® is a registered trade mark of the Caribbean Examinations Council (CXC). Principles of Business for CSEC® Examinations is an independent publication and has not been authorized, sponsored, or otherwise approved by CXC.

Principles of Business for CSEC® Examinations

nciples of Business

2nd edition

Find us on Facebook /macmillancaribbean

Find us on Twitter @MacCaribbean

www.macmillan-caribbean.com

Principles of Business for CSEC® Examinations

2nd Edition

Also available from Macmillan Education:

eBook

9781380023322

9781380023346

CXC® past papers for principles of business and a free syllabus are available to download from

www.cxc-store.com You can also access CSEC® print past papers in all good bookstores.

I S B N 978-0-230-44417-1

Student’s Book

780230 444171

NEW

15/05/2019 11:19 am

www.macmillan-caribbean.com /macmillancaribbean @MacCaribbean

csec IT bled.indd 10

30/08/2019 16:48