• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  • Level: GCSE
  • Subject: ICT
  • Word count: 2706

In this project I have to create an electronic mark book.

Extracts from this document...

Introduction

Time Sheet Week 1 - Plan time sheet and start planning the excel document e.g. what information and what order I should put on the document. Week 2 - Start to create the excel document and put in primary information also look more closely at the formulas deciding what formulae to use. I will make sure that I take screen shot of everything I do while making the excel document to use in my write up Week 3 - Finish creating the excel document and start looking at what graphs to use and what graphs go well with what data. Week 4 - Start creating the write up for the excel document. Week5 - Finish writing the write up and check for mistakes. Week6- Double check for mistakes and hand project in. In this project I have to create an electronic mark book. It will include information on the following in this order Surname, First name, Age, Attendance, 1st Test score, 2nd test score, 3rd Test score, Average Score, Percentage Score, Pass or fail and Grade It will also include 4 different types of formulae. They will be worked out using the Primary data given. Average - I will have 3 sets of raw scores and will use this to find out the average score of each pupil. Lookup Table - I will use this to find what grade each pupil has by comparing Grades to the Average score of the Pupil. Percentage - I'm going to combine my maths knowledge, to create a formula to work out the percentage of a Pupils Total Score. ...read more.

Middle

That's what I had to do for this formula I used the same principle to work out the percentage for it but because I want a percentage for the total amount of test results I had to add all the scores together. This is the formula I came up with. *Note- this is the formula I used in the markbook. A common mistake with writing formulas by hand is that people forget to put an equals (=) sign in. If this is not put in at the beginning Excel will not read it as a formula. If Formula An 'If' formula will look at data and give a separate answer whether it's true or false for example, I want to find out if someone has passed or failed a test, I would use this to look at the data of a pupils total test score and write Pass or Fail depending on how high the score was. This is the formula I used in the Mark book I started the formula off with an Equals Sign '=' then put the name of the formula 'IF' I then opened up some brackets '(' I then put in a logical test which is 'J4>80'. Now all I have to do is put in my Variables (Pass/Fail) I have to open Speech marks at the beginning and at the end of each variable and a comma in between the two. Like this "Pass","Fail" All I have to do now is close the brackets. ...read more.

Conclusion

Well after deciding what graph you would like to do, you begin to write in the data. You must do it with the two axis titles at the top and the information underneath, as shown below. In this project, as well as a scatter graph, I have also made a column chart. The chart is based on attendance It will open another window, which contains a list of graphs and charts as shown on the left, all you have to do is choose one- If you want to preview what the graph will look like before you make it, you would press the control which says 'Press and Hold to View Sample', it will then come up with a picture of the graph about be created. Then all you have to do is press finish. Evaluation In this project I have created an electronic mark book for a teacher. It includes 5 formulae they are: Average Rounding Percent If Lookup What I could have done better In this project I think I should have considered the layout of the excel document more carefully because when it came to making the graphs the information needed was inaccessible to highlight without highlighting other data as well. I have also learnt that I should save work every 15 minutes because at one point I had finished all my work but I hadn't saved it, so now I've started saving backups and saving my work every 15 minutes. I have learnt that most graphs do not work with most data and that I should have considered more carefully about what graphs I used in this project. Page 2 - Professor Dumbledors, mark book, write up ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. GCSE Excel Project ICT

    Table Relationships can be created to link data value together, once linked this information can be access from any of the tables. Queries enable to user to search for information or a data value with greater ease, however the initial file sizes can be large, when more information and data is inserted it makes it easier to use the information.

  2. GCSE Calculator Project

    In order to stop the silver surfers making accidental changes to the calculator we can stop them from looking at the calculator in design view. In access it's possible to allow privileges to different user groups. The groups can be "Users" and "Admin".

  1. This project is designed to help non-computerized library to easily keep track of their ...

    TEXT: used to input alphabetical as well as numerical data. For example name. MEMO: used to input alphabetical as well as numerical data as much desired there is no limitation in the field size. For example address or Members request.

  2. a level ict project

    Microsoft Access. Although, he has already identified this setback and has planned to take a short course on generic software applications and do some background research, (books), to expand his familiarity. As for his employees, they have next to no computer literacy, which is one of the reasons why they are doing

  1. Main aims and functions of Buckingham Bingo.

    When this process is completed the money is then passed on to the cash office. Reception * This is a very small department of the bingo. Its main function is to allow members into the bingo and keeps updating the member's database system.

  2. Database design for a farmers herd book.

    * Relationships are verbs that describe how entities relate to each other; for example: 'Customers Buy Products,' 'Employees File Time Sheets,' 'Salespeople Place Orders.' A sentence in this entity-relationship-entity construct is called a "relationship entity pair," which is a fashionable mechanism for representing relationships.

  1. Performance Charts - The aim of this task is to produce a simple chart ...

    This will therefore result in the formulae changing accordingly. * When this has been done, the number of points will be shown in the cells, not the formulae. To display the formulae, click on Tools>Options, then tick the box next to 'formula'.

  2. Database project

    * He wants to be able to enter new planes to the database and be able to edit them * He wants to be able to enter new rentals to the database and edit them. Output He would like, at any time, to be able to quickly and easily view and print out 1.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work