Ban Dumb People from Using the Computer

Tweet

I was working (as a volunteer) with my Wife and I developed an Excel Spread sheet to help her tract student attendance and parent attendance, for the year, for a special program she is running. I set up the program to count (counta) the students and give me the total of parents attending (SUM). The report will give her monthly, semester and yearly totals. We are dealing with a spread sheet that is over 500 columns wide and about 150 rows long. I worked with the people who were going to input the data (her boss did not want to have me input the date he wanted others to do it) and told them to mark the students with a x when they were present and the parents with a number. (If parents attend a student also attends) I explained that this was important because we were tracking both student and parent data. I told them that if they had to enter new data then just put the student at the bottom of the list and I would change it later. The first thing that happened was a person entered the first and last name in the same column. Then about 3 months into the year one person wanted a list of students so he went and high lighted only the students names and sorted by last name. It took me several hours to re like the names and data. At the end of the year I went to check on them and found gaps in the data being entered. It was more convenient for the people entering the data to save it on their computer and not the network. When they saved the information they did a save as and put it on their computer and sometimes on the network. It has taken me and my wife several hours over several days to get this all compiled correctly. My son tells me , when I complain to him about this, Dad they should not let idiots near a computer until they have been trained. Too many people are using computers and think that you can ask the computer to do anything and it will get done. I am fast becoming of the opinion that some people should not be allowed on a computer.