SECTION 1: Fundamentals of Hardware and Software
- A. Welcome Back To School – A Must Watch
- SBA Part One – Spreadsheet
- SBA Part Two – Database Management
- SBA Part Three – Word Processor
- SBA Part Four – Programming and Problem Solving
- SBA Part Five – Web Development and Designing
- 1. Describe a general-purpose computer system; Major functions of systems: input, processing, output, storage.
- Quiz 1: Fundamentals of Hardware and Software
- 2. Explain the functions of the major hardware Central Processing Unit (CPU): control unit and components of a computer system; ALU; main memory/immediate access storage, secondary storage, input/output devices.
- Quiz 2: Hardware Component of a Computer System
- 3. outline the functions and uses of primary Bistable devices, PROM, EPROM, RAM, ROM. storage devices;
- Quiz 3: Primary Storage Device Uses and Functions
- 4. Manipulate units of storage; Bit, byte, kilobyte, megabyte, gigabyte, terabyte, word, word size.
- Quiz 4: Unit of storage
- 5. compare the types of secondary storage media Magnetic tape, floppy disk, hard disk (fixed head, moving with respect to portability, speed and capacity; head, external), optical disks (CD, DVD), flash drive, flash memory cards.
- Quiz 5: Secondary Storage Media
- 6. use terms associated with storage devices; Read/write head, sectors, tracks, buffers, cylinders, access time, sequential access, direct access; device interfaces such as: SCSI, IDE, SATA.
- Quiz 6: Secondary Device Interface
- 7. explain the uses of various input devices and Optical mark reader (OMR), character readers media; (OCR, MICR), mouse, joystick, bar code reader, document scanner, light-pen, touch terminals, voice response unit, pads and tablets, point of sale (POS), keyboard, digital camera, biometric systems, sensors, remote control, sound capture, pointing devices, webcam.
- Quiz 7: Input and Output Media
- 8. state the types and functions of output devices; Visual display unit: resolution, types, sizes. Printers: impact and non-impact, types: (character, line, page, laser, inkjet, dot matrix). Characteristics: (speed, quality, storage capacity); plotters; audio output devices (for example, speakers, head-phones, earphones); microfilm. Also terms such as hard copy, soft copy, human readable and machine–readable.
- Quiz 8: Type and function of Output Devices
- 9. describe how data are stored and Binary, octal and hexadecimal number systems; binary manipulated within the computer; addition and subtraction. Integers (positive and negative): sign and magnitude, BCD, two’s complement; representation of characters, ASCII.
- Quiz 9: Manipulation of Data
- 10. interpret the hardware specifications of a CPU type and speed; memory: capacity, type, word size, computer system; speed. Hard drive: capacity, speed; fire wire, expansion slots, ports.
- Quiz 10: Hardware Specifications of a Computer System
- 11. distinguish between systems programs and Systems software: operating systems, translators, utilities: application programs; Application software: general purpose, special purpose, custom written. Customization, integrated software.
- 12. explain the functions of an operating system; File management, memory management, security, device management, input/output management, user interface, process management.
- Quiz 11 & 12: System and Application Program
- 13. distinguish among multitasking, multiprocessing Basic treatment of these terms. (See glossary). and multiprogramming;
- Quiz 13
- 14. explain the different types of processing modes; Batch processing, real-time, on-line, time-sharing.
- Quiz 14: Processing Modes
- 15. distinguish between types of user interface. Software interface: Command driven, graphical user interface (GUI) (menu driven, pull-down and pop-up menus, icons). Hardware interface: touch screens, non- visual interface, sensors, and Braille keyboards.
- Quiz 15: User Interface
SECTION 4 A: INTERNET AND COMMUNICATIONS TECHNOLOGY
- 1. use terms associated with data communications and networks; Definitions of data communication and network; types of networks: (local area network, wide area network, metropolitan area network), types of transmission media: cable/wired media (coaxial, fibre-optic, twisted pair), wireless media (satellite, microwave, infra-red), wireless network technology: (Bluetooth, Wi-Fi), hotspot, modem, bandwidth (broadband, narrowband, voiceband), communication modes: (simplex, duplex, half duplex), point-to-point, and broadcast.
- Quiz 16: Data Communications and Network
- 2. distinguish among Internet, intranet and extranet;
- Quiz 17: The Internet, Extranet and Intranet
- 3. explain concepts associated with the Internet; Including Electronic mail (e-mail), newsgroups, Internet Relay Chat (IRC), Telnet, File Transfer Protocol (FTP), upload, download, World Wide Web (WWW), web browser, HTTP, Hypertext Markup Language (HTML/XHTML), web page, website, blogging, webserver, URL, e-commerce, e- learning, HTTP, pod-casting, bulletin board, VoIP.
- Quiz 18: The Internet
- 4. describe measures to secure data and maintain data integrity; Software Restrictions: passwords, encryption, virus protection, firewall; physical access restrictions: biometric systems, guards, locks; fire/water proof cabinets; archiving; backup and recovery procedures; propriety data and software.
- Quiz 19: Protecting and Maintain Data Integrity
SECTION 4 B: APPLICATIONS AND IMPLICATIONS
- 1. Misuse of Information
- Quiz 20: Misuse of Information
- 2. Hardware and Software in the Industries
- Quiz 21: Hardware and Software in the Industries
- 3. The Developmental of Trends in Technology
- Quiz 23: Information Technology on Job Skills and Careers
- 4. Information Technology – Job Skills and Careers
- Quiz 22: The development of Trends in Technology
- 5. Computer Related Professions
- Quiz 24: Computer Related Professions
SECTION 2 AND 3: Problem-Solving and Programming and Program Implementation
- 1. Generation of Programming Language
- Quiz 25: Generation of Programming Language
- 2. Problem Solving and Programming – Non Computer Based
- Quiz 26: Problem Solving and Programming – Non Computer Base
- 3. Problem Solving and Programming – Computer Based
- Quiz 27: Problem Solving and Programming – Computer Base
- 4. Problem Solving and Programming – Selection Statements
- Quiz 28: Problem Solving and Programming – Selection Statement
- 5. Problem Solving and Programming – Loop Statements
- Quiz 29: Problem Solving and Programming – Loop Statements
- 6. Problem Solving and Programming – Flowcharts Algorithm
- Quiz 30: Flowchart Algorithm
- 7. Problem Solving and Programming – Test and Validate Solution
- Quiz 31: Test and Validate Solution
- 8. Problem Solving and Programming – Introduction to Pascal Programming
- 9. Problem Solving and Programming – Conditional Statements in Pascal
- 10. Problem Solving and Programming – Looping Constructs in Pascal
- Quiz 34: Implementing the Program – Loop Construct in Pascal
- 11. Problem Solving and Programming – Documenting the Program
- Quiz 35: Documenting The Program
SECTION 5: Information Processing
SECTION 6: Word-processing, Presentation and Web Page Design
- A: WORD PROCESSING: 1. select appropriate editing features in the Deleting and inserting characters, words, lines, sentences, preparation of a document; paragraphs. Type-over mode. Selecting blocks of text. Copying and moving sections of text.
- 2. describe commonly available features; Page numbers, page breaks, text alignment, wordwrap, margins, tabs, page length, default settings, font size.
- 3. select appropriate formatting features for the Margins, tab stops, line spacing, page breaks, page preparation of a document; numbers, left and right justification, centre line, underline, highlight, uppercase, bold, and italic.
- 4. use headers, footers, footnotes and endnotes appropriately;
- 5. combine documents;
- 6. perform block operations;
- 7. use columns and tables appropriately;
- 8. apply appropriate character formatting Underline, bold, italics, font types and sizes, superscript features; and subscript.
- 9. use search and replace functions appropriately;
- 10. use mail-merge facilities; Creation of primary documents and data files in mail merge application; Field names.
- 11. use spell-check;
- 12. import documents; Text files, graphics, tables including options such as automatic
- B: PRESENTATION – 13. explain the uses of presentation software; For example, to enhance public speaking; to deliver lectures; to present project reports; to effectively present sales or marketing ideas.
- 14. explain the concepts of wizards, templates and slides;
- 15. choose appropriate slide layout; Slide layout must relate to the type of information being presented.
- 16. apply design templates to slides; Choosing from a list of presentation designs.
- 17. use formatting features effectively to enhance Changing background colour, font size and other attributes, presentation; such as font colour and bullets.
- 18. create slide headers and footers; Use of the slide master to personalize the slides.
- 19. create and use speaker notes;
- 20. apply various types of animation effects to Flying, drive-in, camera effects; flash-once, typewriter; laser, slides; reverse-texts, drop-in effects. Custom animation; timing and sound effects.
- 21. insert graphics and moving pictures into a slide;
- 22. manipulate multiple slides; Insertion and deletion of slides; use of the slide sorter.
- 23. present a slide show. Use of slide show tools such as slide navigator, pointer options, screen attributes.
- C: WEB PAGE DESIGN : 24. plan the website; Reasons for the website; the intended audience; number of web pages desired; content of each page; layout of the web pages.
- 25. create a simple web page; Choosing an appropriate design for a page; inserting and deleting text and graphics; wrap text with image; create thumbnail image, index page, home page, hyperlink.
- 26. create hyperlinks; Linking to another web page; link to a location within the web page; link to an email address; link to user-created files.
- 27. test the website; Use of a web browser; verify that all the hyperlinks work correctly; use a test audience.
- 28. publish and maintain a website. Registering domain names; locate hosting company; the use of the file transfer protocol (FTP) for uploading files.
SECTION 7: Spreadsheets
- 1. Explain the purpose of a spreadsheet; Definition of spreadsheet: a spreadsheet is a table consisting of cells (rows, column locations) that hold accounting or financial data and simulates the traditional physical spreadsheet; it captures displays and manipulates data.
- 2. Use appropriate terminology and notions Row, column, cell, cell address, label, value, formula, function, commonly associated with spreadsheets; worksheet, template, range, title, window, record.’
- 3. Formula errors – troubleshooting; Select basic pre-defined systems functions; Including sum, average, date, maximum, minimum, count, if, vlookup, rank.
- 4. Create advanced arithmetic formulae; Formulae involving addition, subtraction; multiplication; division; powers; square roots, the use of brackets.
- 5. Relative, Absolute and Mixed References.
- 6. Invoke row and column title locking; Horizontal, vertical, both.
- 7. Manipulate data on a spreadsheet; Effects of move, copy, delete operations on formulae.
- 8. Manipulate columns and rows; Insert and delete columns and rows.
- 9. Format a spreadsheet; Numeric data formatting, text formatting, alignment, borders.
- 10. Sort a spreadsheet; Primary field, secondary field, ascending vs. descending order.
- 11. Explain the purpose of charts; creating charts, tables.
SECTION 8: Database Management
- 1. explain the concept of a database; Definition of database: repository of information; collection of tables that are related to each other.
- 2. use terminology commonly associated with Database terminology: table (relation), entity, tuple, attribute, a database; primary key, secondary key, composite key, candidate key, alternate key, foreign key.
- 3. distinguish among terminology associated Row (tuple, record), column (attribute, field), key. with files and databases; Data types: alphanumeric; numeric; data; logical.
- 4. outline the advantages and limitations of Comparison with files with regards to: Speed; Ad hoc queries; databases; standardization; present multiple views of the same data.
- 5. create a database; Table structure with at least three data types and populate with at least twenty-five records. Use of wizard is prohibited.
- 6. modify a table structure; Adding new fields, deleting fields, changing field definitions.
- 7. sort a database; Arranging data in numeric, alphabetic; or alphanumeric format. Report generating facilities of the database package, including use of sorting, grouping statistical and summary features, for example, count, sum and average.
- 8. establish relationships; Use of joins, merge tables/files.
- 9. query a database using multiple search Using more than one criterion; use of select, calculated fields. conditions;
- 10. determine the results of a search on a database given multiple conditions; Two or more fields involving the use of relational and logical operators.
- 11. generate reports to the screen, printer and files. Report generating facilities of the database package, including use of sorting, grouping, statistical and summary features, for example, count, sum and average.
SBA Part One – Spreadsheet
The National Youth Service (NYS) Programme
The NYS Corps programme combines training in specific career skills, re-socialization and work experience to develop positive attitudes and values among participants in the areas of self, work place, community and nation, as well as provide opportunities and orientation for their entrance into the labour force. Recruitment and Selection of participants is an island-wide initiative and is done throughout the year. The NYS conducts training camps according to the Camp Schedule. These camps are used for training in various corps such as; Education, Customer Care and Security etc. As a Secretary and parish representative you are required to utilize Word Processor, Spreadsheet, Database as well as a Program Application to begin and implement a Computer – Based solutions to the tasks involved in the management of the participant’s data. For each corps, lecturer will train the participants for the particular area of interest.
The participant’s records are maintained by the usage files in a filing cabinet. Spreadsheet will be used to capture all the clerical data, this process will be done as a PROTOTYPE. The spreadsheet would contain the following corps;
- Customer Care,
The diagrams below will show and describe the layout of the tasks to be done. As Secretary and parish representative, the final data must be accurate.
You are required to design a workbook that accepts the Lecturer or trainers data.
a. Reproduce figure 1 as accurately as possible.
National Youth Service Lecturer Information
|Title||First Name||Last Name||University||Corp||Duration||Qualifications|
Figure 1 showing National Youth Service Lecturer Information
b. Populate the sheet with appropriate data of choice
c. Save the sheet as Lecturers Record
d. Reproduce all the following on separate sheets, (Education Corps, Customer Care Corps and Security Corps) as shown below. This information must be correctly copied.
National Youth Service Security Corps
|First Name||Last Name||Address||Gender||Age||School||Subjects Passed|
Figure 2 showing NYS Security Cops Participants data
National Youth Service Education Corps
|First Name||Last Name||Address||Gender||Age||School||Subjects Passed|
Figure 3 showing NYS Education Cops Participants data
National Youth Service Customer Care Corps
|First Name||Last Name||Address||Gender||Age||School||Subjects Passed|
Figure 4 showing NYS Customer Care Cops Participants data
e. Name each sheet with an appropriate name relating to the data captured.
f. The workbook must be saved as National Youth Service Original Record
Now, at this stage you will now make the necessary modifications and populations to the sheets in the workbook. Ensure that all the data that is transferred is linked in some way.
a. Populate the worksheets with the necessary and appropriate data of your choice. Ensure that the column which labels Subjects Passed contains numbers from 0 up.
b. Add ONE column at the end of each Corp table. Label these columns as: University.
c. Insert the appropriate formulae to produce the result for each. The University column would contain data that reflects whether or not a participant is Eligible or Not Eligible. If the participant has passed 5 subjects, then he/she will be eligible to go to a university, if less subjects are passed then him/her will not be eligible. This data is needed for scholarships selection purposes.
d. Re-save the document as National Youth Service Modified Record.This means that you should have two spreadsheet files:
- National Youth Service Original Record
- National Youth Service Modified
At this stage you will Modify (National Youth Service Modified Record)the spreadsheet to reflect the following record changes;
a. Change all appropriate font size as follows:
- All headings font size 16.
- All sub headings font size 14.
- All other font sizes 12.
b. Ensure all fonts are Arial.
c. One participant was left off each corps sheets list during data entry. You are required to Insert the names of these participants and populate their record with the appropriate data.
Develop and modify a General Record as follow (linking sheets);
a. Create a new sheet to show a NATIONAL YOUTH SERVICE GENERAL RECORD, that includes; all Corps with all records of participants.
b. Insert a column, name the column Corps. Populate the sheet with the appropriate data.
c. Sort the records in descending order by First Names.
d. Name the sheet as with an appropriate label.
e. Indicate in the spreadsheet by calculating the following data: NYS Lecturer Expenses and Total Expenses(Use appropriate formulae).
|NYS Lecturer Expenses||Tax||7%|
|Masters||$ 8,200.00||$ 1,200.00||$||$|
|Masters||$ 8,200.00||$ 1,500.00||$||$|
|PhD||$ 10,100.00||$ 1,600.00||$||$|
|PhD||$ 10,100.00||$ 1,700.00||$||$|
|Masters||$ 8,200.00||$ 1,000.00||$||$|
|Masters||$ 8,200.00||$ 1,100.00||$||$|
|$ 110.00||$ 40.00||$ 55.00||$ 1,200.00||$ 1,500.00|
|# of Participants:|
|# of Lecturers:|
Figure 5 showing National Youth Service (NYS) Expenditures
Create additional sheets with FILTER, Pie and Bar CHART.
a. Create a sheet that displays a filter record. This must filter all subject passes greater than or equal to 5.
b. Name sheet as National Youth Service (NYS) Filer Record
c. Create a Column chart to compare the NYS Lecturer Expenses mentioned in above. Ensure that the chart is formatted appropriately.
d. Give the Column chart an appropriate name. The name must be related to the data captured.
e. Create one a Pie chart to reflect Total Expenses which include: food, water, drink, lecturing materials and location cost.
f. Give the Column chart an appropriate name (must relate to the data captured)