Welcome to GoLive CyberStudio

COMPUTER LITERACY CHALLENGE EXAM GUIDELINES

DATASHEET PROBLEM

Using the available spreadsheet/database program(s), each student must be able to:

Create, modify and print (in both portrait and landscape orientation showing and/or hiding row and column headings and gridlines) a single spreadsheet/database file (given the necessary information). Within that file, students must produce and print two separate reports/lavouts and one chart;

Format cells/fields as appropriate and as indicated in the test directions including: adjusting row height and column width;

configuring plain, bold, italic or underlined text in any required size of font;

entering dates using various formats;

positioning centered, left or right justified (aligned) text;

displaying numbers rounded to the proper decimal value and using commas, dollar signs and/or percents as necessary;

Apply spreadsheet functions and/or formulas to derive all calculated values including counts, sums, differences, products, quotients, minimums, maximums and averages;

Enter calculated values in appropriate cells in accordance with the specific format;

Display cells showing values (numbers) and formulas;

Sort records by any field, both alphabetically and/or numerically in ascending or descending order;

Use filters/queries/match records/hide columns option of the program to select some records without deleting;

Create and print a report/layout that shows only selected fields and records without deleting fields and records.

Create and print a chart based on data included in the datasheet.

Calculators and mental calculations may not be used

Please see database sample task and correct response.

CRITERION FOR PASSING: Students must be able to perform all datasheet functions.

NO ERRORS are allowed in the following “function” areas, including but not limited to: row height and column width; printing, in both portrait and landscape operation; showing or hiding row and column headings and gridlines; entering dates using various formats; positioning centered, left and right justified text; displaying numbers rounded to the proper decimal value and using commas, dollar signs and/or percents as necessary; applying spreadsheet functions and/or formulas to derive all calculated values including counts, sums, minimums, maximums and averages; sorting and showing/hiding records; charting proper fields and records showing appropriate chart and axis titles.

NO MORE THAN TWO ERRORS are allowed in the following areas, including but not limited to: spelling; capitalization; letter duplication; word substitution; omitted or added words; punctuation; spacing between words; not using bold, italics or underlining when indicated; incorrect line spacing, margins, font size, justification, and tab placement. Each occurrence of an error counts as one error.

	COMPUTER LITERACY CHALLENGE EXAM GUIDELINES
	DATASHEET PROBLEM
	Using the available spreadsheet/database program(s), each student must be able to:
	Create, modify and print (in both portrait and landscape orientation showing and/or hiding row and column headings and gridlines) a single spreadsheet/database file (given the necessary information). Within that file, students must produce and print two separate reports/lavouts and one chart;
	Format cells/fields as appropriate and as indicated in the test directions including: adjusting row height and column width;
	configuring plain, bold, italic or underlined text in any required size of font;
	entering dates using various formats;
	positioning centered, left or right justified (aligned) text;
	displaying numbers rounded to the proper decimal value and using commas, dollar signs and/or percents as necessary;
	Apply spreadsheet functions and/or formulas to derive all calculated values including counts, sums, differences, products, quotients, minimums, maximums and averages;
	Enter calculated values in appropriate cells in accordance with the specific format;
	Display cells showing values (numbers) and formulas;
	Sort records by any field, both alphabetically and/or numerically in ascending or descending order;
	Use filters/queries/match records/hide columns option of the program to select some records without deleting;
	Create and print a report/layout that shows only selected fields and records without deleting fields and records.
	Create and print a chart based on data included in the datasheet.
	Calculators and mental calculations may not be used
	Please see database sample task and correct response.
	CRITERION FOR PASSING: Students must be able to perform all datasheet functions.
	NO ERRORS are allowed in the following “function” areas, including but not limited to: row height and column width; printing, in both portrait and landscape operation; showing or hiding row and column headings and gridlines; entering dates using various formats; positioning centered, left and right justified text; displaying numbers rounded to the proper decimal value and using commas, dollar signs and/or percents as necessary; applying spreadsheet functions and/or formulas to derive all calculated values including counts, sums, minimums, maximums and averages; sorting and showing/hiding records; charting proper fields and records showing appropriate chart and axis titles.
	NO MORE THAN TWO ERRORS are allowed in the following areas, including but not limited to: spelling; capitalization; letter duplication; word substitution; omitted or added words; punctuation; spacing between words; not using bold, italics or underlining when indicated; incorrect line spacing, margins, font size, justification, and tab placement. Each occurrence of an error counts as one error.