MARK SCHEME

INFORMATION TECHNOLOGY SBA (2010 – 2011)

Word Processing
Requirement / Key Skills / MARKS Allocation / MARKSAWARDED
  1. Creation of nomination form to be completed by candidates and sent to the Trinbarjam Elections Commission
/
  • Include appropriate fields
  • For entry of relevant data on candidate
  • For entry of relevant data on the constituency
  • Inclusion of the Trinbarjam Letterhead at the top
  • Form designed on letter sized paper with 0.7 margin to the left and right sides.
/ 1
1
1
1
  1. Creation of letter from the Chairman of the Trinbarjam Elections Commission. Letter is to be delivered to each candidate informing of the results of the elections
/
  • Creating the primary/ main document.
  • Congratulatory paragraph.
  • Insertion of candidate name appropriately in the first paragraph
  • Selection of correct merge fields in data source
  • Integration of fields into appropriate sections of primary / main document.
/ 1
1
1
2
2
  1. Insertion of the Report from the database document
/
  • Combining document:
  • Correct order; after paragraph one, maintaining continuity.
/ 1
1
  1. Final paragraph.
/
  • First portion of paragraph congratulating the winners and winning party
  • Final portion should be an invite from Chairman to those who qualify for a refund to visit head office for refund
/ 1
1
  1. Format header to resemble specifications given.
/
  • Header is on the first page only
/ 1
  1. Footer
/
  • Appropriate footer used
/ 1
  1. Ensuring document contains correct spelling and grammar.
/
  • Accurate use of spell check.
/ 1
  1. Creation of an official looking cover page with relevant information.
/
  • Proper creation and labeling of a WP assignment cover.
/ 1
  1. Print-out required documents [The Letters, Officials , Cover Page]
/
  • All required sections printed.
/ 1
TOTAL / 20
Spreadsheet
Requirement / Key Skills / MARKS Allocation / MARKSAWARDED
  1. Create Spreadsheet data.
/
  • Correct data entered
  • Correct fields inserted
  • Formatting of headings
/ 1
1
1
  1. Calculate:
  2. Number of Votes cast
  • General Votes
  • Actual number of votes
  • Total Votes recieved
/ Use basic formula and predefined functions:
  • Correct use of function
  • Use of range names, relative and absolute cell addressing
  • Use of Correct formulaand data
/ 1
1
1
  1. Number of Special Votes
/
  • Insertion of row in appropriate area to record Special Votes cast by constituency
  • Insertion of column to record number of special votes received by candidate
/ 1
1
  1. Refund/No Refund
/
  • Insertion of column to indicate whether or not refund is due to candidate.
  • Determine by use of IF whether or not refund is due to candidate based on criteria.
/ 1
2
  1. Creation of table
/
  • List Constituency
  • Total number of votes received by each party in each constituency.
  • Sort candidate data for each constituency in descending order by total number of votes received
/ 1
1
1
  1. Values, labels etc must be appropriately formatted.
/
  • Use of data formatting in majority of required spreadsheet (such as decimal place, currency, comma, percentage features).
/ 1
  1. Creation of graphs
/
  • Column graph to compare votes received by each party by constituency
  • Create graph that compares parties by name and the total number of votes received
  • Appropriate labeling of graphs
  • Ability to select required range of adjacent cells for use in a chart.
/ 1
1
1
1
  1. Creation and use of spreadsheet to solve spreadsheet assignment.
/
  • Use of more than one worksheet to complete task
/ 1
TOTAL / 20
Database Management
Requirement / Key Skills / MARKS Allocation / MARKSAWARDED
  1. Create tables:
  • All tables
/
  • Correct fields
  • Appropriate field type
/ 1
1
  1. Create Queries.
/
  • Select Query1:
  • Display ID, name, sex and profession for all candidates from Peoples Democratic Revolution(PDR)
  • Return candidates receiving less than 500 votes from constituency with more than 6500 votes
  • Use of correct criteria
  • Calculate special votes as a percentage:
  • Correct calculation of percentage special votes
  • Appropriate fields used.
  • Percentage represented as two places of decimal
  • Candidates receiving less than 20% of votes t in their constituency
  • Correct criteria used
  • Correct fields used
  • All male candidates equal to or older than age 40 receiving more than 40% of votes:
  • Criteria correctly used.
  • Correct fields used
  • Valid records in query.
  • Calculate sum of deposits to be refunded:
  • Correct calculation done
  • Appropriate fields used.
/ 1
1
1
1
1
1
1
2
1
1
1
1
  1. Report:
/
  • Selection of a table or query and appropriate fields for report.
  • Effective use of grouping and sorting of required fields.
  • Show total
  • Show average
/ 1
1
1
1
  1. Overall Presentation of SBA Sub-section
/
  • Candidate’s database assignment was submitted in a coherent manner
/ 1
TOTAL / 20

Algorithm Development

Processes / Key Skills / MARKS Allocation / MARKSAWARDED
1 Problem statement that
defines the problem /
  • Problem is clearly defined
/ 1
2 Representing the solution
in flowchart or
pseudocode /
  • Start of solution
  • Definition of variables:
  • Identify variables
  • Initialize variables
  • Processing:
  • Request for data
  • Storing Data
  • Appropriate and logical use of control structures: selection statements; looping constructs
  • Output results
  • End of solution
/ 1
1
1
1
2
2
1
TOTAL / 10

Program working to specification

Processes / Key Skills / MARKS Allocation / MARKSAWARDED
1 The effectiveness with
which the program
achieved the objective /
  • Program compiled
  • Definition of variables:
  • Output is correct for ALL values
[output is correct for SOME values] / 1
2
[1]
2 The effectiveness with
which the language
features are used to
achieve a working
solution. /
  • Appropriate use of features of the language
  • Appropriate choice of data types for ALL variables [ appropriate choice of data types for SOME variables]
  • Use of Clear screen command
(clrscr)
  • Appropriate use of control structures:
  • Appropriate initialization of variables
  • Appropriate use of sequence
  • Appropriate use of if then else constructs [inefficient use of if then else construct]
  • Appropriate use of looping construct to manipulate arrays or perform other tasks [inefficient use of loop construct]
/ 2
[1]
1
1
1
2
2
[1]
3The effectiveness with
which the language
features are used to
achieve clarity /
  • Clarity of program:
  • Program documentation through
Variable names; author of program; date created; simple statement of task program solves
  • Readability (correctly indented; logical flow of control; easy to follow;)
  • User-friendly
/ 1
1
1
TOTAL / 15

Trace Table

Processes / Key Skills / MARKS Allocation
Constructing the trace table /
  • All variables correctly identified and used
  • Appropriate test data
  • Data set complete:
  • Data set test all areas for robustness
  • [data set test SOME areas]
  • Changes in values correctly demonstrated
/ 1
1
2
1
Total / 5