Syllabus on Calc

2nd Draft

Module	Chapter	Topic	Knowledge
OpenOffice.org - Calc
	3. Calc
		3.1 Styles
		3.2 Printing with Calc
			3.2.1 Printing a spreadsheet
			3.2.2 Selecting sheets to print
			3.2.3 Adjusting the print range
			3.2.4 Page breaks
			3.2.5 Headers and footers
		3.3 Formula and functions
			3.3.1 About formulas
			3.3.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN)
			3.3.3 Statistical functions
			3.3.4 Time and date functions
			3.3.5 Text functions
			3.3.6 Math functions
			3.3.7 Logical functions
			3.3.8 Information functions
			3.3.9 Advanced spreadsheet functions
			3.3.10 Standard errors
		3.4 Sorting data
			3.4.1 Using spreadsheet as database
			3.4.2 Ascending or descending order
			3.4.3 Advanced sorting options
		3.5 Filtering data
			3.5.1 Using autofilter
			3.5.2 Setting up manual filter
			3.5.3 Advanced filters
			3.5.4 Defining filters
		3.6 Creating charts
			3.6.1 Using the AutoFormat Chart dialog
			3.6.2 Chart types
			3.6.3 Appearance of a chart
			3.6.4 Modifying the data area of a chart
			3.6.5 Changing line colors
			3.6.6 Modifying axes scales
		3.7 Solver
			3.7.1 Using Solver
			3.7.2 Groups and goals
		3.8 Goal seek
		3.9 Scenarios
		3.10 Error Detective
		3.11. Linking data
			3.11.1 Why use multiple sheets?
			3.11.2 Referencing other sheets
			3.11.3 Referencing other Calc documents
			3.11.4 Referencing to external data sources
			3.11.5 Relative, mixed, absolute references
		3.12 Validity
		3.13 Subtotals
		3.14 Grouping and schema