Home / KS4 / Nationals 2010 /
Unit 13
Unit 13: IT Systems and user needs (2010)
|
Learning outcomes
By completing this unit candidates will develop a thorough knowledge and
understanding of the range of hardware and software available and will use this
understanding to analyse user needs and make recommendations about an IT system
and the software required to meet those user needs. They will acquire the
knowledge required to make logical configuration changes to software, including
the creation of macros.
Candidates will be able to:
- select suitable hardware and software to meet the needs of a home user
or small business
- spec a suitable system connected to the internet
- configure the operating system
- configure applications software
- create and edit macros to meet the needs of a user
- understand and carry out simple backup procedures.
Scenario
- Yodafone International is a mobile phone company based in the
Dagobah system. In their main office there are a number of employees
who help with the day-to-day running. Yodafone have planned to
launch 12 new mobile phone shops around England. They have asked for
a number of advertising materials to be create which include a TV
advert, a radio advert and a booklet/magazine. Anne who has just
started working in the office requires a computer to do her job.
Yodafone have contacted you to research, purchase and install the
machine based on Anne's requirements.
- Anne has been told that she will be responsible for maintaining
and uploading the company's website. The website includes text,
advertising banners and a large number of photos of mobile phones.
- Anne also has to type up all of the business's weekly meetings,
this means that she will need to create and save lots of agendas,
minutes and memos. Once she has created these documents she will
need to email them to her boss and colleagues.
- The desk Anne has been given is fairly small so she needs a
computer and monitor that doesn't take up a lot of space. Anne is
left handed and suffers from RSI (pain) in her wrists.
- Anne knows that she will probably need a way of backing up all
of her documents every week but doesn't know which program to use.
- Address: Yodafone House, Yodington, Yodaset, UK, YO1 DA2
|
 |
AO1 - Select suitable hardware and software to meet the needs of a home user
or a small business.
|
| |
Pass |
Merit |
Distinction |
| |
Candidates identify the user and purpose
for the required system
They describe the hardware required including input, output, processor and
storage.
They describe suitable applications software. Not all the choices will be
appropriate. |
Candidates describe the user and purpose
for the required system.
They give a detailed description of the hardware required including input,
output, processor and storage.
A suitable operating system is identified and a detailed description of suitable
applications software is given.
Most choices will be appropriate.
|
Candidates explain the user and purpose
for the required system.
A detailed description of the hardware required including input, output,
processor and storage with justification of their choices is given.
A suitable operating system is identified and a detailed description of suitable
applications software with justification of their choices is given.
All choices will be appropriate. |
| A |
Info:
- In this task you will:
- identify the user and purpose of the required
system.
- describe required hardware for the system.
- describe required software for the system.
Task:
- Read the scenario carefully.
- Complete this worksheet.
- Save the worksheet in your unit 13 ao1 folder as
UserRequirements
|
Info:
- In this task you will:
- describe the user and purpose of the required
system.
- give a detailed description of the required hardware for the system.
- give a detailed description of the required software for the system.
- identify a suitable operating system for the required system.
Task:
- Read the scenario carefully.
- Complete this worksheet.
- Save the worksheet in your unit 13 ao1 folder as
UserRequirements
|
Info:
- In this task you will:
- explain the user and purpose of the required system.
- give a detailed description of the required hardware for the system
with justification of choices given.
- give a detailed description of the required software for the system
with justification of choices given.
- identify a suitable operating system for the required system with
justification of the choice given.
Task:
- Read the scenario carefully.
- Complete this worksheet.
- Save the worksheet in your unit 13 ao1 folder as
UserRequirements
|
AO2 - Spec a computer system connected to the internet
|
| |
Pass |
Merit |
Distinction |
| |
Candidates use the internet or a
specialist computer magazine to obtain one quote for a suitable computer meeting
some of the identified hardware/software requirements.
|
Candidates use the internet or a
specialist computer magazine to obtain two quotes for a suitable computer
meeting most of the identified hardware/software requirements.
The quotes are presented in a table to allow them to be compared.
Candidates make a recommendation for the computer to be selected. |
Candidates use the internet or a
specialist computer magazine to obtain two quotes for a suitable computer
meeting all of the identified hardware/software requirements.
The quotes are presented clearly in a table to allow them to be compared.
Candidates make a recommendation for the computer to be selected, justifying
their choices. |
| E |
Info:
- In this task you will research and find a quote that will meet some of
the identified hardware and software requirements.
Task:
- Using either a magazine or an online store such as
PcWorld,
Ebuyer,
Dabs, Scan,
Novatech to find a computer that
meets some of the identified hardware and software requirements.
- If you use an online store you will either need to add all the items to
your basket and print screen this as evidence or print of the individual
product pages to build a quote.
|
Info:
- In this task you will research and find two quotes that will meet most
of the identified hardware/software requirements.
Task:
- Using either a magazine or an online store such as
PcWorld,
Ebuyer,
Dabs, Scan,
Novatech to find two computers that
meet most of the identified hardware and software requirements.
- If you use an online store you will either need to add all the items to
your basket and print screen this as evidence or print of the individual
product pages to build a quote.
|
Info:
- In this task you will research and find two quotes that will meet all of
the identified hardware/software requirements.
Task:
- Using either a magazine or an online store such as
PcWorld,
Ebuyer,
Dabs, Scan,
Novatech to find two computers that
meet all of the identified hardware and software requirements.
- If you use an online store you will either need to add all the items to
your basket and print screen this as evidence or print of the individual
product pages to build a quote.
|
| F |
|
Info:
- In this task you will present the quotes in a table to allow them to be
compared.
Task:
- Use this worksheet to present your quotes in a table.
- Save the worksheet in your unit 13 ao2 folder as
QuotesCompared
|
Info:
- In this task you will present the quotes clearly in a table to allow
them to be compared.
Task:
- Use this worksheet to present your quotes in a table.
- Save the worksheet in your unit 13 ao2 folder as
QuotesCompared
|
| G |
|
Info:
- In this task you will make a recommendation for the computer to be
selected.
Task:
- Use this worksheet to make your recommendation.
- Save the worksheet in your unit 13 ao2 folder as
QuoteRecommended
|
Info:
- In this task you will make a recommendation for the computer to be
selected and justify your choice.
Task:
- Use this worksheet to make your recommendation and justify your choice.
- Save the worksheet in your unit 13 ao2 folder as
QuoteRecommended
|
AO3 - Configure the operating system.
|
| |
Pass |
Merit |
Distinction |
| |
Candidates configure the operating
system in at least four different ways.
Most configuration changes are appropriate to user needs.
|
Candidates configure the operating
system in at least five different ways.
For most of the configuration changes, candidates will explain why they are
appropriate to user needs. |
Candidates configure the operating
system in at least six different ways.
They will explain why the configuration changes are appropriate to user needs. |
| H |
Info:
- In this task you will learn how to make configurations to the operating system
to meet the needs of a user.
- You will need administrative access to the Control Panel to make
operating system changes. (To complete this task you will need to log on as
a computer administrator.)
Task:
- Make four operating system configurations appropriate for the
user needs.
- e.g. Mouse Settings, screen saver, screen resolution, time zone.
- Print screen a before and after shot to evidence each the changes.
- Paste the print screens into a new word document and save this into your
unit 13 ao3 folder as OSChanges
|
Info:
- In this task you will learn how to make configurations to the operating system
to meet the needs of a user.
- You will need administrative access to the Control Panel to make
operating system changes. (To complete this task you will need to log on as
a computer administrator.)
Task:
- Make five operating system configurations appropriate for the
user needs.
- e.g. Mouse Settings, screen saver, screen resolution, time zone.
- Print screen a before and after shot to evidence each the changes.
- Paste the print screens into a new word document and save this into your
unit 13 ao3 folder as OSChanges
|
Info:
- In this task you will learn how to make configurations to the operating system
to meet the needs of a user.
- You will need administrative access to the Control Panel to make
operating system changes. (To complete this task you will need to log on as
a computer administrator.)
Task:
- Make six operating system configurations appropriate for the
user needs.
- e.g. Mouse Settings, screen saver, screen resolution, time zone.
- Print screen a before and after shot to evidence each the changes.
- Paste the print screens into a new word document and save this into your
unit 13 ao3 folder as OSChanges
|
| I |
|
Info:
- In this task you will explain why most of the OS configurations are
appropriate.
Task:
- Using the sheet you used in the previous task annotate most of the print
screens to explain why they are appropriate configurations.
|
Info:
- In this task you will explain why all of the OS configurations are
appropriate.
Task:
- Using the sheet you used in the previous task annotate most of the print
screens to explain why they are appropriate configurations.
|
AO4 - Configure applications software.
|
| |
Pass |
Merit |
Distinction |
| |
Candidates carry out at least four
different configurations on one or more types of applications software.
Most configuration changes are appropriate to user needs.
|
Candidates carry out at least five
different configurations on one or more types of applications software.
For most of the configuration changes, candidates will explain why they are
appropriate to user needs. |
Candidates carry out at least five
different configurations on at least two different types of applications
software.
They will explain why the configuration changes are appropriate to user needs. |
| J |
Info:
- In this task you will learn how to make configurations to applications
software (e.g. Excel, Word, Photoshop etc)
to meet the needs of a user.
Task:
- Make four application configurations appropriate for the
user needs.
- e.g. Autosave time, autosave location, developer tab, default file
format.
- Print screen a before and after shot to evidence each the changes.
- Paste the print screens into a new word document and save this into your
unit 13 ao3 folder as ApplicationChanges
|
Info:
- In this task you will learn how to make configurations to applications
software (e.g. Excel, Word, Photoshop etc)
to meet the needs of a user.
Task:
- Make five application configurations appropriate for the
user needs.
- e.g. Autosave time, autosave location, developer tab, default file
format.
- Print screen a before and after shot to evidence each the changes.
- Paste the print screens into a new word document and save this into your
unit 13 ao3 folder as ApplicationChanges
|
Info:
- In this task you will learn how to make configurations to applications
software (e.g. Excel, Word, Photoshop etc)
to meet the needs of a user.
Task:
- Make five application configurations appropriate for the
user needs on at least two different types of application software.
- e.g. Autosave time, autosave location, developer tab, default file
format.
- Print screen a before and after shot to evidence each the changes.
- Paste the print screens into a new word document and save this into your
unit 13 ao3 folder as ApplicationChanges
|
| K |
|
Info:
- In this task you will explain why most of the application configurations are
appropriate.
Task:
- Using the sheet you used in the previous task annotate most of the print
screens to explain why they are appropriate configurations.
|
Info:
- In this task you will explain why all of the application configurations are
appropriate.
Task:
- Using the sheet you used in the previous task annotate most of the print
screens to explain why they are appropriate configurations.
|
AO5 - Create and edit macros to meet the needs of a user
|
| |
Pass |
Merit |
Distinction |
| |
Candidates record a macro to automate a
sequence of tasks and use one method to activate the macro.
The macro functions as intended.
|
Candidates record a macro to automate a
sequence of tasks in each of two different types of applications software.
They will use two different methods to activate their macros.
The macro functions as intended. |
Candidates record a macro to automate a
sequence of tasks in each of two different types of applications software.
They will use three different methods to activate their macros.
The macro functions as intended.
Candidates will edit the code to change the function of the macro. |
| L |
Info:
- In this task you create a macro that automates a sequence of tasks and
is activated using two methods.
Task:
- Open a blank new excel sheet
- Check you have the developer tab
- Record a new macro:
- Name: Spellsave
- Keyboard shortcut : Ctrl+Shift+S
- Description: your name
- You macro must:
- spell-check the spreadsheet & save the spreadsheet as
spellsave.xlsm (File Type: Excel Marco Enabled Workbook.
- Stop the recording
- View & print the macro code
- Close the code and return to the spreadsheet
- Insert a picture into the spreadsheet and right click and assign the
spellsave macro to it (so it is activated when the user
clicks on it)
- Create print screen evidence showing you have assigned the macro and
paste it into a new word document.
- Print the evidence
- Save the spreadsheet as an excel macro enabled worksheet
called SpellSave.xlsm in your unit 13 ao5
folder
|
Info:
- In this task you create a macro that automates a sequence of tasks and
is activated using two methods.
Task:
- Open a blank new excel sheet
- Check you have the developer tab
- Record a new macro:
- Name: Spellsave
- Keyboard shortcut : Ctrl+Shift+S
- Description: your name
- You macro must:
- spell-check the spreadsheet & save the spreadsheet as
spellsave.xlsm (File Type: Excel Marco Enabled Workbook.
- Stop the recording
- View & print the macro code
- Close the code and return to the spreadsheet
- Insert a picture into the spreadsheet and right click and assign the
spellsave macro to it (so it is activated when the user
clicks on it)
- Create print screen evidence showing you have assigned the macro and
paste it into a new word document.
- Print the evidence
- Save the spreadsheet as an excel macro enabled worksheet
called SpellSave.xlsm in your unit 13 ao5
folder
|
Info:
- In this task you create a macro that automates a sequence of tasks and
is activated using two methods.
Task:
- Open a blank new excel sheet
- Check you have the developer tab
- Record a new macro:
- Name: Spellsave
- Keyboard shortcut : Ctrl+Shift+S
- Description: your name
- You macro must:
- spell-check the spreadsheet & save the spreadsheet as
spellsave.xlsm (File Type: Excel Marco Enabled Workbook.
- Stop the recording
- View & print the macro code
- Close the code and return to the spreadsheet
- Insert a picture into the spreadsheet and right click and assign the
spellsave macro to it (so it is activated when the user
clicks on it)
- Create print screen evidence showing you have assigned the macro and
paste it into a new word document.
- Print the evidence
- Save the spreadsheet as an excel macro enabled worksheet
called SpellSave.xlsm in your unit 13 ao5
folder
|
| M |
|
Info:
- In this task you will create a macro that automates a sequence of tasks
and is activated using two methods.
Task:
- Open a blank new word document sheet
- Check you have the developer tab
- Record a new macro:
- Name: Footprint
- Keyboard shortcut : Ctrl+Shift+F
- Description: your name
- You macro must:
- Insert a footer into the document containing fields for date,
filename & page number & print the document (ignore any error message)
- Stop the recording
- View & print the macro code
- Close the code and return to the spreadsheet
Insert a button on the QAT (Quick access toolbar) and assign the footprint
macro to it (so it is activated when the user clicks on it)
- Create print screen evidence showing you have added the macro to the QAT
and paste it into a new word document.
- Print the evidence
- Save the document as an word macro enabled worksheet
called FootPrint.docm in your unit 13 ao5
folder
|
Info:
- In this task you will create a macro that automates a sequence of tasks
and is activated using two methods.
Task:
- Open a blank new word document sheet
- Check you have the developer tab
- Record a new macro:
- Name: Footprint
- Keyboard shortcut : Ctrl+Shift+F
- Description: your name
- You macro must:
- Insert a footer into the document containing fields for date,
filename & page number & print the document (ignore any error message)
- Stop the recording
- View & print the macro code
- Close the code and return to the spreadsheet
Insert a button on the QAT (Quick access toolbar) and assign the footprint
macro to it (so it is activated when the user clicks on it)
- Create print screen evidence showing you have added the macro to the QAT
and paste it into a new word document.
- Print the evidence
- Save the document as an word macro enabled worksheet
called FootPrint.docm in your unit 13 ao5
folder
|
| N |
|
|
Info:
- In this task you will edit the code to change the function of the macro
Task:
- Open Spellsave.xlsm
- View the macro code
- Edit the code to change the location of where the macro saves the
document
- Print the code
- Save the spreadsheet as an excel macro enabled worksheet
called SpellSave2.xlsm in your unit 13 ao5
folder
|
AO6 - Understand and carry out simple backup procedures
|
| |
Pass |
Merit |
Distinction |
| |
Candidates explain basic backup
procedures.
Candidates carry out one backup procedure. |
Candidates explain a range of backup
procedures using some correct terminology.
Candidates carry out a range of backup procedures. |
Candidates explain a wide range of
backup procedures using correct terminology.
Candidates carry out a wide range of backup procedures and explain their choice
of backup procedure. |
| O |
Info:
- In this task you will learn and explain backup procedures.
Task:
- Complete this worksheet
- Save the worksheet in your unit 13 ao6 folder as
backupprocedures
|
Info:
- In this task you will learn and explain a range of backup procedures
using some correct terminology.
Task:
- Complete this worksheet
- Explain full, incremental, explain differential backup
- Backup locations
- Save the worksheet in your unit 13 ao6 folder as
backupprocedures
|
Info:
- In this task you will learn and explain a wide range of backup
procedures using some correct terminology.
Task:
- Complete this worksheet
- Explain full, incremental, explain differential backup
- Backup locations
- backup patterns such as frequency, grandfather-father-son backup
- backup file names (logical naming/dating system)
- Save the worksheet in your unit 13 ao6 folder as
backupprocedures
|
| P |
Info:
- In this task you will carry out a backup procedures.
Task:
- You need to carry out one simple backup procedure.
- e.g. simple file copy to USB backup, automatic MS-Office file
duplication, email file to a friend, windows backup utility, backup to
DVD
- Print screen evidence and save it in this
worksheet
- Save the worksheet in your unit 13 ao6 folder as
backupevidence
|
Info:
- In this task you will carry out a range of backup procedures.
Task:
- You need to carry out three backup procedures.
- e.g. simple file copy to USB backup, automatic MS-Office file
duplication, email file to a friend, windows backup utility, backup to
DVD
- Print screen evidence and save it in this
worksheet
- Save the worksheet in your unit 13 ao6 folder as
backupevidence
|
Info:
- In this task you will carry out a wide range of backup procedures and
explain your choices of backup procedure.
Task:
- To achieve Distinction level you need to carry out five backup
procedures, explaining your choices
- e.g. simple file copy to USB backup, automatic MS-Office file
duplication, email file to a friend, windows backup utility, backup to
DVD
- Print screen evidence and save it in this
worksheet
- Save the worksheet in your unit 13 ao6 folder as
backupevidence
|
