Example: dental hygienist

Golspie High School

Golspie high School Higher Administration & IT Course Guide 2016/17 Golspie high School Administration & IT Higher Page 3 Course Guidelines The skills, knowledge and understanding that will be developed in the Higher Administration Course are outlined in the following table. Golspie high School Administration & IT Higher Page 4 Course Guidelines Prior Knowledge - ICT It is important that you realise it is assumed that you know all National 4/5 level administrative skills for word processing, spreadsheets, databases, presentation packages, desk top publishing, etc. You will not have time to cover them in class, so it is up to you to work on any gaps in your knowledge at home or after School /lunchtime or during study periods. Ensure you have a copy of the Guidelines for Staff for Document Production sheets to hand and refer to them regularly.

Golspie High School Administration & IT Higher Page 3 Course Guidelines The skills, knowledge and understanding that will be developed in the

Tags:

  High, School, Understanding, Epigloss, Golspie high school

Information

Domain:

Source:

Link to this page:

Please notify us if you found a problem with this document:

Other abuse

Transcription of Golspie High School

1 Golspie high School Higher Administration & IT Course Guide 2016/17 Golspie high School Administration & IT Higher Page 3 Course Guidelines The skills, knowledge and understanding that will be developed in the Higher Administration Course are outlined in the following table. Golspie high School Administration & IT Higher Page 4 Course Guidelines Prior Knowledge - ICT It is important that you realise it is assumed that you know all National 4/5 level administrative skills for word processing, spreadsheets, databases, presentation packages, desk top publishing, etc. You will not have time to cover them in class, so it is up to you to work on any gaps in your knowledge at home or after School /lunchtime or during study periods. Ensure you have a copy of the Guidelines for Staff for Document Production sheets to hand and refer to them regularly.

2 They cover house style layouts, abbreviations and manuscript correction signs for the documents you are required to know. In addition, the following booklets are available on the School intranet to practice with and/or refer to. Resources Date Completed Comments/Targets RS Pack 12/196 MS Excel 2010 at a Glance RS Pack 12/197 MS Access 2010 at a Glance RS Pack 12/198 MS Word 2010 at a Glance RS Pack 12/199 Getting Started with MS Word 2010 RS Pack 12/200 Getting Started with MS Excel 2010 RS Pack 12/201 Getting Started with MS Access 2010 RS Pack 12/202 Getting Started with MS PowerPoint 2010 RS Pack 15/304 Getting Started with MS Publisher 2010 RS Pack 14-277 National 5 Administration & IT Using Your Skills Communications Golspie high School Administration & IT Higher Page 5 Course Guidelines Requirements Resources Date Completed Comments/Targets Business Letters Intermediate 2 Administration Business Letters South Lanarkshire Council Tables Intermediate 2 Administration Tables South Lanarkshire

3 Council Forms Intermediate 2 Administration Forms South Lanarkshire Council Itineraries Intermediate 2 Administration Itineraries South Lanarkshire Council Business Reports Intermediate 2 Administration Reports South Lanarkshire Council Meeting Documentation N5 Meetings Documentation Newsletters N5 Information Sheets Golspie high School Administration & IT Higher Page 6 Course Guidelines Administrative Theory & Practice Effective Administrative Practices 1 Provide an account of the factors contributing to the effectiveness of the administrative function by: Time and Task Management Describing strategies for effective time and task management and their importance: skills required: planning, delegating, organising, directing and controlling setting targets for the individual and the organisation such as.

4 Personal development planning action plans and to-do lists Gantt charts dealing with changes in priorities monitoring and evaluating progress strategies used by both the employee and team leader time stealers and strategies to minimise their effect in independent and group working and meetings benefits of good time and task management to the individual and organisation consequences of bad time and task management to the individual and organisation Effective Teams Describing the characteristics of effective teams features of effective teams team formation skills of team members need for diversity benefits of teams to individuals and the organisation Golspie high School Administration & IT Higher Page 7 Course Guidelines Workplace Regulations Explaining strategies to ensure compliance with workplace legislation strategies for ensuring compliance with workplace legislation: employee and employer responsibilities under current workplace legislation in the areas of: o health and safety legislation Health and Safety at Work Act, Data Protection Act, Computer Misuse Act, Freedom of Information Act, Copyright, Designs and Patents Act o data handling Impact of IT Explaining how modern IT has had an impact on working practices The positive and negative impact of IT on areas such as: office layout and ergonomics employee morale and wellbeing working practices: o homeworking o teleworking o collaborative projects communication methods data handling.

5 O software applications o networks o file management eg naming conventions, version control, restricted access Procedures for organising and supporting meetings/events: role of Administrative Assistant and Chairperson in planning an event/meeting duties and tasks to be completed venue selection notifying attendees documentation relating to meetings: o notice of meeting and agenda o minutes (including action minutes) evaluation forms use of technology to aid in the planning and organisation of events Golspie high School Administration & IT Higher Page 8 Course Guidelines Customer Care 2 Provide an account of customer care in administration by: Customer care in administration Explaining benefits of good, and consequences of poor, customer care: The features of good customer care such as: o written customer care policy o service level agreements o complaints procedures The benefits of good customer care The consequences of poor customer care Monitoring and evaluating the quality of customer care Describing a mechanism for monitoring and evaluating the quality of customer care Methods for monitoring and evaluating the quality of customer care such as: o satisfaction surveys o customer focus groups o market research o quality management systems Golspie high School Administration & IT Higher Page 9 Course Guidelines IT Solutions for Administrators Spreadsheets 1 Use complex functions of a spreadsheet to provide solutions asked for in a task by.

6 Completing a workbook, using complex functions and formulae Manipulating a workbook to aid analysis Formulae, functions and features: arithmetical if and nested if named cells and ranges rounding, roundup and round-down mathematical functions V and H lookups CountIF and SUMIF sorting vertical (2 columns), horizontal conditional formatting comments add, edit, remove subtotalling Resources Date Completed Comments/Targets SLC IF Statements & Conditional Formatting Only required if not completed N5 AIT BEN Introduction to the VLookUp Function BEN HlookUp BEN Introduction to the CountIf Function RS Pack 12-204 MS Excel 2010 Advancing Formulae and Functions RS Pack 14/239 Using Your Skills Functions in MS Excel 2010 RS Pack 14/240 Plenty of Practice in Complex Spreadsheets SLC Higher Admin Using Comments in Spreadsheets Only required if not completed N5 AIT Golspie high School Administration & IT Higher Page 10 Course Guidelines Amending data in the workbook in line with given updated information and sorting the data on two columns to aid interpretation by carrying out the following.

7 Filtering grouping and outlining Resources Date Completed Comments/Targets RS Pack 14-241 Using Your Skills Sorting, Filtering, Grouping and Outlining in MS Excel 2010 Creating a chart to aid analysis Resources Date Completed Comments/Targets RS Pack 12-205 MS EXCEL 2010: Charting Only required if not completed N5 AIT Data consolidation: summary worksheets/files using 3D references pivot tables pivot charts Resources Date Completed Comments/Targets RS Pack 12/207 MS Excel 2010 Pivot Tables Managing workbooks: insert common data or formulae and formats simultaneously (linking worksheets) table from word processing document; data from database table; Resources Date Completed Comments/Targets RS Pack 12-206 MS Excel 2010 Working with Multiple Worksheets Importing and exporting data from external sources: table from word processing document data from database table Exporting dynamically linked data by linking spreadsheet data as a table and/or chart in a word processing document or presentation software Golspie high School Administration & IT Higher Page 11 Course Guidelines Golspie high School Administration & IT Higher Page 12 Course Guidelines Printing.

8 Completed worksheet/s and sections from worksheets in value and formulae view separate and embedded charts to aid analysis Unit Summary Resources Date Completed Comments/Targets RS Pack 14/240 Plenty of Practice in Complex Spreadsheets MS Office 2010 Golspie high School Administration & IT Higher Page 13 Course Guidelines Databases DATABASE SKILLS REQUIRED/ASSUMED FROM N5 ADMIN AND IT Populating and editing a flat database and a relational database using forms Input and edit data making use of forms Alter data format and decimal places Add and delete field/s and records/s Manipulating information in a flat and a relational database searching and sorting Searching the database using the following operators Equals Greater than Less than Great than or equal to Less than or equal to OR NOT Presenting information from a flat and a relational database in a report format, to a professional standard Produce a database report Produce reports from a table or search Produce reports from selected field from a table or search Insert a footer/header Print Database Search results Forms Reports To fit on one page Specified fields Golspie high School Administration & IT Higher Page 14 Course Guidelines 2 Use complex functions of a database to provide solutions asked for in a task by.

9 Creating relationships between tables and working with relational databases use primary and foreign keys create and edit relationships between tables (one to many and one to one) add, delete and modify data Resources Date Completed Comments/Targets RS Pack 14/230 An Introduction to Relationships in MS Access 2010 Manipulating the database finding information by searching/querying the database using advanced functions on a minimum of 2 fields from multiple tables using: search using mathematical operators <, <=, >, >= wild cards (partial text) ie asterisk and question mark use of AND, OR, NULL or NOT to join query criteria together to create more complex conditions aggregate functions, eg sum, count, average, maximum and minimum calculated fields creating, formatting and labelling advanced sort Resources Date Completed Comments/Targets RS Pack 12/208 MS ACCESS 2010: Filtering & Select Queries RS Pack 14/228 Different Types of Queries in MS Access RS Pack 14/233 Plenty Practice in Using and Querying Relational Databases in MS Access 2010 RS Pack 14/235 Aggregate Functions and Calculated Fields in MS Access 2010 RS Pack 14/236 Querying MS Access 2010 Relational Databases Working with forms.

10 Create form enhance appearance (move, align, delete and edit components) modify properties headers and footers Golspie high School Administration & IT Higher Page 15 Course Guidelines Creating a report Creating a report, to a professional standard, to present finindings: using calculations when appropriate grouping data order/sort data summary calculations editing field names inserting report/page headers/footers Resources Date Completed Comments/Targets RS Pack 14/229 Forms and Reports in MS Access 2010 RS Pack 14/231 Plenty Practice in Database Forms and Reports in MS Access 2010 Exporting data: export data to spreadsheet, word processing and presentation applications Resources Date Completed Comments/Targets RS Pack 14-243 Using your Skills Importing across MS Applications Printing: extract/extracts from database queries, forms and reports Golspie high School Administration & IT Higher Page 16 Course Guidelines Word Processing Revision Summary Booklet: Resources Date Completed Comments/Targets RS Pack 12/210 Making the Most of MS Word 2010 3 Use complex functions of word processing to provide solutions asked for in a task by: Editing large business documents by using advanced functions Amending and creating a range of business documents by using advanced functions and ensuring that the house style is complied with.


Related search queries