COMPUTER LITERACY PROJECTBASED LEARNING Team members Liu Chun
COMPUTER LITERACY PROJECT-BASED LEARNING Team members ʘ Liu Chun (31) Law Sze Yuen (24) Lee Suet Sum (26)
Content page Objective------------------------------------p. 3 Analysis-------------------------------------p. 4 Example of using database-------------------------p. 6 Step 1: Design the structure------------------------p. 7 Step 2: Design the input form-----------------------p. 8 Step 3: Design report form-------------------------p. 9 Step 4: Design queries----------------p. 10 -12 Notice-------------------------------------p. 13 Check list-----------------------------------p. 14 Conclusion----------------------------------p. 15 Questionnaire--------------------------------p. 16 Result of survey----------------------------- p. 17 -20 Question Time--------------------------------p. 21
Find out our friend’s personal data More easy!!!
In this project, we are going to use these software. Microsoft Word Microsoft Power point Microsoft Access
Let us introduce how to use database
Example Fields we used: NAME, SEX, TELEPHONE NUMBER AND REGION Queries we used: Display all the fields with the girl classmates who live in New Territories Display all the fields with the girl classmates who birth on 1998/12/30 Display all the fields with the boy Handsome Guy’s email address
Step 1 : Design the structure Design View ->Type in the fields ->choose the type of information
Step 2 : Design the input form import
Step 3 : Report form Easy way Further Design So beautiful !!!!
Step 4: Design the queries • The girl classmates who live in New Territories We put down =”F” on the criteria of the column Sex and ="New Territories" on the column Region. `
Step 4: Design the queries • The girl classmates who birth on 1998/12/30 The criteria we put down =”F” on Sex and = #30/12/1998# on Birthday.
Step 4: Design the queries • The boy Handsome Guy’s email address. We put down the “=Handsome Guy” on criteria to find out his e-mail address.
Notice Symbol Description Example ““ Text Like “ A “ # Number Like #12/3/2012# = Exact match Like = “a”
Check List 1. Find the Female Pass 2. Type ”abc” in field of “birthday” Fail 3. Find the people who live in Kowloon Pass
Conclusion Database… *Help us to find out the data we want faster and easily. *Many function: Queries, Report form etc. *Many limitation: ->We can’t change the fields name in Datasheet View, we can only do it in Design View. ->In criteria of query design, “#” should be type before a number.
OUR QUESTIONNAIRE
Result What do you think about our database? Clear Tidy Most of our classmates thought our database is tidy and clear. TIDY : 50% CLEAR : 50%
What do you think about our report? easy to use good tidy conveient to use Most of our classmates said our report is easy and convenient to use, tidy and good. EASY TO USE : 33% GOOD : 33% TIDY: 17% CONVEIENT TO USE : 17%
Suggestion More data More simpler Add primary key More detail They have some suggestions for us, which are can be more fields and data, more primary key, more detail and simple. MORE DATA : 50% MORE SIMPLER : 17% ADD PRIMARY KEY : 17% MORE DETAIL : 17%
Marks 5 4 3 2 1 The average mark of our database is 4. 2, while the highest mark is 5. 5 : 17% 4 : 50%
Question Time!
THE END
- Slides: 22