• 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

# Related GCSE ICT Systems and Application essays

1. ## ICT Project 1A

Bill sings lead vocals in the band and Tom plays the guitar. The twins have many endorsment deals in Germany and are very well-known in their homeland. And on a separate page for Georg and Gustav... Georg Listing plays the bass guitar in the band and was born in Hamburg.

2. ## ICT PROJECT

When the marks are in numerical e.g.14 out of maximum mark 20, the percentage grade boundaries she used e.g. 85%+ is A*, 80%+ is A, 75%+ is B etc. There are 16 boys and 12 girls, which make overall of 28 students in her class.

1. ## GCSE Excel Project ICT

After data has been inserted into the spreadsheet function, mathematical functions can be created and with the results graphs or charts to display average data easily. In addition, there is a sub-operand called VLOOKUP, VLOOKUP stands for Vertical LOOKUP, which searches for a value in the first column of a

2. ## Computer project Alevels

Data type Validation Rule Validation Text DOCTOR ID Text Like "MCD###" Text you entered is invalid in the field DOCTOR_NO. The entry must be 6 characters long. The first letter must be the letter M, the second letter must be C, and the third letter must be D followed by 3 numbers.

1. ## Ict Unit 2b

* Static electricity attracts toner to the drum surface and a visible image is formed. * Toner on the drum is transferred to paper by positive charging. * After the image transfer process is completed, the paper is separated from the drum surface.

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.

1. ## Excel Project

Microsoft Access is very popular among non-programmers who can create visually pleasing and relatively advanced solutions on their own. It is also easy to place a database on a network and have multiple users share and update data without overwriting each other's work.

2. ## ICT PROJECT

The special features available with Excel (spreadsheet) are no longer an option such as, immediate calculation, from entry, graphs and charts, etc. 5. Most of the surnames and first names are the same it can be difficult to find phone details, however with this system you can have this information automatically loaded with the name entry.

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