6.4. School management systems
A subsection of Information and Communication Technology, 0417, through 6. ICT applications
Listing 6 of 6 questions
A headteacher wants to store details of his students’ attendances in a spreadsheet. He has typed in the details of two students so far. Each student is identified by a student ID which consists of one letter followed by 6 digits. The number of possible attendances is recorded along with each student’s actual number of attendances. A Student name Maria Gonzales Clive Lloyd B Student ID L543789 M351209 C Possible attendances D Actual attendances E The headteacher wants to ensure the Student ID is accurately entered. Describe a method of verifying the input. He wants the spreadsheet to perform a calculation of the percentage attendance of Maria Gonzales in E3. Explain how he would use the spreadsheet to do this. 1 14 He now wants to add another 18 students to the spreadsheet. Explain how he could calculate the percentage attendance for each student by only using a computer mouse. Give two reasons, apart from cost, why computer models are often used instead of the real thing. 1. 2.
0417_s15_qp_11
THEORY
2015
Paper 1, Variant 1
View
A school is setting up a new computerised system to manage many aspects of the school administration. Describe how this system can be used to manage student registration and attendance. Describe the benefits of using this system. The data from the registration system is saved in the school administration database. The head teacher will need to check the attendance records for any student for any semester. She will type in the Student_ID and the Semester (Autumn, Spring or Summer). After she has done this the following data will appear on the same screen. Field name Student_name Days_present Number_of_lates Number_absences Parents_phone_number Tutor_group Design a suitable screen layout to display one record. It must have appropriate spacing for each field, navigation aids and a space to type in search data. Do not include examples of students. A student record from the database is shown below. Field name Example Data Student_ID Semester Spring Student_name Kannur Rahul Days_present Number_of_lates Number_absences Parents_phone_number Tutor_group 11ABC Name an appropriate validation check that could be used for each of the following fields, based on the data shown in the record. Field name Validation check Semester Number_of_lates Parents_phone_number
0417_w18_qp_12
THEORY
2018
Paper 1, Variant 2
View
Here is some text taken from the CIE website. Cambridge Primary Checkpoint is designed to help students learn by providing comprehensive feedback on their strengths and weaknesses in the key curriculum areas - English, mathematics and science. The tests are exclusively available to schools that offer Cambridge Primary and are generally taken at the end of the final year of the programme. They are marked by Cambridge and provide schools with an international benchmark for learner performance. Each learner receives a statement of achievement and a diagnostic feedback report, giving schools invaluable information and parents extra trust in the feedback they receive. We hold two Cambridge Primary Checkpoint test series each year, covering all major areas of learning in the Cambridge Primary curriculum frameworks for English, mathematics and science. Schools teaching Cambridge Primary English as a Second Language curriculum can enter learners for tests provided by our sister organisation, Cambridge English Language Assessment. Here is the same text after it has been reformatted. Cambridge Primary Checkpoint is designed to help students learn by providing comprehensive feedback on their strengths and weaknesses in the key curriculum areas - English, mathematics and science. The tests are exclusively available to schools that offer Cambridge Primary and are generally taken at the end of the final year of the programme. They are marked by Cambridge and provide schools with an international benchmark for learner performance. Each learner receives a statement of achievement and a diagnostic feedback report, giving schools invaluable information and parents extra trust in the feedback they receive. We hold two Cambridge Primary Checkpoint test series each year, covering all major areas of learning in the Cambridge Primary curriculum frameworks for English, mathematics and science. Schools teaching Cambridge Primary English as a Second Language curriculum can enter learners for tests provided by our sister organisation, Cambridge English Language Assessment. Describe the four formatting techniques which have been used. 1 17
0417_s16_qp_11
THEORY
2016
Paper 1, Variant 1
View
Questions Discovered
6