P3 and M2

D2

The database that I have created was made on Microsoft Access. Making it in Access meant that I could easily add information about new members and could  The database was designed for the Kingswoods Film Club. Creating this database allowed easy storage of information about the users.

My database can easily collect members as their is an electronic members table that can keep all this data together. The second table collects all records of payments and also keeps all this information together. This allows it to be read easily by a company and to see all the members and payments made. The third table collects reviews and star ratings about each film, this allows users to make reviews which shows customers whether they should pay for a film. The last table is films information, this table was used for keeping all the information and data together. This made my database easily accessible.

D1 - corrections

P7 - Test Table

Screenshots

Making Form screenshots

P2 - Data Dictionary

P2 - E.A.R Diagram

P2 - Input & Output Processes

D1

M1

P1

M2

Machine and Peripheral Management - The iMac has two main disadvantages over the Lenovo C440, which is that the iMac doesn't come with a mouse or keyboard and that the price is very expensive. Everything has to be bought individually for the iMac, this is very expensive. The lenovo C440 comes with all of these peripherals and still has a cheaper retail price of around £600! The iMacs retail price is around £1,300! The lenovo C440 also has a tilted touchscreen and wireless mouse and keyboard. 

RAM -The iMac has a RAM size of 4GB which is the same as the lenovo C440. The RAM is important to these computers because it means that they will run smoother and quicker. For me this is one of the most important functions a computer that I would purchase. one advantage with iMacs is that you can buy larger RAM sizes but they are very expensive.

Processor -  The iMac has an intel core I7 quad core processor, this is very good because it has four cores which allow more information to be processed which makes it faster. The lenovo C440 has a dual core processor, the iMac will be quicker as it has a much better processor which is double the lenovos processor.

Graphics Card -The iMac has a laptop graphics card which makes it fairly good, but it could be much better. This graphics card is one of the main disadvantages for the iMac as it doesn't make the computer as greater quality as it could be.

What I would buy?
I would buy the iMac if i was to buy one of these computers it would be the iMac, although it is very expensive you are getting your moneys worth. They are very reliable and run smoothly, they have a good RAM and it can be changed to suit the users needs. Also it has a very good processor which helps the computer to not jump, lag or freeze and keeps it running without any problems. This computer is very efficient.

M3/D2

p7

Test	Method	Expected outcome	Actual Outcome	Action required
‘software applications can work as intended’	I will download Microsoft office and open PowerPoint.	To see if it runs quickly and works as supposed.	The program opened quickly and the tools worked well.	No action required except the installation of the Microsoft office.
‘default folder settings are correct’	I will move folders into a default folder and see if it works.	For my files to be transferred and kept safe in a default folder.	All my folders were transferred successfully into a default folder.	No action needed as all I needed to was send my folders into a default folder.
‘desktop shortcuts go to the right place’	I will create a shortcut to my documents from my desktop.	To see if it works and sends me where I wanted it to.	The shortcut put me straight into my documents as expected.	No action needed.
‘the correct device drivers are installed’	I will install device and expect the driver to work.	I will expect all of the functions of the device inserted to work otherwise it means the systems drivers aren’t working as expected.	The correct device driver was installed and the functions worked.	Plugging in a device.
‘the correct paper sizes are set for printing’	I will use word and go on printer settings and see the available paper sizes to print on.	All the basic paper sizes e.g. A4 and A3 can be printed.	These paper sizes could be printed as expected and the quality was the same.	Just needed to be able to print the file.
‘menu options work as intended’	I will use the menu options and type in Microsoft.	I will expect all the programs to be shown.	The programs came up like they should of.	To have access to the menu.
‘the correct date and time are set’	The bottom right has footer with the date and time on. I will use my watch and check that they are the same and are correct.	It to be on the right time and the right date.	It was on the right time and date as my watch.	To use my watch.

P8 - Witness Statement

Witness statement
Learner name		Charlie Mewes
Qualification		BTEC National 1st certificate in IT
Unit number and title		Unit 2.2 computer systems.
Assignment
Description of activity undertaken (please be as specific as possible)
Using the computer system provided, carry out the following routine maintenance: •       Create a file structure under user as follows A folder labelled with your name and within this folder create 3 folders labelled Home, Work and Study •       Configure the operating system to perform the following: •       back-up procedures •       automatic scheduling and deletion of unwanted data •       archiving •       defragmentation •       deleting temporary files •       Cleaning keyboard, mouse, display screen of the computer provided •       replacing consumables printer paper in the printer provided ·         replacing the damaged mouse
Assessment and grading criteria
Task 4. Undertake routine maintenance tasks on a standalone computer system. P8
How the activity meets the requirements of the assessment and grading criteria, including how and where the activity took place
Charlie clearly showed how to create a folder, he named it with his name and created another 3 folders labelled Work, Home and Study. He then showed how to make the operating system configure back up procedures, automatic scheduling and archiving. He used defragmentation programme to defrag data. He showed how to delete temporary files, clean keyboard, mouse and display screen of the computer. He then replaces printer paper and replaced the damaged mouse.
Witness name	Arran McCall		Job role	Witness
Witness signature	Arran McCall		Date	03/06/2014
Assessor name
Assessor signature			Date

P6 - Witness Statement

Witness statement
Learner name		Charlie Mewes
Qualification		BTEC National 1st certificate in IT
Unit number and title		Unit 2.2 computer systems.
Assignment		Set up and maintain a computer system
Description of activity undertaken (please be as specific as possible)
Task 2 (P6) Using the computer system provided: Change the icon size to large Change the font size to large colour/background to red
Assessment and grading criteria
P6.configure a computer system to meet user needs For P6, learners must configure some basic system settings, such as left and right mouse buttons, powersaving options, screen resolution, desktop theme, font size, default language setting, default folder locations etc.
How the activity meets the requirements of the assessment and grading criteria, including how and where the activity took place
Charlie clearly showed how changes an icon size to a large icon. He then showed how to change the font size to large and changing the colour and background to red.
Witness name	Arran McCall		Job role	Witness
	MB
Witness signature	Arran McCall		Date	23/05/2014
Assessor name
Assessor signature			Date