Applied ICT (AS-GCE)
Enter your email into the box below and when the contents of this page change you will get a message to inform you.
Monitor page
for changes
     
     

by ChangeDetection

This unit is interanlly assessed (marked by your teacher).

 

Unit 10 (G049) - Numerical Modelling Using Spreadsheets
Title of this project - "How can a spreadsheet model help to solve a problem?"
Scenario
 
Design Specification Notes Resources
Plan what you are going to do!

before you start to implement your solution, you must have a clear design of what you will do. This means planning and writing down on paper what you will do when you come to create your spreadsheet solution.

What's needed?
1. A report describing what the problem is, written in your own words and explaining how you will tackle the problem.
2. Your design sketches and model spreadsheets.
3. Any other notes or models you prepared.

Unit plan / guided learning hours
Glossary of words
Assignment task - Value Van Hire
Diary / planner
Checklist
Blank spreadsheet
Invoice example
What you need to do
Mark scheme / Recording sheet
Implement your solution Notes Resources
Do what you are going to do!    Video Tutorials (excel)
Record strategies you used to overcome problems Notes Resources
Record problems and say how you solved them!    
Testing Notes Resources
Does the model do what it should do?    
Documentation Notes Resources
Write your technical and user guides    
Evaluation Notes Resources
So, how did it all go? Room for improvement?