Microsoft Excel
Detailed college-level spreadsheet, formulas, functions, analysis and chart notes with 20 projects and examination.
Detailed Notes
1. Spreadsheet Concepts
A spreadsheet stores data in rows and columns and performs calculations using formulas and functions. Excel is used for marksheets, payroll, budgets, inventory and analysis.
2. Workbook, Worksheet and Cells
A workbook is the Excel file and worksheets are individual sheets. Columns use letters, rows use numbers and cells have references such as B5.
3. Data Entry and Formatting
Enter text, numbers, dates and formulas. Apply appropriate number formats, borders, alignment, widths and headings.
4. Formulas and Operators
Formulas begin with =. Common operators include +, -, *, / and ^. Parentheses control calculation order.
=SUM(B2:B20) =AVERAGE(B2:B20) =MAX(B2:B20) =MIN(B2:B20) =COUNT(B2:B20) =IF(C2>=50,"PASS","FAIL") =COUNTIF(D2:D30,"PASS") =SUMIF(A2:A30,"ICT",E2:E30)
5. Cell References
Relative references change when copied, e.g. A1. Absolute references remain fixed, e.g. $A$1. Mixed references lock one part, e.g. A$1 or $A1.
6. Functions
| Function | Purpose |
|---|---|
| SUM | Add values |
| AVERAGE | Calculate mean |
| MAX/MIN | Highest/lowest |
| COUNT | Count numeric cells |
| IF | Test a condition |
| COUNTIF | Count by criteria |
| SUMIF | Sum by criteria |
7. Sorting and Filtering
Sorting arranges records. Filtering displays records meeting selected conditions.
8. Conditional Formatting
Rules can highlight values such as marks below 50 or sales above a target.
9. Charts
Column and bar charts compare categories, line charts show trends and pie charts can show parts of a whole when appropriate.
10. Data Validation and Printing
Data validation controls entries such as marks between 0 and 100. Print setup includes margins, orientation, scaling, print area and preview.
20 Practical Projects
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Examination – 100 Marks
Section A – Short Answer
Section B – Structured Questions
Section C – Practical Questions
Answers / Marking Scheme – Teacher Section
Marking Scheme
Give marks for correct formulas, functions, references and procedures. Practical tasks should assess data entry, formulas, formatting, validation, analysis, charts, accuracy and print setup.