NicoleKalcic Week 8 - Revision history

Nicolekalcic: spelling error

2017-11-02T22:22:20Z

spelling error

Nicolekalcic: updated journal

2017-10-24T08:02:04Z

updated journal

Nicolekalcic: added journal

2017-10-24T07:46:32Z

added journal

Nicolekalcic: spelling

2017-10-24T01:51:39Z

spelling

Nicolekalcic: corrected time points

2017-10-24T01:51:19Z

corrected time points

Nicolekalcic: added a note under acknowledgments

2017-10-24T01:50:34Z

added a note under acknowledgments

Nicolekalcic: Added new sections

2017-10-24T01:46:57Z

Added new sections

Nicolekalcic: updated file

2017-10-24T01:38:06Z

updated file

Nicolekalcic at 23:03, 19 October 2017

2017-10-19T23:03:26Z

Nicolekalcic: added title

2017-10-17T22:54:52Z

added title

New page

'''Journal Week 8''' - [[User:Nicolekalcic|Nicole Kalcic]]

----

@@ Line 14: / Line 14: @@
 Time points: t15, t30, and t60 have 4 and t90, t120 have 3
 ===Electronic Journal===
 As noted above: we are comparing the dHAP4 data within the Yeast Gene Excel spreadsheet.

← Older revision		Revision as of 08:02, 24 October 2017
Line 19:		Line 19:

	''In progress because I made a mistake on excel.''		''In progress because I made a mistake on excel.''
		+
		+	As noted above: we are comparing the dHAP4 data within the Yeast Gene Excel spreadsheet.
		+
		+	#Create a new worksheet, naming it "dHAP4_ANOVA".
		+	#Copy the first three columns containing the "MasterIndex", "ID", and "Standard Name" from the "Master_Sheet" worksheet for your strain and paste it into your new worksheet. Copy the columns containing the data for your strain and paste it into your new worksheet.
		+	#At the top of the first column to the right of your data, create five column headers of the form dHAP4_AvgLogFC_(TIME) where (TIME) is replaced with 15, 30, 60, 90, and then 120.
		+	#In the cell below the dHAP4_AvgLogFC_t15 header, type =AVERAGE(D2:G2). Assuming steps 1-3 were done correctly, D2-G2 will indicate the data in row 2 associated with dHAP4 and t15. Complete this step by pressing the closing parenthesis (shift 0) the the "enter" key.
		+	#This cell now contains the average of the log fold change data from the first gene at t=15 minutes.
		+	#Click on this cell and position your cursor at the bottom right corner. You should see your cursor change to a thin black plus sign (not a chubby white one). When it does, double click, and the formula will magically be copied to the entire column of 6188 other genes.
		+	#Repeat steps (4) through (8) with the t30, t60, t90, and the t120 data. Use step (7) on each corner. The other rows will look as follows:
		+	#*For t30: =AVERAGE(H2:K2)
		+	#*For t60: =AVERAGE(L2:O2)
		+	#*For t90: =AVERAGE(P2:R2)
		+	#*For t120: =AVERAGE(S2:U2)
		+	#Now in the first empty column to the right of the dHAP4_AvgLogFC_t120 calculation, create the column header dHAP4_ss_HO.
		+	#In the first cell below this header, type =SUMSQ(D2:U2). This will highlight all the LogFC data in row 2 for dHAP4 (avoiding the AvgLogFC rows). To complete this step, press the closing parenthesis (shift 0) and press the "enter" key.
		+	#In the next empty column to the right of dHAP4_ss_HO, create the column headers dHAP4_ss_(TIME) as in (3).
		+	#The headers will look as follows:
		+	#*dHAP4_ss_t15
		+	#*dHAP4_ss_t30
		+	#*dHAP4_ss_t60
		+	#*dHAP4_ss_t90
		+	#*dHAP4_ss_t120
		+	#To note: there are 3 data points for t90 and t120 (the rest have 4). Be careful when selecting these cells. The total number of data points is 18.
		+	#In the first cell below the header dHAP4_ss_t15, type =SUMSQ(D2:G2)-COUNTA(D2:G2)*(V2)^2 and hit enter.
		+	#*The COUNTA function counts the number of cells in the specified range that have data in them (i.e., does not count cells with missing values).
		+	#*The phrase <D2:G2> is the data range associated with t15.
		+	#*The phrase <V2> is the AvgLogFC for t15, and the "^2" squares that value.
		+	#*Upon completion of this single computation, use the Step (7) trick to copy the formula throughout the column.
		+	#Repeat this computation for the t30 through t120 data points. Again, be sure to get the data for each time point, type the right number of data points, and get the average from the appropriate cell for each time point, and copy the formula to the whole column for each computation.
		+	#The other initial rows will look as follows, then you can complete step (7) on each corner
		+	#For t30: =SUMSQ(H2:K2)-COUNTA(H2:K2)(W2)^2
		+	#For t60: =SUMSQ(L2:O2)-COUNTA(L2:O2)(X2)^2
		+	#For t90: =SUMSQ(P2:R2)-COUNTA(P2:R2)(Y2)^2
		+	#For t120: =SUMSQ(S2:U2)-COUNTA(S2:U2)(Z2)^2
		+	#*In the first column to the right of dHAP4_ss_t120, create the column header dHAP4_SS_full.
		+	#In the first row below this header, type =SUM(AB2:AF2) and hit enter.
		+
		+
		+	===Summary Paragraph===

	=== Acknowledgements ===		=== Acknowledgements ===

@@ Line 6: / Line 6: @@
 Strain Comparison: dHAP4
-Individual dataset:
+Individual dataset: [[File:BIOL367_Fall2017_Dahlquist-microarray-data-master_20171017NK.zip.xlsx]]
 Powerpoint Slide:
@@ Line 15: / Line 15: @@
 [[File:BIOL367_Fall2017_Dahlquist-microarray-data-master_20171017NK.zip.xlsx]]
 === Acknowledgements ===

@@ Line 12: / Line 12: @@
 File name:
-Timepoints: t15, t30, and t60 have 4 and t90, t120 have 3
+Time points: t15, t30, and t60 have 4 and t90, t120 have 3
 [[File:BIOL367_Fall2017_Dahlquist-microarray-data-master_20171017NK.zip.xlsx]]

@@ Line 12: / Line 12: @@
 File name:
-Number of replicates/Timepoints: t15, t30. t60 have 4 and t90, t120 have 3
+Timepoints: t15, t30, and t60 have 4 and t90, t120 have 3
 [[File:BIOL367_Fall2017_Dahlquist-microarray-data-master_20171017NK.zip.xlsx]]

@@ Line 3: / Line 3: @@
 ----
 [[File:BIOL367_Fall2017_Dahlquist-microarray-data-master_20171017NK.zip.xlsx]]
 === Acknowledgements ===
+I worked with my homework partner [[User:Bhamilton18 | Blair Hamilton]] in class. We met face to face and then continued our communication through texting. She finished the assignment before me, and I used the set of her page [[Bhamilton18 Week 8]] to guide an organization for mine.
 While I worked with the people noted above, this individual journal entry was completed by me and not copied from another source.
@@ Line 14: / Line 23: @@
 === References ===
 * LMU BioDB 2017. (2017). Week 8. Retrieved October 23, 2017, from https://xmlpipedb.cs.lmu.edu/biodb/fall2017/index.php/Week_8
 [[Category: Journal Entry]]

← Older revision		Revision as of 01:46, 24 October 2017
Line 4:		Line 4:

	[[File:BIOL367_Fall2017_Dahlquist-microarray-data-master_20171017NK.zip.xlsx]]		[[File:BIOL367_Fall2017_Dahlquist-microarray-data-master_20171017NK.zip.xlsx]]
		+
		+	=== Acknowledgements ===
		+
		+	I worked with my homework partner [[User:Bhamilton18 \| Blair Hamilton]] in class. We met face to face and then continued our communication through texting.
		+
		+	While I worked with the people noted above, this individual journal entry was completed by me and not copied from another source.
		+
		+	[[User:Nicolekalcic\|Nicolekalcic]] ([[User talk:Nicolekalcic\|talk]]) 18:46, 23 October 2017 (PDT)
		+
		+	=== References ===
		+
		+	* LMU BioDB 2017. (2017). Week 8. Retrieved October 23, 2017, from https://xmlpipedb.cs.lmu.edu/biodb/fall2017/index.php/Week_8
		+
		+
		+	[[Category: Journal Entry]]

← Older revision		Revision as of 01:38, 24 October 2017
Line 3:		Line 3:
	----		----

−	[File:BIOL367_Fall2017_Dahlquist-microarray-data-master_20171017NK.zip.xlsx]	+	[[File:BIOL367_Fall2017_Dahlquist-microarray-data-master_20171017NK.zip.xlsx]]

← Older revision		Revision as of 23:03, 19 October 2017
Line 2:		Line 2:

	----		----
		+
		+	[File:BIOL367_Fall2017_Dahlquist-microarray-data-master_20171017NK.zip.xlsx]