BYS [INT1008] – N4 Integrated Pack 2


Plenty of practice with Spreadsheets, Databases, Word and PowerPoint, this pack is aimed at N4 Admin and IT and incorporates the skills as per the N4 Unit Specification for the IT Solutions For Administrators Unit.  Pack 2 is based It is based around a Scottish loch with camping, wildlife and water activities and a community trying to keep it clean and safe.


The task scenario is based around a loch side community who are trying to find a solution to visitors enjoying the loch and also protecting its environment and local wildlife. Students are asked to do a variety of tasks in Word including creating a fact sheet on wildlife around the loch, designing a car stick and also a poster to encourage responsible camping. There are additional Word tasks with a business letter to be completed and a wrist band to be designed.  There are spreadsheet tasks that require students to create different charts, format and edit data, use basic arithmetical formulas (+, /, *,-) and the common functions of Autosum, Count, Average, Max and Min.  Spreadsheet tasks include analysis visitor numbers and completing an equipment costing sheet.  There are several database tasks around community helpers and community wardens. and also a staff database.  Students are asked to add to an existing database table, turn the table into a Form and create simple Queries and Reports.

Included in each pack are suggested solutions and help sheets.


There are no reviews yet.

Be the first to review “BYS [INT1008] – N4 Integrated Pack 2”