13I Period 1 Tuesday 15th May 2012

Please click on this LINK and complete the SURVEY QUESTIONS.

STARTER

What do you know about Spreadsheets?  Click HERE to find out.

Activity Brief 2: University Budget (READ)

Your Grandparents decided that they would like to support you financially while you are at university.  They have asked you to investigate and compare the sources of income and levels of expenditure that you could incur for university courses which you are interested in applying for.  Also, they would like you calculate the difference between your income and your expenditure for each university and make it clear whether or not you can afford to attend.  When you have completed your research and calculations, they would like you to feed back your results to them in the form of a short letter

The following people have not provided me with a NON ICT SOURCE –  ALEX, ELLIE and BINA.  This could be a photocopy of a relevant part of a university prospectus.  The portfolio will fail without this document.

Task 1 Searching for Budget Information.

(LUCY A)

1. The information that you include in your budget could come from many different sources. It could include;

information found on websites

information found in a university prospectus (non-ict)

information found in books (non-ict)

“A Guide to financial Support for Higher Education Students” (non-ict, found in the IT Room)

1. Finding information for your leaflet is a good opportunity to make use of non-ict sources, at least one non-ict source should be included in your portfolio. Take photocopies or scan relevant non-ict sources.
2. You need to take a screen shot of searches you make to find information for your budget. These searches should be multiple criteria searches separated by quotes “” plus “and”. For example, to look for information about available grants at university the search would be; “University” and “Undergraduate” and “grants”
3. Take screenshots of your search results
4. Also, take screenshots of the actual websites and information found on webpages that you will actually use in your budget – you do not have to do this for every piece of information but make sure there is at least one example.

REMEMBER – A template can be found in the share area to help you with this task – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\Activity 2\2 Budget. It is called SEARCHING FOR BUDGET INFORMATION LTM.

TASK 2– Development of number

(IZZY and LUCY A)

You need to have three print outs of your spreadsheet (make sure your name appears in the header of all printouts).  Check print preview and make sure your printouts are on one page.  Click here to find out how.

3 Printouts;

1. An intermediate stage for your spreadsheet – this should include all of the main data for your spreadsheet but leave the calculations blank at the moment.  Annotate this printout to indicate what you are going to do next.
2. A finished spreadsheet which displays formulas, grid lines and row and column headings. Click here to find out how
3. A finished spreadsheet which displays the results as normal

=if and charts

1. Development of number: You will need to add an =if function to indicate whether you are over or under budget.-Click here for help on =if
2. You will also need to add a chart to your spreadsheet;
   • this could be a bar chart to  show the total expenditure by university or
   • a pie chart giving a break down of expenditure
   • click here for help with charts

REMEMBER – A template can be found in the share area to help you with this task – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\Activity 2\2 Budget.  It is called EXPENDITURE LTM. 

TASK 3 Development of Text (DRAFT LETTER and FINAL LETTER)

(LUCY A and BINA)

1. You need to write a first draft, outline letter to your grandparents.  This outline letter should;
   • be left aligned
   • show original errors, spelling or grammatical
   • be one long paragraph
   • be unformatted
   • not include any information from your spreadsheet
2. Print out this letter and annotate to show the changes you are going to make.  You will probably want to change;
   • the alignment of some elements
   • any spelling or grammatical mistakes (capital letters etc.)
   • one long paragraph into shorter ones
   • format various parts of the letter (bold, italic, font size etc.)
   • add in data from your spreadsheet
3. This will show that you have developed the text in your letter.
4. You could attach this finished letter to an email and send this to your grandparents – another use of purposeful email.

REMEMBER – A template can be found in the share area to help you with this task – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\Activity 2\3 Letter.  It is called DRAFT LETTER LTM. 

TASK 4 Contents Page

(IZZY, LUCY A and BINA)

Please use the following list as a check list for your contents page:

ACTIVITY 1 – UNIVERSITY LEAFLET

1. Plan for Activity 1.
2. Searching for Pictures - complex search, relevant hits / results, selection of images with URLs / web addresses.
3. Developing Pictures - at least 2, original image with URL / web address, improved image produced in Photoshop, explain what you have done to the images.
4. Searching for Text - complex search, relevant hits / results, selection of text with URLs / web addresses.
5. Developing Text - original text with URL / web address, improved text (only use SOME) but make sure that you REWORD IT!!!
6. NON ICT SOURCE - Photocopy from university prospectus with highlighting of relevant text. NOT copied from the INTERNET!!!
7. FIRST DRAFT of University Leaflet - 2 sides of A4 in booklet format, including undeveloped images and text.
8. Purposeful Use of Email - word screenshot document, email screenshot with first draft of university leaflet attached asking for advice / help about improving your leaflet.
9. FINAL Black and White copy of University Leaflet - needs to be checked, spelling, grammar, include improved / developed images and text.
10. FINAL Colour copy of University Leaflet.

ACTIVITY 2 – BUDGET LETTER

1. Plan for Activity 2.
2. Searching for Budget Information – complex search, relevant hits / results selection of text with URLs / web addresses.
3. DRAFT / Outline Budget Spreadsheet - Income section, Expenditure section, Balance, What if analysis (If Function – Can I afford this? – ONLY LABELS!!!
4. FINAL Budget Spreadsheet FORMATTING COPY - all sections showing figures.
5. FINAL Budget Spreadsheet FORMULAE COPY - all sections showing formulae used.
6. CHART – displaying e.g. expenditure at first choice university.
7. DRAFT Letter to Grandparents - unformatted text (no addresses, no spreadsheet data, no chart)
8. FINAL Letter to Grandparents - formatted text (addresses, spreadsheet date and chart data)

TASK 5 Folder Structure

(IZZY, LUCY A and BINA)

You need to create a folder structuredocument to provide evidence that an electonic version of your portfolio exists.

Open Word and create a document entitled Folder Structure.  You will need to show a number of screenshots from your network area.

• Screenshot 1 – Your area showing a Key Skills folder.
• Screenshot 2 - Your Key Skills folder showing an Activity 1 (UNI LEAFLET) folder and Activity 2 (BUDGET LETTER) folder.
• Screenshot 3 – Your Activity 1 folder showing the relevent files for activity 1.
• Screenshot 4 – Your Activity 2 folder showing the relevent files for activity 2.

FINALLY… (IZZY, LUCY A and BINA)

You need to sign and date your cover sheet.  BLACK INK PLEASE!!!

13I Period 1 Tuesday 1st May 2012

Please click on this LINK and complete the SURVEY QUESTIONS.

STARTER

What do you know about Spreadsheets?  Click HERE to find out.

Activity Brief 2: University Budget (READ)

Your Grandparents decided that they would like to support you financially while you are at university.  They have asked you to investigate and compare the sources of income and levels of expenditure that you could incur for university courses which you are interested in applying for.  Also, they would like you calculate the difference between your income and your expenditure for each university and make it clear whether or not you can afford to attend.  When you have completed your research and calculations, they would like you to feed back your results to them in the form of a short letter

The following people have not provided me with a NON ICT SOURCE –  SOPHIE, ALEX, ELLIE and BINA.  This could be a photocopy of a relevant part of a university prospectus.  The portfolio will fail without this document.

Task 1 Searching for Budget Information.

(BINA and LUCY A)

1. The information that you include in your budget could come from many different sources. It could include;

information found on websites

information found in a university prospectus (non-ict)

information found in books (non-ict)

“A Guide to financial Support for Higher Education Students” (non-ict, found in the IT Room)

1. Finding information for your leaflet is a good opportunity to make use of non-ict sources, at least one non-ict source should be included in your portfolio. Take photocopies or scan relevant non-ict sources.
2. You need to take a screen shot of searches you make to find information for your budget. These searches should be multiple criteria searches separated by quotes “” plus “and”. For example, to look for information about available grants at university the search would be; “University” and “Undergraduate” and “grants”
3. Take screenshots of your search results
4. Also, take screenshots of the actual websites and information found on webpages that you will actually use in your budget – you do not have to do this for every piece of information but make sure there is at least one example.

REMEMBER – A template can be found in the share area to help you with this task – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\Activity 2\2 Budget. It is called SEARCHING FOR BUDGET INFORMATION LTM.

TASK 2– Development of number

(IZZY, ALEX, LUCY A, BINA and ALICE D)

You need to have three print outs of your spreadsheet (make sure your name appears in the header of all printouts).  Check print preview and make sure your printouts are on one page.  Click here to find out how.

3 Printouts;

1. An intermediate stage for your spreadsheet – this should include all of the main data for your spreadsheet but leave the calculations blank at the moment.  Annotate this printout to indicate what you are going to do next.
2. A finished spreadsheet which displays formulas, grid lines and row and column headings. Click here to find out how
3. A finished spreadsheet which displays the results as normal

=if and charts

1. Development of number: You will need to add an =if function to indicate whether you are over or under budget.-Click here for help on =if
2. You will also need to add a chart to your spreadsheet;
   • this could be a bar chart to  show the total expenditure by university or
   • a pie chart giving a break down of expenditure
   • click here for help with charts

REMEMBER – A template can be found in the share area to help you with this task – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\Activity 2\2 Budget.  It is called EXPENDITURE LTM. 

TASK 3 Development of Text (DRAFT LETTER and FINAL LETTER)

(ALICE D, IZZY, ALEX, LUCY A and BINA)

1. You need to write a first draft, outline letter to your grandparents.  This outline letter should;
   • be left aligned
   • show original errors, spelling or grammatical
   • be one long paragraph
   • be unformatted
   • not include any information from your spreadsheet
2. Print out this letter and annotate to show the changes you are going to make.  You will probably want to change;
   • the alignment of some elements
   • any spelling or grammatical mistakes (capital letters etc.)
   • one long paragraph into shorter ones
   • format various parts of the letter (bold, italic, font size etc.)
   • add in data from your spreadsheet
3. This will show that you have developed the text in your letter.
4. You could attach this finished letter to an email and send this to your grandparents – another use of purposeful email.

REMEMBER – A template can be found in the share area to help you with this task – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\Activity 2\3 Letter.  It is called DRAFT LETTER LTM. 

TASK 4 Contents Page

(ELLIE,  IMMY, LORNA, LAUREN, ALEX, ALICE D, IZZY, LUCY A and BINA)

Please use the following list as a check list for your contents page:

ACTIVITY 1 – UNIVERSITY LEAFLET

1. Plan for Activity 1.
2. Searching for Pictures - complex search, relevant hits / results, selection of images with URLs / web addresses.
3. Developing Pictures - at least 2, original image with URL / web address, improved image produced in Photoshop, explain what you have done to the images.
4. Searching for Text - complex search, relevant hits / results, selection of text with URLs / web addresses.
5. Developing Text - original text with URL / web address, improved text (only use SOME) but make sure that you REWORD IT!!!
6. NON ICT SOURCE - Photocopy from university prospectus with highlighting of relevant text. NOT copied from the INTERNET!!!
7. FIRST DRAFT of University Leaflet - 2 sides of A4 in booklet format, including undeveloped images and text.
8. Purposeful Use of Email - word screenshot document, email screenshot with first draft of university leaflet attached asking for advice / help about improving your leaflet.
9. FINAL Black and White copy of University Leaflet - needs to be checked, spelling, grammar, include improved / developed images and text.
10. FINAL Colour copy of University Leaflet.

ACTIVITY 2 – BUDGET LETTER

1. Plan for Activity 2.
2. Searching for Budget Information – complex search, relevant hits / results selection of text with URLs / web addresses.
3. DRAFT / Outline Budget Spreadsheet - Income section, Expenditure section, Balance, What if analysis (If Function – Can I afford this? – ONLY LABELS!!!
4. FINAL Budget Spreadsheet FORMATTING COPY - all sections showing figures.
5. FINAL Budget Spreadsheet FORMULAE COPY - all sections showing formulae used.
6. CHART – displaying e.g. expenditure at first choice university.
7. DRAFT Letter to Grandparents - unformatted text (no addresses, no spreadsheet data, no chart)
8. FINAL Letter to Grandparents - formatted text (addresses, spreadsheet date and chart data)

TASK 5 Folder Structure

(ELLIE, IMMY, LAUREN, ALEX, ALICE D, IZZY, LUCY A, BINA and LORNA)

You need to create a folder structuredocument to provide evidence that an electonic version of your portfolio exists.

Open Word and create a document entitled Folder Structure.  You will need to show a number of screenshots from your network area.

• Screenshot 1 – Your area showing a Key Skills folder.
• Screenshot 2 - Your Key Skills folder showing an Activity 1 (UNI LEAFLET) folder and Activity 2 (BUDGET LETTER) folder.
• Screenshot 3 – Your Activity 1 folder showing the relevent files for activity 1.
• Screenshot 4 – Your Activity 2 folder showing the relevent files for activity 2.

FINALLY… (SOPHIE)

You need to sign and date your cover sheet.  BLACK INK PLEASE!!!

13I Period 1 Tuesday 27th March 2012

STARTER

What do you know about Spreadsheets?  Click HERE to find out. 

Activity Brief 2: University Budget (READ)

Your Grandparents decided that they would like to support you financially while you are at university.  They have asked you to investigate and compare the sources of income and levels of expenditure that you could incur for university courses which you are interested in applying for.  Also, they would like you calculate the difference between your income and your expenditure for each university and make it clear whether or not you can afford to attend.  When you have completed your research and calculations, they would like you to feed back your results to them in the form of a short letter

The following people have not provided me with a NON ICT SOURCE –  ALEX, ELLIE and BINA.  This could be a photocopy of a relevant part of a university prospectus.  The portfolio will fail without this document.

TASK 1 – Planning for activity 2 – (BINA)

1. Taking into consideration the activity brief for the letter to you grandparents, you need to plan what you are going to do. This could be in the form of bullet points or 4 or 5 brief paragraphs.
2. Plan logically and in chronological order. What do you need to do to complete the activity and in which order are you going to complete the tasks? Use the outline of tasks as a starting point and expand on these as necessary.
3. Try to plan and focus on the ICT elements which you will need to complete – cover the bullet points below.

Finding Information

What information do you need to find?

How will you find it? ICT Sources, Non-ICT Sources, Both?

If you are going to use a search engine, which one will you use and which key words will you use for your search?

How will you judge the quality and reliability of the information you find? Is it a reliable source? Think about the author, the date the information was updated, the URL (web address) etc.

Where will you go to find non-ICT sources of information?

How will you get the non-ICT source into your portfolio?

How will you decide whether the information you find is useful and/or relevant for your work?

Developing your information and deriving new information

How do you plan to develop any pictures, text or numbers in your work?

Which software will you use and why?

Which features of the software will you use to develop your information or derive new information?

Break down the different stages of your spreadsheet development.

You need to explain which functions you are going to use to develop your numbers and why.

If you are going to include a chart, make sure you plan what it will show and what type of chart it is going to be.

How do you plan to take into account the views of others?

Presenting combined information

Which software will you use to combine your information for the final output? Why?

Which features of the software will you use?

How will you plan to ensure that your work is accurate?

How will you plan to ensure that your is presented consistently?

Which hardware will you use for your final output?

REMEMBER – A template can be found in the share area to help you with this task – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\Activity 2\1 Planning. It is called PLANNING LTM.

Task 2 Searching for Budget Information.

(BINA and LUCY A)

1. The information that you include in your budget could come from many different sources. It could include;

information found on websites

information found in a university prospectus (non-ict)

information found in books (non-ict)

“A Guide to financial Support for Higher Education Students” (non-ict, found in the IT Room)

1. Finding information for your leaflet is a good opportunity to make use of non-ict sources, at least one non-ict source should be included in your portfolio. Take photocopies or scan relevant non-ict sources.
2. You need to take a screen shot of searches you make to find information for your budget. These searches should be multiple criteria searches separated by quotes “” plus “and”. For example, to look for information about available grants at university the search would be;
   “University” and “Undergraduate” and “grants”
3. Take screenshots of your search results
4. Also, take screenshots of the actual websites and information found on webpages that you will actually use in your budget – you do not have to do this for every piece of information but make sure there is at least one example.

REMEMBER – A template can be found in the share area to help you with this task – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\Activity 2\2 Budget. It is called SEARCHING FOR BUDGET INFORMATION LTM.

TASK 3 – Development of number

(LAUREN, ELLIE, IMMY, ALICE D, IZZY, ALEX, LUCY A, BINA and LORNA)

You need to have three print outs of your spreadsheet (make sure your name appears in the header of all printouts).  Check print preview and make sure your printouts are on one page.  Click here to find out how.

3 Printouts;

1. An intermediate stage for your spreadsheet – this should include all of the main data for your spreadsheet but leave the calculations blank at the moment.  Annotate this printout to indicate what you are going to do next.
2. A finished spreadsheet which displays formulas, grid lines and row and column headings. Click here to find out how
3. A finished spreadsheet which displays the results as normal

=if and charts

1. Development of number: You will need to add an =if function to indicate whether you are over or under budget.-Click here for help on =if
2. You will also need to add a chart to your spreadsheet;
   • this could be a bar chart to  show the total expenditure by university or
   • a pie chart giving a break down of expenditure
   • click here for help with charts

 

REMEMBER – A template can be found in the share area to help you with this task – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\Activity 2\2 Budget.  It is called EXPENDITURE LTM. 

TASK 4 Development of Text (DRAFT LETTER and FINAL LETTER)

1. You need to write a first draft, outline letter to your grandparents.  This outline letter should;
   • be left aligned
   • show original errors, spelling or grammatical
   • be one long paragraph
   • be unformatted
   • not include any information from your spreadsheet
2. Print out this letter and annotate to show the changes you are going to make.  You will probably want to change;
   • the alignment of some elements
   • any spelling or grammatical mistakes (capital letters etc.)
   • one long paragraph into shorter ones
   • format various parts of the letter (bold, italic, font size etc.)
   • add in data from your spreadsheet
3. This will show that you have developed the text in your letter.
4. You could attach this finished letter to an email and send this to your grandparents – another use of purposeful email.

REMEMBER – A template can be found in the share area to help you with this task – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\Activity 2\3 Letter.  It is called DRAFT LETTER LTM. 

TASK 5 Contents Page

Please use the following list as a check list for your contents page:

ACTIVITY 1 – UNIVERSITY LEAFLET

1. Plan for Activity 1. 
2. Searching for Pictures - complex search, relevant hits / results, selection of images with URLs / web addresses.
3. Developing Pictures - at least 2, original image with URL / web address, improved image produced in Photoshop, explain what you have done to the images.
4. Searching for Text - complex search, relevant hits / results, selection of text with URLs / web addresses.
5. Developing Text - original text with URL / web address, improved text (only use SOME) but make sure that you REWORD IT!!!
6. NON ICT SOURCE - Photocopy from university prospectus with highlighting of relevant text. NOT copied from the INTERNET!!!
7. FIRST DRAFT of University Leaflet - 2 sides of A4 in booklet format, including undeveloped images and text.
8. Purposeful Use of Email - word screenshot document, email screenshot with first draft of university leaflet attached asking for advice / help about improving your leaflet.
9. FINAL Black and White copy of University Leaflet - needs to be checked, spelling, grammar, include improved / developed images and text.
10. FINAL Colour copy of University Leaflet.

ACTIVITY 2 – BUDGET LETTER

1. Plan for Activity 2. 
2. Searching for Budget Information – complex search, relevant hits / results selection of text with URLs / web addresses.
3. DRAFT / Outline Budget Spreadsheet - Income section, Expenditure section, Balance, What if analysis (If Function – Can I afford this? – ONLY LABELS!!!
4. FINAL Budget Spreadsheet FORMATTING COPY - all sections showing figures.
5. FINAL Budget Spreadsheet FORMULAE COPY - all sections showing formulae used.
6. CHART – displaying e.g. expenditure at first choice university.
7. DRAFT Letter to Grandparents - unformatted text (no addresses, no spreadsheet data, no chart)
8. FINAL Letter to Grandparents - formatted text (addresses, spreadsheet date and chart data)

TASK 6 Folder Structure

You need to create a folder structuredocument to provide evidence that an electonic version of your portfolio exists. 

Open Word and create a document entitled Folder Structure.  You will need to show a number of screenshots from your network area. 

• Screenshot 1 – Your area showing a Key Skills folder. 
• Screenshot 2 - Your Key Skills folder showing an Activity 1 (UNI LEAFLET) folder and Activity 2 (BUDGET LETTER) folder. 
• Screenshot 3 – Your Activity 1 folder showing the relevent files for activity 1.
• Screenshot 4 – Your Activity 2 folder showing the relevent files for activity 2. 

FINALLY…

You need to sign and date your cover sheet.  BLACK INK PLEASE!!!

13I Period 1 Tuesday 13th March 2012

STARTER

What do you know about Spreadsheets?  Click HERE to find out. 

Activity Brief 2: University Budget (READ)

Your Grandparents decided that they would like to support you financially while you are at university.  They have asked you to investigate and compare the sources of income and levels of expenditure that you could incur for university courses which you are interested in applying for.  Also, they would like you calculate the difference between your income and your expenditure for each university and make it clear whether or not you can afford to attend.  When you have completed your research and calculations, they would like you to feed back your results to them in the form of a short letter

The following people have not provided me with a NON ICT SOURCE – SOPHIE, ALEX, ELLIE and BINA.  This could be a photocopy of a relevant part of a university prospectus.  The portfolio will fail without this document.

TASK 1 – Planning for activity 2 – (BINA)

1. Taking into consideration the activity brief for the letter to you grandparents, you need to plan what you are going to do. This could be in the form of bullet points or 4 or 5 brief paragraphs.
2. Plan logically and in chronological order. What do you need to do to complete the activity and in which order are you going to complete the tasks? Use the outline of tasks as a starting point and expand on these as necessary.
3. Try to plan and focus on the ICT elements which you will need to complete – cover the bullet points below.

Finding Information

What information do you need to find?

How will you find it? ICT Sources, Non-ICT Sources, Both?

If you are going to use a search engine, which one will you use and which key words will you use for your search?

How will you judge the quality and reliability of the information you find? Is it a reliable source? Think about the author, the date the information was updated, the URL (web address) etc.

Where will you go to find non-ICT sources of information?

How will you get the non-ICT source into your portfolio?

How will you decide whether the information you find is useful and/or relevant for your work?

Developing your information and deriving new information

How do you plan to develop any pictures, text or numbers in your work?

Which software will you use and why?

Which features of the software will you use to develop your information or derive new information?

Break down the different stages of your spreadsheet development.

You need to explain which functions you are going to use to develop your numbers and why.

If you are going to include a chart, make sure you plan what it will show and what type of chart it is going to be.

How do you plan to take into account the views of others?

Presenting combined information

Which software will you use to combine your information for the final output? Why?

Which features of the software will you use?

How will you plan to ensure that your work is accurate?

How will you plan to ensure that your is presented consistently?

Which hardware will you use for your final output?

REMEMBER – A template can be found in the share area to help you with this task – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\Activity 2\1 Planning. It is called PLANNING LTM.

Task 2 Searching for Budget Information. (BINA and LUCY A)

1. The information that you include in your budget could come from many different sources. It could include;

information found on websites

information found in a university prospectus (non-ict)

information found in books (non-ict)

“A Guide to financial Support for Higher Education Students” (non-ict, found in the IT Room)

1. Finding information for your leaflet is a good opportunity to make use of non-ict sources, at least one non-ict source should be included in your portfolio. Take photocopies or scan relevant non-ict sources.
2. You need to take a screen shot of searches you make to find information for your budget. These searches should be multiple criteria searches separated by quotes “” plus “and”. For example, to look for information about available grants at university the search would be;
   “University” and “Undergraduate” and “grants”
3. Take screenshots of your search results
4. Also, take screenshots of the actual websites and information found on webpages that you will actually use in your budget – you do not have to do this for every piece of information but make sure there is at least one example.

REMEMBER – A template can be found in the share area to help you with this task – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\Activity 2\2 Budget. It is called SEARCHING FOR BUDGET INFORMATION LTM.

TASK 3 – Development of number (LAUREN, ELLIE, IMMY, ALICE D, IZZY, ALEX and LORNA)

(ALICE W and SOPHIE there are some errors in your spreadsheet formulae). 

You need to have three print outs of your spreadsheet (make sure your name appears in the header of all printouts).  Check print preview and make sure your printouts are on one page.  Click here to find out how.

3 Printouts;

1. An intermediate stage for your spreadsheet – this should include all of the main data for your spreadsheet but leave the calculations blank at the moment.  Annotate this printout to indicate what you are going to do next.
2. A finished spreadsheet which displays formulas, grid lines and row and column headings. Click here to find out how
3. A finished spreadsheet which displays the results as normal

=if and charts

1. Development of number: You will need to add an =if function to indicate whether you are over or under budget.-Click here for help on =if
2. You will also need to add a chart to your spreadsheet;
   • this could be a bar chart to  show the total expenditure by university or
   • a pie chart giving a break down of expenditure
   • click here for help with charts

 

REMEMBER – A template can be found in the share area to help you with this task – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\Activity 2\2 Budget.  It is called EXPENDITURE LTM. 

TASK 4 Development of Text (DRAFT LETTER)

1. You need to write a first draft, outline letter to your grandparents.  This outline letter should;
   • be left aligned
   • show original errors, spelling or grammatical
   • be one long paragraph
   • be unformatted
   • not include any information from your spreadsheet
2. Print out this letter and annotate to show the changes you are going to make.  You will probably want to change;
   • the alignment of some elements
   • any spelling or grammatical mistakes (capital letters etc.)
   • one long paragraph into shorter ones
   • format various parts of the letter (bold, italic, font size etc.)
   • add in data from your spreadsheet
3. This will show that you have developed the text in your letter.
4. You could attach this finished letter to an email and send this to your grandparents – another use of purposeful email.

REMEMBER – A template can be found in the share area to help you with this task – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\Activity 2\3 Letter.  It is called DRAFT LETTER LTM. 

Charlotte F and Lily - You need to number the pages of your portfolio and create a contents page. Please use the following list as a check list:

ACTIVITY 1 – UNIVERSITY LEAFLET

1. Plan for Activity 1. 
2. Searching for Pictures - complex search, relevant hits / results, selection of images with URLs / web addresses.
3. Developing Pictures - at least 2, original image with URL / web address, improved image produced in Photoshop, explain what you have done to the images.
4. Searching for Text - complex search, relevant hits / results, selection of text with URLs / web addresses.
5. Developing Text - original text with URL / web address, improved text (only use SOME) but make sure that you REWORD IT!!!
6. NON ICT SOURCE - Photocopy from university prospectus with highlighting of relevant text. NOT copied from the INTERNET!!!
7. FIRST DRAFT of University Leaflet - 2 sides of A4 in booklet format, including undeveloped images and text.
8. Purposeful Use of Email - word screenshot document, email screenshot with first draft of university leaflet attached asking for advice / help about improving your leaflet.
9. FINAL Black and White copy of University Leaflet - needs to be checked, spelling, grammar, include improved / developed images and text.

10. FINAL Colour copy of University Leaflet.

ACTIVITY 2 – BUDGET LETTER

1. Plan for Activity 2. 
2. Searching for Budget Information – complex search, relevant hits / results selection of text with URLs / web addresses.
3. DRAFT / Outline Budget Spreadsheet - Income section, Expenditure section, Balance, What if analysis (If Function – Can I afford this? – ONLY LABELS!!!
4. FINAL Budget Spreadsheet FORMATTING COPY - all sections showing figures.
5. FINAL Budget Spreadsheet FORMULAE COPY - all sections showing formulae used.
6. CHART – displaying e.g. expenditure at first choice university.
7. DRAFT Letter to Grandparents - unformatted text (no addresses, no spreadsheet data, no chart)
8. FINAL Letter to Grandparents - formatted text (addresses, spreadsheet date and chart data)

Emma - you need to create a folder structure document to provide evidence that an electonic version of your portfolio exists. 

Open Word and create a document entitled Folder Structure.  You will need to show a number of screenshots from your network area. 

• Screenshot 1 – Your area showing a Key Skills folder. 
• Screenshot 2 - Your Key Skills folder showing an Activity 1 (UNI LEAFLET) folder and Activity 2 (BUDGET LETTER) folder. 
• Screenshot 3 – Your Activity 1 folder showing the relevent files for activity 1.
• Screenshot 4 – Your Activity 2 folder showing the relevent files for activity 2. 

FINALLY… (MARIA and HARRIET)

You need to sign and date your cover sheet.  BLACK INK PLEASE!!!

LUCY SB, ABI, AMANDA, CHARLIE O and SARAH - Please use the checklist above to check that your portfolio is complete.

13I Period 1 Tuesday 28th February 2012

STARTER

What do you know about Spreadsheets?  Click HERE to find out. 

To help you with the Word Processing questions please look at the file EXAM SKILLS Word Processing.  Here is the path to find this file – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\KS Level 3 Exam Files. 

Task 1 Youth Word Processing Exam question.

The skills required to complete this question are

• adjusting margins
• formatting text
• inserting and formatting images
• setting tabs
• mail merge
• creating a folder
• screen shots

Click HERE to access Word 2007 teaching videos.

13I Period 1 Tuesday 7th February 2012

STARTER

What do you know about Network Systems?  Click HERE to find out. 

To help you with the Word Processing questions please look at the file EXAM SKILLS Word Processing.  Here is the path to find this file – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\KS Level 3 Exam Files. 

Task 1 Lettings Word Processing Exam question.

The skills required to complete this question are

• adjusting margins
• formatting text
• inserting and formatting images
• setting tabs
• mail merge
• creating a folder
• screen shots

Click HERE to access Word 2007 teaching videos. 

EXTENSION

What have you learned about Network Systems?  Click HERE to find out.

13I Period 1 Tuesday 24th January 2012

STARTER – What do you know about Publisher?  Click HERE to find out. 

To help you with the Word Processing questions please look at the file EXAM SKILLS Word Processing.  Here is the path to find this file – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\KS Level 3 Exam Files

Task B – Word processing. 

 

Question 4 – A Standard letter. 

 

PART A – Use a word processing application to insert or open the text file Letter. 

Video – Opening an existing document. 

http://www.teach-ict.net/software/word_2007/creating_opening_documents/open_existing.htm

Instructions:

From the Window menu choose Open. 

Navigate to the Letter document, which is saved in the shared area.  Here is the path:

Shared\Pupils\Senior Pupils\ICT\Key skills\Key Skills Level 3\KS Level 3 Exam Files\Catering\

Choose All Files from the Files of Type drop down menu. 

Double click on Letter (text file). 

Choose Windows (Default) from Text encoding and click on OK. 

 

PART H – Save this letter (in normal word-processing format, i.e. NOT as a .txt file) using the charactersW1 – followed by your full initials as the file name, for example W1 – LTM. 

Video – Using “Save as”. 

http://www.teach-ict.net/software/word_2007/save/save_as.htm

Instructions:

From the Window menu choose Save As.

Type in W1 – your initials e.g. LTM in the File name

Choose Word Document from the File of type drop down menu. 

Navigate to your Catering Exam folder. 

Click on Save. 

 

PART B – Format all text as 10point with a Times Roman font. 

Video – Font size changes, grow and shrink. 

http://www.teach-ict.net/software/word_2007/formatting_editing_text/font_size.htm

Video – Font style changes. 

http://www.teach-ict.net/software/word_2007/formatting_editing_text/font_style.htm

Instructions:

Highlight all of the text by clicking and dragging over it. 

Choose Times New Roman from the Font drop down menu. 

Choose point size 10 from the Font Size drop down menu. 

Save you work by clicking on the Save button. 

 

PART C – Make the text of the first six lines (the company name, address and telephone number) upper case with a font size between 16 and 22 points. 

Video – Change case. 

http://www.teach-ict.net/software/word_2007/formatting_editing_text/change_case.htm

Video – Font size changes, grow and shrink. 

http://www.teach-ict.net/software/word_2007/formatting_editing_text/font_size.htm

Instructions:

Highlight the first six lines of text (the company name, address and telephone number) by clicking and dragging over it. 

Choose UPPER CASE from the Change Case drop down menu. 

Save you work by clicking on the Save button. 

 

PART D, E, F and G – Insert the image file Logo into the letter.  Position the image at the top right hand side of the letter opposite the company name and address.  Adjust the size of the image so that it is approximately 3cm in height, ensuring that it maintains its height-to-width ratio.  Crop the image so that the bow tie is no longer visible. 

Video – Insert an image. 

http://www.teach-ict.net/software/word_2007/images/inserting_image.htm

Video – Wrap text around an image. 

http://www.teach-ict.net/software/word_2007/images/wrap_text.htm

Video – Resize an image. 

http://www.teach-ict.net/software/word_2007/images/resize_image.htm

Video – Crop an image. 

http://www.teach-ict.net/software/word_2007/images/crop_image.htm

Instructions:

Position the cursor approximately where you want to position the image. E.g. Below the postcode and above the date. 

On the Illustrations section o f the Insert menu choose Picture. 

Navigate to find the Logo image.  Here is the path:

Shared\Pupils\Senior Pupils\ICT\Key skills\Key Skills Level 3\KS Level 3 Exam Files\Catering\

Double click the Logo image. 

On the Arrange section of the Format menu choose Tight from the Text Wrapping drop down menu. 

Save you work by clicking on the Save button. 

Move the Logo to the top right side of the letter opposite the company name and address by clicking and dragging it.  You can also use the arrow keys on your keyboard. 

Save you work by clicking on the Save button. 

On the Size section of the Format menu choose 3cm from the Shape height.  (You may need to reposition the image slightly!) 

Save you work by clicking on the Save button. 

On the Size section of the Format menu choose Crop.  Click and drag up on the bottom line to “cut off” the bow tie from the image.  (You will need to resize the image – make it 3cm high.  You may need to reposition the image slightly! 

Save you work by clicking on the Save button. 

 

 

Question 5 – The five lines giving details of cost require formatting. 

Event                    Previous Cost          New Cost          Savings

                                       £                               £                         £

Buffet                          150                           135                    15

Optional Tidying          5.5                     4.95              55

Optional Gifts             15                       13.5                 1.5

PART A – Set centre tabs for the first two lines and decimal tabs for last three lines so that the data is aligned as shown above. 

Video – Tabs. 

http://www.teach-ict.net/software/word_2007/formatting_paragraph/tabs.htm

Instructions:

Highlight the five lines of text by clicking and dragging over them. 

From the Paragraph section of the Home menu click on the drop down arrow (bottom right corner). 

Choose Tabs… from the Indents and Spacing tab. 

Click Clear All and then OK. 

Highlight the first two lines of text by clicking and dragging over them.

From the Paragraph section of the Home menu click on the drop down arrow (bottom right corner). 

Choose Tabs… from the Indents and Spacing tab. 

Type 1, click Center, choose Set.

Type 6, click Center, choose Set.

Type 9, click Center, choose Set.

Type 12, click Center, choose Set.

Click OK. 

You may have to use the Tab key and the BackSpace key to align the text. 

Highlight the last three lines of text by clicking and dragging over them.

From the Paragraph section of the Home menu click on the drop down arrow (bottom right corner). 

Choose Tabs… from the Indents and Spacing tab. 

Type 6, click Decimal, choose Set.

Type 9, click Decimal, choose Set.

Type 12, click Decimal, choose Set.

Click OK. 

You may have to use the Tab key and the BackSpace key to align the text. 

 

PART B – Ensure that the letter fits on a single A4 page, adjusting margins as necessary.  Place your name, today’s date and the title Printout – 3 in a footer and print the letter. 

Video – Change margins. 

http://www.teach-ict.net/software/word_2007/formatting_pages/change_margins.htm

Instructions:

From the Page Setup section of the Page Layout menu, click on the Margins drop down menu. 

Choose one of the Default Margins or click on Custom Margins and type in your own margin sizes. 

Click OK. 

 

Video – Header and Footer. 

http://www.teach-ict.net/software/word_2007/formatting_pages/header_footer.htm

Instructions:

From the Header and Footer section of the Insert menu, click on the Footer and then Blank (Three Columns). 

Type you name into the first / left [Type text]. 

Click on the first / center [Type text].  Then from the Insert section of the Design menu, click on the Date & Time, and select the style of date you prefer and click OK.  

Type you Printout – 3 into the first / right [Type text]. 

Close the footer by double click on any white space section of the main document. 

 

PART C – Save this letter using the characters W2 – followed by your full initials as the filename, for example W2 – LTM. 

Video – Using “Save as”. 

http://www.teach-ict.net/software/word_2007/save/save_as.htm

Instructions:

From the Window menu choose Save As.

Type in W2 – your initials e.g. LTM in the File name

Navigate to your Catering Exam folder. 

Click on Save. 

 

 

Question 6 – Mail Merge. 

 

PART A – The data file DetailsB is to be used as a data source for the mail merge.  This is a comma-delimited file with a header row, which some software can use directly as a data source.  (Where it cannot be used directly, use word-processing software to import or open the file and save it as a mail-merge source.) 

PART B – Turn the letter into a merge document and select the data file DetailsB as the source for the merge. 

PART C – In the letter, replace the words TITLE, FIRSTNAME, LASTNAME, ADDRESS1, ADDRESS2 and POSTCODE wherever they appear with the appropriate merge fields. 

PART D – Replace DATE with today’s date. 

 

Video – Insert today’s date. 

http://www.teach-ict.net/software/word_2007/formatting_pages/insert_date.htm

Instructions:

Double click on text Date in your Letter document. 

From the Text section of the Insert menu, choose Date & Time.  Choose a format that you like and click on OK. 

 

Video – Mail merge from a database. 

http://www.teach-ict.net/software/word_2007/mail_merge/mailmerge_fromdb.htm

Instructions:

Ensure that the data file DetailsB is Close

Ensure your Letter document W2 – your initials e.g. LTM is Open. 

From the Start Mail Merge section of the Mailings menu, choose Step by-Step Mail Merge Wizard from the Start Mail Merge drop down menu. 

Step 1,  Choose Letter from What type of document are you working on?  Click on Next. 

Step 2, Choose Use the current document from How do you want to set up your letters?  Click on Next. 

Step 3,  Choose Use an existing list from Select Recipients.  Click on Browse to find the DetailsB data file.  Here is the path:

Shared\Pupils\Senior Pupils\ICT\Key skills\Key Skills Level 3\KS Level 3 Exam Files\Catering\

Double click on the DetailsB file. 

Click OK. 

Click on Next. 

Step 4, Replace the words TITLE, FIRSTNAME, LASTNAME, ADDRESS1, ADDRESS2 and POSTCODE. 

Double click TITLE in the document.  Choose More items from the Write your letter.  Double click TITLE from the Insert Merged Fields dialogue box.  Click on Close.  Press the space bar to generate a space.  REPEAT this process for all of the other fields in your letter. 

 

*********TAKE A PRINT SCREEN.****************************************** 

Open a new Word document.

Paste screen dump showing the unmerged letter into this document. 

 

PART E – Make sure that the letter fits on a single A4 page, in portrait form, adjusting margins as necessary.  Place your name, today’s date and the title Printout – 4 in a footer. 

 

Video – Change margins. 

http://www.teach-ict.net/software/word_2007/formatting_pages/change_margins.htm

Instructions:

From the Page Setup section of the Page Layout menu, click on the Margins drop down menu. 

Choose one of the Default Margins or click on Custom Margins and type in your own margin sizes. 

Click OK. 

 

Video – Header and Footer. 

http://www.teach-ict.net/software/word_2007/formatting_pages/header_footer.htm

Instructions:

From the Header and Footer section of the Insert menu, click on the Footer and then Blank (Three Columns). 

Type you name into the first / left [Type text]. 

Click on the first / center [Type text].  Then from the Insert section of the Design menu, click on the Date & Time, and select the style of date you prefer and click OK.  

Type you Printout – 3 into the first / right [Type text]. 

Close the footer by double click on any white space section of the main document. 

 

PART F – Save this letter using the characters W3 – followed by your full initials as the filename, for example W3 – LTM. 

Video – Using “Save as”. 

http://www.teach-ict.net/software/word_2007/save/save_as.htm

Instructions:

From the Window menu choose Save As.

Type in W3 – your initials e.g. LTM in the File name

Navigate to your Catering Exam folder. 

Click on Save. 

 

PART G – Print a copy of this unmerged letter in portrait form showing the merged fields.  (If your software will not do this, produce a screen print of unmerged letter with your name, today’s date and the title Printout – 4 in a footer.) 

Video – Print preview. 

http://www.teach-ict.net/software/word_2007/print/print_preview.htm

Instructions:

From the Window menu choose Print and then Print Preview.

Check the document. 

Click on Print and then OK.. 

**********************************************************************

 

COMPLETE the MAIL MERGE. 

 

Step 5, Choose Preview your letter.  You can now preview the letter for each Recipient by using the << and >> arrows.   You can even exclude a recipient by using the Exclude this recipient button. 

Step 6, Choose Complete the merge.  You can print all of the letter or a particular one by choosing Print and then All, Current or typing in page numbers From and To in the Merge to Print box. 

 

Print the letter for each of the first two clients only.  i.e. page 1 to 2 only. 

 

 

Question 7 – Copies of merged letter. 

 

PART A – Amend the footer of the letter to change the title to Printout – 5. 

Video – Header and Footer. 

http://www.teach-ict.net/software/word_2007/formatting_pages/header_footer.htm

Instructions:

From the Header and Footer section of the Insert menu, click on the Footer and then Blank (Three Columns). 

Type you name into the first / left [Type text]. 

Click on the first / center [Type text].  Then from the Insert section of the Design menu, click on the Date & Time, and select the style of date you prefer and click OK.  

Type you Printout – 5 into the last / right [Type text]. 

Close the footer by double click on any white space section of the main document. 

 

PART B – Merge the letter with the data file DetailsB. 

YOU HAVE ALREADY DONE THIS. 

 

PART C – Save the merged letter using the characters W4 – followed by your full initials as the filename, for example W4 – LTM. 

Video – Using “Save as”. 

http://www.teach-ict.net/software/word_2007/save/save_as.htm

Instructions:

From the Window menu choose Save As.

Type in W4 – your initials e.g. LTM in the File name

Navigate to your Catering Exam folder. 

Click on Save. 

 

PART D – Print the letter for each of the first two clients only. 

THIS IS STEP 6 of the MAIL MERGE WIZARD. 

Step 6, Choose Complete the merge.  You can print all of the letter or a particular one by choosing Print and then All, Current or typing in page numbers From and To in the Merge to Print box. 

 

 

TASK C

 

The following task must be completed.  If you have not completed this task within the time allowed, it must be completed at the end of the test. 

 

Question 8 – A printed list of filenames is required. 

 

PART A – Produce a list of the files you have created during the test.  This must be in the form of a screen dump (print screen) showing the filenames with your name, today’s date and the title Printout – 6 as a footer. 

Video –

 

Instructions: 

Open your Catering Exam folder. 

Press the print screen button (PRTSC) on the keyboard. 

Open Word. 

Paste the screen dump into the document. 

Add our Name, Today’s Date and the Title Printout – 6 to the footer. 

Print the document to the KC2mono printer. 

EXTENSION – What have you learned about Publisher.  Click HERE to find out.

13I Period 1 Tuesday 10th January 2012

STARTER

What do you know about communication?  Click HERE  to find out.

Task 1 Job Seek Spreadsheet Exam question.

If you did not complete this spreadsheet in the last lesson, then please continue with it now.  I will demonstrate some of the key formatting and formulae once you have attempted the starter. 

HINT

• 5a Use the VLOOKUP function. 
• 5b Use the IF function. 

TASK 2 Mobile Spreadsheet Exam Question. 

Take a copy of the Mobile Spreadsheet Exam Question.  Make sure that you have made an Mobile Exam folder in your network area.  Save all of your versions of this spreadsheet into this folder.

Insert Text File into a Spreadsheet

Watch the podcast HOW TO IMPORT A TEXT FILE INTO A SPREADSHEET which can be found in the shared area.  Here is the path – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3.  To RUN this podcast – RIGHT click on it – choose Open With… – choose Select the program from the list - and click OK.  Choose Internet Explore and click on OK.  The podcast should open. 

Open the file EXAM SKILLS SPREADSHEETS, which can be found in the shared area.  Here is the path – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\KS Level 3 Exam Files. 

HINT

5b IF function with AND operator. 

5e SUM function with ABSOLUTE CELL REFERENCE. 

EXTENSION

What have you learned about gathering data?  Click HERE to find out.

13I Period 1 Tuesday 6th December 2011

STARTER

What do you know about gathering data?  Click HERE  to find out.

Task 1 Ice Cream Spreadsheet Exam question.

If you did not complete this spreadsheet in the last lesson, then please continue with it now.  I will demonstrate some of the key formatting and formulae once you have attempted the starter. 

TASK 2 Job Seek Spreadsheet Exam Question. 

Take a copy of the Job Seek Spreadsheet Exam Question.  Make sure that you have made an Job Seek Exam folder in your network area.  Save all of your versions of this spreadsheet into this folder.

Insert Text File into a Spreadsheet

Watch the podcast HOW TO IMPORT A TEXT FILE INTO A SPREADSHEET which can be found in the shared area.  Here is the path – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3.  To RUN this podcast – RIGHT click on it – choose Open With… – choose Select the program from the list - and click OK.  Choose Internet Explore and click on OK.  The podcast should open. 

Open the file EXAM SKILLS SPREADSHEETS, which can be found in the shared area.  Here is the path – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\KS Level 3 Exam Files. 

HINT

• 5a Use the VLOOKUP function. 
• 5b Use the IF function. 

EXTENSION

What have you learned about gathering data?  Click HERE to find out.

13I Period 1 Tuesday 22 November 2011

STARTER What do you know about MS Excel?  Click HERE to find out.

TASK 1 IceCream Spreadsheet Exam Question. 

Take a copy of the IceCream Spreadsheet Exam Question.  Make sure that you have made an IceCream Exam folder in your network area.  Save all of your versions of this spreadsheet into this folder.

Insert Text File into a Spreadsheet

Watch the podcast HOW TO IMPORT A TEXT FILE INTO A SPREADSHEET which can be found in the shared area.  Here is the path – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3.  To RUN this podcast – RIGHT click on it – choose Open With… – choose Select the program from the list - and click OK.  Choose Internet Explore and click on OK.  The podcast should open. 

Open the file EXAM SKILLS SPREADSHEETS, which can be found in the shared area.  Here is the path – S:\Pupils\Senior Pupils\ICT\Key Skills\Key Skills Level 3\KS Level 3 Exam Files. 

HINT Question 5d is an example of using an IF FUNCTION!!!

EXTENSION – What have you learned about spreadsheets?  Click HERE to find out.