Test 3 Dates

3A   Cycle 7 Day 5
3C   Cycle 7 Day 6
3D   Cycle 7 Day 7

Database Notes (Part 2)

Field format

This property is used to personalize the way in which data is presented on the screen or in a report.
This can be established in all types of data except the OLE object and Autonumerical.

For Numeric and Currency fields the options are:

General number: presents numbers in the same way as they have been introduced.

Currency: presents the values introduced with a thousandth separator and the assigned monetary symbol in Windows e.g. $

Euro: uses the currency format, with the euro symbol.

Fixed: presents the values without the thousandth separator.

Standard: presents the values with the thousandth separator.

Percent: multiplies the value by 100 and adds the percent sign (%).

Scientific: presents the number with scientific notation.

Date/Time fields have the following formats:

General date: if the value is only a date no time is shown; if the value is only a time no date is
shown. This value is a combination of the Short date and Long time values. E.g. '3/4/93', '05:34:00 PM' and '3/4/93 05:34:00 PM'.

Long date: the date is seen together with the day of the week and the month in full. E.g. Monday, August 21, 2000.

Medium date: presents the month with the first 3 letters. E.g. 21-Aug-2000.

Short date: the date is presented with 2 digits for the day and month. E.g. 01/08/00 or 01/08/2000. The Short date format assumes that dates between 1/1/00 and the 31/12/29 are dates between the years 2000 and 2029, and that the dates between 1/1/30 and the 31/12/99 are for the years 1930 to 1999.

Long time: presents the time in normal format. E.g. 05:35:20 PM

Medium time: presents the time in PM or AM format. E.g 5:35 PM

Short time: presents the time without seconds neither PM. E.g 17:35.

Yes/No fields have predefined Yes/No, True/False, and On/Off formats available.
Yes, True and ON are the equivalents of yes, as are No, False, Off of no.

Note: The default control for Yes/No data is the verification box as we seen in Datasheet the data of this type appears in a verification box and does not affect the format property. If we choose to see the effect we need to change the default control in the Lookup tab in the field properties, in the Display control property select Text box as we will show you next.

The Text and Memo fields do not have predefined formats available, for the Text fields we will need to create your own custom formats.

Class 3D - Rubric for Database Model

Appropriate labelling of model       5 points
Labelling of objects displayed        5 points
Accurate interpretation/representation of database     5 points
Creativity in production of model    5 points
Submission on time - 11/7/14         5 points

TOTAL: 25 points
Graded in the category of 'Other'

Spreadsheet Assignment -ALL 3rd Form Classes

Complete the following tasks using MS Excel.  
Submit to marcelliyoung@yahoo.com no later than Monday, November 3, 2014 before 7pm.
Assessment being graded in the category of 'Other'.  
Total points: 30

Recreate the following spreadsheet starting at cell A1.  Font Face: Times New Roman. Font Size: 12
Click on the image to enlarge.

Instructions:

In an appropriate area of your spreadsheet, insert the following:

1. Insert two blank rows and in Cell A1, enter your name and class,  In cell C1, use a function to include the actual date.  [2pts] 
2. Insert a heading labelled as CALORIE COUNTERS.  Bold, center across selection, and change font size to 14.  [3pts]
3. In cell A26, insert the label Number of Items.  In cell B26, using a function, state the number of food items displayed.  [2pts]
4. In cell A27, insert the label Highest Calorie.  In cell B27, using a function, state the highest calories from the range. [2pts]
5. In cell A28, insert the label Lowest Fat.  In cell B28, using a function, state the lowest fat from the range.  [2pts]
6. In cell A29, insert the label Number of Fast Foods.  In cell B29, use a function to state the number of fast food items based on column A contents. [2pts]
7. In column H, insert the column heading Status.  Determine whether the item is Good or Bad based on the following.  If the calories is increased by 5%, and is still less than 180, then the item is good. [4pts]
8. In column I, insert the column heading Recommended.  Using vlookup, determine the status of each item.  [5pts]
9. Create a criterion and extract all Category that are Fast Foods.  Place the results in an appropriate area of the spreadsheet.  [4pts]
10. Create a criterion and extract all Category that are Baked Goods with Calories more than 200.  Place the results in an appropriate area of the spreadsheet.  [4pts]

Excel Board Game Grading Rubric

Assignment due date changed.  New due date:  November 5, 2014
Submit by email to marcelliyoung@yahoo.com
Ensure that the names of all group members are included in the email cover letter.

Grading Rubric:

Use of Excel functions                   5 points
Proper construct of board game    5 points
User friendliness of game              5 points (if an instruction sheet is needed, prepare in Word)
Creativity                                        5 points
Overall game concept                    5 points
Submission on time                        5 points

Game is to function in Excel.  If an instruction sheet is prepared, submit both documents as attachments to your email.
Game graded in category of 'Other'
Total points: 30 points


 

Database Notes Part 1

A database is a collection of related data about a particular subject stored together. There are two forms of database: Manual Database and Computerized Database. For our purpose, we focus on Computerized Database, and particularly on relational database being Microsoft Access.
There are two types of database:
1. Flat File - one dimensional database containing/storing simple lists. An example is an electronic address book.
2. Relational Database - RDBMS. An example is Microsoft Access; relational meaning that more than one table may be used for storing data. The tables are linked by relationships in a manner to facilitate easy access of information.

Hierarchy of Database Production

A table is a collection of related data about a specific subject.
A field is column in a table that contains a category of information. Insertion of fields is done in design view.
Formatting of data types is done while creating fields. There are four common data types used: text, number, currency and date/time.
A record is a group of related fields pertaining to one subject; it is a row of data in a table. Inputting of records is done in data sheet view.
Microsoft Access uses objects. An object is a sub program that manages one aspect of the database. There are four objects used in Access: Form, Table, Query and Report.
Forms are used for input of information.
Tables are used for storage.
Queries are used for processing of information.
Reports are used for output.
While Forms are the first object listed, for our purposes, we will focus on creating Tables in design view. We create them in this view in order to customize them to our needs.
STORAGE - After creating your database, tables are created to store information. Within tables, fields are formatted and records are inputted. Field properties are formatted from the general tab on the lower left hand of your screen when in design view.
Field Properties:

• Field size - the default field size for a text field is 50 and cannot exceed 255.
• Format - changes the way data is displayed; not stored to create custom formats.
• Input Mask - used to insert special characters in a field.
• Validation Rule - ensures that a number being entered is withing the specified range. Validation text is a message that appears when the validation rule is violated.
• Required - Yes or No
• Primary Key - a field that uniquely identifies each record in a table; speeds up operations such as data retrieval, sorting and the running of queries. Primary key allows users to establish relationships between tables so that they can be joined.

After creating and formatting fields in design view, switch to data sheet view by clicking on the icon that resembles a table on the tool bar. At this point, you will be asked to save your table and to select a primary key. Records can now be entered.
Many tables can be created and stored in one database; sometimes the data is stored in more than one table and therefore, the tables can be linked by forming a relationship.
We will stop at this point and continue in Part Two.

Test 2 Notes

Spreadsheet (Excel)

Test 2 will focus on:

• Basic functions in Excel
• If statement with calculations
• Vlookup
• Advanced Filtering
• Octal conversion to binary and to decimal (Two questions)

Syntax

If statement
if(logical_test,value_if_true,value_if_false)
            (1)            (2)                (3)

1.  The logical test is what tests the condition.  For example average > 70
2.  The value_if_true will be displayed if the condition is met
3.  The value_if_false will be displayed if the condition is not met

Vlookup
vlookup(lookup_value,table_array,col_index_num,range_lookup)
                     (1)               (2)                  (3)                  (4)

1. The lookup value is the cell address that has the value that we will look up in the table array to compare and find the answer,
2. The table array is where on the spreadsheet has the columns with the answer and comparison data.
3. The column index number is the number of the column that has the answer we are searching for.
4. The range lookup is either true or false.  False is what we are looking up for is exact and True if it is an approximate.

Notes:

Filtering is extracting data based on a condition.
The condition is known as a criterion (criteria is the plural of criterion)
A criterion with one condition takes up two cells
A criteria with two condition takes up four cells

Example:
                   Name
                   ="John"
This extracts all people with the name John

                    Age
                     >17
This extracts all people who are older than 17 years

                     Items
                      B*
This extracts all Items with the name starting with the letter B

PRACTICE ACTIVITY

1. Using the spreadsheet below, use vlookup to identify each page name.
2. Perform advanced filtering to extract all Pages that had more than 20,000 views and Page Name has the letter N in it.
3. Calculate if the Page views is more than 200,000 then list it as Active; otherwise list as inactive.

You can click on the spreadsheet to view as a larger image

IF Statements with Calculations:

1.  Cell A29 has the sum of three numbers.  If the sum is more than 25, then calculate and output the square of the sum; otherwise calculate and output the cube of the sum.

2.  Cell B3 has a value.  If the value is less than 100, then output that the value is small; otherwise output that the value is larger.

3.  Cell G78 has a value.  If the value exceeds 50, add 10% to the value; otherwise, add 3% to the value.  (Remember that the % sign is not to be used in the calculation; it should be represented in decimal format)

4.  If the sum of B3 to G3 is more than 100, then calculate the product of cell B3; otherwise, calculate the average of the range.

GOOD LUCK ON YOUR TEST

A little Halloween fun...

click on the link below for a Halloween scavenger hunt
http://garfield.com/game/scary-scavenger-hunt

Test 2 Notification

Please note that Test 2 is scheduled as follows:

3A -Day 1 - Thursday, October 16, 2014
3C -Day 7 - Wednesday, October 15, 2014
3D -Day 6 -Tuesday, October 14, 2014

Test 2 -Theory Test on Excel

Chemistry Students - check this out

Hey Chemistry Students... try this challenge.  Make sure to click play to test your knowledge on the elements.  Don't worry... this is not being graded...just for educational fun!

http://www.brainrush.com/lesson/chemical-families

What does it take to wipe out your hard drive?

Check out a pretty cool video about the effects of magnets on your hard drive.

Post a comment here on the blog (after watching the video).  Your comment should focus on something you learnt from the video.

Comment will be graded as homework out of 10 points.

Deadline:  October 12, 2014

To see the video, click on the link below:
http://zapt.io/tr255ata