Developed test cases in JavaScript to validate
arithmetic operators, string to number, number to string, datetime, math and string objects
The guide covers: BASIC OPERATIONS (opening, closing, saving, printing etc) EDITING (insert and edit data, undo / redo, search / replace, selecting, switching between worksheets) FORMATTING (fonts, sizes, colours, alignment, borders / shading, number / date formats, AutoFill, sorting, cell orientation and wrapping) MANAGE WORKSHEETS (working with rows and columns, managing worksheets) USING FORMULAS AND FUNCTIONS (BODMAS,
arithmetic operators, cell references, ranges and functions) PAGE LAYOUT (margins, orientation,, headers / footers, paper size, row / column headers, gridelines, title rows, preview etc) CREATING CHARTS (pie, line, column, editing and formatting etc)
• Decomposition • Abstraction • Basic Pseudocode •
Arithmetic Operations • Relational
Operators • Boolean
Operators • Input and Output • Iteration • Selection • Nesting statements • Flowcharts • Trace Tables • Dealing with Arrays • Subroutines • Dealing with strings • ASCII and Unicode • Linear search • Binary Search • Compare the two search algorithms < • Bubble Sort • Merge Sort • Compare the two sort algorithms Other student workbooks in this series include: Programming Fundamentals of Data Representation GCSE revision student workbook Computer Systems GCSE revision student workbook Computer Networks GCSE revision student workbook Cyber Security GCSE revision student workbook Ethical, legal and environmental impacts GCSE workbook
Basic Python: - Input Output Variables Mathematical
operators Comments
Arithmetic operations: - basic maths, division (real, whole and modular, maths functions, using the math library.