Business Studies at Campbeltown Grammar School - Home



Pupil/Teacher/Parent

Target Setting Discussion Record

|Date |Target Band|Current |↑↔↓ |Agreed Improvement Actions |Parent Comment |

| | |Band | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

Pupil/Teacher/Parent

Target Setting Discussion Record

|Date |Target Band|Current |↑↔↓ |Agreed Improvement Actions |Parent Comment |

| | |Band | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

| | | | | | |

Unit 1 - Administrative Practices

|Skills, knowledge and understanding |Strength | |Weakness |Next steps/Comments |

|Tasks, skills and qualities of an administrative assistant |

|I can describe the tasks/duties of an Admin | | | | |

|assistant. | | | | |

|I can explain what a job description is and | | | | |

|why it is used. | | | | |

|I can describe the skills required of an | | | | |

|Admin assistant. | | | | |

|I can describe the qualities required of an | | | | |

|Admin assistant. | | | | |

|I can explain what a person specification is | | | | |

|and why it is used. | | | | |

|I can explain what a skill scan and SWOT | | | | |

|analysis is and why it is used. | | | | |

|Customer care |

|I can explain what an internal customer is. | | | | |

|I can explain what an external customer is. | | | | |

|I can explain what a customer service | | | | |

|strategy is. | | | | |

|I can describe what a mission statement is. | | | | |

|I can explain the key features of | | | | |

|good customer service. | | | | |

|I can explain the effects of good | | | | |

|customer service. | | | | |

|I can explain the impact of poor | | | | |

|customer service. | | | | |

|Skills, knowledge and understanding |Strength | |Weakness |Next steps/Comments |

|Health & Safety |

|I can describe the hazards in the workplace | | | | |

|and measures taken to ensure safe practice. | | | | |

|I can describe the procedure to be followed | | | | |

|when an accident occurs and how to complete | | | | |

|the required documentation. | | | | |

|I can explain what is meant by an | | | | |

|organisational health and safety policy and | | | | |

|what it includes. | | | | |

|I can justify the use of induction training | | | | |

|to cover health and safety issues. | | | | |

|I can outline current UK health and safety | | | | |

|legislation and what employers and employees | | | | |

|should do in relation to these acts. | | | | |

|Security of people, property and information |

|I can describe organisational procedures used| | | | |

|to protect people. | | | | |

|I can describe organisational procedures used| | | | |

|to protect property. | | | | |

|I can describe organisational procedures used| | | | |

|to protect both paper-based and electronic | | | | |

|information. | | | | |

|I can explain The Data Protection Act 1998 and The Computer Misuse Act 1990. |

|I can explain what an event is. | |

|Outcome 1 |

|Provide an overview of administration in the workplace by: |Provide an account of administration in the workplace by: |

|Naming the main tasks, skills and qualities of an administrative |Describing the tasks, skills and qualities of an administrative assistant.|

|assistant. |Describing key features of good customer care in the context of |

|Outlining the key features of good customer care. |administration. |

|Outlining the key employee responsibilities in terms of health and safety.|Describing the organisational responsibilities in terms of health and |

|Outlining the key employee responsibilities in terms of the security of |safety. |

|people, property and information. |Describing the key organisational responsibilities in terms of the |

| |security of people, property and information. |

|Outcome 2 |

|Carry out administrative tasks in the context of organising and supporting|Interpret a given brief and carry out administrative tasks in the context |

|small-scale events, according to a simple brief by: |of organising and supporting events by: |

|Carrying out straightforward planning tasks for the event. |Carrying out planning tasks, taking account of the budget available. |

|Edit documents to support the event. |Preparing documents to support the event. |

|Carrying out follow-up activities. |Carrying out follow-up activities. |

Unit 2 - IT Solutions for Administrators

|Skills, knowledge and understanding |Strength | |Weakness |Next steps/Comments |

|Word Processing |

|I can set and change margins | | | | |

|I can carry out manuscript corrections | | | | |

|I can use bold, italics and underline | | | | |

|I can align text | | | | |

|I can change line spacing | | | | |

|I can insert a graphic | | | | |

|I can use bullets and numbering | | | | |

|I can insert headers and footers | | | | |

|I can insert borders and shading | | | | |

|I can insert page numbering | | | | |

|I can insert, delete and move text | | | | |

|I can add or delete rows | | | | |

|I can add of delete columns | | | | |

|I can change column widths | | | | |

|I can include/remove borders | | | | |

|I can insert shading within cells | | | | |

|I can sort data | | | | |

|I can merge cells | | | | |

|I can rotate text within cells | | | | |

|I can print specific pages | | | | |

|I can print documents showing merge fields | | | | |

|I can prepare letters (application, thanks,| | | | |

|enquiry) | | | | |

|I can prepare forms eg travel booking form | | | | |

|I can prepare an itinerary | | | | |

|I can prepare an agenda | | | | |

|I can prepare a personal CV | | | | |

|I can prepare reports on research findings | | | | |

|I can prepare address labels | | | | |

|Spreadsheets |

|I can align text in cell(s) | | | | |

|I can add borders/shading to cell(s) | | | | |

|I can format cells using different fonts, | | | | |

|sizes, styles | | | | |

|I can format cells to display currency, | | | | |

|date, decimal places, percentage | | | | |

|I can use basic arithmetic formulae to | | | | |

|carry out calculations (+ - * /) | | | | |

|I can use the sum function to carry out | | | | |

|calculations | | | | |

|I can use the maximum function to carry out| | | | |

|calculations | | | | |

|I can use the count function to carry out | | | | |

|calculations | | | | |

|I can use the if function to carry out | | | | |

|calculations with two possible answers | | | | |

|I can use conditional formatting to display| | | | |

|answers in different ways | | | | |

|I can link cells within worksheets | | | | |

|I can use named cells | | | | |

|I can use relative and absolute cell | | | | |

|references | | | | |

|I can input data | | | | |

|I can edit data | | | | |

|I can sort data | | | | |

|I can insert columns/rows | | | | |

|I can delete columns/rows | | | | |

|I can create a pie chart | | | | |

|I can create a bar/column chart | | | | |

|I can create a line graph | | | | |

|I can create a fully labelled chart/graph | | | | |

|Skills, knowledge and understanding |Strength | |Weakness |Next steps/Comments |

|Spreadsheets |

|I can print a chart/graph as part of a | | | | |

|worksheet | | | | |

|I can print a chart/graph separately | | | | |

|I can create a pie chart | | | | |

|I can create a bar/column chart | | | | |

|I can create a line graph | | | | |

|I can create a fully labelled chart/graph | | | | |

|I can print a chart/graph as part of a | | | | |

|worksheet | | | | |

|I can print a chart/graph separately | | | | |

|I can print a worksheet showing values | | | | |

|I can print a worksheet showing formulae | | | | |

|I can print with/without gridlines | | | | |

|I can print with/without row/column | | | | |

|headings | | | | |

|I can print in portrait or landscape | | | | |

|orientation | | | | |

|I can print with headers/footers | | | | |

|I can print on one page | | | | |

|I can print a worksheet showing values | | | | |

|I can print a worksheet showing formulae | | | | |

|I can print with/without gridlines | | | | |

|I can print with/without row/column | | | | |

|headings | | | | |

|I can print in portrait or landscape | | | | |

|orientation | | | | |

|I can print with headers/footers | | | | |

|I can print on one page | | | | |

|Skills, knowledge and understanding |Strength | |Weakness |Next steps/Comments |

|Databases |

|I can populate and edit a flat database | | | | |

|using forms | | | | |

|I can populate and edit a relational | | | | |

|database using forms | | | | |

|I can alter date format and decimal places | | | | |

|I can add/delete field(s) and record(s) | | | | |

|I can sort a database on at least one field| | | | |

|I can search a database using equals | | | | |

|I can search a database using greater than | | | | |

|I can search a database using greater than | | | | |

|or equal to | | | | |

|I can search a database using less than | | | | |

|Skills, knowledge and understanding |Strength | |Weakness |Next steps/Comments |

|Databases |

|I can search a database using less than or | | | | |

|equal to | | | | |

|I can search a database using OR | | | | |

|I can search a database using NOT | | | | |

|I can produce a report from a database | | | | |

|I can produce a report from a table or | | | | |

|search | | | | |

|I can insert a footer/header | | | | |

|I can produce a report from selected fields| | | | |

|from a table or search | | | | |

|I can print a database with all fields | | | | |

|visible | | | | |

|I can print search results | | | | |

|I can print forms | | | | |

|I can print reports | | | | |

|I can print so that it fits on one page | | | | |

|Skills, knowledge and understanding |Strength | |Weakness |Next steps/Comments |

|Integrated Software Packages |

|I can describe what is meant by the term | | | | |

|integrated software. | | | | |

|I can explain the advantages of using an | | | | |

|integrated software package. | | | | |

|I can integrate data from other IT | | | | |

|applications into a business document to | | | | |

|enhance it. | | | | |

|I can integrate data from other IT | | | | |

|applications dynamically into a business | | | | |

|document to enhance it. | | | | |

Unit 2 – IT Solutions for Administrators

Unit Assessment

Are you ready to rock?

|National 4 |National 5 |

|Outcome 1 |

|Use functions of a spreadsheet in line with a given task by: |Use a spreadsheet application, to interpret a given brief by: |

|Editing a spreadsheet, applying simple formulae. |Creating, editing and applying advanced functions and formulae to a |

|Sorting data within the worksheet. |workbook. |

|Creating a simple chart from a specified range. |Creating a suitable chart. |

|Outcome 2 |

|Use functions of a flat database in line with a given task by: |Use advanced functions of a relational database to interpret a given brief|

|Populating a database, using forms. |by: |

|Editing a database. |Populating a database, using forms. |

|Manipulating information by searching and sorting. |Editing a database. |

|Creating a simple report. |Manipulating information in a simple relational database. |

| |Presenting information in a report, to a professional standard. |

|Outcome 3 |

|Use functions of word processing in line with a given task by: |Use advanced functions of word processing to interpret a given brief by: |

|Creating and editing simple business documents, complying with the |Editing business documents, applying the house style. |

|prescribed house style. |Creating and/or editing a table. |

|Creating a simple table and sorting the data. |Importing data from a spreadsheet and/or database dynamically into a |

|Importing data into a simple business document. |business document. |

| |Merging appropriate data from a spreadsheet or database into a business |

| |document. |

Unit 3 – Communication in Administration

|Skills, knowledge and understanding |Strength | |Weakness |Next steps/Comments |

|Sourcing and Extracting Information |

|I can explain why business uses of the | | | | |

|Internet | | | | |

|I can define terms associated with using | | | | |

|the Internet to extract information | | | | |

|I can explain advantages of using the | | | | |

|Internet as a source of information | | | | |

|I can explain how to determine whether an | | | | |

|Internet website is reliable | | | | |

|I can explain the consequences of using | | | | |

|unreliable Internet source of information | | | | |

|I can describe uses of the intranet | | | | |

|I can explain advantages of using an | | | | |

|intranet | | | | |

|Presentation Software |

|Insert, edit and format text | | | | |

|Align text | | | | |

|Insert graphics | | | | |

|Use bullets | | | | |

|Create chart(s) and/or table(s) | | | | |

|Add and delete a slide | | | | |

|Animate text/objects | | | | |

|Import data from other | | | | |

|applications/Internet | | | | |

|Change slide content layout | | | | |

|Apply slide transitions | | | | |

|Change slide order | | | | |

|Apply and change background and colour | | | | |

|scheme | | | | |

|Insert footer objects | | | | |

|Skills, knowledge and understanding |Strength | |Weakness |Next steps/Comments |

|Presentation Software |

|Insert action buttons | | | | |

|Use slide master | | | | |

|Print presentation in slide and handout | | | | |

|format | | | | |

|Desktop Publishing |

|Using templates | | | | |

|Select and change font, font size | | | | |

|Set and change margins | | | | |

|Insert text, delete text, move text, format| | | | |

|text | | | | |

|Insert graphic | | | | |

|Insert headers and footers | | | | |

|Borders and shading | | | | |

|Electronic Methods of Communication |

|I can explain the uses/advantages of e-mail| | | | |

|I can explain the disadvantages/problems | | | | |

|associated with e-mail | | | | |

|I can explain the advantages of using an | | | | |

|electronic diary | | | | |

|I can describe different types of social | | | | |

|media | | | | |

Unit 3 – Communication in Administration

Unit Assessment

|National 4 |National 5 |

|Outcome 1 |

|Use technology to gather information in line with a simple brief by: |Use technology to extract information and be able to evaluate sources of |

|Searching for and extracting simple information from the Internet. |information by: |

|Searching for and extracting simple information using an internal network|Searching for and extracting/downloading relevant information to |

|(intranet). |interpret a given brief. |

| |Outlining key features of reliable sources of information. |

| |Explaining the consequences of using unreliable Internet sources of |

| |information. |

|Outcome 2 |

|Use functions of technology to prepare and communicate simple information|Use advanced functions of technology to prepare and communicate |

|in line with a simple brief by: |information by interpreting a given brief, to convey a professional image|

|Using multimedia to create a simple presentation. |by: |

|Using desktop publishing to produce a simple document. |Using functions of multimedia applications to create a presentation. |

|Using an electronic method to communicate information. |Using functions of desktop publishing to produce a document. |

| |Using electronic methods to communicate information. |

Administration & IT

Course Assessment

|National 4 |

|Added Value Assignment |

|The assignment will be carried out in class under supervision. This will be set and marked internally – Pass/Fail. |

|You must complete this assignment independently. The assignment is open book. |

|8 hours plus preparation time. |

| |

|Organise and support a small-scale event to a given brief, making use of current or emerging equivalent technologies, by: |

|Preparing for a small-scale event, making use of appropriate technologies where appropriate. |

|Preparing simple documents to support the event, using standard templates and utilising functions of IT applications. |

|Communicating using electronic methods, showing a basic awareness of the communication’s context, audience and purpose. |

|Carrying out straightforward follow-up tasks, making use of appropriate technologies where necessary. |

|National 5 |

|Course Assignment |

|Graded A-D. 100 mark assignment. Event administration (before and after). In class, exam conditions. |

|Four hours. 10-20% theory, 80-90% practical. SQA set and marked. |

| |

|Stage 1: preparing for the event including contingency planning: |

|Preparing a to-do list/priorities list. |

|Entering details into an e-diary. |

|Searching for information about the venue and resources and how to book them. |

|Using spreadsheets to access relevant statistical or financial information, including the budget for the event. |

|Using appropriate software to prepare the agenda. |

|Using appropriate software to prepare materials, which could include name badges, advertising, invitations, place cards. |

|Using databases for details of delegates/performers and to carry out the following functions: update, search, mail merge and prepare letters, labels, |

|attendees’ report. |

|Using presentation software to prepare the key speaker’s presentation, background/welcoming presentation. |

|Resolve a double-booking of the venue. |

|Prepare additional documents at short notice. |

|Changing travel or other arrangements due to unforeseen circumstances |

|Stage 2: follow-up tasks: |

|Prepare an evaluation of the event. |

|Collate responses and present findings in a variety of formats, including charts. |

|Prepare ‘thank you’ letters (to the venue host, participants and guests), using mail merge. |

|Prepare minutes, notes or action points. |

|Prepare event costings and expenses. |

| |

|Theory: Admin tasks/skills, customer care, health&safety, events/meetings, sourcing reliable info, security of people, equipment and info, good file |

|management, corporate image (consistency - house style - colour, font, style, layout, graphics, etc) |

| |

|Practical: Word Processing |

|♦ creating a range of documents, complying consistently with the house style; documents to include: letter, form, itinerary, business report, minutes, |

|agenda, to-do list, priorities list, thank you letters, evaluations |

|♦ using functions of desktop publishing to create documents, for example: leaflets, four-page booklets, newsletters, magazines |

|♦ editing a given document; this will involve amending and manipulating its text to enhance its presentation, using own judgement |

|♦ creating and enhancing a table, sorting the data and making use of formulae to summarise the information where appropriate |

|♦ importing data from other IT applications dynamically into a document |

|♦ merging appropriate data from spreadsheet and/or database applications into a business document, for example: address labels, letters, report, name |

|badges, certificates |

|Spreadsheets |

|♦ creating a workbook by selecting and applying appropriate formatting, formulae and functions: |

|— basic arithmetical formula, average, relative/absolute cell references, maximum, minimum, if, named cells, count formulae, conditional formatting |

|♦ editing data in the workbook and sorting the data |

|♦ making amendments to the workbook to improve its presentation |

|♦ creating a chart, labelling it independently using data from adjacent and non-adjacent columns |

|♦ use of comments |

|♦ printing worksheets and extracts of worksheets |

|Databases |

|♦ editing simple relational database using tables and forms |

|♦ manipulating information in a simple relational database; this will involve searching and sorting |

|♦ presenting information from a simple relational database in a report, to a professional standard |

|Presentations |

|using advanced functions of multimedia applications to create and edit presentations, for example: action buttons, master slides, animation, transition |

|e-communication |

|♦ searching for and extracting/downloading relevant information from the internet, showing an understanding of what constitutes a reliable source of |

|information |

|♦ using electronic methods to communicate an item of information in ways appropriate to its context, audience and purpose, for example use of: e-mail, |

|blogs, social media |

|♦ use an e-diary |

|Past AND Practice Paper Record |Attempt 1 |Attempt 2 |Attempt 3 |

|(enter paper name and | | | |

|year below) | | | |

| | | | |

| | | | |

| | | | |

| | | | |

| | | | |

| | | | |

| | | | |

| | | | |

| | | | |

-----------------------

National 5

Administration & IT

PLP

Pupil Name: ________________________

Class: ___________

Teacher: ________________________

To prepare for this assessment I plan to:

How did I do? What areas of my skills, knowledge and understanding do I need to improve before the final course assessment?

How can I use the skills, knowledge and understanding in this unit to help my studies in other subject areas or my home life?

To reinforce these word processing skills on the lead up to the unit and final course assessment I plan to:

How can I use my word processing skills to help my studies in other subject areas or my home life?

To reinforce these spreadsheet skills on the lead up to the unit and final course assessment I plan to:

How can I use my spreadsheet skills to help my studies in other subject areas or my home life?

To reinforce my database skills on the lead up to the unit and final course assessment I plan to:

How can I use my database skills to help my studies in other subject areas or my home life?

To prepare for this assessment I plan to:

How did I do? What areas of my skills, knowledge and understanding do I need to improve before the final course assessment?

How can I use the skills, knowledge and understanding in this unit to help my studies in other subject areas or my home life?

To prepare for this assessment I plan to:

YZ¬0¬P¬¯

¯

¯¯¯¯¯¯ How did I do? What areas of my skills, knowledge and understanding do I need to improve before the final course assessment?

How can I use the skills, knowledge and understanding in this unit to help my studies in other subject areas or my home life?

To prepare for this assessment I plan to:

To prepare for this final assignment I plan to:

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download