Home Random Page


CATEGORIES:

BiologyChemistryConstructionCultureEcologyEconomyElectronicsFinanceGeographyHistoryInformaticsLawMathematicsMechanicsMedicineOtherPedagogyPhilosophyPhysicsPolicyPsychologySociologySportTourism






Task 4 Evaluation and Presentation

Formative work ¹1

Subject:Computer Science Grade: 11
Topic:Algorithms and programming.
Lesson theme:Classifications and categories of programming languages. Data types.One and two dimensional arrays.
Learning objectives: Project development: solve a real life problem by applying appropriate problem-solving techniques. Coding: use indentation and formatting to show clearly the control structures within the code. Application software: describe the purpose and impact of different types of generic application software.
Criteria: Critical thinking and research. Communication and reflection.
Task:Solving a Problem using Excel and Delphi. Overview You will be working in pairs to help a National Car Magazine Company analyse the sales of offices located in regions across Kazakhstan. Each Area has a specific target;
Area Sales Target
5,000
15,000
20,000

 

The sales for the 1st quarter are as follows;

Office Area Sales Target reached?
A 5,000  
B 20,001  
C 14,578  

 

The manager wants to be able to compare the data from the office sales to the sales target for each area and see if each office has met their sales target. You need to write a nested IF statement formula to solve this problem. If they have reached their target then the word “Yes” should be displayed. If an office has failed to reach their target then the word “No” should be displayed.

In this project you will be completing the tasks using both Excel and Delphi, and then you will compare both software applications and evaluate which software was most suitable in solving the above problem.

Task 1

· You will need to create a flowchart that will detail the processes/decisions that will need to be followed in order to display the correct data.

Task 2 Excel

1. Open an Excel Workbook and create the 2 models displayed above

2. You will need to create a nested IF formula to display the data needed by the manager

3. You must use both relative and absolute cell referencing

Task 3 Delphi

Createthe project inDelphi:

  • Create an appropriate interface for the project.
  • Write thecode.

Attention! Before compilinga filepre-saveit to the desktopin a separate folder.

Task 4 Evaluation and Presentation

1. In your pairs you will need to create a short 3 minute presentation that addresses the following points

a. Explain their flowchart

b. The advantages/disadvantages of using Excel for this task

c. The advantages/disadvantages of using Delphi for this task

d. The most suitable application for this task with justified read

 
Learning objectives Criteria Description Achieved Working towards Conclusion
Not completed Working towards
Project development: solve a real life problem by applying appropriate problem-solving techniques. Critical thinking and research. Students show a working knowledge of Excel by laying out both tables in correctly
Students have attempted a nested IF statement that satisfies the criteria.
Students can use Delphi in solving a problem
Coding: use indentation and formatting to show clearly the control structures within the code. Communication and reflection. Students have used the correct formatting to layout the program which clearly shows the control structures.
The students have created a program that demonstrates mostly correct code.
Students have created a well-designed interface that is easy for all users to understand.
Students use indentation and formatting to show clearly the control structures within the code
Application software: describe the purpose and impact of different types of generic application software. Communication and reflection. Students have created a written presentation which explains their work through each part of the project.
Students have compared both software packages and given their thoughts on which was most suitable to solve the problem.
The students have presented their project orally and answered any questions.
The students demonstrate a good command of both written and spoken English throughout the project.
               

Date: 2015-12-18; view: 827

<== previous page | next page ==>
Circle the correct letter A, B, C, or D. | Cultural Differences
doclecture.net - lectures - 2014-2024 year. Copyright infringement or personal data (0.006 sec.)