13I Period 1 Tuesday 15th May 2012

May 1, 2012 by Leave a comment

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!!!

Filed under LTM Year 13 Key Skills

12I Period 5 Monday 18th June 2012

April 30, 2012 by Leave a comment

Please click on this LINK and complete the SURVEY QUESTIONS.

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.

TASK 1 – Development of number

(Rosie, Lara, and Laura)

DEADLINE Thursday 29th March 2012

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 2 Development of Text (DRAFT LETTER and FINAL LETTER)

(Natalie, Laura, Lara and Rosie)

DEADLINE Friday 4th May 2012.

  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 3 Contents Page

(Harriet, Becky, Natalie, Laura, Lara and Rosie)

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 4 Folder Structure

(Harriet, Becky, Natalie, Laura, Lara and Rosie)

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…(Harriet, Becky, Natalie, Laura, Lara and Rosie)

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

EXTENSION WORK

Click HERE to watch some teaching videos about MS ACCESS.  Start with Importing data from a text file.  Now try these GAMES to find out what you have learned.

Click HERE to watch some videos about MS EXCEL.  Start with Importing data from a text file.  Now try these GAMES to find out what you have learned.

Click HERE to watch some videos about MS WORD.  Start with Mail Merge.  Now try these GAMES to find out what you have learned.

Filed under LTM Year 12 Key Skills

12I Period 5 Monday 30th April 2012

March 27, 2012 by Leave a comment

Please click on this LINK and complete the SURVEY QUESTIONS.

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

TASK 1 – Development of number

(Becky, Rosie, Lara, and  Laura)

DEADLINE Thursday 29th March 2012

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 2 Development of Text (DRAFT LETTER and FINAL LETTER)

(Natalie, Harriet, Charlotte W and Olivia W)

DEADLINE Friday 4th May 2012.

  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 3 Contents Page

(Robyn and Hannah)

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 4 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…(Charlotte E)

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

Sara and Olivia M

Click HERE to watch some teaching videos about MS ACCESS.  Start with Importing data from a text file.  Now try these GAMES to find out what you have learned.

Click HERE to watch some videos about MS EXCEL.  Start with Importing data from a text file.  Now try these GAMES to find out what you have learned.

Click HERE to watch some videos about MS WORD.  Start with Mail Merge.  Now try these GAMES to find out what you have learned.

Filed under LTM Year 12 Key Skills

13I Period 1 Tuesday 1st May 2012

March 27, 2012 by Leave a comment

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!!!

Filed under LTM Year 13 Key Skills

13I Period 1 Tuesday 27th March 2012

March 13, 2012 by Leave a comment

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!!!

Filed under LTM Year 13 Key Skills

12I Period 5 Monday 26th March 2012

March 13, 2012 by Leave a comment

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

TASK 2 – Development of number

(Becky, Rosie, Lara, Charlotte E, Harriet, Laura, Olivia W and Charlotte W, Hannah)

DEADLINE Thursday 29th March 2012

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)

(Natalie)

DEADLINE Friday 4th May 2012. 

  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. 

Sara, Robyn and Olivia M I need you to print out a colour copy of your FINAL LETTER. 

TASK 4 Contents Page

(Sara, Robyn and Olivia M)

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

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!!!

Filed under LTM Year 12 Key Skills

13I Period 1 Tuesday 13th March 2012

February 29, 2012 by Leave a comment

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.

Filed under LTM Year 13 Key Skills

12I Period 5 Monday 12th March 2012

February 28, 2012 by Leave a comment

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

TASK 1 – Planning for activity 2 – (Lara, Becky and Rosie) 

DEADLINE Friday 17th February. 

  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. (Lara, Becky, Hannah, Harriet, Laura, and Rosie)

DEADLINE Friday 2nd March 2012

  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

DEADLINE Thursday 29th March 2012

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. 

Filed under LTM Year 12 Key Skills

13I Period 1 Tuesday 28th February 2012

February 10, 2012 by Leave a comment

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.

Filed under LTM Year 13 Key Skills

12I Period 5 Monday 27th February 2012

February 8, 2012 by Leave a comment

STARTER

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

TASK 1 Colour Copy of University Leaflet.  (Charlotte E and Rosie)

Please print me a colour copy of your Final University Leaflet to the KC2colour printer. 

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

TASK 1 – Planning for activity 2 – (Lara, Charlotte E, Becky, Hannah, Harriet, Olivia M, Rosie) 

DEADLINE Friday 17th February. 

  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. 

DEADLINE Friday 2nd March 2012. 

(Laura, Natalie and Charlotte W)

  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

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. 

Filed under LTM Year 12 Key Skills

← Older posts

Follow

Get every new post delivered to your Inbox.