| Unit 18- Business Calculations | ||
| Tutor: Paul Bolger and Tony Arkwright | ||
| Unit 2 - Scheme of Work 2004/05 | ||
| Syllabus - Click Here to see what you will be studying this year | ||
| Progress Report - Unit 18 - Latest Results | ||
| Unit 7 - Documents and Notes | ||
| Maths Puzzle Zone - Have a go at exercising the old grey matter CLICK HERE to have a go | ||
| Quick Catch Up - Have you been Rumbled ? Not actually done any of that studying you were supposed to have done yet ? CLICK HERE if you need to catch up ... | |
|
|
Studywork / Homework |
Week by Week Lesson Topics | Paul's Lesson Classwork |
| Week 1 (3 hours) - Induction programme | ||
| Week 2 (3 hours) - Unit Induction - Explain overview of the syllabus - Explain Assessment Method and Rules - Explain Class rules - Introduce unit website - Register each student for an email address and record it - Ensure each student registers for the unit on line | ||
| week
02 - classwork/homework - additions
sheet 01 |
induction/ Course/Subject Overview | Week 02 - Lesson Plan |
| week 02 - classwork/homework - additions sheet 02 | ||
| week 02 - classwork/homework - additions sheet 03 | ||
| week 02 - classwork/homework - additions sheet 04 | ||
| week 02 - classwork/homework - additions sheet 05 | ||
| Week 3 (3 hours) - Numerical tools for data manipulation - Arithmetical calculations: add, subtract, integers | ||
| week 03 - classwork/homework - subtraction sheet 01 | Week 03 - Lesson Plan | |
| week 03 - classwork/homework - subtraction sheet 02 | ||
| week 03 - classwork/homework - subtraction sheet 03 | ||
| week 03 - classwork/homework - subtraction sheet 04 | ||
| week 03 - classwork/homework - subtraction sheet 05 | ||
| week 03 - classwork/homework - add/subtract sheet 01 | ||
| week 03 - classwork/homework - add/subtract sheet 02 | ||
| week 03 - classwork/homework - add/subtract sheet 03 | ||
| week 03 - classwork/homework - add/subtract sheet 04 | ||
| Week 4 (3 hours) - Numerical tools for data manipulation - Arithmetical calculations: multiply and divide integers | ||
| week 04 - classwork/homework - countdown game 1 | Week 04 - Lesson Plan | |
| week 04 - classwork/homework - multiplication sheet 01 | ||
| week 04 - classwork/homework - multiplication sheet 02 | ||
| week 04 - classwork/homework - division sheet 01 | ||
| week 04 - classwork/homework - division sheet 02 | ||
| week 04 - classwork/homework - division sheet 03 | ||
| week 04 - classwork/homework - fraction sheet 01 | ||
| week 04 - classwork/homework - fraction sheet 02 | ||
| week 04 - classwork/homework - fraction sheet 03 | ||
| week 04 - classwork/homework - fraction sheet 04 | ||
| Week
5 (3
hours) - Graphs, Charts 1 |
||
| week 05 - classwor/homework - editing charts | Week 05 - Lesson Plan | |
| week 05 - classwork/homework - graphs and charts | ||
| week 05 - classwork/homework - Assessment 1 Tasks | First Task of the Business Calculations Assessment (kindly provided by Tony Arkwright) | |
| week 05 - classwork/homework - Assessment 1 Cover Sheet | ||
| week 05 - classwork/homework - Assessment 1 Marking Grid | ||
| week 05 - classwork/homework - creating charts from spreadsheets | ||
| Week 6 (3 hours) - Graphs, Charts , simple accounts | ||
| Key Skills AON - level 2 past paper 2 may 2002 | Introduce AON KS level 2 (EDEXCEL website) | Week 06 - Lesson Plan |
| Exam Timetable | Key Skills AON - level 2 past paper 1 jan 2002 | |
| AON Level 2 Specification | ||
| Week 7 (3 hours) - | ||
| Example KS2 AON Exam 3 | Week 07 - Lesson Plan | |
| To create a spreadsheet for a newsagents showing newspaper sales. Enter data & formulae, edit cell contents, save spreadsheet, create pie chart with legend and percentages. -> | week 06 - classwork/homework - Pie Charts | |
| To create a spreadsheet for a small business showing 1st quarter expenses. Enter data, labels and values. Edit cell contents, save spreadsheet, create charts. -> | week 06 - classwork/homework - Bar Charts | |
| To create a spreadsheet showing rainfall across UK. Enter data & formulae, edit cell contents, insert rows, save spreadsheet, create pie chart, bar chart and comparative bar chart. -> | week 06 - classwork/homework - Charts | |
| To create a spreadsheet showing expenses for a small group of people. Enter data & formulae (sum & average), insert column, save spreadsheet, create & save pie chart and bar chart. -> | week 06 - classwork/homework - Charts 2 | |
| Create a spreadsheet showing cinema attendance. Enter data & formulae (sum & average), delete row, add columns, save spreadsheet, create & save pie chart and bar chart. -> | week 06 - classwork/homework - Charts 3 | |
HALF
TERM 1 |
||
| Week 8 (3 hours) - Logic Gates are tiny electronic devices that manipulate binary data in fixed ways. Three important gates are the AND gate, the OR gate, and the NOT gate. The behavior of each of these gates can be described using a truth table showing input and output values. Some other important gates are the NAND gate, the NOR gate, and the XOR gate. | ||
| Truth tables/Boolean algebra and assignment work | Week 08 - Lesson Plan | |
| Introduce logic gates (AND, OR and NOT) and truth tables didactic input with exercises. | Week 8 - computer logic notes | |
| Truth tables etc. | week 08 - computer logic | |
| week 08 - Circuits using AND and OR gates | ||
| week 08 - Building Truth Tables and developing circuits | ||
| week 08 - download SIMCIR software | ||
| Week
9
(3 hours) - |
||
| Key Skills AON - level 2 past paper 5 feb 2004 | Exam practice for AON ( 1 hr ) | Week 09 - Lesson Plan |
| In class Latest Assessment and observation session ( 2 hr ) | ||
| Week
10
(3 hours) - |
||
| Key Skills AON - level 2 past paper 6 mar 2004 | Week 10 - Lesson Plan | |
| Example KS2 AON Exam 4 | assignment 1 deadline | |
| Week 11 (3 hours) - | ||
| Exam practice | Week 11 - Lesson Plan | |
| In class assessment and observation | ||
AON
Workbook
01.doc |
Describing
situations using fractions - LEVELS 1 and 2 (intranet
only) |
|
AON
Workbook
02.doc |
Describing
situations using decimal fractions - LEVELS 1 and 2 (intranet
only) |
|
|
AON Workbook
03.doc |
Describing
situations using percentages to explain amounts and proportions - LEVELS
1 and 2 (intranet only) |
|
| Week
12
(3 hours) - |
||
| Exam practice | Week 12 - Lesson Plan | |
| In class assessment and observation | ||
AON
Workbook
04.doc |
Describing
situations using ratios - LEVELS 1 and 2 (intranet
only) |
|
AON
Workbook
05.doc |
Describing
situations using negative numbers - LEVELS 1 and 2 (intranet
only) |
|
| AON
Workbook
06.doc |
Approximations
- LEVELS 1 and 2 (intranet only) |
|
| Week 13 (3 hours) - | ||
| Exam practice | Week 13 - Lesson Plan | |
| In class assessment and observation | ||
AON
Workbook
07.doc |
Using
estimations to check results - LEVELS 1 and 2 (intranet
only) |
|
AON
Workbook
08.doc |
Number
- LEVELS 1 and 2 (intranet only) |
|
AON
Workbook
09.doc |
Calculating
with fractions - LEVELS 1 and 2 (intranet
only) |
|
| Week 14 (3 hours) - | Week 14 - | |
| Exam practice | Week 13 - Lesson Plan | |
| In class assessment and observation | ||
AON
Workbook
10.doc |
Calculate
with decimals - LEVELS 1 and 2 (intranet
only) |
|
AON
Workbook
11.doc |
Calculations
using simple percentages - LEVELS 1 and 2 (intranet
only) |
|
AON
Workbook
12.doc |
Calculations
with ratios - LEVELS 1 and 2 (intranet only) |
|
XMAS
BREAK |
||
| 03/1/2005 | Week 15 (3 hours) - | |
AON
Workbook
13.doc |
Calculations
using simple formulae - LEVELS 1 and 2 (intranet
only) |
|
AON
Workbook
14.doc |
Calculations
using common units - LEVELS 1 and 2 (intranet
only) |
|
AON
Workbook
15.doc |
Perimeter
and area - LEVELS 1 and 2 (intranet only) |
|
| 10/1/2005 | Week 16 (3 hours) - | |
| AON
Workbook
16.doc |
Volume
- LEVELS 1 and 2 (intranet only) |
|
Borders
- LEVELS 1 and 2 (intranet only) |
||
AON
Workbook
18.doc |
Converting
using scales and tables - LEVELS 1 and 2 (intranet
only) |
|
| 17/1/2005 | Week 17 (3 hours) - | |
AON
Workbook
19.doc |
Using
probability to describe situations - LEVELS 1 and 2 (intranet
only) |
|
AON
Workbook
20.doc |
Interpreting
and constructing 2D diagrams (plans and drawings) - LEVELS 1 and 2 (intranet
only) |
|
AON
Workbook
21.doc |
Interpreting
and constructing 2D representation of 3D objects - LEVELS 1 and 2 (intranet
only) |
|
AON
Workbook
22.doc |
Shoe
size survey - LEVELS 1 and 2 (intranet only) |
|
| 24/1/2005 | Week 18 (3 hours) - | |
| Number Systems | ||
| Binary Arithmetic | ||
| Boolean Logic and Algebra | ||
| Truth Tables | ||
| Gates and Circuits | ||
| 31/1/2005 | Week 19 (3 hours) - | |
| Business Calculations - Assessment 2 - Truth Tables | ||
| 7/2/2005 | Week 20 (3 hours) - | |
|
HALF
TERM 2
|
||
| 21/2/2005 | Week 21 - AON Portfolio Assessment | |
| Word - AON Level 2 Portfolio Assessment | Adobe - Key Skills AON Level 2 - Example Portfolio | |
| Adobe - Level 2 AON syllabus | ||
| Adobe - Hints, Tips and Useful Websites | ||
| 28/2/2005 | Week 22 (3 hours) - Accounting | |
| Word - 01 - Introduction to Accounting | Excel -Cash Book Account Example | |
| powerpoint - Introducing Accounts | ||
| powerpoint - Accounting Basics | ||
| powerpoint - Cash Book | ||
| 07/03/2005 | Week 23 - | |
| Word - 02 Double Entry | Excel -Double Entry Example | |
| Word - 03 A ccount Balancing | Excel -Account Balancing Example 1 | |
| Excel -Account Balancing Example 2 | ||
| powerpoint - Balance Sheets | ||
| powerpoint - final accounts | ||
| powerpoint - books of original entry | ||
| 14/03/2005 | Week 24 - | |
word - 04 gross profit |
word - 04 gross profit exercises |
|
EASTER |
||
| 04/04/2005 | Week 25 - | |
| Consoldiation Week / Students University Seminar | ||
| 11/04/2005 | Week 26 - | |
| Word - 05 net and trading profit | Word - 05 net and trading profit exercises | |
HALF
TERM 3 |
||
| Answers | Essential Downloads | |
| week 02/03 - classwork/homework - model answers | graphs
and algebra - xy
graph paper |
|
| week 04 - classwork/homework - model answers | graphs
and algebra - 2mm
- 10mm graph paper |
|
| week 06 - past paper may 2002 - model answers | ||
| week 06 - past paper jan 2002 - model answers | ||
| week 07 - example KS2 AON exam 3 model answers | ||
| week 08 - example KS2 AON exam 4 model answers | ||
| Introduction/Background Documentation - Key Skills AON Levels 1 and 2- (AVAILABLE Internally ON INTRANET ONLY) | |
| Front Page - 1 | Front Page for workbooks 1 to 22 - LEVELS 1 and 2 (intranet only) |
| Contents Page - 1 | Contents Page describing workbooks 1 to 22 inclusive - LEVELS 1 and 2 (intranet only) |
| Workbooks - Key Skills AON Levels 1 and 2 - (AVAILABLE Internally ON INTRANET ONLY) | |
Describing
situations using fractions - LEVELS 1 and 2 (intranet
only) |
|
Describing
situations using decimal fractions - LEVELS 1 and 2 (intranet
only) |
|
Describing
situations using percentages to explain amounts and proportions - LEVELS
1 and 2 (intranet only) |
|
Describing
situations using ratios - LEVELS 1 and 2 (intranet
only) |
|
Describing
situations using negative numbers - LEVELS 1 and 2 (intranet
only) |
|
Approximations
- LEVELS 1 and 2 (intranet only) |
|
Using
estimations to check results - LEVELS 1 and 2 (intranet
only) |
|
Number
- LEVELS 1 and 2 (intranet only) |
|
Calculating
with fractions - LEVELS 1 and 2 (intranet
only) |
|
Calculate
with decimals - LEVELS 1 and 2 (intranet
only) |
|
Calculations
using simple percentages - LEVELS 1 and 2 (intranet
only) |
|
Calculations
with ratios - LEVELS 1 and 2 (intranet only) |
|
Calculations
using simple formulae - LEVELS 1 and 2 (intranet
only) |
|
Calculations
using common units - LEVELS 1 and 2 (intranet
only) |
|
Perimeter
and area - LEVELS 1 and 2 (intranet only) |
|
Volume
- LEVELS 1 and 2 (intranet only) |
|
Borders
- LEVELS 1 and 2 (intranet only) |
|
Converting
using scales and tables - LEVELS 1 and 2 (intranet
only) |
|
Using
probability to describe situations - LEVELS 1 and 2 (intranet
only) |
|
Interpreting
and constructing 2D diagrams (plans and drawings) - LEVELS 1 and 2 (intranet
only) |
|
Interpreting
and constructing 2D representation of 3D objects - LEVELS 1 and 2 (intranet
only) |
|
Shoe
size survey - LEVELS 1 and 2 (intranet only) |
|