Mrs. Palmer's Info.Tech Site



CXC CSEC INFORMATION TECHNOLOGYSCHOOL BASED ASSESSMENT(General Proficiency)Paper 03 – School Based Assessment?PRACTICAL ASSIGNMENTSWORD-PROCESSINGSPREADSHEETDATABASE MANAGEMENTWEB PAGE DESIGNPROBLEM-SOLVING AND PROGRAM DESIGN&IMPLEMENTATION??Project DescriptionA new government high school is about to open its door in your area and the administration has hired you as an IT specialist to assist with the following task:Generate registration forms and invitations for teachers to attend a series of workshopsDesign and maintain a database of staff’s qualifications and salaries from which to generate reportsUse spreadsheets to analyze the present budget and make projections for the following school year.Submit a short analysis report, to the Ministry of Education, that includes:Report of teaching staff present and projected salariesChart on distribution of funding (expenditure)Summary table of present and project budgetThe high school; GARDEN CITY HIGH SCHOOL, is located at #586 George Price Blvd, Belmopan City.Assume everything is in place for the start of the new school year:Students have been registered (4 first forms)Teaching, administration and auxiliary staff have been hired (10 teachers, 2 Administrators and 4 auxiliary)Furniture and all infrastructure is in placeFunding has been received from government and fees collected from students. DATABASE MANAGEMENTDatabase Tables should be designed containing appropriate and relevant informationImportant to Note:Each teacher teaches ONE subjectAuxiliary Staff may include secretaries, janitors etc. All auxiliary staff member must have high school diplomas.There will be two members, who constitute the administration. Each member must have a Master’s Degree or Doctoral Degree in Education. Since this is a First Year Group, only the core subjects will be taught at this level. These include English, Math, Science, Information Technology, Spanish, Social Studies, Accounts, History, Biology and Business. Each subject must carry a code, which will be identified by the first three letters in the word (capitalized) followed by any two numbers, eg. English –ENG09A member of staff can either be full time or part time. This will be reflected in the schedule table as SID (English for example- FULLJD03 - hence Jane Doe is a full time English teacher. Members of Admin has to be full time. There should be at least two teachers for each qualificationEach qualification must have a code, which is identified as follows:QualificationSpecial AllowanceHigh School Diploma-HSCH--------$60-$90Associates Degree-ASSOC--------$100-$180Bachelor’s Degree-BACH--------$200-$290Master’s Degree-MAST--------$300-$370Doctorate Degree-DOCT--------$390-$450TABLE: STAFFThe staff table should hold the following information concerning staff:First Names, Last Name, addresses, qualifications, years of service, special allowance, number of teaching sessions per week and personal ID number(in the format persons initials and any two numbers eg Jane Doe-JD03).TABLE: SCHEDULEThis table will hold information regarding the schedules for teachers. This will include SID, subjectcode, personalID, number of sessions taughtTABLE: SUBJECTThe fields in this table must include subjectcode, course description, fees, and credit hoursQUERIES:Create queries to show:1. Show all staff members with Associate degrees and the subjects they teach. 2. Staff members who possesses a Masters or Doctoral Degree. Save this query as QRYQUALIFICATION3. Members of staff who teach 10 or more sessions for the week. Save this query as QRYGREATERTHANTWO4. All members of staff who have more than 5 years of service and are in possession of a Bachelor’s Degree or Master’s Degree will be entitled to a 5% increase in salary at the beginning of the following school year. Copy the Staff table and update the allowance field to reflect this change. Save this query as QUALIFINCREASE5. Members of staff personal Id, name, qualification, subcode and course description. Save as SubjectTaught6. All staff must pay 15% income tax on their allowance. Create a calculated fields to show both the amount of tax to be paid and the income after the tax has been paid. Save this query as EDITEDALLOWANCE. REPORTS1. Prepare a report with staff members and their total allowances in descending order. Enter an Appropriate title for the report. Save this report as ALLOWANCESSORTED.2. Prepare a report which will show each employee’s name, qualification, PID, address, number of subjects taught, allowance, number of sessions taught and years of experience. Group this report by qualifications in descending order by name. Display the minimum sessions taught and the total allowance for each qualification group. Save this report as QUALIFICATIONS. FORMS The schools board chairman is not familiar with MS Access and wants to be able to easily assess and enter information straight into tables without having to open each table to do so. Hence you are required to:Create attractive forms for EACH table created aboveAttach buttons the allow for easy movement through the recordsAllow for the database to be exited from the form. SPREADSHEET1. The staff table from the database section should serve as the initial data for the analysis of the present budget and as a basis for a projected budget. 2. Government has within the last month passed a new education reform that affects salaries for all its workers. For teachers, administration and other staff within the school system the salaries are on the basis of qualifications and years of service. Use the following lookup table to assign salaries to each member of staff. CodeQualificationSalaryHIGHHigh School750ASSOCAssociate Degree1100BACHBachelor's Degree2300MASTMaster's Degree3200DOCDoctorate Degree41003. In order to analyze the current budget and make projections, expenses must be calculated and categorized. Create a summary for this information for the pre(now) and post (projected) analysis. Add proper labels and all required formulas and functions. A big portion of the budget is spent on salaries. Calculate the total of the salaried for the year and add it as an expense category in the summary table. Salaries amount to 70% of the total overall budget. Use these figured to calculate the other expenses for the year as follows. Electricity (3.5%), Water (2%), Telephone (6.5%), Stationery (3%) , P.E. Program (6%), and Repairs (9%). Include the percentage values in the summary table. Government provide 75% of the overall budget for this year. For the remaining balance 27.5% will come from fees already collected at registration and 2.5% from fund raising. Add this information to the summary table. Save this workbook as Year 1. 4. An appropriate chart is to be generated showing the distribution of the overall budget by expense categories. Add appropriate labels and titles to the chart.5. In a new workbook, two of the teachers are currently completing a higher degree; update the qualifications of the first and third teacher in the list. Maintain the updated staff list in order by qualification and last name.6. For the following school year work under the assumption that all members of staff will remain. Update their years of service. Because of a new second form and more students, additional teaching staff will be needed. Add four additions teachers and their data to the staff list. 7. For the awards day activities in the coming year the board wants to award teachers for service of over 10 years. Use the advanced filter feature to display these names neatly. 8. Staff will be given salary increases based on their years of service. An employee of 5 or less will be given a one percent increase, employees who has been employed for 5-10 years will be given a 3% increase, employees employed for over 10 years will be given a 6.5% increase. Using an appropriate formula, display this information.9. Using a pivot table display the following information:The amount of staff members with each qualification.How much is paid out to each staff member grouped by qualificationThe amount of teachers who teach the same amount of sessions. 10. Calculate the total of salaries for the following year and update the summary table to reflect this value in the projected analysis. Percentage distributions and expenses categories will remain the same for the following school year except PE program (4.5%) and repairs (10.5%). Save this workbook as Year 2.11. A second chart shall compare and show the trends between the present and projected budget distribution according to expense categories. Proper labels, legends and titles are required. WORD PROCESSINGYou are required to create a:1. FLYER:Create a one page flyer inviting schools to the workshops. This flyer should be divided into no less than two columns. Information about the workshop including but not limited to the date, time and workshop topics should be on the flyer. 2. INVITATION LETTER:Create a letterhead containing any graphic (as a school logo), the school name, address, phone number and principal’s name.Invite teachers to a series of continuous professional development workshops to be held during the week in August in Kingston and Montego Bay.Include at the bottom of the letter a small table with the names of the workshops (five), dates, fees applicable and location. Eg. Measurement and Assessment in EducationIndicate in the letter that the registration forms must be filled and returned within two weeks in order for final arrangements to be made.Add the footer ‘Daring to soar, through education’ Use the appropriate word processing feature to send this letter to all members of staff. Ensure that you incorporate data from your database (to be used as your data source).3. REGISTRATION FORM:Create a fillable registration form using textboxes, drop down boxes, buttons etc to be filled and returned by teachers for registration purposes. Divide the form into sections as follows: Personal Information: name, gender, contact information, qualifications and other information you think may be necessary. Workshop Interest: List of Workshop Choices, Comments and Special Request if any. WEB PAGE DESIGNUsing the Web Page developer used in class create a web page to introduce Garden City High School to prospective teachers and parents. This page should be interactive and attractive to incoming parents and teachers. PROBLEM-SOLVING, PROGRAM IMPLEMENTATIONDevelop an algorithm (flow chart or pseudocode) to maintain the staff qualification and starting salaries for a ten of teachers. The algorithm should accept the name of the teacher, years of service and qualifications for ten teachers. The algorithm should determine their starting salary based on their qualification and the rate of increase of their salary which is double their years of service (e.g. for 3 years of service the rate of increase would be 6% therefore the rate of increase can range from 1%-112%) . The algorithm should display all the teachers entered in a list with a corresponding number, it should also provide a print out a teachers name, starting salary, rate of increase and new salary at the users requests when the corresponding number (1-10) is selected.Using data from your database, select all teachers with Bachelors and Masters Degrees to design and execute a trace table. The trace table should accept the name, quantification and years of service for the teacher and produce the starting salary, rate of increase and new salary for all teachers entered.Using the programming language Pascal write a program code to implement the algorithm in (1) above. ................
................

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

Google Online Preview   Download